APPS.FII_GL_EXTRACTION_UTIL dependencies on FII_CCC_MGR_GT

Line 32: g_state := 'Loading fii_ccc_mgr_gt';

28: p_retcode := 0;
29:
30: -- initialize global variables
31:
32: g_state := 'Loading fii_ccc_mgr_gt';
33:
34: -- real job start here
35:
36: select count(*) into l_count from fii_ccc_mgr_gt;

Line 36: select count(*) into l_count from fii_ccc_mgr_gt;

32: g_state := 'Loading fii_ccc_mgr_gt';
33:
34: -- real job start here
35:
36: select count(*) into l_count from fii_ccc_mgr_gt;
37:
38: if l_count > 0 then
39: if g_debug_flag = 'Y' then
40: fii_util.put_line( 'Detected ' || l_count || ' rows' );

Line 48: fii_util.put_line( 'Populating fii_ccc_mgr_gt' );

44: return;
45: end if;
46:
47: if g_debug_flag = 'Y' then
48: fii_util.put_line( 'Populating fii_ccc_mgr_gt' );
49: end if;
50:
51: /* Table fii_ccc_mgr_gt has a row for each ccc_org_id.
52: Column manager is the ID of the current manager of a ccc_org_id.

Line 51: /* Table fii_ccc_mgr_gt has a row for each ccc_org_id.

47: if g_debug_flag = 'Y' then
48: fii_util.put_line( 'Populating fii_ccc_mgr_gt' );
49: end if;
50:
51: /* Table fii_ccc_mgr_gt has a row for each ccc_org_id.
52: Column manager is the ID of the current manager of a ccc_org_id.
53: If a ccc_org_id doesn't have a current manager, its manager column
54: is set to null.
55: */

Line 58: insert /*+ append parallel(a) */ into fii_ccc_mgr_gt a (manager, ccc_org_id, company_id, cost_center_id)

54: is set to null.
55: */
56:
57: --bug 3560006: populate company_id, cost_center_id
58: insert /*+ append parallel(a) */ into fii_ccc_mgr_gt a (manager, ccc_org_id, company_id, cost_center_id)
59: select /*+ use_hash(ccc_tbl,mgr_tbl,org,fv1,fv2) parallel(ccc_tbl) parallel(org) parallel(fv1) parallel(fv2) pq_distribute(fv1 hash,hash) pq_distribute(fv2 hash,hash) */
60: to_number (mgr_tbl.org_information2) manager,
61: ccc_tbl.organization_id ccc_org_id,
62: fv1.flex_value_id com_id,

Line 131: from fii_ccc_mgr_gt gt, hr_all_organization_units ou

127: -- date_to null is also considered because the organizations having null
128: -- to date will not be considered as inactive.
129: cursor missing_csr is
130: select distinct ou.name
131: from fii_ccc_mgr_gt gt, hr_all_organization_units ou
132: where gt.manager is null
133: and gt.ccc_org_id = ou.organization_id
134: and (to_date(to_char(date_to,'mm/dd/yyyy'),'mm/dd/yyyy') >= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'mm/dd/yyyy')
135: or date_to is null);

Line 145: load_ccc_mgr ( l_retcode ); -- in case fii_ccc_mgr_gt has not been loaded

141: if g_debug_flag = 'Y' then
142: FII_MESSAGE.Func_Ent('FII_GL_EXTRACTION_UTIL.CHECK_MISSING_CCC_MGR');
143: end if;
144:
145: load_ccc_mgr ( l_retcode ); -- in case fii_ccc_mgr_gt has not been loaded
146:
147: for missing_csr_rec in missing_csr loop
148: l_count := l_count +1;
149: