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 HR_API

Line 25: p_supervisor_name in varchar2 default hr_api.g_varchar2,

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,
29: p_manager_title in varchar2 default hr_api.g_varchar2,

Line 26: p_supervisor_title in varchar2 default hr_api.g_varchar2,

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,
29: p_manager_title in varchar2 default hr_api.g_varchar2,
30: p_manager_date in date default hr_api.g_date,

Line 27: p_supervisor_date in date default hr_api.g_date,

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,
29: p_manager_title in varchar2 default hr_api.g_varchar2,
30: p_manager_date in date default hr_api.g_date,
31: p_classifier_name in varchar2 default hr_api.g_varchar2,

Line 28: p_manager_name in varchar2 default hr_api.g_varchar2,

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,
29: p_manager_title in varchar2 default hr_api.g_varchar2,
30: p_manager_date in date default hr_api.g_date,
31: p_classifier_name in varchar2 default hr_api.g_varchar2,
32: p_classifier_title in varchar2 default hr_api.g_varchar2,

Line 29: p_manager_title in varchar2 default hr_api.g_varchar2,

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,
29: p_manager_title in varchar2 default hr_api.g_varchar2,
30: p_manager_date in date default hr_api.g_date,
31: p_classifier_name in varchar2 default hr_api.g_varchar2,
32: p_classifier_title in varchar2 default hr_api.g_varchar2,
33: p_classifier_date in date default hr_api.g_date,

Line 30: p_manager_date in date default hr_api.g_date,

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,
29: p_manager_title in varchar2 default hr_api.g_varchar2,
30: p_manager_date in date default hr_api.g_date,
31: p_classifier_name in varchar2 default hr_api.g_varchar2,
32: p_classifier_title in varchar2 default hr_api.g_varchar2,
33: p_classifier_date in date default hr_api.g_date,
34: p_attribute_category in varchar2 default null,

Line 31: p_classifier_name 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,
29: p_manager_title in varchar2 default hr_api.g_varchar2,
30: p_manager_date in date default hr_api.g_date,
31: p_classifier_name in varchar2 default hr_api.g_varchar2,
32: p_classifier_title in varchar2 default hr_api.g_varchar2,
33: p_classifier_date in date default hr_api.g_date,
34: p_attribute_category in varchar2 default null,
35: p_attribute1 in varchar2 default null,

Line 32: p_classifier_title in varchar2 default hr_api.g_varchar2,

28: p_manager_name in varchar2 default hr_api.g_varchar2,
29: p_manager_title in varchar2 default hr_api.g_varchar2,
30: p_manager_date in date default hr_api.g_date,
31: p_classifier_name in varchar2 default hr_api.g_varchar2,
32: p_classifier_title in varchar2 default hr_api.g_varchar2,
33: p_classifier_date in date default hr_api.g_date,
34: p_attribute_category in varchar2 default null,
35: p_attribute1 in varchar2 default null,
36: p_attribute2 in varchar2 default null,

Line 33: p_classifier_date in date default hr_api.g_date,

29: p_manager_title in varchar2 default hr_api.g_varchar2,
30: p_manager_date in date default hr_api.g_date,
31: p_classifier_name in varchar2 default hr_api.g_varchar2,
32: p_classifier_title in varchar2 default hr_api.g_varchar2,
33: p_classifier_date in date default hr_api.g_date,
34: p_attribute_category in varchar2 default null,
35: p_attribute1 in varchar2 default null,
36: p_attribute2 in varchar2 default null,
37: p_attribute3 in varchar2 default null,

Line 204: when hr_api.cannot_find_prog_unit then

200: p_2_routing_list_id => p_2_routing_list_id,
201: p_2_routing_seq_number => p_2_routing_seq_number
202: );
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'create_pdi',
207: p_hook_type => 'BP'
208: );

Line 205: hr_api.cannot_find_prog_unit_error

201: p_2_routing_seq_number => p_2_routing_seq_number
202: );
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'create_pdi',
207: p_hook_type => 'BP'
208: );
209: end;

Line 329: if nvl(l_action_taken,hr_api.g_varchar2) in

325: hr_utility.raise_error;
326: end if;
327: end if;
328: hr_utility.set_location('before getting item key'||l_action_taken,10);
329: if nvl(l_action_taken,hr_api.g_varchar2) in
330: ('NOT_ROUTED','INITIATED','CLASSIFIED','AUTHORIZED','REQUESTED')
331: then
332:
333: OPEN c_item_key_seq;

