1 PACKAGE PJI_RESOURCE_UTILZ AUTHID CURRENT_USER AS
2 /* $Header: PJIPR01S.pls 120.2 2005/12/13 03:58:16 pschandr noship $ */
3
4 TYPE V_TYPE_TAB IS TABLE OF VARCHAR2(50)
5 INDEX BY BINARY_INTEGER;
6
7 TYPE N_TYPE_TAB IS TABLE OF NUMBER(15)
8 INDEX BY BINARY_INTEGER;
9
10 PROCEDURE GET_PERIOD_DATA
11 (
12 p_calendar_type IN VARCHAR2
13 ,p_org_id IN NUMBER
14 ,x_calendar_id OUT NOCOPY /* file.sql.39 change */ NUMBER
15 ,x_accnt_period_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 ,x_sets_of_books_id OUT NOCOPY /* file.sql.39 change */ NUMBER
17 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
19 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 );
21
22 PROCEDURE PJI_POP_SIMPLE_UTILZ_DATA
23 (
24 p_calendar_id IN NUMBER
25 ,p_calendar_type IN VARCHAR2
26 ,p_population_mode IN VARCHAR2
27 ,p_table_amount_type IN NUMBER DEFAULT NULL
28 ,x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER
29 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
30 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 );
32
33 PROCEDURE PJI_POP_COMPLEX_UTILZ_DATA
34 (
35 p_calendar_id IN NUMBER
36 ,p_calendar_type IN VARCHAR2
37 ,p_population_mode IN VARCHAR2
38 ,p_org_id IN NUMBER
39 ,x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER
40 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
41 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 );
43
44 PROCEDURE PJI_POP_GRAPH_UTILZ_DATA
45 (
46 p_person_id IN NUMBER
47 ,p_period_id IN NUMBER
48 ,p_period_type IN NUMBER
49 ,p_calendar_type IN VARCHAR2
50 ,p_org_id IN NUMBER
51 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
53 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54
55 );
56
57 PROCEDURE PJI_POP_TABLE_UTILZ_DATA
58 (
59 p_person_id IN NUMBER
60 ,p_period_id IN NUMBER
61 ,p_period_type IN NUMBER
62 ,p_calendar_type IN VARCHAR2
63 ,p_org_id IN NUMBER
64 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
66 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67 );
68
69 PROCEDURE PJI_POPULATE_PERIODS
70 (
71 p_period_type_id IN NUMBER
72 ,p_calendar_type IN VARCHAR2
73 ,p_period_id IN NUMBER
74 ,p_org_id IN NUMBER
75 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
77 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 );
79
80 PROCEDURE PJI_GET_PERIOD_PROFILE_DATA
81 (
82 p_org_id IN NUMBER
83 ,x_period_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
84 ,x_calendar_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 ,x_person_id OUT NOCOPY /* file.sql.39 change */ NUMBER
86 ,x_period_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 ,x_curr_period_id OUT NOCOPY /* file.sql.39 change */ NUMBER
88 ,x_curr_period_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
91 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 );
93
94 PROCEDURE PJI_POP_UTILIZATION_DATA
95 (
96 p_person_id IN NUMBER
97 ,p_period_id IN NUMBER
98 ,p_period_type IN NUMBER
99 ,p_calendar_type IN VARCHAR2
100 ,p_org_id IN NUMBER
101 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
103 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 );
105
106 PROCEDURE GET_PERSON_FROM_RES
107 (
108 p_resource_id IN NUMBER
109 ,x_person_id OUT NOCOPY /* file.sql.39 change */ NUMBER
110 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
112 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 );
114
115 END PJI_RESOURCE_UTILZ;