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.PQP_DET_UPD dependencies on PQP_DET_SHD

Line 54: Procedure update_dml(p_rec in out nocopy pqp_det_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy pqp_det_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: pqp_det_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: pqp_det_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the pqp_analyzed_alien_details Row
68: --
69: update pqp_analyzed_alien_details

Line 99: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

95: current_analysis = p_rec.current_analysis,
96: forecast_income_code = p_rec.forecast_income_code
97: where analyzed_data_details_id = p_rec.analyzed_data_details_id;
98: --
99: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
102: --
103: Exception

Line 106: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

102: --
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_det_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated

Line 107: pqp_det_shd.constraint_error

103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_det_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

Line 111: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

107: pqp_det_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_det_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated

Line 112: pqp_det_shd.constraint_error

108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_det_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

Line 116: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

112: pqp_det_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_det_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

Line 117: pqp_det_shd.constraint_error

113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_det_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;

Line 120: pqp_det_shd.g_api_dml := false; -- Unset the api dml status

116: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_det_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: pqp_det_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;
122: End update_dml;
123: --
124: -- ----------------------------------------------------------------------------

Line 156: Procedure pre_update(p_rec in pqp_det_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- ----------------------------------------------------------------------------
156: Procedure pre_update(p_rec in pqp_det_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'pre_update';
159: --
160: Begin

Line 199: p_effective_date in date,p_rec in pqp_det_shd.g_rec_type) is

195: --
196: -- {End Of Comments}
197: -- ----------------------------------------------------------------------------
198: Procedure post_update(
199: p_effective_date in date,p_rec in pqp_det_shd.g_rec_type) is
200: --
201: l_proc varchar2(72) := g_package||'post_update';
202: --
203: Begin

Line 240: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id

236: ,p_effective_date =>p_effective_date
237: ,p_retro_loss_notification_sent =>p_rec.retro_loss_notification_sent
238: ,p_current_analysis =>p_rec.current_analysis
239: ,p_forecast_income_code =>p_rec.forecast_income_code
240: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id
241: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
242: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
243: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
244: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code

Line 241: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code

237: ,p_retro_loss_notification_sent =>p_rec.retro_loss_notification_sent
238: ,p_current_analysis =>p_rec.current_analysis
239: ,p_forecast_income_code =>p_rec.forecast_income_code
240: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id
241: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
242: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
243: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
244: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
245: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount

Line 242: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate

238: ,p_current_analysis =>p_rec.current_analysis
239: ,p_forecast_income_code =>p_rec.forecast_income_code
240: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id
241: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
242: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
243: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
244: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
245: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
246: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag

Line 243: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type

239: ,p_forecast_income_code =>p_rec.forecast_income_code
240: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id
241: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
242: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
243: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
244: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
245: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
246: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
247: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends

Line 244: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code

240: ,p_analyzed_data_id_o =>pqp_det_shd.g_old_rec.analyzed_data_id
241: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
242: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
243: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
244: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
245: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
246: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
247: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
248: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag

Line 245: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount

241: ,p_income_code_o =>pqp_det_shd.g_old_rec.income_code
242: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
243: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
244: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
245: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
246: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
247: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
248: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
249: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss

Line 246: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag

242: ,p_withholding_rate_o =>pqp_det_shd.g_old_rec.withholding_rate
243: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
244: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
245: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
246: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
247: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
248: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
249: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
250: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare

Line 247: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends

243: ,p_income_code_sub_type_o =>pqp_det_shd.g_old_rec.income_code_sub_type
244: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
245: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
246: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
247: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
248: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
249: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
250: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
251: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss

Line 248: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag

244: ,p_exemption_code_o =>pqp_det_shd.g_old_rec.exemption_code
245: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
246: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
247: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
248: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
249: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
250: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
251: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
252: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare

Line 249: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss

245: ,p_maximum_benefit_amount_o =>pqp_det_shd.g_old_rec.maximum_benefit_amount
246: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
247: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
248: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
249: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
250: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
251: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
252: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
253: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag

Line 250: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare

246: ,p_retro_lose_ben_amt_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
247: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
248: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
249: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
250: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
251: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
252: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
253: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
254: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax

Line 251: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss

247: ,p_date_benefit_ends_o =>pqp_det_shd.g_old_rec.date_benefit_ends
248: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
249: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
250: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
251: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
252: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
253: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
254: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
255: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt

Line 252: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare

248: ,p_retro_lose_ben_date_flag_o =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
249: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
250: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
251: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
252: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
253: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
254: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
255: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
256: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type

Line 253: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag

249: ,p_nra_exempt_from_ss_o =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
250: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
251: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
252: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
253: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
254: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
255: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
256: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
257: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption

Line 254: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax

250: ,p_nra_exempt_from_medicare_o =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
251: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
252: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
253: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
254: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
255: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
256: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
257: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
258: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed

Line 255: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt

251: ,p_student_exempt_from_ss_o =>pqp_det_shd.g_old_rec.student_exempt_from_ss
252: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
253: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
254: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
255: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
256: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
257: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
258: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
259: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag

Line 256: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type

252: ,p_student_exempt_from_medi_o =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
253: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
254: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
255: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
256: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
257: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
258: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
259: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
260: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date

Line 257: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption

253: ,p_addl_withholding_flag_o =>pqp_det_shd.g_old_rec.addl_withholding_flag
254: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
255: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
256: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
257: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
258: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
259: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
260: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
261: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number

Line 258: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed

254: ,p_constant_addl_tax_o =>pqp_det_shd.g_old_rec.constant_addl_tax
255: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
256: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
257: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
258: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
259: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
260: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
261: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
262: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent

Line 259: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag

255: ,p_addl_withholding_amt_o =>pqp_det_shd.g_old_rec.addl_withholding_amt
256: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
257: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
258: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
259: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
260: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
261: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
262: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
263: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis

Line 260: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date

256: ,p_addl_wthldng_amt_period_ty_o =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
257: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
258: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
259: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
260: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
261: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
262: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
263: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis
264: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code

Line 261: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number

257: ,p_personal_exemption_o =>pqp_det_shd.g_old_rec.personal_exemption
258: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
259: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
260: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
261: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
262: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
263: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis
264: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code
265: );

Line 262: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent

258: ,p_addl_exemption_allowed_o =>pqp_det_shd.g_old_rec.addl_exemption_allowed
259: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
260: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
261: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
262: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
263: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis
264: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code
265: );
266: --

