DBA Data[Home] [Help]

APPS.HR_UPDATE_UTILITY dependencies on PAY_UPGRADE_DEFINITIONS

Line 36: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;

32: l_request_id number := null;
33:
34: l_sql_stmt varchar2(250);
35:
36: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
37: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
38: l_upg_mthd pay_upgrade_definitions.upgrade_method%type;
39:
40: /*

Line 37: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;

33:
34: l_sql_stmt varchar2(250);
35:
36: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
37: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
38: l_upg_mthd pay_upgrade_definitions.upgrade_method%type;
39:
40: /*
41: ** Local variables for use by get_request_status

Line 38: l_upg_mthd pay_upgrade_definitions.upgrade_method%type;

34: l_sql_stmt varchar2(250);
35:
36: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
37: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
38: l_upg_mthd pay_upgrade_definitions.upgrade_method%type;
39:
40: /*
41: ** Local variables for use by get_request_status
42: */

Line 64: from pay_upgrade_definitions

60: cursor csr_get_update_details is
61: select upgrade_definition_id,
62: upgrade_level,
63: upgrade_method
64: from pay_upgrade_definitions
65: where short_name = p_update_name;
66:
67: /*
68: ** This cursor is used to get the status of a GUP

Line 320: from pay_upgrade_definitions

316:
317: cursor csr_get_update_details is
318: select upgrade_definition_id,
319: upgrade_level
320: from pay_upgrade_definitions
321: where short_name = p_update_name;
322:
323: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
324: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;

Line 323: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;

319: upgrade_level
320: from pay_upgrade_definitions
321: where short_name = p_update_name;
322:
323: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
324: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
325:
326: begin
327:

Line 324: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;

320: from pay_upgrade_definitions
321: where short_name = p_update_name;
322:
323: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
324: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
325:
326: begin
327:
328:

Line 357: from pay_upgrade_definitions

353:
354: cursor csr_get_update_details is
355: select upgrade_definition_id,
356: upgrade_level
357: from pay_upgrade_definitions
358: where short_name = p_update_name;
359:
360: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
361: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;

Line 360: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;

356: upgrade_level
357: from pay_upgrade_definitions
358: where short_name = p_update_name;
359:
360: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
361: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
362:
363: begin
364:

Line 361: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;

357: from pay_upgrade_definitions
358: where short_name = p_update_name;
359:
360: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
361: l_upg_lvl pay_upgrade_definitions.upgrade_level%type;
362:
363: begin
364:
365: