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_DISB_IN_TRANSIT dependencies on FV_TREASURY_CONFIRMATIONS

Line 12: v_treasury_doc_date fv_treasury_confirmations.treasury_doc_date%TYPE;

8: v_set_of_books_id gl_ledgers_public_v.ledger_id%TYPE;
9: v_org_id fv_operating_units.org_id%TYPE;
10: c_gl_appl_id gl_period_statuses.application_id%TYPE;
11: g_treasury_confirmation_id NUMBER;
12: v_treasury_doc_date fv_treasury_confirmations.treasury_doc_date%TYPE;
13: c_application_short_name VARCHAR2(10);
14: c_key_flex_code VARCHAR2(4);
15: -- v_flex_num gl_sets_of_books.chart_of_accounts_id%TYPE;
16: v_flux_num gl_ledgers_public_v.chart_of_accounts_id%TYPE;

Line 50: UPDATE fv_treasury_confirmations

46: BEGIN
47:
48: ROLLBACK;
49:
50: UPDATE fv_treasury_confirmations
51: SET confirmation_status_flag = 'N'
52: WHERE treasury_confirmation_id = g_treasury_confirmation_id;
53:
54: COMMIT;

Line 76: v_begin_doc fv_treasury_confirmations.begin_doc_num%TYPE;

72: IS
73: l_module_name VARCHAR2(200);
74: v_doc_ctr NUMBER(15);
75: v_chk_ctr NUMBER(15);
76: v_begin_doc fv_treasury_confirmations.begin_doc_num%TYPE;
77: v_end_doc fv_treasury_confirmations.end_doc_num%TYPE;
78: v_payment_instruction_id iby_pay_instructions_all.payment_instruction_id%TYPE;
79: v_confirm_date fv_treasury_confirmations.treasury_doc_date%TYPE;
80: v_diff NUMBER;

Line 77: v_end_doc fv_treasury_confirmations.end_doc_num%TYPE;

73: l_module_name VARCHAR2(200);
74: v_doc_ctr NUMBER(15);
75: v_chk_ctr NUMBER(15);
76: v_begin_doc fv_treasury_confirmations.begin_doc_num%TYPE;
77: v_end_doc fv_treasury_confirmations.end_doc_num%TYPE;
78: v_payment_instruction_id iby_pay_instructions_all.payment_instruction_id%TYPE;
79: v_confirm_date fv_treasury_confirmations.treasury_doc_date%TYPE;
80: v_diff NUMBER;
81: v_check_num NUMBER;

Line 79: v_confirm_date fv_treasury_confirmations.treasury_doc_date%TYPE;

75: v_chk_ctr NUMBER(15);
76: v_begin_doc fv_treasury_confirmations.begin_doc_num%TYPE;
77: v_end_doc fv_treasury_confirmations.end_doc_num%TYPE;
78: v_payment_instruction_id iby_pay_instructions_all.payment_instruction_id%TYPE;
79: v_confirm_date fv_treasury_confirmations.treasury_doc_date%TYPE;
80: v_diff NUMBER;
81: v_check_num NUMBER;
82: v_delta NUMBER(15);
83: v_treasury_pay_number ap_checks.treasury_pay_number%TYPE;

Line 115: FROM fv_treasury_confirmations ftc,

111: AND ipa.org_id = v_org_id;
112:
113: CURSOR c_check_ranges IS
114: SELECT ftcr.range_from, ftcr.range_to, ftc.payment_instruction_id,ftc.treasury_doc_date
115: FROM fv_treasury_confirmations ftc,
116: fv_treasury_check_ranges ftcr
117: WHERE ftc.treasury_confirmation_id = g_treasury_confirmation_id
118: AND ftc.treasury_confirmation_id = ftcr.treasury_confirmation_id;
119:

Line 134: FROM fv_treasury_confirmations ftc

130:
131: -- Getting the name of the Payment Instruction
132: SELECT ftc.payment_instruction_id
133: INTO v_payment_instruction_id
134: FROM fv_treasury_confirmations ftc
135: WHERE ftc.treasury_confirmation_id = g_treasury_confirmation_id;
136:
137: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
138: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'v_payment_instruction_id is ' || v_payment_instruction_id);

Line 336: v_checkrun_name fv_treasury_confirmations.checkrun_name%TYPE ;

332: v_reference3 gl_interface.reference3%TYPE;
333: v_currency_code gl_ledgers_public_v.currency_code%TYPE;
334: v_dr_account_segment_value gl_ussgl_account_pairs.dr_account_segment_value%TYPE;
335: v_cr_account_segment_value gl_ussgl_account_pairs.cr_account_segment_value%TYPE;
336: v_checkrun_name fv_treasury_confirmations.checkrun_name%TYPE ;
337: v_check_id ap_checks.check_id%TYPE;
338: v_vendor_id po_vendors.vendor_id%TYPE;
339: v_period_start_date gl_period_statuses.start_date%TYPE;
340: v_period_end_date gl_period_statuses.end_date%TYPE;

Line 367: FROM fv_treasury_confirmations ftc,

363: apd.currency_conversion_rate,
364: apd.ae_line_type_code,
365: aip.invoice_id,
366: ac.check_id
367: FROM fv_treasury_confirmations ftc,
368: ap_checks ac,
369: ap_invoice_payments aip,
370: ap_ae_lines apd,
371: iby_payments_all ipa

Line 434: FROM fv_treasury_confirmations t