Line 263: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis

259: ,p_treaty_ben_allowed_flag_o =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
260: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
261: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
262: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
263: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis
264: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code
265: );
266: --
267: exception

Line 264: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code

260: ,p_treaty_benefits_start_date_o =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
261: ,p_object_version_number_o =>pqp_det_shd.g_old_rec.object_version_number
262: ,p_retro_loss_notif_sent_o =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
263: ,p_current_analysis_o =>pqp_det_shd.g_old_rec.current_analysis
264: ,p_forecast_income_code_o =>pqp_det_shd.g_old_rec.forecast_income_code
265: );
266: --
267: exception
268: --

Line 326: Procedure convert_defs(p_rec in out nocopy pqp_det_shd.g_rec_type) is

322: -- Internal Row Handler Use Only.
323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure convert_defs(p_rec in out nocopy pqp_det_shd.g_rec_type) is
327: --
328: l_proc varchar2(72) := g_package||'convert_defs';
329: --
330: Begin

Line 341: pqp_det_shd.g_old_rec.analyzed_data_id;

337: -- is being used then we must set to the 'current' argument value.
338: --
339: If (p_rec.analyzed_data_id = hr_api.g_number) then
340: p_rec.analyzed_data_id :=
341: pqp_det_shd.g_old_rec.analyzed_data_id;
342: End If;
343: If (p_rec.income_code = hr_api.g_varchar2) then
344: p_rec.income_code :=
345: pqp_det_shd.g_old_rec.income_code;

Line 345: pqp_det_shd.g_old_rec.income_code;

341: pqp_det_shd.g_old_rec.analyzed_data_id;
342: End If;
343: If (p_rec.income_code = hr_api.g_varchar2) then
344: p_rec.income_code :=
345: pqp_det_shd.g_old_rec.income_code;
346: End If;
347: If (p_rec.withholding_rate = hr_api.g_number) then
348: p_rec.withholding_rate :=
349: pqp_det_shd.g_old_rec.withholding_rate;

Line 349: pqp_det_shd.g_old_rec.withholding_rate;

345: pqp_det_shd.g_old_rec.income_code;
346: End If;
347: If (p_rec.withholding_rate = hr_api.g_number) then
348: p_rec.withholding_rate :=
349: pqp_det_shd.g_old_rec.withholding_rate;
350: End If;
351: If (p_rec.income_code_sub_type = hr_api.g_varchar2) then
352: p_rec.income_code_sub_type :=
353: pqp_det_shd.g_old_rec.income_code_sub_type;

