DBA Data[Home] [Help]

APPS.GHR_MASS_CHANGES dependencies on GHR_PAR_UPD

Line 948: -- ghr_par_upd.upd

944: -- from the above procedure, use it in the ghr_prh_upd.upd to update the groupbox_id
945: -- ( use ghr_mass_actions_pkg.get_personnel_off_groupbox to get the groupbox_id and
946: -- the routing_group_id)
947: -- Also update the ghr_pa_requests with the routing_group_id passed out
948: -- ghr_par_upd.upd
949: -- If the groupbox_id is null, then rollback to create_52_for_mass_changes and then nake an
950: -- entry in the ghr_process_log -- (not sure about this part)
951:
952: BEGIN

Line 979: -- Call ghr_par_upd.upd here

975: p_groupbox_id => l_groupbox_id,
976: p_object_version_number => l_1_prh_object_version_number);
977:
978:
979: -- Call ghr_par_upd.upd here
980: ghr_par_upd.upd(
981: p_pa_request_id => l_pa_request_rec.pa_request_id,
982: p_routing_group_id => l_routing_group_id,
983: p_object_version_number => l_pa_request_rec.object_version_number);

Line 980: ghr_par_upd.upd(

976: p_object_version_number => l_1_prh_object_version_number);
977:
978:
979: -- Call ghr_par_upd.upd here
980: ghr_par_upd.upd(
981: p_pa_request_id => l_pa_request_rec.pa_request_id,
982: p_routing_group_id => l_routing_group_id,
983: p_object_version_number => l_pa_request_rec.object_version_number);
984:

Line 1058: ghr_par_upd.upd

1054: p_employee_dept_or_agency => l_pa_request_rec.employee_dept_or_agency,
1055: p_to_office_symbol => l_pa_request_rec.to_office_symbol);
1056:
1057: -- VSM : Bug # 677880, Added sf50 parameters to populate the values.
1058: ghr_par_upd.upd
1059: (p_pa_request_id => l_pa_request_rec.pa_request_id,
1060: p_object_version_number => l_pa_request_rec.object_version_number,
1061: p_agency_code => l_pa_request_rec.agency_code,
1062: p_from_agency_code => l_pa_request_rec.from_agency_code,

Line 1078: ghr_par_upd.upd(

1074: --BEGIN BUG# 14055214
1075: IF p_mass_action_type = 'MASS_NOA_SEL' THEN
1076: IF l_pa_request_rec.first_noa_code IN ('800') THEN
1077: IF l_target_flsa_category IS NOT NULL THEN
1078: ghr_par_upd.upd(
1079: p_pa_request_id => l_pa_request_rec.pa_request_id,
1080: p_flsa_category => l_target_flsa_category,
1081: p_object_version_number => l_pa_request_rec.object_version_number);
1082: END IF;

Line 1084: ghr_par_upd.upd(

1080: p_flsa_category => l_target_flsa_category,
1081: p_object_version_number => l_pa_request_rec.object_version_number);
1082: END IF;
1083: IF l_target_barg_unit_status IS NOT NULL THEN
1084: ghr_par_upd.upd(
1085: p_pa_request_id => l_pa_request_rec.pa_request_id,
1086: p_bargaining_unit_status => l_target_barg_unit_status,
1087: p_object_version_number => l_pa_request_rec.object_version_number);
1088: END IF;

Line 1090: ghr_par_upd.upd(

1086: p_bargaining_unit_status => l_target_barg_unit_status,
1087: p_object_version_number => l_pa_request_rec.object_version_number);
1088: END IF;
1089: IF l_target_occ_code IS NOT NULL THEN
1090: ghr_par_upd.upd(
1091: p_pa_request_id => l_pa_request_rec.pa_request_id,
1092: p_to_occ_code => l_target_occ_code,
1093: p_to_job_id => l_target_job_id,
1094: p_object_version_number => l_pa_request_rec.object_version_number);

Line 1098: ghr_par_upd.upd(

1094: p_object_version_number => l_pa_request_rec.object_version_number);
1095: END IF;
1096: --Begin Bug# 14410401
1097: IF l_target_functional_class IS NOT NULL THEN
1098: ghr_par_upd.upd(
1099: p_pa_request_id => l_pa_request_rec.pa_request_id,
1100: p_functional_class => l_target_functional_class,
1101: p_object_version_number => l_pa_request_rec.object_version_number);
1102: END IF;

Line 1109: ghr_par_upd.upd(

1105: l_employee_dept_or_agency := hr_general.decode_lookup
1106: (p_lookup_type => 'GHR_US_AGENCY_CODE',
1107: p_lookup_code => l_target_agency_code_subelmt
1108: );
1109: ghr_par_upd.upd(
1110: p_pa_request_id => l_pa_request_rec.pa_request_id,
1111: p_agency_code => l_target_agency_code_subelmt,
1112: p_employee_dept_or_agency => l_employee_dept_or_agency,
1113: p_object_version_number => l_pa_request_rec.object_version_number);

Line 1118: ghr_par_upd.upd(

1114: END IF;
1115: END IF;
1116: IF l_pa_request_rec.first_noa_code IN ('792') THEN
1117: IF l_target_barg_unit_status IS NOT NULL THEN
1118: ghr_par_upd.upd(
1119: p_pa_request_id => l_pa_request_rec.pa_request_id,
1120: p_bargaining_unit_status => l_target_barg_unit_status,
1121: p_object_version_number => l_pa_request_rec.object_version_number);
1122: END IF;