1 PACKAGE HR_JP_GENERAL_PKG AUTHID CURRENT_USER AS
2 /* $Header: hrjpgen.pkh 115.5 2003/08/11 21:05:44 ytohya ship $ */
3 --------------------------------------------------------------
4 FUNCTION GET_SESSION_DATE
5 --------------------------------------------------------------
6 RETURN DATE;
7 -- pragma restrict_references(GET_SESSION_DATE,WNDS,WNPS);
8
9 --------------------------------------------------------------
10 FUNCTION DECODE_ORG(
11 --------------------------------------------------------------
12 P_ORGANIZATION_ID IN NUMBER)
13 RETURN VARCHAR2;
14 -- pragma restrict_references(DECODE_ORG,WNDS,WNPS);
15
16 --------------------------------------------------------------
17 FUNCTION DECODE_DISTRICT(
18 --------------------------------------------------------------
19 P_DISTRICT_CODE IN VARCHAR2)
20 RETURN VARCHAR2;
21 -- pragma restrict_references(DECODE_DISTRICT,WNDS,WNPS);
22
23 --------------------------------------------------------------
24 FUNCTION GET_ADDRESS(
25 --------------------------------------------------------------
26 P_PERSON_ID IN NUMBER,
27 P_ADDRESS_TYPE IN VARCHAR2,
28 P_EFFECTIVE_DATE IN DATE)
29 RETURN VARCHAR2;
30 -- pragma restrict_references(GET_ADDRESS,WNDS,WNPS);
31
32 --------------------------------------------------------------
33 FUNCTION GET_DISTRICT_CODE(
34 --------------------------------------------------------------
35 P_PERSON_ID IN NUMBER,
36 P_ADDRESS_TYPE IN VARCHAR2,
37 P_EFFECTIVE_DATE IN DATE)
38 RETURN VARCHAR2;
39 -- pragma restrict_references(GET_DISTRICT_CODE,WNDS,WNPS);
40
41 --------------------------------------------------------------
42 FUNCTION run_assact_exists(
43 --------------------------------------------------------------
44 p_assignment_id IN NUMBER,
45 p_element_set_name IN VARCHAR2,
46 p_validation_start_date IN DATE DEFAULT NULL,
47 p_validation_end_date IN DATE DEFAULT NULL,
48 p_effective_date IN DATE DEFAULT NULL) RETURN VARCHAR2;
49 -- pragma restrict_references(run_assact_exists,WNDS,WNPS);
50
51
52 --
53 -- ----------------------------------------------------------------------------
54 -- |-------------------------< get_org_short_name >----------------------------|
55 -- ----------------------------------------------------------------------------
56 -- {Start Of Comments}
57 --
58 -- Description:
59 -- This Function returns one of the org extra names defined as further
60 -- org information against the specified organization .
61 -- Which name column to be returnd is determined by the specified
62 -- column name.
63 --
64 -- NOTE:
65 -- This Function does not raise an error even when user sets parameters
66 -- to invalid values,but returns NULL.
67 --
68 --
69 --
70 -- In Parameters:
71 -- Name Reqd Type Description
72 -- p_organization_id Yes number ID of oraganization.
73 --
74 --
75 --
76 -- p_column_name No varchar2 Column name for org short
77 -- name.You must specify NAME1
78 -- ,NAME2,NAME3,NAME4 or NAME5.
79 -- The Default value is NAME1.
80 --
81 -- Post Success:
82 --
83 -- The Function sets the following out parameters:
84 --
85 -- Name Type Description
86 -- varchar2 The return value is the org
87 -- short name associated with
88 -- the column name and the
89 -- organization
90 --
91 --
92 -- Access Status:
93 -- Public.
94 --
95 -- {End Of Comments}
96 --
97 --------------------------------------------------------------
98 FUNCTION GET_ORG_SHORT_NAME(
99 --------------------------------------------------------------
100 p_organization_id IN NUMBER
101 ,p_column_name IN VARCHAR2 default 'NAME1')
102 RETURN VARCHAR2;
103 -- pragma restrict_references(GET_ORG_SHORT_NAME,WNDS,WNPS);
104 --
105 -- The following function is to avoid bug.2668811
106 --
107 --------------------------------------------------------------
108 function date_to_jp_char(
109 --------------------------------------------------------------
110 p_date in date,
111 p_format in varchar2) return varchar2 deterministic;
112 --
113 --------------------------------------------------------------
114 FUNCTION DECODE_VEHICLE(
115 --------------------------------------------------------------
116 P_VEHICLE_ALLOCATION_ID IN NUMBER,
117 P_EFFECTIVE_DATE IN DATE)
118 RETURN VARCHAR2;
119 --
120 END HR_JP_GENERAL_PKG;