eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_INVOICES_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 2999: ap_payment_schedules_all aps,

2995: 1,
2996: aps.iby_hold_reason,
2997: aps.hold_flag
2998: from ap_invoices_all ai,
2999: ap_payment_schedules_all aps,
3000: ap_suppliers pv,
3001: ap_supplier_sites_all pvs
3002: where ai.invoice_id = p_invoice_id
3003: and ai.invoice_id = aps.invoice_id

Line 3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;

3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3043: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;

Line 3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;

3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3043: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;
3044: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;

Line 3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;

3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3043: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;
3044: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;
3045: l_DISCOUNT_DATE date;

Line 3051: l_iby_hold_reason ap_payment_schedules_all.iby_hold_reason%type;

3047: l_CREATION_DATE date;
3048: l_LAST_UPDATED_BY number;
3049: l_LAST_UPDATE_DATE date;
3050: l_OBJECT_VERSION_NUMBER number;
3051: l_iby_hold_reason ap_payment_schedules_all.iby_hold_reason%type;
3052: l_hold_flag ap_payment_schedules_all.hold_flag%type;
3053:
3054: l_return_status VARCHAR2(10);
3055: l_msg_count NUMBER;

Line 3052: l_hold_flag ap_payment_schedules_all.hold_flag%type;

3048: l_LAST_UPDATED_BY number;
3049: l_LAST_UPDATE_DATE date;
3050: l_OBJECT_VERSION_NUMBER number;
3051: l_iby_hold_reason ap_payment_schedules_all.iby_hold_reason%type;
3052: l_hold_flag ap_payment_schedules_all.hold_flag%type;
3053:
3054: l_return_status VARCHAR2(10);
3055: l_msg_count NUMBER;
3056: l_msg_data varchar2(2000);

Line 3238: Update Ap_Payment_Schedules_all

3234: END IF;
3235: END IF;
3236: END LOOP;
3237:
3238: Update Ap_Payment_Schedules_all
3239: Set hold_flag = 'Y',
3240: iby_hold_reason = l_iby_error_msg_str
3241: Where invoice_id = l_calling_app_doc_unique_ref1
3242: And payment_num = l_calling_app_doc_unique_ref2;

Line 3251: Update Ap_Payment_Schedules_All

3247:
3248: --if no row exists remove the hold flag and reason on the payment schedule if it
3249: --was previously on hold and there was a hold reason.
3250: IF l_hold_flag = 'Y' and l_iby_hold_reason IS NOT NULL THEN
3251: Update Ap_Payment_Schedules_All
3252: Set hold_flag = 'N',
3253: iby_hold_reason = Null
3254: Where invoice_id = l_calling_app_doc_unique_ref1
3255: And payment_num = l_calling_app_doc_unique_ref2;