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 301: FROM ap_checks ac

297: l_check_tbl l_check_tbl_type;
298:
299: CURSOR cur_get_checks IS
300: SELECT ac.check_id
301: FROM ap_checks ac
302: ,fv_treasury_confirmations ftc
303: WHERE ftc.treasury_confirmation_id = g_treasury_conf_id
304: AND ftc.payment_instruction_id = ac.payment_instruction_id
305: AND ac.org_id = g_org_id;

Line 310: ap_checks ac,

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

Line 439: UPDATE ap_checks c

435: 'l_check_tbl(l_row_num).check_id:'||
436: l_check_tbl(l_row_num).check_id);
437: END IF;
438:
439: UPDATE ap_checks c
440: SET treasury_pay_number = l_begin_doc,
441: treasury_pay_date = g_accounting_date,
442: last_update_date = SYSDATE,
443: last_updated_by = fnd_global.user_id,

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

448: l_begin_doc := l_begin_doc +1;
449: END LOOP;
450: END LOOP;
451:
452: -- Update ap_checks if a corrected treasury pay number
453: -- for a payment within the batch being processed has been entered
454: OPEN cur_corr_treas_pay_num;
455: LOOP
456: FETCH cur_corr_treas_pay_num INTO l_corr_treas_pay_num, l_offset_check_id;

Line 465: UPDATE ap_checks

461: 'In corrected treasury pay number loop');
462: END IF;
463:
464: IF l_corr_treas_pay_num IS NOT NULL THEN
465: UPDATE ap_checks
466: SET treasury_pay_number = l_corr_treas_pay_num
467: WHERE check_id = l_offset_check_id;
468: END IF;
469: END LOOP;

Line 488: FROM ap_checks_all ac

484: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
485: 'Treasury Confirmation Successful. Checking for Voided Checks');
486:
487: SELECT COUNT(ac.check_id) INTO l_void_count
488: FROM ap_checks_all ac
489: ,fv_treasury_confirmations_all ftc
490: WHERE ftc.treasury_confirmation_id = g_treasury_conf_id
491: AND ftc.payment_instruction_id = ac.payment_instruction_id
492: AND ac.org_id = g_org_id

Line 528: FROM ap_checks_all ac,

524: fnd_global.user_id,
525: fnd_global.login_id,
526: ac.org_id,
527: g_payment_instr_id
528: FROM ap_checks_all ac,
529: fv_treasury_confirmations_all fvc
530: WHERE ac.org_id = g_org_id
531: AND fvc.org_id = ac.org_id
532: AND fvc.treasury_confirmation_id= g_treasury_conf_id

Line 574: ap_checks_all ac

570: WHERE processed_flag = 'U'
571: AND org_id = g_org_id
572: and check_id in ( select check_id
573: from fv_treasury_confirmations_all fvtreas ,
574: ap_checks_all ac
575: where
576: fvtreas.org_id = g_org_id
577: and ac.org_id = fvtreas.org_id
578: and fvtreas.treasury_confirmation_id = g_treasury_conf_id

Line 688: FROM ap_checks ac

684: l_reference_info XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO;
685:
686: CURSOR cur_get_payment_info(p_treasury_conf_id NUMBER) IS
687: SELECT distinct ac.legal_entity_id, ftc.event_id
688: FROM ap_checks ac
689: ,fv_treasury_confirmations ftc
690: WHERE ftc.treasury_confirmation_id = p_treasury_conf_id
691: AND ftc.payment_instruction_id = ac.payment_instruction_id
692: AND ac.org_id = g_org_id;

Line 702: ap_checks_all ac

698: FVC.check_id,
699: FTC.treasury_confirmation_id
700: FROM fv_voided_checks FVC,
701: fv_treasury_confirmations_all FTC,
702: ap_checks_all ac
703: WHERE
704: ftc.org_id = g_org_id
705: AND FVC.org_id = ftc.org_id
706: AND ac.org_id = FVC.org_id

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

972:
973: CURSOR cur_treas_conf
974: IS
975: SELECT max(fvtreas.TREASURY_CONFIRMATION_ID) TREASURY_CONFIRMATION_ID
976: FROM fv_voided_checks fvc , ap_checks_all apchk,fv_treasury_confirmations_all fvtreas
977: WHERE
978: apchk.org_id = g_org_id
979: AND apchk.org_id = fvtreas.org_id
980: AND apchk.check_id = fvc.check_id

Line 1027: FROM ap_checks_all ac,

1023: SYSDATE,
1024: fnd_global.user_id,
1025: fnd_global.login_id,
1026: ac.org_id
1027: FROM ap_checks_all ac,
1028: fv_treasury_confirmations_all fvtc
1029: WHERE ac.org_id = g_org_id
1030: AND fvtc.org_id = ac.org_id
1031: AND fvtc.payment_instruction_id = ac.payment_instruction_id

Line 1059: FROM ap_checks_all ac

1055:
1056: l_void_count:=0;
1057:
1058: SELECT COUNT(ac.check_id) INTO l_void_count
1059: FROM ap_checks_all ac
1060: ,fv_treasury_confirmations_all ftc
1061: , fv_voided_checks fvc
1062: WHERE ftc.treasury_confirmation_id = treas_conf_rec.TREASURY_CONFIRMATION_ID
1063: AND ftc.payment_instruction_id = ac.payment_instruction_id

Line 1087: ap_checks_all ac

1083: WHERE processed_flag = 'U'
1084: AND org_id = g_org_id
1085: and check_id in ( select check_id
1086: from fv_treasury_confirmations_all fvtreas ,
1087: ap_checks_all ac
1088: where
1089: fvtreas.org_id = g_org_id
1090: and ac.org_id = fvtreas.org_id
1091: and fvtreas.treasury_confirmation_id = treas_conf_rec.TREASURY_CONFIRMATION_ID