Line 345: if nvl(l_action_taken,hr_api.g_varchar2) not in

341: end if;
342:
343: --insert_messages(5,l_position_description_id,'after item_key_seq');
344: -- write the first record into the routing history (actions done by the user)
345: if nvl(l_action_taken,hr_api.g_varchar2) not in
346: ('CANCELED') then
347: hr_utility.set_location('after not in cancled',10);
348: ghr_pdh_ins.ins
349: (

Line 372: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CLASSIFIED','NOT_ROUTED') then

368: p_validate => false
369: );
370: -- Insert 2nd record into routing_history for routing details
371: -- (exception when routing_status = 'NOT_ROUTED' )
372: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CLASSIFIED','NOT_ROUTED') then
373: hr_utility.set_location('in the 2nd row',10);
374: l_2_routing_seq_number := p_2_routing_seq_number;
375: l_2_groupbox_id := p_2_groupbox_id;
376: l_2_user_name := p_2_user_name_routed_to;

Line 489: when hr_api.cannot_find_prog_unit then

485: p_2_pd_routing_history_id => p_2_pd_routing_history_id,
486: p_pdi_object_version_number => l_pdi_object_version_number
487: );
488: exception
489: when hr_api.cannot_find_prog_unit then
490: hr_api.cannot_find_prog_unit_error
491: (p_module_name => 'create_pdi',
492: p_hook_type => 'AP'
493: );

Line 490: hr_api.cannot_find_prog_unit_error

486: p_pdi_object_version_number => l_pdi_object_version_number
487: );
488: exception
489: when hr_api.cannot_find_prog_unit then
490: hr_api.cannot_find_prog_unit_error
491: (p_module_name => 'create_pdi',
492: p_hook_type => 'AP'
493: );
494: end;

Line 499: RAISE hr_api.validate_enabled;

495: --
496: -- End of After Process User Hook call
497: --
498: IF p_validate THEN
499: RAISE hr_api.validate_enabled;
500: END IF;
501: --
502: -- Set All output Arguments
503: --

Line 509: WHEN hr_api.validate_enabled THEN

505: p_pdi_object_version_number := l_pdi_object_version_number;
506: hr_utility.set_location ('Leaving:'|| l_proc,11);
507: EXCEPTION
508:
509: WHEN hr_api.validate_enabled THEN
510: -- As the validation exception has been raised
511: -- We must rollback to the Savepoint set.
512: ROLLBACK TO create_pdi;
513: --

Line 546: p_routing_grp_id IN number default hr_api.g_number,

