1: Package Body HR_KI_HRC_LOAD_API as
2: /* $Header: hrkihrcl.pkb 120.1 2006/06/27 16:03:09 avarri noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: hrkihrcl.pkb 120.1 2006/06/27 16:03:09 avarri noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(31) := 'HR_KI_HRC_LOAD_API';
7: --
8:
9:
10: procedure UPDATE_ROW (
175: X_PARENT_HIERARCHY_ID in out nocopy number
176: )
177: is
178:
179: l_proc VARCHAR2(61) := 'HR_KI_HRC_LOAD_API.VALIDATE_PARENT_KEY';
180: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;
181:
182: CURSOR C_VAL IS
183: select hierarchy_id
218: X_OWNER in VARCHAR2
219:
220: )
221: is
222: l_proc VARCHAR2(31) := 'HR_KI_HRC_LOAD_API.LOAD_ROW';
223: l_rowid rowid;
224: l_created_by HR_KI_HIERARCHIES.created_by%TYPE := 0;
225: l_creation_date HR_KI_HIERARCHIES.creation_date%TYPE := SYSDATE;
226: l_last_update_date HR_KI_HIERARCHIES.last_update_date%TYPE := SYSDATE;
379: end;
380:
381: end TRANSLATE_ROW;
382:
383: END HR_KI_HRC_LOAD_API;