13589019 R12.AR.B ARP_EXT_BANK_PKG invalid: PLS-00323: subprogram or cursor 'INSERT_ACCT_INSTR_ASSI
Naveen says:Applied 13589019:R12.AR.B and now have invalids.
SQL> alter package ARP_EXT_BANK_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> sho errors
Errors for PACKAGE BODY ARP_EXT_BANK_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
57/13 PLS-00323: subprogram or cursor 'INSERT_ACCT_INSTR_ASSIGNMENT'
is declared in a package specification and must be defined in
the package body
736/7 PL/SQL: Statement ignored
736/7 PLS-00306: wrong number or types of arguments in call to
'INSERT_ACCT_INSTR_ASSIGNMENT'
QL> select text from user_source where name='ARP_EXT_BANK_PKG' and line=2;
TEXT
--------------------------------------------------------------------------------
/* $Header: AREXTBAS.pls 120.5.12010000.5 2012/01/17 06:13:29 kknekkal ship $ */