Line 353: pqp_det_shd.g_old_rec.income_code_sub_type;

349: pqp_det_shd.g_old_rec.withholding_rate;
350: End If;
351: If (p_rec.income_code_sub_type = hr_api.g_varchar2) then
352: p_rec.income_code_sub_type :=
353: pqp_det_shd.g_old_rec.income_code_sub_type;
354: End If;
355: If (p_rec.exemption_code = hr_api.g_varchar2) then
356: p_rec.exemption_code :=
357: pqp_det_shd.g_old_rec.exemption_code;

Line 357: pqp_det_shd.g_old_rec.exemption_code;

353: pqp_det_shd.g_old_rec.income_code_sub_type;
354: End If;
355: If (p_rec.exemption_code = hr_api.g_varchar2) then
356: p_rec.exemption_code :=
357: pqp_det_shd.g_old_rec.exemption_code;
358: End If;
359: If (p_rec.maximum_benefit_amount = hr_api.g_number) then
360: p_rec.maximum_benefit_amount :=
361: pqp_det_shd.g_old_rec.maximum_benefit_amount;

Line 361: pqp_det_shd.g_old_rec.maximum_benefit_amount;

357: pqp_det_shd.g_old_rec.exemption_code;
358: End If;
359: If (p_rec.maximum_benefit_amount = hr_api.g_number) then
360: p_rec.maximum_benefit_amount :=
361: pqp_det_shd.g_old_rec.maximum_benefit_amount;
362: End If;
363: If (p_rec.retro_lose_ben_amt_flag = hr_api.g_varchar2) then
364: p_rec.retro_lose_ben_amt_flag :=
365: pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag;

Line 365: pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag;

361: pqp_det_shd.g_old_rec.maximum_benefit_amount;
362: End If;
363: If (p_rec.retro_lose_ben_amt_flag = hr_api.g_varchar2) then
364: p_rec.retro_lose_ben_amt_flag :=
365: pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag;
366: End If;
367: If (p_rec.date_benefit_ends = hr_api.g_date) then
368: p_rec.date_benefit_ends :=
369: pqp_det_shd.g_old_rec.date_benefit_ends;

Line 369: pqp_det_shd.g_old_rec.date_benefit_ends;

365: pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag;
366: End If;
367: If (p_rec.date_benefit_ends = hr_api.g_date) then
368: p_rec.date_benefit_ends :=
369: pqp_det_shd.g_old_rec.date_benefit_ends;
370: End If;
371: If (p_rec.retro_lose_ben_date_flag = hr_api.g_varchar2) then
372: p_rec.retro_lose_ben_date_flag :=
373: pqp_det_shd.g_old_rec.retro_lose_ben_date_flag;

Line 373: pqp_det_shd.g_old_rec.retro_lose_ben_date_flag;

369: pqp_det_shd.g_old_rec.date_benefit_ends;
370: End If;
371: If (p_rec.retro_lose_ben_date_flag = hr_api.g_varchar2) then
372: p_rec.retro_lose_ben_date_flag :=
373: pqp_det_shd.g_old_rec.retro_lose_ben_date_flag;
374: End If;
375: If (p_rec.nra_exempt_from_ss = hr_api.g_varchar2) then
376: p_rec.nra_exempt_from_ss :=
377: pqp_det_shd.g_old_rec.nra_exempt_from_ss;

Line 377: pqp_det_shd.g_old_rec.nra_exempt_from_ss;

373: pqp_det_shd.g_old_rec.retro_lose_ben_date_flag;
374: End If;
375: If (p_rec.nra_exempt_from_ss = hr_api.g_varchar2) then
376: p_rec.nra_exempt_from_ss :=
377: pqp_det_shd.g_old_rec.nra_exempt_from_ss;
378: End If;
379: If (p_rec.nra_exempt_from_medicare = hr_api.g_varchar2) then
380: p_rec.nra_exempt_from_medicare :=
381: pqp_det_shd.g_old_rec.nra_exempt_from_medicare;

Line 381: pqp_det_shd.g_old_rec.nra_exempt_from_medicare;

377: pqp_det_shd.g_old_rec.nra_exempt_from_ss;
378: End If;
379: If (p_rec.nra_exempt_from_medicare = hr_api.g_varchar2) then
380: p_rec.nra_exempt_from_medicare :=
381: pqp_det_shd.g_old_rec.nra_exempt_from_medicare;
382: End If;
383: If (p_rec.student_exempt_from_ss = hr_api.g_varchar2) then
384: p_rec.student_exempt_from_ss :=
385: pqp_det_shd.g_old_rec.student_exempt_from_ss;

