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 607: last_updated_by = fnd_global.user_id,

603: iby_pay_instructions_all
604: SET
605: payment_instruction_status = p_newStatus,
606: object_version_number = l_instruction_ovn + 1,
607: last_updated_by = fnd_global.user_id,
608: last_update_date = SYSDATE,
609: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
610: WHERE
611: payment_instruction_id = p_payment_instruction_id;

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

605: payment_instruction_status = p_newStatus,
606: object_version_number = l_instruction_ovn + 1,
607: last_updated_by = fnd_global.user_id,
608: last_update_date = SYSDATE,
609: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
610: WHERE
611: payment_instruction_id = p_payment_instruction_id;
612:
613: IF p_newStatus = 'SUBMITTED_FOR_PRINTING' THEN

Line 643: last_updated_by = fnd_global.user_id,

639: iby_payments_all
640: SET
641: payment_status = 'SUBMITTED_FOR_PRINTING',
642: object_version_number = object_version_number + 1,
643: last_updated_by = fnd_global.user_id,
644: last_update_date = SYSDATE,
645: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
646: WHERE
647: payment_instruction_id = p_payment_instruction_id

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

641: payment_status = 'SUBMITTED_FOR_PRINTING',
642: object_version_number = object_version_number + 1,
643: last_updated_by = fnd_global.user_id,
644: last_update_date = SYSDATE,
645: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
646: WHERE
647: payment_instruction_id = p_payment_instruction_id
648: AND payment_status IN ('FORMATTED', 'INSTRUCTION_CREATED');
649:

Line 688: last_updated_by = fnd_global.user_id,

684: 'READY_TO_REPRINT','SUBMITTED_FOR_PRINTING',
685: 'VOID_BY_SETUP_REPRINT','VOID_BY_SETUP',
686: 'VOID_BY_OVERFLOW_REPRINT','VOID_BY_OVERFLOW'),
687: object_version_number = object_version_number + 1,
688: last_updated_by = fnd_global.user_id,
689: last_update_date = SYSDATE,
690: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
691: WHERE
692: payment_instruction_id = p_payment_instruction_id

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

686: 'VOID_BY_OVERFLOW_REPRINT','VOID_BY_OVERFLOW'),
687: object_version_number = object_version_number + 1,
688: last_updated_by = fnd_global.user_id,
689: last_update_date = SYSDATE,
690: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
691: WHERE
692: payment_instruction_id = p_payment_instruction_id
693: AND payment_status IN ('READY_TO_REPRINT','VOID_BY_SETUP_REPRINT','VOID_BY_OVERFLOW_REPRINT');
694:

Line 715: -- last_updated_by = fnd_global.user_id,

711: -- iby_payments_all
712: -- SET
713: -- payment_status = 'VOID_BY_SETUP',
714: -- object_version_number = object_version_number + 1,
715: -- last_updated_by = fnd_global.user_id,
716: -- last_update_date = SYSDATE,
717: -- last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
718: -- WHERE
719: -- payment_instruction_id = p_payment_instruction_id

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

713: -- payment_status = 'VOID_BY_SETUP',
714: -- object_version_number = object_version_number + 1,
715: -- last_updated_by = fnd_global.user_id,
716: -- last_update_date = SYSDATE,
717: -- last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
718: -- WHERE
719: -- payment_instruction_id = p_payment_instruction_id
720: -- AND payment_status = 'VOID_BY_SETUP_REPRINT';
721:

Line 742: -- last_updated_by = fnd_global.user_id,

738: -- iby_payments_all
739: -- SET
740: -- payment_status = 'VOID_BY_OVERFLOW',
741: -- object_version_number = object_version_number + 1,
742: -- last_updated_by = fnd_global.user_id,
743: -- last_update_date = SYSDATE,
744: -- last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
745: -- WHERE
746: -- payment_instruction_id = p_payment_instruction_id

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

740: -- payment_status = 'VOID_BY_OVERFLOW',
741: -- object_version_number = object_version_number + 1,
742: -- last_updated_by = fnd_global.user_id,
743: -- last_update_date = SYSDATE,
744: -- last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
745: -- WHERE
746: -- payment_instruction_id = p_payment_instruction_id
747: -- AND payment_status = 'VOID_BY_OVERFLOW_REPRINT';
748:

Line 785: last_updated_by = fnd_global.user_id,

781: iby_payments_all
782: SET
783: payment_status = 'FORMATTED',
784: object_version_number = object_version_number + 1,
785: last_updated_by = fnd_global.user_id,
786: last_update_date = SYSDATE,
787: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
788: WHERE
789: payment_instruction_id = p_payment_instruction_id

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

