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_WEB_UTILITIES_PKG dependencies on AP_INVOICES_ALL

Line 3168: -- Bug: 6220330, added a new parameter so that the trigger on ap_invoices_all can use this.

3164: fnd_client_info.set_org_context( l_org_id );
3165: END IF;
3166: END ExpenseSetOrgContext;
3167:
3168: -- Bug: 6220330, added a new parameter so that the trigger on ap_invoices_all can use this.
3169: PROCEDURE UpdateExpenseStatusCode(
3170: p_invoice_id AP_INVOICES_ALL.invoice_id%TYPE,
3171: p_pay_status_flag AP_INVOICES_ALL.payment_status_flag%TYPE DEFAULT NULL
3172: ) IS

Line 3170: p_invoice_id AP_INVOICES_ALL.invoice_id%TYPE,

3166: END ExpenseSetOrgContext;
3167:
3168: -- Bug: 6220330, added a new parameter so that the trigger on ap_invoices_all can use this.
3169: PROCEDURE UpdateExpenseStatusCode(
3170: p_invoice_id AP_INVOICES_ALL.invoice_id%TYPE,
3171: p_pay_status_flag AP_INVOICES_ALL.payment_status_flag%TYPE DEFAULT NULL
3172: ) IS
3173:
3174: t_paid_status CONSTANT VARCHAR2(10) := 'PAID';

Line 3171: p_pay_status_flag AP_INVOICES_ALL.payment_status_flag%TYPE DEFAULT NULL

3167:
3168: -- Bug: 6220330, added a new parameter so that the trigger on ap_invoices_all can use this.
3169: PROCEDURE UpdateExpenseStatusCode(
3170: p_invoice_id AP_INVOICES_ALL.invoice_id%TYPE,
3171: p_pay_status_flag AP_INVOICES_ALL.payment_status_flag%TYPE DEFAULT NULL
3172: ) IS
3173:
3174: t_paid_status CONSTANT VARCHAR2(10) := 'PAID';
3175: t_partially_paid_status CONSTANT VARCHAR2(10) := 'PARPAID';

Line 3190: l_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;

3186:
3187: l_parent_report_status VARCHAR2(100);
3188: l_main_report_status VARCHAR2(100);
3189:
3190: l_payment_status AP_INVOICES_ALL.payment_status_flag%TYPE;
3191:
3192: l_report_header_id AP_EXPENSE_REPORT_HEADERS_ALL.report_header_id%TYPE;
3193: l_invoice_status VARCHAR2(100);
3194: l_identifier VARCHAR2(100);

Line 3352: -- Bug: 6220330, Expenses are updated from two triggers, one on AP_INVOICES_ALL and

