PACKAGE: APPS.HRI_BPL_PERSON_TYPE

Source

1 PACKAGE HRI_BPL_PERSON_TYPE AUTHID CURRENT_USER AS
2 /* $Header: hribptu.pkh 120.1 2005/07/04 06:37:18 jtitmas noship $ */
3 --
4 -- Global Variables
5 --
6 g_warning_flag                      VARCHAR2(30);
7 --
8 FUNCTION get_emp_user_person_type
9   (p_effective_date              IN    DATE
10   ,p_person_id                   IN    NUMBER
11   )
12 RETURN VARCHAR2 ;
13 --
14 FUNCTION get_concat_user_person_type
15   (p_effective_date              IN    DATE
16   ,p_person_id                   IN    NUMBER
17   )
18 RETURN VARCHAR2 ;
19 --
20 FUNCTION get_apl_user_person_type
21   (p_effective_date              IN    DATE
22   ,p_person_id                   IN    NUMBER
23   )
24 RETURN VARCHAR2 ;
25 --
26 FUNCTION get_cwk_user_person_type
27   (p_effective_date              IN    DATE
28   ,p_person_id                   IN    NUMBER
29   )
30 RETURN VARCHAR2 ;
31 --
32 FUNCTION get_emp_system_type(p_effective_date       IN DATE,
33                              p_person_id            IN NUMBER)
34 RETURN VARCHAR2;
35 --
36 FUNCTION get_person_typ_ff_id
37 RETURN NUMBER;
38 --
39 FUNCTION get_wkth_lvl1_sk_fk
40   (p_person_type_id       IN NUMBER
41   ,p_system_person_type   IN VARCHAR2
42   ,p_user_person_type     IN VARCHAR2
43   ,p_business_group_id    IN NUMBER
44   ,p_primary_flag         IN VARCHAR2
45   ,p_employment_category  IN VARCHAR2
46   ,p_assignment_type      IN VARCHAR2)
47       RETURN VARCHAR2;
48 
49 FUNCTION get_wkth_lvl2_sk_fk
50   (p_person_type_id       IN NUMBER
51   ,p_system_person_type   IN VARCHAR2
52   ,p_user_person_type     IN VARCHAR2
53   ,p_business_group_id    IN NUMBER
54   ,p_primary_flag         IN VARCHAR2
55   ,p_employment_category  IN VARCHAR2
56   ,p_assignment_type      IN VARCHAR2)
57       RETURN VARCHAR2;
58 
59 FUNCTION get_wkth_lvl1_code
60   (p_person_type_id       IN NUMBER
61   ,p_system_person_type   IN VARCHAR2
62   ,p_user_person_type     IN VARCHAR2
63   ,p_business_group_id    IN NUMBER
64   ,p_primary_flag         IN VARCHAR2
65   ,p_employment_category  IN VARCHAR2
66   ,p_assignment_type      IN VARCHAR2)
67       RETURN VARCHAR2;
68 
69 FUNCTION get_wkth_lvl2_code
70   (p_person_type_id       IN NUMBER
71   ,p_system_person_type   IN VARCHAR2
72   ,p_user_person_type     IN VARCHAR2
73   ,p_business_group_id    IN NUMBER
74   ,p_primary_flag         IN VARCHAR2
75   ,p_employment_category  IN VARCHAR2
76   ,p_assignment_type      IN VARCHAR2)
77       RETURN VARCHAR2;
78 
79 FUNCTION get_wkth_wktyp_code
80   (p_prsntyp_sk_pk  IN NUMBER)
81        RETURN VARCHAR2;
82 
83 FUNCTION get_include_flag
84   (p_person_type_id       IN NUMBER
85   ,p_system_person_type   IN VARCHAR2
86   ,p_user_person_type     IN VARCHAR2
87   ,p_business_group_id    IN NUMBER
88   ,p_primary_flag         IN VARCHAR2
89   ,p_employment_category  IN VARCHAR2
90   ,p_assignment_type      IN VARCHAR2)
91       RETURN VARCHAR2;
92 
93 FUNCTION get_prsntyp_sk_fk
94   (p_person_type_id       IN NUMBER
95   ,p_employment_category  IN VARCHAR2
96   ,p_primary_flag         IN VARCHAR2
97   ,p_assignment_type      IN VARCHAR2)
98      RETURN NUMBER;
99 
100 END HRI_BPL_PERSON_TYPE;