PACKAGE: APPS.PA_ROLE_JOB_BG_UTILS

Source

1 package pa_role_job_bg_utils AUTHID CURRENT_USER as
2 -- $Header: PAXRJBUS.pls 115.1 2003/08/25 19:01:36 ramurthy ship $
3 
4 --
5 --  PROCEDURE
6 --              check_dup_job_bg_defaults
7 --  PURPOSE
8 --              This procedure checks to see that the same Business Group
9 --              has not already had job defaults specified for a given role.
10 --  HISTORY
11 --     17-Jul-2003      Ranjana Murthy    - Created
12 --
13 PROCEDURE check_dup_job_bg_defaults(
14 			p_role_job_bg_id       IN  NUMBER
15                        ,p_project_role_id      IN  NUMBER
16                        ,p_business_group_id    IN  NUMBER
17                        ,p_return_status        OUT NOCOPY VARCHAR2
18                        ,p_error_message_code   OUT NOCOPY VARCHAR2);
19 
20 -- These functions are called from the view PA_PROJECT_ROLE_TYPES_VL
21 -- to get the job defaults based on the profile values for CBGA and
22 -- HR BG ID.
23 
24 FUNCTION get_job_id(p_project_role_id             IN  NUMBER) return NUMBER;
25 FUNCTION get_min_job_level(p_project_role_id      IN  NUMBER) return NUMBER;
26 FUNCTION get_max_job_level(p_project_role_id      IN  NUMBER) return NUMBER;
27 
28 end pa_role_job_bg_utils;