182: (P_MODULE_NAME IN VARCHAR2
183: ,P_API_MODULE_TYPE IN VARCHAR2
184: ) IS
185: SELECT API_MODULE_ID
186: FROM HR_API_MODULES
187: WHERE UPPER(MODULE_NAME) = P_MODULE_NAME
188: AND UPPER(API_MODULE_TYPE) = P_API_MODULE_TYPE;
189: BEGIN
190: L_MODULE_NAME := UPPER(P_MODULE_NAME);
202: FETCH CSR_API_MODULE_ID
203: INTO L_API_MODULE_ID;
204: --
205: -- Call the appropriate API depending on whether or not a row in
206: -- HR_API_MODULES exists.
207: --
208: IF CSR_API_MODULE_ID%NOTFOUND THEN
209: CLOSE CSR_API_MODULE_ID;
210: HR_API_MODULE_INTERNAL.CREATE_API_MODULE
206: -- HR_API_MODULES exists.
207: --
208: IF CSR_API_MODULE_ID%NOTFOUND THEN
209: CLOSE CSR_API_MODULE_ID;
210: HR_API_MODULE_INTERNAL.CREATE_API_MODULE
211: (P_VALIDATE => FALSE
212: ,P_EFFECTIVE_DATE => HR_API.G_SYS
213: ,P_API_MODULE_TYPE => L_API_MODULE_TYPE
214: ,P_MODULE_NAME => L_MODULE_NAME
208: IF CSR_API_MODULE_ID%NOTFOUND THEN
209: CLOSE CSR_API_MODULE_ID;
210: HR_API_MODULE_INTERNAL.CREATE_API_MODULE
211: (P_VALIDATE => FALSE
212: ,P_EFFECTIVE_DATE => HR_API.G_SYS
213: ,P_API_MODULE_TYPE => L_API_MODULE_TYPE
214: ,P_MODULE_NAME => L_MODULE_NAME
215: ,P_DATA_WITHIN_BUSINESS_GROUP => L_DATA_WITHIN_BUSINESS_GROUP
216: ,P_LEGISLATION_CODE => L_LEGISLATION_CODE
218: ,P_API_MODULE_ID => L_API_MODULE_ID
219: );
220: ELSE
221: CLOSE CSR_API_MODULE_ID;
222: HR_API_MODULE_INTERNAL.UPDATE_API_MODULE
223: (P_VALIDATE => FALSE
224: ,P_API_MODULE_ID => L_API_MODULE_ID
225: ,P_MODULE_NAME => L_MODULE_NAME
226: ,P_MODULE_PACKAGE => L_MODULE_PACKAGE
224: ,P_API_MODULE_ID => L_API_MODULE_ID
225: ,P_MODULE_NAME => L_MODULE_NAME
226: ,P_MODULE_PACKAGE => L_MODULE_PACKAGE
227: ,P_DATA_WITHIN_BUSINESS_GROUP => L_DATA_WITHIN_BUSINESS_GROUP
228: ,P_EFFECTIVE_DATE => HR_API.G_SYS
229: );
230: END IF;
231: END SEED_API;
232:
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) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =
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) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =
334: NVL(L_MODULE_PACKAGE, HR_API.G_VARCHAR2);
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) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =
334: NVL(L_MODULE_PACKAGE, HR_API.G_VARCHAR2);
335: --
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) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =
334: NVL(L_MODULE_PACKAGE, HR_API.G_VARCHAR2);
335: --
336: INSERT
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) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
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
330: NVL(L_MODULE_NAME, HR_API.G_VARCHAR2)
331: AND NVL(UPPER(API_MODULE_TYPE), HR_API.G_VARCHAR2) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
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
487: is
488:
489: cursor csr_get_api_module_id (p_module_name hr_pump_spread_loaders.module_name%type) is
490: select api_module_id
491: from hr_api_modules
492: where module_name = p_module_name
493: and api_module_type in ('AI','BP');
494:
495: cursor csr_chk_row_exists is