APPS.CLN_ACK_PO_PKG dependencies on DUAL

Line 103: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

99: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EVENT_RAISED');
100: FND_MESSAGE.SET_TOKEN('EVENT','Update');
101: x_msg_data := FND_MESSAGE.GET;
102:
103: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
104:
105: IF (l_Debug_Level <= 1) THEN
106: cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------', 1);
107: cln_debug_pub.Add('Collaboration ID ---- '||p_coll_id, 1);

Line 218: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

214: FND_MESSAGE.SET_TOKEN('EVENT','Add Messages');
215: x_msg_data := FND_MESSAGE.GET;
216:
217:
218: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
219:
220: IF (l_Debug_Level <= 1) THEN
221: cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------',1);
222: cln_debug_pub.Add('Collaboration ID ---- '||p_coll_id, 1);

Line 557: select cln_generic_s.NEXTVAL INTO l_txn_id FROM DUAL;

553: cln_debug_pub.Add('Return status is : '||x_return_status,1);
554: END IF;
555:
556: -- get the sequence number for Transaction id.
557: select cln_generic_s.NEXTVAL INTO l_txn_id FROM DUAL;
558: IF (l_Debug_Level <= 2) THEN
559: cln_debug_pub.Add('Transaction ID :' || l_txn_id, 1);
560: END IF;
561:

Line 850: select cln_generic_s.NEXTVAL INTO l_txn_id FROM DUAL;

846: cln_debug_pub.Add('----------------------------------',1);
847: END IF;
848:
849: -- get the sequence number for Transaction id.
850: select cln_generic_s.NEXTVAL INTO l_txn_id FROM DUAL;
851: IF (l_Debug_Level <= 1) THEN
852: cln_debug_pub.Add('Transaction ID:' || l_txn_id, 1);
853: END IF;
854:

Line 1740: select cln_generic_s.NEXTVAL INTO l_txn_id FROM DUAL;

1736: cln_debug_pub.Add('Return status is : '||x_return_status,1);
1737: END IF;
1738:
1739: -- get the sequence number for Transaction id.
1740: select cln_generic_s.NEXTVAL INTO l_txn_id FROM DUAL;
1741: IF (l_Debug_Level <= 2) THEN
1742: cln_debug_pub.Add('Transaction ID :' || l_txn_id, 1);
1743: END IF;
1744:

Line 2034: select cln_generic_s.NEXTVAL INTO l_txn_id FROM DUAL;

2030: cln_debug_pub.Add('----------------------------------',1);
2031: END IF;
2032:
2033: -- get the sequence number for Transaction id.
2034: select cln_generic_s.NEXTVAL INTO l_txn_id FROM DUAL;
2035: IF (l_Debug_Level <= 1) THEN
2036: cln_debug_pub.Add('Transaction ID:' || l_txn_id, 1);
2037: END IF;
2038: