APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 82: --cursor to get last run date from jtm_con_request_data

78: FROM HZ_CUST_ACCOUNTS hzc , CSM_HZ_CUST_ACCOUNTS_ACC acc
79: WHERE hzc.cust_account_id = acc.cust_account_id
80: AND hzc.LAST_UPDATE_DATE > c_last_run_date;
81:
82: --cursor to get last run date from jtm_con_request_data
83: CURSOR csr_last_run_date
84: IS
85: SELECT nvl(last_run_date, (sysdate - 365*50) )
86: FROM jtm_con_request_data

Line 86: FROM jtm_con_request_data

82: --cursor to get last run date from jtm_con_request_data
83: CURSOR csr_last_run_date
84: IS
85: SELECT nvl(last_run_date, (sysdate - 365*50) )
86: FROM jtm_con_request_data
87: WHERE package_name = 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG'
88: AND procedure_name = 'CUST_ACCOUNTS_UPD';
89:
90: --variable declarations

Line 97: l_last_run_date JTM_CON_REQUEST_DATA.LAST_RUN_DATE%TYPE;

93: l_sqlerrmsg varchar2(2000);
94: l_markdirty BOOLEAN;
95: l_accessid_lst asg_download.access_list;
96: l_userid_lst asg_download.user_list;
97: l_last_run_date JTM_CON_REQUEST_DATA.LAST_RUN_DATE%TYPE;
98:
99: BEGIN
100: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD',FND_LOG.LEVEL_EXCEPTION);
101:

Line 125: UPDATE jtm_con_request_data

121:
122: COMMIT;
123: END LOOP;
124:
125: UPDATE jtm_con_request_data
126: SET last_run_date = sysdate
127: WHERE package_name = 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG'
128: AND procedure_name = 'CUST_ACCOUNTS_UPD';
129: