APPS.GCS_CATEGORIES_PKG dependencies on GCS_CATEGORIES_B

Line 27: FROM gcs_categories_b cb

23: last_update_login NUMBER,
24: object_version_number NUMBER) IS
25: CURSOR catg_row IS
26: SELECT rowid
27: FROM gcs_categories_b cb
28: WHERE cb.category_code= insert_row.category_code;
29:
30: BEGIN
31: IF category_code IS NULL THEN

Line 35: INSERT INTO gcs_categories_b

31: IF category_code IS NULL THEN
32: raise no_data_found;
33: END IF;
34:
35: INSERT INTO gcs_categories_b
36: (category_code,
37: category_number,
38: net_to_re_flag,
39: target_entity_code,

Line 72: FROM gcs_categories_b cb

68: insert_row.object_version_number
69: FROM dual
70: WHERE NOT EXISTS
71: (SELECT 1
72: FROM gcs_categories_b cb
73: WHERE cb.category_code= insert_row.category_code);
74:
75: -- Bugfix 5158937 : Inserted rows for the other installed languages on the env.
76: INSERT INTO gcs_categories_tl(

Line 137: UPDATE gcs_categories_b cb

133: last_updated_by NUMBER,
134: last_update_login NUMBER,
135: object_version_number NUMBER) IS
136: BEGIN
137: UPDATE gcs_categories_b cb
138: SET category_number = update_row.category_number,
139: net_to_re_flag = update_row.net_to_re_flag,
140: target_entity_code = update_row.target_entity_code,
141: category_type_code = update_row.category_type_code,

Line 238: FROM GCS_CATEGORIES_B cb

234:
235: BEGIN
236: SELECT cb.last_updated_by, cb.last_update_date
237: INTO db_luby, db_ludate
238: FROM GCS_CATEGORIES_B cb
239: WHERE cb.category_code = load_row.category_code;
240:
241: -- Test for customization information
242: IF fnd_load_util.upload_test( f_luby, f_ludate, db_luby, db_ludate,

Line 391: FROM gcs_categories_b

387: net_to_re_flag,
388: target_entity_code,
389: support_multi_parents_flag
390: BULK COLLECT INTO g_oper_category_info
391: FROM gcs_categories_b
392: WHERE target_entity_code = 'CHILD'
393: --Bugfix : 4209435
394: AND enabled_flag = 'Y'
395: AND category_type_code IN ('CONSOLIDATION_RULE', 'ELIMINATION_RULE')

Line 404: FROM gcs_categories_b

400: net_to_re_flag,
401: target_entity_code,
402: support_multi_parents_flag
403: BULK COLLECT INTO g_cons_category_info
404: FROM gcs_categories_b
405: WHERE target_entity_code IN ('ELIMINATION', 'PARENT')
406: --Bugfix : 4209435
407: AND enabled_flag = 'Y'
408: AND category_type_code IN ('CONSOLIDATION_RULE', 'ELIMINATION_RULE')