DBA Data[Home] [Help]

APPS.OKL_INS_QUOTE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_ins_quote_pvt_w as
2: /* $Header: OKLEINQS.pls 120.2 2005/09/19 11:35:46 pagarg noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ins_quote_pvt.ipyv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_600
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_300

Line 11: , a8 JTF_VARCHAR2_TABLE_100

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

Line 17: , a14 JTF_VARCHAR2_TABLE_100

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

Line 18: , a15 JTF_VARCHAR2_TABLE_100

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_DATE_TABLE

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_DATE_TABLE

Line 20: , a17 JTF_VARCHAR2_TABLE_100

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

Line 21: , a18 JTF_VARCHAR2_TABLE_100

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

Line 30: , a27 JTF_VARCHAR2_TABLE_100

26: , a23 JTF_DATE_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100

Line 31: , a28 JTF_VARCHAR2_TABLE_100

27: , a24 JTF_DATE_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100

Line 32: , a29 JTF_VARCHAR2_TABLE_100

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

Line 33: , a30 JTF_VARCHAR2_TABLE_100

29: , a26 JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE

Line 34: , a31 JTF_VARCHAR2_TABLE_100

30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE

Line 35: , a32 JTF_VARCHAR2_TABLE_100

31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE

Line 43: , a40 JTF_VARCHAR2_TABLE_100

39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_300
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE

Line 45: , a42 JTF_VARCHAR2_TABLE_100

41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_300
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_NUMBER_TABLE
49: , a46 JTF_NUMBER_TABLE

Line 50: , a47 JTF_VARCHAR2_TABLE_100

46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_NUMBER_TABLE
49: , a46 JTF_NUMBER_TABLE
50: , a47 JTF_VARCHAR2_TABLE_100
51: , a48 JTF_VARCHAR2_TABLE_100
52: , a49 JTF_VARCHAR2_TABLE_500
53: , a50 JTF_VARCHAR2_TABLE_500
54: , a51 JTF_VARCHAR2_TABLE_500

Line 51: , a48 JTF_VARCHAR2_TABLE_100

47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_NUMBER_TABLE
49: , a46 JTF_NUMBER_TABLE
50: , a47 JTF_VARCHAR2_TABLE_100
51: , a48 JTF_VARCHAR2_TABLE_100
52: , a49 JTF_VARCHAR2_TABLE_500
53: , a50 JTF_VARCHAR2_TABLE_500
54: , a51 JTF_VARCHAR2_TABLE_500
55: , a52 JTF_VARCHAR2_TABLE_500

Line 81: , a1 out nocopy JTF_VARCHAR2_TABLE_100

77: , a74 JTF_NUMBER_TABLE
78: , a75 JTF_NUMBER_TABLE
79: );
80: procedure rosetta_table_copy_out_p1(t okl_ins_quote_pvt.ipyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_VARCHAR2_TABLE_100
82: , a2 out nocopy JTF_VARCHAR2_TABLE_300
83: , a3 out nocopy JTF_VARCHAR2_TABLE_600
84: , a4 out nocopy JTF_VARCHAR2_TABLE_300
85: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 88: , a8 out nocopy JTF_VARCHAR2_TABLE_100

84: , a4 out nocopy JTF_VARCHAR2_TABLE_300
85: , a5 out nocopy JTF_VARCHAR2_TABLE_300
86: , a6 out nocopy JTF_VARCHAR2_TABLE_300
87: , a7 out nocopy JTF_VARCHAR2_TABLE_300
88: , a8 out nocopy JTF_VARCHAR2_TABLE_100
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_NUMBER_TABLE

Line 94: , a14 out nocopy JTF_VARCHAR2_TABLE_100

90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_NUMBER_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 95: , a15 out nocopy JTF_VARCHAR2_TABLE_100

91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_NUMBER_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: , a19 out nocopy JTF_DATE_TABLE

Line 96: , a16 out nocopy JTF_VARCHAR2_TABLE_100

92: , a12 out nocopy JTF_NUMBER_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: , a19 out nocopy JTF_DATE_TABLE
100: , a20 out nocopy JTF_DATE_TABLE

Line 97: , a17 out nocopy JTF_VARCHAR2_TABLE_100

93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: , a19 out nocopy JTF_DATE_TABLE
100: , a20 out nocopy JTF_DATE_TABLE
101: , a21 out nocopy JTF_DATE_TABLE

Line 98: , a18 out nocopy JTF_VARCHAR2_TABLE_100

94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: , a19 out nocopy JTF_DATE_TABLE
100: , a20 out nocopy JTF_DATE_TABLE
101: , a21 out nocopy JTF_DATE_TABLE
102: , a22 out nocopy JTF_DATE_TABLE

Line 107: , a27 out nocopy JTF_VARCHAR2_TABLE_100

103: , a23 out nocopy JTF_DATE_TABLE
104: , a24 out nocopy JTF_DATE_TABLE
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_VARCHAR2_TABLE_100
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , a28 out nocopy JTF_VARCHAR2_TABLE_100

104: , a24 out nocopy JTF_DATE_TABLE
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_VARCHAR2_TABLE_100
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100
112: , a32 out nocopy JTF_VARCHAR2_TABLE_100

Line 109: , a29 out nocopy JTF_VARCHAR2_TABLE_100

105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_VARCHAR2_TABLE_100
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100
112: , a32 out nocopy JTF_VARCHAR2_TABLE_100
113: , a33 out nocopy JTF_NUMBER_TABLE

Line 110: , a30 out nocopy JTF_VARCHAR2_TABLE_100

106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_VARCHAR2_TABLE_100
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100
112: , a32 out nocopy JTF_VARCHAR2_TABLE_100
113: , a33 out nocopy JTF_NUMBER_TABLE
114: , a34 out nocopy JTF_NUMBER_TABLE

Line 111: , a31 out nocopy JTF_VARCHAR2_TABLE_100

107: , a27 out nocopy JTF_VARCHAR2_TABLE_100
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100
112: , a32 out nocopy JTF_VARCHAR2_TABLE_100
113: , a33 out nocopy JTF_NUMBER_TABLE
114: , a34 out nocopy JTF_NUMBER_TABLE
115: , a35 out nocopy JTF_NUMBER_TABLE

Line 112: , a32 out nocopy JTF_VARCHAR2_TABLE_100

108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: , a30 out nocopy JTF_VARCHAR2_TABLE_100
111: , a31 out nocopy JTF_VARCHAR2_TABLE_100
112: , a32 out nocopy JTF_VARCHAR2_TABLE_100
113: , a33 out nocopy JTF_NUMBER_TABLE
114: , a34 out nocopy JTF_NUMBER_TABLE
115: , a35 out nocopy JTF_NUMBER_TABLE
116: , a36 out nocopy JTF_NUMBER_TABLE

Line 120: , a40 out nocopy JTF_VARCHAR2_TABLE_100

116: , a36 out nocopy JTF_NUMBER_TABLE
117: , a37 out nocopy JTF_NUMBER_TABLE
118: , a38 out nocopy JTF_NUMBER_TABLE
119: , a39 out nocopy JTF_VARCHAR2_TABLE_300
120: , a40 out nocopy JTF_VARCHAR2_TABLE_100
121: , a41 out nocopy JTF_NUMBER_TABLE
122: , a42 out nocopy JTF_VARCHAR2_TABLE_100
123: , a43 out nocopy JTF_NUMBER_TABLE
124: , a44 out nocopy JTF_NUMBER_TABLE

Line 122: , a42 out nocopy JTF_VARCHAR2_TABLE_100

118: , a38 out nocopy JTF_NUMBER_TABLE
119: , a39 out nocopy JTF_VARCHAR2_TABLE_300
120: , a40 out nocopy JTF_VARCHAR2_TABLE_100
121: , a41 out nocopy JTF_NUMBER_TABLE
122: , a42 out nocopy JTF_VARCHAR2_TABLE_100
123: , a43 out nocopy JTF_NUMBER_TABLE
124: , a44 out nocopy JTF_NUMBER_TABLE
125: , a45 out nocopy JTF_NUMBER_TABLE
126: , a46 out nocopy JTF_NUMBER_TABLE

Line 127: , a47 out nocopy JTF_VARCHAR2_TABLE_100

123: , a43 out nocopy JTF_NUMBER_TABLE
124: , a44 out nocopy JTF_NUMBER_TABLE
125: , a45 out nocopy JTF_NUMBER_TABLE
126: , a46 out nocopy JTF_NUMBER_TABLE
127: , a47 out nocopy JTF_VARCHAR2_TABLE_100
128: , a48 out nocopy JTF_VARCHAR2_TABLE_100
129: , a49 out nocopy JTF_VARCHAR2_TABLE_500
130: , a50 out nocopy JTF_VARCHAR2_TABLE_500
131: , a51 out nocopy JTF_VARCHAR2_TABLE_500

Line 128: , a48 out nocopy JTF_VARCHAR2_TABLE_100

124: , a44 out nocopy JTF_NUMBER_TABLE
125: , a45 out nocopy JTF_NUMBER_TABLE
126: , a46 out nocopy JTF_NUMBER_TABLE
127: , a47 out nocopy JTF_VARCHAR2_TABLE_100
128: , a48 out nocopy JTF_VARCHAR2_TABLE_100
129: , a49 out nocopy JTF_VARCHAR2_TABLE_500
130: , a50 out nocopy JTF_VARCHAR2_TABLE_500
131: , a51 out nocopy JTF_VARCHAR2_TABLE_500
132: , a52 out nocopy JTF_VARCHAR2_TABLE_500

Line 165: , a7 JTF_VARCHAR2_TABLE_100

161: , a3 JTF_NUMBER_TABLE
162: , a4 JTF_NUMBER_TABLE
163: , a5 JTF_NUMBER_TABLE
164: , a6 JTF_NUMBER_TABLE
165: , a7 JTF_VARCHAR2_TABLE_100
166: , a8 JTF_VARCHAR2_TABLE_500
167: , a9 JTF_VARCHAR2_TABLE_500
168: , a10 JTF_VARCHAR2_TABLE_500
169: , a11 JTF_VARCHAR2_TABLE_500

Line 199: , a7 out nocopy JTF_VARCHAR2_TABLE_100

195: , a3 out nocopy JTF_NUMBER_TABLE
196: , a4 out nocopy JTF_NUMBER_TABLE
197: , a5 out nocopy JTF_NUMBER_TABLE
198: , a6 out nocopy JTF_NUMBER_TABLE
199: , a7 out nocopy JTF_VARCHAR2_TABLE_100
200: , a8 out nocopy JTF_VARCHAR2_TABLE_500
201: , a9 out nocopy JTF_VARCHAR2_TABLE_500
202: , a10 out nocopy JTF_VARCHAR2_TABLE_500
203: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 236: procedure rosetta_table_copy_in_p7(t out nocopy okl_ins_quote_pvt.policy_tbl_type, a0 JTF_VARCHAR2_TABLE_100

232: , a1 out nocopy JTF_NUMBER_TABLE
233: , a2 out nocopy JTF_NUMBER_TABLE
234: );
235:
236: procedure rosetta_table_copy_in_p7(t out nocopy okl_ins_quote_pvt.policy_tbl_type, a0 JTF_VARCHAR2_TABLE_100
237: , a1 JTF_VARCHAR2_TABLE_200
238: );
239: procedure rosetta_table_copy_out_p7(t okl_ins_quote_pvt.policy_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
240: , a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 239: procedure rosetta_table_copy_out_p7(t okl_ins_quote_pvt.policy_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

235:
236: procedure rosetta_table_copy_in_p7(t out nocopy okl_ins_quote_pvt.policy_tbl_type, a0 JTF_VARCHAR2_TABLE_100
237: , a1 JTF_VARCHAR2_TABLE_200
238: );
239: procedure rosetta_table_copy_out_p7(t okl_ins_quote_pvt.policy_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
240: , a1 out nocopy JTF_VARCHAR2_TABLE_200
241: );
242:
243: procedure rosetta_table_copy_in_p9(t out nocopy okl_ins_quote_pvt.payment_tbl_type, a0 JTF_NUMBER_TABLE