[Home] [Help]
PACKAGE: APPS.PSP_CREATE_EFF_REPORTS
Source
1 PACKAGE PSP_CREATE_EFF_REPORTS
2 /* $Header: PSPERCRS.pls 120.4 2006/01/19 07:34 tbalacha noship $*/
3
4
5 AUTHID CURRENT_USER AS
6
7
8 PROCEDURE effort_asg_action_code (p_pactid IN NUMBER,
9 stperson IN NUMBER,
10 endperson IN NUMBER,
11 p_chunk_num IN NUMBER);
12
13 PROCEDURE PSPREP_INIT(p_payroll_action_id IN NUMBER);
14
15 PROCEDURE EFFORT_ARCHIVE(payroll_action_id IN NUMBER,
16 chunk_number IN NUMBER);
17
18
19 PROCEDURE CREATE_EFFORT_REPORTS(errBuf OUT NOCOPY VARCHAR2,
20 retCode OUT NOCOPY VARCHAR2,
21 p_pactid IN NUMBER,
22 p_request_id IN NUMBER,
23 p_chunk_num IN NUMBER
24 );
25
26 Procedure populate_eff_tables(errBuf OUT NOCOPY VARCHAR2,
27 retCode OUT NOCOPY VARCHAR2,
28 p_pactid IN NUMBER,
29 p_request_id IN NUMBER,
30 p_chunk_num IN NUMBER,
31 p_supercede_mode IN VARCHAR2 default null -- added for supercede
32 );
33
34 PROCEDURE populate_error_table(p_request_id IN NUMBER, p_start_person IN NUMBER, p_end_person IN NUMBER, p_min_effort_report_id IN NUMBER, p_retry_request_id IN NUMBER, p_mode in varchar2, p_match_level in varchar2);
35
36 g_lookup_code varchar2(30);
37
38
39
40 type effort_sum_criteria_type is record
41 (
42 array_sum_criteria t_varchar_30_type := t_varchar_30_type(NULL),
43 array_sum_order t_num_15_type := t_num_15_type(NULL),
44 array_criteria_value1 t_varchar_30_type := t_varchar_30_type(NULL),
45 array_criteria_value2 t_varchar_30_type := t_varchar_30_type(NULL)
46
47 );
48
49 eff_template_sum_rec effort_sum_criteria_type;
50
51
52 type person_rec_type is record
53 (
54 person_id t_num_15_type := t_num_15_type(NULL)
55
56 );
57
58 person_array person_rec_type;
59
60
61 g_exec_string varchar2(8000);
62 g_psp_request_id number;
63 g_psp_template_id number;
64 g_psp_effort_start date;
65 g_psp_effort_end date;
66
67
68
69 type person_eff_rec_type is record
70 (
71 array_person_id t_num_15_type := t_num_15_type(NULL) ,
72 array_effort_report_id t_num_15_type := t_num_15_type(NULL) ,
73 sum_tot t_num_15_2_type := t_num_15_2_type(NULL) ,
74 payroll_percent_tot t_num_15_2_type := t_num_15_2_type(NULL) ,
75 array_assignment_id t_num_15_type := t_num_15_type(NULL)
76 );
77
78 person_rec person_eff_rec_type;
79 type details_array_rec_type is record
80
81 (
82
83 effort_report_detail_id t_num_15_type := t_num_15_type(NULL) ,
84 effort_report_id t_num_15_type := t_num_15_type(NULL)
85 );
86
87 details_array details_array_rec_type;
88
89 det_effort_report_id t_num_15_type := t_num_15_type(NULL) ;
90 det_effort_report_detail_id t_num_15_type := t_num_15_type(NULL);
91 det_person_id t_num_15_type := t_num_15_type(NULL) ;
92 det_segment1 t_varchar_25_type := t_varchar_25_type(NULL) ;
93 det_segment2 t_varchar_25_type := t_varchar_25_type(NULL) ;
94 det_segment3 t_varchar_25_type := t_varchar_25_type(NULL) ;
95 det_segment4 t_varchar_25_type := t_varchar_25_type(NULL) ;
96 det_segment5 t_varchar_25_type := t_varchar_25_type(NULL) ;
97 det_segment6 t_varchar_25_type := t_varchar_25_type(NULL) ;
98 det_segment7 t_varchar_25_type := t_varchar_25_type(NULL) ;
99 det_segment8 t_varchar_25_type := t_varchar_25_type(NULL) ;
100 det_segment9 t_varchar_25_type := t_varchar_25_type(NULL) ;
101 det_segment10 t_varchar_25_type := t_varchar_25_type(NULL) ;
102 det_segment11 t_varchar_25_type := t_varchar_25_type(NULL) ;
103 det_segment12 t_varchar_25_type := t_varchar_25_type(NULL) ;
104 det_segment13 t_varchar_25_type := t_varchar_25_type(NULL) ;
105 det_segment14 t_varchar_25_type := t_varchar_25_type(NULL) ;
106 det_segment15 t_varchar_25_type := t_varchar_25_type(NULL) ;
107 det_segment16 t_varchar_25_type := t_varchar_25_type(NULL) ;
108 det_segment17 t_varchar_25_type := t_varchar_25_type(NULL) ;
109 det_segment18 t_varchar_25_type := t_varchar_25_type(NULL) ;
110 det_segment19 t_varchar_25_type := t_varchar_25_type(NULL) ;
111 det_segment20 t_varchar_25_type := t_varchar_25_type(NULL) ;
112 det_segment21 t_varchar_25_type := t_varchar_25_type(NULL) ;
113 det_segment22 t_varchar_25_type := t_varchar_25_type(NULL) ;
114 det_segment23 t_varchar_25_type := t_varchar_25_type(NULL) ;
115 det_segment24 t_varchar_25_type := t_varchar_25_type(NULL) ;
116 det_segment25 t_varchar_25_type := t_varchar_25_type(NULL) ;
117 det_segment26 t_varchar_25_type := t_varchar_25_type(NULL) ;
118 det_segment27 t_varchar_25_type := t_varchar_25_type(NULL) ;
119 det_segment28 t_varchar_25_type := t_varchar_25_type(NULL) ;
120 det_segment29 t_varchar_25_type := t_varchar_25_type(NULL) ;
121 det_segment30 t_varchar_25_type := t_varchar_25_type(NULL) ;
122 det_assignment_id t_num_15_type := t_num_15_type(NULL);
123 det_project_id t_num_15_type := t_num_15_type(NULL) ;
124 det_exp_org_id t_num_15_type := t_num_15_type(NULL) ;
125 det_expenditure_type t_varchar_30_type := t_varchar_30_type(NULL);
126 det_task_id t_num_15_type := t_num_15_type(NULL) ;
127 det_award_id t_num_15_type := t_num_15_type(NULL) ;
128 det_distribution_amount t_num_15_2_type := t_num_15_2_type(NULL);
129 det_sum_amount t_number_type := t_number_type(NULL) ;
130 det_dr_cr_flag t_varchar_1_type := t_varchar_1_type(NULL);
131 det_schedule_start_date t_date_type := t_date_type(NULL) ;
132 det_schedule_end_date t_date_type := t_date_type(NULL);
133
134
135 type eff_det_lines_type is record
136 (
137 effort_report_detail_id t_num_15_type := t_num_15_type(NULL) ,
138 person_id t_num_15_type := t_num_15_type(NULL)
139 );
140
141 -- for supercede
142 g_summarization_criteria varchar2(2000);
143
144 PROCEDURE VALIDATE_PTAOE(p_start_person IN NUMBER,
145 p_end_person IN NUMBER,
146 p_request_id IN NUMBER,
147 p_retry_request_id IN NUMBER,
148 p_return_status OUT NOCOPY VARCHAR2);
149
150 END;