Line 385: pqp_det_shd.g_old_rec.student_exempt_from_ss;

381: pqp_det_shd.g_old_rec.nra_exempt_from_medicare;
382: End If;
383: If (p_rec.student_exempt_from_ss = hr_api.g_varchar2) then
384: p_rec.student_exempt_from_ss :=
385: pqp_det_shd.g_old_rec.student_exempt_from_ss;
386: End If;
387: If (p_rec.student_exempt_from_medicare = hr_api.g_varchar2) then
388: p_rec.student_exempt_from_medicare :=
389: pqp_det_shd.g_old_rec.student_exempt_from_medicare;

Line 389: pqp_det_shd.g_old_rec.student_exempt_from_medicare;

385: pqp_det_shd.g_old_rec.student_exempt_from_ss;
386: End If;
387: If (p_rec.student_exempt_from_medicare = hr_api.g_varchar2) then
388: p_rec.student_exempt_from_medicare :=
389: pqp_det_shd.g_old_rec.student_exempt_from_medicare;
390: End If;
391: If (p_rec.addl_withholding_flag = hr_api.g_varchar2) then
392: p_rec.addl_withholding_flag :=
393: pqp_det_shd.g_old_rec.addl_withholding_flag;

Line 393: pqp_det_shd.g_old_rec.addl_withholding_flag;

389: pqp_det_shd.g_old_rec.student_exempt_from_medicare;
390: End If;
391: If (p_rec.addl_withholding_flag = hr_api.g_varchar2) then
392: p_rec.addl_withholding_flag :=
393: pqp_det_shd.g_old_rec.addl_withholding_flag;
394: End If;
395: If (p_rec.constant_addl_tax = hr_api.g_number) then
396: p_rec.constant_addl_tax :=
397: pqp_det_shd.g_old_rec.constant_addl_tax;

Line 397: pqp_det_shd.g_old_rec.constant_addl_tax;

393: pqp_det_shd.g_old_rec.addl_withholding_flag;
394: End If;
395: If (p_rec.constant_addl_tax = hr_api.g_number) then
396: p_rec.constant_addl_tax :=
397: pqp_det_shd.g_old_rec.constant_addl_tax;
398: End If;
399: If (p_rec.addl_withholding_amt = hr_api.g_number) then
400: p_rec.addl_withholding_amt :=
401: pqp_det_shd.g_old_rec.addl_withholding_amt;

Line 401: pqp_det_shd.g_old_rec.addl_withholding_amt;

397: pqp_det_shd.g_old_rec.constant_addl_tax;
398: End If;
399: If (p_rec.addl_withholding_amt = hr_api.g_number) then
400: p_rec.addl_withholding_amt :=
401: pqp_det_shd.g_old_rec.addl_withholding_amt;
402: End If;
403: If (p_rec.addl_wthldng_amt_period_type = hr_api.g_varchar2) then
404: p_rec.addl_wthldng_amt_period_type :=
405: pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type;

Line 405: pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type;

401: pqp_det_shd.g_old_rec.addl_withholding_amt;
402: End If;
403: If (p_rec.addl_wthldng_amt_period_type = hr_api.g_varchar2) then
404: p_rec.addl_wthldng_amt_period_type :=
405: pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type;
406: End If;
407: If (p_rec.personal_exemption = hr_api.g_number) then
408: p_rec.personal_exemption :=
409: pqp_det_shd.g_old_rec.personal_exemption;

Line 409: pqp_det_shd.g_old_rec.personal_exemption;

405: pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type;
406: End If;
407: If (p_rec.personal_exemption = hr_api.g_number) then
408: p_rec.personal_exemption :=
409: pqp_det_shd.g_old_rec.personal_exemption;
410: End If;
411: If (p_rec.addl_exemption_allowed = hr_api.g_number) then
412: p_rec.addl_exemption_allowed :=
413: pqp_det_shd.g_old_rec.addl_exemption_allowed;

Line 413: pqp_det_shd.g_old_rec.addl_exemption_allowed;

