PACKAGE: APPS.QPR_SPECIAL_ETL

Source

1 PACKAGE QPR_SPECIAL_ETL AUTHID CURRENT_USER AS
2 /* $Header: QPRUSPLS.pls 120.2 2007/12/13 05:37:23 bhuchand noship $ */
3    TYPE num_type      IS TABLE OF Number         INDEX BY BINARY_INTEGER;
4    TYPE char240_type  IS TABLE OF Varchar2(240)  INDEX BY BINARY_INTEGER;
5    TYPE char1000_type  IS TABLE OF Varchar2(1000)  INDEX BY BINARY_INTEGER;
6    TYPE real_type     IS TABLE OF Number(32,10)  INDEX BY BINARY_INTEGER;
7    TYPE date_type     IS TABLE OF Date           INDEX BY BINARY_INTEGER;
8 
9    TYPE QPRREFCUR IS REF CURSOR;
10 
11 TYPE OFFADJ_REC_TYPE IS RECORD
12 (
13 LEVEL1_VALUE                         char240_type,
14 LEVEL2_VALUE                         char240_type,
15 LEVEL3_VALUE                         char240_type,
16 LEVEL4_VALUE                         char240_type,
17 LEVEL5_VALUE                         char240_type,
18 LEVEL6_VALUE                         char240_type,
19 LEVEL7_VALUE                         char240_type,
20 LEVEL8_VALUE                         char240_type,
21 LEVEL9_VALUE                         char240_type,
22 LEVEL10_VALUE                         char240_type,
23 DATE_VALUE                            date_type,
24 MEASURE1_VALUE				num_type,
25 MEASURE2_VALUE				num_type,
26 MEASURE3_VALUE				num_type,
27 MEASURE4_VALUE				num_type,
28 MEASURE5_VALUE				num_type,
29 MEASURE6_VALUE				num_type,
30 MEASURE7_VALUE				num_type,
31 MEASURE8_VALUE				num_type,
32 MEASURE9_VALUE				num_type,
33 MEASURE10_VALUE				num_type
34 );
35 
36 TYPE COST_REC_TYPE IS RECORD
37 (
38 ORD_LEVEL_VALUE                 char240_type,
39 BOOKED_DATE                     date_type,
40 COS_LEVEL_VALUE                 char240_type,
41 COST_VALUE	    	        num_type,
42 UNIT_LIST_PRICE                   num_type,
43 TOP_MODEL_LINE_ID               num_type,
44 LINK_TO_LINE_ID                 num_type,
45 ITEM_TYPE_CODE                  char240_type,
46 INVENTORY_ITEM_ID               num_type,
47 COMPONENT_CODE                  char1000_type,
48 ATO_LINE_ID                     num_type,
49 ORD_QUANTITY                    num_type,
50 MEASURE_VAL_ID			num_type
51 );
52 /* Public Procedures */
53 procedure collect_offadj(
54                         errbuf              OUT NOCOPY VARCHAR2,
55                         retcode             OUT NOCOPY VARCHAR2,
56 			p_TRX_TYP_NAME        VARCHAR2,
57 --			P_TRX_TYPE 	    VARCHAR2,
58 			P_h_reason_code 	    VARCHAR2,
59 			P_l_reason_code 	    VARCHAR2,
60 			p_from_trx_date	 VARCHAR2,
61 			p_to_trx_date VARCHAR2,
62 			p_from_date VARCHAR2,
63 			p_to_date VARCHAR2,
64 			p_instance_id number );
65 
66 --Transaction Type (Class)
67 --Reason Code
68 --Transaction Date from and to
69 --Order (booking) date from and to
70 
71 
72 procedure collect_cost(
73                         errbuf              OUT NOCOPY VARCHAR2,
74                         retcode             OUT NOCOPY VARCHAR2,
75 			p_from_date	    varchar2,
76 			p_to_date	    varchar2,
77 			p_instance_id number );
78 
79 procedure allocate_offinvoice_adj(
80                         errbuf              OUT NOCOPY VARCHAR2,
81                         retcode             OUT NOCOPY VARCHAR2,
82 			p_from_date	    date,
83 			p_to_date	    date,
84 			p_instance_id number );
85 
86 procedure consolidate_upd_sales_meas(
87                         errbuf              OUT NOCOPY VARCHAR2,
88                         retcode             OUT NOCOPY VARCHAR2,
89 			p_instance_id in number,
90 			p_from_date in varchar2,
91 			p_to_date in varchar2);
92 
93 procedure update_pr_segment(
94                         errbuf              OUT NOCOPY VARCHAR2,
95                         retcode             OUT NOCOPY VARCHAR2,
96 			p_instance_id in number,
97 			p_from_date in varchar2,
98 			p_to_date in varchar2);
99 END QPR_SPECIAL_ETL;