PACKAGE: APPS.OKS_ENT_UTIL_PVT

Source

1 PACKAGE OKS_ENT_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSREUTS.pls 120.0 2005/05/25 17:45:45 appldev noship $ */
3 
4   FUNCTION get_duration_period(
5 		 p_start_date IN Date
6 		,p_end_date IN Date
7 		,inp_type Varchar2) RETURN Varchar2;
8 
9   FUNCTION get_contract_amount(p_hdr_id IN Number) RETURN Number;
10 
11   FUNCTION get_party(p_hdr_id IN Number) RETURN Varchar2;
12 
13   FUNCTION get_billtoshipto(p_hdr_id	IN Number --DEFAULT NULL
14 				   ,p_line_id	IN Number --DEFAULT NULL
15 				   ,p_inp_type	IN Varchar2) RETURN Varchar2;
16 
17   FUNCTION get_pricelist(p_hdr_id	IN Number --DEFAULT NULL
18 				,p_line_id	IN Number --DEFAULT NULL
19 				,p_inp_type	IN Varchar2) RETURN Varchar2;
20 
21   FUNCTION get_discount( p_hdr_id	IN Number --DEFAULT NULL
22 				,p_line_id	IN Number --DEFAULT NULL
23                 ) RETURN Varchar2;
24 
25   FUNCTION	get_acc_rule(p_hdr_id	IN Number
26 				,p_line_id	IN Number) RETURN Varchar2;
27 
28   FUNCTION	get_inv_rule(p_hdr_id	IN Number
29 				,p_line_id	IN Number) RETURN Varchar2;
30 
31   FUNCTION	get_billingprofile(p_hdr_id	IN Number
32 					,p_line_id	IN Number) RETURN Varchar2;
33 
34   FUNCTION	get_billingschedule(p_hdr_id	 IN Number
35 					 ,p_line_id	 IN Number
36 					 ,p_inp_type IN Varchar2) RETURN Varchar2;
37 
38   FUNCTION	get_renternotes(p_hdr_id	 IN Number
39 				   ,p_inp_type	 IN Varchar2) RETURN CLOB;
40 
41   FUNCTION	get_terms(p_hdr_id	 IN Number
42 			   ,p_line_id	 IN Number) RETURN Varchar2;
43 
44 
45   TYPE l_pdt_rec IS RECORD
46 	( product_id	Number,
47 	  product_qty	Number);
48 
49   FUNCTION get_product(p_line_id IN Number) RETURN l_pdt_rec;
50 
51   FUNCTION get_product(p_line_id IN Number, p_inp_type IN Varchar2) RETURN Varchar2;
52 
53   TYPE l_sys_rec IS RECORD
54 	( system_id		Number,
55 	  system_name	Varchar2(240));
56 
57   FUNCTION	get_system(p_line_id IN Number, p_org_id IN Number) RETURN l_sys_rec;
58 
59   FUNCTION	get_system(p_line_id IN Number, p_inp_type IN Varchar2, p_org_id IN Number) RETURN Varchar2;
60 
61   TYPE l_inv_rec IS RECORD
62 	( inv_item_id	Number,
63 	  item_name		Varchar2(240));
64 
65   FUNCTION	get_invitem(p_line_id IN Number, p_organization_id IN Number) RETURN l_inv_rec;
66 
67   FUNCTION	get_invitem(p_line_id IN Number, p_inp_type IN Varchar2, p_organization_id IN Number) RETURN Varchar2;
68 
69   TYPE l_qtyrate_rec IS RECORD
70 	(default_amcv_flag	Varchar2(1),
71 	 default_qty		Number,
72 	 default_uom		Varchar2(25),
73 	 default_duration		Number,
74 	 default_period		Varchar2(25),
75 	 minimum_qty		Number,
76 	 minimum_uom		Varchar2(25),
77 	 minimum_duration		Number,
78 	 minimum_period		Varchar2(25),
79 	 fixed_qty			Number,
80 	 fixed_uom			Varchar2(25),
81 	 fixed_duration		Number,
82 	 fixed_period		Varchar2(25),
83 	 level_flag			Varchar2(1));
84 
85   FUNCTION get_qtyrate_rule(p_line_id IN Number) RETURN l_qtyrate_rec;
86 
87   FUNCTION get_taxrule(p_hdr_id IN Number, p_inp_type IN Varchar2) RETURN Varchar2;
88 
89   FUNCTION get_convrule(p_hdr_id IN Number) RETURN Varchar2;
90 
91   FUNCTION get_agreement(p_hdr_id IN Number) RETURN Number;
92 
93   TYPE l_party_rec IS RECORD (party_id Number, party_name Varchar2(500));
94   FUNCTION get_clvl_party(p_line_id IN Number) RETURN l_party_rec;
95 
96   TYPE l_cust_rec IS RECORD (customer_id Number, customer_name Varchar2(500));
97   FUNCTION get_clvl_customer(p_line_id IN Number) RETURN l_cust_rec;
98 
99   TYPE l_site_rec IS RECORD (site_id Number, site_name Varchar2(500));
100   FUNCTION get_clvl_site(p_line_id IN Number, p_org_id IN Number) RETURN l_site_rec;
101 
102   FUNCTION get_coverage_type(p_line_id IN Number) Return Varchar2;
103 
104   FUNCTION get_billrate(p_rate_code IN VARCHAR2) Return Varchar2;
105 
106 END OKS_ENT_UTIL_PVT;