APPS.CLN_PO_CHANGE_RESPONSE_PKG dependencies on PO_CHANGE_REQUESTS

Line 75: cln_debug_pub.Add('Querying the PO_CHANGE_REQUESTS table.....',1);

71: l_change_request_group_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'CHANGE_REQUEST_GP_ID'));
72: IF (l_Debug_Level <= 1) THEN
73: cln_debug_pub.Add('Change Request Group ID : ' || l_change_request_group_id, 1);
74:
75: cln_debug_pub.Add('Querying the PO_CHANGE_REQUESTS table.....',1);
76: END IF;
77:
78: BEGIN
79: SELECT max(new_supplier_order_number), max(document_header_id),

Line 87: FROM po_change_requests

83: INTO l_so_number, l_header_id,
84: l_revision_num, l_release_id,
85: l_header_status, l_consolidated_line_status,
86: l_header_response_reason,l_document_num
87: FROM po_change_requests
88: WHERE change_request_group_id = l_change_request_group_id;
89:
90: -- Get the revision number
91: IF l_release_id is not null and l_release_id > 0 THEN

Line 100: l_msg_data := 'No data found in the po_change_requests table for the specified Change_Request_Group_ID ='||l_change_request_group_id;

96:
97:
98: EXCEPTION
99: WHEN NO_DATA_FOUND THEN
100: l_msg_data := 'No data found in the po_change_requests table for the specified Change_Request_Group_ID ='||l_change_request_group_id;
101: IF (l_Debug_Level <= 1) THEN
102: cln_debug_pub.Add(l_msg_data,1);
103: END IF;
104:

Line 109: cln_debug_pub.Add('=========== FROM THE PO_CHANGE_REQUESTS TABLE =================== ',1);

105: RAISE FND_API.G_EXC_ERROR;
106: END;
107:
108: IF (l_Debug_Level <= 1) THEN
109: cln_debug_pub.Add('=========== FROM THE PO_CHANGE_REQUESTS TABLE =================== ',1);
110: cln_debug_pub.Add('Supplier Order Number - '||l_so_number,1);
111: cln_debug_pub.Add('PO Header ID - '||l_header_id,1);
112: cln_debug_pub.Add('Revision Number - '||l_revision_num,1);
113: cln_debug_pub.Add('Release ID - '||l_release_id,1);

Line 321: FROM po_change_requests

317: l_xmlg_int_control_num := null;
318: BEGIN
319: SELECT max(msg_cont_num)
320: INTO l_xmlg_int_control_num
321: FROM po_change_requests
322: WHERE change_request_group_id = l_change_request_group_id;
323:
324: IF (l_Debug_Level <= 1) THEN
325: cln_debug_pub.Add('Internal Control Number got as : ' || l_xmlg_int_control_num);

Line 473: FROM PO_CHANGE_REQUESTS

469:
470: BEGIN
471: SELECT max(SUPPLIER_DOC_REF) -- to compile this code in 11.5.9 env use RESPONSE_REASON
472: INTO X_DATA1
473: FROM PO_CHANGE_REQUESTS
474: WHERE CHANGE_REQUEST_GROUP_ID = to_number(P_CHANGE_REQUEST_GROUP_ID);
475: EXCEPTION
476: WHEN OTHERS THEN
477: l_error_code := SQLCODE;