[Home] [Help]
PACKAGE: APPS.OKL_CNTR_GRP_BILLING_PUB_W
Source
1 package okl_cntr_grp_billing_pub_w AUTHID CURRENT_USER as
2 /* $Header: OKLUCLBS.pls 120.5 2008/02/21 13:25:54 udhenuko noship $ */
3 procedure calculate_cntgrp_bill_amt(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p5_a0 JTF_NUMBER_TABLE
9 , p5_a1 JTF_VARCHAR2_TABLE_200
10 , p5_a2 JTF_NUMBER_TABLE
11 , p5_a3 JTF_VARCHAR2_TABLE_100
12 , p5_a4 JTF_VARCHAR2_TABLE_200
13 , p5_a5 JTF_VARCHAR2_TABLE_200
14 , p5_a6 JTF_VARCHAR2_TABLE_100
15 , p5_a7 JTF_VARCHAR2_TABLE_100
16 , p5_a8 JTF_DATE_TABLE
17 , p5_a9 JTF_DATE_TABLE
18 , p5_a10 JTF_NUMBER_TABLE
19 , p5_a11 JTF_DATE_TABLE
20 , p5_a12 JTF_NUMBER_TABLE
21 , p5_a13 JTF_NUMBER_TABLE
22 , p6_a0 out nocopy JTF_NUMBER_TABLE
23 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
24 , p6_a2 out nocopy JTF_NUMBER_TABLE
25 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
26 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
27 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
28 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
29 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
30 , p6_a8 out nocopy JTF_DATE_TABLE
31 , p6_a9 out nocopy JTF_DATE_TABLE
32 , p6_a10 out nocopy JTF_NUMBER_TABLE
33 , p6_a11 out nocopy JTF_DATE_TABLE
34 , p6_a12 out nocopy JTF_NUMBER_TABLE
35 , p6_a13 out nocopy JTF_NUMBER_TABLE
36 );
37 procedure calculate_cntgrp_bill_amt(p_api_version NUMBER
38 , p_init_msg_list VARCHAR2
39 , x_return_status out nocopy VARCHAR2
40 , x_msg_count out nocopy NUMBER
41 , x_msg_data out nocopy VARCHAR2
42 , p5_a0 NUMBER
43 , p5_a1 VARCHAR2
44 , p5_a2 NUMBER
45 , p5_a3 VARCHAR2
46 , p5_a4 VARCHAR2
47 , p5_a5 VARCHAR2
48 , p5_a6 VARCHAR2
49 , p5_a7 VARCHAR2
50 , p5_a8 DATE
51 , p5_a9 DATE
52 , p5_a10 NUMBER
53 , p5_a11 DATE
54 , p5_a12 NUMBER
55 , p5_a13 NUMBER
56 , p6_a0 out nocopy NUMBER
57 , p6_a1 out nocopy VARCHAR2
58 , p6_a2 out nocopy NUMBER
59 , p6_a3 out nocopy VARCHAR2
60 , p6_a4 out nocopy VARCHAR2
61 , p6_a5 out nocopy VARCHAR2
62 , p6_a6 out nocopy VARCHAR2
63 , p6_a7 out nocopy VARCHAR2
64 , p6_a8 out nocopy DATE
65 , p6_a9 out nocopy DATE
66 , p6_a10 out nocopy NUMBER
67 , p6_a11 out nocopy DATE
68 , p6_a12 out nocopy NUMBER
69 , p6_a13 out nocopy NUMBER
70 );
71 procedure insert_cntr_grp_bill(p_api_version NUMBER
72 , p_init_msg_list VARCHAR2
73 , x_return_status out nocopy VARCHAR2
74 , x_msg_count out nocopy NUMBER
75 , x_msg_data out nocopy VARCHAR2
76 , p5_a0 JTF_NUMBER_TABLE
77 , p5_a1 JTF_VARCHAR2_TABLE_200
78 , p5_a2 JTF_NUMBER_TABLE
79 , p5_a3 JTF_VARCHAR2_TABLE_100
80 , p5_a4 JTF_VARCHAR2_TABLE_200
81 , p5_a5 JTF_VARCHAR2_TABLE_200
82 , p5_a6 JTF_VARCHAR2_TABLE_100
83 , p5_a7 JTF_VARCHAR2_TABLE_100
84 , p5_a8 JTF_DATE_TABLE
85 , p5_a9 JTF_DATE_TABLE
86 , p5_a10 JTF_NUMBER_TABLE
87 , p5_a11 JTF_DATE_TABLE
88 , p5_a12 JTF_NUMBER_TABLE
89 , p5_a13 JTF_NUMBER_TABLE
90 , p6_a0 out nocopy JTF_NUMBER_TABLE
91 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
92 , p6_a2 out nocopy JTF_NUMBER_TABLE
93 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
94 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
95 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
96 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
97 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
98 , p6_a8 out nocopy JTF_DATE_TABLE
99 , p6_a9 out nocopy JTF_DATE_TABLE
100 , p6_a10 out nocopy JTF_NUMBER_TABLE
101 , p6_a11 out nocopy JTF_DATE_TABLE
102 , p6_a12 out nocopy JTF_NUMBER_TABLE
103 , p6_a13 out nocopy JTF_NUMBER_TABLE
104 );
105 procedure insert_cntr_grp_bill(p_api_version NUMBER
106 , p_init_msg_list VARCHAR2
107 , x_return_status out nocopy VARCHAR2
108 , x_msg_count out nocopy NUMBER
109 , x_msg_data out nocopy VARCHAR2
110 , p5_a0 NUMBER
111 , p5_a1 VARCHAR2
112 , p5_a2 NUMBER
113 , p5_a3 VARCHAR2
114 , p5_a4 VARCHAR2
115 , p5_a5 VARCHAR2
116 , p5_a6 VARCHAR2
117 , p5_a7 VARCHAR2
118 , p5_a8 DATE
119 , p5_a9 DATE
120 , p5_a10 NUMBER
121 , p5_a11 DATE
122 , p5_a12 NUMBER
123 , p5_a13 NUMBER
124 , p6_a0 out nocopy NUMBER
125 , p6_a1 out nocopy VARCHAR2
126 , p6_a2 out nocopy NUMBER
127 , p6_a3 out nocopy VARCHAR2
128 , p6_a4 out nocopy VARCHAR2
129 , p6_a5 out nocopy VARCHAR2
130 , p6_a6 out nocopy VARCHAR2
131 , p6_a7 out nocopy VARCHAR2
132 , p6_a8 out nocopy DATE
133 , p6_a9 out nocopy DATE
134 , p6_a10 out nocopy NUMBER
135 , p6_a11 out nocopy DATE
136 , p6_a12 out nocopy NUMBER
137 , p6_a13 out nocopy NUMBER
138 );
139 end okl_cntr_grp_billing_pub_w;