783: payment_status = 'FORMATTED',
784: object_version_number = object_version_number + 1,
785: last_updated_by = fnd_global.user_id,
786: last_update_date = SYSDATE,
787: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
788: WHERE
789: payment_instruction_id = p_payment_instruction_id
790: AND payment_status = 'INSTRUCTION_CREATED';
791:

Line 827: last_updated_by = fnd_global.user_id,

823: iby_payments_all
824: SET
825: payment_status = 'FORMATTED',
826: object_version_number = object_version_number + 1,
827: last_updated_by = fnd_global.user_id,
828: last_update_date = SYSDATE,
829: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
830: WHERE
831: payment_instruction_id = p_payment_instruction_id

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

825: payment_status = 'FORMATTED',
826: object_version_number = object_version_number + 1,
827: last_updated_by = fnd_global.user_id,
828: last_update_date = SYSDATE,
829: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
830: WHERE
831: payment_instruction_id = p_payment_instruction_id
832: AND payment_status = 'INSTRUCTION_CREATED';
833:

Line 901: last_updated_by = fnd_global.user_id,

897: iby_payments_all
898: SET
899: payment_status = 'FORMATTED',
900: object_version_number = object_version_number + 1,
901: last_updated_by = fnd_global.user_id,
902: last_update_date = SYSDATE,
903: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
904: WHERE
905: payment_instruction_id = p_payment_instruction_id

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

899: payment_status = 'FORMATTED',
900: object_version_number = object_version_number + 1,
901: last_updated_by = fnd_global.user_id,
902: last_update_date = SYSDATE,
903: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
904: WHERE
905: payment_instruction_id = p_payment_instruction_id
906: AND payment_status = 'INSTRUCTION_CREATED';
907:

Line 951: last_updated_by = fnd_global.user_id,

947: iby_payments_all
948: SET
949: payment_status = 'FORMATTED',
950: object_version_number = object_version_number + 1,
951: last_updated_by = fnd_global.user_id,
952: last_update_date = SYSDATE,
953: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
954: WHERE
955: payment_instruction_id = p_payment_instruction_id

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

949: payment_status = 'FORMATTED',
950: object_version_number = object_version_number + 1,
951: last_updated_by = fnd_global.user_id,
952: last_update_date = SYSDATE,
953: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
954: WHERE
955: payment_instruction_id = p_payment_instruction_id
956: AND payment_status = 'INSTRUCTION_CREATED';
957:

Line 1026: last_updated_by = fnd_global.user_id,

1022: iby_payments_all
1023: SET
1024: payment_status = 'TRANSMITTED',
1025: object_version_number = object_version_number + 1,
1026: last_updated_by = fnd_global.user_id,
1027: last_update_date = SYSDATE,
1028: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1029: WHERE
1030: payment_instruction_id = p_payment_instruction_id

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

1024: payment_status = 'TRANSMITTED',
1025: object_version_number = object_version_number + 1,
1026: last_updated_by = fnd_global.user_id,
1027: last_update_date = SYSDATE,
1028: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1029: WHERE
1030: payment_instruction_id = p_payment_instruction_id
1031: AND payment_status IN ('FORMATTED', 'INSTRUCTION_CREATED');
1032:

Line 1113: last_updated_by = fnd_global.user_id,

1109: iby_payments_all
1110: SET
1111: payment_status = 'FORMATTED',
1112: object_version_number = object_version_number + 1,
1113: last_updated_by = fnd_global.user_id,
1114: last_update_date = SYSDATE,
1115: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1116: WHERE
1117: payment_instruction_id = p_payment_instruction_id

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

1111: payment_status = 'FORMATTED',
1112: object_version_number = object_version_number + 1,
1113: last_updated_by = fnd_global.user_id,
1114: last_update_date = SYSDATE,
1115: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1116: WHERE
1117: payment_instruction_id = p_payment_instruction_id
1118: AND payment_status IN ('INSTRUCTION_CREATED');
1119:

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

1294: object_version_number, override_allowed_on_error_flag,
1295: do_not_apply_error_flag, error_type, error_message)
1296: values
1297: (l_transaction_error_id, 'PAYMENT_INSTRUCTION', p_payment_instruction_id,
1298: p_error_code, sysdate, 'ACTIVE', fnd_global.user_id,
1299: sysdate, fnd_global.user_id, sysdate,
1300: 1, 'Y',
1301: 'N', 'BANK', p_error_msg);
1302:

