[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pos_pub_history_bo(ph.publication_event_id,
ph.party_id,
ph.publication_date,
ph.published_by,
ph.publish_detail,
ph.xmlcontent,
ph.created_by,
ph.creation_date,
ph.last_updated_by,
ph.last_update_date,
ph.last_update_login,
ph.request_id)
BULK COLLECT
INTO l_pos_pub_history_bo_tbl
FROM pos_supp_pub_history ph
WHERE ph.publication_event_id = nvl(l_event_id, publication_event_id)
AND ph.party_id = nvl(l_party_id, party_id);
SELECT 1
FROM pos_supp_pub_history
WHERE publication_event_id = p_event_id AND
party_id = p_party_id;
SELECT 1
FROM pos_supp_pub_responses
WHERE target_system = p_target AND
response_process_id = p_response_id;
INSERT INTO pos_supp_pub_responses(
publication_event_id,
party_id,
target_system,
request_process_id,
request_process_status,
response_process_id,
response_process_status,
target_system_response_date,
error_message,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES (
p_event_id,
p_party_id,
p_target_system,
p_request_process_id,
p_request_process_status,
p_response_process_id,
p_response_process_status,
sysdate,
p_message,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.login_id
);