DBA Data[Home] [Help]

APPS.OKL_CNTR_GRP_BILLING_PUB_W dependencies on JTF_NUMBER_TABLE

Line 8: , p5_a0 JTF_NUMBER_TABLE

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

Line 10: , p5_a2 JTF_NUMBER_TABLE

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

Line 18: , p5_a10 JTF_NUMBER_TABLE

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

Line 20: , p5_a12 JTF_NUMBER_TABLE

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

Line 21: , p5_a13 JTF_NUMBER_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

Line 22: , p6_a0 out nocopy JTF_NUMBER_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

Line 24: , p6_a2 out nocopy JTF_NUMBER_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

Line 32: , p6_a10 out nocopy JTF_NUMBER_TABLE

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: );

Line 34: , p6_a12 out nocopy JTF_NUMBER_TABLE

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

Line 35: , p6_a13 out nocopy JTF_NUMBER_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

Line 76: , p5_a0 JTF_NUMBER_TABLE

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

Line 78: , p5_a2 JTF_NUMBER_TABLE

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

Line 86: , p5_a10 JTF_NUMBER_TABLE

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

Line 88: , p5_a12 JTF_NUMBER_TABLE

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

Line 89: , p5_a13 JTF_NUMBER_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

Line 90: , p6_a0 out nocopy JTF_NUMBER_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

Line 92: , p6_a2 out nocopy JTF_NUMBER_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

Line 100: , p6_a10 out nocopy JTF_NUMBER_TABLE

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: );

Line 102: , p6_a12 out nocopy JTF_NUMBER_TABLE

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

Line 103: , p6_a13 out nocopy JTF_NUMBER_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