PACKAGE: APPS.PSP_UPGRADE_EFF_REPORTS

Source

1 PACKAGE PSP_UPGRADE_EFF_REPORTS 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;