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.

[Home] [Help]

APPS.FV_FACTS1_GL_PKG dependencies on FV_FACTS1_LINE_BALANCES

Line 29: party_id fv_facts1_line_balances.Party_Id%TYPE,

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

Line 30: cust_vend_type fv_facts1_line_balances.party_type%TYPE,

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

Line 31: vendor_type fv_facts1_line_balances.party_classification%TYPE,

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

Line 32: elim_dept fv_facts1_line_balances.eliminations_dept%TYPE,

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

Line 33: recipient_name fv_facts1_line_balances.recipient_name%TYPE,

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

Line 35: record_category fv_facts1_line_balances.record_category%TYPE,

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

Line 36: feeder_flag fv_facts1_line_balances.feeder_flag%TYPE,

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

Line 37: g_ng_indicator fv_facts1_line_balances.g_ng_indicator%TYPE,

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

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

426: END log;
427: --------------------------------------------------------------------------------
428: -- Select all journal lines from gl_je_lines from the beginning of the year upto
429: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and
430: -- all journal lines not existing in fv_facts1_line_balances.
431: -- Retreives party info like party type, eliminations dept, etc and insert into
432: -- fv_facts1_line_balances.
433: --------------------------------------------------------------------------------
434: PROCEDURE PROCESS_GL_LINES

Line 432: -- fv_facts1_line_balances.

428: -- Select all journal lines from gl_je_lines from the beginning of the year upto
429: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and
430: -- all journal lines not existing in fv_facts1_line_balances.
431: -- Retreives party info like party type, eliminations dept, etc and insert into
432: -- fv_facts1_line_balances.
433: --------------------------------------------------------------------------------
434: PROCEDURE PROCESS_GL_LINES
435: IS
436: l_module_name VARCHAR2(200);

Line 448: TYPE amount_t IS TABLE OF fv_facts1_line_balances.amount%TYPE;

444: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
445: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
446: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;
447: TYPE attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
448: TYPE amount_t IS TABLE OF fv_facts1_line_balances.amount%TYPE;
449: TYPE d_c_indicator_t IS TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;
450: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
451: TYPE party_id_t IS TABLE OF fv_facts1_line_balances.party_id%TYPE;
452: TYPE party_type_t IS TABLE OF fv_facts1_line_balances.party_type%TYPE;

Line 449: TYPE d_c_indicator_t IS TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;

445: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
446: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;
447: TYPE attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
448: TYPE amount_t IS TABLE OF fv_facts1_line_balances.amount%TYPE;
449: TYPE d_c_indicator_t IS TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;
450: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
451: TYPE party_id_t IS TABLE OF fv_facts1_line_balances.party_id%TYPE;
452: TYPE party_type_t IS TABLE OF fv_facts1_line_balances.party_type%TYPE;
453: TYPE vendor_type_t IS TABLE OF fv_facts1_line_balances.party_classification%TYPE;

Line 451: TYPE party_id_t IS TABLE OF fv_facts1_line_balances.party_id%TYPE;

447: TYPE attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
448: TYPE amount_t IS TABLE OF fv_facts1_line_balances.amount%TYPE;
449: TYPE d_c_indicator_t IS TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;
450: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
451: TYPE party_id_t IS TABLE OF fv_facts1_line_balances.party_id%TYPE;
452: TYPE party_type_t IS TABLE OF fv_facts1_line_balances.party_type%TYPE;
453: TYPE vendor_type_t IS TABLE OF fv_facts1_line_balances.party_classification%TYPE;
454: TYPE recipient_name_t IS TABLE OF fv_facts1_line_balances.recipient_name%TYPE;
455: TYPE eliminations_dept_t IS TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;

Line 452: TYPE party_type_t IS TABLE OF fv_facts1_line_balances.party_type%TYPE;

448: TYPE amount_t IS TABLE OF fv_facts1_line_balances.amount%TYPE;
449: TYPE d_c_indicator_t IS TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;
450: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
451: TYPE party_id_t IS TABLE OF fv_facts1_line_balances.party_id%TYPE;
452: TYPE party_type_t IS TABLE OF fv_facts1_line_balances.party_type%TYPE;
453: TYPE vendor_type_t IS TABLE OF fv_facts1_line_balances.party_classification%TYPE;
454: TYPE recipient_name_t IS TABLE OF fv_facts1_line_balances.recipient_name%TYPE;
455: TYPE eliminations_dept_t IS TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;
456: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;

Line 453: TYPE vendor_type_t IS TABLE OF fv_facts1_line_balances.party_classification%TYPE;

449: TYPE d_c_indicator_t IS TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;
450: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
451: TYPE party_id_t IS TABLE OF fv_facts1_line_balances.party_id%TYPE;
452: TYPE party_type_t IS TABLE OF fv_facts1_line_balances.party_type%TYPE;
453: TYPE vendor_type_t IS TABLE OF fv_facts1_line_balances.party_classification%TYPE;
454: TYPE recipient_name_t IS TABLE OF fv_facts1_line_balances.recipient_name%TYPE;
455: TYPE eliminations_dept_t IS TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;
456: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
457: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;

