APPS.CLN_PO_CHANGE_RESPONSE_PKG dependencies on PO_HEADERS_ALL

Line 94: select revision_num into l_revision_num from po_headers_all where po_header_id = l_header_id;

90: -- Get the revision number
91: IF l_release_id is not null and l_release_id > 0 THEN
92: select revision_num into l_revision_num from po_releases_all where po_release_id = l_release_id;
93: ELSE
94: select revision_num into l_revision_num from po_headers_all where po_header_id = l_header_id;
95: END IF;
96:
97:
98: EXCEPTION

Line 126: FROM PO_HEADERS_ALL

122:
123: BEGIN
124: SELECT VENDOR_ID, VENDOR_SITE_ID
125: INTO l_party_id, l_party_site_id
126: FROM PO_HEADERS_ALL
127: WHERE PO_HEADER_ID = l_header_id;
128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN
130: l_msg_data := 'Trading Partner Details not found for PO Header ID ='||l_header_id;

Line 139: cln_debug_pub.Add('======== FROM THE PO_HEADERS_ALL TABLE ======== ',1);

135: RAISE FND_API.G_EXC_ERROR;
136: END;
137:
138: IF (l_Debug_Level <= 1) THEN
139: cln_debug_pub.Add('======== FROM THE PO_HEADERS_ALL TABLE ======== ',1);
140: cln_debug_pub.Add('Trading Partner ID - '||l_party_id,1);
141: cln_debug_pub.Add('Trading Partner site ID - '||l_party_site_id,1);
142: cln_debug_pub.Add('================================================ ',1);
143: END IF;