The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* 4169685: REMOVE INSTALL DATA INSERTION FROM HR_LOCATIONS TABLE */
IF NOT itg_x_utils.g_initialized THEN
g_return_status := FND_API.G_RET_STS_ERROR;
CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION(
x_return_status => l_status,
x_msg_data => l_msg_data,
p_coll_id => g_collaboration_id,
p_app_id => NULL,
p_ref_id => p_refid,
p_rel_no => NULL,
p_doc_no => p_doc,
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_cln_status,
p_doc_type => g_doctyp,
p_doc_dir => 'IN',
p_coll_pt => itg_x_utils.c_coll_pt,
p_org_ref => NULL,
p_doc_status => l_doc_status,
p_notification_id => NULL,
p_msg_text => l_message,
p_xmlg_msg_id => NULL,
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,
x_dtl_coll_id => l_dtl_id,
p_xmlg_internal_control_number => p_refid,
p_doc_creation_date => p_cdate,
p_doc_revision_date => SYSDATE,
p_org_id => g_org
);
itg_debug_pub.Add('CLN update_collaboration retsts> ' || l_status,6);
itg_debug_pub.Add('CLN update_collaboration retmsg> ' || l_msg_data,6);
/* Delete global message table*/
FND_MSG_PUB.Delete_Msg;
PROCEDURE Update_PoLine(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_validation_level IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_po_code IN VARCHAR2,
p_org_id IN VARCHAR2,
p_release_id IN VARCHAR2,
p_line_num IN NUMBER,
p_doc_type IN VARCHAR2,
p_quantity IN NUMBER,
p_amount IN NUMBER
) IS
BEGIN
IF (l_Debug_Level <= 2) THEN
itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Update_PoLine', 2);
itg_debug_pub.Add('wUPL - Calling ITG_SyncPoInbound_PVT.Update_PoLine API' ,1);
ITG_SyncPoInbound_PVT.Update_PoLine(
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_po_code => p_po_code,
p_org_id => p_org_id,
p_release_id => p_release_id,
p_line_num => p_line_num,
p_doc_type => p_doc_type,
p_quantity => p_quantity,
p_amount => p_amount
);
check_return_status('Update_PoLine2', x_return_status);
itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Update_PoLine', 2);
itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Update_PoLine : OTHER ERROR', 6);
END Update_PoLine;