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

Line 1126: l_instrtype IBY_PMT_INSTR_USES_ALL.instrument_type%TYPE;

1122:
1123: l_assign_id NUMBER;
1124: l_instr_id NUMBER;
1125: l_priority NUMBER;
1126: l_instrtype IBY_PMT_INSTR_USES_ALL.instrument_type%TYPE;
1127:
1128: l_bnkacct_owner_cnt NUMBER;
1129:
1130: -- for call to TCA hook

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

1139: -- lmallick (bugfix 8586083)
1140: -- Query the instrument_type as well, because this isn't passed to the API when the
1141: -- instrument assignment is passed.
1142: CURSOR c_instr_assignment
1143: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
1144: ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
1145: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
1146: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1147: )

Line 1144: ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,

1140: -- Query the instrument_type as well, because this isn't passed to the API when the
1141: -- instrument assignment is passed.
1142: CURSOR c_instr_assignment
1143: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
1144: ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
1145: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
1146: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1147: )
1148: IS

Line 1145: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,

1141: -- instrument assignment is passed.
1142: CURSOR c_instr_assignment
1143: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
1144: ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
1145: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
1146: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1147: )
1148: IS
1149: SELECT instrument_payment_use_id, instrument_type

Line 1146: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE

1142: CURSOR c_instr_assignment
1143: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
1144: ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
1145: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
1146: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1147: )
1148: IS
1149: SELECT instrument_payment_use_id, instrument_type
1150: FROM iby_pmt_instr_uses_all

Line 1150: FROM iby_pmt_instr_uses_all

1146: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1147: )
1148: IS
1149: SELECT instrument_payment_use_id, instrument_type
1150: FROM iby_pmt_instr_uses_all
1151: WHERE (payment_flow = G_PMT_FLOW_FNDCPT)
1152: -- [lmallick] - bug# 12570664
1153: -- This filter condition on payer_id should be fired always!
1154: -- Adding this as a mandatory filter condition and commenting

Line 1168: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE)

1164: -- [lmallick]: bug# 12570664
1165: -- New cursor to fetch the assignment attributes in case these
1166: -- were not set by the calling module.
1167: CURSOR c_assign_details
1168: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE)
1169: IS
1170: SELECT instrument_id, instrument_type
1171: FROM iby_pmt_instr_uses_all
1172: WHERE instrument_payment_use_id = ci_assign_id;

Line 1171: FROM iby_pmt_instr_uses_all

1167: CURSOR c_assign_details
1168: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE)
1169: IS
1170: SELECT instrument_id, instrument_type
1171: FROM iby_pmt_instr_uses_all
1172: WHERE instrument_payment_use_id = ci_assign_id;
1173:
1174:
1175: CURSOR c_bnkacct_owner

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

1172: WHERE instrument_payment_use_id = ci_assign_id;
1173:
1174:
1175: CURSOR c_bnkacct_owner
1176: (ci_party_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
1177: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1178: )
1179: IS
1180: SELECT count(*)

Line 1177: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE

1173:
1174:
1175: CURSOR c_bnkacct_owner
1176: (ci_party_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
1177: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
1178: )
1179: IS
1180: SELECT count(*)
1181: FROM IBY_ACCOUNT_OWNERS

Line 1328: FROM iby_pmt_instr_uses_all instr

1324: * If no assingment exists, then priority would be 1
1325: */
1326:
1327: SELECT NVL(MAX(order_of_preference),0)+1 INTO l_priority
1328: FROM iby_pmt_instr_uses_all instr
1329: WHERE instr.ext_pmt_party_id = l_payer_id
1330: AND instr.instrument_type = l_instrtype
1331: AND instr.payment_flow = G_PMT_FLOW_FNDCPT;
1332:

Line 1346: UPDATE iby_pmt_instr_uses_all

1342: --Skipping execution with the expensive CONNECT BY clause
1343: --when p_assignment_attribs.Priority is NULL or 1,
1344: --also l_priority gets 1 when p_assignment_attribs.Priority is NULL
1345:
1346: UPDATE iby_pmt_instr_uses_all
1347: SET order_of_preference = order_of_preference + 1,
1348: last_updated_by = fnd_global.user_id,
1349: last_update_date = trunc(SYSDATE),
1350: last_update_login = fnd_global.login_id,

