[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* 4169685: REMOVE INSTALL DATA INSERTION FROM HR_LOCATIONS TABLE
* Missing Trading Partner setup and/or Connector uninitialized.
* Should never get here, since the workflow should not be activated.
*/
resultout := 'ERROR';
PROCEDURE update_outbound_collaboration(
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout OUT NOCOPY VARCHAR2
) IS
l_org_id NUMBER;
itg_debug_pub.Add('--- Entering update_outbound_collaboration ---' ,2);
/* 4169685: REMOVE INSTALL DATA INSERTION FROM HR_LOCATIONS TABLE
* Missing Trading Partner setup and/or Connector uninitialized.
* Should never get here, since the workflow should not be activated.
*/
resultout := 'ERROR';
CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION(
x_return_status => l_return_status,
x_msg_data => l_buff,
p_coll_id => l_coll_id,
/* Returned from previous call */
p_app_id => itg_x_utils.c_application_id,
p_ref_id => l_ref_id,
/* The value of .. ? */
p_rel_no => NULL,
p_doc_no => NULL,
p_doc_rev_no => NULL,
p_xmlg_transaction_type => NULL,
p_xmlg_transaction_subtype => NULL,
p_xmlg_document_id => NULL,
p_resend_flag => NULL,
p_resend_count => NULL,
p_disposition => NULL,
p_coll_status => 'COMPLETED',
p_doc_type => l_doc_type,
p_doc_dir => 'OUT',
p_coll_pt => itg_x_utils.c_xmlg_coll_pt,
p_org_ref => NULL,
p_doc_status => 'SUCCESS',
p_notification_id => NULL,
p_msg_text => 'Document successfully sent',
p_tr_partner_type => itg_x_utils.c_party_type,
p_tr_partner_id => itg_x_utils.g_party_id,
p_tr_partner_site => itg_x_utils.g_party_site_id,
p_sender_component => NULL,
p_rosettanet_check_required => FALSE,
p_xmlg_msg_id => l_xmlg_msg_id,
x_dtl_coll_id => l_collaboration_dtl_id,
p_xml_event_key => l_xml_event_key
);
itg_debug_pub.Add('--- Exting update_outbound_collaboration ---' ,2);
WF_CORE.CONTEXT('itg_wf_utils', 'update_outbound_collaboration',
itemtype, itemkey, to_char(actid), funcmode);
itg_debug_pub.Add('--- Exting update_outbound_collaboration :ERROR---' ,6);
END update_outbound_collaboration;
PROCEDURE update_outbound_collab_cbod(
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout OUT NOCOPY VARCHAR2
) IS
l_org_id NUMBER;
itg_debug_pub.Add('--- Entering update_outbound_collab_cbod ---' ,2);
select nls_language
into l_nls_lang
from fnd_languages
where language_code = l_lang;
/* 4169685: REMOVE INSTALL DATA INSERTION FROM HR_LOCATIONS TABLE
* Missing Trading Partner setup and/or Connector uninitialized.
* Should never get here, since the workflow should not be activated.
*/
resultout := 'ERROR';
CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION(
x_return_status => l_return_status,
x_msg_data => l_buff,
p_coll_id => l_coll_id,
/* Returned from previous call */
p_app_id => itg_x_utils.c_application_id,
p_ref_id => NULL,
p_rel_no => NULL,
p_doc_no => NULL,
p_doc_rev_no => NULL,
p_xmlg_transaction_type => NULL,
p_xmlg_transaction_subtype => NULL,
p_xmlg_document_id => NULL,
p_resend_flag => NULL,
p_resend_count => NULL,
p_disposition => NULL,
p_coll_status => l_coll_status, /*'COMPLETED',*/
p_doc_type => l_doc_type,
p_doc_dir => 'OUT',
p_coll_pt => itg_x_utils.c_xmlg_coll_pt,
p_org_ref => NULL,
p_doc_status => 'SUCCESS',
p_notification_id => NULL,
p_msg_text => 'Document successfully sent',
p_tr_partner_type => itg_x_utils.c_party_type,
p_tr_partner_id => itg_x_utils.g_party_id,
p_tr_partner_site => itg_x_utils.g_party_site_id,
p_sender_component => NULL,
p_rosettanet_check_required => FALSE,
p_xmlg_msg_id => l_xmlg_msg_id,
x_dtl_coll_id => l_collaboration_dtl_id
);
itg_debug_pub.Add('--- Exiting update_outbound_collab_cbod ---' ,2);
WF_CORE.CONTEXT('itg_wf_utils', 'update_outbound_collaboration cbod',
itemtype, itemkey, to_char(actid), funcmode);
itg_debug_pub.Add('--- Exting update_outbound_collab_cbod :ERROR---' ,6);
END update_outbound_collab_cbod;
itg_debug_pub.Add('--- Entering update_set_cbod_description ---' ,2);
SELECT NLS_LANGUAGE
INTO l_nls_language
FROM FND_LANGUAGES
WHERE LANGUAGE_CODE = parameter5
AND installed_flag in ('B','I') ;
itg_debug_pub.Add('--- Exiting update_set_cbod_description ---' ,2);