APPS.CLN_PO_SYNC_CAT_PKG dependencies on DUAL

Line 500: FROM DUAL;

496: END IF;
497:
498: SELECT cln_generic_s.nextval
499: INTO l_line_num
500: FROM DUAL;
501:
502: IF (l_Debug_Level <= 1) THEN
503: cln_debug_pub.Add('l_line_num:' || l_line_num, 1);
504: END IF;

Line 571: FROM DUAL;

567: IF p_operation = 'INSERT' THEN
568: -- Create a new BPO Line
569: SELECT cln_generic_s.nextval
570: INTO l_line_num
571: FROM DUAL;
572: x_line_num := l_line_num;
573: INSERT INTO po_lines_interface(interface_header_id,
574: interface_line_id,
575: item,

Line 654: FROM DUAL;

650: -- Line does not exist, create a new line
651: cln_debug_pub.Add('Line number does not exist, creating a new row', 1);
652: SELECT cln_generic_s.nextval
653: INTO l_line_num
654: FROM DUAL;
655: x_line_num := l_line_num;
656: cln_debug_pub.Add('x_line_num:' || x_line_num, 1);
657: INSERT INTO po_lines_interface(interface_header_id,
658: interface_line_id,

Line 882: FROM DUAL;

878: -- Create a new BPO Line Price Break
879: -- No need to check,if this exists
880: SELECT cln_generic_s.nextval
881: INTO l_line_ship_num
882: FROM DUAL;
883:
884: INSERT INTO po_lines_interface(interface_header_id,
885: interface_line_id,
886: item,

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

1989: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EVENT_RAISED');
1990: FND_MESSAGE.SET_TOKEN('EVENT','Update');
1991: x_msg_data := FND_MESSAGE.GET;
1992:
1993: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
1994:
1995: IF (l_Debug_Level <= 1) THEN
1996: cln_debug_pub.Add('With the following parameters', 1);
1997: cln_debug_pub.Add('p_ref_id' || p_ref_id, 1);

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

2105: FND_MESSAGE.SET_NAME('CLN', 'CLN_G_RET_MSG_SUCCESS');
2106: x_msg_data := FND_MESSAGE.GET;
2107:
2108:
2109: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
2110:
2111: l_cln_ch_parameters := wf_parameter_list_t();
2112: WF_EVENT.AddParameterToList('COLLABORATION_DETAIL_ID', l_dtl_coll_id, l_cln_ch_parameters);
2113: WF_EVENT.AddParameterToList('REFERENCE_ID1', p_ref1, l_cln_ch_parameters);