DBA Data[Home] [Help]

APPS.CLN_XMLG_EVENT_HANDLER_PKG dependencies on CLN_COLL_HIST_HDR

Line 173: FROM CLN_COLL_HIST_HDR

169: -- Getting Collaboration ID for the Application Refernce ID
170: BEGIN
171: SELECT collaboration_id
172: INTO l_coll_id
173: FROM CLN_COLL_HIST_HDR
174: WHERE APPLICATION_REFERENCE_ID = l_app_ref_id;
175: EXCEPTION
176: WHEN NO_DATA_FOUND THEN
177: l_coll_exists_flag := false;

Line 184: FROM CLN_COLL_HIST_HDR

180: IF NOT l_coll_exists_flag THEN
181: BEGIN
182: SELECT collaboration_id
183: INTO l_coll_id
184: FROM CLN_COLL_HIST_HDR
185: WHERE xmlg_msg_id = p_msg_id;
186:
187: l_coll_exists_flag := true;
188:

Line 557: FROM CLN_COLL_HIST_HDR

553:
554: BEGIN
555: SELECT collaboration_id
556: INTO l_coll_id
557: FROM CLN_COLL_HIST_HDR
558: WHERE APPLICATION_REFERENCE_ID = l_app_ref_id;
559: EXCEPTION
560: WHEN NO_DATA_FOUND THEN
561: l_coll_id := NULL;