APPS.CSM_PROFILE_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 84: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

80: p_message OUT NOCOPY VARCHAR2)
81: IS
82: PRAGMA AUTONOMOUS_TRANSACTION;
83: l_pub_item varchar2(30) := 'CSF_M_PROFILES';
84: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
85: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
86: l_user_id fnd_user.user_id%TYPE;
87: l_resp_id fnd_responsibility.responsibility_id%TYPE;
88: l_app_id fnd_application.application_id%TYPE;

Line 102: FROM jtm_con_request_data

98:
99: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
100: IS
101: SELECT nvl(last_run_date, (sysdate - 365*50))
102: FROM jtm_con_request_data
103: WHERE package_name = 'CSM_PROFILE_EVENT_PKG'
104: AND procedure_name = 'REFRESH_ACC';
105:
106: --Bug 5257429

Line 812: -- set the program update date in jtm_con_request_data to sysdate

808: END LOOP; --palm omfs user loop
809:
810: END LOOP; -- process inserts
811:
812: -- set the program update date in jtm_con_request_data to sysdate
813: UPDATE jtm_con_request_data
814: SET last_run_date = l_run_date,
815: last_update_date = SYSDATE
816: WHERE package_name = 'CSM_PROFILE_EVENT_PKG'

Line 813: UPDATE jtm_con_request_data

809:
810: END LOOP; -- process inserts
811:
812: -- set the program update date in jtm_con_request_data to sysdate
813: UPDATE jtm_con_request_data
814: SET last_run_date = l_run_date,
815: last_update_date = SYSDATE
816: WHERE package_name = 'CSM_PROFILE_EVENT_PKG'
817: AND procedure_name = 'REFRESH_ACC';