409: pqp_det_shd.g_old_rec.personal_exemption;
410: End If;
411: If (p_rec.addl_exemption_allowed = hr_api.g_number) then
412: p_rec.addl_exemption_allowed :=
413: pqp_det_shd.g_old_rec.addl_exemption_allowed;
414: End If;
415: If (p_rec.treaty_ben_allowed_flag = hr_api.g_varchar2) then
416: p_rec.treaty_ben_allowed_flag :=
417: pqp_det_shd.g_old_rec.treaty_ben_allowed_flag;

Line 417: pqp_det_shd.g_old_rec.treaty_ben_allowed_flag;

413: pqp_det_shd.g_old_rec.addl_exemption_allowed;
414: End If;
415: If (p_rec.treaty_ben_allowed_flag = hr_api.g_varchar2) then
416: p_rec.treaty_ben_allowed_flag :=
417: pqp_det_shd.g_old_rec.treaty_ben_allowed_flag;
418: End If;
419: If (p_rec.treaty_benefits_start_date = hr_api.g_date) then
420: p_rec.treaty_benefits_start_date :=
421: pqp_det_shd.g_old_rec.treaty_benefits_start_date;

Line 421: pqp_det_shd.g_old_rec.treaty_benefits_start_date;

417: pqp_det_shd.g_old_rec.treaty_ben_allowed_flag;
418: End If;
419: If (p_rec.treaty_benefits_start_date = hr_api.g_date) then
420: p_rec.treaty_benefits_start_date :=
421: pqp_det_shd.g_old_rec.treaty_benefits_start_date;
422: End If;
423: If (p_rec.retro_loss_notification_sent = hr_api.g_varchar2) then
424: p_rec.retro_loss_notification_sent :=
425: pqp_det_shd.g_old_rec.retro_loss_notification_sent;

Line 425: pqp_det_shd.g_old_rec.retro_loss_notification_sent;

421: pqp_det_shd.g_old_rec.treaty_benefits_start_date;
422: End If;
423: If (p_rec.retro_loss_notification_sent = hr_api.g_varchar2) then
424: p_rec.retro_loss_notification_sent :=
425: pqp_det_shd.g_old_rec.retro_loss_notification_sent;
426: End If;
427: If (p_rec.current_analysis = hr_api.g_varchar2) then
428: p_rec.current_analysis :=
429: pqp_det_shd.g_old_rec.current_analysis;

Line 429: pqp_det_shd.g_old_rec.current_analysis;

425: pqp_det_shd.g_old_rec.retro_loss_notification_sent;
426: End If;
427: If (p_rec.current_analysis = hr_api.g_varchar2) then
428: p_rec.current_analysis :=
429: pqp_det_shd.g_old_rec.current_analysis;
430: End If;
431: If (p_rec.forecast_income_code = hr_api.g_varchar2) then
432: p_rec.forecast_income_code :=
433: pqp_det_shd.g_old_rec.forecast_income_code;

Line 433: pqp_det_shd.g_old_rec.forecast_income_code;

429: pqp_det_shd.g_old_rec.current_analysis;
430: End If;
431: If (p_rec.forecast_income_code = hr_api.g_varchar2) then
432: p_rec.forecast_income_code :=
433: pqp_det_shd.g_old_rec.forecast_income_code;
434: End If;
435:
436: --
437: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 447: p_rec in out nocopy pqp_det_shd.g_rec_type

443: -- ----------------------------------------------------------------------------
444: Procedure upd
445: (
446: p_effective_date in date,
447: p_rec in out nocopy pqp_det_shd.g_rec_type
448: ) is
449: --
450: l_proc varchar2(72) := g_package||'upd';
451: --

Line 457: pqp_det_shd.lck

453: hr_utility.set_location('Entering:'||l_proc, 5);
454: --
455: -- We must lock the row which we need to update.
456: --
457: pqp_det_shd.lck
458: (
459: p_rec.analyzed_data_details_id,
460: p_rec.object_version_number
461: );

Line 521: l_rec pqp_det_shd.g_rec_type;

517: p_current_analysis in varchar2 default hr_api.g_varchar2,
518: p_forecast_income_code in varchar2 default hr_api.g_varchar2
519: ) is
520: --
521: l_rec pqp_det_shd.g_rec_type;
522: l_proc varchar2(72) := g_package||'upd';
523: --
524: Begin
525: hr_utility.set_location('Entering:'||l_proc, 5);

Line 531: pqp_det_shd.convert_args

527: -- Call conversion function to turn arguments into the
528: -- l_rec structure.
529: --
530: l_rec :=
531: pqp_det_shd.convert_args
532: (
533: p_analyzed_data_details_id,
534: p_analyzed_data_id,
535: p_income_code,