Line 1299: sysdate, fnd_global.user_id, sysdate,

1295: do_not_apply_error_flag, error_type, error_message)
1296: values
1297: (l_transaction_error_id, 'PAYMENT_INSTRUCTION', p_payment_instruction_id,
1298: p_error_code, sysdate, 'ACTIVE', fnd_global.user_id,
1299: sysdate, fnd_global.user_id, sysdate,
1300: 1, 'Y',
1301: 'N', 'BANK', p_error_msg);
1302:
1303: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,

Line 1344: last_updated_by = fnd_global.user_id,

1340: iby_docs_payable_all
1341: SET
1342: straight_through_flag = 'N',
1343: object_version_number = object_version_number + 1,
1344: last_updated_by = fnd_global.user_id,
1345: last_update_date = SYSDATE,
1346: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1347: WHERE
1348: document_payable_id = l_doc.document_payable_id;

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

1342: straight_through_flag = 'N',
1343: object_version_number = object_version_number + 1,
1344: last_updated_by = fnd_global.user_id,
1345: last_update_date = SYSDATE,
1346: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1347: WHERE
1348: document_payable_id = l_doc.document_payable_id;
1349:
1350: END LOOP;

Line 1544: last_updated_by = fnd_global.user_id,

1540:
1541: UPDATE iby_acct_pmt_profiles_b
1542: SET
1543: object_version_number = object_version_number + 1,
1544: last_updated_by = fnd_global.user_id,
1545: last_update_date = SYSDATE,
1546: last_update_login = fnd_global.LOGIN_ID
1547: WHERE
1548: payment_profile_id = l_payment_profile_id;

Line 1546: last_update_login = fnd_global.LOGIN_ID

1542: SET
1543: object_version_number = object_version_number + 1,
1544: last_updated_by = fnd_global.user_id,
1545: last_update_date = SYSDATE,
1546: last_update_login = fnd_global.LOGIN_ID
1547: WHERE
1548: payment_profile_id = l_payment_profile_id;
1549:
1550: END IF;

Line 1583: last_updated_by = fnd_global.user_id,

1579: iby_pay_instructions_all
1580: SET
1581: remittance_advice_created_flag = 'Y',
1582: object_version_number = l_instruction_ovn + 1,
1583: last_updated_by = fnd_global.user_id,
1584: last_update_date = SYSDATE,
1585: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1586: WHERE
1587: payment_instruction_id = p_payment_instruction_id;

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

1581: remittance_advice_created_flag = 'Y',
1582: object_version_number = l_instruction_ovn + 1,
1583: last_updated_by = fnd_global.user_id,
1584: last_update_date = SYSDATE,
1585: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1586: WHERE
1587: payment_instruction_id = p_payment_instruction_id;
1588:
1589: END set_sra_created;

Line 1615: last_updated_by = fnd_global.user_id,

1611: iby_pay_instructions_all
1612: SET
1613: positive_pay_file_created_flag = 'Y',
1614: object_version_number = l_instruction_ovn + 1,
1615: last_updated_by = fnd_global.user_id,
1616: last_update_date = SYSDATE,
1617: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1618: WHERE
1619: payment_instruction_id = p_payment_instruction_id;

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

1613: positive_pay_file_created_flag = 'Y',
1614: object_version_number = l_instruction_ovn + 1,
1615: last_updated_by = fnd_global.user_id,
1616: last_update_date = SYSDATE,
1617: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1618: WHERE
1619: payment_instruction_id = p_payment_instruction_id;
1620:
1621: END set_pos_pay_created;

Line 1647: last_updated_by = fnd_global.user_id,

1643: iby_pay_instructions_all
1644: SET
1645: regulatory_report_created_flag = 'Y',
1646: object_version_number = l_instruction_ovn + 1,
1647: last_updated_by = fnd_global.user_id,
1648: last_update_date = SYSDATE,
1649: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1650: WHERE
1651: payment_instruction_id = p_payment_instruction_id;

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

1645: regulatory_report_created_flag = 'Y',
1646: object_version_number = l_instruction_ovn + 1,
1647: last_updated_by = fnd_global.user_id,
1648: last_update_date = SYSDATE,
1649: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
1650: WHERE
1651: payment_instruction_id = p_payment_instruction_id;
1652:
1653: END set_reg_rpt_created;

Line 1787: where APPLICATION_ID = FND_GLOBAL.resp_appl_id;