430: END IF;
431:
432: SELECT t.treasury_doc_date
433: INTO v_treasury_doc_date
434: FROM fv_treasury_confirmations t
435: WHERE treasury_confirmation_id = x_treasury_confirmation_id;
436:
437: SELECT p.start_date, p.end_date
438: INTO v_period_start_date, v_period_end_date

Line 679: UPDATE fv_treasury_confirmations

675: AND group_id = x_group_id;
676:
677: -- if the button that is called is either confirm or backout, not void
678: IF v_process_job IN ('C', 'B') THEN
679: UPDATE fv_treasury_confirmations
680: -- if the process is confirm, status is Not Confirmed,
681: -- if the process is backout, status is Confirmed
682: SET confirmation_status_flag = DECODE(v_process_job, 'C', 'N', 'B', 'Y'),
683: gl_period = NULL,

Line 788: v_checkrun_name fv_treasury_confirmations.checkrun_name%TYPE;

784: x_err_code IN OUT NOCOPY NUMBER,
785: x_err_stage IN OUT NOCOPY VARCHAR2)
786: IS
787: l_module_name VARCHAR2(200);
788: v_checkrun_name fv_treasury_confirmations.checkrun_name%TYPE;
789: v_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
790: v_currency_code gl_ledgers_public_v.currency_code%TYPE;
791: v_func_currency_code gl_ledgers_public_v.currency_code%TYPE;
792: v_credit_amount gl_je_lines.entered_dr%TYPE;

Line 826: FROM fv_treasury_confirmations

822: END IF;
823:
824: SELECT treasury_doc_date
825: INTO v_treasury_doc_date
826: FROM fv_treasury_confirmations
827: WHERE treasury_confirmation_id = v_treasury_confirmation_id;
828:
829:
830: -- get name of open period that treasury doc date is in

Line 1056: FROM fv_treasury_confirmations_all ftc,

1052: ftc.treasury_confirmation_id,
1053: fvt.processed_flag,
1054: ac.exchange_date,
1055: ac.void_date
1056: FROM fv_treasury_confirmations_all ftc,
1057: fv_voided_checks fvt,
1058: ap_checks_all ac ,
1059: ap_invoice_payments_all apip,
1060: iby_payments_all ipa

Line 1662: v_period fv_treasury_confirmations.gl_period%TYPE;

1658: dstatus VARCHAR2(30);
1659: message VARCHAR2(240);
1660: v_dummy NUMBER;
1661: v_process_job VARCHAR2(1);
1662: v_period fv_treasury_confirmations.gl_period%TYPE;
1663: l_set_of_books_name VARCHAR2(200);
1664:
1665: BEGIN
1666:

Line 1711: UPDATE fv_treasury_confirmations

1707: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1708: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'v_button_name = '||v_button_name);
1709: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'v_treasury_confirmation_id = '||TO_CHAR(v_treasury_confirmation_id));
1710: END IF;
1711: UPDATE fv_treasury_confirmations
1712: SET confirmation_status_flag = DECODE(v_button_name, 'TREASURY_CONFIRMATION.CONFIRM', 'N', 'TREASURY_CONFIRMATION.BACK_OUT', 'Y')
1713: WHERE treasury_confirmation_id = v_treasury_confirmation_id;
1714: RETURN;
1715: END IF;

Line 1818: UPDATE fv_treasury_confirmations

1814: process_clean_up;
1815: -- if the process is a backout, want to rollback and set status to Y for the treasury confirmation id
1816: ELSIF v_process_job = 'B' THEN
1817: ROLLBACK;
1818: UPDATE fv_treasury_confirmations
1819: SET confirmation_status_flag = 'Y'
1820: WHERE treasury_confirmation_id = v_treasury_confirmation_id;
1821: COMMIT;
1822: END IF;

Line 1877: FROM fv_treasury_confirmations ftca,

1873: last_updated_by = fnd_global.user_id,
1874: last_update_login = fnd_global.login_id
1875: WHERE payment_id IN
1876: (SELECT payment_id
1877: FROM fv_treasury_confirmations ftca,
1878: iby_payments_all ipa
1879: WHERE ftca.treasury_confirmation_id = v_treasury_confirmation_id
1880: AND ftca.payment_instruction_id = ipa.payment_instruction_id);
1881:

Line 1882: UPDATE fv_treasury_confirmations

1878: iby_payments_all ipa
1879: WHERE ftca.treasury_confirmation_id = v_treasury_confirmation_id
1880: AND ftca.payment_instruction_id = ipa.payment_instruction_id);
1881:
1882: UPDATE fv_treasury_confirmations
1883: SET confirmation_status_flag = 'B',
1884: last_update_date = SYSDATE,
1885: last_updated_by = fnd_global.user_id,
1886: last_update_login = fnd_global.login_id

Line 1895: fv_treasury_confirmations ftc,

1891:
1892: DELETE FROM fv_tc_offsets
1893: WHERE check_id IN (SELECT check_id
1894: FROM ap_checks ac,
1895: fv_treasury_confirmations ftc,
1896: iby_payments_all ipa
1897: WHERE ftc.treasury_confirmation_id = v_treasury_confirmation_id
1898: AND ftc.payment_instruction_id = ipa.payment_instruction_id
1899: AND ipa.payment_id = ac.payment_id);

Line 1907: UPDATE fv_treasury_confirmations

1903:
1904: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1905: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Updating confirm status');
1906: END IF;
1907: UPDATE fv_treasury_confirmations
1908: SET confirmation_status_flag = 'Y',
1909: gl_period = v_period,
1910: last_update_date = SYSDATE,
1911: last_updated_by = fnd_global.user_id,