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_FACTS1_GL_PKG dependencies on FV_FACTS1_LINE_BALANCES

Line 28: party_id fv_facts1_line_balances.Party_Id%TYPE,

24: TYPE party_info_rec
25: IS
26: RECORD
27: (
28: party_id fv_facts1_line_balances.Party_Id%TYPE,
29: cust_vend_type fv_facts1_line_balances.party_type%TYPE,
30: vendor_type fv_facts1_line_balances.party_classification%TYPE,
31: elim_dept fv_facts1_line_balances.eliminations_dept%TYPE,
32: recipient_name fv_facts1_line_balances.recipient_name%TYPE,

Line 29: cust_vend_type fv_facts1_line_balances.party_type%TYPE,

25: IS
26: RECORD
27: (
28: party_id fv_facts1_line_balances.Party_Id%TYPE,
29: cust_vend_type fv_facts1_line_balances.party_type%TYPE,
30: vendor_type fv_facts1_line_balances.party_classification%TYPE,
31: elim_dept fv_facts1_line_balances.eliminations_dept%TYPE,
32: recipient_name fv_facts1_line_balances.recipient_name%TYPE,
33: reported_status VARCHAR2(1),

Line 30: vendor_type fv_facts1_line_balances.party_classification%TYPE,

26: RECORD
27: (
28: party_id fv_facts1_line_balances.Party_Id%TYPE,
29: cust_vend_type fv_facts1_line_balances.party_type%TYPE,
30: vendor_type fv_facts1_line_balances.party_classification%TYPE,
31: elim_dept fv_facts1_line_balances.eliminations_dept%TYPE,
32: recipient_name fv_facts1_line_balances.recipient_name%TYPE,
33: reported_status VARCHAR2(1),
34: record_category fv_facts1_line_balances.record_category%TYPE,

Line 31: elim_dept fv_facts1_line_balances.eliminations_dept%TYPE,

27: (
28: party_id fv_facts1_line_balances.Party_Id%TYPE,
29: cust_vend_type fv_facts1_line_balances.party_type%TYPE,
30: vendor_type fv_facts1_line_balances.party_classification%TYPE,
31: elim_dept fv_facts1_line_balances.eliminations_dept%TYPE,
32: recipient_name fv_facts1_line_balances.recipient_name%TYPE,
33: reported_status VARCHAR2(1),
34: record_category fv_facts1_line_balances.record_category%TYPE,
35: feeder_flag fv_facts1_line_balances.feeder_flag%TYPE,

Line 32: recipient_name fv_facts1_line_balances.recipient_name%TYPE,

28: party_id fv_facts1_line_balances.Party_Id%TYPE,
29: cust_vend_type fv_facts1_line_balances.party_type%TYPE,
30: vendor_type fv_facts1_line_balances.party_classification%TYPE,
31: elim_dept fv_facts1_line_balances.eliminations_dept%TYPE,
32: recipient_name fv_facts1_line_balances.recipient_name%TYPE,
33: reported_status VARCHAR2(1),
34: record_category fv_facts1_line_balances.record_category%TYPE,
35: feeder_flag fv_facts1_line_balances.feeder_flag%TYPE,
36: g_ng_indicator fv_facts1_line_balances.g_ng_indicator%TYPE,

Line 34: record_category fv_facts1_line_balances.record_category%TYPE,

30: vendor_type fv_facts1_line_balances.party_classification%TYPE,
31: elim_dept fv_facts1_line_balances.eliminations_dept%TYPE,
32: recipient_name fv_facts1_line_balances.recipient_name%TYPE,
33: reported_status VARCHAR2(1),
34: record_category fv_facts1_line_balances.record_category%TYPE,
35: feeder_flag fv_facts1_line_balances.feeder_flag%TYPE,
36: g_ng_indicator fv_facts1_line_balances.g_ng_indicator%TYPE,
37: party_line_amount NUMBER);
38: TYPE party_info_table

Line 35: feeder_flag fv_facts1_line_balances.feeder_flag%TYPE,

31: elim_dept fv_facts1_line_balances.eliminations_dept%TYPE,
32: recipient_name fv_facts1_line_balances.recipient_name%TYPE,
33: reported_status VARCHAR2(1),
34: record_category fv_facts1_line_balances.record_category%TYPE,
35: feeder_flag fv_facts1_line_balances.feeder_flag%TYPE,
36: g_ng_indicator fv_facts1_line_balances.g_ng_indicator%TYPE,
37: party_line_amount NUMBER);
38: TYPE party_info_table
39: IS

Line 36: g_ng_indicator fv_facts1_line_balances.g_ng_indicator%TYPE,

32: recipient_name fv_facts1_line_balances.recipient_name%TYPE,
33: reported_status VARCHAR2(1),
34: record_category fv_facts1_line_balances.record_category%TYPE,
35: feeder_flag fv_facts1_line_balances.feeder_flag%TYPE,
36: g_ng_indicator fv_facts1_line_balances.g_ng_indicator%TYPE,
37: party_line_amount NUMBER);
38: TYPE party_info_table
39: IS
40: TABLE OF party_info_rec INDEX BY BINARY_INTEGER;

Line 356: -- all journal lines not existing in fv_facts1_line_balances.

352: END log;
353: --------------------------------------------------------------------------------
354: -- Select all journal lines from gl_je_lines from the beginning of the year upto
355: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and
356: -- all journal lines not existing in fv_facts1_line_balances.
357: -- Retreives party info like party type, eliminations dept, etc and insert into
358: -- fv_facts1_line_balances.
359: --------------------------------------------------------------------------------
360: PROCEDURE PROCESS_GL_LINES

Line 358: -- fv_facts1_line_balances.

354: -- Select all journal lines from gl_je_lines from the beginning of the year upto
355: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and
356: -- all journal lines not existing in fv_facts1_line_balances.
357: -- Retreives party info like party type, eliminations dept, etc and insert into
358: -- fv_facts1_line_balances.
359: --------------------------------------------------------------------------------
360: PROCEDURE PROCESS_GL_LINES
361: IS
362: l_module_name VARCHAR2(200);

Line 392: TABLE OF fv_facts1_line_balances.amount%TYPE;

388: IS
389: TABLE OF gl_je_lines.attribute1%TYPE;
390: TYPE amount_t
391: IS
392: TABLE OF fv_facts1_line_balances.amount%TYPE;
393: TYPE d_c_indicator_t
394: IS
395: TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;
396: TYPE gl_period_t

Line 395: TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;

391: IS
392: TABLE OF fv_facts1_line_balances.amount%TYPE;
393: TYPE d_c_indicator_t
394: IS
395: TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;
396: TYPE gl_period_t
397: IS
398: TABLE OF gl_je_lines.period_name%TYPE;
399: TYPE party_id_t

Line 401: TABLE OF fv_facts1_line_balances.party_id%TYPE;

397: IS
398: TABLE OF gl_je_lines.period_name%TYPE;
399: TYPE party_id_t
400: IS
401: TABLE OF fv_facts1_line_balances.party_id%TYPE;
402: TYPE party_type_t
403: IS
404: TABLE OF fv_facts1_line_balances.party_type%TYPE;
405: TYPE vendor_type_t

Line 404: TABLE OF fv_facts1_line_balances.party_type%TYPE;

400: IS
401: TABLE OF fv_facts1_line_balances.party_id%TYPE;
402: TYPE party_type_t
403: IS
404: TABLE OF fv_facts1_line_balances.party_type%TYPE;
405: TYPE vendor_type_t
406: IS
407: TABLE OF fv_facts1_line_balances.party_classification%TYPE;
408: TYPE recipient_name_t

Line 407: TABLE OF fv_facts1_line_balances.party_classification%TYPE;

403: IS
404: TABLE OF fv_facts1_line_balances.party_type%TYPE;
405: TYPE vendor_type_t
406: IS
407: TABLE OF fv_facts1_line_balances.party_classification%TYPE;
408: TYPE recipient_name_t
409: IS
410: TABLE OF fv_facts1_line_balances.recipient_name%TYPE;
411: TYPE eliminations_dept_t

Line 410: TABLE OF fv_facts1_line_balances.recipient_name%TYPE;

406: IS
407: TABLE OF fv_facts1_line_balances.party_classification%TYPE;
408: TYPE recipient_name_t
409: IS
410: TABLE OF fv_facts1_line_balances.recipient_name%TYPE;
411: TYPE eliminations_dept_t
412: IS
413: TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;
414: TYPE reference_t

Line 413: TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;

409: IS
410: TABLE OF fv_facts1_line_balances.recipient_name%TYPE;
411: TYPE eliminations_dept_t
412: IS
413: TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;
414: TYPE reference_t
415: IS
416: TABLE OF gl_je_lines.reference_1%TYPE;
417: TYPE fund_value_t

Line 422: TABLE OF fv_facts1_line_balances.account_number%TYPE;

418: IS
419: TABLE OF fv_fund_parameters.fund_value%TYPE;
420: TYPE account_number_t
421: IS
422: TABLE OF fv_facts1_line_balances.account_number%TYPE;
423: TYPE fed_nonfed_t
424: IS
425: TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;
426: TYPE g_ng_indicator_t

Line 428: TABLE OF fv_facts1_line_balances.g_ng_indicator%TYPE;

424: IS
425: TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;
426: TYPE g_ng_indicator_t
427: IS
428: TABLE OF fv_facts1_line_balances.g_ng_indicator%TYPE;
429: TYPE record_category_t
430: IS
431: TABLE OF fv_facts1_line_balances.record_category%TYPE;
432: TYPE varchar_1_t

Line 431: TABLE OF fv_facts1_line_balances.record_category%TYPE;

427: IS
428: TABLE OF fv_facts1_line_balances.g_ng_indicator%TYPE;
429: TYPE record_category_t
430: IS
431: TABLE OF fv_facts1_line_balances.record_category%TYPE;
432: TYPE varchar_1_t
433: IS
434: TABLE OF VARCHAR2(1);
435: TYPE period_num_t

Line 814: INTO fv_facts1_line_balances

810: -- It will not insert any values into table.
811: if (je_header_id_list_2.count > 0) then
812: FORALL i IN je_header_id_list_2.first .. je_header_id_list_2.last
813: INSERT
814: INTO fv_facts1_line_balances
815: (
816: ccid ,
817: period_num ,
818: set_of_books_id ,

Line 1615: fv_facts1_line_balances l,

1611: substr(rpad(l.account_number, 9, '' ''),1,9) || '' '' ||
1612: substr(rpad(l.fund_value, 20, '' ''),1,20) || '' '' ||
1613: to_char( amount,''99,999,999,999,999,999.99'') ' || ' FROM fv_facts1_header_id_gt f ,
1614: gl_je_headers h,
1615: fv_facts1_line_balances l,
1616: gl_je_batches b
1617: where h.je_header_id = f.je_header_id
1618: and l.je_header_id = h.je_header_id
1619: and l.record_category IN (''NO_VENDOR'', ''G_NONFED_VENDOR'')