Line 1365: SELECT iby_pmt_instr_uses_all_s.nextval

1361:
1362: l_last_update := SYSDATE;
1363:
1364: IF (x_assign_id IS NULL) THEN
1365: SELECT iby_pmt_instr_uses_all_s.nextval
1366: INTO x_assign_id
1367: FROM DUAL;
1368:
1369: INSERT INTO iby_pmt_instr_uses_all

Line 1369: INSERT INTO iby_pmt_instr_uses_all

1365: SELECT iby_pmt_instr_uses_all_s.nextval
1366: INTO x_assign_id
1367: FROM DUAL;
1368:
1369: INSERT INTO iby_pmt_instr_uses_all
1370: (instrument_payment_use_id, ext_pmt_party_id, instrument_type,
1371: instrument_id, payment_function, payment_flow, order_of_preference,
1372: debit_auth_flag, debit_auth_method, debit_auth_reference,
1373: debit_auth_begin, debit_auth_end, start_date, end_date,

Line 1389: UPDATE iby_pmt_instr_uses_all

1385: fnd_global.login_id, 1);
1386:
1387: l_op_type := 'I';
1388: ELSE
1389: UPDATE iby_pmt_instr_uses_all
1390: SET
1391: order_of_preference =
1392: NVL(p_assignment_attribs.Priority,order_of_preference),
1393: start_date = NVL(p_assignment_attribs.Start_Date,start_date),

Line 1418: FROM iby_pmt_instr_uses_all

1414: END IF;
1415:
1416: SELECT instrument_type
1417: INTO l_instr_type
1418: FROM iby_pmt_instr_uses_all
1419: WHERE instrument_payment_use_id = x_assign_id;
1420:
1421: IF (l_instr_type = 'BANKACCOUNT') THEN
1422: SELECT party_type INTO l_party_type

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

1512: l_assign_count NUMBER := 0;
1513: l_prev_msg_count NUMBER;
1514:
1515: CURSOR c_instr_assignments
1516: (ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE)
1517: IS
1518: SELECT instrument_payment_use_id, instrument_type, instrument_id,
1519: order_of_preference, start_date, end_date
1520: FROM iby_pmt_instr_uses_all

Line 1520: FROM iby_pmt_instr_uses_all

1516: (ci_payer_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE)
1517: IS
1518: SELECT instrument_payment_use_id, instrument_type, instrument_id,
1519: order_of_preference, start_date, end_date
1520: FROM iby_pmt_instr_uses_all
1521: WHERE (payment_flow = G_PMT_FLOW_FNDCPT)
1522: AND (ext_pmt_party_id = ci_payer_id);
1523:
1524: BEGIN

Line 1637: FROM iby_pmt_instr_uses_all u, iby_external_payers_all p

1633: CURSOR c_instr_assignments
1634: (ci_party_id IN iby_external_payers_all.party_id%TYPE)
1635: IS
1636: SELECT DISTINCT u.instrument_type, u.instrument_id
1637: FROM iby_pmt_instr_uses_all u, iby_external_payers_all p
1638: WHERE (u.payment_flow = G_PMT_FLOW_FNDCPT)
1639: AND (u.ext_pmt_party_id = p.ext_payer_id)
1640: AND (p.party_id = ci_party_id);
1641:

Line 1781: IBY_PMT_INSTR_USES_ALL inst,

1777: CUST_ACCOUNT_ID,
1778: RANK() OVER (PARTITION BY INSTRUMENT_TYPE, INSTRUMENT_ID
1779: ORDER BY ACCT_SITE_USE_ID, CUST_ACCOUNT_ID,ORDER_OF_PREFERENCE,INSTRUMENT_PAYMENT_USE_ID) DUP_RANK
1780: FROM
1781: IBY_PMT_INSTR_USES_ALL inst,
1782: IBY_EXTERNAL_PAYERS_ALL payer
1783: WHERE
1784: (inst.PAYMENT_FLOW = G_PMT_FLOW_FNDCPT)
1785: AND inst.INSTRUMENT_TYPE = NVL(ci_instrument_type ,INSTRUMENT_TYPE)