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.IBY_FD_POST_PICP_PROGS_PVT dependencies on FND_GLOBAL

Line 565: last_updated_by = fnd_global.user_id,

561: iby_pay_instructions_all
562: SET
563: payment_instruction_status = p_newStatus,
564: object_version_number = l_instruction_ovn + 1,
565: last_updated_by = fnd_global.user_id,
566: last_update_date = SYSDATE,
567: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
568: WHERE
569: payment_instruction_id = p_payment_instruction_id;

Line 567: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

563: payment_instruction_status = p_newStatus,
564: object_version_number = l_instruction_ovn + 1,
565: last_updated_by = fnd_global.user_id,
566: last_update_date = SYSDATE,
567: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
568: WHERE
569: payment_instruction_id = p_payment_instruction_id;
570:
571: IF p_newStatus = 'SUBMITTED_FOR_PRINTING' THEN

Line 589: last_updated_by = fnd_global.user_id,

585: iby_payments_all
586: SET
587: payment_status = 'SUBMITTED_FOR_PRINTING',
588: object_version_number = l_payment.object_version_number + 1,
589: last_updated_by = fnd_global.user_id,
590: last_update_date = SYSDATE,
591: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
592: WHERE
593: payment_id = l_payment.payment_id;

Line 591: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

587: payment_status = 'SUBMITTED_FOR_PRINTING',
588: object_version_number = l_payment.object_version_number + 1,
589: last_updated_by = fnd_global.user_id,
590: last_update_date = SYSDATE,
591: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
592: WHERE
593: payment_id = l_payment.payment_id;
594: END IF;
595:

Line 613: last_updated_by = fnd_global.user_id,

609: iby_payments_all
610: SET
611: payment_status = 'SUBMITTED_FOR_PRINTING',
612: object_version_number = l_payment.object_version_number + 1,
613: last_updated_by = fnd_global.user_id,
614: last_update_date = SYSDATE,
615: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
616: WHERE
617: payment_id = l_payment.payment_id;

Line 615: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

611: payment_status = 'SUBMITTED_FOR_PRINTING',
612: object_version_number = l_payment.object_version_number + 1,
613: last_updated_by = fnd_global.user_id,
614: last_update_date = SYSDATE,
615: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
616: WHERE
617: payment_id = l_payment.payment_id;
618:
619: ELSIF l_payment.payment_status = 'VOID_BY_SETUP_REPRINT' THEN

Line 631: last_updated_by = fnd_global.user_id,

627: iby_payments_all
628: SET
629: payment_status = 'VOID_BY_SETUP',
630: object_version_number = l_payment.object_version_number + 1,
631: last_updated_by = fnd_global.user_id,
632: last_update_date = SYSDATE,
633: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
634: WHERE
635: payment_id = l_payment.payment_id;

Line 633: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

629: payment_status = 'VOID_BY_SETUP',
630: object_version_number = l_payment.object_version_number + 1,
631: last_updated_by = fnd_global.user_id,
632: last_update_date = SYSDATE,
633: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
634: WHERE
635: payment_id = l_payment.payment_id;
636:
637: ELSIF l_payment.payment_status = 'VOID_BY_OVERFLOW_REPRINT' THEN

Line 649: last_updated_by = fnd_global.user_id,

645: iby_payments_all
646: SET
647: payment_status = 'VOID_BY_OVERFLOW',
648: object_version_number = l_payment.object_version_number + 1,
649: last_updated_by = fnd_global.user_id,
650: last_update_date = SYSDATE,
651: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
652: WHERE
653: payment_id = l_payment.payment_id;

Line 651: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

647: payment_status = 'VOID_BY_OVERFLOW',
648: object_version_number = l_payment.object_version_number + 1,
649: last_updated_by = fnd_global.user_id,
650: last_update_date = SYSDATE,
651: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
652: WHERE
653: payment_id = l_payment.payment_id;
654:
655: END IF;

Line 678: last_updated_by = fnd_global.user_id,

674: iby_payments_all
675: SET
676: payment_status = 'FORMATTED',
677: object_version_number = l_payment.object_version_number + 1,
678: last_updated_by = fnd_global.user_id,
679: last_update_date = SYSDATE,
680: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
681: WHERE
682: payment_id = l_payment.payment_id;

Line 680: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

