DBA Data[Home] [Help]

APPS.HR_PUMP_UTILS dependencies on HR_PUMP_DEFAULT_EXCEPTIONS

Line 155: FROM HR_PUMP_DEFAULT_EXCEPTIONS

151: WHERE UPPER(MODULE_NAME) = L_MODULE_NAME
152: AND UPPER(API_MODULE_TYPE) = L_API_MODULE_TYPE;
153: --
154: DELETE
155: FROM HR_PUMP_DEFAULT_EXCEPTIONS
156: WHERE UPPER(MODULE_NAME) = L_MODULE_NAME
157: AND UPPER(API_MODULE_TYPE) = L_API_MODULE_TYPE;
158: --
159: DELETE

Line 245: FROM HR_PUMP_DEFAULT_EXCEPTIONS

241: L_MODULE_NAME := UPPER(P_MODULE_NAME);
242: L_API_MODULE_TYPE := UPPER(P_API_MODULE_TYPE);
243: --
244: DELETE
245: FROM HR_PUMP_DEFAULT_EXCEPTIONS
246: WHERE UPPER(MODULE_NAME) = L_MODULE_NAME
247: AND UPPER(API_MODULE_TYPE) = L_API_MODULE_TYPE;
248: --
249: INSERT

Line 250: INTO HR_PUMP_DEFAULT_EXCEPTIONS

246: WHERE UPPER(MODULE_NAME) = L_MODULE_NAME
247: AND UPPER(API_MODULE_TYPE) = L_API_MODULE_TYPE;
248: --
249: INSERT
250: INTO HR_PUMP_DEFAULT_EXCEPTIONS
251: (MODULE_NAME
252: ,API_MODULE_TYPE
253: )
254: VALUES