DBA Data[Home] [Help]

APPS.AMS_WFCMPAPR_PVT dependencies on AMS_ACT_WF_REQUESTS

Line 90: -- This Procedure inserts workflow process data into AMS_ACT_WF_REQUESTS

86: -- NAME
87: -- Create_WFreqest
88: --
89: -- PURPOSE
90: -- This Procedure inserts workflow process data into AMS_ACT_WF_REQUESTS
91: -- table and returns SUCCESS if the insertion is successful
92: -- else it will return FAILURE
93: --
94: -- CALLED BY

Line 133: SELECT ams_act_wf_requests_s.NEXTVAL

129:
130: l_wf_request_id NUMBER;
131:
132: CURSOR C_wf_request_id_seq IS
133: SELECT ams_act_wf_requests_s.NEXTVAL
134: FROM DUAL;
135:
136: BEGIN
137:

Line 181: INSERT INTO ams_act_wf_requests

177: -- close cursor
178: CLOSE C_wf_request_id_seq;
179:
180:
181: INSERT INTO ams_act_wf_requests
182: (activity_wf_request_id
183:
184: -- standard who columns
185: ,last_update_date