APPS.CLN_NP_PROCESSOR_PKG dependencies on DUAL

Line 85: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;

81: IF (l_Debug_Level <= 1) THEN
82: ecx_cln_debug_pub.Add('Embedded Notification reqd :' || l_embedded_notif_screen , 1);
83: END IF;
84:
85: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
86:
87: IF(l_embedded_notif_screen = 'N') THEN
88: IF (l_Debug_Level <= 1) THEN
89: ecx_cln_debug_pub.Add('Calling CLN_NPNP/NOTIFY_SOMEONE', 1);

Line 551: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;

547:
548:
549: IF c_actions.action_code = 'START_WORKFLOW' THEN
550: -- attribute1 => Item , attribute2 => Process
551: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
552: IF (l_Debug_Level <= 2) THEN
553: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':' || c_actions.attribute1 || l_notification_flow_key
554: || ':' || c_actions.attribute2, 2);
555: END IF;

Line 861: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;

857: END IF;
858: IF c_actions.attribute15 IS NOT NULL THEN
859: WF_EVENT.AddParameterToList('Attribute14', c_actions.attribute15, l_cln_not_parameters);
860: END IF;
861: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
862: WF_EVENT.Raise(c_actions.attribute1, l_notification_flow_key, NULL, l_cln_not_parameters, NULL);
863: ELSIF c_actions.action_code = 'PROCEDURE_CALL' THEN
864: IF (l_Debug_Level <= 1) THEN
865: ecx_cln_debug_pub.Add('UserDefined PL/SQL API :' || c_actions.attribute1, 1);

Line 870: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;

866: ecx_cln_debug_pub.Add('UserDefined PL/SQL API Mode:' || c_actions.attribute3, 1);
867: END IF;
868:
869: IF c_actions.attribute3 = 'CONCURRENT' THEN
870: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
871: IF (l_Debug_Level <= 2) THEN
872: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
873: END IF;
874:

Line 1081: SELECT REPLACE(p_reason_code, '::', ':') INTO l_all_reason_codes FROM DUAL;

1077: END IF;
1078:
1079: l_update_collaboration_flag := FALSE; -- no need to update second or third time
1080: ELSE
1081: SELECT REPLACE(p_reason_code, '::', ':') INTO l_all_reason_codes FROM DUAL;
1082: SELECT REPLACE(p_line_desc, '::', ':') INTO l_all_reason_desc FROM DUAL;
1083: l_position_code := 0;
1084: l_position_desc := 0;
1085: END IF;

Line 1082: SELECT REPLACE(p_line_desc, '::', ':') INTO l_all_reason_desc FROM DUAL;

1078:
1079: l_update_collaboration_flag := FALSE; -- no need to update second or third time
1080: ELSE
1081: SELECT REPLACE(p_reason_code, '::', ':') INTO l_all_reason_codes FROM DUAL;
1082: SELECT REPLACE(p_line_desc, '::', ':') INTO l_all_reason_desc FROM DUAL;
1083: l_position_code := 0;
1084: l_position_desc := 0;
1085: END IF;
1086:

Line 1432: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;

1428: ecx_cln_debug_pub.Add('About to start workflow', 1);
1429: END IF;
1430:
1431:
1432: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
1433: IF (l_Debug_Level <= 1) THEN
1434: ecx_cln_debug_pub.Add('Process Item Key to send a mail to administrator:' || l_notification_flow_key, 1);
1435: END IF;
1436: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY');

Line 2060: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;

2056: END IF;
2057: END;
2058:
2059:
2060: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
2061:
2062:
2063: ------------ get the notification details -----------
2064: FND_MESSAGE.SET_NAME('CLN', 'CLN_NOTIF_DTLS');