DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJ_LINE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: ozfwoals.pls 120.1 2005/09/26 17:59 rssharma noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_adj_line_pvt.offadj_line_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 16: , a13 JTF_VARCHAR2_TABLE_100

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
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: );
24: procedure rosetta_table_copy_out_p2(t ozf_offer_adj_line_pvt.offadj_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_NUMBER_TABLE

Line 27: , a3 out nocopy JTF_VARCHAR2_TABLE_100

23: );
24: procedure rosetta_table_copy_out_p2(t ozf_offer_adj_line_pvt.offadj_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_VARCHAR2_TABLE_100
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_NUMBER_TABLE
30: , a6 out nocopy JTF_DATE_TABLE
31: , a7 out nocopy JTF_NUMBER_TABLE

Line 37: , a13 out nocopy JTF_VARCHAR2_TABLE_100

33: , a9 out nocopy JTF_NUMBER_TABLE
34: , a10 out nocopy JTF_NUMBER_TABLE
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_VARCHAR2_TABLE_100
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_NUMBER_TABLE
41: , a17 out nocopy JTF_NUMBER_TABLE

Line 42: , a18 out nocopy JTF_VARCHAR2_TABLE_100

38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_NUMBER_TABLE
41: , a17 out nocopy JTF_NUMBER_TABLE
42: , a18 out nocopy JTF_VARCHAR2_TABLE_100
43: , a19 out nocopy JTF_DATE_TABLE
44: );
45:
46: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_adj_line_pvt.offadj_new_line_tbl_type, a0 JTF_NUMBER_TABLE

Line 50: , a4 JTF_VARCHAR2_TABLE_100

46: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_adj_line_pvt.offadj_new_line_tbl_type, a0 JTF_NUMBER_TABLE
47: , a1 JTF_NUMBER_TABLE
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_NUMBER_TABLE
50: , a4 JTF_VARCHAR2_TABLE_100
51: , a5 JTF_NUMBER_TABLE
52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_VARCHAR2_TABLE_100
54: , a8 JTF_VARCHAR2_TABLE_300

Line 52: , a6 JTF_VARCHAR2_TABLE_100

48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_NUMBER_TABLE
50: , a4 JTF_VARCHAR2_TABLE_100
51: , a5 JTF_NUMBER_TABLE
52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_VARCHAR2_TABLE_100
54: , a8 JTF_VARCHAR2_TABLE_300
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_VARCHAR2_TABLE_100

Line 53: , a7 JTF_VARCHAR2_TABLE_100

49: , a3 JTF_NUMBER_TABLE
50: , a4 JTF_VARCHAR2_TABLE_100
51: , a5 JTF_NUMBER_TABLE
52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_VARCHAR2_TABLE_100
54: , a8 JTF_VARCHAR2_TABLE_300
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_VARCHAR2_TABLE_100
57: , a11 JTF_VARCHAR2_TABLE_300

Line 55: , a9 JTF_VARCHAR2_TABLE_100

51: , a5 JTF_NUMBER_TABLE
52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_VARCHAR2_TABLE_100
54: , a8 JTF_VARCHAR2_TABLE_300
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_VARCHAR2_TABLE_100
57: , a11 JTF_VARCHAR2_TABLE_300
58: , a12 JTF_VARCHAR2_TABLE_300
59: , a13 JTF_NUMBER_TABLE

Line 56: , a10 JTF_VARCHAR2_TABLE_100

52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_VARCHAR2_TABLE_100
54: , a8 JTF_VARCHAR2_TABLE_300
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_VARCHAR2_TABLE_100
57: , a11 JTF_VARCHAR2_TABLE_300
58: , a12 JTF_VARCHAR2_TABLE_300
59: , a13 JTF_NUMBER_TABLE
60: , a14 JTF_NUMBER_TABLE

Line 63: , a17 JTF_VARCHAR2_TABLE_100

