DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_BUDGET_PVT_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_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_VARCHAR2_TABLE_200
12: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 9: , p5_a1 JTF_NUMBER_TABLE

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_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_VARCHAR2_TABLE_200
12: , p5_a4 JTF_VARCHAR2_TABLE_100
13: , p5_a5 JTF_DATE_TABLE

Line 15: , p5_a7 JTF_NUMBER_TABLE

11: , p5_a3 JTF_VARCHAR2_TABLE_200
12: , p5_a4 JTF_VARCHAR2_TABLE_100
13: , p5_a5 JTF_DATE_TABLE
14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_DATE_TABLE
18: , p5_a10 JTF_VARCHAR2_TABLE_100
19: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 16: , p5_a8 JTF_NUMBER_TABLE

12: , p5_a4 JTF_VARCHAR2_TABLE_100
13: , p5_a5 JTF_DATE_TABLE
14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_DATE_TABLE
18: , p5_a10 JTF_VARCHAR2_TABLE_100
19: , p5_a11 JTF_VARCHAR2_TABLE_500
20: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 34: , p5_a26 JTF_NUMBER_TABLE

30: , p5_a22 JTF_VARCHAR2_TABLE_500
31: , p5_a23 JTF_VARCHAR2_TABLE_500
32: , p5_a24 JTF_VARCHAR2_TABLE_500
33: , p5_a25 JTF_VARCHAR2_TABLE_500
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE

Line 36: , p5_a28 JTF_NUMBER_TABLE

32: , p5_a24 JTF_VARCHAR2_TABLE_500
33: , p5_a25 JTF_VARCHAR2_TABLE_500
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p6_a0 out nocopy JTF_NUMBER_TABLE
40: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 38: , p5_a30 JTF_NUMBER_TABLE

34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p6_a0 out nocopy JTF_NUMBER_TABLE
40: , p6_a1 out nocopy JTF_NUMBER_TABLE
41: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 39: , p6_a0 out nocopy JTF_NUMBER_TABLE

35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p6_a0 out nocopy JTF_NUMBER_TABLE
40: , p6_a1 out nocopy JTF_NUMBER_TABLE
41: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
43: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 40: , p6_a1 out nocopy JTF_NUMBER_TABLE

36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p6_a0 out nocopy JTF_NUMBER_TABLE
40: , p6_a1 out nocopy JTF_NUMBER_TABLE
41: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
43: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a5 out nocopy JTF_DATE_TABLE

Line 46: , p6_a7 out nocopy JTF_NUMBER_TABLE

42: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
43: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a5 out nocopy JTF_DATE_TABLE
45: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
46: , p6_a7 out nocopy JTF_NUMBER_TABLE
47: , p6_a8 out nocopy JTF_NUMBER_TABLE
48: , p6_a9 out nocopy JTF_DATE_TABLE
49: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
50: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 47: , p6_a8 out nocopy JTF_NUMBER_TABLE

43: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a5 out nocopy JTF_DATE_TABLE
45: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
46: , p6_a7 out nocopy JTF_NUMBER_TABLE
47: , p6_a8 out nocopy JTF_NUMBER_TABLE
48: , p6_a9 out nocopy JTF_DATE_TABLE
49: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
50: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
51: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 65: , p6_a26 out nocopy JTF_NUMBER_TABLE

61: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
62: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
63: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
64: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
65: , p6_a26 out nocopy JTF_NUMBER_TABLE
66: , p6_a27 out nocopy JTF_DATE_TABLE
67: , p6_a28 out nocopy JTF_NUMBER_TABLE
68: , p6_a29 out nocopy JTF_DATE_TABLE
69: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 67: , p6_a28 out nocopy JTF_NUMBER_TABLE

