1 PACKAGE PSP_UPGRADE_EFF_REPORTS AUTHID CURRENT_USER AS
2 /*$Header: PSPERUPS.pls 120.0 2005/06/02 15:59:38 appldev noship $*/
3
4 TYPE t_num_15_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5 TYPE t_date is TABLE of DATE index by BINARY_INTEGER;
6 TYPE t_varchar2_30_type is TABLE of VARCHAR2(30) INDEX BY BINARY_INTEGER;
7 TYPE t_varchar2_240_type is TABLE of VARCHAR2(240) INDEX BY BINARY_INTEGER;
8
9 type eff_reports_master_type is record
10 (
11 effort_report_id t_num_15_type,
12 person_id t_num_15_type,
13 full_name t_varchar2_240_type,
14 approver_name t_varchar2_240_type,
15 start_date t_date,
16 end_date t_date,
17 da_batch t_varchar2_30_type,
18 business_group_name t_varchar2_240_type
19 );
20
21 eff_master_rec eff_reports_master_type;
22
23 type eff_element_type is record
24 (
25 element_type_id t_num_15_type
26 );
27
28 eff_element_rec eff_element_type;
29
30
31 PROCEDURE migrate_eff_Reports(
32 errBuf OUT NOCOPY VARCHAR2,
33 retCode OUT NOCOPY VARCHAR2,
34 p_diagnostic_mode IN VARCHAR2,
35 p_ignore_appr IN VARCHAR2,
36 p_ignore_da IN VARCHAR2,
37 p_element_set_name IN VARCHAR2
38 );
39
40 END psp_upgrade_eff_reports;