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_FACTS2_DERIVE_BALANCES dependencies on FV_FACTSII_ACCOUNTS_GT

Line 121: --* : their child accounts into the temporary table fv_factsii_accounts_gt *--

117: --****************************************************************************************--
118: --* Name : explode_accounts *--
119: --* Type : Procedure *--
120: --* Purpose : Looks at all the FACTSII accounts and puts those accounts along with *--
121: --* : their child accounts into the temporary table fv_factsii_accounts_gt *--
122: --* Parameters : p_ledger_id Set Of Books Id *--
123: --* : p_acct_value_set_id Account Value Set Id *--
124: --* : p_error_code Return Error Code *--
125: --* : p_error_desc Return Error Description *--

Line 139: --* : fv_factsii_accounts_gt INSERT *--

135: --* Tables Used : fnd_flex_value_hierarchies SELECT *--
136: --* : fnd_flex_values_vl SELECT *--
137: --* : fv_facts_attributes SELECT *--
138: --* : fv_facts_ussgl_accounts SELECT *--
139: --* : fv_factsii_accounts_gt INSERT *--
140: --* Logic : 1. Get all the FACTSII accounts from table fv_facts_ussgl_accounts *--
141: --* : and select only those accounts from table fv_facts_attributes *--
142: --* : where the following attributes are set to Y. public_law_code, *--
143: --* : advance_flag and transfer_flag *--

Line 144: --* : 2. Insert that account into table fv_factsii_accounts_gt *--

140: --* Logic : 1. Get all the FACTSII accounts from table fv_facts_ussgl_accounts *--
141: --* : and select only those accounts from table fv_facts_attributes *--
142: --* : where the following attributes are set to Y. public_law_code, *--
143: --* : advance_flag and transfer_flag *--
144: --* : 2. Insert that account into table fv_factsii_accounts_gt *--
145: --* : 3. Find all the child accounts using the tables fnd_flex_values_vl *--
146: --* : and fnd_flex_value_hierarchies and insert those too into the *--
147: --* : temporary table fv_factsii_accounts_gt *--
148: --****************************************************************************************--

Line 147: --* : temporary table fv_factsii_accounts_gt *--

143: --* : advance_flag and transfer_flag *--
144: --* : 2. Insert that account into table fv_factsii_accounts_gt *--
145: --* : 3. Find all the child accounts using the tables fnd_flex_values_vl *--
146: --* : and fnd_flex_value_hierarchies and insert those too into the *--
147: --* : temporary table fv_factsii_accounts_gt *--
148: --****************************************************************************************--
149: PROCEDURE explode_accounts
150: (
151: p_ledger_id IN gl_ledgers_public_v.ledger_id%TYPE,

Line 213: INSERT INTO fv_factsii_accounts_gt

209: AND (fa.public_law_code = 'Y' OR
210: fa.advance_flag = 'Y' OR
211: fa.transfer_flag = 'Y')) LOOP
212: BEGIN
213: INSERT INTO fv_factsii_accounts_gt
214: (
215: ussgl_account,
216: account,
217: public_law_code,

Line 233: l_location := l_module_name||'insert_fv_factsii_accounts_gt';

229: EXCEPTION
230: WHEN OTHERS THEN
231: p_error_code := g_FAILURE;
232: p_error_desc := SQLERRM;
233: l_location := l_module_name||'insert_fv_factsii_accounts_gt';
234: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
235: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
236: END;
237:

Line 245: INSERT INTO fv_factsii_accounts_gt

241: FOR get_child_values_rec IN get_child_values_cursor(p_acct_value_set_id,
242: get_hierarchies_rec.child_flex_value_low,
243: get_hierarchies_rec.child_flex_value_high) LOOP
244: BEGIN
245: INSERT INTO fv_factsii_accounts_gt
246: (
247: ussgl_account,
248: account,
249: public_law_code,

Line 265: l_location := l_module_name||'insert_fv_factsii_accounts_gt2';

261: EXCEPTION
262: WHEN OTHERS THEN
263: p_error_code := g_FAILURE;
264: p_error_desc := SQLERRM;
265: l_location := l_module_name||'insert_fv_factsii_accounts_gt2';
266: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
267: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
268: END;
269: IF (p_error_code <> g_SUCCESS) THEN

Line 751: --* : fv_factsii_accounts_gt SELECT *--

747: --* : gl_period_statuses gps SELECT *--
748: --* : fv_be_trx_dtls SELECT *--
749: --* : gl_balances glbal SELECT *--
750: --* : gl_code_combinations gcc SELECT *--
751: --* : fv_factsii_accounts_gt SELECT *--
752: --* Logic : 1.
753: --****************************************************************************************--
754: PROCEDURE start_processing
755: (

Line 1025: fv_factsii_accounts_gt fa

1021: gcc.segment30,'||
1022: 'gcc.'||p_bal_segment||'
1023: FROM gl_balances glbal,
1024: gl_code_combinations gcc,
1025: fv_factsii_accounts_gt fa
1026: WHERE glbal.ledger_id = :b_set_of_books_id
1027: AND glbal.period_year = :b_period_year
1028: AND glbal.period_num = :b_period_num
1029: AND glbal.template_id IS NULL