APPS.JTM_COMMON_CON_PROG_PUB dependencies on JTM_CON_REQUEST_INTERVALS

Line 43: SELECT INTERVAL_ID FROM JTM_CON_REQUEST_INTERVALS

39: ) IS
40:
41: -- Reason to Use two cursor is for EXECUTION_ORDER.
42: CURSOR X_INTERVAL IS
43: SELECT INTERVAL_ID FROM JTM_CON_REQUEST_INTERVALS
44: WHERE INTERVAL <= CURRENT_ROUND;
45:
46: CURSOR X_TO_BE_RUN_REQUEST(x_interval_id NUMBER, x_interval NUMBER) IS
47: SELECT PACKAGE_NAME, PROCEDURE_NAME

Line 85: UPDATE JTM_CON_REQUEST_INTERVALS

81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: -- Initalize the Apps Context
84:
85: UPDATE JTM_CON_REQUEST_INTERVALS
86: SET CURRENT_ROUND = CURRENT_ROUND + 1 ;
87:
88: -- Careful, For Dynamic SQL, VARCHAR2 has to be initialized first.
89: -- remove parameters from dynamic sql.

Line 92: SELECT INTERVAL INTO l_interval FROM jtm_con_request_intervals

88: -- Careful, For Dynamic SQL, VARCHAR2 has to be initialized first.
89: -- remove parameters from dynamic sql.
90: FOR r_interval IN X_INTERVAL LOOP
91: l_interval_id := r_interval.INTERVAL_ID;
92: SELECT INTERVAL INTO l_interval FROM jtm_con_request_intervals
93: where INTERVAL_ID = r_interval.INTERVAL_ID;
94: FOR x_request IN X_TO_BE_RUN_REQUEST(r_interval.INTERVAL_ID, l_interval) LOOP
95:
96: l_api_start := sysdate;

Line 114: UPDATE JTM_CON_REQUEST_INTERVALS

110:
111: l_api_end := sysdate;
112: l_api_status := 'COMPLETED';
113:
114: UPDATE JTM_CON_REQUEST_INTERVALS
115: SET CURRENT_ROUND = 0
116: WHERE INTERVAL_ID = r_interval.INTERVAL_ID;
117:
118: EXCEPTION

Line 144: UPDATE JTM_CON_REQUEST_INTERVALS

140: COMMIT;
141: END LOOP;
142: END LOOP;
143:
144: UPDATE JTM_CON_REQUEST_INTERVALS
145: SET CURRENT_ROUND = 0
146: WHERE CURRENT_ROUND >= INTERVAL;
147: Commit;
148:

Line 154: UPDATE JTM_CON_REQUEST_INTERVALS

150: retcode := 0;
151: Exception
152: When others then
153:
154: UPDATE JTM_CON_REQUEST_INTERVALS
155: SET CURRENT_ROUND = 0
156: WHERE CURRENT_ROUND >= INTERVAL;
157:
158: JTM_MESSAGE_LOG_PKG.log_msg(