DBA Data[Home] [Help]

APPS.M4U_WLQ_GENERATE dependencies on M4U_WLQID_S

Line 12: -- The sequence m4u_wlqid_sequence is used to obtain unique event key.

8: -- raise_wlq_event
9: -- Purpose
10: -- This procedure is called from a concurrent program.
11: -- The the event 'oracle.apps.m4u.worklistquery' is raised with the supplied event parameters
12: -- The sequence m4u_wlqid_sequence is used to obtain unique event key.
13: -- Arguments
14: -- x_err_buf => API param for concurrent program calls
15: -- x_retcode => API param for concurrent program calls
16: -- p_wlq_type => The type of notifications from Worklist to be queried

Line 70: SELECT m4u_wlqid_s.NEXTVAL

66: cln_debug_pub.Add('=====================================',1);
67: END IF;
68:
69: -- obtain a unique event-id
70: SELECT m4u_wlqid_s.NEXTVAL
71: INTO l_event_key
72: FROM dual;
73:
74: l_event_key := 'M4U_WLQ_' || l_event_key;