APPS.OZF_VOLUME_OFFER_DISC_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_volume_offer_disc_pvt.ozf_vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE

Line 14: , a11 JTF_VARCHAR2_TABLE_100

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE

Line 16: , a13 JTF_VARCHAR2_TABLE_100

12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE

Line 21: , a18 JTF_VARCHAR2_TABLE_100

17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_DATE_TABLE

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE

Line 32: , a29 JTF_VARCHAR2_TABLE_100

28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_300
36: , a33 JTF_VARCHAR2_TABLE_2000

Line 37: , a34 JTF_VARCHAR2_TABLE_100

33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_300
36: , a33 JTF_VARCHAR2_TABLE_2000
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_300
39: , a36 JTF_VARCHAR2_TABLE_300
40: , a37 JTF_VARCHAR2_TABLE_300
41: , a38 JTF_VARCHAR2_TABLE_300

Line 58: , a4 out nocopy JTF_VARCHAR2_TABLE_100

54: procedure rosetta_table_copy_out_p2(t ozf_volume_offer_disc_pvt.ozf_vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_NUMBER_TABLE
56: , a2 out nocopy JTF_NUMBER_TABLE
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_VARCHAR2_TABLE_100
59: , a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , a6 out nocopy JTF_VARCHAR2_TABLE_100
61: , a7 out nocopy JTF_NUMBER_TABLE
62: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 59: , a5 out nocopy JTF_VARCHAR2_TABLE_100

55: , a1 out nocopy JTF_NUMBER_TABLE
56: , a2 out nocopy JTF_NUMBER_TABLE
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_VARCHAR2_TABLE_100
59: , a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , a6 out nocopy JTF_VARCHAR2_TABLE_100
61: , a7 out nocopy JTF_NUMBER_TABLE
62: , a8 out nocopy JTF_VARCHAR2_TABLE_100
63: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , a6 out nocopy JTF_VARCHAR2_TABLE_100

56: , a2 out nocopy JTF_NUMBER_TABLE
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_VARCHAR2_TABLE_100
59: , a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , a6 out nocopy JTF_VARCHAR2_TABLE_100
61: , a7 out nocopy JTF_NUMBER_TABLE
62: , a8 out nocopy JTF_VARCHAR2_TABLE_100
63: , a9 out nocopy JTF_VARCHAR2_TABLE_100
64: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , a8 out nocopy JTF_VARCHAR2_TABLE_100

58: , a4 out nocopy JTF_VARCHAR2_TABLE_100
59: , a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , a6 out nocopy JTF_VARCHAR2_TABLE_100
61: , a7 out nocopy JTF_NUMBER_TABLE
62: , a8 out nocopy JTF_VARCHAR2_TABLE_100
63: , a9 out nocopy JTF_VARCHAR2_TABLE_100
64: , a10 out nocopy JTF_VARCHAR2_TABLE_100
65: , a11 out nocopy JTF_VARCHAR2_TABLE_100
66: , a12 out nocopy JTF_NUMBER_TABLE

Line 63: , a9 out nocopy JTF_VARCHAR2_TABLE_100

59: , a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , a6 out nocopy JTF_VARCHAR2_TABLE_100
61: , a7 out nocopy JTF_NUMBER_TABLE
62: , a8 out nocopy JTF_VARCHAR2_TABLE_100
63: , a9 out nocopy JTF_VARCHAR2_TABLE_100
64: , a10 out nocopy JTF_VARCHAR2_TABLE_100
65: , a11 out nocopy JTF_VARCHAR2_TABLE_100
66: , a12 out nocopy JTF_NUMBER_TABLE
67: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: , a10 out nocopy JTF_VARCHAR2_TABLE_100

60: , a6 out nocopy JTF_VARCHAR2_TABLE_100
61: , a7 out nocopy JTF_NUMBER_TABLE
62: , a8 out nocopy JTF_VARCHAR2_TABLE_100
63: , a9 out nocopy JTF_VARCHAR2_TABLE_100
64: , a10 out nocopy JTF_VARCHAR2_TABLE_100
65: , a11 out nocopy JTF_VARCHAR2_TABLE_100
66: , a12 out nocopy JTF_NUMBER_TABLE
67: , a13 out nocopy JTF_VARCHAR2_TABLE_100
68: , a14 out nocopy JTF_NUMBER_TABLE

Line 65: , a11 out nocopy JTF_VARCHAR2_TABLE_100

61: , a7 out nocopy JTF_NUMBER_TABLE
62: , a8 out nocopy JTF_VARCHAR2_TABLE_100
63: , a9 out nocopy JTF_VARCHAR2_TABLE_100
64: , a10 out nocopy JTF_VARCHAR2_TABLE_100
65: , a11 out nocopy JTF_VARCHAR2_TABLE_100
66: , a12 out nocopy JTF_NUMBER_TABLE
67: , a13 out nocopy JTF_VARCHAR2_TABLE_100
68: , a14 out nocopy JTF_NUMBER_TABLE
69: , a15 out nocopy JTF_NUMBER_TABLE

Line 67: , a13 out nocopy JTF_VARCHAR2_TABLE_100

63: , a9 out nocopy JTF_VARCHAR2_TABLE_100
64: , a10 out nocopy JTF_VARCHAR2_TABLE_100
65: , a11 out nocopy JTF_VARCHAR2_TABLE_100
66: , a12 out nocopy JTF_NUMBER_TABLE
67: , a13 out nocopy JTF_VARCHAR2_TABLE_100
68: , a14 out nocopy JTF_NUMBER_TABLE
69: , a15 out nocopy JTF_NUMBER_TABLE
70: , a16 out nocopy JTF_NUMBER_TABLE
71: , a17 out nocopy JTF_NUMBER_TABLE

Line 72: , a18 out nocopy JTF_VARCHAR2_TABLE_100

68: , a14 out nocopy JTF_NUMBER_TABLE
69: , a15 out nocopy JTF_NUMBER_TABLE
70: , a16 out nocopy JTF_NUMBER_TABLE
71: , a17 out nocopy JTF_NUMBER_TABLE
72: , a18 out nocopy JTF_VARCHAR2_TABLE_100
73: , a19 out nocopy JTF_DATE_TABLE
74: , a20 out nocopy JTF_DATE_TABLE
75: , a21 out nocopy JTF_VARCHAR2_TABLE_100
76: , a22 out nocopy JTF_DATE_TABLE

Line 75: , a21 out nocopy JTF_VARCHAR2_TABLE_100

71: , a17 out nocopy JTF_NUMBER_TABLE
72: , a18 out nocopy JTF_VARCHAR2_TABLE_100
73: , a19 out nocopy JTF_DATE_TABLE
74: , a20 out nocopy JTF_DATE_TABLE
75: , a21 out nocopy JTF_VARCHAR2_TABLE_100
76: , a22 out nocopy JTF_DATE_TABLE
77: , a23 out nocopy JTF_NUMBER_TABLE
78: , a24 out nocopy JTF_DATE_TABLE
79: , a25 out nocopy JTF_NUMBER_TABLE

Line 83: , a29 out nocopy JTF_VARCHAR2_TABLE_100

79: , a25 out nocopy JTF_NUMBER_TABLE
80: , a26 out nocopy JTF_NUMBER_TABLE
81: , a27 out nocopy JTF_NUMBER_TABLE
82: , a28 out nocopy JTF_NUMBER_TABLE
83: , a29 out nocopy JTF_VARCHAR2_TABLE_100
84: , a30 out nocopy JTF_NUMBER_TABLE
85: , a31 out nocopy JTF_NUMBER_TABLE
86: , a32 out nocopy JTF_VARCHAR2_TABLE_300
87: , a33 out nocopy JTF_VARCHAR2_TABLE_2000

Line 88: , a34 out nocopy JTF_VARCHAR2_TABLE_100

84: , a30 out nocopy JTF_NUMBER_TABLE
85: , a31 out nocopy JTF_NUMBER_TABLE
86: , a32 out nocopy JTF_VARCHAR2_TABLE_300
87: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
88: , a34 out nocopy JTF_VARCHAR2_TABLE_100
89: , a35 out nocopy JTF_VARCHAR2_TABLE_300
90: , a36 out nocopy JTF_VARCHAR2_TABLE_300
91: , a37 out nocopy JTF_VARCHAR2_TABLE_300
92: , a38 out nocopy JTF_VARCHAR2_TABLE_300

Line 107: , a1 JTF_VARCHAR2_TABLE_100

103: , a49 out nocopy JTF_VARCHAR2_TABLE_300
104: );
105:
106: procedure rosetta_table_copy_in_p6(t out nocopy ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_VARCHAR2_TABLE_100
110: , a4 JTF_VARCHAR2_TABLE_100
111: , a5 JTF_DATE_TABLE

Line 109: , a3 JTF_VARCHAR2_TABLE_100

105:
106: procedure rosetta_table_copy_in_p6(t out nocopy ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_VARCHAR2_TABLE_100
110: , a4 JTF_VARCHAR2_TABLE_100
111: , a5 JTF_DATE_TABLE
112: , a6 JTF_DATE_TABLE
113: , a7 JTF_NUMBER_TABLE

Line 110: , a4 JTF_VARCHAR2_TABLE_100

106: procedure rosetta_table_copy_in_p6(t out nocopy ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_VARCHAR2_TABLE_100
110: , a4 JTF_VARCHAR2_TABLE_100
111: , a5 JTF_DATE_TABLE
112: , a6 JTF_DATE_TABLE
113: , a7 JTF_NUMBER_TABLE
114: , a8 JTF_NUMBER_TABLE

Line 122: , a16 JTF_VARCHAR2_TABLE_100

118: , a12 JTF_NUMBER_TABLE
119: , a13 JTF_NUMBER_TABLE
120: , a14 JTF_NUMBER_TABLE
121: , a15 JTF_NUMBER_TABLE
122: , a16 JTF_VARCHAR2_TABLE_100
123: , a17 JTF_VARCHAR2_TABLE_100
124: , a18 JTF_VARCHAR2_TABLE_300
125: , a19 JTF_VARCHAR2_TABLE_100
126: , a20 JTF_VARCHAR2_TABLE_100

Line 123: , a17 JTF_VARCHAR2_TABLE_100

119: , a13 JTF_NUMBER_TABLE
120: , a14 JTF_NUMBER_TABLE
121: , a15 JTF_NUMBER_TABLE
122: , a16 JTF_VARCHAR2_TABLE_100
123: , a17 JTF_VARCHAR2_TABLE_100
124: , a18 JTF_VARCHAR2_TABLE_300
125: , a19 JTF_VARCHAR2_TABLE_100
126: , a20 JTF_VARCHAR2_TABLE_100
127: );

Line 125: , a19 JTF_VARCHAR2_TABLE_100

121: , a15 JTF_NUMBER_TABLE
122: , a16 JTF_VARCHAR2_TABLE_100
123: , a17 JTF_VARCHAR2_TABLE_100
124: , a18 JTF_VARCHAR2_TABLE_300
125: , a19 JTF_VARCHAR2_TABLE_100
126: , a20 JTF_VARCHAR2_TABLE_100
127: );
128: procedure rosetta_table_copy_out_p6(t ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 126: , a20 JTF_VARCHAR2_TABLE_100

122: , a16 JTF_VARCHAR2_TABLE_100
123: , a17 JTF_VARCHAR2_TABLE_100
124: , a18 JTF_VARCHAR2_TABLE_300
125: , a19 JTF_VARCHAR2_TABLE_100
126: , a20 JTF_VARCHAR2_TABLE_100
127: );
128: procedure rosetta_table_copy_out_p6(t ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_VARCHAR2_TABLE_100
130: , a2 out nocopy JTF_NUMBER_TABLE

Line 129: , a1 out nocopy JTF_VARCHAR2_TABLE_100

125: , a19 JTF_VARCHAR2_TABLE_100
126: , a20 JTF_VARCHAR2_TABLE_100
127: );
128: procedure rosetta_table_copy_out_p6(t ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_VARCHAR2_TABLE_100
130: , a2 out nocopy JTF_NUMBER_TABLE
131: , a3 out nocopy JTF_VARCHAR2_TABLE_100
132: , a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , a5 out nocopy JTF_DATE_TABLE

Line 131: , a3 out nocopy JTF_VARCHAR2_TABLE_100

127: );
128: procedure rosetta_table_copy_out_p6(t ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_VARCHAR2_TABLE_100
130: , a2 out nocopy JTF_NUMBER_TABLE
131: , a3 out nocopy JTF_VARCHAR2_TABLE_100
132: , a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , a5 out nocopy JTF_DATE_TABLE
134: , a6 out nocopy JTF_DATE_TABLE
135: , a7 out nocopy JTF_NUMBER_TABLE

Line 132: , a4 out nocopy JTF_VARCHAR2_TABLE_100

128: procedure rosetta_table_copy_out_p6(t ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_VARCHAR2_TABLE_100
130: , a2 out nocopy JTF_NUMBER_TABLE
131: , a3 out nocopy JTF_VARCHAR2_TABLE_100
132: , a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , a5 out nocopy JTF_DATE_TABLE
134: , a6 out nocopy JTF_DATE_TABLE
135: , a7 out nocopy JTF_NUMBER_TABLE
136: , a8 out nocopy JTF_NUMBER_TABLE

Line 144: , a16 out nocopy JTF_VARCHAR2_TABLE_100

140: , a12 out nocopy JTF_NUMBER_TABLE
141: , a13 out nocopy JTF_NUMBER_TABLE
142: , a14 out nocopy JTF_NUMBER_TABLE
143: , a15 out nocopy JTF_NUMBER_TABLE
144: , a16 out nocopy JTF_VARCHAR2_TABLE_100
145: , a17 out nocopy JTF_VARCHAR2_TABLE_100
146: , a18 out nocopy JTF_VARCHAR2_TABLE_300
147: , a19 out nocopy JTF_VARCHAR2_TABLE_100
148: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 145: , a17 out nocopy JTF_VARCHAR2_TABLE_100

141: , a13 out nocopy JTF_NUMBER_TABLE
142: , a14 out nocopy JTF_NUMBER_TABLE
143: , a15 out nocopy JTF_NUMBER_TABLE
144: , a16 out nocopy JTF_VARCHAR2_TABLE_100
145: , a17 out nocopy JTF_VARCHAR2_TABLE_100
146: , a18 out nocopy JTF_VARCHAR2_TABLE_300
147: , a19 out nocopy JTF_VARCHAR2_TABLE_100
148: , a20 out nocopy JTF_VARCHAR2_TABLE_100
149: );

Line 147: , a19 out nocopy JTF_VARCHAR2_TABLE_100

143: , a15 out nocopy JTF_NUMBER_TABLE
144: , a16 out nocopy JTF_VARCHAR2_TABLE_100
145: , a17 out nocopy JTF_VARCHAR2_TABLE_100
146: , a18 out nocopy JTF_VARCHAR2_TABLE_300
147: , a19 out nocopy JTF_VARCHAR2_TABLE_100
148: , a20 out nocopy JTF_VARCHAR2_TABLE_100
149: );
150:
151: procedure create_vo_discount(p_api_version_number NUMBER

Line 148: , a20 out nocopy JTF_VARCHAR2_TABLE_100

144: , a16 out nocopy JTF_VARCHAR2_TABLE_100
145: , a17 out nocopy JTF_VARCHAR2_TABLE_100
146: , a18 out nocopy JTF_VARCHAR2_TABLE_300
147: , a19 out nocopy JTF_VARCHAR2_TABLE_100
148: , a20 out nocopy JTF_VARCHAR2_TABLE_100
149: );
150:
151: procedure create_vo_discount(p_api_version_number NUMBER
152: , p_init_msg_list VARCHAR2