Line 454: TYPE recipient_name_t IS TABLE OF fv_facts1_line_balances.recipient_name%TYPE;

450: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;
451: TYPE party_id_t IS TABLE OF fv_facts1_line_balances.party_id%TYPE;
452: TYPE party_type_t IS TABLE OF fv_facts1_line_balances.party_type%TYPE;
453: TYPE vendor_type_t IS TABLE OF fv_facts1_line_balances.party_classification%TYPE;
454: TYPE recipient_name_t IS TABLE OF fv_facts1_line_balances.recipient_name%TYPE;
455: TYPE eliminations_dept_t IS TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;
456: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
457: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
458: TYPE account_number_t IS TABLE OF fv_facts1_line_balances.account_number%TYPE;

Line 455: TYPE eliminations_dept_t IS TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;

451: TYPE party_id_t IS TABLE OF fv_facts1_line_balances.party_id%TYPE;
452: TYPE party_type_t IS TABLE OF fv_facts1_line_balances.party_type%TYPE;
453: TYPE vendor_type_t IS TABLE OF fv_facts1_line_balances.party_classification%TYPE;
454: TYPE recipient_name_t IS TABLE OF fv_facts1_line_balances.recipient_name%TYPE;
455: TYPE eliminations_dept_t IS TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;
456: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
457: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
458: TYPE account_number_t IS TABLE OF fv_facts1_line_balances.account_number%TYPE;
459: TYPE fed_nonfed_t IS TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;

Line 458: TYPE account_number_t IS TABLE OF fv_facts1_line_balances.account_number%TYPE;

454: TYPE recipient_name_t IS TABLE OF fv_facts1_line_balances.recipient_name%TYPE;
455: TYPE eliminations_dept_t IS TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;
456: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
457: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
458: TYPE account_number_t IS TABLE OF fv_facts1_line_balances.account_number%TYPE;
459: TYPE fed_nonfed_t IS TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;
460: TYPE g_ng_indicator_t IS TABLE OF fv_facts1_line_balances.g_ng_indicator%TYPE;
461: TYPE record_category_t IS TABLE OF fv_facts1_line_balances.record_category%TYPE;
462: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);

Line 460: TYPE g_ng_indicator_t IS TABLE OF fv_facts1_line_balances.g_ng_indicator%TYPE;

456: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
457: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
458: TYPE account_number_t IS TABLE OF fv_facts1_line_balances.account_number%TYPE;
459: TYPE fed_nonfed_t IS TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;
460: TYPE g_ng_indicator_t IS TABLE OF fv_facts1_line_balances.g_ng_indicator%TYPE;
461: TYPE record_category_t IS TABLE OF fv_facts1_line_balances.record_category%TYPE;
462: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);
463: TYPE period_num_t IS TABLE OF gl_period_statuses.period_num%TYPE;
464: TYPE je_from_sla_flag_t IS TABLE OF VARCHAR2(1);

Line 461: TYPE record_category_t IS TABLE OF fv_facts1_line_balances.record_category%TYPE;

457: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
458: TYPE account_number_t IS TABLE OF fv_facts1_line_balances.account_number%TYPE;
459: TYPE fed_nonfed_t IS TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;
460: TYPE g_ng_indicator_t IS TABLE OF fv_facts1_line_balances.g_ng_indicator%TYPE;
461: TYPE record_category_t IS TABLE OF fv_facts1_line_balances.record_category%TYPE;
462: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);
463: TYPE period_num_t IS TABLE OF gl_period_statuses.period_num%TYPE;
464: TYPE je_from_sla_flag_t IS TABLE OF VARCHAR2(1);
465: TYPE je_batch_id_t IS TABLE OF gl_je_headers.je_batch_id%TYPE;

Line 858: INSERT INTO fv_facts1_line_balances

854:
855: FORALL i IN je_header_id_list_2.first .. je_header_id_list_2.last
856:
857:
858: INSERT INTO fv_facts1_line_balances
859: ( ccid,
860: period_num,
861: set_of_books_id,
862: period_year,

Line 1680: fv_facts1_line_balances l,

1676: substr(rpad(l.fund_value, 20, '' ''),1,20) || '' '' ||
1677: to_char( amount,''99,999,999,999,999,999.99'') ' ||
1678: ' FROM fv_facts1_header_id_gt f ,
1679: gl_je_headers h,
1680: fv_facts1_line_balances l,
1681: gl_je_batches b
1682: where h.je_header_id = f.je_header_id
1683: and l.je_header_id = h.je_header_id
1684: and l.record_category IN (''NO_VENDOR'', ''G_NONFED_VENDOR'')