APPS.JTM_MESSAGE_LOG_PKG dependencies on JTM_CONC_RUN_STATUS_LOG

Line 82: l_dml := 'INSERT INTO JTM_CONC_RUN_STATUS_LOG' ||

78: l_dml varchar2(2000);
79: l_log_id number;
80: BEGIN
81:
82: l_dml := 'INSERT INTO JTM_CONC_RUN_STATUS_LOG' ||
83: '(LOG_ID,PACKAGE_NAME,PROCEDURE_NAME,CONC_QUERY_ID,QUERY_STMT, ' ||
84: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,' ||
85: 'START_TIME,END_TIME,STATUS, MESSAGE)' ||
86: 'VALUES (JTM_CONC_RUN_STATUS_LOG_S.nextval, :1, :2, :3, :4,-1, sysdate, -1, sysdate, :5, :6, :7, :8) RETURNING LOG_ID INTO :9';

Line 86: 'VALUES (JTM_CONC_RUN_STATUS_LOG_S.nextval, :1, :2, :3, :4,-1, sysdate, -1, sysdate, :5, :6, :7, :8) RETURNING LOG_ID INTO :9';

82: l_dml := 'INSERT INTO JTM_CONC_RUN_STATUS_LOG' ||
83: '(LOG_ID,PACKAGE_NAME,PROCEDURE_NAME,CONC_QUERY_ID,QUERY_STMT, ' ||
84: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,' ||
85: 'START_TIME,END_TIME,STATUS, MESSAGE)' ||
86: 'VALUES (JTM_CONC_RUN_STATUS_LOG_S.nextval, :1, :2, :3, :4,-1, sysdate, -1, sysdate, :5, :6, :7, :8) RETURNING LOG_ID INTO :9';
87: EXECUTE IMMEDIATE l_dml using v_package_name, v_procedure_name, v_con_query_id, v_query_stmt, v_start_time,v_end_time, v_status, v_message RETURNING INTO l_log_id;
88: commit;
89:
90: x_log_id := l_log_id;

Line 92: x_msg_data := 'Insert record into JTM_CONC_RUN_STATUS_LOG successfully';

88: commit;
89:
90: x_log_id := l_log_id;
91: x_status := 'S';
92: x_msg_data := 'Insert record into JTM_CONC_RUN_STATUS_LOG successfully';
93:
94: EXCEPTION
95: WHEN OTHERS THEN
96: x_status := 'E';

Line 115: l_dml := 'UPDATE JTM_CONC_RUN_STATUS_LOG SET QUERY_STMT = :1, START_TIME = :2 ,END_TIME= :3' ||

111: )
112: IS
113: l_dml varchar2(2000);
114: BEGIN
115: l_dml := 'UPDATE JTM_CONC_RUN_STATUS_LOG SET QUERY_STMT = :1, START_TIME = :2 ,END_TIME= :3' ||
116: ',STATUS= :4 , MESSAGE= :5 WHERE LOG_ID = :5';
117: EXECUTE IMMEDIATE l_dml USING v_query_stmt, v_start_time, v_end_time, v_status, v_message, v_log_id;
118: commit;
119: x_status := 'S';

Line 134: l_dml := 'DELETE FROM JTM_CONC_RUN_STATUS_LOG WHERE LOG_ID = :1';

130: IS
131: l_dml varchar2(2000);
132: BEGIN
133: /* Testing show that the code below does not work. comment out
134: l_dml := 'DELETE FROM JTM_CONC_RUN_STATUS_LOG WHERE LOG_ID = :1';
135: EXECUTE IMMEDIATE l_dml USING v_log_id;
136: */
137: DELETE FROM JTM_CONC_RUN_STATUS_LOG WHERE LOG_ID = v_log_id;
138:

Line 137: DELETE FROM JTM_CONC_RUN_STATUS_LOG WHERE LOG_ID = v_log_id;

133: /* Testing show that the code below does not work. comment out
134: l_dml := 'DELETE FROM JTM_CONC_RUN_STATUS_LOG WHERE LOG_ID = :1';
135: EXECUTE IMMEDIATE l_dml USING v_log_id;
136: */
137: DELETE FROM JTM_CONC_RUN_STATUS_LOG WHERE LOG_ID = v_log_id;
138:
139: EXCEPTION
140: WHEN OTHERS THEN
141: RAISE;