1783: IF MO_GLOBAL.is_mo_init_done = 'N' THEN
1784: select APPLICATION_SHORT_NAME
1785: into l_appl_name
1786: from FND_APPLICATION
1787: where APPLICATION_ID = FND_GLOBAL.resp_appl_id;
1788:
1789: -- Set MOAC security
1790: MO_GLOBAL.init(l_appl_name);
1791: END IF;

Line 2131: reset_request_1 = fnd_global.CONC_REQUEST_ID,

2127: UPDATE iby_acct_pmt_profiles_b
2128: SET
2129: reset_value_1 = nvl(p_reset_value, reset_value_1),
2130: last_used_number_1 = nvl(p_reset_value, reset_value_1),
2131: reset_request_1 = fnd_global.CONC_REQUEST_ID,
2132: object_version_number = object_version_number + 1,
2133: last_updated_by = fnd_global.user_id,
2134: last_update_date = SYSDATE,
2135: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

Line 2133: last_updated_by = fnd_global.user_id,

2129: reset_value_1 = nvl(p_reset_value, reset_value_1),
2130: last_used_number_1 = nvl(p_reset_value, reset_value_1),
2131: reset_request_1 = fnd_global.CONC_REQUEST_ID,
2132: object_version_number = object_version_number + 1,
2133: last_updated_by = fnd_global.user_id,
2134: last_update_date = SYSDATE,
2135: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
2136: WHERE
2137: payment_profile_id = p_payment_profile_id;

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

2131: reset_request_1 = fnd_global.CONC_REQUEST_ID,
2132: object_version_number = object_version_number + 1,
2133: last_updated_by = fnd_global.user_id,
2134: last_update_date = SYSDATE,
2135: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
2136: WHERE
2137: payment_profile_id = p_payment_profile_id;
2138:
2139: ELSIF p_sequence_number = 2 THEN

Line 2145: reset_request_2 = fnd_global.CONC_REQUEST_ID,

2141: UPDATE iby_acct_pmt_profiles_b
2142: SET
2143: reset_value_2 = nvl(p_reset_value, reset_value_2),
2144: last_used_number_2 = nvl(p_reset_value, reset_value_2),
2145: reset_request_2 = fnd_global.CONC_REQUEST_ID,
2146: object_version_number = object_version_number + 1,
2147: last_updated_by = fnd_global.user_id,
2148: last_update_date = SYSDATE,
2149: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

Line 2147: last_updated_by = fnd_global.user_id,

2143: reset_value_2 = nvl(p_reset_value, reset_value_2),
2144: last_used_number_2 = nvl(p_reset_value, reset_value_2),
2145: reset_request_2 = fnd_global.CONC_REQUEST_ID,
2146: object_version_number = object_version_number + 1,
2147: last_updated_by = fnd_global.user_id,
2148: last_update_date = SYSDATE,
2149: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
2150: WHERE
2151: payment_profile_id = p_payment_profile_id;

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

2145: reset_request_2 = fnd_global.CONC_REQUEST_ID,
2146: object_version_number = object_version_number + 1,
2147: last_updated_by = fnd_global.user_id,
2148: last_update_date = SYSDATE,
2149: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
2150: WHERE
2151: payment_profile_id = p_payment_profile_id;
2152:
2153: ELSIF p_sequence_number = 3 THEN

Line 2159: reset_request_3 = fnd_global.CONC_REQUEST_ID,

2155: UPDATE iby_acct_pmt_profiles_b
2156: SET
2157: reset_value_3 = nvl(p_reset_value, reset_value_3),
2158: last_used_number_3 = nvl(p_reset_value, reset_value_3),
2159: reset_request_3 = fnd_global.CONC_REQUEST_ID,
2160: object_version_number = object_version_number + 1,
2161: last_updated_by = fnd_global.user_id,
2162: last_update_date = SYSDATE,
2163: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

Line 2161: last_updated_by = fnd_global.user_id,

2157: reset_value_3 = nvl(p_reset_value, reset_value_3),
2158: last_used_number_3 = nvl(p_reset_value, reset_value_3),
2159: reset_request_3 = fnd_global.CONC_REQUEST_ID,
2160: object_version_number = object_version_number + 1,
2161: last_updated_by = fnd_global.user_id,
2162: last_update_date = SYSDATE,
2163: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
2164: WHERE
2165: payment_profile_id = p_payment_profile_id;

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

2159: reset_request_3 = fnd_global.CONC_REQUEST_ID,
2160: object_version_number = object_version_number + 1,
2161: last_updated_by = fnd_global.user_id,
2162: last_update_date = SYSDATE,
2163: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
2164: WHERE
2165: payment_profile_id = p_payment_profile_id;
2166:
2167: END IF;