DBA Data[Home] [Help]

APPS.HR_PUMP_UTILS dependencies on HR_PUMP_MAPPING_PACKAGES

Line 160: FROM HR_PUMP_MAPPING_PACKAGES

156: WHERE UPPER(MODULE_NAME) = L_MODULE_NAME
157: AND UPPER(API_MODULE_TYPE) = L_API_MODULE_TYPE;
158: --
159: DELETE
160: FROM HR_PUMP_MAPPING_PACKAGES
161: WHERE UPPER(MODULE_NAME) = L_MODULE_NAME
162: AND UPPER(API_MODULE_TYPE) = L_API_MODULE_TYPE;
163: --
164: END SEED_ZAP;

Line 327: FROM HR_PUMP_MAPPING_PACKAGES

323: L_API_MODULE_TYPE := UPPER(P_API_MODULE_TYPE);
324: L_MODULE_PACKAGE := UPPER(P_MODULE_PACKAGE);
325: --
326: DELETE
327: FROM HR_PUMP_MAPPING_PACKAGES
328: WHERE UPPER(MAPPING_PACKAGE) = L_MAPPING_PACKAGE
329: AND NVL(UPPER(MODULE_NAME), HR_API.G_VARCHAR2) =
330: NVL(L_MODULE_NAME, HR_API.G_VARCHAR2)
331: AND NVL(UPPER(API_MODULE_TYPE), HR_API.G_VARCHAR2) =

Line 337: INTO HR_PUMP_MAPPING_PACKAGES

333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =
334: NVL(L_MODULE_PACKAGE, HR_API.G_VARCHAR2);
335: --
336: INSERT
337: INTO HR_PUMP_MAPPING_PACKAGES
338: (MAPPING_PACKAGE
339: ,MODULE_NAME
340: ,API_MODULE_TYPE
341: ,MODULE_PACKAGE