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_AUTOMATIC_PROPAGATION_PKG dependencies on FND_GLOBAL

Line 314: last_updated_by = FND_GLOBAL.user_id,

310:
311: UPDATE ap_payment_schedules_all aps
312: SET aps.external_bank_account_id = l_to_bank_account_id,
313: last_update_date = SYSDATE,
314: last_updated_by = FND_GLOBAL.user_id,
315: last_update_login = FND_GLOBAL.login_id
316: WHERE aps.invoice_id = x.invoice_id -- Added and commented below code for bug 9410719
317: AND aps.payment_num = x.payment_num;
318:

Line 315: last_update_login = FND_GLOBAL.login_id

311: UPDATE ap_payment_schedules_all aps
312: SET aps.external_bank_account_id = l_to_bank_account_id,
313: last_update_date = SYSDATE,
314: last_updated_by = FND_GLOBAL.user_id,
315: last_update_login = FND_GLOBAL.login_id
316: WHERE aps.invoice_id = x.invoice_id -- Added and commented below code for bug 9410719
317: AND aps.payment_num = x.payment_num;
318:
319: --Bug10065192: Update the bank at invoice header level, so recalculation of

Line 324: ai.last_updated_by = FND_GLOBAL.user_id,

320: --payment schedules does not reinstate the inactive bank
321: UPDATE ap_invoices_all ai
322: SET ai.external_bank_account_id = l_to_bank_account_id,
323: ai.last_update_date = SYSDATE,
324: ai.last_updated_by = FND_GLOBAL.user_id,
325: ai.last_update_login = FND_GLOBAL.login_id
326: WHERE ai.invoice_id = x.invoice_id;
327:
328: /* WHERE aps.invoice_id IN

Line 325: ai.last_update_login = FND_GLOBAL.login_id

321: UPDATE ap_invoices_all ai
322: SET ai.external_bank_account_id = l_to_bank_account_id,
323: ai.last_update_date = SYSDATE,
324: ai.last_updated_by = FND_GLOBAL.user_id,
325: ai.last_update_login = FND_GLOBAL.login_id
326: WHERE ai.invoice_id = x.invoice_id;
327:
328: /* WHERE aps.invoice_id IN
329: (SELECT DISTINCT ai.invoice_id

Line 399: last_updated_by = FND_GLOBAL.user_id,

395:
396: UPDATE ap_payment_schedules_all aps
397: SET aps.external_bank_account_id = l_to_bank_account_id,
398: last_update_date = SYSDATE,
399: last_updated_by = FND_GLOBAL.user_id,
400: last_update_login = FND_GLOBAL.login_id
401: WHERE aps.invoice_id = x.invoice_id -- Added and commented below code for bug 9410719
402: AND aps.payment_num = x.payment_num;
403:

Line 400: last_update_login = FND_GLOBAL.login_id

396: UPDATE ap_payment_schedules_all aps
397: SET aps.external_bank_account_id = l_to_bank_account_id,
398: last_update_date = SYSDATE,
399: last_updated_by = FND_GLOBAL.user_id,
400: last_update_login = FND_GLOBAL.login_id
401: WHERE aps.invoice_id = x.invoice_id -- Added and commented below code for bug 9410719
402: AND aps.payment_num = x.payment_num;
403:
404: --Bug10065192: Update the bank at invoice header level, so recalculation of

Line 409: ai.last_updated_by = FND_GLOBAL.user_id,

405: --payment schedules does not reinstate the inactive bank
406: UPDATE ap_invoices_all ai
407: SET ai.external_bank_account_id = l_to_bank_account_id,
408: ai.last_update_date = SYSDATE,
409: ai.last_updated_by = FND_GLOBAL.user_id,
410: ai.last_update_login = FND_GLOBAL.login_id
411: WHERE ai.invoice_id = x.invoice_id;
412:
413: /* WHERE aps.invoice_id IN

Line 410: ai.last_update_login = FND_GLOBAL.login_id

406: UPDATE ap_invoices_all ai
407: SET ai.external_bank_account_id = l_to_bank_account_id,
408: ai.last_update_date = SYSDATE,
409: ai.last_updated_by = FND_GLOBAL.user_id,
410: ai.last_update_login = FND_GLOBAL.login_id
411: WHERE ai.invoice_id = x.invoice_id;
412:
413: /* WHERE aps.invoice_id IN
414: (SELECT DISTINCT ai.invoice_id

Line 476: last_updated_by = FND_GLOBAL.user_id,

472:
473: UPDATE ap_payment_schedules_all aps
474: SET aps.external_bank_account_id = l_to_bank_account_id,
475: last_update_date = SYSDATE,
476: last_updated_by = FND_GLOBAL.user_id,
477: last_update_login = FND_GLOBAL.login_id
478: WHERE aps.invoice_id = x.invoice_id -- Added and commented below code for bug 9410719
479: AND aps.payment_num = x.payment_num;
480:

Line 477: last_update_login = FND_GLOBAL.login_id

473: UPDATE ap_payment_schedules_all aps
474: SET aps.external_bank_account_id = l_to_bank_account_id,
475: last_update_date = SYSDATE,
476: last_updated_by = FND_GLOBAL.user_id,
477: last_update_login = FND_GLOBAL.login_id
478: WHERE aps.invoice_id = x.invoice_id -- Added and commented below code for bug 9410719
479: AND aps.payment_num = x.payment_num;
480:
481: --Bug10065192: Update the bank at invoice header level, so recalculation of

Line 486: ai.last_updated_by = FND_GLOBAL.user_id,

482: --payment schedules does not reinstate the inactive bank
483: UPDATE ap_invoices_all ai
484: SET ai.external_bank_account_id = l_to_bank_account_id,
485: ai.last_update_date = SYSDATE,
486: ai.last_updated_by = FND_GLOBAL.user_id,
487: ai.last_update_login = FND_GLOBAL.login_id
488: WHERE ai.invoice_id = x.invoice_id;
489:
490: /* WHERE aps.invoice_id IN

Line 487: ai.last_update_login = FND_GLOBAL.login_id

483: UPDATE ap_invoices_all ai
484: SET ai.external_bank_account_id = l_to_bank_account_id,
485: ai.last_update_date = SYSDATE,
486: ai.last_updated_by = FND_GLOBAL.user_id,
487: ai.last_update_login = FND_GLOBAL.login_id
488: WHERE ai.invoice_id = x.invoice_id;
489:
490: /* WHERE aps.invoice_id IN
491: (SELECT DISTINCT ai.invoice_id

Line 545: last_updated_by = FND_GLOBAL.user_id,

541:
542: UPDATE ap_payment_schedules_all aps
543: SET aps.external_bank_account_id = l_to_bank_account_id,
544: last_update_date = SYSDATE,
545: last_updated_by = FND_GLOBAL.user_id,
546: last_update_login = FND_GLOBAL.login_id
547: WHERE aps.invoice_id = x.invoice_id -- Added and commented below code for bug 9410719
548: AND aps.payment_num = x.payment_num;
549:

Line 546: last_update_login = FND_GLOBAL.login_id

542: UPDATE ap_payment_schedules_all aps
543: SET aps.external_bank_account_id = l_to_bank_account_id,
544: last_update_date = SYSDATE,
545: last_updated_by = FND_GLOBAL.user_id,
546: last_update_login = FND_GLOBAL.login_id
547: WHERE aps.invoice_id = x.invoice_id -- Added and commented below code for bug 9410719
548: AND aps.payment_num = x.payment_num;
549:
550: --Bug10065192: Update the bank at invoice header level, so recalculation of

Line 555: ai.last_updated_by = FND_GLOBAL.user_id,

551: --payment schedules does not reinstate the inactive bank
552: UPDATE ap_invoices_all ai
553: SET ai.external_bank_account_id = l_to_bank_account_id,
554: ai.last_update_date = SYSDATE,
555: ai.last_updated_by = FND_GLOBAL.user_id,
556: ai.last_update_login = FND_GLOBAL.login_id
557: WHERE ai.invoice_id = x.invoice_id;
558:
559: /* WHERE aps.invoice_id IN

Line 556: ai.last_update_login = FND_GLOBAL.login_id

552: UPDATE ap_invoices_all ai
553: SET ai.external_bank_account_id = l_to_bank_account_id,
554: ai.last_update_date = SYSDATE,
555: ai.last_updated_by = FND_GLOBAL.user_id,
556: ai.last_update_login = FND_GLOBAL.login_id
557: WHERE ai.invoice_id = x.invoice_id;
558:
559: /* WHERE aps.invoice_id IN
560: (SELECT DISTINCT ai.invoice_id