676: payment_status = 'FORMATTED',
677: object_version_number = l_payment.object_version_number + 1,
678: last_updated_by = fnd_global.user_id,
679: last_update_date = SYSDATE,
680: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
681: WHERE
682: payment_id = l_payment.payment_id;
683: END IF;
684:

Line 705: last_updated_by = fnd_global.user_id,

701: iby_payments_all
702: SET
703: payment_status = 'FORMATTED',
704: object_version_number = l_payment.object_version_number + 1,
705: last_updated_by = fnd_global.user_id,
706: last_update_date = SYSDATE,
707: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
708: WHERE
709: payment_id = l_payment.payment_id;

Line 707: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

703: payment_status = 'FORMATTED',
704: object_version_number = l_payment.object_version_number + 1,
705: last_updated_by = fnd_global.user_id,
706: last_update_date = SYSDATE,
707: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
708: WHERE
709: payment_id = l_payment.payment_id;
710: END IF;
711:

Line 759: last_updated_by = fnd_global.user_id,

755: iby_payments_all
756: SET
757: payment_status = 'FORMATTED',
758: object_version_number = l_payment.object_version_number + 1,
759: last_updated_by = fnd_global.user_id,
760: last_update_date = SYSDATE,
761: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
762: WHERE
763: payment_id = l_payment.payment_id;

Line 761: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

757: payment_status = 'FORMATTED',
758: object_version_number = l_payment.object_version_number + 1,
759: last_updated_by = fnd_global.user_id,
760: last_update_date = SYSDATE,
761: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
762: WHERE
763: payment_id = l_payment.payment_id;
764: END IF;
765:

Line 793: last_updated_by = fnd_global.user_id,

789: iby_payments_all
790: SET
791: payment_status = 'FORMATTED',
792: object_version_number = l_payment.object_version_number + 1,
793: last_updated_by = fnd_global.user_id,
794: last_update_date = SYSDATE,
795: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
796: WHERE
797: payment_id = l_payment.payment_id;

Line 795: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

791: payment_status = 'FORMATTED',
792: object_version_number = l_payment.object_version_number + 1,
793: last_updated_by = fnd_global.user_id,
794: last_update_date = SYSDATE,
795: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
796: WHERE
797: payment_id = l_payment.payment_id;
798: END IF;
799:

Line 846: last_updated_by = fnd_global.user_id,

842: iby_payments_all
843: SET
844: payment_status = 'TRANSMITTED',
845: object_version_number = l_payment.object_version_number + 1,
846: last_updated_by = fnd_global.user_id,
847: last_update_date = SYSDATE,
848: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
849: WHERE
850: payment_id = l_payment.payment_id;

Line 848: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

844: payment_status = 'TRANSMITTED',
845: object_version_number = l_payment.object_version_number + 1,
846: last_updated_by = fnd_global.user_id,
847: last_update_date = SYSDATE,
848: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
849: WHERE
850: payment_id = l_payment.payment_id;
851: END IF;
852:

Line 908: last_updated_by = fnd_global.user_id,

904: iby_payments_all
905: SET
906: payment_status = 'FORMATTED',
907: object_version_number = l_payment.object_version_number + 1,
908: last_updated_by = fnd_global.user_id,
909: last_update_date = SYSDATE,
910: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
911: WHERE
912: payment_id = l_payment.payment_id;

Line 910: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

906: payment_status = 'FORMATTED',
907: object_version_number = l_payment.object_version_number + 1,
908: last_updated_by = fnd_global.user_id,
909: last_update_date = SYSDATE,
910: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
911: WHERE
912: payment_id = l_payment.payment_id;
913: END IF;
914:

Line 1089: p_error_code, sysdate, 'ACTIVE', fnd_global.user_id,

1085: object_version_number, override_allowed_on_error_flag,
1086: do_not_apply_error_flag, error_type, error_message)
1087: values
1088: (l_transaction_error_id, 'PAYMENT_INSTRUCTION', p_payment_instruction_id,
1089: p_error_code, sysdate, 'ACTIVE', fnd_global.user_id,
1090: sysdate, fnd_global.user_id, sysdate,
1091: 1, 'Y',
1092: 'N', 'BANK', p_error_msg);
1093:

Line 1090: sysdate, fnd_global.user_id, sysdate,

1086: do_not_apply_error_flag, error_type, error_message)
1087: values
1088: (l_transaction_error_id, 'PAYMENT_INSTRUCTION', p_payment_instruction_id,
1089: p_error_code, sysdate, 'ACTIVE', fnd_global.user_id,
1090: sysdate, fnd_global.user_id, sysdate,
1091: 1, 'Y',
1092: 'N', 'BANK', p_error_msg);
1093:
1094: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

