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 193: X_Language_Code varchar2 default hr_api.userenv_lang

189: X_Default_Label VARCHAR2,
190: X_Form_Name VARCHAR2,
191: X_Max_Number_Of_Nav_Buttons NUMBER,
192: X_Block_Name VARCHAR2,
193: X_Language_Code varchar2 default hr_api.userenv_lang
194: )
195: IS
196: l_language_code varchar2(3);
197: BEGIN

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

200: -- instead of x_language_code from now on, to allow an IN OUT parameter to
201: -- be passed through.
202: --
203: l_language_code := x_language_code;
204: hr_api.validate_language_code(p_language_code => l_language_code);
205:
206: UPDATE HR_NAVIGATION_UNITS
207: SET
208: nav_unit_id = X_Nav_Unit_Id,

Line 250: X_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang

246: X_DEFAULT_LABEL VARCHAR2,
247: X_FORM_NAME VARCHAR2,
248: X_MAX_NUMBER_OF_NAV_BUTTONS NUMBER,
249: X_BLOCK_NAME VARCHAR2,
250: X_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
251: ) is
252: l_language_code varchar2(3);
253: begin
254:

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

256: -- instead of x_language_code from now on, to allow an IN OUT parameter to
257: -- be passed through.
258: --
259: l_language_code := x_language_code;
260: hr_api.validate_language_code(p_language_code => l_language_code);
261:
262:
263: update HR_NAVIGATION_UNITS set
264: DEFAULT_WORKFLOW_ID = X_DEFAULT_WORKFLOW_ID,

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

397: into X_NAV_UNIT_ID, Y_DEFAULT_WORKFLOW_ID, Y_APPLICATION_ABBREV,
398: Y_DEFAULT_LABEL,Y_MAX_NUMBER_OF_NAV_BUTTONS
399: from hr_navigation_units
400: where FORM_NAME = X_FORM_NAME
401: and nvl(block_name,hr_api.g_varchar2) = nvl(x_block_name,hr_api.g_varchar2);
402:
403: --
404: -- Fix for bug 3274423 starts here.
405: -- Before updating the record, compare the database row with the row in ldt file.