APPS.GCS_CONS_MONITOR_PKG dependencies on GCS_CONS_DATA_STATUSES

Line 114: FROM gcs_cons_data_statuses gcds,

110: -- end of bug fix 4554149
111:
112: CURSOR c_cons_entities IS
113: SELECT gcds.status_code
114: FROM gcs_cons_data_statuses gcds,
115: fem_entities_attr fea,
116: gcs_cons_relationships gcr
117: WHERE gcr.child_entity_id = gcds.consolidation_entity_id
118: AND gcds.cal_period_id = p_cal_period_id

Line 233: MERGE INTO gcs_cons_data_statuses gcds

229: IF (l_total_cnt < l_child_cnt AND l_status_code <> 'NOT_STARTED') THEN
230: l_status_code := 'IN_PROGRESS';
231: END IF;
232:
233: MERGE INTO gcs_cons_data_statuses gcds
234: USING (SELECT l_status_code status_code FROM dual) src
235: ON (gcds.hierarchy_id = p_hierarchy_id AND
236: gcds.consolidation_entity_id = p_entity_id AND
237: gcds.cal_period_id = p_cal_period_id AND

Line 267: -- update the gcs_cons_data_statuses table for a newly added entity in the specified hierarchy

263: fnd_global.user_id,
264: sysdate);
265: END load_entity;
266:
267: -- update the gcs_cons_data_statuses table for a newly added entity in the specified hierarchy
268: -- from the start date
269: -- it first insert into the gcs_cons_data_statuses table
270: -- then update gcs_cons_data_statuses for the cal_period_id and balance_type_code not loaded with
271: -- this entity

Line 269: -- it first insert into the gcs_cons_data_statuses table

265: END load_entity;
266:
267: -- update the gcs_cons_data_statuses table for a newly added entity in the specified hierarchy
268: -- from the start date
269: -- it first insert into the gcs_cons_data_statuses table
270: -- then update gcs_cons_data_statuses for the cal_period_id and balance_type_code not loaded with
271: -- this entity
272: PROCEDURE add_entity(p_entity_id IN NUMBER,
273: p_hierarchy_id IN NUMBER,

Line 270: -- then update gcs_cons_data_statuses for the cal_period_id and balance_type_code not loaded with

266:
267: -- update the gcs_cons_data_statuses table for a newly added entity in the specified hierarchy
268: -- from the start date
269: -- it first insert into the gcs_cons_data_statuses table
270: -- then update gcs_cons_data_statuses for the cal_period_id and balance_type_code not loaded with
271: -- this entity
272: PROCEDURE add_entity(p_entity_id IN NUMBER,
273: p_hierarchy_id IN NUMBER,
274: p_start_date IN DATE) IS

Line 329: UPDATE gcs_cons_data_statuses gcds

325: p_entity_id || ' p_hierarchy_id = ' || p_hierarchy_id || ' ' ||
326: ' p_start_date = ' || p_start_date || ' ' ||
327: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
328: END IF;
329: UPDATE gcs_cons_data_statuses gcds
330: SET status_code = 'IN_PROGRESS',
331: last_update_date = sysdate,
332: last_updated_by = fnd_global.user_id
333: WHERE hierarchy_id = p_hierarchy_id

Line 463: -- Update the gcs_cons_data_statuses when a new hierarchy is created,

459: --
460: -- Procedure
461: -- update_data_status
462: -- Purpose
463: -- Update the gcs_cons_data_statuses when a new hierarchy is created,
464: -- or an entity is added/deleted, or new data submitted
465: -- Arguments
466: -- p_load_id Data submission identifier
467: -- p_cons_rel_id Consolidation relationship identifier

Line 557: FROM gcs_cons_data_statuses gcds,

553: CURSOR c_parent_info(p_end_date DATE, p_hierarchy_id NUMBER, p_entity_id NUMBER) IS
554: SELECT gcds.cal_period_id,
555: gcds.balance_type_code,
556: fcpa.date_assign_value
557: FROM gcs_cons_data_statuses gcds,
558: fem_cal_periods_attr fcpa
559: WHERE hierarchy_id = p_hierarchy_id
560: AND consolidation_entity_id = p_entity_id
561: AND gcds.cal_period_id = fcpa.cal_period_id

Line 804: -- Submits update gcs_cons_data_statuses when a new hierarchy is created,

800: --
801: -- Procedure
802: -- submit_update_data_status
803: -- Purpose
804: -- Submits update gcs_cons_data_statuses when a new hierarchy is created,
805: -- or an entity is added/deleted, or new data submitted
806: -- Arguments
807: -- p_load_id Data submission identifier
808: -- p_cons_rel_id Consolidation relationship identifier