APPS.CLN_NP_PROCESSOR_PKG dependencies on CLN_COLL_HIST_HDR

Line 274: FROM CLN_COLL_HIST_HDR

270: SELECT application_id, collaboration_type, org_id, document_no,
271: doc_revision_no, release_no, collaboration_id, document_owner
272: INTO l_application_id, l_collaboration_type, l_org_id, l_document_number,
273: l_revision_number, l_release_number, l_collaboration_id, l_document_owner
274: FROM CLN_COLL_HIST_HDR
275: WHERE collaboration_id = p_coll_id;
276: ELSIF ( (p_reference IS NOT NULL) AND (LENGTH(TRIM(p_reference)) <> 0) ) THEN
277: SELECT application_id, collaboration_type, org_id, document_no,
278: doc_revision_no, release_no, collaboration_id,document_owner

Line 281: FROM CLN_COLL_HIST_HDR

277: SELECT application_id, collaboration_type, org_id, document_no,
278: doc_revision_no, release_no, collaboration_id,document_owner
279: INTO l_application_id, l_collaboration_type, l_org_id, l_document_number,
280: l_revision_number, l_release_number, l_collaboration_id, l_document_owner
281: FROM CLN_COLL_HIST_HDR
282: WHERE APPLICATION_REFERENCE_ID = p_reference;
283: ELSIF (p_int_con_no IS NOT NULL) THEN -- added 28 June 2004.
284: SELECT application_id, collaboration_type, org_id, document_no,
285: doc_revision_no, release_no, collaboration_id, l_document_owner

Line 288: FROM CLN_COLL_HIST_HDR

284: SELECT application_id, collaboration_type, org_id, document_no,
285: doc_revision_no, release_no, collaboration_id, l_document_owner
286: INTO l_application_id, l_collaboration_type, l_org_id, l_document_number,
287: l_revision_number, l_release_number, l_collaboration_id, l_document_owner
288: FROM CLN_COLL_HIST_HDR
289: WHERE xmlg_internal_control_number = p_int_con_no;
290: END IF;
291:
292: l_tp_id := p_tp_id;

Line 725: FROM CLN_COLL_HIST_HDR

721: END IF;
722:
723: SELECT OWNER_ROLE
724: INTO l_role
725: FROM CLN_COLL_HIST_HDR
726: where COLLABORATION_ID = l_collaboration_id;
727:
728: IF (l_Debug_Level <= 1) THEN
729: ecx_cln_debug_pub.Add('Notification Receiver '||l_role, 1);