DBA Data[Home] [Help]

APPS.PER_PSH_BUS dependencies on PER_PSH_BUS

Line 1: Package Body per_psh_bus as

1: Package Body per_psh_bus as
2: /* $Header: pepshrhi.pkb 120.2 2006/05/08 19:35 tpapired noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' per_psh_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_psh_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 126: if ( nvl(per_psh_bus.g_sharing_instance_id, hr_api.g_number)

122: ,p_argument => 'sharing_instance_id'
123: ,p_argument_value => p_sharing_instance_id
124: );
125: --
126: if ( nvl(per_psh_bus.g_sharing_instance_id, hr_api.g_number)
127: = p_sharing_instance_id) then
128: --
129: -- The legislation code has already been found with a previous
130: -- call to this function. Just return the value in the global

Line 133: l_legislation_code := per_psh_bus.g_legislation_code;

129: -- The legislation code has already been found with a previous
130: -- call to this function. Just return the value in the global
131: -- variable.
132: --
133: l_legislation_code := per_psh_bus.g_legislation_code;
134: hr_utility.set_location(l_proc, 20);
135: else
136: --
137: -- The ID is different to the last call to this function

Line 157: per_psh_bus.g_sharing_instance_id := p_sharing_instance_id;

153: -- Set the global variables so the values are
154: -- available for the next call to this function.
155: --
156: close csr_leg_code;
157: per_psh_bus.g_sharing_instance_id := p_sharing_instance_id;
158: per_psh_bus.g_legislation_code := l_legislation_code;
159: end if;
160: hr_utility.set_location(' Leaving:'|| l_proc, 40);
161: return l_legislation_code;

Line 158: per_psh_bus.g_legislation_code := l_legislation_code;

154: -- available for the next call to this function.
155: --
156: close csr_leg_code;
157: per_psh_bus.g_sharing_instance_id := p_sharing_instance_id;
158: per_psh_bus.g_legislation_code := l_legislation_code;
159: end if;
160: hr_utility.set_location(' Leaving:'|| l_proc, 40);
161: return l_legislation_code;
162: end return_legislation_code;

Line 594: per_psh_bus.chk_person_id

590: --
591: --
592: -- check if person_id is valid
593: --
594: per_psh_bus.chk_person_id
595: (p_person_id => p_rec.person_id
596: );
597: --
598: -- check if scorecard_id is valid

Line 600: per_psh_bus.chk_scorecard_id

596: );
597: --
598: -- check if scorecard_id is valid
599: --
600: per_psh_bus.chk_scorecard_id
601: (p_scorecard_id => p_rec.scorecard_id
602: ,p_person_id => p_rec.person_id
603: );
604: --

Line 607: per_psh_bus.chk_scorecard_person_unique

603: );
604: --
605: -- check whetehr scorecard_id person_id combination already exists
606: --
607: per_psh_bus.chk_scorecard_person_unique
608: (p_scorecard_id => p_rec.scorecard_id
609: ,p_person_id => p_rec.person_id
610: );
611: --

Line 612: per_psh_bus.chk_df(p_rec);

608: (p_scorecard_id => p_rec.scorecard_id
609: ,p_person_id => p_rec.person_id
610: );
611: --
612: per_psh_bus.chk_df(p_rec);
613: --
614: hr_utility.set_location(' Leaving:'||l_proc, 10);
615: End insert_validate;
616: --

Line 642: per_psh_bus.chk_person_id

638: --
639: --
640: -- check if person_id is valid
641: --
642: per_psh_bus.chk_person_id
643: (p_person_id => p_rec.person_id
644: );
645: --
646: -- check if scorecard_id is valid

Line 648: per_psh_bus.chk_scorecard_id

644: );
645: --
646: -- check if scorecard_id is valid
647: --
648: per_psh_bus.chk_scorecard_id
649: (p_scorecard_id => p_rec.scorecard_id
650: ,p_person_id => p_rec.person_id
651: );
652: --

Line 653: per_psh_bus.chk_df(p_rec);

649: (p_scorecard_id => p_rec.scorecard_id
650: ,p_person_id => p_rec.person_id
651: );
652: --
653: per_psh_bus.chk_df(p_rec);
654: --
655: hr_utility.set_location(' Leaving:'||l_proc, 10);
656: End update_validate;
657: --

Line 675: end per_psh_bus;

671: --
672: hr_utility.set_location(' Leaving:'||l_proc, 10);
673: End delete_validate;
674: --
675: end per_psh_bus;