Line 1135: last_updated_by = fnd_global.user_id,

1131: iby_docs_payable_all
1132: SET
1133: straight_through_flag = 'N',
1134: object_version_number = object_version_number + 1,
1135: last_updated_by = fnd_global.user_id,
1136: last_update_date = SYSDATE,
1137: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1138: WHERE
1139: document_payable_id = l_doc.document_payable_id;

Line 1137: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

1133: straight_through_flag = 'N',
1134: object_version_number = object_version_number + 1,
1135: last_updated_by = fnd_global.user_id,
1136: last_update_date = SYSDATE,
1137: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1138: WHERE
1139: document_payable_id = l_doc.document_payable_id;
1140:
1141: END LOOP;

Line 1335: last_updated_by = fnd_global.user_id,

1331:
1332: UPDATE iby_acct_pmt_profiles_b
1333: SET
1334: object_version_number = object_version_number + 1,
1335: last_updated_by = fnd_global.user_id,
1336: last_update_date = SYSDATE,
1337: last_update_login = fnd_global.LOGIN_ID
1338: WHERE
1339: payment_profile_id = l_payment_profile_id;

Line 1337: last_update_login = fnd_global.LOGIN_ID

1333: SET
1334: object_version_number = object_version_number + 1,
1335: last_updated_by = fnd_global.user_id,
1336: last_update_date = SYSDATE,
1337: last_update_login = fnd_global.LOGIN_ID
1338: WHERE
1339: payment_profile_id = l_payment_profile_id;
1340:
1341: END IF;

Line 1374: last_updated_by = fnd_global.user_id,

1370: iby_pay_instructions_all
1371: SET
1372: remittance_advice_created_flag = 'Y',
1373: object_version_number = l_instruction_ovn + 1,
1374: last_updated_by = fnd_global.user_id,
1375: last_update_date = SYSDATE,
1376: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1377: WHERE
1378: payment_instruction_id = p_payment_instruction_id;

Line 1376: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

1372: remittance_advice_created_flag = 'Y',
1373: object_version_number = l_instruction_ovn + 1,
1374: last_updated_by = fnd_global.user_id,
1375: last_update_date = SYSDATE,
1376: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1377: WHERE
1378: payment_instruction_id = p_payment_instruction_id;
1379:
1380: END set_sra_created;

Line 1406: last_updated_by = fnd_global.user_id,

1402: iby_pay_instructions_all
1403: SET
1404: positive_pay_file_created_flag = 'Y',
1405: object_version_number = l_instruction_ovn + 1,
1406: last_updated_by = fnd_global.user_id,
1407: last_update_date = SYSDATE,
1408: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1409: WHERE
1410: payment_instruction_id = p_payment_instruction_id;

Line 1408: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

1404: positive_pay_file_created_flag = 'Y',
1405: object_version_number = l_instruction_ovn + 1,
1406: last_updated_by = fnd_global.user_id,
1407: last_update_date = SYSDATE,
1408: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1409: WHERE
1410: payment_instruction_id = p_payment_instruction_id;
1411:
1412: END set_pos_pay_created;

Line 1438: last_updated_by = fnd_global.user_id,

1434: iby_pay_instructions_all
1435: SET
1436: regulatory_report_created_flag = 'Y',
1437: object_version_number = l_instruction_ovn + 1,
1438: last_updated_by = fnd_global.user_id,
1439: last_update_date = SYSDATE,
1440: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1441: WHERE
1442: payment_instruction_id = p_payment_instruction_id;

Line 1440: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

1436: regulatory_report_created_flag = 'Y',
1437: object_version_number = l_instruction_ovn + 1,
1438: last_updated_by = fnd_global.user_id,
1439: last_update_date = SYSDATE,
1440: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1441: WHERE
1442: payment_instruction_id = p_payment_instruction_id;
1443:
1444: END set_reg_rpt_created;

Line 1578: where APPLICATION_ID = FND_GLOBAL.resp_appl_id;

1574: IF MO_GLOBAL.is_mo_init_done = 'N' THEN
1575: select APPLICATION_SHORT_NAME
1576: into l_appl_name
1577: from FND_APPLICATION
1578: where APPLICATION_ID = FND_GLOBAL.resp_appl_id;
1579:
1580: -- Set MOAC security
1581: MO_GLOBAL.init(l_appl_name);
1582: END IF;

