APPS.PQP_GDA_BUS dependencies on PQP_GDA_SHD

Line 204: ,p_rec in pqp_gda_shd.g_rec_type

200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure chk_non_updateable_args
203: (p_effective_date in date
204: ,p_rec in pqp_gda_shd.g_rec_type
205: ) IS
206: --
207: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
208: --

Line 214: IF NOT pqp_gda_shd.api_updating

210: --
211: -- Only proceed with the validation if a row exists for the current
212: -- record in the HR Schema.
213: --
214: IF NOT pqp_gda_shd.api_updating
215: (p_gap_daily_absence_id => p_rec.gap_daily_absence_id
216: ,p_object_version_number => p_rec.object_version_number
217: ) THEN
218: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 225: nvl(pqp_gda_shd.g_old_rec.gap_absence_plan_id

221: fnd_message.raise_error;
222: END IF;
223: --
224: IF nvl(p_rec.gap_absence_plan_id, hr_api.g_number) <>
225: nvl(pqp_gda_shd.g_old_rec.gap_absence_plan_id
226: ,hr_api.g_number
227: ) THEN
228:
229: hr_api.argument_changed_error

Line 232: ,p_base_table => pqp_gda_shd.g_tab_nam

228:
229: hr_api.argument_changed_error
230: (p_api_name => l_proc
231: ,p_argument => 'GAP_ABSENCE_PLAN_ID'
232: ,p_base_table => pqp_gda_shd.g_tab_nam
233: );
234:
235: END IF;
236: --

Line 238: nvl(pqp_gda_shd.g_old_rec.absence_date

234:
235: END IF;
236: --
237: IF nvl(p_rec.absence_date, hr_api.g_date) <>
238: nvl(pqp_gda_shd.g_old_rec.absence_date
239: ,hr_api.g_date
240: ) THEN
241:
242: hr_api.argument_changed_error

Line 245: ,p_base_table => pqp_gda_shd.g_tab_nam

241:
242: hr_api.argument_changed_error
243: (p_api_name => l_proc
244: ,p_argument => 'ABSENCE_DATE'
245: ,p_base_table => pqp_gda_shd.g_tab_nam
246: );
247:
248: END IF;
249: --

Line 408: nvl(pqp_gda_shd.g_old_rec.work_pattern_day_type,

404: --
405: hr_utility.set_location(l_proc, 20);
406: --
407: if (((p_gap_daily_absence_id is not null) and
408: nvl(pqp_gda_shd.g_old_rec.work_pattern_day_type,
409: hr_api.g_varchar2) <> nvl(p_work_pattern_day_type,
410: hr_api.g_varchar2))
411: or
412: (p_gap_daily_absence_id is null)) then

Line 489: nvl(pqp_gda_shd.g_old_rec.level_of_entitlement,

485: --
486: hr_utility.set_location(l_proc, 20);
487: --
488: if (((p_gap_daily_absence_id is not null) and
489: nvl(pqp_gda_shd.g_old_rec.level_of_entitlement,
490: hr_api.g_varchar2) <> nvl(p_level_of_entitlement,
491: hr_api.g_varchar2))
492: or
493: (p_gap_daily_absence_id is null)) then

Line 572: nvl(pqp_gda_shd.g_old_rec.level_of_pay,

568: --
569: hr_utility.set_location(l_proc, 20);
570: --
571: if (((p_gap_daily_absence_id is not null) and
572: nvl(pqp_gda_shd.g_old_rec.level_of_pay,
573: hr_api.g_varchar2) <> nvl(p_level_of_pay,
574: hr_api.g_varchar2))
575: or
576: (p_gap_daily_absence_id is null)) then

Line 664: nvl(pqp_gda_shd.g_old_rec.duration,

660: --
661: hr_utility.set_location(l_proc, 20);
662: --
663: if (((p_gap_daily_absence_id is not null) and
664: nvl(pqp_gda_shd.g_old_rec.duration,
665: hr_api.g_number) <> nvl(p_duration,
666: hr_api.g_number))
667: or
668: (p_gap_daily_absence_id is null)) then

Line 737: nvl(pqp_gda_shd.g_old_rec.duration_in_hours,

733: --
734: hr_utility.set_location(l_proc, 20);
735: --
736: if (((p_gap_daily_absence_id is not null) and
737: nvl(pqp_gda_shd.g_old_rec.duration_in_hours,
738: hr_api.g_number) <> nvl(p_duration_in_hours,
739: hr_api.g_number))
740: or
741: (p_gap_daily_absence_id is null)) then

Line 809: nvl(pqp_gda_shd.g_old_rec.working_days_per_week,

805: --
806: hr_utility.set_location(l_proc, 20);
807: --
808: if (((p_gap_daily_absence_id is not null) and
809: nvl(pqp_gda_shd.g_old_rec.working_days_per_week,
810: hr_api.g_number) <> nvl(p_working_days_per_week,
811: hr_api.g_number))
812: or
813: (p_gap_daily_absence_id is null)) then

Line 886: nvl(pqp_gda_shd.g_old_rec.fte,hr_api.g_number)

882: --
883: hr_utility.set_location(l_proc, 20);
884: --
885: if (((p_gap_daily_absence_id is not null) and
886: nvl(pqp_gda_shd.g_old_rec.fte,hr_api.g_number)
887: <> nvl(p_fte, hr_api.g_number))
888: or
889: (p_gap_daily_absence_id is null)) then
890:

Line 917: ,p_rec in pqp_gda_shd.g_rec_type

913: -- |---------------------------< insert_validate >----------------------------|
914: -- ----------------------------------------------------------------------------
915: Procedure insert_validate
916: (p_effective_date in date
917: ,p_rec in pqp_gda_shd.g_rec_type
918: ) is
919: --
920: l_proc varchar2(72) := g_package||'insert_validate';
921: --

Line 990: ,p_rec in pqp_gda_shd.g_rec_type

986: -- |---------------------------< update_validate >----------------------------|
987: -- ----------------------------------------------------------------------------
988: Procedure update_validate
989: (p_effective_date in date
990: ,p_rec in pqp_gda_shd.g_rec_type
991: ) is
992: --
993: l_proc varchar2(72) := g_package||'update_validate';
994: --

Line 1067: (p_rec in pqp_gda_shd.g_rec_type

1063: -- ----------------------------------------------------------------------------
1064: -- |---------------------------< delete_validate >----------------------------|
1065: -- ----------------------------------------------------------------------------
1066: Procedure delete_validate
1067: (p_rec in pqp_gda_shd.g_rec_type
1068: ) is
1069: --
1070: l_proc varchar2(72) := g_package||'delete_validate';
1071: --