DBA Data[Home] [Help]

APPS.HR_NAVIGATION_UNITS_PKG dependencies on HR_API

Line 32: X_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang

28: X_Default_Label VARCHAR2,
29: X_Form_Name VARCHAR2,
30: X_Max_Number_Of_Nav_Buttons NUMBER,
31: X_Block_Name VARCHAR2,
32: X_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
33: ) IS
34: CURSOR C IS SELECT rowid FROM HR_NAVIGATION_UNITS
35:
36: WHERE nav_unit_id = X_Nav_Unit_Id;

Line 47: hr_api.validate_language_code(p_language_code => l_language_code);

43: -- instead of p_language_code from now on, to allow an IN OUT parameter to
44: -- be passed through.
45: --
46: l_language_code := x_language_code;
47: hr_api.validate_language_code(p_language_code => l_language_code);
48:
49: if (X_Nav_Unit_Id is NULL) then
50: OPEN C2;
51: FETCH C2 INTO X_Nav_Unit_Id;

Line 224: X_Language_Code varchar2 default hr_api.userenv_lang

220: X_Default_Label VARCHAR2,
221: X_Form_Name VARCHAR2,
222: X_Max_Number_Of_Nav_Buttons NUMBER,
223: X_Block_Name VARCHAR2,
224: X_Language_Code varchar2 default hr_api.userenv_lang
225: )
226: IS
227: l_language_code varchar2(3);
228: BEGIN

Line 235: hr_api.validate_language_code(p_language_code => l_language_code);

231: -- instead of x_language_code from now on, to allow an IN OUT parameter to
232: -- be passed through.
233: --
234: l_language_code := x_language_code;
235: hr_api.validate_language_code(p_language_code => l_language_code);
236:
237: UPDATE HR_NAVIGATION_UNITS
238: SET
239: nav_unit_id = X_Nav_Unit_Id,

Line 281: X_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang

277: X_DEFAULT_LABEL VARCHAR2,
278: X_FORM_NAME VARCHAR2,
279: X_MAX_NUMBER_OF_NAV_BUTTONS NUMBER,
280: X_BLOCK_NAME VARCHAR2,
281: X_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
282: ) is
283: l_language_code varchar2(3);
284: begin
285:

Line 291: hr_api.validate_language_code(p_language_code => l_language_code);

287: -- instead of x_language_code from now on, to allow an IN OUT parameter to
288: -- be passed through.
289: --
290: l_language_code := x_language_code;
291: hr_api.validate_language_code(p_language_code => l_language_code);
292:
293:
294: update HR_NAVIGATION_UNITS set
295: DEFAULT_WORKFLOW_ID = X_DEFAULT_WORKFLOW_ID,

Line 456: and nvl(block_name,hr_api.g_varchar2) = nvl(x_block_name,hr_api.g_varchar2);

452: into X_NAV_UNIT_ID, Y_DEFAULT_WORKFLOW_ID, Y_APPLICATION_ABBREV,
453: Y_DEFAULT_LABEL,Y_MAX_NUMBER_OF_NAV_BUTTONS
454: from hr_navigation_units
455: where FORM_NAME = X_FORM_NAME
456: and nvl(block_name,hr_api.g_varchar2) = nvl(x_block_name,hr_api.g_varchar2);
457:
458: --
459: -- Fix for bug 3274423 starts here.
460: -- Before updating the record, compare the database row with the row in ldt file.