APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_PMT_INSTR_USES_ALL

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

1043: l_party_type VARCHAR2(50);
1044: l_instr_type VARCHAR2(50);
1045:
1046: CURSOR c_instr_assignment
1047: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
1048: ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
1049: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
1050: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1051: )

Line 1048: ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,

1044: l_instr_type VARCHAR2(50);
1045:
1046: CURSOR c_instr_assignment
1047: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
1048: ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
1049: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
1050: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1051: )
1052: IS

Line 1049: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,

1045:
1046: CURSOR c_instr_assignment
1047: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
1048: ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
1049: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
1050: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1051: )
1052: IS
1053: SELECT instrument_payment_use_id

Line 1050: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE

1046: CURSOR c_instr_assignment
1047: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
1048: ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
1049: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
1050: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1051: )
1052: IS
1053: SELECT instrument_payment_use_id
1054: FROM iby_pmt_instr_uses_all

Line 1054: FROM iby_pmt_instr_uses_all

1050: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1051: )
1052: IS
1053: SELECT instrument_payment_use_id
1054: FROM iby_pmt_instr_uses_all
1055: WHERE (payment_flow = G_PMT_FLOW_FNDCPT)
1056: AND ( (instrument_payment_use_id = NVL(ci_assign_id,-1))
1057: OR (ext_pmt_party_id = ci_payer_id
1058: AND instrument_type = ci_instr_type

Line 1157: UPDATE iby_pmt_instr_uses_all

1153: IF (x_assign_id IS NULL) OR
1154: ((NOT x_assign_id IS NULL) AND (NOT p_assignment_attribs.Priority IS NULL))
1155: THEN
1156:
1157: UPDATE iby_pmt_instr_uses_all
1158: SET order_of_preference = order_of_preference + 1,
1159: last_updated_by = fnd_global.user_id,
1160: last_update_date = SYSDATE,
1161: last_update_login = fnd_global.login_id,

Line 1166: FROM iby_pmt_instr_uses_all

1162: object_version_number = object_version_number + 1
1163: WHERE instrument_payment_use_id IN
1164: (
1165: SELECT instrument_payment_use_id
1166: FROM iby_pmt_instr_uses_all
1167: WHERE (ext_pmt_party_id = l_payer_id)
1168: AND (payment_flow = G_PMT_FLOW_FNDCPT)
1169: START WITH order_of_preference = l_priority
1170: AND (ext_pmt_party_id = l_payer_id)

Line 1182: SELECT iby_pmt_instr_uses_all_s.nextval

1178:
1179: l_last_update := SYSDATE;
1180:
1181: IF (x_assign_id IS NULL) THEN
1182: SELECT iby_pmt_instr_uses_all_s.nextval
1183: INTO x_assign_id
1184: FROM DUAL;
1185:
1186: INSERT INTO iby_pmt_instr_uses_all

Line 1186: INSERT INTO iby_pmt_instr_uses_all

1182: SELECT iby_pmt_instr_uses_all_s.nextval
1183: INTO x_assign_id
1184: FROM DUAL;
1185:
1186: INSERT INTO iby_pmt_instr_uses_all
1187: (instrument_payment_use_id, ext_pmt_party_id, instrument_type,
1188: instrument_id, payment_function, payment_flow, order_of_preference,
1189: debit_auth_flag, debit_auth_method, debit_auth_reference,
1190: debit_auth_begin, debit_auth_end, start_date, end_date,

Line 1206: UPDATE iby_pmt_instr_uses_all

1202: fnd_global.login_id, 1);
1203:
1204: l_op_type := 'I';
1205: ELSE
1206: UPDATE iby_pmt_instr_uses_all
1207: SET
1208: order_of_preference =
1209: NVL(p_assignment_attribs.Priority,order_of_preference),
1210: start_date = NVL(p_assignment_attribs.Start_Date,start_date),

Line 1235: FROM iby_pmt_instr_uses_all

1231: END IF;
1232:
1233: SELECT instrument_type
1234: INTO l_instr_type
1235: FROM iby_pmt_instr_uses_all
1236: WHERE instrument_payment_use_id = x_assign_id;
1237:
1238: IF (l_instr_type = 'BANKACCOUNT') THEN
1239: SELECT party_type INTO l_party_type

Line 1333: (ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE)

1329: l_assign_count NUMBER := 0;
1330: l_prev_msg_count NUMBER;
1331:
1332: CURSOR c_instr_assignments
1333: (ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE)
1334: IS
1335: SELECT instrument_payment_use_id, instrument_type, instrument_id,
1336: order_of_preference, start_date, end_date
1337: FROM iby_pmt_instr_uses_all

Line 1337: FROM iby_pmt_instr_uses_all

1333: (ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE)
1334: IS
1335: SELECT instrument_payment_use_id, instrument_type, instrument_id,
1336: order_of_preference, start_date, end_date
1337: FROM iby_pmt_instr_uses_all
1338: WHERE (payment_flow = G_PMT_FLOW_FNDCPT)
1339: AND (ext_pmt_party_id = ci_payer_id);
1340:
1341: BEGIN

Line 1454: FROM iby_pmt_instr_uses_all u, iby_external_payers_all p

1450: CURSOR c_instr_assignments
1451: (ci_party_id IN iby_external_payers_all.party_id%TYPE)
1452: IS
1453: SELECT DISTINCT u.instrument_type, u.instrument_id
1454: FROM iby_pmt_instr_uses_all u, iby_external_payers_all p
1455: WHERE (u.payment_flow = G_PMT_FLOW_FNDCPT)
1456: AND (u.ext_pmt_party_id = p.ext_payer_id)
1457: AND (p.party_id = ci_party_id);
1458:

Line 1582: FROM iby_pmt_instr_uses_all

1578: FROM (SELECT instrument_payment_use_id, instrument_type, instrument_id,
1579: order_of_preference, start_date, end_date,
1580: rank() over (partition by instrument_type, instrument_id
1581: order by order_of_preference, instrument_payment_use_id) dup_rank
1582: FROM iby_pmt_instr_uses_all
1583: WHERE (payment_flow = G_PMT_FLOW_FNDCPT)
1584: AND instrument_type = NVL(ci_instrument_type,instrument_type)
1585: AND sysdate >= start_date
1586: AND sysdate < NVL(end_date, sysdate+1)