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 GL_LEDGERS_PUBLIC_V

Line 8: v_set_of_books_id gl_ledgers_public_v.ledger_id%TYPE;

4: g_errmsg VARCHAR2(200);
5:
6: -- v_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
7:
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;

Line 16: v_flux_num gl_ledgers_public_v.chart_of_accounts_id%TYPE;

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;
17: v_segment_value VARCHAR2(25);
18: a_segments fnd_flex_ext.SegmentArray;
19: gl_seg_name VARCHAR2(30);
20:

Line 274: (v_chart_of_accounts_id OUT NOCOPY gl_ledgers_public_v.chart_of_accounts_id%TYPE,

270: ----------------------------------------------------------------------------------------
271:
272:
273: PROCEDURE get_interface_data
274: (v_chart_of_accounts_id OUT NOCOPY gl_ledgers_public_v.chart_of_accounts_id%TYPE,
275: v_currency_code OUT NOCOPY gl_ledgers_public_v.currency_code%TYPE,
276: x_err_code IN OUT NOCOPY NUMBER,
277: x_err_stage IN OUT NOCOPY VARCHAR2)
278: IS

Line 275: v_currency_code OUT NOCOPY gl_ledgers_public_v.currency_code%TYPE,

271:
272:
273: PROCEDURE get_interface_data
274: (v_chart_of_accounts_id OUT NOCOPY gl_ledgers_public_v.chart_of_accounts_id%TYPE,
275: v_currency_code OUT NOCOPY gl_ledgers_public_v.currency_code%TYPE,
276: x_err_code IN OUT NOCOPY NUMBER,
277: x_err_stage IN OUT NOCOPY VARCHAR2)
278: IS
279: l_module_name VARCHAR2(200);

Line 285: FROM gl_ledgers_public_v

281: l_module_name := g_module_name || 'get_interface_data ';
282: -- Get chart of accounts id, and currency code
283: SELECT chart_of_accounts_id, currency_code
284: INTO v_chart_of_accounts_id, v_currency_code
285: FROM gl_ledgers_public_v
286: WHERE ledger_id = v_set_of_books_id;
287:
288: EXCEPTION
289: WHEN OTHERS THEN

Line 310: v_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;

306: l_module_name VARCHAR2(200);
307: v_structure_number NUMBER;
308: v_segment_number NUMBER;
309: v_segment_name VARCHAR2(30);
310: v_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
311: c_flex_qual_name VARCHAR2(10);
312: v_n_segments NUMBER;
313: --a_segments fnd_flex_ext.SegmentArray;
314: --LGOEL: Change the declaration for these two variables

Line 326: v_functional_curr_code gl_ledgers_public_v.currency_code%TYPE;

322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;
325: v_line_type_code ap_ae_lines_all.ae_line_type_code%TYPE;
326: v_functional_curr_code gl_ledgers_public_v.currency_code%TYPE;
327:
328: v_accounting_date gl_interface.accounting_date%TYPE;
329: v_boolean BOOLEAN;
330: c_reference1 gl_interface.reference1%TYPE;

Line 333: v_currency_code gl_ledgers_public_v.currency_code%TYPE;

329: v_boolean BOOLEAN;
330: c_reference1 gl_interface.reference1%TYPE;
331: v_reference21 gl_interface.reference21%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;

Line 789: v_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;

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;
793: v_debit_amount gl_je_lines.entered_cr%TYPE;

Line 790: v_currency_code gl_ledgers_public_v.currency_code%TYPE;

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;
793: v_debit_amount gl_je_lines.entered_cr%TYPE;
794: v_cc_id gl_je_lines.code_combination_id%TYPE;

Line 791: v_func_currency_code gl_ledgers_public_v.currency_code%TYPE;

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;
793: v_debit_amount gl_je_lines.entered_cr%TYPE;
794: v_cc_id gl_je_lines.code_combination_id%TYPE;
795: v_n_segments NUMBER;

Line 1021: l_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;

1017: l_module_name VARCHAR2(200);
1018: l_group_id NUMBER;
1019: l_err_code NUMBER;
1020: l_err_stage VARCHAR2(2000);
1021: l_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
1022: l_org_id NUMBER;
1023: l_func_currency_code gl_ledgers_public_v.currency_code%TYPE;
1024: l_reference1 gl_interface.reference1%TYPE;
1025: l_insert_required BOOLEAN := FALSE;

Line 1023: l_func_currency_code gl_ledgers_public_v.currency_code%TYPE;

1019: l_err_code NUMBER;
1020: l_err_stage VARCHAR2(2000);
1021: l_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
1022: l_org_id NUMBER;
1023: l_func_currency_code gl_ledgers_public_v.currency_code%TYPE;
1024: l_reference1 gl_interface.reference1%TYPE;
1025: l_insert_required BOOLEAN := FALSE;
1026: l_count_void NUMBER := 0;
1027: l_interface_run_id NUMBER;

Line 1083: FROM gl_ledgers_public_v glpv,

1079: (ftc.confirmation_status_flag in ('B','N')
1080: AND apip.creation_date BETWEEN ftc.creation_date and ftc.last_update_date)
1081: )
1082: AND EXISTS (SELECT null
1083: FROM gl_ledgers_public_v glpv,
1084: gl_je_headers gjh,
1085: gl_je_lines gjl
1086: WHERE glpv.ledger_id = p_set_of_books_id
1087: --AND gjh.set_of_books_id = gsob.set_of_books_id

Line 1117: FROM gl_ledgers_public_v glpv,

1113: gjl.accounted_dr,
1114: gjh.currency_code,
1115: gjl.reference_4 invoice_id,
1116: gjl.rowid gl_rowid
1117: FROM gl_ledgers_public_v glpv,
1118: gl_je_lines gjl,
1119: gl_je_headers gjh
1120: WHERE glpv.ledger_id = p_set_of_books_id
1121: AND gjh.ledger_id = glpv.ledger_id