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_INVOICES_ALL

Line 721: FROM ap_invoices_all

717: RELATIONSHIP_ID,
718: /* Bug 7831073 */
719: original_invoice_amount,
720: rtrim(dispute_reason) dispute_reason
721: FROM ap_invoices_all
722: WHERE rowid = X_Rowid
723: FOR UPDATE of Invoice_Id NOWAIT;
724:
725: Recinfo C%ROWTYPE;

Line 1386: FROM ap_invoices_all

1382: RELATIONSHIP_ID,
1383: /* Bug 7831073 */
1384: original_invoice_amount,
1385: dispute_reason
1386: FROM ap_invoices_all
1387: WHERE invoice_id = X_Invoice_id
1388: FOR UPDATE of Invoice_Id NOWAIT;
1389:
1390: Recinfo C%ROWTYPE;

Line 2962: from ap_invoices_all

2958: If l_reapprove>0 then return('NEEDS WFREAPPROVAL'); end if; /* Bug 11655111 */
2959:
2960: select wfapproval_status
2961: into header_approval_status
2962: from ap_invoices_all
2963: where invoice_id=p_invoice_id
2964: and org_id=p_org_id;
2965:
2966: IF (l_approved > 0 and header_approval_status = 'NOT REQUIRED') THEN

Line 3129: from ap_invoices_all ai,

3125: sysdate,
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

Line 3147: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;

3143: l_DOCUMENT_PAYABLE_ID number;
3144: l_CALLING_APP_ID number;
3145: l_CALLING_APP_DOC_UNIQUE_REF1 number;
3146: l_CALLING_APP_DOC_UNIQUE_REF2 number;
3147: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3148: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3149: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3150: l_PAYMENT_AMOUNT number;
3151: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;

Line 3148: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;

3144: l_CALLING_APP_ID number;
3145: l_CALLING_APP_DOC_UNIQUE_REF1 number;
3146: l_CALLING_APP_DOC_UNIQUE_REF2 number;
3147: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3148: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3149: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3150: l_PAYMENT_AMOUNT number;
3151: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3152: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;

Line 3149: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;

3145: l_CALLING_APP_DOC_UNIQUE_REF1 number;
3146: l_CALLING_APP_DOC_UNIQUE_REF2 number;
3147: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3148: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3149: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3150: l_PAYMENT_AMOUNT number;
3151: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3152: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3153: l_DOCUMENT_DATE date;

Line 3151: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;

3147: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3148: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3149: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3150: l_PAYMENT_AMOUNT number;
3151: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3152: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3153: l_DOCUMENT_DATE date;
3154: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3155: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;

Line 3152: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;

3148: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3149: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3150: l_PAYMENT_AMOUNT number;
3151: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3152: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3153: l_DOCUMENT_DATE date;
3154: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3155: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;
3156: l_DOCUMENT_AMOUNT number;

Line 3154: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;

3150: l_PAYMENT_AMOUNT number;
3151: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3152: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3153: l_DOCUMENT_DATE date;
3154: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3155: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;
3156: l_DOCUMENT_AMOUNT number;
3157: l_EXTERNAL_BANK_ACCOUNT_ID number;
3158: l_PAYEE_PARTY_ID number;

Line 3155: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;

3151: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3152: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3153: l_DOCUMENT_DATE date;
3154: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3155: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;
3156: l_DOCUMENT_AMOUNT number;
3157: l_EXTERNAL_BANK_ACCOUNT_ID number;
3158: l_PAYEE_PARTY_ID number;
3159: l_PAYEE_PARTY_SITE_ID number;

Line 3164: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;

3160: l_SUPPLIER_SITE_ID number;
3161: l_LEGAL_ENTITY_ID number;
3162: l_ORG_ID number;
3163: l_ORG_TYPE varchar2(30);
3164: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3165: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%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;

Line 3165: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;

3161: l_LEGAL_ENTITY_ID number;
3162: l_ORG_ID number;
3163: l_ORG_TYPE varchar2(30);
3164: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3165: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%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;

Line 3166: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;

3162: l_ORG_ID number;
3163: l_ORG_TYPE varchar2(30);
3164: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3165: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%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;

Line 3167: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;

3163: l_ORG_TYPE varchar2(30);
3164: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3165: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%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;

Line 3168: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;

3164: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3165: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%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;

Line 3169: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;

3165: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%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;

Line 3173: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%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;
3177: l_CREATED_BY number;

Line 3174: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%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;
3177: l_CREATED_BY number;
3178: l_CREATION_DATE date;

Line 3175: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%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;
3177: l_CREATED_BY number;
3178: l_CREATION_DATE date;
3179: l_LAST_UPDATED_BY number;

Line 3410: FROM ap_invoices_all ai

3406: l_invoice_includes_prepay_flag VARCHAR2(1);
3407: BEGIN
3408: SELECT 'Y'
3409: INTO l_invoice_includes_prepay_flag
3410: FROM ap_invoices_all ai
3411: WHERE ai.invoice_id = P_invoice_id
3412: AND EXISTS (SELECT ail.invoice_includes_prepay_flag
3413: FROM ap_invoice_lines_all ail
3414: WHERE ail.invoice_id = ai.invoice_id

Line 3449: FROM ap_invoices_all ai

3445: l_count NUMBER;
3446: BEGIN
3447: SELECT COUNT(1)
3448: INTO l_count
3449: FROM ap_invoices_all ai
3450: WHERE ai.invoice_id = P_invoice_id
3451: AND ai.historical_flag = 'Y'
3452: AND ai.payment_status_flag = 'Y'
3453: AND NVL(ai.force_revalidation_flag,'N') = 'N'

Line 3504: update ap_invoices_all

3500:
3501: If l_count > 0 then
3502: P_force_revalidation_flag := 'Y';
3503: If(P_event = 'ON-INSERT') then
3504: update ap_invoices_all
3505: set force_revalidation_flag = 'Y'
3506: where invoice_id = p_invoice_id;
3507: end if;
3508: END IF;