PACKAGE: APPS.QPR_MAINTAIN_AW

Source

1 PACKAGE QPR_MAINTAIN_AW AS
2 /* $Header: QPRUMNTS.pls 120.1 2007/11/22 05:42:19 bhuchand noship $ */
3 /* Public Procedures */
4    TYPE num_type      IS TABLE OF Number         INDEX BY BINARY_INTEGER;
5    TYPE char240_type  IS TABLE OF Varchar2(240)  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 g_calendar_code varchar2(15);
12 g_instance number;
13 g_price_plan_id number;
14 g_run_number number;
15 g_start_date date;
16 g_end_date date;
17 g_base_uom varchar2(10);
18 g_currency_code varchar2(15);
19 g_ord_line varchar2(240);
20 g_item varchar2(240);
21 g_tp_site varchar2(240);
22 g_cus varchar2(240);
23 g_ou varchar2(240);
24 g_sr varchar2(240);
25 g_chn varchar2(240);
26 g_adj varchar2(240);
27 g_psg varchar2(240);
28 
29 procedure maintanance_process(
30                         errbuf              OUT NOCOPY VARCHAR2,
31                         retcode             OUT NOCOPY VARCHAR2,
32                         p_price_plan_id     NUMBER,
33 			p_from_date 	varchar2,
34 			p_to_date	varchar2,
35 			p_clean_temp varchar2 default 'Y',
36 			p_clean_meas varchar2 default 'N',
37 			p_clean_dim varchar2 default 'N',
38 			p_include_dim varchar2 default 'Y',
39 			p_run_number number default 0);
40 
41 function get_calendar_code return varchar2;
42 function get_instance return number;
43 function get_price_plan_id return number;
44 function get_run_number return number;
45 function get_day(p_time_pk varchar2, p_low_lvl_time varchar2) return date;
46 function get_start_date return date;
47 function get_end_date return date;
48 function get_base_uom return varchar2;
49 function get_currency_code return varchar2;
50 FUNCTION get_ORD_LINE return varchar2 ;
51 FUNCTION get_ITEM return varchar2 ;
52 FUNCTION get_TP_SITE return varchar2 ;
53 FUNCTION get_CUS return varchar2 ;
54 FUNCTION get_OU return varchar2 ;
55 FUNCTION get_SR return varchar2 ;
56 FUNCTION get_CHN return varchar2 ;
57 FUNCTION get_ADJ return varchar2 ;
58 FUNCTION get_PSG return varchar2 ;
59 --
60 
61 END QPR_MAINTAIN_AW ;