59: , a13 JTF_NUMBER_TABLE
60: , a14 JTF_NUMBER_TABLE
61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_NUMBER_TABLE
63: , a17 JTF_VARCHAR2_TABLE_100
64: , a18 JTF_NUMBER_TABLE
65: , a19 JTF_NUMBER_TABLE
66: , a20 JTF_NUMBER_TABLE
67: , a21 JTF_NUMBER_TABLE

Line 69: , a23 JTF_VARCHAR2_TABLE_100

65: , a19 JTF_NUMBER_TABLE
66: , a20 JTF_NUMBER_TABLE
67: , a21 JTF_NUMBER_TABLE
68: , a22 JTF_NUMBER_TABLE
69: , a23 JTF_VARCHAR2_TABLE_100
70: , a24 JTF_NUMBER_TABLE
71: , a25 JTF_VARCHAR2_TABLE_100
72: , a26 JTF_VARCHAR2_TABLE_100
73: , a27 JTF_NUMBER_TABLE

Line 71: , a25 JTF_VARCHAR2_TABLE_100

67: , a21 JTF_NUMBER_TABLE
68: , a22 JTF_NUMBER_TABLE
69: , a23 JTF_VARCHAR2_TABLE_100
70: , a24 JTF_NUMBER_TABLE
71: , a25 JTF_VARCHAR2_TABLE_100
72: , a26 JTF_VARCHAR2_TABLE_100
73: , a27 JTF_NUMBER_TABLE
74: , a28 JTF_VARCHAR2_TABLE_100
75: , a29 JTF_NUMBER_TABLE

Line 72: , a26 JTF_VARCHAR2_TABLE_100

68: , a22 JTF_NUMBER_TABLE
69: , a23 JTF_VARCHAR2_TABLE_100
70: , a24 JTF_NUMBER_TABLE
71: , a25 JTF_VARCHAR2_TABLE_100
72: , a26 JTF_VARCHAR2_TABLE_100
73: , a27 JTF_NUMBER_TABLE
74: , a28 JTF_VARCHAR2_TABLE_100
75: , a29 JTF_NUMBER_TABLE
76: , a30 JTF_VARCHAR2_TABLE_100

Line 74: , a28 JTF_VARCHAR2_TABLE_100

70: , a24 JTF_NUMBER_TABLE
71: , a25 JTF_VARCHAR2_TABLE_100
72: , a26 JTF_VARCHAR2_TABLE_100
73: , a27 JTF_NUMBER_TABLE
74: , a28 JTF_VARCHAR2_TABLE_100
75: , a29 JTF_NUMBER_TABLE
76: , a30 JTF_VARCHAR2_TABLE_100
77: , a31 JTF_NUMBER_TABLE
78: , a32 JTF_DATE_TABLE

Line 76: , a30 JTF_VARCHAR2_TABLE_100

72: , a26 JTF_VARCHAR2_TABLE_100
73: , a27 JTF_NUMBER_TABLE
74: , a28 JTF_VARCHAR2_TABLE_100
75: , a29 JTF_NUMBER_TABLE
76: , a30 JTF_VARCHAR2_TABLE_100
77: , a31 JTF_NUMBER_TABLE
78: , a32 JTF_DATE_TABLE
79: , a33 JTF_NUMBER_TABLE
80: , a34 JTF_DATE_TABLE

Line 101: , a55 JTF_VARCHAR2_TABLE_100

