APPS.JTM_CON_QUERY_REQUEST_PKG dependencies on JTM_CON_REQUEST_DATA

Line 454: FROM jtm_con_request_data

450: l_category varchar2(80);
451: BEGIN
452: SELECT category
453: INTO l_category
454: FROM jtm_con_request_data
455: WHERE upper(package_name) = 'JTM_CON_QUERY_REQUEST_PKG'
456: AND upper(procedure_name) = 'RUN_QUERY_REQUESTS';
457:
458: return l_category;

Line 1474: UPDATE JTM_CON_REQUEST_DATA SET LAST_RUN_DATE = SYSDATE

1470:
1471: IF (P_Message = 'OK') then
1472: P_Message:= 'The concurrent query program is working fine';
1473: END IF;
1474: UPDATE JTM_CON_REQUEST_DATA SET LAST_RUN_DATE = SYSDATE
1475: WHERE PRODUCT_CODE = 'JTM'
1476: AND PACKAGE_NAME = G_PACKAGE_NAME
1477: AND UPPER(PROCEDURE_NAME) = L_API_NAME;
1478: COMMIT;