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_DISBURSEMENT_SETUP_PUB dependencies on IBY_PMT_INSTR_USES_ALL

Line 854: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,

850: l_giv_op NUMBER; --Bug 14488642 Variable for given order of preference
851: l_cur_op NUMBER; --Variable for current order of preference
852:
853: CURSOR c_instr_assignment
854: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
855: ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
856: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
857: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
858: )

Line 855: ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,

851: l_cur_op NUMBER; --Variable for current order of preference
852:
853: CURSOR c_instr_assignment
854: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
855: ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
856: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
857: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
858: )
859: IS

Line 856: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,

852:
853: CURSOR c_instr_assignment
854: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
855: ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
856: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
857: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
858: )
859: IS
860: SELECT instrument_payment_use_id

Line 857: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE

853: CURSOR c_instr_assignment
854: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
855: ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
856: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
857: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
858: )
859: IS
860: SELECT instrument_payment_use_id
861: FROM iby_pmt_instr_uses_all

Line 861: FROM iby_pmt_instr_uses_all

857: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
858: )
859: IS
860: SELECT instrument_payment_use_id
861: FROM iby_pmt_instr_uses_all
862: WHERE (payment_flow = G_PMT_FLOW_DISBURSE)
863: AND ( (instrument_payment_use_id = NVL(ci_assign_id,-1))
864: OR (ext_pmt_party_id = ci_payee_id
865: AND instrument_type = ci_instr_type

Line 870: (ci_party_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,

866: AND instrument_id = ci_instr_id )
867: );
868:
869: CURSOR c_bnkacct_owner
870: (ci_party_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
871: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
872: )
873: IS
874: SELECT count(*)

Line 871: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE

867: );
868:
869: CURSOR c_bnkacct_owner
870: (ci_party_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
871: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
872: )
873: IS
874: SELECT count(*)
875: FROM IBY_ACCOUNT_OWNERS

Line 996: FROM iby_pmt_instr_uses_all

992: l_giv_op := p_assignment_attribs.Priority; --Bug 14488642
993: IF(x_assign_id IS NOT NULL) THEN
994: SELECT order_of_preference
995: INTO l_cur_op
996: FROM iby_pmt_instr_uses_all
997: WHERE instrument_payment_use_id = x_assign_id;
998: END IF;
999:
1000: -- only need to shift instrument priorities if this is a new instrument

Line 1006: UPDATE iby_pmt_instr_uses_all

1002: IF (x_assign_id IS NULL)
1003: THEN
1004: --Per bug 6851476
1005: --Eleminating the expensive CONNECT BY clause
1006: UPDATE iby_pmt_instr_uses_all
1007: SET order_of_preference = order_of_preference + 1,
1008: last_updated_by = fnd_global.user_id,
1009: last_update_date = SYSDATE,
1010: last_update_login = fnd_global.login_id,

Line 1020: UPDATE iby_pmt_instr_uses_all

1016: ELSE
1017: --Shifting priorities via API
1018: IF(p_assignment_attribs.Priority IS NOT NULL) THEN --Bug 13827657
1019: IF(l_cur_op > l_giv_op) THEN
1020: UPDATE iby_pmt_instr_uses_all
1021: SET order_of_preference = order_of_preference + 1,
1022: last_updated_by = fnd_global.user_id,
1023: last_update_date = SYSDATE,
1024: last_update_login = fnd_global.login_id

Line 1030: UPDATE iby_pmt_instr_uses_all

1026: AND payment_flow = G_PMT_FLOW_DISBURSE
1027: AND order_of_preference < l_cur_op
1028: AND order_of_preference >= l_giv_op ;
1029: ELSIF(l_cur_op < l_giv_op) THEN
1030: UPDATE iby_pmt_instr_uses_all
1031: SET order_of_preference = order_of_preference - 1,
1032: last_updated_by = fnd_global.user_id,
1033: last_update_date = SYSDATE,
1034: last_update_login = fnd_global.login_id

Line 1044: SELECT iby_pmt_instr_uses_all_s.nextval

1040: END IF;
1041: END IF;
1042:
1043: IF (x_assign_id IS NULL) THEN
1044: SELECT iby_pmt_instr_uses_all_s.nextval
1045: INTO x_assign_id
1046: FROM DUAL;
1047:
1048: INSERT INTO iby_pmt_instr_uses_all

Line 1048: INSERT INTO iby_pmt_instr_uses_all

1044: SELECT iby_pmt_instr_uses_all_s.nextval
1045: INTO x_assign_id
1046: FROM DUAL;
1047:
1048: INSERT INTO iby_pmt_instr_uses_all
1049: (instrument_payment_use_id,
1050: ext_pmt_party_id,
1051: instrument_type,
1052: instrument_id,

Line 1087: UPDATE iby_pmt_instr_uses_all

1083: SYSDATE,
1084: fnd_global.login_id,
1085: 1);
1086: ELSE
1087: UPDATE iby_pmt_instr_uses_all
1088: SET
1089: order_of_preference =
1090: NVL(p_assignment_attribs.Priority,order_of_preference),
1091: start_date = NVL(p_assignment_attribs.Start_Date,start_date),

Line 1205: (ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE)

1201:
1202: l_assign_count NUMBER := 0;
1203:
1204: CURSOR c_instr_assignments
1205: (ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE)
1206: IS
1207: SELECT instrument_payment_use_id,
1208: instrument_type,
1209: instrument_id,

Line 1213: FROM iby_pmt_instr_uses_all

1209: instrument_id,
1210: order_of_preference,
1211: start_date,
1212: end_date
1213: FROM iby_pmt_instr_uses_all
1214: WHERE (payment_flow = G_PMT_FLOW_DISBURSE)
1215: AND (ext_pmt_party_id = ci_payee_id);
1216:
1217: BEGIN

Line 1345: FROM iby_pmt_instr_uses_all u, iby_external_payees_all p

1341: CURSOR c_instr_assignments
1342: (ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)
1343: IS
1344: SELECT DISTINCT u.instrument_type, u.instrument_id
1345: FROM iby_pmt_instr_uses_all u, iby_external_payees_all p
1346: WHERE (u.payment_flow = G_PMT_FLOW_DISBURSE)
1347: AND (u.ext_pmt_party_id = p.ext_payee_id)
1348: AND (p.payee_party_id = ci_party_id);
1349: