APPS.AP_AC_TABLE_HANDLER_PKG dependencies on AP_CHECKS

Line 136: CURSOR C IS SELECT rowid FROM ap_checks

132: P_paycard_reference_id NUMBER DEFAULT NULL
133: )
134:
135: IS
136: CURSOR C IS SELECT rowid FROM ap_checks
137: WHERE check_id = p_Check_Id;
138: l_iban_number CE_BANK_ACCOUNTS.IBAN_NUMBER%TYPE; --IBY:SP
139: current_calling_sequence VARCHAR2(2000);
140: debug_info VARCHAR2(100);

Line 164: debug_info := 'Insert into ap_checks';

160: l_iban_number := NULL;
161: END;
162: END IF;
163:
164: debug_info := 'Insert into ap_checks';
165: INSERT INTO ap_checks_all(
166: amount,
167: ce_bank_acct_use_id,
168: bank_account_name,

Line 165: INSERT INTO ap_checks_all(

161: END;
162: END IF;
163:
164: debug_info := 'Insert into ap_checks';
165: INSERT INTO ap_checks_all(
166: amount,
167: ce_bank_acct_use_id,
168: bank_account_name,
169: check_date,

Line 587: debug_info := 'Update ap_checks';

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
589: SET
590: amount = p_Amount,
591: ce_bank_acct_use_id = p_Ce_Bank_Acct_Use_Id,

Line 588: UPDATE ap_checks

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
589: SET
590: amount = p_Amount,
591: ce_bank_acct_use_id = p_Ce_Bank_Acct_Use_Id,
592: bank_account_name = substr(p_Bank_Account_Name,1,80),

Line 751: debug_info := 'Delete from ap_checks';

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
754: RETURNING check_id
755: INTO l_check_id;

Line 752: DELETE FROM ap_checks

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
754: RETURNING check_id
755: INTO l_check_id;
756:

Line 797: debug_info := 'update ap_checks amounts';

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:
799: UPDATE ap_checks
800: SET amount = nvl(p_amount, amount),
801: base_amount = nvl(p_base_amount, base_amount)

Line 799: UPDATE ap_checks

795: P_calling_sequence;
796:
797: debug_info := 'update ap_checks amounts';
798:
799: UPDATE ap_checks
800: SET amount = nvl(p_amount, amount),
801: base_amount = nvl(p_base_amount, base_amount)
802: WHERE check_id = p_check_id;
803: