eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PDI_API dependencies on GHR_POSITION_DESCRIPTIONS

Line 13: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,

9: p_position_description_id OUT NOCOPY number,
10: p_date_from IN date,
11: p_routing_grp_id IN number default null,
12: p_date_to IN date default null,
13: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,
14: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
15: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
16: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
17: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,

Line 14: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,

10: p_date_from IN date,
11: p_routing_grp_id IN number default null,
12: p_date_to IN date default null,
13: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,
14: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
15: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
16: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
17: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
18: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,

Line 15: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,

11: p_routing_grp_id IN number default null,
12: p_date_to IN date default null,
13: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,
14: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
15: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
16: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
17: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
18: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
19: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,

Line 16: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,

12: p_date_to IN date default null,
13: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,
14: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
15: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
16: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
17: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
18: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
19: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
20: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,

Line 17: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,

13: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,
14: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
15: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
16: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
17: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
18: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
19: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
20: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
21: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,

Line 18: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,

14: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
15: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
16: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
17: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
18: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
19: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
20: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
21: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
22: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,

Line 19: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,

15: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
16: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
17: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
18: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
19: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
20: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
21: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
22: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
23: p_category IN ghr_position_descriptions.category%TYPE default null,

Line 20: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,

16: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
17: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
18: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
19: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
20: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
21: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
22: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
23: p_category IN ghr_position_descriptions.category%TYPE default null,
24: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,

Line 21: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,

17: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
18: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
19: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
20: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
21: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
22: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
23: p_category IN ghr_position_descriptions.category%TYPE default null,
24: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,
25: p_supervisor_name in varchar2 default hr_api.g_varchar2,

Line 22: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,

18: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
19: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
20: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
21: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
22: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
23: p_category IN ghr_position_descriptions.category%TYPE default null,
24: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,
25: p_supervisor_name in varchar2 default hr_api.g_varchar2,
26: p_supervisor_title in varchar2 default hr_api.g_varchar2,

Line 23: p_category IN ghr_position_descriptions.category%TYPE default null,

19: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
20: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
21: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
22: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
23: p_category IN ghr_position_descriptions.category%TYPE default null,
24: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,
25: p_supervisor_name in varchar2 default hr_api.g_varchar2,
26: p_supervisor_title in varchar2 default hr_api.g_varchar2,
27: p_supervisor_date in date default hr_api.g_date,

Line 24: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,

20: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
21: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
22: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
23: p_category IN ghr_position_descriptions.category%TYPE default null,
24: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,
25: p_supervisor_name in varchar2 default hr_api.g_varchar2,
26: p_supervisor_title in varchar2 default hr_api.g_varchar2,
27: p_supervisor_date in date default hr_api.g_date,
28: p_manager_name in varchar2 default hr_api.g_varchar2,

Line 70: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;

66: p_2_pd_routing_history_id out nocopy number,
67: p_pdi_object_version_number out nocopy number)
68: IS
69: l_proc varchar2(72) := g_package||'create_pdi';
70: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
71: l_pdi_object_version_number number := 1;
72: /* Added by Dinkar. Karumuri to support workflow and routing of Position description*/
73: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
74: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;

Line 217: -- GHR_POSITION_DESCRIPTIONS and GHR_PD_CLASSIFICATIONS.

213: --
214: hr_utility.set_location(l_proc,6);
215: -- Validation in Addition to Row Handlers: There is no additional validation
216: -- Process Logic: The process logic is to call the row handlers to insert the information into
217: -- GHR_POSITION_DESCRIPTIONS and GHR_PD_CLASSIFICATIONS.
218: -- 1)First insert a row into GHR_POSITION_DESCRIPTIONS table.
219: ghr_pdi_ins.ins
220: (
221: p_position_description_id => l_position_description_id,

Line 218: -- 1)First insert a row into GHR_POSITION_DESCRIPTIONS table.

