DBA Data[Home] [Help]

APPS.PAY_EVQ_BUS dependencies on PAY_EVQ_SHD

Line 182: ,p_rec in pay_evq_shd.g_rec_type

178: -- {End Of Comments}
179: -- ----------------------------------------------------------------------------
180: Procedure chk_non_updateable_args
181: (p_effective_date in date
182: ,p_rec in pay_evq_shd.g_rec_type
183: ) IS
184: --
185: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
186: l_error EXCEPTION;

Line 195: IF NOT pay_evq_shd.api_updating

191: --
192: -- Only proceed with the validation if a row exists for the current
193: -- record in the HR Schema.
194: --
195: IF NOT pay_evq_shd.api_updating
196: (p_event_qualifier_id => p_rec.event_qualifier_id
197: ,p_effective_date => p_effective_date
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN

Line 210: nvl(pay_evq_shd.g_old_rec.event_qualifier_id, hr_api.g_number)

206: -- Checks to ensure non-updateable args havent been updated.
207: --
208: --
209: if (nvl(p_rec.event_qualifier_id, hr_api.g_number) <>
210: nvl(pay_evq_shd.g_old_rec.event_qualifier_id, hr_api.g_number)
211: ) then
212: l_argument := 'event_qualifier_id';
213: raise l_error;
214: END IF;

Line 217: nvl(pay_evq_shd.g_old_rec.dated_table_id,hr_api.g_number)

213: raise l_error;
214: END IF;
215: --
216: if (nvl(p_rec.dated_table_id, hr_api.g_number) <>
217: nvl(pay_evq_shd.g_old_rec.dated_table_id,hr_api.g_number)
218: ) then
219: l_argument := 'dated_table_id';
220: raise l_error;
221: END IF;

Line 224: nvl(pay_evq_shd.g_old_rec.column_name,hr_api.g_varchar2)

220: raise l_error;
221: END IF;
222: --
223: if (nvl(p_rec.column_name, hr_api.g_varchar2) <>
224: nvl(pay_evq_shd.g_old_rec.column_name,hr_api.g_varchar2)
225: ) then
226: l_argument := 'column_name';
227: raise l_error;
228: END IF;

Line 231: nvl(pay_evq_shd.g_old_rec.qualifier_name,hr_api.g_varchar2)

227: raise l_error;
228: END IF;
229: --
230: if (nvl(p_rec.qualifier_name, hr_api.g_varchar2) <>
231: nvl(pay_evq_shd.g_old_rec.qualifier_name,hr_api.g_varchar2)
232: ) then
233: l_argument := 'qualifier_name';
234: raise l_error;
235: END IF;

Line 238: nvl(pay_evq_shd.g_old_rec.legislation_code,hr_api.g_varchar2)

234: raise l_error;
235: END IF;
236: --
237: if (nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
238: nvl(pay_evq_shd.g_old_rec.legislation_code,hr_api.g_varchar2)
239: ) then
240: l_argument := 'legislation_code';
241: raise l_error;
242: END IF;

Line 245: nvl(pay_evq_shd.g_old_rec.business_group_id,hr_api.g_number)

241: raise l_error;
242: END IF;
243: --
244: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
245: nvl(pay_evq_shd.g_old_rec.business_group_id,hr_api.g_number)
246: ) then
247: l_argument := 'business_group_id';
248: raise l_error;
249: END IF;

Line 517: (p_rec in pay_evq_shd.g_rec_type

513: --
514: -- {End of comments}
515: --
516: Procedure chk_tab_col
517: (p_rec in pay_evq_shd.g_rec_type
518: ) is
519: l_proc varchar2(72) := g_package||'chk_tab_col';
520: l_table varchar2(30);
521: --

Line 558: (p_rec in pay_evq_shd.g_rec_type

554: -- ----------------------------------------------------------------------------
555: -- |---------------------------< insert_validate >----------------------------|
556: -- ----------------------------------------------------------------------------
557: Procedure insert_validate
558: (p_rec in pay_evq_shd.g_rec_type
559: ,p_effective_date in date
560: ,p_datetrack_mode in varchar2
561: ,p_validation_start_date in date
562: ,p_validation_end_date in date

Line 586: ,p_associated_column1 => pay_evq_shd.g_tab_name

582: -- Validate Important Attributes
583: --
584: hr_api.validate_bus_grp_id
585: (p_business_group_id => p_rec.business_group_id
586: ,p_associated_column1 => pay_evq_shd.g_tab_name
587: || '.BUSINESS_GROUP_ID');
588: end if;
589: -- NOTE, if business_group_id is null then
590: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS

Line 613: (p_rec in pay_evq_shd.g_rec_type

609: -- ----------------------------------------------------------------------------
610: -- |---------------------------< update_validate >----------------------------|
611: -- ----------------------------------------------------------------------------
612: Procedure update_validate
613: (p_rec in pay_evq_shd.g_rec_type
614: ,p_effective_date in date
615: ,p_datetrack_mode in varchar2
616: ,p_validation_start_date in date
617: ,p_validation_end_date in date

Line 641: ,p_associated_column1 => pay_evq_shd.g_tab_name

637: -- Validate Important Attributes
638: --
639: hr_api.validate_bus_grp_id
640: (p_business_group_id => p_rec.business_group_id
641: ,p_associated_column1 => pay_evq_shd.g_tab_name
642: || '.BUSINESS_GROUP_ID');
643: --
644: -- After validating the set of important attributes,
645: -- if Multiple Message Detection is enabled and at least

Line 676: (p_rec in pay_evq_shd.g_rec_type

672: -- ----------------------------------------------------------------------------
673: -- |---------------------------< delete_validate >----------------------------|
674: -- ----------------------------------------------------------------------------
675: Procedure delete_validate
676: (p_rec in pay_evq_shd.g_rec_type
677: ,p_effective_date in date
678: ,p_datetrack_mode in varchar2
679: ,p_validation_start_date in date
680: ,p_validation_end_date in date

Line 690: ,pay_evq_shd.g_old_rec.business_group_id

686: hr_utility.set_location('Entering:'||l_proc, 5);
687: --
688: --
689: chk_startup_action(false
690: ,pay_evq_shd.g_old_rec.business_group_id
691: ,pay_evq_shd.g_old_rec.legislation_code
692: );
693: IF hr_startup_data_api_support.g_startup_mode
694: NOT IN ('GENERIC','STARTUP') THEN

Line 691: ,pay_evq_shd.g_old_rec.legislation_code

687: --
688: --
689: chk_startup_action(false
690: ,pay_evq_shd.g_old_rec.business_group_id
691: ,pay_evq_shd.g_old_rec.legislation_code
692: );
693: IF hr_startup_data_api_support.g_startup_mode
694: NOT IN ('GENERIC','STARTUP') THEN
695: --