APPS.FII_GL_COMCCH_C dependencies on FII_CCC_MGR_GT

Line 214: fii_ccc_mgr_gt ct

210: sysdate,
211: g_fii_user_id,
212: g_fii_login_id
213: FROM FII_COM_CC_MAPPINGS_GT dim,
214: fii_ccc_mgr_gt ct
215: WHERE company_cost_center_org_id <> -1
216: and dim.company_cost_center_org_id = ct.CCC_ORG_ID (+);
217:
218: If g_debug_flag = 'Y' then

Line 287: fii_ccc_mgr_gt ct

283: G_UNASSIGNED_LOB_ID,
284: nvl(ct.manager, -1),
285: G_UNASSIGNED_LOB_ID
286: FROM FII_COM_CC_MAPPINGS_GT dim,
287: fii_ccc_mgr_gt ct
288: WHERE dim.company_cost_center_org_id <> -1
289: and dim.company_cost_center_org_id = ct.CCC_ORG_ID (+);
290:
291: If g_debug_flag = 'Y' then

Line 920: --multiple orgs in table fii_ccc_mgr_gt

916: l_count NUMBER(15) :=0;
917: l_ret_val BOOLEAN := FALSE;
918:
919: --this cursor prints out all (company, cost_center) with
920: --multiple orgs in table fii_ccc_mgr_gt
921: Cursor c_duplicate_org is
922: select count(*) cnt,
923: company_id,
924: cost_center_id

Line 925: from fii_ccc_mgr_gt

921: Cursor c_duplicate_org is
922: select count(*) cnt,
923: company_id,
924: cost_center_id
925: from fii_ccc_mgr_gt
926: where company_id is not null
927: and cost_center_id is not null
928: group by company_id, cost_center_id
929: having count(*) > 1;

Line 936: from fii_ccc_mgr_gt gt,

932: Cursor c_list_dup_org (p_com_id number, p_cc_id number) is
933: select com.flex_value company,
934: cc.flex_value cost_center,
935: org.name organization
936: from fii_ccc_mgr_gt gt,
937: hr_all_organization_units org,
938: fnd_flex_values com,
939: fnd_flex_values cc
940: where gt.company_id = p_com_id

Line 983: --Bug 3560006: Add ccc-org in FII_CCC_MGR_GT

979: ---------------------------------------------------------------------------------------
980:
981:
982: --------------------------------------------
983: --Bug 3560006: Add ccc-org in FII_CCC_MGR_GT
984: -- which are not in CCID
985: --------------------------------------------
986:
987: -- First report bad ccc-org in FII_CCC_MGR_GT

Line 987: -- First report bad ccc-org in FII_CCC_MGR_GT

983: --Bug 3560006: Add ccc-org in FII_CCC_MGR_GT
984: -- which are not in CCID
985: --------------------------------------------
986:
987: -- First report bad ccc-org in FII_CCC_MGR_GT
988:
989: g_phase := 'report bad ccc-org in FII_CCC_MGR_GT';
990:
991: l_count := 0;

Line 989: g_phase := 'report bad ccc-org in FII_CCC_MGR_GT';

985: --------------------------------------------
986:
987: -- First report bad ccc-org in FII_CCC_MGR_GT
988:
989: g_phase := 'report bad ccc-org in FII_CCC_MGR_GT';
990:
991: l_count := 0;
992: FOR r_dup_org IN c_duplicate_org LOOP
993: if l_count = 0 then

Line 1023: g_phase := 'Populate FII_COM_CC_MAPPINGS_GT from fii_ccc_mgr_gt';

1019:
1020: --reset l_count to 0
1021: l_count := 0;
1022:
1023: g_phase := 'Populate FII_COM_CC_MAPPINGS_GT from fii_ccc_mgr_gt';
1024:
1025: -- Insert all "good" (company, cost center, ccc org) from FII_CCC_MGR_GT
1026: INSERT INTO FII_COM_CC_MAPPINGS_GT
1027: (COMPANY_COST_CENTER_ORG_ID,

Line 1025: -- Insert all "good" (company, cost center, ccc org) from FII_CCC_MGR_GT

1021: l_count := 0;
1022:
1023: g_phase := 'Populate FII_COM_CC_MAPPINGS_GT from fii_ccc_mgr_gt';
1024:
1025: -- Insert all "good" (company, cost center, ccc org) from FII_CCC_MGR_GT
1026: INSERT INTO FII_COM_CC_MAPPINGS_GT
1027: (COMPANY_COST_CENTER_ORG_ID,
1028: COMPANY_ID,
1029: COST_CENTER_ID,

Line 1035: from fii_ccc_mgr_gt

1031: select NVL(max(ccc_org_id), -1),
1032: company_id,
1033: cost_center_id,
1034: -1
1035: from fii_ccc_mgr_gt
1036: where company_id is not null
1037: and cost_center_id is not null
1038: group by company_id, cost_center_id
1039: having count(*) = 1;

Line 1219: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');

1215: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (p_status);
1216:
1217: IF p_status = -1 then
1218: fii_util.write_log('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
1219: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');
1220: raise NO_DATA_FOUND;
1221: END IF;
1222:
1223: ----------------------------------------------------