APPS.IEC_AGTLESS_CPN_PVT dependencies on IEC_G_AGTLESS_CPN_RT_INFO

Line 18: INSERT INTO IEC_G_AGTLESS_CPN_RT_INFO

14: AS
15: BEGIN
16: -- TRY TO INSERT RT INFO AND LOCK CAMPAIGN
17: BEGIN
18: INSERT INTO IEC_G_AGTLESS_CPN_RT_INFO
19: (
20: AGTLESS_CPN_RT_INFO_ID,
21: OBJECT_VERSION_NUMBER,
22: CREATED_BY,

Line 33: IEC_G_AGTLESS_CPN_RT_INFO_S.NEXTVAL,

29: STATUS
30: )
31: VALUES
32: (
33: IEC_G_AGTLESS_CPN_RT_INFO_S.NEXTVAL,
34: 1,
35: 1,
36: SYSDATE,
37: 1,

Line 88: FROM IEC_G_AGTLESS_CPN_RT_INFO

84:
85: BEGIN
86: SELECT SERVER_ID, LAST_UPDATE_DATE, EXECUTION
87: INTO l_curr_server_id, l_last_update_date, l_execution
88: FROM IEC_G_AGTLESS_CPN_RT_INFO
89: WHERE CAMPAIGN_ID = P_CAMPAIGN_ID
90: FOR UPDATE;
91:
92: EXCEPTION

Line 128: UPDATE IEC_G_AGTLESS_CPN_RT_INFO

124: -- is executing, see if we locked it
125:
126: IF l_curr_server_id = P_SERVER_ID OR l_curr_server_id = NULL OR SYSDATE - l_last_update_date > 1/720 THEN
127:
128: UPDATE IEC_G_AGTLESS_CPN_RT_INFO
129: SET SERVER_ID = P_SERVER_ID, LAST_UPDATE_DATE = SYSDATE, STATUS = L_STATUS_STARTED, EXECUTION = l_execution, LAST_UPDATED_BY = 1
130: WHERE CAMPAIGN_ID = P_CAMPAIGN_ID;
131:
132: X_RESULT := FND_API.G_RET_STS_SUCCESS;

Line 161: UPDATE IEC_G_AGTLESS_CPN_RT_INFO

157: BEGIN
158:
159: BEGIN
160:
161: UPDATE IEC_G_AGTLESS_CPN_RT_INFO
162: SET SERVER_ID = '', LAST_UPDATE_DATE = SYSDATE, STATUS = L_STATUS_STOPPED, LAST_UPDATED_BY = 1
163: WHERE CAMPAIGN_ID = P_CAMPAIGN_ID AND SERVER_ID = P_SERVER_ID;
164: EXCEPTION
165: