APPS.GCS_HIERARCHIES_PKG dependencies on GCS_HIERARCHIES_B

Line 83: FROM gcs_hierarchies_b hb

79: creation_date DATE,
80: created_by NUMBER) IS
81: CURSOR hier_row IS
82: SELECT rowid
83: FROM gcs_hierarchies_b hb
84: WHERE hb.hierarchy_id = insert_row.hierarchy_id;
85: BEGIN
86: IF hierarchy_id IS NULL THEN
87: raise no_data_found;

Line 89: INSERT INTO gcs_hierarchies_b

85: BEGIN
86: IF hierarchy_id IS NULL THEN
87: raise no_data_found;
88: END IF;
89: INSERT INTO gcs_hierarchies_b
90: (hierarchy_id,
91: top_entity_id,
92: start_date,
93: calendar_id,

Line 129: FROM gcs_hierarchies_b hb

125: created_by
126: FROM dual
127: WHERE NOT EXISTS
128: (SELECT 1
129: FROM gcs_hierarchies_b hb
130: WHERE hb.hierarchy_id = insert_row.hierarchy_id);
131: INSERT INTO gcs_hierarchies_tl
132: (hierarchy_id,
133: language,

Line 215: UPDATE gcs_hierarchies_b hb

211: last_update_login NUMBER,
212: creation_date DATE,
213: created_by NUMBER) IS
214: BEGIN
215: UPDATE gcs_hierarchies_b hb
216: SET top_entity_id = update_row.top_entity_id,
217: start_date = update_row.start_date,
218: calendar_id = update_row.calendar_id,
219: dimension_group_id = update_row.dimension_group_id,

Line 333: FROM GCS_HIERARCHIES_B hb

329: f_start_date := nvl(to_date(start_date, 'YYYY/MM/DD'), sysdate);
330: BEGIN
331: SELECT hb.last_updated_by, hb.last_update_date
332: INTO db_luby, db_ludate
333: FROM GCS_HIERARCHIES_B hb
334: WHERE hb.hierarchy_id = load_row.hierarchy_id;
335: -- Test for customization information
336: IF fnd_load_util.upload_test(f_luby,
337: f_ludate,

Line 2087: FROM gcs_hierarchies_b hb

2083: FROM gcs_cons_relationships r
2084: WHERE r.hierarchy_id = p_hier_id
2085: AND r.parent_entity_id =
2086: (SELECT hb.top_entity_id
2087: FROM gcs_hierarchies_b hb
2088: WHERE hb.hierarchy_id = p_hier_id)
2089: AND r.start_date <= nvl(r.end_date, r.start_date)
2090: AND p_removal_date <= nvl(r.end_date, p_removal_date)
2091: AND r.actual_ownership_flag = 'Y';

Line 2613: FROM gcs_hierarchies_b b,

2609:
2610: SELECT tl.hierarchy_name,
2611: b.fem_ledger_id
2612: INTO l_hierarchy_name,l_ledger_id
2613: FROM gcs_hierarchies_b b,
2614: gcs_hierarchies_tl tl
2615: WHERE b.hierarchy_id = tl.hierarchy_id
2616: AND tl.hierarchy_id = p_hierarchy_id
2617: AND tl.language = userenv('LANG');