APPS.JTM_MASTER_CONC_PROG_PUB dependencies on JTM_CON_REQUEST_DATA

Line 53: FROM JTM_CON_REQUEST_DATA

49: L_API_NAME CONSTANT varchar2(30) := 'DO_REFRESH_MOBILE_DATA';
50:
51: CURSOR X_TO_BE_RUN_REQUEST(p_Category_Type varchar2) IS
52: SELECT PACKAGE_NAME, PROCEDURE_NAME
53: FROM JTM_CON_REQUEST_DATA
54: WHERE Category = p_Category_Type
55: AND EXECUTE_FLAG = 'Y'
56: ORDER BY EXECUTION_ORDER, PRODUCT_CODE;
57:

Line 212: dynamic_stmt := 'UPDATE JTM_CON_REQUEST_DATA SET LAST_TXC_START = :1, '

208: l_status_message := SQLERRM;
209: END IF;
210: END;
211:
212: dynamic_stmt := 'UPDATE JTM_CON_REQUEST_DATA SET LAST_TXC_START = :1, '
213: || 'LAST_TXC_END = :2, COMPLETION_TEXT = :3, STATUS = :4 '
214: || 'WHERE PACKAGE_NAME = :5 AND PROCEDURE_NAME = :6';
215:
216: EXECUTE IMMEDIATE dynamic_stmt USING l_api_start, l_api_end,l_status_message,