542: PROCEDURE update_pdi
543: (
544: p_validate IN BOOLEAN default false,
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,

Line 548: p_date_to IN date default hr_api.g_date,

544: p_validate IN BOOLEAN default false,
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,

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 561: p_supervisor_name in varchar2 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,
565: p_manager_title in varchar2 default hr_api.g_varchar2,

Line 562: p_supervisor_title in varchar2 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,
565: p_manager_title in varchar2 default hr_api.g_varchar2,
566: p_manager_date in date default hr_api.g_date,

Line 563: p_supervisor_date in date default hr_api.g_date,

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,
565: p_manager_title in varchar2 default hr_api.g_varchar2,
566: p_manager_date in date default hr_api.g_date,
567: p_classifier_name in varchar2 default hr_api.g_varchar2,

Line 564: p_manager_name in varchar2 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,
565: p_manager_title in varchar2 default hr_api.g_varchar2,
566: p_manager_date in date default hr_api.g_date,
567: p_classifier_name in varchar2 default hr_api.g_varchar2,
568: p_classifier_title in varchar2 default hr_api.g_varchar2,

Line 565: p_manager_title in varchar2 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,
565: p_manager_title in varchar2 default hr_api.g_varchar2,
566: p_manager_date in date default hr_api.g_date,
567: p_classifier_name in varchar2 default hr_api.g_varchar2,
568: p_classifier_title in varchar2 default hr_api.g_varchar2,
569: p_classifier_date in date default hr_api.g_date,

Line 566: p_manager_date in date default hr_api.g_date,

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,
565: p_manager_title in varchar2 default hr_api.g_varchar2,
566: p_manager_date in date default hr_api.g_date,
567: p_classifier_name in varchar2 default hr_api.g_varchar2,
568: p_classifier_title in varchar2 default hr_api.g_varchar2,
569: p_classifier_date in date default hr_api.g_date,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 567: p_classifier_name 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,
565: p_manager_title in varchar2 default hr_api.g_varchar2,
566: p_manager_date in date default hr_api.g_date,
567: p_classifier_name in varchar2 default hr_api.g_varchar2,
568: p_classifier_title in varchar2 default hr_api.g_varchar2,
569: p_classifier_date in date default hr_api.g_date,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 568: p_classifier_title in varchar2 default hr_api.g_varchar2,

564: p_manager_name in varchar2 default hr_api.g_varchar2,
565: p_manager_title in varchar2 default hr_api.g_varchar2,
566: p_manager_date in date default hr_api.g_date,
567: p_classifier_name in varchar2 default hr_api.g_varchar2,
568: p_classifier_title in varchar2 default hr_api.g_varchar2,
569: p_classifier_date in date default hr_api.g_date,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 569: p_classifier_date in date default hr_api.g_date,

565: p_manager_title in varchar2 default hr_api.g_varchar2,
566: p_manager_date in date default hr_api.g_date,
567: p_classifier_name in varchar2 default hr_api.g_varchar2,
568: p_classifier_title in varchar2 default hr_api.g_varchar2,
569: p_classifier_date in date default hr_api.g_date,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 570: p_attribute_category in varchar2 default hr_api.g_varchar2,

566: p_manager_date in date default hr_api.g_date,
567: p_classifier_name in varchar2 default hr_api.g_varchar2,
568: p_classifier_title in varchar2 default hr_api.g_varchar2,
569: p_classifier_date in date default hr_api.g_date,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 571: p_attribute1 in varchar2 default hr_api.g_varchar2,

567: p_classifier_name in varchar2 default hr_api.g_varchar2,
568: p_classifier_title in varchar2 default hr_api.g_varchar2,
569: p_classifier_date in date default hr_api.g_date,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 572: p_attribute2 in varchar2 default hr_api.g_varchar2,

568: p_classifier_title in varchar2 default hr_api.g_varchar2,
569: p_classifier_date in date default hr_api.g_date,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 573: p_attribute3 in varchar2 default hr_api.g_varchar2,

569: p_classifier_date in date default hr_api.g_date,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 574: p_attribute4 in varchar2 default hr_api.g_varchar2,

570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 575: p_attribute5 in varchar2 default hr_api.g_varchar2,

571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 576: p_attribute6 in varchar2 default hr_api.g_varchar2,

572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 577: p_attribute7 in varchar2 default hr_api.g_varchar2,

573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 578: p_attribute8 in varchar2 default hr_api.g_varchar2,

574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 579: p_attribute9 in varchar2 default hr_api.g_varchar2,

575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 580: p_attribute10 in varchar2 default hr_api.g_varchar2,

576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 581: p_attribute11 in varchar2 default hr_api.g_varchar2,

577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 582: p_attribute12 in varchar2 default hr_api.g_varchar2,

578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 583: p_attribute13 in varchar2 default hr_api.g_varchar2,

579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 584: p_attribute14 in varchar2 default hr_api.g_varchar2,

580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 585: p_attribute15 in varchar2 default hr_api.g_varchar2,

581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 586: p_attribute16 in varchar2 default hr_api.g_varchar2,

582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 587: p_attribute17 in varchar2 default hr_api.g_varchar2,

583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,
591: p_business_group_id in number default hr_api.g_number,

Line 588: p_attribute18 in varchar2 default hr_api.g_varchar2,

584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,
591: p_business_group_id in number default hr_api.g_number,
592: p_u_approved_flag in varchar2 default hr_api.g_varchar2,

Line 589: p_attribute19 in varchar2 default hr_api.g_varchar2,

585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,
591: p_business_group_id in number default hr_api.g_number,
592: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
593: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,

Line 590: p_attribute20 in varchar2 default hr_api.g_varchar2,

586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,
591: p_business_group_id in number default hr_api.g_number,
592: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
593: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
594: p_u_action_taken in varchar2 default null,

Line 591: p_business_group_id in number default hr_api.g_number,

587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,
591: p_business_group_id in number default hr_api.g_number,
592: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
593: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
594: p_u_action_taken in varchar2 default null,
595: p_i_user_name_routed_to in varchar2 default null,

Line 592: p_u_approved_flag in varchar2 default hr_api.g_varchar2,

588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,
591: p_business_group_id in number default hr_api.g_number,
592: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
593: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
594: p_u_action_taken in varchar2 default null,
595: p_i_user_name_routed_to in varchar2 default null,
596: p_i_groupbox_id in number default null,

Line 593: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,

589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,
591: p_business_group_id in number default hr_api.g_number,
592: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
593: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
594: p_u_action_taken in varchar2 default null,
595: p_i_user_name_routed_to in varchar2 default null,
596: p_i_groupbox_id in number default null,
597: p_i_routing_list_id in number default null,

Line 804: when hr_api.cannot_find_prog_unit then

800: p_i_pdh_object_version_number => p_i_pdh_object_version_number,
801: p_pdi_object_version_number => p_pdi_object_version_number
802: );
803: exception
804: when hr_api.cannot_find_prog_unit then
805: hr_api.cannot_find_prog_unit_error
806: (p_module_name => 'update_pdi',
807: p_hook_type => 'BP'
808: );

