[Home] [Help]
PACKAGE: APPS.PA_FORECAST_GLOB
Source
1 PACKAGE PA_FORECAST_GLOB as
2 --/* $Header: PARFGLBS.pls 120.0 2005/05/30 01:17:28 appldev noship $ */
3
4 TYPE WeekDatesRangeRecordFc IS RECORD (
5 week_start_date DATE,
6 week_end_date DATE);
7
8 TYPE WeekDatesRangeFcTabTyp IS TABLE OF WeekDatesRangeRecordFc
9 INDEX BY BINARY_INTEGER;
10
11 TYPE AsgnDtlRecord IS RECORD ( assignment_id NUMBER,
12 assignment_type VARCHAR2(30),
13 status_code VARCHAR2(30),
14 start_date DATE,
15 end_date DATE,
16 source_assignment_id NUMBER,
17 project_id NUMBER,
18 resource_id NUMBER,
19 work_type_id NUMBER,
20 expenditure_org_id NUMBER,
21 expenditure_organization_id NUMBER,
22 expenditure_type VARCHAR2(30),
23 expenditure_type_class VARCHAR2(30),
24 fcst_tp_amount_type VARCHAR2(30));
25
26 TYPE FIDayRecord IS RECORD ( forecast_item_id NUMBER,
27 item_date DATE,
28 item_quantity NUMBER,
29 status_code VARCHAR2(30),
30 project_org_id NUMBER,
31 expenditure_org_id NUMBER,
32 project_id NUMBER,
33 expenditure_organization_id NUMBER,
34 resource_id NUMBER,
35 work_type_id NUMBER,
36 person_billable_flag VARCHAR2(1),
37 provisional_flag VARCHAR2(1),
38 tp_amount_type VARCHAR2(30),
39 include_in_forecast VARCHAR2(1),
40 error_flag VARCHAR2(1),
41 action_flag VARCHAR2(3),
42 asgmt_sys_status_code VARCHAR2(30),
43 asgmt_confirmed_quantity NUMBER,
44 asgmt_provisional_quantity NUMBER,
45 capacity_quantity NUMBER,
46 overcommitment_quantity NUMBER,
47 availability_quantity NUMBER,
48 overcommitment_flag VARCHAR2(1),
49 availability_flag VARCHAR2(1),
50 OVERCOMMITMENT_QTY NUMBER,
51 OVERPROVISIONAL_QTY NUMBER,
52 OVER_PROV_CONF_QTY NUMBER,
53 CONFIRMED_QTY NUMBER,
54 PROVISIONAL_QTY NUMBER,
55 JOB_ID NUMBER);
56
57
58
59 TYPE FIDayTabTyp IS TABLE OF FIDayRecord INDEX BY BINARY_INTEGER;
60
61 TYPE FIHdrRecord IS RECORD (forecast_item_id NUMBER,
62 forecast_item_type VARCHAR2(30),
63 project_org_id NUMBER,
64 expenditure_org_id NUMBER,
65 expenditure_organization_id NUMBER,
66 project_organization_id NUMBER,
67 project_id NUMBER,
68 project_type_class VARCHAR2(30),
69 person_id NUMBER,
70 resource_id NUMBER,
71 borrowed_flag VARCHAR2(1),
72 assignment_id NUMBER,
73 item_date DATE,
74 item_uom VARCHAR2(30),
75 item_quantity NUMBER,
76 pvdr_period_set_name VARCHAR2(30),
77 pvdr_pa_period_name VARCHAR2(30),
78 pvdr_gl_period_name VARCHAR2(30),
79 rcvr_period_set_name VARCHAR2(30),
80 rcvr_pa_period_name VARCHAR2(30),
81 rcvr_gl_period_name VARCHAR2(30),
82 global_exp_period_end_date DATE,
83 expenditure_type VARCHAR2(30),
84 expenditure_type_class VARCHAR2(30),
85 cost_rejection_code VARCHAR2(30),
86 rev_rejection_code VARCHAR2(30),
87 tp_rejection_code VARCHAR2(30),
88 burden_rejection_code VARCHAR2(30),
89 other_rejection_code VARCHAR2(30),
90 delete_flag VARCHAR2(1),
91 error_flag VARCHAR2(1),
92 provisional_flag VARCHAR2(1),
93 asgmt_sys_status_code VARCHAR2(30),
94 capacity_quantity NUMBER,
95 overcommitment_quantity NUMBER,
96 availability_quantity NUMBER,
97 overcommitment_flag VARCHAR2(1),
98 availability_flag VARCHAR2(1),
99 creation_date DATE,
100 created_by NUMBER,
101 last_update_date DATE,
102 last_updated_by NUMBER,
103 last_update_login NUMBER,
104 request_id NUMBER,
105 program_application_id NUMBER,
106 program_id NUMBER,
107 program_update_date DATE,
108 OVERPROVISIONAL_QTY NUMBER,
109 OVER_PROV_CONF_QTY NUMBER,
110 CONFIRMED_QTY NUMBER,
111 PROVISIONAL_QTY NUMBER,
112 JOB_ID NUMBER,
113 TP_AMOUNT_TYPE VARCHAR2(30),
114 OVERCOMMITMENT_QTY NUMBER
115 );
116
117 TYPE FIHdrTabTyp IS TABLE OF FIHdrRecord INDEX BY BINARY_INTEGER;
118
119 TYPE FIDtlRecord IS RECORD (forecast_item_id NUMBER,
120 amount_type_id NUMBER,
121 line_num NUMBER,
122 resource_type_code VARCHAR2(30),
123 person_billable_flag VARCHAR2(1),
124 item_date DATE,
125 item_uom VARCHAR2(30),
126 item_quantity NUMBER,
127 expenditure_org_id NUMBER,
128 project_org_id NUMBER,
129 pvdr_acct_curr_code VARCHAR2(15),
130 pvdr_acct_amount NUMBER,
131 rcvr_acct_curr_code VARCHAR2(15),
132 rcvr_acct_amount NUMBER,
133 proj_currency_code VARCHAR2(15),
134 proj_amount NUMBER,
135 denom_currency_code VARCHAR2(15),
136 denom_amount NUMBER,
137 tp_amount_type VARCHAR2(30),
138 billable_flag VARCHAR2(1),
139 forecast_summarized_code VARCHAR2(30),
140 util_summarized_code VARCHAR2(30),
141 work_type_id NUMBER,
142 resource_util_category_id NUMBER,
143 org_util_category_id NUMBER,
144 resource_util_weighted NUMBER,
145 org_util_weighted NUMBER,
146 provisional_flag VARCHAR2(1),
147 reversed_flag VARCHAR2(1),
148 net_zero_flag VARCHAR2(1),
149 reduce_capacity_flag VARCHAR2(1),
150 line_num_reversed NUMBER,
151 CAPACITY_QUANTITY NUMBER,
152 OVERCOMMITMENT_QTY NUMBER,
153 OVERPROVISIONAL_QTY NUMBER,
154 OVER_PROV_CONF_QTY NUMBER,
155 CONFIRMED_QTY NUMBER,
156 PROVISIONAL_QTY NUMBER,
157 JOB_ID NUMBER,
158 PROJECT_ID NUMBER,
159 RESOURCE_ID NUMBER,
160 EXPENDITURE_ORGANIZATION_ID NUMBER,
161 PJI_SUMMARIZED_FLAG VARCHAR2(1)
162 );
163
164
165 TYPE FIDtlTabTyp IS TABLE OF FIDtlRecord INDEX BY BINARY_INTEGER;
166
167 TYPE VC1TabTyp IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
168 TYPE VC15TabTyp IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
169 /*Commented the below code for the bug 3864340
170 TYPE VCTabTyp IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;*/
171 /*Added the below for the bug 3864340*/
172 TYPE VCTabTyp IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
173 TYPE datetabtyp IS TABLE OF DATE INDEX BY BINARY_INTEGER;
174 TYPE PeriodNameTabTyp IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
175 TYPE NumberTabTyp IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
176 TYPE ScheduleRecord IS RECORD
177
178 (status_code VARCHAR2(30),
179 start_date DATE,
180 end_date DATE,
181 monday_hours NUMBER,
182 tuesday_hours NUMBER,
183 wednesday_hours NUMBER,
184 thursday_hours NUMBER,
185 friday_hours NUMBER,
186 saturday_hours NUMBER,
187 sunday_hours NUMBER,
188 forecast_txn_version_number NUMBER,
189 forecast_txn_generated_flag VARCHAR(1),
190 schedule_id NUMBER,
191 system_status_code VARCHAR2(30)) ;
192
193 TYPE ScheduleTabTyp IS TABLE OF ScheduleRecord INDEX BY BINARY_INTEGER;
194
195
196 END PA_FORECAST_GLOB;