The following lines contain the word 'select', 'insert', 'update' or 'delete':
-- this loop would read each row of the input table and insert
-- a corresponding row in the relationship table
-- if any error occurs it would rollback, thereby erasing all
-- of the inserted rows in the relationship table tiil that point
-- (by this call only)
-- Inteer event table data is already validated by calling routine
-- because of this we need not validate data again
while i is not null loop
/* BUG Fix 3135128. SKARIMIS . Added a IF condition to eliminate the posting of orphan childs*/
IF (p_inter_event_tbl(i).parent_erecord_id is not NULL) THEN
/* Bugfix 3169361 SRPURI added new condition AND NVL(p_inter_event_tbl(i).child_erecord_id,-1) <> -1
to resolve issue when child is not required */
IF (p_inter_event_tbl(i).parent_erecord_id <> -1) AND
NVL(p_inter_event_tbl(i).child_erecord_id,-1) <> -1 THEN
edr_event_relationship_pub.CREATE_RELATIONSHIP
( p_api_version => 1.0 ,
p_init_msg_list => FND_API.G_FALSE ,
p_commit => FND_API.G_FALSE ,
p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
x_return_status => l_return_status ,
x_msg_count => l_msg_count ,
x_msg_data => l_msg_data ,
p_parent_erecord_id => p_inter_event_tbl(i).parent_erecord_id ,
p_parent_event_name => p_inter_event_tbl(i).parent_event_name ,
p_parent_event_key => p_inter_event_tbl(i).parent_event_key ,
p_child_erecord_id => p_inter_event_tbl(i).child_erecord_id ,
p_child_event_name => p_inter_event_tbl(i).child_event_name ,
p_child_event_key => p_inter_event_tbl(i).child_event_key ,
x_relationship_id => l_relationship_id
);
select event_name,event_key into l_child_event_name,l_child_event_key
from edr_psig_documents
where document_id = parent_child_record(i).child_erecord_id;
select count(*) from edr_psig_documents
where event_name = p_parent_event_name
and event_key = p_parent_event_key
and document_id = p_parent_erecord_id;
select count(*) from wf_events_vl
where name = p_parent_event_name;
select event_name from edr_psig_documents
where document_id = p_erecord_id;