Line 1922: reset_request_1 = fnd_global.CONC_REQUEST_ID,

1918: UPDATE iby_acct_pmt_profiles_b
1919: SET
1920: reset_value_1 = nvl(p_reset_value, reset_value_1),
1921: last_used_number_1 = nvl(p_reset_value, reset_value_1),
1922: reset_request_1 = fnd_global.CONC_REQUEST_ID,
1923: object_version_number = object_version_number + 1,
1924: last_updated_by = fnd_global.user_id,
1925: last_update_date = SYSDATE,
1926: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

Line 1924: last_updated_by = fnd_global.user_id,

1920: reset_value_1 = nvl(p_reset_value, reset_value_1),
1921: last_used_number_1 = nvl(p_reset_value, reset_value_1),
1922: reset_request_1 = fnd_global.CONC_REQUEST_ID,
1923: object_version_number = object_version_number + 1,
1924: last_updated_by = fnd_global.user_id,
1925: last_update_date = SYSDATE,
1926: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1927: WHERE
1928: payment_profile_id = p_payment_profile_id;

Line 1926: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

1922: reset_request_1 = fnd_global.CONC_REQUEST_ID,
1923: object_version_number = object_version_number + 1,
1924: last_updated_by = fnd_global.user_id,
1925: last_update_date = SYSDATE,
1926: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1927: WHERE
1928: payment_profile_id = p_payment_profile_id;
1929:
1930: ELSIF p_sequence_number = 2 THEN

Line 1936: reset_request_2 = fnd_global.CONC_REQUEST_ID,

1932: UPDATE iby_acct_pmt_profiles_b
1933: SET
1934: reset_value_2 = nvl(p_reset_value, reset_value_2),
1935: last_used_number_2 = nvl(p_reset_value, reset_value_2),
1936: reset_request_2 = fnd_global.CONC_REQUEST_ID,
1937: object_version_number = object_version_number + 1,
1938: last_updated_by = fnd_global.user_id,
1939: last_update_date = SYSDATE,
1940: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

Line 1938: last_updated_by = fnd_global.user_id,

1934: reset_value_2 = nvl(p_reset_value, reset_value_2),
1935: last_used_number_2 = nvl(p_reset_value, reset_value_2),
1936: reset_request_2 = fnd_global.CONC_REQUEST_ID,
1937: object_version_number = object_version_number + 1,
1938: last_updated_by = fnd_global.user_id,
1939: last_update_date = SYSDATE,
1940: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1941: WHERE
1942: payment_profile_id = p_payment_profile_id;

Line 1940: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

1936: reset_request_2 = fnd_global.CONC_REQUEST_ID,
1937: object_version_number = object_version_number + 1,
1938: last_updated_by = fnd_global.user_id,
1939: last_update_date = SYSDATE,
1940: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1941: WHERE
1942: payment_profile_id = p_payment_profile_id;
1943:
1944: ELSIF p_sequence_number = 3 THEN

Line 1950: reset_request_3 = fnd_global.CONC_REQUEST_ID,

1946: UPDATE iby_acct_pmt_profiles_b
1947: SET
1948: reset_value_3 = nvl(p_reset_value, reset_value_3),
1949: last_used_number_3 = nvl(p_reset_value, reset_value_3),
1950: reset_request_3 = fnd_global.CONC_REQUEST_ID,
1951: object_version_number = object_version_number + 1,
1952: last_updated_by = fnd_global.user_id,
1953: last_update_date = SYSDATE,
1954: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

Line 1952: last_updated_by = fnd_global.user_id,

1948: reset_value_3 = nvl(p_reset_value, reset_value_3),
1949: last_used_number_3 = nvl(p_reset_value, reset_value_3),
1950: reset_request_3 = fnd_global.CONC_REQUEST_ID,
1951: object_version_number = object_version_number + 1,
1952: last_updated_by = fnd_global.user_id,
1953: last_update_date = SYSDATE,
1954: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1955: WHERE
1956: payment_profile_id = p_payment_profile_id;

Line 1954: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

1950: reset_request_3 = fnd_global.CONC_REQUEST_ID,
1951: object_version_number = object_version_number + 1,
1952: last_updated_by = fnd_global.user_id,
1953: last_update_date = SYSDATE,
1954: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1955: WHERE
1956: payment_profile_id = p_payment_profile_id;
1957:
1958: END IF;