Package Specification and body replacement with New Custom Packages

GET_DDL 

Here is the below details for your reference for taking backup of an existing package and replacement with the newly package provided by the development team.

connect as apps/<apps-passwd>

set pages 10000
set long 99999
set pagesize 0

For .pks(Package Specification)

spool <packagename>_<date>.sql

SELECT DBMS_METADATA.GET_DDL('PACKAGE','XBOL_PAY_LIQUIDA_CAJA_AHO_PK') from dual;

set pages 10000
set long 99999
set pagesize 0

For .pkb(Package Body)

spool <packagebody>_<date>.sql

SELECT DBMS_METADATA.GET_DDL('PACKAGE_BODY','XBOL_PAY_LIQUIDA_CAJA_AHO_PK') from dual;

OR

Use SQL Developer and Take the backup of pkb and pks

Note:Confirm both the spool files are present

$ ls -lrt

2.Replace the package with the attached files
(XBOL_PAY_LIQUIDA_CAJA_AHO_PK,XBOL_PAY_LIQUIDA_CAJA_AHO_PK)

Login to TEST1 on server1.domain.com as applmgr User

Download the attached files and place it on  server.

connect as apps/<apps-passwd>

set pages 10000
set long 99999
set pagesize 0

connect as apps/<apps-passwd>
SQL>@XBOL_PAY_LIQUIDA_CAJA_AHO_PK.pks

SQL>@XBOL_PAY_LIQUIDA_CAJA_AHO_PK.pkb

SQL> Show err

Make sure that it doesn't error out.