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.FV_TREASURY_PAYMENTS_PKG dependencies on AP_CHECKS

Line 11: g_checkrun_name ap_checks_all.checkrun_name%TYPE;

7: g_org_id fv_operating_units.org_id%TYPE;
8: g_treasury_conf_id fv_treasury_confirmations.treasury_confirmation_id%TYPE;
9: g_accounting_date fv_treasury_confirmations.treasury_doc_date%TYPE;
10: g_payment_instr_id iby_pay_instructions_all.payment_instruction_id%TYPE;
11: g_checkrun_name ap_checks_all.checkrun_name%TYPE;
12: x_err_code NUMBER;
13: x_err_stage VARCHAR2(2000);
14: --g_dit_flag VARCHAR2(1);
15: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 297: FROM ap_checks ac

293: l_check_tbl l_check_tbl_type;
294:
295: CURSOR cur_get_checks IS
296: SELECT ac.check_id
297: FROM ap_checks ac
298: ,fv_treasury_confirmations ftc
299: WHERE ftc.treasury_confirmation_id = g_treasury_conf_id
300: AND ftc.payment_instruction_id = ac.payment_instruction_id
301: AND ac.org_id = g_org_id

Line 307: ap_checks ac,

303:
304: CURSOR cur_corr_treas_pay_num IS
305: SELECT fto.corrected_treasury_pay_number, fto.check_id
306: FROM fv_tc_offsets fto,
307: ap_checks ac,
308: iby_pay_instructions_all ipa
309: WHERE ac.check_id = fto.check_id
310: AND ipa.payment_instruction_id = ac.payment_instruction_id
311: AND ipa.payment_instruction_id = g_payment_instr_id;

Line 436: -- Update ap_checks if a corrected treasury pay number

432: 'l_check_tbl(l_row_num).check_id:'||
433: l_check_tbl(l_row_num).check_id);
434: END IF;
435:
436: -- Update ap_checks if a corrected treasury pay number
437: -- for a payment within the batch being processed has been entered
438: UPDATE ap_checks c
439: SET treasury_pay_number = l_begin_doc,
440: treasury_pay_date = g_accounting_date,

Line 438: UPDATE ap_checks c

434: END IF;
435:
436: -- Update ap_checks if a corrected treasury pay number
437: -- for a payment within the batch being processed has been entered
438: UPDATE ap_checks c
439: SET treasury_pay_number = l_begin_doc,
440: treasury_pay_date = g_accounting_date,
441: last_update_date = SYSDATE,
442: last_updated_by = fnd_global.user_id,

Line 470: FROM ap_checks ac,

466: SYSDATE,
467: fnd_global.user_id,
468: fnd_global.login_id,
469: ac.org_id
470: FROM ap_checks ac,
471: ap_payment_history aph
472: WHERE ac.check_id = l_check_tbl(l_row_num).check_id
473: AND ac.void_date IS NOT NULL
474: AND (ac.checkrun_name IS NOT NULL OR ac.payment_id IS NOT NULL)

Line 501: UPDATE ap_checks

497: 'In corrected treasury pay number loop');
498: END IF;
499:
500: IF l_corr_treas_pay_num IS NOT NULL THEN
501: UPDATE ap_checks
502: SET treasury_pay_number = l_corr_treas_pay_num
503: WHERE check_id = l_offset_check_id;
504: END IF;
505: END LOOP;

Line 633: FROM ap_checks ac

629: l_reference_info XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO;
630:
631: CURSOR cur_get_payment_info(p_treasury_conf_id NUMBER) IS
632: SELECT distinct ac.legal_entity_id, ftc.event_id
633: FROM ap_checks ac
634: ,fv_treasury_confirmations ftc
635: WHERE ftc.treasury_confirmation_id = p_treasury_conf_id
636: AND ftc.payment_instruction_id = ac.payment_instruction_id
637: AND ac.org_id = g_org_id;

Line 647: ap_checks_all ac

643: FVC.check_id,
644: FTC.treasury_confirmation_id
645: FROM fv_voided_checks FVC,
646: fv_treasury_confirmations_all FTC,
647: ap_checks_all ac
648: WHERE
649: ftc.org_id = g_org_id
650: AND FVC.org_id = ftc.org_id
651: AND ac.org_id = FVC.org_id

Line 934: FROM fv_voided_checks fvc , ap_checks_all apchk,fv_treasury_confirmations_all fvtreas

930:
931: CURSOR cur_treas_conf
932: IS
933: SELECT max(fvtreas.TREASURY_CONFIRMATION_ID) TREASURY_CONFIRMATION_ID
934: FROM fv_voided_checks fvc , ap_checks_all apchk,fv_treasury_confirmations_all fvtreas
935: WHERE
936: apchk.org_id = g_org_id
937: AND apchk.org_id = fvtreas.org_id
938: AND apchk.check_id = fvc.check_id

Line 951: ap_checks_all ac

947: WHERE fc.processed_flag = 'U'
948: AND fc.org_id = g_org_id
949: and fc.check_id in ( select check_id
950: from fv_treasury_confirmations_all fvtreas ,
951: ap_checks_all ac
952: where fvtreas.org_id = g_org_id
953: and ac.org_id = fvtreas.org_id
954: and fvtreas.treasury_confirmation_id = p_treas_conf_id
955: and fvtreas.payment_instruction_id = ac.payment_instruction_id

Line 1005: FROM fv_voided_checks fvc , ap_checks_all apchk,

1001: FETCH unprocessed_event_cur into cur_event_id;
1002: EXIT WHEN unprocessed_event_cur%NOTFOUND;
1003:
1004: SELECT max(fvtreas.TREASURY_CONFIRMATION_ID) TREASURY_CONFIRMATION_ID into p_treasury_conf_id
1005: FROM fv_voided_checks fvc , ap_checks_all apchk,
1006: fv_treasury_confirmations_all fvtreas
1007: WHERE apchk.org_id = g_org_id
1008: AND apchk.org_id = fvtreas.org_id
1009: AND apchk.check_id = fvc.check_id

Line 1083: FROM ap_checks_all ac,

1079: SYSDATE,
1080: fnd_global.user_id,
1081: fnd_global.login_id,
1082: ac.org_id
1083: FROM ap_checks_all ac,
1084: fv_treasury_confirmations_all fvtc
1085: , ap_payment_history_all aph
1086: WHERE ac.org_id = g_org_id
1087: AND fvtc.org_id = ac.org_id

Line 1125: FROM ap_checks_all ac

1121:
1122: l_void_count:=0;
1123:
1124: SELECT COUNT(ac.check_id) INTO l_void_count
1125: FROM ap_checks_all ac
1126: ,fv_treasury_confirmations_all ftc
1127: , fv_voided_checks fvc
1128: WHERE ftc.treasury_confirmation_id = treas_conf_rec.TREASURY_CONFIRMATION_ID
1129: AND ftc.payment_instruction_id = ac.payment_instruction_id

Line 1171: ap_checks_all ac

1167: WHERE processed_flag = 'U'
1168: AND org_id = g_org_id
1169: and check_id in ( select check_id
1170: from fv_treasury_confirmations_all fvtreas ,
1171: ap_checks_all ac
1172: where
1173: fvtreas.org_id = g_org_id
1174: and ac.org_id = fvtreas.org_id
1175: and fvtreas.treasury_confirmation_id = treas_conf_rec.TREASURY_CONFIRMATION_ID