APPS.GCS_RULES_PROCESSOR dependencies on GCS_CATEGORIES_B

Line 40: invalid_category_code EXCEPTION; -- unable to get data from gcs_categories_b

36: no_default_cctr_found EXCEPTION; -- used in initEntriesGT_tgtDimSet()
37: convert_threshold_err EXCEPTION; -- used in createEntry
38: entry_header_error EXCEPTION; -- GCS_ENTRY_PKG.create_entry_header failed
39: templates_pkg_error EXCEPTION; -- GCS_TEMPLATES_DYNAMIC_PKG may raise
40: invalid_category_code EXCEPTION; -- unable to get data from gcs_categories_b
41:
42: --The cctr_org and interco dims may require special handling
43: --The column names are long strings, so lets use shorter constants
44: cctr_column CONSTANT Varchar2(30) := 'COMPANY_COST_CENTER_ORG_ID';

Line 186: From gcs_categories_b

182: org_output_code,
183: -- interco_output_code, -- changes made by yingliu
184: net_to_re_flag,
185: support_multi_parents_flag -- changes made by yingliu
186: From gcs_categories_b
187: Where category_code = contextData.eventCategory;
188:
189: -- We need a SIGN attribute to set the xtd_balance_e values
190: cursor getSigns(liaAtt number, liaVer number, ataAtt number, ataVer number) is

Line 556: FROM gcs_categories_b

552: WHERE cons_relationship_id = contextData.relationship;
553:
554: CURSOR c_get_target IS
555: SELECT target_entity_code, net_to_re_flag
556: FROM gcs_categories_b
557: WHERE category_code = contextData.eventCategory;
558:
559: l_entities DBMS_SQL.number_table;
560: l_percent DBMS_SQL.number_table;

Line 1166: FROM GCS_CATEGORIES_B

1162: WHERE hierarchy_id = contextData.hierarchy;
1163: */
1164: cursor getSpecificIntercoId is
1165: SELECT SPECIFIC_INTERCOMPANY_ID
1166: FROM GCS_CATEGORIES_B
1167: WHERE CATEGORY_CODE = 'INTRACOMPANY';
1168: -- end of change by yingliu
1169:
1170: cursor getChildEntityType is

Line 2772: FROM GCS_CATEGORIES_B

2768: WHERE hierarchy_id = contextData.hierarchy;
2769: */
2770: cursor getSpecificIntercoId is
2771: SELECT SPECIFIC_INTERCOMPANY_ID
2772: FROM GCS_CATEGORIES_B
2773: WHERE CATEGORY_CODE = 'INTRACOMPANY';
2774: -- end of change by yingliu
2775:
2776: --We need a cctr and interco value to use here.

Line 3528: FROM GCS_CATEGORIES_B

3524: AND D.RULE_STEP_ID = rsi;
3525:
3526: cursor getSpecificIntercoId is
3527: SELECT SPECIFIC_INTERCOMPANY_ID
3528: FROM GCS_CATEGORIES_B
3529: WHERE CATEGORY_CODE = 'INTRACOMPANY';
3530:
3531: --Bugfix 4928211 (STK): Added organization and intercompany values over here
3532: organizationId number;

Line 3614: FROM gcs_categories_b

3610:
3611: --Bugfix 4928211: Determine the organization and intercompany target value
3612: SELECT NVL(specific_intercompany_id, organizationId)
3613: INTO intercompanyId
3614: FROM gcs_categories_b
3615: WHERE category_code = 'INTRACOMPANY';
3616:
3617: end if; -- if contextData.eventType = 'C'
3618: