DBA Data[Home] [Help]

APPS.PQP_ANALYZED_ALIEN_DATA_API dependencies on HR_API

Line 131: ,p_assignment_id in number default hr_api.g_number

127: procedure update_analyzed_alien_data
128: (
129: p_validate in boolean default false
130: ,p_analyzed_data_id in number
131: ,p_assignment_id in number default hr_api.g_number
132: ,p_data_source in varchar2 default hr_api.g_varchar2
133: ,p_tax_year in number default hr_api.g_number
134: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
135: ,p_nra_to_ra_date in date default hr_api.g_date

Line 132: ,p_data_source in varchar2 default hr_api.g_varchar2

128: (
129: p_validate in boolean default false
130: ,p_analyzed_data_id in number
131: ,p_assignment_id in number default hr_api.g_number
132: ,p_data_source in varchar2 default hr_api.g_varchar2
133: ,p_tax_year in number default hr_api.g_number
134: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
135: ,p_nra_to_ra_date in date default hr_api.g_date
136: ,p_target_departure_date in date default hr_api.g_date

Line 133: ,p_tax_year in number default hr_api.g_number

129: p_validate in boolean default false
130: ,p_analyzed_data_id in number
131: ,p_assignment_id in number default hr_api.g_number
132: ,p_data_source in varchar2 default hr_api.g_varchar2
133: ,p_tax_year in number default hr_api.g_number
134: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
135: ,p_nra_to_ra_date in date default hr_api.g_date
136: ,p_target_departure_date in date default hr_api.g_date
137: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2

Line 134: ,p_current_residency_status in varchar2 default hr_api.g_varchar2

130: ,p_analyzed_data_id in number
131: ,p_assignment_id in number default hr_api.g_number
132: ,p_data_source in varchar2 default hr_api.g_varchar2
133: ,p_tax_year in number default hr_api.g_number
134: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
135: ,p_nra_to_ra_date in date default hr_api.g_date
136: ,p_target_departure_date in date default hr_api.g_date
137: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
138: ,p_treaty_info_update_date in date default hr_api.g_date

Line 135: ,p_nra_to_ra_date in date default hr_api.g_date

131: ,p_assignment_id in number default hr_api.g_number
132: ,p_data_source in varchar2 default hr_api.g_varchar2
133: ,p_tax_year in number default hr_api.g_number
134: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
135: ,p_nra_to_ra_date in date default hr_api.g_date
136: ,p_target_departure_date in date default hr_api.g_date
137: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
138: ,p_treaty_info_update_date in date default hr_api.g_date
139: ,p_number_of_days_in_usa in number default hr_api.g_number

Line 136: ,p_target_departure_date in date default hr_api.g_date

132: ,p_data_source in varchar2 default hr_api.g_varchar2
133: ,p_tax_year in number default hr_api.g_number
134: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
135: ,p_nra_to_ra_date in date default hr_api.g_date
136: ,p_target_departure_date in date default hr_api.g_date
137: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
138: ,p_treaty_info_update_date in date default hr_api.g_date
139: ,p_number_of_days_in_usa in number default hr_api.g_number
140: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2

Line 137: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2

133: ,p_tax_year in number default hr_api.g_number
134: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
135: ,p_nra_to_ra_date in date default hr_api.g_date
136: ,p_target_departure_date in date default hr_api.g_date
137: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
138: ,p_treaty_info_update_date in date default hr_api.g_date
139: ,p_number_of_days_in_usa in number default hr_api.g_number
140: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
141: ,p_ra_effective_date in date default hr_api.g_date

Line 138: ,p_treaty_info_update_date in date default hr_api.g_date

134: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
135: ,p_nra_to_ra_date in date default hr_api.g_date
136: ,p_target_departure_date in date default hr_api.g_date
137: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
138: ,p_treaty_info_update_date in date default hr_api.g_date
139: ,p_number_of_days_in_usa in number default hr_api.g_number
140: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
141: ,p_ra_effective_date in date default hr_api.g_date
142: ,p_record_source in varchar2 default hr_api.g_varchar2

Line 139: ,p_number_of_days_in_usa in number default hr_api.g_number

135: ,p_nra_to_ra_date in date default hr_api.g_date
136: ,p_target_departure_date in date default hr_api.g_date
137: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
138: ,p_treaty_info_update_date in date default hr_api.g_date
139: ,p_number_of_days_in_usa in number default hr_api.g_number
140: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
141: ,p_ra_effective_date in date default hr_api.g_date
142: ,p_record_source in varchar2 default hr_api.g_varchar2
143: ,p_visa_type in varchar2 default hr_api.g_varchar2

Line 140: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2

136: ,p_target_departure_date in date default hr_api.g_date
137: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
138: ,p_treaty_info_update_date in date default hr_api.g_date
139: ,p_number_of_days_in_usa in number default hr_api.g_number
140: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
141: ,p_ra_effective_date in date default hr_api.g_date
142: ,p_record_source in varchar2 default hr_api.g_varchar2
143: ,p_visa_type in varchar2 default hr_api.g_varchar2
144: ,p_j_sub_type in varchar2 default hr_api.g_varchar2

Line 141: ,p_ra_effective_date in date default hr_api.g_date

137: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
138: ,p_treaty_info_update_date in date default hr_api.g_date
139: ,p_number_of_days_in_usa in number default hr_api.g_number
140: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
141: ,p_ra_effective_date in date default hr_api.g_date
142: ,p_record_source in varchar2 default hr_api.g_varchar2
143: ,p_visa_type in varchar2 default hr_api.g_varchar2
144: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
145: ,p_primary_activity in varchar2 default hr_api.g_varchar2

Line 142: ,p_record_source in varchar2 default hr_api.g_varchar2

138: ,p_treaty_info_update_date in date default hr_api.g_date
139: ,p_number_of_days_in_usa in number default hr_api.g_number
140: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
141: ,p_ra_effective_date in date default hr_api.g_date
142: ,p_record_source in varchar2 default hr_api.g_varchar2
143: ,p_visa_type in varchar2 default hr_api.g_varchar2
144: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
145: ,p_primary_activity in varchar2 default hr_api.g_varchar2
146: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2

Line 143: ,p_visa_type in varchar2 default hr_api.g_varchar2

139: ,p_number_of_days_in_usa in number default hr_api.g_number
140: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
141: ,p_ra_effective_date in date default hr_api.g_date
142: ,p_record_source in varchar2 default hr_api.g_varchar2
143: ,p_visa_type in varchar2 default hr_api.g_varchar2
144: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
145: ,p_primary_activity in varchar2 default hr_api.g_varchar2
146: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
147: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2

Line 144: ,p_j_sub_type in varchar2 default hr_api.g_varchar2

140: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
141: ,p_ra_effective_date in date default hr_api.g_date
142: ,p_record_source in varchar2 default hr_api.g_varchar2
143: ,p_visa_type in varchar2 default hr_api.g_varchar2
144: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
145: ,p_primary_activity in varchar2 default hr_api.g_varchar2
146: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
147: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
148: ,p_object_version_number in out nocopy number

Line 145: ,p_primary_activity in varchar2 default hr_api.g_varchar2

141: ,p_ra_effective_date in date default hr_api.g_date
142: ,p_record_source in varchar2 default hr_api.g_varchar2
143: ,p_visa_type in varchar2 default hr_api.g_varchar2
144: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
145: ,p_primary_activity in varchar2 default hr_api.g_varchar2
146: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
147: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
148: ,p_object_version_number in out nocopy number
149: ,p_effective_date in date

Line 146: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2

142: ,p_record_source in varchar2 default hr_api.g_varchar2
143: ,p_visa_type in varchar2 default hr_api.g_varchar2
144: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
145: ,p_primary_activity in varchar2 default hr_api.g_varchar2
146: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
147: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
148: ,p_object_version_number in out nocopy number
149: ,p_effective_date in date
150: ,p_date_8233_signed in date default hr_api.g_date

Line 147: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2

143: ,p_visa_type in varchar2 default hr_api.g_varchar2
144: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
145: ,p_primary_activity in varchar2 default hr_api.g_varchar2
146: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
147: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
148: ,p_object_version_number in out nocopy number
149: ,p_effective_date in date
150: ,p_date_8233_signed in date default hr_api.g_date
151: ,p_date_w4_signed in date default hr_api.g_date

Line 150: ,p_date_8233_signed in date default hr_api.g_date

146: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
147: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
148: ,p_object_version_number in out nocopy number
149: ,p_effective_date in date
150: ,p_date_8233_signed in date default hr_api.g_date
151: ,p_date_w4_signed in date default hr_api.g_date
152: );
153: --
154: -- ----------------------------------------------------------------------------

Line 151: ,p_date_w4_signed in date default hr_api.g_date

147: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
148: ,p_object_version_number in out nocopy number
149: ,p_effective_date in date
150: ,p_date_8233_signed in date default hr_api.g_date
151: ,p_date_w4_signed in date default hr_api.g_date
152: );
153: --
154: -- ----------------------------------------------------------------------------
155: -- |------------------------< delete_analyzed_alien_data >------------------------|