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 3130: ap_payment_schedules_all aps,

3126: 1,
3127: aps.iby_hold_reason,
3128: aps.hold_flag
3129: from ap_invoices_all ai,
3130: ap_payment_schedules_all aps,
3131: ap_suppliers pv,
3132: ap_supplier_sites_all pvs
3133: where ai.invoice_id = p_invoice_id
3134: and ai.invoice_id = aps.invoice_id

Line 3170: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;

3166: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3167: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3168: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3169: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3170: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3171: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3172: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3173: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3174: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;

Line 3171: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;

3167: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3168: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3169: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3170: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3171: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3172: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3173: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3174: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;
3175: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;

Line 3172: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;

3168: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3169: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3170: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3171: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3172: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3173: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3174: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;
3175: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;
3176: l_DISCOUNT_DATE date;

Line 3182: l_iby_hold_reason ap_payment_schedules_all.iby_hold_reason%type;

3178: l_CREATION_DATE date;
3179: l_LAST_UPDATED_BY number;
3180: l_LAST_UPDATE_DATE date;
3181: l_OBJECT_VERSION_NUMBER number;
3182: l_iby_hold_reason ap_payment_schedules_all.iby_hold_reason%type;
3183: l_hold_flag ap_payment_schedules_all.hold_flag%type;
3184:
3185: l_return_status VARCHAR2(10);
3186: l_msg_count NUMBER;

Line 3183: l_hold_flag ap_payment_schedules_all.hold_flag%type;

3179: l_LAST_UPDATED_BY number;
3180: l_LAST_UPDATE_DATE date;
3181: l_OBJECT_VERSION_NUMBER number;
3182: l_iby_hold_reason ap_payment_schedules_all.iby_hold_reason%type;
3183: l_hold_flag ap_payment_schedules_all.hold_flag%type;
3184:
3185: l_return_status VARCHAR2(10);
3186: l_msg_count NUMBER;
3187: l_msg_data varchar2(2000);

Line 3369: Update Ap_Payment_Schedules_all

3365: END IF;
3366: END IF;
3367: END LOOP;
3368:
3369: Update Ap_Payment_Schedules_all
3370: Set hold_flag = 'Y',
3371: iby_hold_reason = l_iby_error_msg_str
3372: Where invoice_id = l_calling_app_doc_unique_ref1
3373: And payment_num = l_calling_app_doc_unique_ref2;

Line 3382: Update Ap_Payment_Schedules_All

3378:
3379: --if no row exists remove the hold flag and reason on the payment schedule if it
3380: --was previously on hold and there was a hold reason.
3381: IF l_hold_flag = 'Y' and l_iby_hold_reason IS NOT NULL THEN
3382: Update Ap_Payment_Schedules_All
3383: Set hold_flag = 'N',
3384: iby_hold_reason = Null
3385: Where invoice_id = l_calling_app_doc_unique_ref1
3386: And payment_num = l_calling_app_doc_unique_ref2;