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 569: UPDATE iby_payments_all pmt

565: END IF;
566:
567: /*LKQ POS PAY - PAVAN */
568: -- payment level attribute setting
569: UPDATE iby_payments_all pmt
570: SET pmt.positive_pay_file_created_flag = 'Y'
571: WHERE pmt.payment_instruction_id = p_payment_instruction_id
572: AND pmt.payment_status = 'ISSUED'
573: AND (pmt.positive_pay_file_created_flag='N' or pmt.positive_pay_file_created_flag is NULL);

Line 622: UPDATE iby_payments_all

618: -- payment level attribute setting
619: iby_debug_pub.add(debug_msg => 'Payment Count : '|| l_paymentid_arr.COUNT,debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
620: IF ( l_paymentid_arr.COUNT <> 0) THEN
621: FOR i IN l_paymentid_arr.FIRST .. l_paymentid_arr.LAST LOOP
622: UPDATE iby_payments_all
623: SET positive_pay_file_created_flag = 'Y'
624: WHERE payment_id = l_paymentid_arr(i);
625: iby_debug_pub.add(debug_msg => 'Payment ID : '|| l_paymentid_arr(i),debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
626: END LOOP;

Line 644: FROM iby_payments_all pmt

640: IF (l_paymentinstrid_arr(i) IS NOT NULL ) THEN
641: UPDATE iby_pay_instructions_all ins
642: SET ins.positive_pay_file_created_flag = 'Y'
643: WHERE not exists (SELECT 'N'
644: FROM iby_payments_all pmt
645: WHERE nvl(pmt.positive_pay_file_created_flag,'N') = 'N'
646: AND pmt.payment_status IN('ISSUED', 'PAID')
647: AND pmt.payment_instruction_id = l_paymentinstrid_arr(i))
648: AND ins.payment_instruction_id = l_paymentinstrid_arr(i);

Line 942: UPDATE iby_payments_all

938:
939: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
940: iby_debug_pub.add(debug_msg => 'payment level attribute setting ' || p_payment_instruction_id, debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
941: END IF;
942: UPDATE iby_payments_all
943: SET positive_pay_file_created_flag = 'Y'
944: WHERE payment_instruction_id = p_payment_instruction_id
945: AND (positive_pay_file_created_flag='N' or positive_pay_file_created_flag is NULL)
946: AND payment_status IN ('ISSUED','PAID');

Line 958: UPDATE iby_payments_all

954:
955: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
956: iby_debug_pub.add(debug_msg => 'payment level attribute setting ' || p_payment_instruction_id, debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
957: END IF;
958: UPDATE iby_payments_all
959: SET positive_pay_file_created_flag = 'Y'
960: WHERE payment_instruction_id = p_payment_instruction_id
961: AND (positive_pay_file_created_flag='N' or positive_pay_file_created_flag is NULL)
962: AND payment_status IN ('ISSUED','PAID');

Line 980: UPDATE iby_payments_all

976:
977: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
978: iby_debug_pub.add(debug_msg => 'payment level attribute setting ' || p_payment_instruction_id, debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
979: END IF;
980: UPDATE iby_payments_all
981: SET positive_pay_file_created_flag = 'Y'
982: WHERE payment_instruction_id = p_payment_instruction_id
983: AND (positive_pay_file_created_flag='N' or positive_pay_file_created_flag is NULL)
984: AND payment_status IN ('VOID','ISSUED','PAID');

Line 997: UPDATE iby_payments_all

993:
994: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
995: iby_debug_pub.add(debug_msg => 'payment level attribute setting ' || p_payment_instruction_id, debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
996: END IF;
997: UPDATE iby_payments_all
998: SET positive_pay_file_created_flag = 'Y'
999: WHERE payment_instruction_id = p_payment_instruction_id
1000: AND payment_status IN ('VOID','ISSUED','PAID');
1001:

Line 1131: UPDATE iby_payments_all

1127:
1128: iby_debug_pub.add(debug_msg => 'Payment Count : '|| l_paymentid_arr.COUNT,debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
1129: IF ( l_paymentid_arr.COUNT <> 0) THEN
1130: FOR i IN l_paymentid_arr.FIRST .. l_paymentid_arr.LAST LOOP
1131: UPDATE iby_payments_all
1132: SET positive_pay_file_created_flag = 'Y'
1133: WHERE payment_id = l_paymentid_arr(i);
1134: iby_debug_pub.add(debug_msg => 'Payment ID : '|| l_paymentid_arr(i),debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
1135: END LOOP;

Line 1170: FROM iby_payments_all pmt

1166: IF (l_paymentinstrid_arr(i) IS NOT NULL ) THEN
1167: UPDATE iby_pay_instructions_all ins
1168: SET ins.positive_pay_file_created_flag = 'Y'
1169: WHERE not exists (SELECT 'N'
1170: FROM iby_payments_all pmt
1171: WHERE nvl(pmt.positive_pay_file_created_flag,'N') = 'N'
1172: AND pmt.payment_status IN('ISSUED', 'PAID')
1173: AND pmt.payment_instruction_id = l_paymentinstrid_arr(i))
1174: AND ins.payment_instruction_id = l_paymentinstrid_arr(i);

Line 1703: FROM iby_payments_all

1699: l_url VARCHAR2(2000);
1700:
1701: CURSOR l_pmt_csr (p_payment_id IN NUMBER) IS
1702: SELECT remit_to_location_id, party_site_id, payee_party_id
1703: FROM iby_payments_all
1704: WHERE payment_id = p_payment_id;
1705:
1706: CURSOR l_email_csr (p_owner_table_name IN VARCHAR2, p_owner_table_id IN NUMBER) IS
1707: SELECT email_address

Line 2490: FROM iby_payments_all

2486: l_payment_id NUMBER;
2487: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerIns_Denorm';
2488: CURSOR l_ins_payment_csr (p_payment_instruction_id IN NUMBER) IS
2489: SELECT payment_id
2490: FROM iby_payments_all
2491: WHERE payment_instruction_id = p_payment_instruction_id
2492: AND ROWNUM = 1;
2493:
2494: BEGIN

Line 2522: FROM iby_payments_all

2518: l_payment_id NUMBER;
2519: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccountIns_Denorm';
2520: CURSOR l_ins_payment_csr (p_payment_instruction_id IN NUMBER) IS
2521: SELECT payment_id
2522: FROM iby_payments_all
2523: WHERE payment_instruction_id = p_payment_instruction_id
2524: AND ROWNUM = 1;
2525:
2526: BEGIN

Line 2640: FROM iby_payments_all

2636: l_pmt_func VARCHAR2(1);
2637:
2638: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS
2639: SELECT nvl(employee_payment_flag, 'N')
2640: FROM iby_payments_all
2641: WHERE payment_id = p_payment_id;
2642:
2643: CURSOR l_payee_csr (p_payment_id IN NUMBER) IS
2644: SELECT payee

Line 2841: FROM iby_payments_all

2837: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount';
2838:
2839: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS
2840: SELECT nvl(employee_payment_flag, 'N')
2841: FROM iby_payments_all
2842: WHERE payment_id = p_payment_id;
2843:
2844: CURSOR l_payee_ba_csr (p_external_bank_account_id IN NUMBER) IS
2845: SELECT ext_bank_account

Line 2908: FROM iby_payments_all

2904: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayeeBankAccount_Denorm';
2905:
2906: CURSOR l_pmt_func_csr (p_payment_id IN NUMBER) IS
2907: SELECT nvl(employee_payment_flag, 'N')
2908: FROM iby_payments_all
2909: WHERE payment_id = p_payment_id;
2910:
2911: CURSOR l_payee_ba_csr (p_payment_id IN NUMBER) IS
2912: SELECT ext_bank_account

Line 3059: FROM iby_payments_all pmt, iby_pay_instructions_all ins,

3055: l_ps_territory VARCHAR2(60);
3056:
3057: CURSOR l_sra_setup_csr (p_payment_id IN NUMBER) IS
3058: SELECT sra_setup.sra_override_payee_flag, sra_setup.remit_advice_delivery_method
3059: FROM iby_payments_all pmt, iby_pay_instructions_all ins,
3060: iby_payment_profiles pp, iby_remit_advice_setup sra_setup
3061: WHERE pmt.payment_id = p_payment_id
3062: AND pmt.payment_instruction_id = ins.payment_instruction_id
3063: AND pp.payment_profile_id = ins.payment_profile_id

Line 3068: FROM iby_payments_all

3064: AND pp.system_profile_code = sra_setup.system_profile_code;
3065:
3066: CURSOR l_sra_req_flag_csr (p_payment_id IN NUMBER) IS
3067: SELECT separate_remit_advice_req_flag
3068: FROM iby_payments_all
3069: WHERE payment_id = p_payment_id;
3070:
3071: CURSOR l_lang_territory_csr (p_payment_id IN NUMBER) IS
3072: SELECT loc.language, loc.country

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

3069: WHERE payment_id = p_payment_id;
3070:
3071: CURSOR l_lang_territory_csr (p_payment_id IN NUMBER) IS
3072: SELECT loc.language, loc.country
3073: FROM hz_party_sites ps, hz_locations loc, iby_payments_all pmt
3074: WHERE payment_id = p_payment_id
3075: AND pmt.party_site_id = ps.party_site_id(+)
3076: AND loc.location_id = ps.location_id;
3077:

Line 3137: iby_payments_all pmt

3133: SELECT payee.remit_advice_delivery_method,
3134: payee.remit_advice_email,
3135: payee.remit_advice_fax
3136: FROM iby_external_payees_all payee,
3137: iby_payments_all pmt
3138: WHERE payee.payee_party_id = pmt.payee_party_id
3139: AND payee.payment_function = pmt.payment_function
3140: AND (payee.org_id is NULL OR (payee.org_id = pmt.org_id AND payee.org_type = pmt.org_type))
3141: AND (payee.party_site_id is NULL OR payee.party_site_id = pmt.party_site_id)

Line 3222: iby_payments_all pmt

3218:
3219: CURSOR l_ts_cur (p_payment_id NUMBER) IS
3220: SELECT fv.treasury_symbol
3221: FROM FV_TP_TS_AMT_DATA fv,
3222: iby_payments_all pmt
3223: WHERE pmt.payment_instruction_id = fv.payment_instruction_id
3224: AND pmt.payment_id = p_payment_id
3225: AND ROWNUM = 1;
3226:

Line 3411: FROM iby_payments_all pmt

3407:
3408: CURSOR l_amount_cur (p_payment_id NUMBER) IS
3409: SELECT pmt.payment_amount,
3410: pmt.payment_currency_code
3411: FROM iby_payments_all pmt
3412: WHERE pmt.payment_id = p_payment_id;
3413:
3414: BEGIN
3415:

Line 3597: FROM iby_payments_all

3593: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Update_Pmt_SRA_Attr_Prt';
3594:
3595: CURSOR l_pmt_csr (p_payment_instruction_id IN NUMBER) IS
3596: SELECT payment_id, payment_reference_number
3597: FROM iby_payments_all
3598: WHERE payment_instruction_id = p_payment_instruction_id
3599: -- note: this where clause should be kept
3600: -- in-sync with the where clause of l_payerinstr_sra_prt_csr
3601: -- in Get_Ins_PayerInstrAgg()

Line 3619: iby_payments_all

3615: module => l_Debug_Module);
3616: END IF;
3617:
3618: UPDATE
3619: iby_payments_all
3620: SET
3621: remit_advice_delivery_method = 'PRINTED',
3622: remit_advice_email = null,
3623: remit_advice_fax = null,

Line 3649: iby_payments_all

3645: BEGIN
3646:
3647: IF p_delivery_method = 'EMAIL' THEN
3648: UPDATE
3649: iby_payments_all
3650: SET
3651: remit_advice_delivery_method = p_delivery_method,
3652: remit_advice_email = p_recipient_email,
3653: remit_advice_fax = null,

Line 3661: iby_payments_all

3657: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
3658: WHERE payment_id = p_payment_id;
3659: ELSIF p_delivery_method = 'FAX' THEN
3660: UPDATE
3661: iby_payments_all
3662: SET
3663: remit_advice_delivery_method = p_delivery_method,
3664: remit_advice_email = null,
3665: remit_advice_fax = p_recipient_fax,

Line 3849: FROM iby_payments_all

3845: WHERE payment_instruction_id = p_payment_instruction_id;
3846:
3847: CURSOR l_amt_total_csr (p_payment_instruction_id IN NUMBER) IS
3848: SELECT SUM(payment_amount)
3849: FROM iby_payments_all
3850: WHERE payment_status in ('INSTRUCTION_CREATED', 'READY_TO_REPRINT',
3851: 'SUBMITTED_FOR_PRINTING', 'ISSUED', 'FORMATTED', 'TRANSMITTED')
3852: AND payment_instruction_id = p_payment_instruction_id;
3853: