DBA Data[Home] [Help]

APPS.HR_FIM_BUS dependencies on HR_FIM_SHD

Line 91: ,p_rec in hr_fim_shd.g_rec_type

87: -- {End Of Comments}
88: -- ----------------------------------------------------------------------------
89: Procedure chk_non_updateable_args
90: (p_effective_date in date
91: ,p_rec in hr_fim_shd.g_rec_type
92: ) IS
93: --
94: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
95: l_error EXCEPTION;

Line 103: IF NOT hr_fim_shd.api_updating

99: --
100: -- Only proceed with the validation if a row exists for the current
101: -- record in the HR Schema.
102: --
103: IF NOT hr_fim_shd.api_updating
104: (p_form_item_id => p_rec.form_item_id
105: ,p_object_version_number => p_rec.object_version_number
106: ) THEN
107: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 114: nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number)

110: fnd_message.raise_error;
111: END IF;
112: --
113: IF (nvl(p_rec.application_id,hr_api.g_number) <>
114: nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number)
115: ) THEN
116: l_argument := 'application_id';
117: RAISE l_error;
118: END IF;

Line 121: nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number)

117: RAISE l_error;
118: END IF;
119: --
120: IF (nvl(p_rec.form_id,hr_api.g_number) <>
121: nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number)
122: ) THEN
123: l_argument := 'form_id';
124: RAISE l_error;
125: END IF;

Line 128: nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number)

124: RAISE l_error;
125: END IF;
126: --
127: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>
128: nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number)
129: ) THEN
130: l_argument := 'form_canvas_id';
131: RAISE l_error;
132: END IF;

Line 135: nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number)

131: RAISE l_error;
132: END IF;
133: --
134: IF (nvl(p_rec.form_tab_page_id,hr_api.g_number) <>
135: nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number)
136: ) THEN
137: l_argument := 'form_tab_page_id';
138: RAISE l_error;
139: END IF;

Line 142: nvl(hr_fim_shd.g_old_rec.item_type,hr_api.g_varchar2)

138: RAISE l_error;
139: END IF;
140: --
141: IF (nvl(p_rec.item_type,hr_api.g_varchar2) <>
142: nvl(hr_fim_shd.g_old_rec.item_type,hr_api.g_varchar2)
143: ) THEN
144: l_argument := 'item_type';
145: RAISE l_error;
146: END IF;

Line 271: l_api_updating := hr_fim_shd.api_updating

267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 10);
270: --
271: l_api_updating := hr_fim_shd.api_updating
272: (p_form_item_id => p_form_item_id
273: ,p_object_version_number => p_object_version_number
274: );
275: hr_utility.set_location(l_proc,20);

Line 280: and nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

276: --
277: -- Only proceed with SQL validation if absolutely necessary
278: --
279: if ( ( l_api_updating
280: and nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
281: nvl(p_form_canvas_id,hr_api.g_number))
282: or (NOT l_api_updating)) then
283: --
284: hr_utility.set_location(l_proc,30);

Line 443: l_api_updating := hr_fim_shd.api_updating

439: ,p_argument => 'effective_date'
440: ,p_argument_value => p_effective_date
441: );
442: --
443: l_api_updating := hr_fim_shd.api_updating
444: (p_form_item_id => p_form_item_id
445: ,p_object_version_number => p_object_version_number
446: );
447: hr_utility.set_location(l_proc,20);

Line 452: and nvl(hr_fim_shd.g_old_rec.item_type,hr_api.g_varchar2) <>

448: --
449: -- Only proceed with SQL validation if absolutely necessary
450: --
451: if ( ( l_api_updating
452: and nvl(hr_fim_shd.g_old_rec.item_type,hr_api.g_varchar2) <>
453: nvl(p_item_type,hr_api.g_varchar2))
454: or (NOT l_api_updating)) then
455: --
456: hr_utility.set_location(l_proc,30);

Line 574: l_api_updating := hr_fim_shd.api_updating

570: ,p_argument => 'effective_date'
571: ,p_argument_value => p_effective_date
572: );
573: --
574: l_api_updating := hr_fim_shd.api_updating
575: (p_form_item_id => p_form_item_id
576: ,p_object_version_number => p_object_version_number
577: );
578: hr_utility.set_location(l_proc,20);

Line 583: and nvl(hr_fim_shd.g_old_rec.required_override,hr_api.g_number) <>

579: --
580: -- Only proceed with SQL validation if absolutely necessary
581: --
582: if ( ( l_api_updating
583: and nvl(hr_fim_shd.g_old_rec.required_override,hr_api.g_number) <>
584: nvl(p_required_override,hr_api.g_number))
585: or (NOT l_api_updating)) then
586: --
587: hr_utility.set_location(l_proc,30);

Line 638: l_api_updating := hr_fim_shd.api_updating

634: ,p_argument => 'effective_date'
635: ,p_argument_value => p_effective_date
636: );
637: --
638: l_api_updating := hr_fim_shd.api_updating
639: (p_form_item_id => p_form_item_id
640: ,p_object_version_number => p_object_version_number
641: );
642: hr_utility.set_location(l_proc,20);

Line 647: and nvl(hr_fim_shd.g_old_rec.visible_override,hr_api.g_number) <>

643: --
644: -- Only proceed with SQL validation if absolutely necessary
645: --
646: if ( ( l_api_updating
647: and nvl(hr_fim_shd.g_old_rec.visible_override,hr_api.g_number) <>
648: nvl(p_visible_override,hr_api.g_number))
649: or (NOT l_api_updating)) then
650: --
651: hr_utility.set_location(l_proc,30);

Line 706: l_api_updating := hr_fim_shd.api_updating

702: --
703: Begin
704: hr_utility.set_location('Entering:'||l_proc, 10);
705: --
706: l_api_updating := hr_fim_shd.api_updating
707: (p_form_item_id => p_form_item_id
708: ,p_object_version_number => p_object_version_number
709: );
710: hr_utility.set_location(l_proc,20);

Line 715: and ( (nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number) <>

711: --
712: -- Only proceed with SQL validation if absolutely necessary
713: --
714: if ( ( l_api_updating
715: and ( (nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number) <>
716: nvl(p_application_id,hr_api.g_number))
717: or (nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number) <>
718: nvl(p_form_id,hr_api.g_number))
719: or (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

Line 717: or (nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number) <>

713: --
714: if ( ( l_api_updating
715: and ( (nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number) <>
716: nvl(p_application_id,hr_api.g_number))
717: or (nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number) <>
718: nvl(p_form_id,hr_api.g_number))
719: or (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
720: nvl(p_form_canvas_id,hr_api.g_number))))
721: or (NOT l_api_updating)) then

Line 719: or (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

715: and ( (nvl(hr_fim_shd.g_old_rec.application_id,hr_api.g_number) <>
716: nvl(p_application_id,hr_api.g_number))
717: or (nvl(hr_fim_shd.g_old_rec.form_id,hr_api.g_number) <>
718: nvl(p_form_id,hr_api.g_number))
719: or (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
720: nvl(p_form_canvas_id,hr_api.g_number))))
721: or (NOT l_api_updating)) then
722: --
723: hr_utility.set_location(l_proc,30);

Line 784: l_api_updating := hr_fim_shd.api_updating

780: --
781: Begin
782: hr_utility.set_location('Entering:'||l_proc, 10);
783: --
784: l_api_updating := hr_fim_shd.api_updating
785: (p_form_item_id => p_form_item_id
786: ,p_object_version_number => p_object_version_number
787: );
788: hr_utility.set_location(l_proc,20);

Line 793: and ( (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

789: --
790: -- Only proceed with SQL validation if absolutely necessary
791: --
792: if ( ( l_api_updating
793: and ( (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
794: nvl(p_form_canvas_id,hr_api.g_number))
795: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
796: nvl(p_form_tab_page_id,hr_api.g_number))
797: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id_override,hr_api.g_number) <>

Line 795: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>

791: --
792: if ( ( l_api_updating
793: and ( (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
794: nvl(p_form_canvas_id,hr_api.g_number))
795: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
796: nvl(p_form_tab_page_id,hr_api.g_number))
797: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id_override,hr_api.g_number) <>
798: nvl(p_form_tab_page_id_override,hr_api.g_number))))
799: or (NOT l_api_updating)) then

Line 797: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id_override,hr_api.g_number) <>

793: and ( (nvl(hr_fim_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
794: nvl(p_form_canvas_id,hr_api.g_number))
795: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
796: nvl(p_form_tab_page_id,hr_api.g_number))
797: or (nvl(hr_fim_shd.g_old_rec.form_tab_page_id_override,hr_api.g_number) <>
798: nvl(p_form_tab_page_id_override,hr_api.g_number))))
799: or (NOT l_api_updating)) then
800: --
801: hr_utility.set_location(l_proc,30);

Line 892: (p_rec in hr_fim_shd.g_rec_type

888: -- ----------------------------------------------------------------------------
889: -- |------------------------------< chk_delete >------------------------------|
890: -- ----------------------------------------------------------------------------
891: Procedure chk_delete
892: (p_rec in hr_fim_shd.g_rec_type
893: ) is
894: --
895: l_proc varchar2(72) := g_package||'chk_delete';
896: --

Line 912: ,p_rec in hr_fim_shd.g_rec_type

908: -- |---------------------------< insert_validate >----------------------------|
909: -- ----------------------------------------------------------------------------
910: Procedure insert_validate
911: (p_effective_date in date
912: ,p_rec in hr_fim_shd.g_rec_type
913: ) is
914: --
915: l_proc varchar2(72) := g_package||'insert_validate';
916: --

Line 1022: ,p_rec in hr_fim_shd.g_rec_type

1018: -- |---------------------------< update_validate >----------------------------|
1019: -- ----------------------------------------------------------------------------
1020: Procedure update_validate
1021: (p_effective_date in date
1022: ,p_rec in hr_fim_shd.g_rec_type
1023: ) is
1024: --
1025: l_proc varchar2(72) := g_package||'update_validate';
1026: --

Line 1136: (p_rec in hr_fim_shd.g_rec_type

1132: -- ----------------------------------------------------------------------------
1133: -- |---------------------------< delete_validate >----------------------------|
1134: -- ----------------------------------------------------------------------------
1135: Procedure delete_validate
1136: (p_rec in hr_fim_shd.g_rec_type
1137: ) is
1138: --
1139: l_proc varchar2(72) := g_package||'delete_validate';
1140: --