214: hr_utility.set_location(l_proc,6);
215: -- Validation in Addition to Row Handlers: There is no additional validation
216: -- Process Logic: The process logic is to call the row handlers to insert the information into
217: -- GHR_POSITION_DESCRIPTIONS and GHR_PD_CLASSIFICATIONS.
218: -- 1)First insert a row into GHR_POSITION_DESCRIPTIONS table.
219: ghr_pdi_ins.ins
220: (
221: p_position_description_id => l_position_description_id,
222: p_routing_group_id => p_routing_grp_id,

Line 549: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,

545: p_position_description_id IN number,
546: p_routing_grp_id IN number default hr_api.g_number,
547: p_date_from IN date,
548: p_date_to IN date default hr_api.g_date,
549: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,
550: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
551: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
552: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
553: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,

Line 550: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,

546: p_routing_grp_id IN number default hr_api.g_number,
547: p_date_from IN date,
548: p_date_to IN date default hr_api.g_date,
549: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,
550: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
551: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
552: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
553: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
554: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,

Line 551: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,

547: p_date_from IN date,
548: p_date_to IN date default hr_api.g_date,
549: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,
550: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
551: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
552: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
553: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
554: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
555: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,

Line 552: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,

548: p_date_to IN date default hr_api.g_date,
549: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,
550: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
551: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
552: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
553: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
554: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
555: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
556: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,

Line 553: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,

549: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,
550: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
551: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
552: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
553: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
554: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
555: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
556: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
557: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,

Line 554: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,

550: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
551: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
552: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
553: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
554: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
555: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
556: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
557: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
558: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,

Line 555: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,

551: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
552: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
553: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
554: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
555: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
556: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
557: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
558: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
559: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,

Line 556: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,

552: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
553: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
554: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
555: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
556: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
557: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
558: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
559: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,
560: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,

Line 557: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,

553: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
554: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
555: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
556: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
557: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
558: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
559: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,
560: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,
561: p_supervisor_name in varchar2 default hr_api.g_varchar2,

Line 558: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,

554: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
555: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
556: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
557: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
558: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
559: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,
560: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,
561: p_supervisor_name in varchar2 default hr_api.g_varchar2,
562: p_supervisor_title in varchar2 default hr_api.g_varchar2,

Line 559: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,

555: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
556: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
557: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
558: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
559: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,
560: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,
561: p_supervisor_name in varchar2 default hr_api.g_varchar2,
562: p_supervisor_title in varchar2 default hr_api.g_varchar2,
563: p_supervisor_date in date default hr_api.g_date,

Line 560: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,

556: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
557: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
558: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
559: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,
560: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,
561: p_supervisor_name in varchar2 default hr_api.g_varchar2,
562: p_supervisor_title in varchar2 default hr_api.g_varchar2,
563: p_supervisor_date in date default hr_api.g_date,
564: p_manager_name in varchar2 default hr_api.g_varchar2,

Line 612: l_routing_grp_id ghr_position_descriptions.routing_group_id%TYPE;

608: p_pdi_object_version_number in out nocopy number)
609: IS
610: l_pdi_object_version_number number;
611: l_proc varchar2(72) := g_package||'Update_pdi';
612: l_routing_grp_id ghr_position_descriptions.routing_group_id%TYPE;
613: l_u_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
614: l_i_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
615: l_u_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
616: l_initial_u_pdh_ovn ghr_pd_routing_history.object_version_number%TYPE;

Line 663: FROM ghr_position_descriptions pdi

659: ORDER BY pdh.pd_routing_history_id desc;
660:
661: CURSOR c_routing_grp_id is
662: SELECT pdi.routing_group_id
663: FROM ghr_position_descriptions pdi
664: WHERE pdi.position_description_id = p_position_description_id;
665:
666: /* CURSOR c_names is
667: SELECT usr.employee_id,

Line 817: -- To Update the ghr_position_descriptions table. we need the primary key.

813: hr_utility.set_location(l_proc,6);
814: --
815: -- Validation in addition to row handlers.
816: --
817: -- To Update the ghr_position_descriptions table. we need the primary key.
818: IF p_position_description_id is null then
819: hr_utility.set_message(8301, 'GHR_PD_ID_PRIMARY_KEY_INVALID');
820: hr_utility.raise_error;
821: end if;

Line 1314: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,

1310: END update_pdi;
1311:
1312: procedure call_workflow
1313: (
1314: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
1315: p_action_taken IN ghr_pd_routing_history.action_taken%TYPE
1316: )
1317: is
1318: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;

Line 1318: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;

1314: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
1315: p_action_taken IN ghr_pd_routing_history.action_taken%TYPE
1316: )
1317: is
1318: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
1319: l_pdi_object_version_number number := 1;
1320: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
1321: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
1322: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;

Line 1375: from ghr_position_descriptions pdi

1371: where pdh.position_description_id = p_position_description_id
1372: order by pdh.pd_routing_history_id desc;
1373: cursor c_routing_grp_id is
1374: select pdi.routing_group_id
1375: from ghr_position_descriptions pdi
1376: where pdi.position_description_id = p_position_description_id;
1377: cursor c_pd_initiated is
1378: select 'X'
1379: from ghr_pd_routing_history pdh