The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fet_cons.entity_name,
fet_cons.entity_id,
fet_child.entity_name,
fet_counter.entity_name,
fet_counter.entity_id,
gcerd.run_name,
gcerd.entry_id,
gdtct.data_type_name,
fcpt.cal_period_name,
ght.hierarchy_name,
gcerd.request_error_code,
gcerd.category_code,
--nvl(fea_cons.varchar_assign_value, fea_child.varchar_assign_value) contact
fea_child.varchar_assign_value,
-- Bug fix 5245250
fnd_flex_values_s.NEXTVAL
INTO l_cons_entity_name,
l_cons_entity_id,
l_entity_name,
l_counter_entity_name,
l_counter_entity_id,
l_run_name,
l_entry_id,
l_balance_type,
l_date,
l_hierarchy_name,
l_status,
l_category_code,
l_recipient,
-- Bug fix 5245250
l_seq
FROM gcs_cons_eng_run_dtls gcerd,
fem_entities_tl fet_cons,
fem_entities_tl fet_child,
fem_entities_tl fet_counter,
gcs_hierarchies_tl ght,
gcs_cons_eng_runs gcer,
gcs_data_type_codes_b gdtcb,
gcs_data_type_codes_tl gdtct,
fem_cal_periods_tl fcpt,
--fem_entities_attr fea_cons,
fem_entities_attr fea_child
WHERE gcerd.run_detail_id = p_cons_detail_id
AND gcerd.consolidation_entity_id = fet_cons.entity_id
AND gcerd.child_entity_id = fet_child.entity_id (+)
AND gcerd.contra_child_entity_id = fet_counter.entity_id (+)
AND gcerd.run_name = gcer.run_name
AND gcerd.consolidation_entity_id = gcer.run_entity_id
AND gcer.hierarchy_id = ght.hierarchy_id
AND ght.language = userenv('LANG')
AND fet_cons.language = userenv('LANG')
AND fet_child.language (+)= userenv('LANG')
AND fet_counter.language (+) = userenv('LANG')
AND gcer.balance_type_code = gdtcb.data_type_code
AND gdtcb.data_type_id = gdtct.data_type_id
AND gdtct.language = userenv('LANG')
AND gcer.cal_period_id = fcpt.cal_period_id
AND fcpt.language = userenv('LANG')
--AND fea_cons.entity_id = fet_cons.entity_id
AND fea_child.entity_id (+)= fet_child.entity_id
--AND fea_cons.attribute_id = l_entity_contact_attr
--AND fea_cons.version_id = l_entity_contact_ver
AND fea_child.attribute_id (+)= l_entity_contact_attr
AND fea_child.version_id (+)= l_entity_contact_ver;
SELECT fea_counter.varchar_assign_value
INTO l_counter_recipient
FROM fem_entities_attr fea_counter
WHERE fea_counter.entity_id = l_counter_entity_id
AND fea_counter.attribute_id = l_entity_contact_attr
AND fea_counter.version_id = l_entity_contact_ver;
SELECT fet_cons.entity_name,
gdtct.data_type_name,
fcpt.cal_period_name,
ght.hierarchy_name,
fea_cons.varchar_assign_value,
-- Bug fix 5245250
fnd_flex_values_s.NEXTVAL
INTO l_cons_entity_name,
l_balance_type,
l_date,
l_hierarchy_name,
l_recipient,
-- Bug fix 5245250
l_seq
FROM fem_entities_tl fet_cons,
gcs_hierarchies_tl ght,
gcs_cons_eng_runs gcer,
gcs_data_type_codes_b gdtcb,
gcs_data_type_codes_tl gdtct,
fem_entities_attr fea_cons,
fem_cal_periods_tl fcpt
WHERE p_run_name = gcer.run_name
AND gcer.run_entity_id = p_cons_entity_id
AND gcer.run_entity_id = fet_cons.entity_id
AND gcer.hierarchy_id = ght.hierarchy_id
AND ght.language = userenv('LANG')
AND fet_cons.language = userenv('LANG')
AND gcer.balance_type_code = gdtcb.data_type_code
AND gdtcb.data_type_id = gdtct.data_type_id
AND gdtct.language = userenv('LANG')
AND fea_cons.entity_id = gcer.run_entity_id
AND fea_cons.attribute_id = l_entity_contact_attr
AND fea_cons.version_id = l_entity_contact_ver
AND gcer.cal_period_id = fcpt.cal_period_id
AND fcpt.language = userenv('LANG');
SELECT fet_cons.entity_name,
gdtct.data_type_name,
fcpt.cal_period_name,
ght.hierarchy_name,
fea_cons.varchar_assign_value,
-- Bug fix 5245250
fnd_flex_values_s.NEXTVAL
INTO l_cons_entity_name,
l_balance_type,
l_date,
l_hierarchy_name,
l_recipient,
-- Bug fix 5245250
l_seq
FROM fem_entities_tl fet_cons,
gcs_hierarchies_tl ght,
gcs_cons_eng_runs gcer,
gcs_data_type_codes_b gdtcb,
gcs_data_type_codes_tl gdtct,
fem_cal_periods_tl fcpt,
fem_entities_attr fea_cons
WHERE p_run_name = gcer.run_name
AND gcer.run_entity_id = p_cons_entity_id
AND gcer.run_entity_id = fet_cons.entity_id
AND gcer.hierarchy_id = ght.hierarchy_id
AND ght.language = userenv('LANG')
AND fet_cons.language = userenv('LANG')
AND gcer.balance_type_code = gdtcb.data_type_code
AND gdtcb.data_type_id = gdtct.data_type_id
AND gdtct.language = userenv('LANG')
AND fea_cons.entity_id = gcer.run_entity_id
AND fea_cons.attribute_id = l_entity_contact_attr
AND fea_cons.version_id = l_entity_contact_ver
AND gcer.cal_period_id = fcpt.cal_period_id
AND fcpt.language = userenv('LANG');
PROCEDURE update_consolidation( p_itemtype IN VARCHAR2,
p_itemkey IN VARCHAR2,
p_actid IN NUMBER,
p_funcmode IN VARCHAR2,
p_result IN OUT NOCOPY VARCHAR2)
IS
l_run_dtl_id NUMBER(15);
l_api_name VARCHAR2(80) := 'update_consolidation';
SELECT wn.notification_id nid
FROM wf_notifications wn,
wf_item_activity_statuses wias
WHERE wn.group_id = wias.notification_id
AND wias.item_type = p_item_type
AND wias.item_key = p_item_key;
UPDATE gcs_cons_eng_run_dtls
SET notification_id = l_ntf_id
WHERE run_detail_id = l_run_dtl_id;
END update_consolidation;