Line 805: hr_api.cannot_find_prog_unit_error

801: p_pdi_object_version_number => p_pdi_object_version_number
802: );
803: exception
804: when hr_api.cannot_find_prog_unit then
805: hr_api.cannot_find_prog_unit_error
806: (p_module_name => 'update_pdi',
807: p_hook_type => 'BP'
808: );
809: end;

Line 828: if p_routing_grp_id is not null and p_routing_grp_id <> hr_api.g_number then

824: -- Routing Group _Id can be changed only in a case where the request has been initiated
825: -- but not yet routed , for instance when the user uses the task flow button to
826: -- naviage to another form and when he comes back he can change the routing_grouip_id
827:
828: if p_routing_grp_id is not null and p_routing_grp_id <> hr_api.g_number then
829: for rout_group_id in c_routing_grp_id loop
830: l_routing_grp_id := rout_group_id.routing_group_id;
831: end loop;
832: if nvl(l_routing_grp_id,hr_api.g_number) <> p_routing_grp_id then

Line 832: if nvl(l_routing_grp_id,hr_api.g_number) <> p_routing_grp_id then

828: if p_routing_grp_id is not null and p_routing_grp_id <> hr_api.g_number then
829: for rout_group_id in c_routing_grp_id loop
830: l_routing_grp_id := rout_group_id.routing_group_id;
831: end loop;
832: if nvl(l_routing_grp_id,hr_api.g_number) <> p_routing_grp_id then
833: for cnt_of_history in c_cnt_history loop
834: l_cnt_history := cnt_of_history.cnt;
835: exit;
836: end loop;

Line 961: if nvl(l_reclass_action_taken,hr_api.g_varchar2) in ('RECLASSIFIED','CLASSIFIED') then

957: l_last_item_key := cur_routing_history_id.item_key;
958: exit;
959: end loop;
960:
961: if nvl(l_reclass_action_taken,hr_api.g_varchar2) in ('RECLASSIFIED','CLASSIFIED') then
962: if nvl(l_action_taken,hr_api.g_varchar2) in ('RECLASSIFIED','NOT_ROUTED') then
963: l_reclass_direct_flag := 'Y';
964: end if;
965: end if;

Line 962: if nvl(l_action_taken,hr_api.g_varchar2) in ('RECLASSIFIED','NOT_ROUTED') then

958: exit;
959: end loop;
960:
961: if nvl(l_reclass_action_taken,hr_api.g_varchar2) in ('RECLASSIFIED','CLASSIFIED') then
962: if nvl(l_action_taken,hr_api.g_varchar2) in ('RECLASSIFIED','NOT_ROUTED') then
963: l_reclass_direct_flag := 'Y';
964: end if;
965: end if;
966:

Line 1018: if not (nvl(l_action_taken,hr_api.g_varchar2) in ('NOT_ROUTED') and l_reclass_direct_flag = 'Y' )

1014: -- For reclassifaction of existing classfied PD we need two records one is for 'REOPENED' status
1015: -- another is for routing purposes
1016:
1017:
1018: if not (nvl(l_action_taken,hr_api.g_varchar2) in ('NOT_ROUTED') and l_reclass_direct_flag = 'Y' )
1019: then
1020: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','RECLASSIFIED','CLASSIFIED')
1021: then
1022:

Line 1020: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','RECLASSIFIED','CLASSIFIED')

