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_EXTRACT_GEN_PVT dependencies on IBY_PAYMENTS_ALL

Line 771: UPDATE iby_payments_all pmt

767: END IF;
768:
769: /*LKQ POS PAY - PAVAN */
770: -- payment level attribute setting
771: UPDATE iby_payments_all pmt
772: SET pmt.positive_pay_file_created_flag = 'Y'
773: WHERE pmt.payment_instruction_id = p_payment_instruction_id
774: AND pmt.payment_status = 'ISSUED'
775: AND (pmt.positive_pay_file_created_flag='N' or pmt.positive_pay_file_created_flag is NULL);

Line 822: UPDATE iby_payments_all

818: -- payment level attribute setting
819: iby_debug_pub.add(debug_msg => 'Payment Count : '|| l_paymentid_arr.COUNT,debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
820: IF ( l_paymentid_arr.COUNT <> 0) THEN
821: FOR i IN l_paymentid_arr.FIRST .. l_paymentid_arr.LAST LOOP
822: UPDATE iby_payments_all
823: SET positive_pay_file_created_flag = 'Y'
824: WHERE payment_id = l_paymentid_arr(i);
825: iby_debug_pub.add(debug_msg => 'Payment ID : '|| l_paymentid_arr(i),debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
826: END LOOP;

Line 844: FROM iby_payments_all pmt

840: IF (l_paymentinstrid_arr(i) IS NOT NULL ) THEN
841: UPDATE iby_pay_instructions_all ins
842: SET ins.positive_pay_file_created_flag = 'Y'
843: WHERE not exists (SELECT 'N'
844: FROM iby_payments_all pmt
845: WHERE nvl(pmt.positive_pay_file_created_flag,'N') = 'N'
846: AND pmt.payment_status IN('ISSUED', 'PAID')
847: AND pmt.payment_instruction_id = l_paymentinstrid_arr(i))
848: AND ins.payment_instruction_id = l_paymentinstrid_arr(i);

Line 1216: UPDATE iby_payments_all

1212:
1213: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1214: iby_debug_pub.add(debug_msg => 'payment level attribute setting ' || p_payment_instruction_id, debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
1215: END IF;
1216: UPDATE iby_payments_all
1217: SET positive_pay_file_created_flag = 'Y'
1218: WHERE payment_instruction_id = p_payment_instruction_id
1219: AND (positive_pay_file_created_flag='N' or positive_pay_file_created_flag is NULL)
1220: AND payment_status IN ('ISSUED','PAID');

Line 1232: UPDATE iby_payments_all

1228:
1229: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1230: iby_debug_pub.add(debug_msg => 'payment level attribute setting ' || p_payment_instruction_id, debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
1231: END IF;
1232: UPDATE iby_payments_all
1233: SET positive_pay_file_created_flag = 'Y'
1234: WHERE payment_instruction_id = p_payment_instruction_id
1235: AND (positive_pay_file_created_flag='N' or positive_pay_file_created_flag is NULL)
1236: AND payment_status IN ('ISSUED','PAID');

Line 1254: UPDATE iby_payments_all

1250:
1251: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1252: iby_debug_pub.add(debug_msg => 'payment level attribute setting ' || p_payment_instruction_id, debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
1253: END IF;
1254: UPDATE iby_payments_all
1255: SET positive_pay_file_created_flag = 'Y'
1256: WHERE payment_instruction_id = p_payment_instruction_id
1257: AND (positive_pay_file_created_flag='N' or positive_pay_file_created_flag is NULL)
1258: AND payment_status IN ('VOID');

Line 1271: UPDATE iby_payments_all

1267:
1268: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1269: iby_debug_pub.add(debug_msg => 'payment level attribute setting ' || p_payment_instruction_id, debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
1270: END IF;
1271: UPDATE iby_payments_all
1272: SET positive_pay_file_created_flag = 'Y'
1273: WHERE payment_instruction_id = p_payment_instruction_id
1274: AND payment_status IN ('VOID');
1275:

Line 1292: UPDATE iby_payments_all

1288:
1289: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1290: iby_debug_pub.add(debug_msg => 'payment level attribute setting ' || p_payment_instruction_id, debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
1291: END IF;
1292: UPDATE iby_payments_all
1293: SET positive_pay_file_created_flag = 'Y'
1294: WHERE payment_instruction_id = p_payment_instruction_id
1295: AND (positive_pay_file_created_flag='N' or positive_pay_file_created_flag is NULL)
1296: AND payment_status IN ('VOID','ISSUED','PAID');

Line 1309: UPDATE iby_payments_all

1305:
1306: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1307: iby_debug_pub.add(debug_msg => 'payment level attribute setting ' || p_payment_instruction_id, debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
1308: END IF;
1309: UPDATE iby_payments_all
1310: SET positive_pay_file_created_flag = 'Y'
1311: WHERE payment_instruction_id = p_payment_instruction_id
1312: AND payment_status IN ('VOID','ISSUED','PAID');
1313:

Line 1486: UPDATE iby_payments_all

1482:
1483: iby_debug_pub.add(debug_msg => 'Payment Count : '|| l_paymentid_arr.COUNT,debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
1484: IF ( l_paymentid_arr.COUNT <> 0) THEN
1485: FOR i IN l_paymentid_arr.FIRST .. l_paymentid_arr.LAST LOOP
1486: UPDATE iby_payments_all
1487: SET positive_pay_file_created_flag = 'Y'
1488: WHERE payment_id = l_paymentid_arr(i);
1489: iby_debug_pub.add(debug_msg => 'Payment ID : '|| l_paymentid_arr(i),debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
1490: END LOOP;

Line 1551: FROM iby_payments_all pmt

1547: IF (l_paymentinstrid_arr(i) IS NOT NULL ) THEN
1548: UPDATE iby_pay_instructions_all ins
1549: SET ins.positive_pay_file_created_flag = 'Y'
1550: WHERE not exists (SELECT 'N'
1551: FROM iby_payments_all pmt
1552: WHERE nvl(pmt.positive_pay_file_created_flag,'N') = 'N'
1553: AND pmt.payment_status IN('ISSUED', 'PAID')
1554: AND pmt.payment_instruction_id = l_paymentinstrid_arr(i))
1555: AND ins.payment_instruction_id = l_paymentinstrid_arr(i);

Line 2252: FROM iby_payments_all

2248: l_url VARCHAR2(2000);
2249:
2250: CURSOR l_pmt_csr (p_payment_id IN NUMBER) IS
2251: SELECT remit_to_location_id, party_site_id, payee_party_id
2252: FROM iby_payments_all
2253: WHERE payment_id = p_payment_id;
2254:
2255: CURSOR l_email_csr (p_owner_table_name IN VARCHAR2, p_owner_table_id IN NUMBER) IS
2256: SELECT email_address

Line 2375: ,p_remit_to_location_id IN iby_payments_all.remit_to_location_id%TYPE

2371: /* Overloaded Function : Citi Perf */
2372: /* Also adding caching for Payee Contact. Given type of party or party_site
2373: we will be able to get the email,phone, fax details.*/
2374: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER
2375: ,p_remit_to_location_id IN iby_payments_all.remit_to_location_id%TYPE
2376: ,p_party_site_id IN iby_payments_all.party_site_id%TYPE
2377: ,p_payee_party_id IN iby_payments_all.payee_party_id%TYPE)
2378: RETURN XMLTYPE
2379: IS

Line 2376: ,p_party_site_id IN iby_payments_all.party_site_id%TYPE

2372: /* Also adding caching for Payee Contact. Given type of party or party_site
2373: we will be able to get the email,phone, fax details.*/
2374: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER
2375: ,p_remit_to_location_id IN iby_payments_all.remit_to_location_id%TYPE
2376: ,p_party_site_id IN iby_payments_all.party_site_id%TYPE
2377: ,p_payee_party_id IN iby_payments_all.payee_party_id%TYPE)
2378: RETURN XMLTYPE
2379: IS
2380: l_contactinfo XMLTYPE;

Line 2377: ,p_payee_party_id IN iby_payments_all.payee_party_id%TYPE)

2373: we will be able to get the email,phone, fax details.*/
2374: FUNCTION Get_PayeeContact(p_payment_id IN NUMBER
2375: ,p_remit_to_location_id IN iby_payments_all.remit_to_location_id%TYPE
2376: ,p_party_site_id IN iby_payments_all.party_site_id%TYPE
2377: ,p_payee_party_id IN iby_payments_all.payee_party_id%TYPE)
2378: RETURN XMLTYPE
2379: IS
2380: l_contactinfo XMLTYPE;
2381: l_remit_to_loc_id NUMBER;

Line 2396: FROM iby_payments_all

2392:
2393: /*
2394: CURSOR l_pmt_csr (p_payment_id IN NUMBER) IS
2395: SELECT remit_to_location_id, party_site_id, payee_party_id
2396: FROM iby_payments_all
2397: WHERE payment_id = p_payment_id;
2398: */
2399:
2400: CURSOR l_email_csr (p_owner_table_name IN VARCHAR2, p_owner_table_id IN NUMBER) IS

Line 3337: FROM iby_payments_all

3333: l_payment_id NUMBER;
3334: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerIns_Denorm';
3335: CURSOR l_ins_payment_csr (p_payment_instruction_id IN NUMBER) IS
3336: SELECT payment_id
3337: FROM iby_payments_all
3338: WHERE payment_instruction_id = p_payment_instruction_id
3339: AND ROWNUM = 1;
3340:
3341: BEGIN

Line 3382: FROM iby_payments_all

3378:
3379: /*Bug 8662990 - sort by payment_id to get a non void-by-overflow payment*/
3380: CURSOR l_ins_payment_csr (p_payment_instruction_id IN NUMBER) IS
3381: SELECT min(payment_id)
3382: FROM iby_payments_all
3383: WHERE payment_instruction_id = p_payment_instruction_id;
3384:
3385: BEGIN
3386: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3546: FROM iby_payments_all

3542: l_pmt_func VARCHAR2(1);
3543:
3544: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS
3545: SELECT nvl(employee_payment_flag, 'N')
3546: FROM iby_payments_all
3547: WHERE payment_id = p_payment_id;
3548:
3549: CURSOR l_payee_csr (p_payment_id IN NUMBER) IS
3550: SELECT payee

Line 3616: FROM iby_payments_all

3612: l_pmt_func VARCHAR2(1);
3613:
3614: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS
3615: SELECT nvl(employee_payment_flag, 'N')
3616: FROM iby_payments_all
3617: WHERE payment_id = p_payment_id;
3618:
3619: CURSOR l_payee_csr (p_payment_id IN NUMBER) IS
3620: SELECT payee

Line 3846: FROM iby_payments_all

3842: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount';
3843:
3844: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS
3845: SELECT nvl(employee_payment_flag, 'N')
3846: FROM iby_payments_all
3847: WHERE payment_id = p_payment_id;
3848:
3849: CURSOR l_payee_ba_csr (p_external_bank_account_id IN NUMBER) IS
3850: SELECT ext_bank_account

Line 3913: FROM iby_payments_all

3909: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount_Denorm 2 input param';
3910:
3911: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS
3912: SELECT nvl(employee_payment_flag, 'N')
3913: FROM iby_payments_all
3914: WHERE payment_id = p_payment_id;
3915:
3916: CURSOR l_payee_ba_csr (p_payment_id IN NUMBER) IS
3917: SELECT ext_bank_account

Line 3994: FROM iby_payments_all

3990: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount_Denorm 3 input param';
3991:
3992: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS
3993: SELECT nvl(employee_payment_flag, 'N')
3994: FROM iby_payments_all
3995: WHERE payment_id = p_payment_id;
3996:
3997: CURSOR l_payee_ba_csr (p_payment_id IN NUMBER) IS
3998: SELECT ext_bank_account

Line 4268: FROM iby_payments_all pmt, iby_pay_instructions_all ins,

4264: l_email_sub VARCHAR2(2000);
4265:
4266: CURSOR l_sra_setup_csr (p_payment_id IN NUMBER) IS
4267: SELECT sra_setup.sra_override_payee_flag, sra_setup.remit_advice_delivery_method
4268: FROM iby_payments_all pmt, iby_pay_instructions_all ins,
4269: iby_payment_profiles pp, iby_remit_advice_setup sra_setup
4270: WHERE pmt.payment_id = p_payment_id
4271: AND pmt.payment_instruction_id = ins.payment_instruction_id
4272: AND pp.payment_profile_id = ins.payment_profile_id

Line 4277: FROM iby_payments_all

4273: AND pp.system_profile_code = sra_setup.system_profile_code;
4274:
4275: CURSOR l_sra_req_flag_csr (p_payment_id IN NUMBER) IS
4276: SELECT separate_remit_advice_req_flag
4277: FROM iby_payments_all
4278: WHERE payment_id = p_payment_id;
4279:
4280: --Changing for bug 9686312.
4281: --Adding fnd_languages table to fetch language country in

Line 4285: FROM hz_party_sites ps, hz_locations loc, iby_payments_all pmt

4281: --Adding fnd_languages table to fetch language country in
4282: --ISO standard.
4283: CURSOR l_lang_territory_csr (p_payment_id IN NUMBER) IS
4284: SELECT fl.language_code , loc.country
4285: FROM hz_party_sites ps, hz_locations loc, iby_payments_all pmt
4286: , fnd_languages fl
4287: WHERE payment_id = p_payment_id
4288: AND fl.language_code = loc.language
4289: AND pmt.party_site_id = ps.party_site_id(+)

Line 4295: FROM iby_payments_all pmt

4291: -- End of bug 9686312.
4292:
4293: CURSOR l_payment_details_csr (p_payment_id IN NUMBER) IS
4294: SELECT pmt.payment_reference_number, pmt.paper_document_number
4295: FROM iby_payments_all pmt
4296: WHERE pmt.payment_id = p_payment_id;
4297:
4298: BEGIN
4299:

Line 4376: iby_payments_all pmt

4372: SELECT payee.remit_advice_delivery_method,
4373: payee.remit_advice_email,
4374: payee.remit_advice_fax
4375: FROM iby_external_payees_all payee,
4376: iby_payments_all pmt
4377: WHERE payee.payee_party_id = pmt.payee_party_id
4378: AND payee.payment_function = pmt.payment_function
4379: AND (payee.org_id is NULL OR (payee.org_id = pmt.org_id AND payee.org_type = pmt.org_type))
4380: AND (payee.party_site_id is NULL OR payee.party_site_id = pmt.party_site_id)

Line 4461: iby_payments_all pmt

4457:
4458: CURSOR l_ts_cur (p_payment_id NUMBER) IS
4459: SELECT fv.treasury_symbol
4460: FROM FV_TP_TS_AMT_DATA fv,
4461: iby_payments_all pmt
4462: WHERE pmt.payment_instruction_id = fv.payment_instruction_id
4463: AND pmt.payment_id = p_payment_id
4464: AND ROWNUM = 1;
4465:

Line 4650: FROM iby_payments_all pmt

4646:
4647: CURSOR l_amount_cur (p_payment_id NUMBER) IS
4648: SELECT pmt.payment_amount,
4649: pmt.payment_currency_code
4650: FROM iby_payments_all pmt
4651: WHERE pmt.payment_id = p_payment_id;
4652:
4653: BEGIN
4654:

Line 4836: FROM iby_payments_all

4832: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Update_Pmt_SRA_Attr_Prt';
4833:
4834: CURSOR l_pmt_csr (p_payment_instruction_id IN NUMBER) IS
4835: SELECT payment_id, payment_reference_number
4836: FROM iby_payments_all
4837: WHERE payment_instruction_id = p_payment_instruction_id
4838: -- note: this where clause should be kept
4839: -- in-sync with the where clause of l_payerinstr_sra_prt_csr
4840: -- in Get_Ins_PayerInstrAgg()

Line 4858: iby_payments_all

4854: module => l_Debug_Module);
4855: END IF;
4856:
4857: UPDATE
4858: iby_payments_all
4859: SET
4860: remit_advice_delivery_method = 'PRINTED',
4861: remit_advice_email = null,
4862: remit_advice_fax = null,

Line 4888: iby_payments_all

4884: BEGIN
4885:
4886: IF p_delivery_method = 'EMAIL' THEN
4887: UPDATE
4888: iby_payments_all
4889: SET
4890: remit_advice_delivery_method = p_delivery_method,
4891: remit_advice_email = p_recipient_email,
4892: remit_advice_fax = null,

Line 4900: iby_payments_all

4896: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
4897: WHERE payment_id = p_payment_id;
4898: ELSIF p_delivery_method = 'FAX' THEN
4899: UPDATE
4900: iby_payments_all
4901: SET
4902: remit_advice_delivery_method = p_delivery_method,
4903: remit_advice_email = null,
4904: remit_advice_fax = p_recipient_fax,

Line 5378: FROM iby_payments_all

5374: WHERE payment_instruction_id = p_payment_instruction_id;
5375:
5376: CURSOR l_amt_total_csr (p_payment_instruction_id IN NUMBER) IS
5377: SELECT SUM(payment_amount)
5378: FROM iby_payments_all
5379: WHERE payment_status in ('INSTRUCTION_CREATED', 'READY_TO_REPRINT',
5380: 'SUBMITTED_FOR_PRINTING', 'ISSUED', 'FORMATTED', 'TRANSMITTED')
5381: AND payment_instruction_id = p_payment_instruction_id;
5382:

Line 5876: iby_payments_all pmt,

5872: cursor get_Assignments(c_payment_id NUMBER,
5873: c_ext_bank_account_id NUMBER) is
5874: SELECT instr.instrument_payment_use_id, instr.attribute_category
5875: FROM iby_pmt_instr_uses_all instr,
5876: iby_payments_all pmt,
5877: iby_external_payees_all payee
5878: WHERE instr.instrument_id = c_ext_bank_account_id
5879: AND InStr.instrument_type = 'BANKACCOUNT'
5880: AND InStr.payment_flow = 'DISBURSEMENTS'