3348: RETURN TRUE;
3349:
3350: END ContainsChars;
3351:
3352: -- Bug: 6220330, Expenses are updated from two triggers, one on AP_INVOICES_ALL and
3353: -- one on AP_INVOICE_PAYMENTS_ALL. If p_pay_status_flag is null, the trigger is
3354: -- on AP_INVOICE_PAYMENTS_ALL, and on AP_INVOICES_ALL other wise.
3355:
3356: PROCEDURE GetExpensesToUpdate(p_invoice_id IN AP_INVOICES_ALL.invoice_id%TYPE,

Line 3354: -- on AP_INVOICE_PAYMENTS_ALL, and on AP_INVOICES_ALL other wise.

3350: END ContainsChars;
3351:
3352: -- Bug: 6220330, Expenses are updated from two triggers, one on AP_INVOICES_ALL and
3353: -- one on AP_INVOICE_PAYMENTS_ALL. If p_pay_status_flag is null, the trigger is
3354: -- on AP_INVOICE_PAYMENTS_ALL, and on AP_INVOICES_ALL other wise.
3355:
3356: PROCEDURE GetExpensesToUpdate(p_invoice_id IN AP_INVOICES_ALL.invoice_id%TYPE,
3357: p_pay_status_flag IN AP_INVOICES_ALL.payment_status_flag%TYPE,
3358: p_expenses_to_update OUT NOCOPY ExpensesToUpdate) IS

Line 3356: PROCEDURE GetExpensesToUpdate(p_invoice_id IN AP_INVOICES_ALL.invoice_id%TYPE,

3352: -- Bug: 6220330, Expenses are updated from two triggers, one on AP_INVOICES_ALL and
3353: -- one on AP_INVOICE_PAYMENTS_ALL. If p_pay_status_flag is null, the trigger is
3354: -- on AP_INVOICE_PAYMENTS_ALL, and on AP_INVOICES_ALL other wise.
3355:
3356: PROCEDURE GetExpensesToUpdate(p_invoice_id IN AP_INVOICES_ALL.invoice_id%TYPE,
3357: p_pay_status_flag IN AP_INVOICES_ALL.payment_status_flag%TYPE,
3358: p_expenses_to_update OUT NOCOPY ExpensesToUpdate) IS
3359: BEGIN
3360: IF (p_pay_status_flag IS NULL) THEN

Line 3357: p_pay_status_flag IN AP_INVOICES_ALL.payment_status_flag%TYPE,

3353: -- one on AP_INVOICE_PAYMENTS_ALL. If p_pay_status_flag is null, the trigger is
3354: -- on AP_INVOICE_PAYMENTS_ALL, and on AP_INVOICES_ALL other wise.
3355:
3356: PROCEDURE GetExpensesToUpdate(p_invoice_id IN AP_INVOICES_ALL.invoice_id%TYPE,
3357: p_pay_status_flag IN AP_INVOICES_ALL.payment_status_flag%TYPE,
3358: p_expenses_to_update OUT NOCOPY ExpensesToUpdate) IS
3359: BEGIN
3360: IF (p_pay_status_flag IS NULL) THEN
3361: -- For the trigger on AP_INVOICE_PAYMENTS_ALL

Line 3371: ap_invoices_all parent_ai,

3367: DECODE(parent_AI.Payment_status_flag,
3368: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3369: FROM ap_expense_report_headers_all parent_aerh,
3370: ap_expense_report_headers_all main_aerh,
3371: ap_invoices_all parent_ai,
3372: ap_payment_schedules_all parent_aps
3373: WHERE
3374: main_aerh.bothpay_parent_id = parent_aerh.report_header_id (+) and
3375: parent_aerh.vouchno = parent_ai.invoice_id and

Line 3387: ap_invoices_all main_ai,

3383: DECODE(main_AI.Payment_status_flag,
3384: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3385: FROM
3386: ap_expense_report_headers_all main_aerh,
3387: ap_invoices_all main_ai,
3388: ap_payment_schedules_all main_aps
3389: WHERE
3390: main_aerh.vouchno = main_ai.invoice_id and
3391: main_ai.invoice_id = main_aps.invoice_id and

Line 3403: ap_invoices_all child_ai,

3399: 'Y','PAID','N','INVOICED','P','PARPAID',NULL) ) invoice_status
3400: FROM
3401: ap_expense_report_headers_all child_aerh,
3402: ap_expense_report_headers_all main_aerh,
3403: ap_invoices_all child_ai,
3404: ap_payment_schedules_all child_aps
3405: WHERE child_aerh.bothpay_parent_id (+) = main_aerh.report_header_id and
3406: child_aerh.vouchno = child_ai.invoice_id and
3407: child_ai.invoice_id = child_aps.invoice_id and

Line 3411: -- For the trigger on AP_INVOICES_ALL

3407: child_ai.invoice_id = child_aps.invoice_id and
3408: main_aerh.vouchno = p_invoice_id;
3409: ELSE
3410: OPEN p_expenses_to_update FOR
3411: -- For the trigger on AP_INVOICES_ALL
3412: -- cc in bp
3413: SELECT 'PARENT' Identifier,
3414: parent_aerh.report_header_id report_header_id,
3415: DECODE(parent_APS.GROSS_AMOUNT ,0,'PAID',