97: , a51 JTF_VARCHAR2_TABLE_300
98: , a52 JTF_VARCHAR2_TABLE_300
99: , a53 JTF_VARCHAR2_TABLE_300
100: , a54 JTF_VARCHAR2_TABLE_300
101: , a55 JTF_VARCHAR2_TABLE_100
102: , a56 JTF_DATE_TABLE
103: );
104: procedure rosetta_table_copy_out_p6(t ozf_offer_adj_line_pvt.offadj_new_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a1 out nocopy JTF_NUMBER_TABLE

Line 108: , a4 out nocopy JTF_VARCHAR2_TABLE_100

104: procedure rosetta_table_copy_out_p6(t ozf_offer_adj_line_pvt.offadj_new_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a1 out nocopy JTF_NUMBER_TABLE
106: , a2 out nocopy JTF_NUMBER_TABLE
107: , a3 out nocopy JTF_NUMBER_TABLE
108: , a4 out nocopy JTF_VARCHAR2_TABLE_100
109: , a5 out nocopy JTF_NUMBER_TABLE
110: , a6 out nocopy JTF_VARCHAR2_TABLE_100
111: , a7 out nocopy JTF_VARCHAR2_TABLE_100
112: , a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 110: , a6 out nocopy JTF_VARCHAR2_TABLE_100

106: , a2 out nocopy JTF_NUMBER_TABLE
107: , a3 out nocopy JTF_NUMBER_TABLE
108: , a4 out nocopy JTF_VARCHAR2_TABLE_100
109: , a5 out nocopy JTF_NUMBER_TABLE
110: , a6 out nocopy JTF_VARCHAR2_TABLE_100
111: , a7 out nocopy JTF_VARCHAR2_TABLE_100
112: , a8 out nocopy JTF_VARCHAR2_TABLE_300
113: , a9 out nocopy JTF_VARCHAR2_TABLE_100
114: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 111: , a7 out nocopy JTF_VARCHAR2_TABLE_100

107: , a3 out nocopy JTF_NUMBER_TABLE
108: , a4 out nocopy JTF_VARCHAR2_TABLE_100
109: , a5 out nocopy JTF_NUMBER_TABLE
110: , a6 out nocopy JTF_VARCHAR2_TABLE_100
111: , a7 out nocopy JTF_VARCHAR2_TABLE_100
112: , a8 out nocopy JTF_VARCHAR2_TABLE_300
113: , a9 out nocopy JTF_VARCHAR2_TABLE_100
114: , a10 out nocopy JTF_VARCHAR2_TABLE_100
115: , a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 113: , a9 out nocopy JTF_VARCHAR2_TABLE_100

109: , a5 out nocopy JTF_NUMBER_TABLE
110: , a6 out nocopy JTF_VARCHAR2_TABLE_100
111: , a7 out nocopy JTF_VARCHAR2_TABLE_100
112: , a8 out nocopy JTF_VARCHAR2_TABLE_300
113: , a9 out nocopy JTF_VARCHAR2_TABLE_100
114: , a10 out nocopy JTF_VARCHAR2_TABLE_100
115: , a11 out nocopy JTF_VARCHAR2_TABLE_300
116: , a12 out nocopy JTF_VARCHAR2_TABLE_300
117: , a13 out nocopy JTF_NUMBER_TABLE

Line 114: , a10 out nocopy JTF_VARCHAR2_TABLE_100

110: , a6 out nocopy JTF_VARCHAR2_TABLE_100
111: , a7 out nocopy JTF_VARCHAR2_TABLE_100
112: , a8 out nocopy JTF_VARCHAR2_TABLE_300
113: , a9 out nocopy JTF_VARCHAR2_TABLE_100
114: , a10 out nocopy JTF_VARCHAR2_TABLE_100
115: , a11 out nocopy JTF_VARCHAR2_TABLE_300
116: , a12 out nocopy JTF_VARCHAR2_TABLE_300
117: , a13 out nocopy JTF_NUMBER_TABLE
118: , a14 out nocopy JTF_NUMBER_TABLE

Line 121: , a17 out nocopy JTF_VARCHAR2_TABLE_100

117: , a13 out nocopy JTF_NUMBER_TABLE
118: , a14 out nocopy JTF_NUMBER_TABLE
119: , a15 out nocopy JTF_NUMBER_TABLE
120: , a16 out nocopy JTF_NUMBER_TABLE
121: , a17 out nocopy JTF_VARCHAR2_TABLE_100
122: , a18 out nocopy JTF_NUMBER_TABLE
123: , a19 out nocopy JTF_NUMBER_TABLE
124: , a20 out nocopy JTF_NUMBER_TABLE
125: , a21 out nocopy JTF_NUMBER_TABLE

Line 127: , a23 out nocopy JTF_VARCHAR2_TABLE_100

123: , a19 out nocopy JTF_NUMBER_TABLE
124: , a20 out nocopy JTF_NUMBER_TABLE
125: , a21 out nocopy JTF_NUMBER_TABLE
126: , a22 out nocopy JTF_NUMBER_TABLE
127: , a23 out nocopy JTF_VARCHAR2_TABLE_100
128: , a24 out nocopy JTF_NUMBER_TABLE
129: , a25 out nocopy JTF_VARCHAR2_TABLE_100
130: , a26 out nocopy JTF_VARCHAR2_TABLE_100
131: , a27 out nocopy JTF_NUMBER_TABLE

Line 129: , a25 out nocopy JTF_VARCHAR2_TABLE_100

125: , a21 out nocopy JTF_NUMBER_TABLE
126: , a22 out nocopy JTF_NUMBER_TABLE
127: , a23 out nocopy JTF_VARCHAR2_TABLE_100
128: , a24 out nocopy JTF_NUMBER_TABLE
129: , a25 out nocopy JTF_VARCHAR2_TABLE_100
130: , a26 out nocopy JTF_VARCHAR2_TABLE_100
131: , a27 out nocopy JTF_NUMBER_TABLE
132: , a28 out nocopy JTF_VARCHAR2_TABLE_100
133: , a29 out nocopy JTF_NUMBER_TABLE

Line 130: , a26 out nocopy JTF_VARCHAR2_TABLE_100

126: , a22 out nocopy JTF_NUMBER_TABLE
127: , a23 out nocopy JTF_VARCHAR2_TABLE_100
128: , a24 out nocopy JTF_NUMBER_TABLE
129: , a25 out nocopy JTF_VARCHAR2_TABLE_100
130: , a26 out nocopy JTF_VARCHAR2_TABLE_100
131: , a27 out nocopy JTF_NUMBER_TABLE
132: , a28 out nocopy JTF_VARCHAR2_TABLE_100
133: , a29 out nocopy JTF_NUMBER_TABLE
134: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 132: , a28 out nocopy JTF_VARCHAR2_TABLE_100

128: , a24 out nocopy JTF_NUMBER_TABLE
129: , a25 out nocopy JTF_VARCHAR2_TABLE_100
130: , a26 out nocopy JTF_VARCHAR2_TABLE_100
131: , a27 out nocopy JTF_NUMBER_TABLE
132: , a28 out nocopy JTF_VARCHAR2_TABLE_100
133: , a29 out nocopy JTF_NUMBER_TABLE
134: , a30 out nocopy JTF_VARCHAR2_TABLE_100
135: , a31 out nocopy JTF_NUMBER_TABLE
136: , a32 out nocopy JTF_DATE_TABLE

Line 134: , a30 out nocopy JTF_VARCHAR2_TABLE_100

130: , a26 out nocopy JTF_VARCHAR2_TABLE_100
131: , a27 out nocopy JTF_NUMBER_TABLE
132: , a28 out nocopy JTF_VARCHAR2_TABLE_100
133: , a29 out nocopy JTF_NUMBER_TABLE
134: , a30 out nocopy JTF_VARCHAR2_TABLE_100
135: , a31 out nocopy JTF_NUMBER_TABLE
136: , a32 out nocopy JTF_DATE_TABLE
137: , a33 out nocopy JTF_NUMBER_TABLE
138: , a34 out nocopy JTF_DATE_TABLE

Line 159: , a55 out nocopy JTF_VARCHAR2_TABLE_100

155: , a51 out nocopy JTF_VARCHAR2_TABLE_300
156: , a52 out nocopy JTF_VARCHAR2_TABLE_300
157: , a53 out nocopy JTF_VARCHAR2_TABLE_300
158: , a54 out nocopy JTF_VARCHAR2_TABLE_300
159: , a55 out nocopy JTF_VARCHAR2_TABLE_100
160: , a56 out nocopy JTF_DATE_TABLE
161: );
162:
163: procedure create_offer_adj_line(p_api_version_number NUMBER