APPS.PQH_STS_UPD dependencies on HR_API

Line 100: ,p_business_group_id in number default hr_api.g_number

96: Procedure upd
97: (p_effective_date in date
98: ,p_statutory_situation_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_business_group_id in number default hr_api.g_number
101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2

Line 101: ,p_situation_name in varchar2 default hr_api.g_varchar2

97: (p_effective_date in date
98: ,p_statutory_situation_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_business_group_id in number default hr_api.g_number
101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2

Line 102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2

98: ,p_statutory_situation_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_business_group_id in number default hr_api.g_number
101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2

Line 103: ,p_situation_type in varchar2 default hr_api.g_varchar2

99: ,p_object_version_number in out nocopy number
100: ,p_business_group_id in number default hr_api.g_number
101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2

Line 104: ,p_sub_type in varchar2 default hr_api.g_varchar2

100: ,p_business_group_id in number default hr_api.g_number
101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2

Line 105: ,p_source in varchar2 default hr_api.g_varchar2

101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date

Line 106: ,p_location in varchar2 default hr_api.g_varchar2

102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date

Line 107: ,p_reason in varchar2 default hr_api.g_varchar2

103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2

Line 108: ,p_is_default in varchar2 default hr_api.g_varchar2

104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2

Line 109: ,p_date_from in date default hr_api.g_date

105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2

Line 110: ,p_date_to in date default hr_api.g_date

106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2

Line 111: ,p_request_type in varchar2 default hr_api.g_varchar2

107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2

Line 112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2

108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2

Line 113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2

109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2

Line 114: ,p_print_arrette in varchar2 default hr_api.g_varchar2

110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2

Line 115: ,p_reserve_position in varchar2 default hr_api.g_varchar2

111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number

Line 116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2

112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number

Line 117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2

113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2

114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number

Line 119: ,p_pay_share in number default hr_api.g_number

115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number

Line 120: ,p_pay_periods in number default hr_api.g_number

116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number

Line 121: ,p_frequency in varchar2 default hr_api.g_varchar2

117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number

Line 122: ,p_first_period_max_duration in number default hr_api.g_number

118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2

Line 123: ,p_min_duration_per_request in number default hr_api.g_number

119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number

Line 124: ,p_max_duration_per_request in number default hr_api.g_number

120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number

Line 125: ,p_max_duration_whole_career in number default hr_api.g_number

121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number

Line 126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2

122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number
130: ,p_remunerate_assign_status_id in number default hr_api.g_number

Line 127: ,p_max_no_of_renewals in number default hr_api.g_number

123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number
130: ,p_remunerate_assign_status_id in number default hr_api.g_number
131: );

Line 128: ,p_max_duration_per_renewal in number default hr_api.g_number

124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number
130: ,p_remunerate_assign_status_id in number default hr_api.g_number
131: );
132: --

Line 129: ,p_max_tot_continuous_duration in number default hr_api.g_number

125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number
130: ,p_remunerate_assign_status_id in number default hr_api.g_number
131: );
132: --
133: end pqh_sts_upd;

Line 130: ,p_remunerate_assign_status_id in number default hr_api.g_number

126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number
130: ,p_remunerate_assign_status_id in number default hr_api.g_number
131: );
132: --
133: end pqh_sts_upd;