1: PACKAGE BODY AP_AC_TABLE_HANDLER_PKG as
2: /* $Header: apachthb.pls 120.12 2011/11/25 16:34:01 jnallam ship $ */
3:
4: ----------------------------------------------------------------------------
5: PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
142: BEGIN
143:
144: -- Update the calling sequence
145: --
146: current_calling_sequence := 'AP_AC_TABLE_HANDLER_PKG.INSERT_ROW<-' ||
147: p_calling_sequence;
148:
149: -- Bug 2633878
150: debug_info := 'Get the IBAN_NUMBER';
580:
581: BEGIN
582: -- Update the calling sequence
583: --
584: current_calling_sequence := 'AP_AC_TABLE_HANDLER_PKG.UPDATE_ROW<-' ||
585: p_calling_sequence;
586:
587: debug_info := 'Update ap_checks';
588: UPDATE ap_checks
745:
746: BEGIN
747: -- Update the calling sequence
748: --
749: current_calling_sequence := 'AP_AC_TABLE_HANDLER_PKG.DELETE_ROW<-' ||
750: p_calling_sequence;
751: debug_info := 'Delete from ap_checks';
752: DELETE FROM ap_checks
753: WHERE rowid = p_Rowid
790: Begin
791:
792: -- Update the calling sequence
793: --
794: current_calling_sequence := 'ap_ac_table_handler_pkg.update_amounts<-'||
795: P_calling_sequence;
796:
797: debug_info := 'update ap_checks amounts';
798:
820:
821: END Update_Amounts;
822:
823:
824: END AP_AC_TABLE_HANDLER_PKG;