PACKAGE: APPS.HXC_SUPERVISOR_DASHBOARD

Source

1 PACKAGE HXC_SUPERVISOR_DASHBOARD AUTHID CURRENT_USER AS
2 /* $Header: hxcsupdash.pkh 120.0.12020000.5 2013/03/13 06:57:21 pravesk noship $ */
3 
4 
5   TYPE person_details IS RECORD (
6     person_id NUMBER,
7     payroll_id VARCHAR2(240),
8     location_id VARCHAR2(240),
9     supervisor_id VARCHAR2(240),
10     organization_id VARCHAR2(240),
11     start_date DATE,
12     end_date DATE,
13     recurring_period_id NUMBER,
14     application_set_id NUMBER,
15 assignment_start_date date,
16 assignment_end_date date );
17 
18   TYPE timecard_exist IS RECORD (
19     resource_id NUMBER,
20     timecard_id NUMBER,
21     timecard_ovn NUMBER,
22     start_time DATE,
23     stop_time DATE,
24     first_st_time DATE,
25     first_end_time DATE,
26     next_st_time DATE,
27     next_end_time DATE,
28     approval_status VARCHAR2(50),
29     recurring_period_id NUMBER,
30     person_number NUMBER,
31     full_name VARCHAR2(240),
32     payroll_name VARCHAR2(240),
33     organization_name VARCHAR2(240),
34     location_name VARCHAR2(240),
35     supervisor_id NUMBER,
36     supervisor_name VARCHAR2(240),
37     application VARCHAR2(240),
38 		period_exist VARCHAR2(1),
39 		per_start_time DATE,
40 		per_stop_time DATE );
41 
42   TYPE timecard_not_exist IS RECORD (
43     resource_id NUMBER,
44     start_time DATE,
45     stop_time DATE,
46     /*timecard_id number,
47     timecard_ovn number,*/
48     approval_status VARCHAR2(50),
49     recurring_period_id NUMBER,
50     person_number NUMBER,
51     full_name VARCHAR2(240),
52     payroll_name VARCHAR2(240),
53     organization_name VARCHAR2(240),
54     location_name VARCHAR2(240),
55     supervisor_id NUMBER,
56     supervisor_name VARCHAR2(240),
57     person_types VARCHAR2(240),
58     application VARCHAR2(240),
59     meaning VARCHAR2(50),
60 		period_exist VARCHAR2(2),
61 assg_start_date DATE,
62 			  assg_end_date DATE,
63 				period_start_date DATE,
64 			  period_end_date DATE);
65 
66   TYPE recurring_details IS RECORD
67   (
68     	recurring_period_id NUMBER,
69 	period_type VARCHAR2(30),
70 	start_day DATE,
71 	day_count NUMBER,
72 	duration_in_days NUMBER
73   );
74   TYPE t_recurring_det
75       IS TABLE OF recurring_details  INDEX BY BINARY_INTEGER;
76   g_recurring_det t_recurring_det;
77 
78 	TYPE rec_period_type IS RECORD
79 	(
80 		RECURRING_PERIOD_ID NUMBER,
81 		PERIOD_TYPE VARCHAR2(30),
82 		NUMBER_PER_FISCAL_YEAR NUMBER(15,0)
83 	);
84 
85 	TYPE t_rec_period_type
86 		IS TABLE OF rec_period_type INDEX BY BINARY_INTEGER;
87 
88 	g_rec_period_type t_rec_period_type;
89 
90   TYPE persondet
91     IS TABLE OF PERSON_DETAILS;
92   TYPE timecards
93     IS TABLE OF TIMECARD_EXIST;
94   TYPE timecardsnotexist
95     IS TABLE OF TIMECARD_NOT_EXIST;
96   TYPE varchartab
97     IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
98   TYPE numbertab
99     IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
100   TYPE datetab
101     IS TABLE OF DATE INDEX BY BINARY_INTEGER;
102 
103   PROCEDURE GO(
104     p_recurring_period IN VARCHAR2 DEFAULT NULL,
105     p_supervisor_id    IN NUMBER,
106     p_reptng_emp       IN VARCHAR2,
107     p_location_id      IN NUMBER,
108     p_organization_id  IN NUMBER,
109     p_start_date       IN DATE,
110     p_end_date         IN DATE,
111     p_msg              OUT nocopy VARCHAR2,
112     p_level            OUT nocopy VARCHAR2 );
113 
114   PROCEDURE generate_supervisor_xml(
115     p_start_time       IN VARCHAR2 DEFAULT NULL,
116     p_stop_time        IN VARCHAR2 DEFAULT NULL,
117     p_supervisor_id    IN VARCHAR2 DEFAULT NULL,
118     p_reporting_emp    IN VARCHAR2 DEFAULT NULL,
119     p_recurring_period IN VARCHAR2 DEFAULT NULL,
120     p_timecard_status  IN VARCHAR2 DEFAULT NULL,
121     p_location         IN VARCHAR2 DEFAULT NULL,
122     p_organization     IN VARCHAR2 DEFAULT NULL,
123     p_column_name      IN VARCHAR2 DEFAULT NULL,
124     p_supervisor_param IN VARCHAR2,
125     p_pre_xml          OUT nocopy CLOB );
126 
127 
128 END hxc_supervisor_dashboard;