1016:
1017:
1018: if not (nvl(l_action_taken,hr_api.g_varchar2) in ('NOT_ROUTED') and l_reclass_direct_flag = 'Y' )
1019: then
1020: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','RECLASSIFIED','CLASSIFIED')
1021: then
1022:
1023: hr_utility.set_location('l_action taken is ' || l_action_taken,10);
1024: hr_utility.set_location('l_reclass_direct is ' || l_reclass_direct_flag,10);

Line 1080: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED') then

1076: -- else sequence_number = 1
1077: -- if there are no more sequences, raise an error
1078: -- Insert 2nd record into routing_history for routing details (exception when action_taken = 'NOT_ROUTED')
1079:
1080: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED') then
1081: l_next_seq_numb := p_i_routing_seq_number;
1082: l_next_groupbox_id := p_i_groupbox_id;
1083: l_next_user_name := p_i_user_name_routed_to;
1084: -- fetch the next sequence number for the specific routing list, when it is not passed

Line 1140: or (nvl(l_action_taken,hr_api.g_varchar2) in ('NOT_ROUTED') and l_reclass_direct_flag = 'Y' )

1136:
1137:
1138:
1139: IF l_action_taken IN ('CANCELED','RECLASSIFIED','CLASSIFIED')
1140: or (nvl(l_action_taken,hr_api.g_varchar2) in ('NOT_ROUTED') and l_reclass_direct_flag = 'Y' )
1141: then
1142: hr_utility.set_location('l_action taken is ' || l_action_taken,10);
1143: hr_utility.set_location('l_reclass_direct is ' || l_reclass_direct_flag,10);
1144: for cur_routing_history_id in C_routing_history_id loop

Line 1265: when hr_api.cannot_find_prog_unit then

1261: p_i_pdh_object_version_number => p_i_pdh_object_version_number,
1262: p_pdi_object_version_number => l_pdi_object_version_number
1263: );
1264: exception
1265: when hr_api.cannot_find_prog_unit then
1266: hr_api.cannot_find_prog_unit_error
1267: (p_module_name => 'update_pdi',
1268: p_hook_type => 'AP'
1269: );

Line 1266: hr_api.cannot_find_prog_unit_error

1262: p_pdi_object_version_number => l_pdi_object_version_number
1263: );
1264: exception
1265: when hr_api.cannot_find_prog_unit then
1266: hr_api.cannot_find_prog_unit_error
1267: (p_module_name => 'update_pdi',
1268: p_hook_type => 'AP'
1269: );
1270: end;

Line 1275: RAISE hr_api.validate_enabled;

1271: --
1272: -- End of After Process User Hook call
1273: --
1274: IF p_validate THEN
1275: RAISE hr_api.validate_enabled;
1276: END IF;
1277: p_pdi_object_version_number := l_pdi_object_version_number;
1278: hr_utility.set_location('Leaving:'|| l_proc,11);
1279: EXCEPTION

Line 1280: WHEN hr_api.validate_enabled THEN

1276: END IF;
1277: p_pdi_object_version_number := l_pdi_object_version_number;
1278: hr_utility.set_location('Leaving:'|| l_proc,11);
1279: EXCEPTION
1280: WHEN hr_api.validate_enabled THEN
1281: --
1282: -- As the Validate_Enabled exception has been raised
1283: -- We must rollback to the savepoint
1284: --

Line 1424: if nvl(l_last_action_taken_2,hr_api.g_varchar2)

1420: l_pd_initiated := FALSE;
1421: end if;
1422: -- Setting the reclass_direct_flag
1423: if l_cnt_history > 1 then
1424: if nvl(l_last_action_taken_2,hr_api.g_varchar2)
1425: in ('RECLASSIFIED','CLASSIFIED') then
1426: if nvl(l_last_action_taken_1,hr_api.g_varchar2) = 'RECLASSIFIED' then
1427: l_reclass_direct_flag := 'Y';
1428: end if;

Line 1426: if nvl(l_last_action_taken_1,hr_api.g_varchar2) = 'RECLASSIFIED' then

1422: -- Setting the reclass_direct_flag
1423: if l_cnt_history > 1 then
1424: if nvl(l_last_action_taken_2,hr_api.g_varchar2)
1425: in ('RECLASSIFIED','CLASSIFIED') then
1426: if nvl(l_last_action_taken_1,hr_api.g_varchar2) = 'RECLASSIFIED' then
1427: l_reclass_direct_flag := 'Y';
1428: end if;
1429: end if;
1430: end if;