63: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
64: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
65: , p6_a26 out nocopy JTF_NUMBER_TABLE
66: , p6_a27 out nocopy JTF_DATE_TABLE
67: , p6_a28 out nocopy JTF_NUMBER_TABLE
68: , p6_a29 out nocopy JTF_DATE_TABLE
69: , p6_a30 out nocopy JTF_NUMBER_TABLE
70: );
71: procedure update_budget_line(p_api_version NUMBER

Line 69: , p6_a30 out nocopy JTF_NUMBER_TABLE

65: , p6_a26 out nocopy JTF_NUMBER_TABLE
66: , p6_a27 out nocopy JTF_DATE_TABLE
67: , p6_a28 out nocopy JTF_NUMBER_TABLE
68: , p6_a29 out nocopy JTF_DATE_TABLE
69: , p6_a30 out nocopy JTF_NUMBER_TABLE
70: );
71: procedure update_budget_line(p_api_version NUMBER
72: , p_init_msg_list VARCHAR2
73: , 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_NUMBER_TABLE
78: , p5_a2 JTF_VARCHAR2_TABLE_100
79: , p5_a3 JTF_VARCHAR2_TABLE_200
80: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 77: , p5_a1 JTF_NUMBER_TABLE

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_NUMBER_TABLE
78: , p5_a2 JTF_VARCHAR2_TABLE_100
79: , p5_a3 JTF_VARCHAR2_TABLE_200
80: , p5_a4 JTF_VARCHAR2_TABLE_100
81: , p5_a5 JTF_DATE_TABLE

Line 83: , p5_a7 JTF_NUMBER_TABLE

79: , p5_a3 JTF_VARCHAR2_TABLE_200
80: , p5_a4 JTF_VARCHAR2_TABLE_100
81: , p5_a5 JTF_DATE_TABLE
82: , p5_a6 JTF_VARCHAR2_TABLE_100
83: , p5_a7 JTF_NUMBER_TABLE
84: , p5_a8 JTF_NUMBER_TABLE
85: , p5_a9 JTF_DATE_TABLE
86: , p5_a10 JTF_VARCHAR2_TABLE_100
87: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 84: , p5_a8 JTF_NUMBER_TABLE

80: , p5_a4 JTF_VARCHAR2_TABLE_100
81: , p5_a5 JTF_DATE_TABLE
82: , p5_a6 JTF_VARCHAR2_TABLE_100
83: , p5_a7 JTF_NUMBER_TABLE
84: , p5_a8 JTF_NUMBER_TABLE
85: , p5_a9 JTF_DATE_TABLE
86: , p5_a10 JTF_VARCHAR2_TABLE_100
87: , p5_a11 JTF_VARCHAR2_TABLE_500
88: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 102: , p5_a26 JTF_NUMBER_TABLE

98: , p5_a22 JTF_VARCHAR2_TABLE_500
99: , p5_a23 JTF_VARCHAR2_TABLE_500
100: , p5_a24 JTF_VARCHAR2_TABLE_500
101: , p5_a25 JTF_VARCHAR2_TABLE_500
102: , p5_a26 JTF_NUMBER_TABLE
103: , p5_a27 JTF_DATE_TABLE
104: , p5_a28 JTF_NUMBER_TABLE
105: , p5_a29 JTF_DATE_TABLE
106: , p5_a30 JTF_NUMBER_TABLE

Line 104: , p5_a28 JTF_NUMBER_TABLE

100: , p5_a24 JTF_VARCHAR2_TABLE_500
101: , p5_a25 JTF_VARCHAR2_TABLE_500
102: , p5_a26 JTF_NUMBER_TABLE
103: , p5_a27 JTF_DATE_TABLE
104: , p5_a28 JTF_NUMBER_TABLE
105: , p5_a29 JTF_DATE_TABLE
106: , p5_a30 JTF_NUMBER_TABLE
107: , p6_a0 out nocopy JTF_NUMBER_TABLE
108: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 106: , p5_a30 JTF_NUMBER_TABLE

102: , p5_a26 JTF_NUMBER_TABLE
103: , p5_a27 JTF_DATE_TABLE
104: , p5_a28 JTF_NUMBER_TABLE
105: , p5_a29 JTF_DATE_TABLE
106: , p5_a30 JTF_NUMBER_TABLE
107: , p6_a0 out nocopy JTF_NUMBER_TABLE
108: , p6_a1 out nocopy JTF_NUMBER_TABLE
109: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 107: , p6_a0 out nocopy JTF_NUMBER_TABLE

103: , p5_a27 JTF_DATE_TABLE
104: , p5_a28 JTF_NUMBER_TABLE
105: , p5_a29 JTF_DATE_TABLE
106: , p5_a30 JTF_NUMBER_TABLE
107: , p6_a0 out nocopy JTF_NUMBER_TABLE
108: , p6_a1 out nocopy JTF_NUMBER_TABLE
109: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
111: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , p6_a1 out nocopy JTF_NUMBER_TABLE

104: , p5_a28 JTF_NUMBER_TABLE
105: , p5_a29 JTF_DATE_TABLE
106: , p5_a30 JTF_NUMBER_TABLE
107: , p6_a0 out nocopy JTF_NUMBER_TABLE
108: , p6_a1 out nocopy JTF_NUMBER_TABLE
109: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
111: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , p6_a5 out nocopy JTF_DATE_TABLE

Line 114: , p6_a7 out nocopy JTF_NUMBER_TABLE

110: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
111: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , p6_a5 out nocopy JTF_DATE_TABLE
113: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
114: , p6_a7 out nocopy JTF_NUMBER_TABLE
115: , p6_a8 out nocopy JTF_NUMBER_TABLE
116: , p6_a9 out nocopy JTF_DATE_TABLE
117: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
118: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 115: , p6_a8 out nocopy JTF_NUMBER_TABLE

111: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , p6_a5 out nocopy JTF_DATE_TABLE
113: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
114: , p6_a7 out nocopy JTF_NUMBER_TABLE
115: , p6_a8 out nocopy JTF_NUMBER_TABLE
116: , p6_a9 out nocopy JTF_DATE_TABLE
117: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
118: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
119: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 133: , p6_a26 out nocopy JTF_NUMBER_TABLE

129: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
130: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
131: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
132: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
133: , p6_a26 out nocopy JTF_NUMBER_TABLE
134: , p6_a27 out nocopy JTF_DATE_TABLE
135: , p6_a28 out nocopy JTF_NUMBER_TABLE
136: , p6_a29 out nocopy JTF_DATE_TABLE
137: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 135: , p6_a28 out nocopy JTF_NUMBER_TABLE

131: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
132: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
133: , p6_a26 out nocopy JTF_NUMBER_TABLE
134: , p6_a27 out nocopy JTF_DATE_TABLE
135: , p6_a28 out nocopy JTF_NUMBER_TABLE
136: , p6_a29 out nocopy JTF_DATE_TABLE
137: , p6_a30 out nocopy JTF_NUMBER_TABLE
138: );
139: procedure validate_budget_line(p_api_version NUMBER

Line 137: , p6_a30 out nocopy JTF_NUMBER_TABLE

133: , p6_a26 out nocopy JTF_NUMBER_TABLE
134: , p6_a27 out nocopy JTF_DATE_TABLE
135: , p6_a28 out nocopy JTF_NUMBER_TABLE
136: , p6_a29 out nocopy JTF_DATE_TABLE
137: , p6_a30 out nocopy JTF_NUMBER_TABLE
138: );
139: procedure validate_budget_line(p_api_version NUMBER
140: , p_init_msg_list VARCHAR2
141: , x_return_status out nocopy VARCHAR2

Line 144: , p5_a0 JTF_NUMBER_TABLE

140: , p_init_msg_list VARCHAR2
141: , x_return_status out nocopy VARCHAR2
142: , x_msg_count out nocopy NUMBER
143: , x_msg_data out nocopy VARCHAR2
144: , p5_a0 JTF_NUMBER_TABLE
145: , p5_a1 JTF_NUMBER_TABLE
146: , p5_a2 JTF_VARCHAR2_TABLE_100
147: , p5_a3 JTF_VARCHAR2_TABLE_200
148: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 145: , p5_a1 JTF_NUMBER_TABLE

141: , x_return_status out nocopy VARCHAR2
142: , x_msg_count out nocopy NUMBER
143: , x_msg_data out nocopy VARCHAR2
144: , p5_a0 JTF_NUMBER_TABLE
145: , p5_a1 JTF_NUMBER_TABLE
146: , p5_a2 JTF_VARCHAR2_TABLE_100
147: , p5_a3 JTF_VARCHAR2_TABLE_200
148: , p5_a4 JTF_VARCHAR2_TABLE_100
149: , p5_a5 JTF_DATE_TABLE

Line 151: , p5_a7 JTF_NUMBER_TABLE

147: , p5_a3 JTF_VARCHAR2_TABLE_200
148: , p5_a4 JTF_VARCHAR2_TABLE_100
149: , p5_a5 JTF_DATE_TABLE
150: , p5_a6 JTF_VARCHAR2_TABLE_100
151: , p5_a7 JTF_NUMBER_TABLE
152: , p5_a8 JTF_NUMBER_TABLE
153: , p5_a9 JTF_DATE_TABLE
154: , p5_a10 JTF_VARCHAR2_TABLE_100
155: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 152: , p5_a8 JTF_NUMBER_TABLE

148: , p5_a4 JTF_VARCHAR2_TABLE_100
149: , p5_a5 JTF_DATE_TABLE
150: , p5_a6 JTF_VARCHAR2_TABLE_100
151: , p5_a7 JTF_NUMBER_TABLE
152: , p5_a8 JTF_NUMBER_TABLE
153: , p5_a9 JTF_DATE_TABLE
154: , p5_a10 JTF_VARCHAR2_TABLE_100
155: , p5_a11 JTF_VARCHAR2_TABLE_500
156: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 170: , p5_a26 JTF_NUMBER_TABLE

166: , p5_a22 JTF_VARCHAR2_TABLE_500
167: , p5_a23 JTF_VARCHAR2_TABLE_500
168: , p5_a24 JTF_VARCHAR2_TABLE_500
169: , p5_a25 JTF_VARCHAR2_TABLE_500
170: , p5_a26 JTF_NUMBER_TABLE
171: , p5_a27 JTF_DATE_TABLE
172: , p5_a28 JTF_NUMBER_TABLE
173: , p5_a29 JTF_DATE_TABLE
174: , p5_a30 JTF_NUMBER_TABLE

Line 172: , p5_a28 JTF_NUMBER_TABLE

168: , p5_a24 JTF_VARCHAR2_TABLE_500
169: , p5_a25 JTF_VARCHAR2_TABLE_500
170: , p5_a26 JTF_NUMBER_TABLE
171: , p5_a27 JTF_DATE_TABLE
172: , p5_a28 JTF_NUMBER_TABLE
173: , p5_a29 JTF_DATE_TABLE
174: , p5_a30 JTF_NUMBER_TABLE
175: );
176: end okl_subsidy_pool_budget_pvt_w;

Line 174: , p5_a30 JTF_NUMBER_TABLE

170: , p5_a26 JTF_NUMBER_TABLE
171: , p5_a27 JTF_DATE_TABLE
172: , p5_a28 JTF_NUMBER_TABLE
173: , p5_a29 JTF_DATE_TABLE
174: , p5_a30 JTF_NUMBER_TABLE
175: );
176: end okl_subsidy_pool_budget_pvt_w;