APPS.FV_TREASURY_PAYMENTS_PKG dependencies on FV_TREASURY_CONFIRMATIONS_ALL

Line 287: l_checkrun_name fv_treasury_confirmations_all.checkrun_name%TYPE;

283: l_void_return_status VARCHAR2(1);
284:
285: --Variables used for 11i Upgrade rows
286: l_pay_fmt_program_name ap_payment_programs.program_name%TYPE;
287: l_checkrun_name fv_treasury_confirmations_all.checkrun_name%TYPE;
288: l_select_str VARCHAR2(1000);
289: TYPE t_refcur IS REF CURSOR;
290: l_upg_check_id_cur t_refcur;
291: l_corr_treas_pay_num fv_tc_offsets.corrected_treasury_pay_number%TYPE;

Line 339: FROM FV_TREASURY_CONFIRMATIONS_ALL

335: -- select statement for 11i upgrade rows
336: BEGIN
337: SELECT checkrun_name
338: INTO l_checkrun_name
339: FROM FV_TREASURY_CONFIRMATIONS_ALL
340: WHERE payment_instruction_id = g_payment_instr_id
341: AND org_id = g_org_id;
342:
343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 489: ,fv_treasury_confirmations_all ftc

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
493: AND ac.org_id = ftc.org_id

Line 529: fv_treasury_confirmations_all fvc

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
533: AND fvc.payment_instruction_id = ac.payment_instruction_id

Line 573: from fv_treasury_confirmations_all fvtreas ,

569: SET processed_flag = 'P'
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

Line 701: fv_treasury_confirmations_all FTC,

697: FTC.payment_instruction_id,
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

Line 735: l_pmt_id fv_treasury_confirmations_all.payment_instruction_id%TYPE;

731: l_treas_conf_id NUMBER(15);
732: l_void_acctg_date DATE;
733: l_tc_event_id NUMBER(15);
734: l_void_event_id NUMBER(15);
735: l_pmt_id fv_treasury_confirmations_all.payment_instruction_id%TYPE;
736:
737: BEGIN
738: l_calling_sequence := p_calling_sequence || ' -> FV_TREASURY_PAYMENTS_PKG.CREATE_TREASURY_PAYMENT_EVENT';
739: l_module_name := g_module_name||'Create_Treasury_Payment_Event';

Line 835: Update fv_treasury_confirmations_all

831:
832: Insert into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
833: values (l_tc_Event_id);
834:
835: Update fv_treasury_confirmations_all
836: Set event_id = l_tc_event_id
837: Where treasury_confirmation_id = p_treasury_conf_id;
838:
839: ELSIF p_event_type = 'TREASURY_VOID' THEN

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 1028: fv_treasury_confirmations_all fvtc

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
1032: AND ac.void_date IS NOT NULL

Line 1060: ,fv_treasury_confirmations_all ftc

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
1064: AND ac.org_id = g_org_id

Line 1086: from fv_treasury_confirmations_all fvtreas ,

1082: SET processed_flag = 'P'
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