DBA Data[Home] [Help]

APPS.OZF_OFFER_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE

1: package ozf_offer_pvt_w AUTHID CURRENT_USER as
2: /* $Header: ozfwofrs.pls 120.14 2011/03/14 05:13:57 nirprasa ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: );

Line 4: , a1 JTF_NUMBER_TABLE

1: package ozf_offer_pvt_w AUTHID CURRENT_USER as
2: /* $Header: ozfwofrs.pls 120.14 2011/03/14 05:13:57 nirprasa ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package ozf_offer_pvt_w AUTHID CURRENT_USER as
2: /* $Header: ozfwofrs.pls 120.14 2011/03/14 05:13:57 nirprasa ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: ozfwofrs.pls 120.14 2011/03/14 05:13:57 nirprasa ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_NUMBER_TABLE
10: , a2 out nocopy JTF_NUMBER_TABLE

Line 8: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_NUMBER_TABLE
10: , a2 out nocopy JTF_NUMBER_TABLE
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );

Line 9: , a1 out nocopy JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_NUMBER_TABLE
10: , a2 out nocopy JTF_NUMBER_TABLE
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
13:

Line 10: , a2 out nocopy JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_NUMBER_TABLE
10: , a2 out nocopy JTF_NUMBER_TABLE
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
13:
14: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100

Line 11: , a3 out nocopy JTF_NUMBER_TABLE

7: );
8: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_NUMBER_TABLE
10: , a2 out nocopy JTF_NUMBER_TABLE
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
13:
14: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
15: , a1 JTF_VARCHAR2_TABLE_100

Line 16: , a2 JTF_NUMBER_TABLE

12: );
13:
14: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
15: , a1 JTF_VARCHAR2_TABLE_100
16: , a2 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_NUMBER_TABLE
19: , a5 JTF_VARCHAR2_TABLE_100
20: , a6 JTF_NUMBER_TABLE

Line 18: , a4 JTF_NUMBER_TABLE

14: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
15: , a1 JTF_VARCHAR2_TABLE_100
16: , a2 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_NUMBER_TABLE
19: , a5 JTF_VARCHAR2_TABLE_100
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_DATE_TABLE
22: , a8 JTF_DATE_TABLE

Line 20: , a6 JTF_NUMBER_TABLE

16: , a2 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_NUMBER_TABLE
19: , a5 JTF_VARCHAR2_TABLE_100
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_DATE_TABLE
22: , a8 JTF_DATE_TABLE
23: , a9 JTF_VARCHAR2_TABLE_100
24: , a10 JTF_VARCHAR2_TABLE_100

Line 25: , a11 JTF_NUMBER_TABLE

21: , a7 JTF_DATE_TABLE
22: , a8 JTF_DATE_TABLE
23: , a9 JTF_VARCHAR2_TABLE_100
24: , a10 JTF_VARCHAR2_TABLE_100
25: , a11 JTF_NUMBER_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_NUMBER_TABLE
28: , a14 JTF_NUMBER_TABLE
29: , a15 JTF_VARCHAR2_TABLE_100

Line 27: , a13 JTF_NUMBER_TABLE

23: , a9 JTF_VARCHAR2_TABLE_100
24: , a10 JTF_VARCHAR2_TABLE_100
25: , a11 JTF_NUMBER_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_NUMBER_TABLE
28: , a14 JTF_NUMBER_TABLE
29: , a15 JTF_VARCHAR2_TABLE_100
30: , a16 JTF_NUMBER_TABLE
31: , a17 JTF_VARCHAR2_TABLE_100

Line 28: , a14 JTF_NUMBER_TABLE

24: , a10 JTF_VARCHAR2_TABLE_100
25: , a11 JTF_NUMBER_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_NUMBER_TABLE
28: , a14 JTF_NUMBER_TABLE
29: , a15 JTF_VARCHAR2_TABLE_100
30: , a16 JTF_NUMBER_TABLE
31: , a17 JTF_VARCHAR2_TABLE_100
32: , a18 JTF_NUMBER_TABLE

Line 30: , a16 JTF_NUMBER_TABLE

26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_NUMBER_TABLE
28: , a14 JTF_NUMBER_TABLE
29: , a15 JTF_VARCHAR2_TABLE_100
30: , a16 JTF_NUMBER_TABLE
31: , a17 JTF_VARCHAR2_TABLE_100
32: , a18 JTF_NUMBER_TABLE
33: , a19 JTF_NUMBER_TABLE
34: , a20 JTF_NUMBER_TABLE

Line 32: , a18 JTF_NUMBER_TABLE

28: , a14 JTF_NUMBER_TABLE
29: , a15 JTF_VARCHAR2_TABLE_100
30: , a16 JTF_NUMBER_TABLE
31: , a17 JTF_VARCHAR2_TABLE_100
32: , a18 JTF_NUMBER_TABLE
33: , a19 JTF_NUMBER_TABLE
34: , a20 JTF_NUMBER_TABLE
35: , a21 JTF_NUMBER_TABLE
36: , a22 JTF_VARCHAR2_TABLE_100

Line 33: , a19 JTF_NUMBER_TABLE

29: , a15 JTF_VARCHAR2_TABLE_100
30: , a16 JTF_NUMBER_TABLE
31: , a17 JTF_VARCHAR2_TABLE_100
32: , a18 JTF_NUMBER_TABLE
33: , a19 JTF_NUMBER_TABLE
34: , a20 JTF_NUMBER_TABLE
35: , a21 JTF_NUMBER_TABLE
36: , a22 JTF_VARCHAR2_TABLE_100
37: , a23 JTF_VARCHAR2_TABLE_100

Line 34: , a20 JTF_NUMBER_TABLE

30: , a16 JTF_NUMBER_TABLE
31: , a17 JTF_VARCHAR2_TABLE_100
32: , a18 JTF_NUMBER_TABLE
33: , a19 JTF_NUMBER_TABLE
34: , a20 JTF_NUMBER_TABLE
35: , a21 JTF_NUMBER_TABLE
36: , a22 JTF_VARCHAR2_TABLE_100
37: , a23 JTF_VARCHAR2_TABLE_100
38: , a24 JTF_VARCHAR2_TABLE_100

Line 35: , a21 JTF_NUMBER_TABLE

31: , a17 JTF_VARCHAR2_TABLE_100
32: , a18 JTF_NUMBER_TABLE
33: , a19 JTF_NUMBER_TABLE
34: , a20 JTF_NUMBER_TABLE
35: , a21 JTF_NUMBER_TABLE
36: , a22 JTF_VARCHAR2_TABLE_100
37: , a23 JTF_VARCHAR2_TABLE_100
38: , a24 JTF_VARCHAR2_TABLE_100
39: , a25 JTF_VARCHAR2_TABLE_300

Line 41: , a27 JTF_NUMBER_TABLE

37: , a23 JTF_VARCHAR2_TABLE_100
38: , a24 JTF_VARCHAR2_TABLE_100
39: , a25 JTF_VARCHAR2_TABLE_300
40: , a26 JTF_VARCHAR2_TABLE_100
41: , a27 JTF_NUMBER_TABLE
42: , a28 JTF_VARCHAR2_TABLE_100
43: , a29 JTF_VARCHAR2_TABLE_100
44: , a30 JTF_VARCHAR2_TABLE_300
45: , a31 JTF_VARCHAR2_TABLE_100

Line 53: , a39 JTF_NUMBER_TABLE

49: , a35 JTF_VARCHAR2_TABLE_300
50: , a36 JTF_VARCHAR2_TABLE_100
51: , a37 JTF_VARCHAR2_TABLE_300
52: , a38 JTF_VARCHAR2_TABLE_300
53: , a39 JTF_NUMBER_TABLE
54: , a40 JTF_VARCHAR2_TABLE_2000
55: , a41 JTF_VARCHAR2_TABLE_100
56: , a42 JTF_VARCHAR2_TABLE_300
57: , a43 JTF_VARCHAR2_TABLE_300

Line 71: , a57 JTF_NUMBER_TABLE

67: , a53 JTF_VARCHAR2_TABLE_300
68: , a54 JTF_VARCHAR2_TABLE_300
69: , a55 JTF_VARCHAR2_TABLE_300
70: , a56 JTF_VARCHAR2_TABLE_300
71: , a57 JTF_NUMBER_TABLE
72: , a58 JTF_NUMBER_TABLE
73: , a59 JTF_NUMBER_TABLE
74: , a60 JTF_NUMBER_TABLE
75: , a61 JTF_NUMBER_TABLE

Line 72: , a58 JTF_NUMBER_TABLE

68: , a54 JTF_VARCHAR2_TABLE_300
69: , a55 JTF_VARCHAR2_TABLE_300
70: , a56 JTF_VARCHAR2_TABLE_300
71: , a57 JTF_NUMBER_TABLE
72: , a58 JTF_NUMBER_TABLE
73: , a59 JTF_NUMBER_TABLE
74: , a60 JTF_NUMBER_TABLE
75: , a61 JTF_NUMBER_TABLE
76: , a62 JTF_NUMBER_TABLE

Line 73: , a59 JTF_NUMBER_TABLE

69: , a55 JTF_VARCHAR2_TABLE_300
70: , a56 JTF_VARCHAR2_TABLE_300
71: , a57 JTF_NUMBER_TABLE
72: , a58 JTF_NUMBER_TABLE
73: , a59 JTF_NUMBER_TABLE
74: , a60 JTF_NUMBER_TABLE
75: , a61 JTF_NUMBER_TABLE
76: , a62 JTF_NUMBER_TABLE
77: , a63 JTF_NUMBER_TABLE

Line 74: , a60 JTF_NUMBER_TABLE

70: , a56 JTF_VARCHAR2_TABLE_300
71: , a57 JTF_NUMBER_TABLE
72: , a58 JTF_NUMBER_TABLE
73: , a59 JTF_NUMBER_TABLE
74: , a60 JTF_NUMBER_TABLE
75: , a61 JTF_NUMBER_TABLE
76: , a62 JTF_NUMBER_TABLE
77: , a63 JTF_NUMBER_TABLE
78: , a64 JTF_NUMBER_TABLE

Line 75: , a61 JTF_NUMBER_TABLE

71: , a57 JTF_NUMBER_TABLE
72: , a58 JTF_NUMBER_TABLE
73: , a59 JTF_NUMBER_TABLE
74: , a60 JTF_NUMBER_TABLE
75: , a61 JTF_NUMBER_TABLE
76: , a62 JTF_NUMBER_TABLE
77: , a63 JTF_NUMBER_TABLE
78: , a64 JTF_NUMBER_TABLE
79: , a65 JTF_NUMBER_TABLE

Line 76: , a62 JTF_NUMBER_TABLE

72: , a58 JTF_NUMBER_TABLE
73: , a59 JTF_NUMBER_TABLE
74: , a60 JTF_NUMBER_TABLE
75: , a61 JTF_NUMBER_TABLE
76: , a62 JTF_NUMBER_TABLE
77: , a63 JTF_NUMBER_TABLE
78: , a64 JTF_NUMBER_TABLE
79: , a65 JTF_NUMBER_TABLE
80: , a66 JTF_NUMBER_TABLE

Line 77: , a63 JTF_NUMBER_TABLE

73: , a59 JTF_NUMBER_TABLE
74: , a60 JTF_NUMBER_TABLE
75: , a61 JTF_NUMBER_TABLE
76: , a62 JTF_NUMBER_TABLE
77: , a63 JTF_NUMBER_TABLE
78: , a64 JTF_NUMBER_TABLE
79: , a65 JTF_NUMBER_TABLE
80: , a66 JTF_NUMBER_TABLE
81: , a67 JTF_VARCHAR2_TABLE_100

Line 78: , a64 JTF_NUMBER_TABLE

74: , a60 JTF_NUMBER_TABLE
75: , a61 JTF_NUMBER_TABLE
76: , a62 JTF_NUMBER_TABLE
77: , a63 JTF_NUMBER_TABLE
78: , a64 JTF_NUMBER_TABLE
79: , a65 JTF_NUMBER_TABLE
80: , a66 JTF_NUMBER_TABLE
81: , a67 JTF_VARCHAR2_TABLE_100
82: , a68 JTF_NUMBER_TABLE

Line 79: , a65 JTF_NUMBER_TABLE

75: , a61 JTF_NUMBER_TABLE
76: , a62 JTF_NUMBER_TABLE
77: , a63 JTF_NUMBER_TABLE
78: , a64 JTF_NUMBER_TABLE
79: , a65 JTF_NUMBER_TABLE
80: , a66 JTF_NUMBER_TABLE
81: , a67 JTF_VARCHAR2_TABLE_100
82: , a68 JTF_NUMBER_TABLE
83: , a69 JTF_NUMBER_TABLE

Line 80: , a66 JTF_NUMBER_TABLE

76: , a62 JTF_NUMBER_TABLE
77: , a63 JTF_NUMBER_TABLE
78: , a64 JTF_NUMBER_TABLE
79: , a65 JTF_NUMBER_TABLE
80: , a66 JTF_NUMBER_TABLE
81: , a67 JTF_VARCHAR2_TABLE_100
82: , a68 JTF_NUMBER_TABLE
83: , a69 JTF_NUMBER_TABLE
84: , a70 JTF_VARCHAR2_TABLE_300

Line 82: , a68 JTF_NUMBER_TABLE

78: , a64 JTF_NUMBER_TABLE
79: , a65 JTF_NUMBER_TABLE
80: , a66 JTF_NUMBER_TABLE
81: , a67 JTF_VARCHAR2_TABLE_100
82: , a68 JTF_NUMBER_TABLE
83: , a69 JTF_NUMBER_TABLE
84: , a70 JTF_VARCHAR2_TABLE_300
85: , a71 JTF_VARCHAR2_TABLE_300
86: , a72 JTF_VARCHAR2_TABLE_300

Line 83: , a69 JTF_NUMBER_TABLE

79: , a65 JTF_NUMBER_TABLE
80: , a66 JTF_NUMBER_TABLE
81: , a67 JTF_VARCHAR2_TABLE_100
82: , a68 JTF_NUMBER_TABLE
83: , a69 JTF_NUMBER_TABLE
84: , a70 JTF_VARCHAR2_TABLE_300
85: , a71 JTF_VARCHAR2_TABLE_300
86: , a72 JTF_VARCHAR2_TABLE_300
87: );

Line 90: , a2 out nocopy JTF_NUMBER_TABLE

86: , a72 JTF_VARCHAR2_TABLE_300
87: );
88: procedure rosetta_table_copy_out_p4(t ozf_offer_pvt.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
89: , a1 out nocopy JTF_VARCHAR2_TABLE_100
90: , a2 out nocopy JTF_NUMBER_TABLE
91: , a3 out nocopy JTF_VARCHAR2_TABLE_100
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_NUMBER_TABLE

Line 92: , a4 out nocopy JTF_NUMBER_TABLE

88: procedure rosetta_table_copy_out_p4(t ozf_offer_pvt.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
89: , a1 out nocopy JTF_VARCHAR2_TABLE_100
90: , a2 out nocopy JTF_NUMBER_TABLE
91: , a3 out nocopy JTF_VARCHAR2_TABLE_100
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_NUMBER_TABLE
95: , a7 out nocopy JTF_DATE_TABLE
96: , a8 out nocopy JTF_DATE_TABLE

Line 94: , a6 out nocopy JTF_NUMBER_TABLE

90: , a2 out nocopy JTF_NUMBER_TABLE
91: , a3 out nocopy JTF_VARCHAR2_TABLE_100
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_NUMBER_TABLE
95: , a7 out nocopy JTF_DATE_TABLE
96: , a8 out nocopy JTF_DATE_TABLE
97: , a9 out nocopy JTF_VARCHAR2_TABLE_100
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 99: , a11 out nocopy JTF_NUMBER_TABLE

95: , a7 out nocopy JTF_DATE_TABLE
96: , a8 out nocopy JTF_DATE_TABLE
97: , a9 out nocopy JTF_VARCHAR2_TABLE_100
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_NUMBER_TABLE
100: , a12 out nocopy JTF_VARCHAR2_TABLE_100
101: , a13 out nocopy JTF_NUMBER_TABLE
102: , a14 out nocopy JTF_NUMBER_TABLE
103: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 101: , a13 out nocopy JTF_NUMBER_TABLE

97: , a9 out nocopy JTF_VARCHAR2_TABLE_100
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_NUMBER_TABLE
100: , a12 out nocopy JTF_VARCHAR2_TABLE_100
101: , a13 out nocopy JTF_NUMBER_TABLE
102: , a14 out nocopy JTF_NUMBER_TABLE
103: , a15 out nocopy JTF_VARCHAR2_TABLE_100
104: , a16 out nocopy JTF_NUMBER_TABLE
105: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 102: , a14 out nocopy JTF_NUMBER_TABLE

98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_NUMBER_TABLE
100: , a12 out nocopy JTF_VARCHAR2_TABLE_100
101: , a13 out nocopy JTF_NUMBER_TABLE
102: , a14 out nocopy JTF_NUMBER_TABLE
103: , a15 out nocopy JTF_VARCHAR2_TABLE_100
104: , a16 out nocopy JTF_NUMBER_TABLE
105: , a17 out nocopy JTF_VARCHAR2_TABLE_100
106: , a18 out nocopy JTF_NUMBER_TABLE

Line 104: , a16 out nocopy JTF_NUMBER_TABLE

100: , a12 out nocopy JTF_VARCHAR2_TABLE_100
101: , a13 out nocopy JTF_NUMBER_TABLE
102: , a14 out nocopy JTF_NUMBER_TABLE
103: , a15 out nocopy JTF_VARCHAR2_TABLE_100
104: , a16 out nocopy JTF_NUMBER_TABLE
105: , a17 out nocopy JTF_VARCHAR2_TABLE_100
106: , a18 out nocopy JTF_NUMBER_TABLE
107: , a19 out nocopy JTF_NUMBER_TABLE
108: , a20 out nocopy JTF_NUMBER_TABLE

Line 106: , a18 out nocopy JTF_NUMBER_TABLE

102: , a14 out nocopy JTF_NUMBER_TABLE
103: , a15 out nocopy JTF_VARCHAR2_TABLE_100
104: , a16 out nocopy JTF_NUMBER_TABLE
105: , a17 out nocopy JTF_VARCHAR2_TABLE_100
106: , a18 out nocopy JTF_NUMBER_TABLE
107: , a19 out nocopy JTF_NUMBER_TABLE
108: , a20 out nocopy JTF_NUMBER_TABLE
109: , a21 out nocopy JTF_NUMBER_TABLE
110: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 107: , a19 out nocopy JTF_NUMBER_TABLE

103: , a15 out nocopy JTF_VARCHAR2_TABLE_100
104: , a16 out nocopy JTF_NUMBER_TABLE
105: , a17 out nocopy JTF_VARCHAR2_TABLE_100
106: , a18 out nocopy JTF_NUMBER_TABLE
107: , a19 out nocopy JTF_NUMBER_TABLE
108: , a20 out nocopy JTF_NUMBER_TABLE
109: , a21 out nocopy JTF_NUMBER_TABLE
110: , a22 out nocopy JTF_VARCHAR2_TABLE_100
111: , a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , a20 out nocopy JTF_NUMBER_TABLE

104: , a16 out nocopy JTF_NUMBER_TABLE
105: , a17 out nocopy JTF_VARCHAR2_TABLE_100
106: , a18 out nocopy JTF_NUMBER_TABLE
107: , a19 out nocopy JTF_NUMBER_TABLE
108: , a20 out nocopy JTF_NUMBER_TABLE
109: , a21 out nocopy JTF_NUMBER_TABLE
110: , a22 out nocopy JTF_VARCHAR2_TABLE_100
111: , a23 out nocopy JTF_VARCHAR2_TABLE_100
112: , a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 109: , a21 out nocopy JTF_NUMBER_TABLE

105: , a17 out nocopy JTF_VARCHAR2_TABLE_100
106: , a18 out nocopy JTF_NUMBER_TABLE
107: , a19 out nocopy JTF_NUMBER_TABLE
108: , a20 out nocopy JTF_NUMBER_TABLE
109: , a21 out nocopy JTF_NUMBER_TABLE
110: , a22 out nocopy JTF_VARCHAR2_TABLE_100
111: , a23 out nocopy JTF_VARCHAR2_TABLE_100
112: , a24 out nocopy JTF_VARCHAR2_TABLE_100
113: , a25 out nocopy JTF_VARCHAR2_TABLE_300

Line 115: , a27 out nocopy JTF_NUMBER_TABLE

111: , a23 out nocopy JTF_VARCHAR2_TABLE_100
112: , a24 out nocopy JTF_VARCHAR2_TABLE_100
113: , a25 out nocopy JTF_VARCHAR2_TABLE_300
114: , a26 out nocopy JTF_VARCHAR2_TABLE_100
115: , a27 out nocopy JTF_NUMBER_TABLE
116: , a28 out nocopy JTF_VARCHAR2_TABLE_100
117: , a29 out nocopy JTF_VARCHAR2_TABLE_100
118: , a30 out nocopy JTF_VARCHAR2_TABLE_300
119: , a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 127: , a39 out nocopy JTF_NUMBER_TABLE

123: , a35 out nocopy JTF_VARCHAR2_TABLE_300
124: , a36 out nocopy JTF_VARCHAR2_TABLE_100
125: , a37 out nocopy JTF_VARCHAR2_TABLE_300
126: , a38 out nocopy JTF_VARCHAR2_TABLE_300
127: , a39 out nocopy JTF_NUMBER_TABLE
128: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
129: , a41 out nocopy JTF_VARCHAR2_TABLE_100
130: , a42 out nocopy JTF_VARCHAR2_TABLE_300
131: , a43 out nocopy JTF_VARCHAR2_TABLE_300

Line 145: , a57 out nocopy JTF_NUMBER_TABLE

141: , a53 out nocopy JTF_VARCHAR2_TABLE_300
142: , a54 out nocopy JTF_VARCHAR2_TABLE_300
143: , a55 out nocopy JTF_VARCHAR2_TABLE_300
144: , a56 out nocopy JTF_VARCHAR2_TABLE_300
145: , a57 out nocopy JTF_NUMBER_TABLE
146: , a58 out nocopy JTF_NUMBER_TABLE
147: , a59 out nocopy JTF_NUMBER_TABLE
148: , a60 out nocopy JTF_NUMBER_TABLE
149: , a61 out nocopy JTF_NUMBER_TABLE

Line 146: , a58 out nocopy JTF_NUMBER_TABLE

142: , a54 out nocopy JTF_VARCHAR2_TABLE_300
143: , a55 out nocopy JTF_VARCHAR2_TABLE_300
144: , a56 out nocopy JTF_VARCHAR2_TABLE_300
145: , a57 out nocopy JTF_NUMBER_TABLE
146: , a58 out nocopy JTF_NUMBER_TABLE
147: , a59 out nocopy JTF_NUMBER_TABLE
148: , a60 out nocopy JTF_NUMBER_TABLE
149: , a61 out nocopy JTF_NUMBER_TABLE
150: , a62 out nocopy JTF_NUMBER_TABLE

Line 147: , a59 out nocopy JTF_NUMBER_TABLE

143: , a55 out nocopy JTF_VARCHAR2_TABLE_300
144: , a56 out nocopy JTF_VARCHAR2_TABLE_300
145: , a57 out nocopy JTF_NUMBER_TABLE
146: , a58 out nocopy JTF_NUMBER_TABLE
147: , a59 out nocopy JTF_NUMBER_TABLE
148: , a60 out nocopy JTF_NUMBER_TABLE
149: , a61 out nocopy JTF_NUMBER_TABLE
150: , a62 out nocopy JTF_NUMBER_TABLE
151: , a63 out nocopy JTF_NUMBER_TABLE

Line 148: , a60 out nocopy JTF_NUMBER_TABLE

144: , a56 out nocopy JTF_VARCHAR2_TABLE_300
145: , a57 out nocopy JTF_NUMBER_TABLE
146: , a58 out nocopy JTF_NUMBER_TABLE
147: , a59 out nocopy JTF_NUMBER_TABLE
148: , a60 out nocopy JTF_NUMBER_TABLE
149: , a61 out nocopy JTF_NUMBER_TABLE
150: , a62 out nocopy JTF_NUMBER_TABLE
151: , a63 out nocopy JTF_NUMBER_TABLE
152: , a64 out nocopy JTF_NUMBER_TABLE

Line 149: , a61 out nocopy JTF_NUMBER_TABLE

145: , a57 out nocopy JTF_NUMBER_TABLE
146: , a58 out nocopy JTF_NUMBER_TABLE
147: , a59 out nocopy JTF_NUMBER_TABLE
148: , a60 out nocopy JTF_NUMBER_TABLE
149: , a61 out nocopy JTF_NUMBER_TABLE
150: , a62 out nocopy JTF_NUMBER_TABLE
151: , a63 out nocopy JTF_NUMBER_TABLE
152: , a64 out nocopy JTF_NUMBER_TABLE
153: , a65 out nocopy JTF_NUMBER_TABLE

Line 150: , a62 out nocopy JTF_NUMBER_TABLE

146: , a58 out nocopy JTF_NUMBER_TABLE
147: , a59 out nocopy JTF_NUMBER_TABLE
148: , a60 out nocopy JTF_NUMBER_TABLE
149: , a61 out nocopy JTF_NUMBER_TABLE
150: , a62 out nocopy JTF_NUMBER_TABLE
151: , a63 out nocopy JTF_NUMBER_TABLE
152: , a64 out nocopy JTF_NUMBER_TABLE
153: , a65 out nocopy JTF_NUMBER_TABLE
154: , a66 out nocopy JTF_NUMBER_TABLE

Line 151: , a63 out nocopy JTF_NUMBER_TABLE

147: , a59 out nocopy JTF_NUMBER_TABLE
148: , a60 out nocopy JTF_NUMBER_TABLE
149: , a61 out nocopy JTF_NUMBER_TABLE
150: , a62 out nocopy JTF_NUMBER_TABLE
151: , a63 out nocopy JTF_NUMBER_TABLE
152: , a64 out nocopy JTF_NUMBER_TABLE
153: , a65 out nocopy JTF_NUMBER_TABLE
154: , a66 out nocopy JTF_NUMBER_TABLE
155: , a67 out nocopy JTF_VARCHAR2_TABLE_100

Line 152: , a64 out nocopy JTF_NUMBER_TABLE

148: , a60 out nocopy JTF_NUMBER_TABLE
149: , a61 out nocopy JTF_NUMBER_TABLE
150: , a62 out nocopy JTF_NUMBER_TABLE
151: , a63 out nocopy JTF_NUMBER_TABLE
152: , a64 out nocopy JTF_NUMBER_TABLE
153: , a65 out nocopy JTF_NUMBER_TABLE
154: , a66 out nocopy JTF_NUMBER_TABLE
155: , a67 out nocopy JTF_VARCHAR2_TABLE_100
156: , a68 out nocopy JTF_NUMBER_TABLE

Line 153: , a65 out nocopy JTF_NUMBER_TABLE

149: , a61 out nocopy JTF_NUMBER_TABLE
150: , a62 out nocopy JTF_NUMBER_TABLE
151: , a63 out nocopy JTF_NUMBER_TABLE
152: , a64 out nocopy JTF_NUMBER_TABLE
153: , a65 out nocopy JTF_NUMBER_TABLE
154: , a66 out nocopy JTF_NUMBER_TABLE
155: , a67 out nocopy JTF_VARCHAR2_TABLE_100
156: , a68 out nocopy JTF_NUMBER_TABLE
157: , a69 out nocopy JTF_NUMBER_TABLE

Line 154: , a66 out nocopy JTF_NUMBER_TABLE

150: , a62 out nocopy JTF_NUMBER_TABLE
151: , a63 out nocopy JTF_NUMBER_TABLE
152: , a64 out nocopy JTF_NUMBER_TABLE
153: , a65 out nocopy JTF_NUMBER_TABLE
154: , a66 out nocopy JTF_NUMBER_TABLE
155: , a67 out nocopy JTF_VARCHAR2_TABLE_100
156: , a68 out nocopy JTF_NUMBER_TABLE
157: , a69 out nocopy JTF_NUMBER_TABLE
158: , a70 out nocopy JTF_VARCHAR2_TABLE_300

Line 156: , a68 out nocopy JTF_NUMBER_TABLE

152: , a64 out nocopy JTF_NUMBER_TABLE
153: , a65 out nocopy JTF_NUMBER_TABLE
154: , a66 out nocopy JTF_NUMBER_TABLE
155: , a67 out nocopy JTF_VARCHAR2_TABLE_100
156: , a68 out nocopy JTF_NUMBER_TABLE
157: , a69 out nocopy JTF_NUMBER_TABLE
158: , a70 out nocopy JTF_VARCHAR2_TABLE_300
159: , a71 out nocopy JTF_VARCHAR2_TABLE_300
160: , a72 out nocopy JTF_VARCHAR2_TABLE_300

Line 157: , a69 out nocopy JTF_NUMBER_TABLE

153: , a65 out nocopy JTF_NUMBER_TABLE
154: , a66 out nocopy JTF_NUMBER_TABLE
155: , a67 out nocopy JTF_VARCHAR2_TABLE_100
156: , a68 out nocopy JTF_NUMBER_TABLE
157: , a69 out nocopy JTF_NUMBER_TABLE
158: , a70 out nocopy JTF_VARCHAR2_TABLE_300
159: , a71 out nocopy JTF_VARCHAR2_TABLE_300
160: , a72 out nocopy JTF_VARCHAR2_TABLE_300
161: );

Line 163: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE

159: , a71 out nocopy JTF_VARCHAR2_TABLE_300
160: , a72 out nocopy JTF_VARCHAR2_TABLE_300
161: );
162:
163: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_100
165: , a2 JTF_NUMBER_TABLE
166: , a3 JTF_VARCHAR2_TABLE_100
167: , a4 JTF_VARCHAR2_TABLE_100

Line 165: , a2 JTF_NUMBER_TABLE

161: );
162:
163: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_100
165: , a2 JTF_NUMBER_TABLE
166: , a3 JTF_VARCHAR2_TABLE_100
167: , a4 JTF_VARCHAR2_TABLE_100
168: , a5 JTF_VARCHAR2_TABLE_300
169: , a6 JTF_VARCHAR2_TABLE_100

Line 174: , a11 JTF_NUMBER_TABLE

170: , a7 JTF_VARCHAR2_TABLE_100
171: , a8 JTF_VARCHAR2_TABLE_100
172: , a9 JTF_VARCHAR2_TABLE_300
173: , a10 JTF_VARCHAR2_TABLE_300
174: , a11 JTF_NUMBER_TABLE
175: , a12 JTF_VARCHAR2_TABLE_100
176: );
177: procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 177: procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

173: , a10 JTF_VARCHAR2_TABLE_300
174: , a11 JTF_NUMBER_TABLE
175: , a12 JTF_VARCHAR2_TABLE_100
176: );
177: procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_VARCHAR2_TABLE_100
179: , a2 out nocopy JTF_NUMBER_TABLE
180: , a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 179: , a2 out nocopy JTF_NUMBER_TABLE

175: , a12 JTF_VARCHAR2_TABLE_100
176: );
177: procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_VARCHAR2_TABLE_100
179: , a2 out nocopy JTF_NUMBER_TABLE
180: , a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , a4 out nocopy JTF_VARCHAR2_TABLE_100
182: , a5 out nocopy JTF_VARCHAR2_TABLE_300
183: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 188: , a11 out nocopy JTF_NUMBER_TABLE

184: , a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , a8 out nocopy JTF_VARCHAR2_TABLE_100
186: , a9 out nocopy JTF_VARCHAR2_TABLE_300
187: , a10 out nocopy JTF_VARCHAR2_TABLE_300
188: , a11 out nocopy JTF_NUMBER_TABLE
189: , a12 out nocopy JTF_VARCHAR2_TABLE_100
190: );
191:
192: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100

Line 197: , a5 JTF_NUMBER_TABLE

193: , a1 JTF_VARCHAR2_TABLE_100
194: , a2 JTF_VARCHAR2_TABLE_300
195: , a3 JTF_VARCHAR2_TABLE_300
196: , a4 JTF_VARCHAR2_TABLE_100
197: , a5 JTF_NUMBER_TABLE
198: , a6 JTF_NUMBER_TABLE
199: , a7 JTF_NUMBER_TABLE
200: , a8 JTF_NUMBER_TABLE
201: , a9 JTF_DATE_TABLE

Line 198: , a6 JTF_NUMBER_TABLE

194: , a2 JTF_VARCHAR2_TABLE_300
195: , a3 JTF_VARCHAR2_TABLE_300
196: , a4 JTF_VARCHAR2_TABLE_100
197: , a5 JTF_NUMBER_TABLE
198: , a6 JTF_NUMBER_TABLE
199: , a7 JTF_NUMBER_TABLE
200: , a8 JTF_NUMBER_TABLE
201: , a9 JTF_DATE_TABLE
202: , a10 JTF_DATE_TABLE

Line 199: , a7 JTF_NUMBER_TABLE

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

Line 200: , a8 JTF_NUMBER_TABLE

196: , a4 JTF_VARCHAR2_TABLE_100
197: , a5 JTF_NUMBER_TABLE
198: , a6 JTF_NUMBER_TABLE
199: , a7 JTF_NUMBER_TABLE
200: , a8 JTF_NUMBER_TABLE
201: , a9 JTF_DATE_TABLE
202: , a10 JTF_DATE_TABLE
203: , a11 JTF_NUMBER_TABLE
204: , a12 JTF_VARCHAR2_TABLE_100

Line 203: , a11 JTF_NUMBER_TABLE

199: , a7 JTF_NUMBER_TABLE
200: , a8 JTF_NUMBER_TABLE
201: , a9 JTF_DATE_TABLE
202: , a10 JTF_DATE_TABLE
203: , a11 JTF_NUMBER_TABLE
204: , a12 JTF_VARCHAR2_TABLE_100
205: , a13 JTF_VARCHAR2_TABLE_100
206: , a14 JTF_VARCHAR2_TABLE_300
207: , a15 JTF_VARCHAR2_TABLE_300

Line 227: , a5 out nocopy JTF_NUMBER_TABLE

223: , a1 out nocopy JTF_VARCHAR2_TABLE_100
224: , a2 out nocopy JTF_VARCHAR2_TABLE_300
225: , a3 out nocopy JTF_VARCHAR2_TABLE_300
226: , a4 out nocopy JTF_VARCHAR2_TABLE_100
227: , a5 out nocopy JTF_NUMBER_TABLE
228: , a6 out nocopy JTF_NUMBER_TABLE
229: , a7 out nocopy JTF_NUMBER_TABLE
230: , a8 out nocopy JTF_NUMBER_TABLE
231: , a9 out nocopy JTF_DATE_TABLE

Line 228: , a6 out nocopy JTF_NUMBER_TABLE

224: , a2 out nocopy JTF_VARCHAR2_TABLE_300
225: , a3 out nocopy JTF_VARCHAR2_TABLE_300
226: , a4 out nocopy JTF_VARCHAR2_TABLE_100
227: , a5 out nocopy JTF_NUMBER_TABLE
228: , a6 out nocopy JTF_NUMBER_TABLE
229: , a7 out nocopy JTF_NUMBER_TABLE
230: , a8 out nocopy JTF_NUMBER_TABLE
231: , a9 out nocopy JTF_DATE_TABLE
232: , a10 out nocopy JTF_DATE_TABLE

Line 229: , a7 out nocopy JTF_NUMBER_TABLE

225: , a3 out nocopy JTF_VARCHAR2_TABLE_300
226: , a4 out nocopy JTF_VARCHAR2_TABLE_100
227: , a5 out nocopy JTF_NUMBER_TABLE
228: , a6 out nocopy JTF_NUMBER_TABLE
229: , a7 out nocopy JTF_NUMBER_TABLE
230: , a8 out nocopy JTF_NUMBER_TABLE
231: , a9 out nocopy JTF_DATE_TABLE
232: , a10 out nocopy JTF_DATE_TABLE
233: , a11 out nocopy JTF_NUMBER_TABLE

Line 230: , a8 out nocopy JTF_NUMBER_TABLE

226: , a4 out nocopy JTF_VARCHAR2_TABLE_100
227: , a5 out nocopy JTF_NUMBER_TABLE
228: , a6 out nocopy JTF_NUMBER_TABLE
229: , a7 out nocopy JTF_NUMBER_TABLE
230: , a8 out nocopy JTF_NUMBER_TABLE
231: , a9 out nocopy JTF_DATE_TABLE
232: , a10 out nocopy JTF_DATE_TABLE
233: , a11 out nocopy JTF_NUMBER_TABLE
234: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 233: , a11 out nocopy JTF_NUMBER_TABLE

229: , a7 out nocopy JTF_NUMBER_TABLE
230: , a8 out nocopy JTF_NUMBER_TABLE
231: , a9 out nocopy JTF_DATE_TABLE
232: , a10 out nocopy JTF_DATE_TABLE
233: , a11 out nocopy JTF_NUMBER_TABLE
234: , a12 out nocopy JTF_VARCHAR2_TABLE_100
235: , a13 out nocopy JTF_VARCHAR2_TABLE_100
236: , a14 out nocopy JTF_VARCHAR2_TABLE_300
237: , a15 out nocopy JTF_VARCHAR2_TABLE_300

Line 262: , p8_a2 JTF_NUMBER_TABLE

258: , x_msg_data out nocopy VARCHAR2
259: , p_offer_type VARCHAR2
260: , p8_a0 JTF_VARCHAR2_TABLE_100
261: , p8_a1 JTF_VARCHAR2_TABLE_100
262: , p8_a2 JTF_NUMBER_TABLE
263: , p8_a3 JTF_VARCHAR2_TABLE_100
264: , p8_a4 JTF_NUMBER_TABLE
265: , p8_a5 JTF_VARCHAR2_TABLE_100
266: , p8_a6 JTF_NUMBER_TABLE

Line 264: , p8_a4 JTF_NUMBER_TABLE

260: , p8_a0 JTF_VARCHAR2_TABLE_100
261: , p8_a1 JTF_VARCHAR2_TABLE_100
262: , p8_a2 JTF_NUMBER_TABLE
263: , p8_a3 JTF_VARCHAR2_TABLE_100
264: , p8_a4 JTF_NUMBER_TABLE
265: , p8_a5 JTF_VARCHAR2_TABLE_100
266: , p8_a6 JTF_NUMBER_TABLE
267: , p8_a7 JTF_DATE_TABLE
268: , p8_a8 JTF_DATE_TABLE

Line 266: , p8_a6 JTF_NUMBER_TABLE

262: , p8_a2 JTF_NUMBER_TABLE
263: , p8_a3 JTF_VARCHAR2_TABLE_100
264: , p8_a4 JTF_NUMBER_TABLE
265: , p8_a5 JTF_VARCHAR2_TABLE_100
266: , p8_a6 JTF_NUMBER_TABLE
267: , p8_a7 JTF_DATE_TABLE
268: , p8_a8 JTF_DATE_TABLE
269: , p8_a9 JTF_VARCHAR2_TABLE_100
270: , p8_a10 JTF_VARCHAR2_TABLE_100

Line 271: , p8_a11 JTF_NUMBER_TABLE

267: , p8_a7 JTF_DATE_TABLE
268: , p8_a8 JTF_DATE_TABLE
269: , p8_a9 JTF_VARCHAR2_TABLE_100
270: , p8_a10 JTF_VARCHAR2_TABLE_100
271: , p8_a11 JTF_NUMBER_TABLE
272: , p8_a12 JTF_VARCHAR2_TABLE_100
273: , p8_a13 JTF_NUMBER_TABLE
274: , p8_a14 JTF_NUMBER_TABLE
275: , p8_a15 JTF_VARCHAR2_TABLE_100

Line 273: , p8_a13 JTF_NUMBER_TABLE

269: , p8_a9 JTF_VARCHAR2_TABLE_100
270: , p8_a10 JTF_VARCHAR2_TABLE_100
271: , p8_a11 JTF_NUMBER_TABLE
272: , p8_a12 JTF_VARCHAR2_TABLE_100
273: , p8_a13 JTF_NUMBER_TABLE
274: , p8_a14 JTF_NUMBER_TABLE
275: , p8_a15 JTF_VARCHAR2_TABLE_100
276: , p8_a16 JTF_NUMBER_TABLE
277: , p8_a17 JTF_VARCHAR2_TABLE_100

Line 274: , p8_a14 JTF_NUMBER_TABLE

270: , p8_a10 JTF_VARCHAR2_TABLE_100
271: , p8_a11 JTF_NUMBER_TABLE
272: , p8_a12 JTF_VARCHAR2_TABLE_100
273: , p8_a13 JTF_NUMBER_TABLE
274: , p8_a14 JTF_NUMBER_TABLE
275: , p8_a15 JTF_VARCHAR2_TABLE_100
276: , p8_a16 JTF_NUMBER_TABLE
277: , p8_a17 JTF_VARCHAR2_TABLE_100
278: , p8_a18 JTF_NUMBER_TABLE

Line 276: , p8_a16 JTF_NUMBER_TABLE

272: , p8_a12 JTF_VARCHAR2_TABLE_100
273: , p8_a13 JTF_NUMBER_TABLE
274: , p8_a14 JTF_NUMBER_TABLE
275: , p8_a15 JTF_VARCHAR2_TABLE_100
276: , p8_a16 JTF_NUMBER_TABLE
277: , p8_a17 JTF_VARCHAR2_TABLE_100
278: , p8_a18 JTF_NUMBER_TABLE
279: , p8_a19 JTF_NUMBER_TABLE
280: , p8_a20 JTF_NUMBER_TABLE

Line 278: , p8_a18 JTF_NUMBER_TABLE

274: , p8_a14 JTF_NUMBER_TABLE
275: , p8_a15 JTF_VARCHAR2_TABLE_100
276: , p8_a16 JTF_NUMBER_TABLE
277: , p8_a17 JTF_VARCHAR2_TABLE_100
278: , p8_a18 JTF_NUMBER_TABLE
279: , p8_a19 JTF_NUMBER_TABLE
280: , p8_a20 JTF_NUMBER_TABLE
281: , p8_a21 JTF_NUMBER_TABLE
282: , p8_a22 JTF_VARCHAR2_TABLE_100

Line 279: , p8_a19 JTF_NUMBER_TABLE

275: , p8_a15 JTF_VARCHAR2_TABLE_100
276: , p8_a16 JTF_NUMBER_TABLE
277: , p8_a17 JTF_VARCHAR2_TABLE_100
278: , p8_a18 JTF_NUMBER_TABLE
279: , p8_a19 JTF_NUMBER_TABLE
280: , p8_a20 JTF_NUMBER_TABLE
281: , p8_a21 JTF_NUMBER_TABLE
282: , p8_a22 JTF_VARCHAR2_TABLE_100
283: , p8_a23 JTF_VARCHAR2_TABLE_100

Line 280: , p8_a20 JTF_NUMBER_TABLE

276: , p8_a16 JTF_NUMBER_TABLE
277: , p8_a17 JTF_VARCHAR2_TABLE_100
278: , p8_a18 JTF_NUMBER_TABLE
279: , p8_a19 JTF_NUMBER_TABLE
280: , p8_a20 JTF_NUMBER_TABLE
281: , p8_a21 JTF_NUMBER_TABLE
282: , p8_a22 JTF_VARCHAR2_TABLE_100
283: , p8_a23 JTF_VARCHAR2_TABLE_100
284: , p8_a24 JTF_VARCHAR2_TABLE_100

Line 281: , p8_a21 JTF_NUMBER_TABLE

277: , p8_a17 JTF_VARCHAR2_TABLE_100
278: , p8_a18 JTF_NUMBER_TABLE
279: , p8_a19 JTF_NUMBER_TABLE
280: , p8_a20 JTF_NUMBER_TABLE
281: , p8_a21 JTF_NUMBER_TABLE
282: , p8_a22 JTF_VARCHAR2_TABLE_100
283: , p8_a23 JTF_VARCHAR2_TABLE_100
284: , p8_a24 JTF_VARCHAR2_TABLE_100
285: , p8_a25 JTF_VARCHAR2_TABLE_300

Line 287: , p8_a27 JTF_NUMBER_TABLE

283: , p8_a23 JTF_VARCHAR2_TABLE_100
284: , p8_a24 JTF_VARCHAR2_TABLE_100
285: , p8_a25 JTF_VARCHAR2_TABLE_300
286: , p8_a26 JTF_VARCHAR2_TABLE_100
287: , p8_a27 JTF_NUMBER_TABLE
288: , p8_a28 JTF_VARCHAR2_TABLE_100
289: , p8_a29 JTF_VARCHAR2_TABLE_100
290: , p8_a30 JTF_VARCHAR2_TABLE_300
291: , p8_a31 JTF_VARCHAR2_TABLE_100

Line 299: , p8_a39 JTF_NUMBER_TABLE

295: , p8_a35 JTF_VARCHAR2_TABLE_300
296: , p8_a36 JTF_VARCHAR2_TABLE_100
297: , p8_a37 JTF_VARCHAR2_TABLE_300
298: , p8_a38 JTF_VARCHAR2_TABLE_300
299: , p8_a39 JTF_NUMBER_TABLE
300: , p8_a40 JTF_VARCHAR2_TABLE_2000
301: , p8_a41 JTF_VARCHAR2_TABLE_100
302: , p8_a42 JTF_VARCHAR2_TABLE_300
303: , p8_a43 JTF_VARCHAR2_TABLE_300

Line 317: , p8_a57 JTF_NUMBER_TABLE

313: , p8_a53 JTF_VARCHAR2_TABLE_300
314: , p8_a54 JTF_VARCHAR2_TABLE_300
315: , p8_a55 JTF_VARCHAR2_TABLE_300
316: , p8_a56 JTF_VARCHAR2_TABLE_300
317: , p8_a57 JTF_NUMBER_TABLE
318: , p8_a58 JTF_NUMBER_TABLE
319: , p8_a59 JTF_NUMBER_TABLE
320: , p8_a60 JTF_NUMBER_TABLE
321: , p8_a61 JTF_NUMBER_TABLE

Line 318: , p8_a58 JTF_NUMBER_TABLE

314: , p8_a54 JTF_VARCHAR2_TABLE_300
315: , p8_a55 JTF_VARCHAR2_TABLE_300
316: , p8_a56 JTF_VARCHAR2_TABLE_300
317: , p8_a57 JTF_NUMBER_TABLE
318: , p8_a58 JTF_NUMBER_TABLE
319: , p8_a59 JTF_NUMBER_TABLE
320: , p8_a60 JTF_NUMBER_TABLE
321: , p8_a61 JTF_NUMBER_TABLE
322: , p8_a62 JTF_NUMBER_TABLE

Line 319: , p8_a59 JTF_NUMBER_TABLE

315: , p8_a55 JTF_VARCHAR2_TABLE_300
316: , p8_a56 JTF_VARCHAR2_TABLE_300
317: , p8_a57 JTF_NUMBER_TABLE
318: , p8_a58 JTF_NUMBER_TABLE
319: , p8_a59 JTF_NUMBER_TABLE
320: , p8_a60 JTF_NUMBER_TABLE
321: , p8_a61 JTF_NUMBER_TABLE
322: , p8_a62 JTF_NUMBER_TABLE
323: , p8_a63 JTF_NUMBER_TABLE

Line 320: , p8_a60 JTF_NUMBER_TABLE

316: , p8_a56 JTF_VARCHAR2_TABLE_300
317: , p8_a57 JTF_NUMBER_TABLE
318: , p8_a58 JTF_NUMBER_TABLE
319: , p8_a59 JTF_NUMBER_TABLE
320: , p8_a60 JTF_NUMBER_TABLE
321: , p8_a61 JTF_NUMBER_TABLE
322: , p8_a62 JTF_NUMBER_TABLE
323: , p8_a63 JTF_NUMBER_TABLE
324: , p8_a64 JTF_NUMBER_TABLE

Line 321: , p8_a61 JTF_NUMBER_TABLE

317: , p8_a57 JTF_NUMBER_TABLE
318: , p8_a58 JTF_NUMBER_TABLE
319: , p8_a59 JTF_NUMBER_TABLE
320: , p8_a60 JTF_NUMBER_TABLE
321: , p8_a61 JTF_NUMBER_TABLE
322: , p8_a62 JTF_NUMBER_TABLE
323: , p8_a63 JTF_NUMBER_TABLE
324: , p8_a64 JTF_NUMBER_TABLE
325: , p8_a65 JTF_NUMBER_TABLE

Line 322: , p8_a62 JTF_NUMBER_TABLE

318: , p8_a58 JTF_NUMBER_TABLE
319: , p8_a59 JTF_NUMBER_TABLE
320: , p8_a60 JTF_NUMBER_TABLE
321: , p8_a61 JTF_NUMBER_TABLE
322: , p8_a62 JTF_NUMBER_TABLE
323: , p8_a63 JTF_NUMBER_TABLE
324: , p8_a64 JTF_NUMBER_TABLE
325: , p8_a65 JTF_NUMBER_TABLE
326: , p8_a66 JTF_NUMBER_TABLE

Line 323: , p8_a63 JTF_NUMBER_TABLE

319: , p8_a59 JTF_NUMBER_TABLE
320: , p8_a60 JTF_NUMBER_TABLE
321: , p8_a61 JTF_NUMBER_TABLE
322: , p8_a62 JTF_NUMBER_TABLE
323: , p8_a63 JTF_NUMBER_TABLE
324: , p8_a64 JTF_NUMBER_TABLE
325: , p8_a65 JTF_NUMBER_TABLE
326: , p8_a66 JTF_NUMBER_TABLE
327: , p8_a67 JTF_VARCHAR2_TABLE_100

Line 324: , p8_a64 JTF_NUMBER_TABLE

320: , p8_a60 JTF_NUMBER_TABLE
321: , p8_a61 JTF_NUMBER_TABLE
322: , p8_a62 JTF_NUMBER_TABLE
323: , p8_a63 JTF_NUMBER_TABLE
324: , p8_a64 JTF_NUMBER_TABLE
325: , p8_a65 JTF_NUMBER_TABLE
326: , p8_a66 JTF_NUMBER_TABLE
327: , p8_a67 JTF_VARCHAR2_TABLE_100
328: , p8_a68 JTF_NUMBER_TABLE

Line 325: , p8_a65 JTF_NUMBER_TABLE

321: , p8_a61 JTF_NUMBER_TABLE
322: , p8_a62 JTF_NUMBER_TABLE
323: , p8_a63 JTF_NUMBER_TABLE
324: , p8_a64 JTF_NUMBER_TABLE
325: , p8_a65 JTF_NUMBER_TABLE
326: , p8_a66 JTF_NUMBER_TABLE
327: , p8_a67 JTF_VARCHAR2_TABLE_100
328: , p8_a68 JTF_NUMBER_TABLE
329: , p8_a69 JTF_NUMBER_TABLE

Line 326: , p8_a66 JTF_NUMBER_TABLE

322: , p8_a62 JTF_NUMBER_TABLE
323: , p8_a63 JTF_NUMBER_TABLE
324: , p8_a64 JTF_NUMBER_TABLE
325: , p8_a65 JTF_NUMBER_TABLE
326: , p8_a66 JTF_NUMBER_TABLE
327: , p8_a67 JTF_VARCHAR2_TABLE_100
328: , p8_a68 JTF_NUMBER_TABLE
329: , p8_a69 JTF_NUMBER_TABLE
330: , p8_a70 JTF_VARCHAR2_TABLE_300

Line 328: , p8_a68 JTF_NUMBER_TABLE

324: , p8_a64 JTF_NUMBER_TABLE
325: , p8_a65 JTF_NUMBER_TABLE
326: , p8_a66 JTF_NUMBER_TABLE
327: , p8_a67 JTF_VARCHAR2_TABLE_100
328: , p8_a68 JTF_NUMBER_TABLE
329: , p8_a69 JTF_NUMBER_TABLE
330: , p8_a70 JTF_VARCHAR2_TABLE_300
331: , p8_a71 JTF_VARCHAR2_TABLE_300
332: , p8_a72 JTF_VARCHAR2_TABLE_300

Line 329: , p8_a69 JTF_NUMBER_TABLE

325: , p8_a65 JTF_NUMBER_TABLE
326: , p8_a66 JTF_NUMBER_TABLE
327: , p8_a67 JTF_VARCHAR2_TABLE_100
328: , p8_a68 JTF_NUMBER_TABLE
329: , p8_a69 JTF_NUMBER_TABLE
330: , p8_a70 JTF_VARCHAR2_TABLE_300
331: , p8_a71 JTF_VARCHAR2_TABLE_300
332: , p8_a72 JTF_VARCHAR2_TABLE_300
333: , x_qp_list_header_id out nocopy NUMBER

Line 430: , p6_a2 JTF_NUMBER_TABLE

426: , x_msg_count out nocopy NUMBER
427: , x_msg_data out nocopy VARCHAR2
428: , p6_a0 JTF_VARCHAR2_TABLE_100
429: , p6_a1 JTF_VARCHAR2_TABLE_100
430: , p6_a2 JTF_NUMBER_TABLE
431: , p6_a3 JTF_VARCHAR2_TABLE_100
432: , p6_a4 JTF_NUMBER_TABLE
433: , p6_a5 JTF_VARCHAR2_TABLE_100
434: , p6_a6 JTF_NUMBER_TABLE

Line 432: , p6_a4 JTF_NUMBER_TABLE

428: , p6_a0 JTF_VARCHAR2_TABLE_100
429: , p6_a1 JTF_VARCHAR2_TABLE_100
430: , p6_a2 JTF_NUMBER_TABLE
431: , p6_a3 JTF_VARCHAR2_TABLE_100
432: , p6_a4 JTF_NUMBER_TABLE
433: , p6_a5 JTF_VARCHAR2_TABLE_100
434: , p6_a6 JTF_NUMBER_TABLE
435: , p6_a7 JTF_DATE_TABLE
436: , p6_a8 JTF_DATE_TABLE

Line 434: , p6_a6 JTF_NUMBER_TABLE

430: , p6_a2 JTF_NUMBER_TABLE
431: , p6_a3 JTF_VARCHAR2_TABLE_100
432: , p6_a4 JTF_NUMBER_TABLE
433: , p6_a5 JTF_VARCHAR2_TABLE_100
434: , p6_a6 JTF_NUMBER_TABLE
435: , p6_a7 JTF_DATE_TABLE
436: , p6_a8 JTF_DATE_TABLE
437: , p6_a9 JTF_VARCHAR2_TABLE_100
438: , p6_a10 JTF_VARCHAR2_TABLE_100

Line 439: , p6_a11 JTF_NUMBER_TABLE

435: , p6_a7 JTF_DATE_TABLE
436: , p6_a8 JTF_DATE_TABLE
437: , p6_a9 JTF_VARCHAR2_TABLE_100
438: , p6_a10 JTF_VARCHAR2_TABLE_100
439: , p6_a11 JTF_NUMBER_TABLE
440: , p6_a12 JTF_VARCHAR2_TABLE_100
441: , p6_a13 JTF_NUMBER_TABLE
442: , p6_a14 JTF_NUMBER_TABLE
443: , p6_a15 JTF_VARCHAR2_TABLE_100

Line 441: , p6_a13 JTF_NUMBER_TABLE

437: , p6_a9 JTF_VARCHAR2_TABLE_100
438: , p6_a10 JTF_VARCHAR2_TABLE_100
439: , p6_a11 JTF_NUMBER_TABLE
440: , p6_a12 JTF_VARCHAR2_TABLE_100
441: , p6_a13 JTF_NUMBER_TABLE
442: , p6_a14 JTF_NUMBER_TABLE
443: , p6_a15 JTF_VARCHAR2_TABLE_100
444: , p6_a16 JTF_NUMBER_TABLE
445: , p6_a17 JTF_VARCHAR2_TABLE_100

Line 442: , p6_a14 JTF_NUMBER_TABLE

438: , p6_a10 JTF_VARCHAR2_TABLE_100
439: , p6_a11 JTF_NUMBER_TABLE
440: , p6_a12 JTF_VARCHAR2_TABLE_100
441: , p6_a13 JTF_NUMBER_TABLE
442: , p6_a14 JTF_NUMBER_TABLE
443: , p6_a15 JTF_VARCHAR2_TABLE_100
444: , p6_a16 JTF_NUMBER_TABLE
445: , p6_a17 JTF_VARCHAR2_TABLE_100
446: , p6_a18 JTF_NUMBER_TABLE

Line 444: , p6_a16 JTF_NUMBER_TABLE

440: , p6_a12 JTF_VARCHAR2_TABLE_100
441: , p6_a13 JTF_NUMBER_TABLE
442: , p6_a14 JTF_NUMBER_TABLE
443: , p6_a15 JTF_VARCHAR2_TABLE_100
444: , p6_a16 JTF_NUMBER_TABLE
445: , p6_a17 JTF_VARCHAR2_TABLE_100
446: , p6_a18 JTF_NUMBER_TABLE
447: , p6_a19 JTF_NUMBER_TABLE
448: , p6_a20 JTF_NUMBER_TABLE

Line 446: , p6_a18 JTF_NUMBER_TABLE

442: , p6_a14 JTF_NUMBER_TABLE
443: , p6_a15 JTF_VARCHAR2_TABLE_100
444: , p6_a16 JTF_NUMBER_TABLE
445: , p6_a17 JTF_VARCHAR2_TABLE_100
446: , p6_a18 JTF_NUMBER_TABLE
447: , p6_a19 JTF_NUMBER_TABLE
448: , p6_a20 JTF_NUMBER_TABLE
449: , p6_a21 JTF_NUMBER_TABLE
450: , p6_a22 JTF_VARCHAR2_TABLE_100

Line 447: , p6_a19 JTF_NUMBER_TABLE

443: , p6_a15 JTF_VARCHAR2_TABLE_100
444: , p6_a16 JTF_NUMBER_TABLE
445: , p6_a17 JTF_VARCHAR2_TABLE_100
446: , p6_a18 JTF_NUMBER_TABLE
447: , p6_a19 JTF_NUMBER_TABLE
448: , p6_a20 JTF_NUMBER_TABLE
449: , p6_a21 JTF_NUMBER_TABLE
450: , p6_a22 JTF_VARCHAR2_TABLE_100
451: , p6_a23 JTF_VARCHAR2_TABLE_100

Line 448: , p6_a20 JTF_NUMBER_TABLE

444: , p6_a16 JTF_NUMBER_TABLE
445: , p6_a17 JTF_VARCHAR2_TABLE_100
446: , p6_a18 JTF_NUMBER_TABLE
447: , p6_a19 JTF_NUMBER_TABLE
448: , p6_a20 JTF_NUMBER_TABLE
449: , p6_a21 JTF_NUMBER_TABLE
450: , p6_a22 JTF_VARCHAR2_TABLE_100
451: , p6_a23 JTF_VARCHAR2_TABLE_100
452: , p6_a24 JTF_VARCHAR2_TABLE_100

Line 449: , p6_a21 JTF_NUMBER_TABLE

445: , p6_a17 JTF_VARCHAR2_TABLE_100
446: , p6_a18 JTF_NUMBER_TABLE
447: , p6_a19 JTF_NUMBER_TABLE
448: , p6_a20 JTF_NUMBER_TABLE
449: , p6_a21 JTF_NUMBER_TABLE
450: , p6_a22 JTF_VARCHAR2_TABLE_100
451: , p6_a23 JTF_VARCHAR2_TABLE_100
452: , p6_a24 JTF_VARCHAR2_TABLE_100
453: , p6_a25 JTF_VARCHAR2_TABLE_300

Line 455: , p6_a27 JTF_NUMBER_TABLE

451: , p6_a23 JTF_VARCHAR2_TABLE_100
452: , p6_a24 JTF_VARCHAR2_TABLE_100
453: , p6_a25 JTF_VARCHAR2_TABLE_300
454: , p6_a26 JTF_VARCHAR2_TABLE_100
455: , p6_a27 JTF_NUMBER_TABLE
456: , p6_a28 JTF_VARCHAR2_TABLE_100
457: , p6_a29 JTF_VARCHAR2_TABLE_100
458: , p6_a30 JTF_VARCHAR2_TABLE_300
459: , p6_a31 JTF_VARCHAR2_TABLE_100

Line 467: , p6_a39 JTF_NUMBER_TABLE

463: , p6_a35 JTF_VARCHAR2_TABLE_300
464: , p6_a36 JTF_VARCHAR2_TABLE_100
465: , p6_a37 JTF_VARCHAR2_TABLE_300
466: , p6_a38 JTF_VARCHAR2_TABLE_300
467: , p6_a39 JTF_NUMBER_TABLE
468: , p6_a40 JTF_VARCHAR2_TABLE_2000
469: , p6_a41 JTF_VARCHAR2_TABLE_100
470: , p6_a42 JTF_VARCHAR2_TABLE_300
471: , p6_a43 JTF_VARCHAR2_TABLE_300

Line 485: , p6_a57 JTF_NUMBER_TABLE

481: , p6_a53 JTF_VARCHAR2_TABLE_300
482: , p6_a54 JTF_VARCHAR2_TABLE_300
483: , p6_a55 JTF_VARCHAR2_TABLE_300
484: , p6_a56 JTF_VARCHAR2_TABLE_300
485: , p6_a57 JTF_NUMBER_TABLE
486: , p6_a58 JTF_NUMBER_TABLE
487: , p6_a59 JTF_NUMBER_TABLE
488: , p6_a60 JTF_NUMBER_TABLE
489: , p6_a61 JTF_NUMBER_TABLE

Line 486: , p6_a58 JTF_NUMBER_TABLE

482: , p6_a54 JTF_VARCHAR2_TABLE_300
483: , p6_a55 JTF_VARCHAR2_TABLE_300
484: , p6_a56 JTF_VARCHAR2_TABLE_300
485: , p6_a57 JTF_NUMBER_TABLE
486: , p6_a58 JTF_NUMBER_TABLE
487: , p6_a59 JTF_NUMBER_TABLE
488: , p6_a60 JTF_NUMBER_TABLE
489: , p6_a61 JTF_NUMBER_TABLE
490: , p6_a62 JTF_NUMBER_TABLE

Line 487: , p6_a59 JTF_NUMBER_TABLE

483: , p6_a55 JTF_VARCHAR2_TABLE_300
484: , p6_a56 JTF_VARCHAR2_TABLE_300
485: , p6_a57 JTF_NUMBER_TABLE
486: , p6_a58 JTF_NUMBER_TABLE
487: , p6_a59 JTF_NUMBER_TABLE
488: , p6_a60 JTF_NUMBER_TABLE
489: , p6_a61 JTF_NUMBER_TABLE
490: , p6_a62 JTF_NUMBER_TABLE
491: , p6_a63 JTF_NUMBER_TABLE

Line 488: , p6_a60 JTF_NUMBER_TABLE

484: , p6_a56 JTF_VARCHAR2_TABLE_300
485: , p6_a57 JTF_NUMBER_TABLE
486: , p6_a58 JTF_NUMBER_TABLE
487: , p6_a59 JTF_NUMBER_TABLE
488: , p6_a60 JTF_NUMBER_TABLE
489: , p6_a61 JTF_NUMBER_TABLE
490: , p6_a62 JTF_NUMBER_TABLE
491: , p6_a63 JTF_NUMBER_TABLE
492: , p6_a64 JTF_NUMBER_TABLE

Line 489: , p6_a61 JTF_NUMBER_TABLE

485: , p6_a57 JTF_NUMBER_TABLE
486: , p6_a58 JTF_NUMBER_TABLE
487: , p6_a59 JTF_NUMBER_TABLE
488: , p6_a60 JTF_NUMBER_TABLE
489: , p6_a61 JTF_NUMBER_TABLE
490: , p6_a62 JTF_NUMBER_TABLE
491: , p6_a63 JTF_NUMBER_TABLE
492: , p6_a64 JTF_NUMBER_TABLE
493: , p6_a65 JTF_NUMBER_TABLE

Line 490: , p6_a62 JTF_NUMBER_TABLE

486: , p6_a58 JTF_NUMBER_TABLE
487: , p6_a59 JTF_NUMBER_TABLE
488: , p6_a60 JTF_NUMBER_TABLE
489: , p6_a61 JTF_NUMBER_TABLE
490: , p6_a62 JTF_NUMBER_TABLE
491: , p6_a63 JTF_NUMBER_TABLE
492: , p6_a64 JTF_NUMBER_TABLE
493: , p6_a65 JTF_NUMBER_TABLE
494: , p6_a66 JTF_NUMBER_TABLE

Line 491: , p6_a63 JTF_NUMBER_TABLE

487: , p6_a59 JTF_NUMBER_TABLE
488: , p6_a60 JTF_NUMBER_TABLE
489: , p6_a61 JTF_NUMBER_TABLE
490: , p6_a62 JTF_NUMBER_TABLE
491: , p6_a63 JTF_NUMBER_TABLE
492: , p6_a64 JTF_NUMBER_TABLE
493: , p6_a65 JTF_NUMBER_TABLE
494: , p6_a66 JTF_NUMBER_TABLE
495: , p6_a67 JTF_VARCHAR2_TABLE_100

Line 492: , p6_a64 JTF_NUMBER_TABLE

488: , p6_a60 JTF_NUMBER_TABLE
489: , p6_a61 JTF_NUMBER_TABLE
490: , p6_a62 JTF_NUMBER_TABLE
491: , p6_a63 JTF_NUMBER_TABLE
492: , p6_a64 JTF_NUMBER_TABLE
493: , p6_a65 JTF_NUMBER_TABLE
494: , p6_a66 JTF_NUMBER_TABLE
495: , p6_a67 JTF_VARCHAR2_TABLE_100
496: , p6_a68 JTF_NUMBER_TABLE

Line 493: , p6_a65 JTF_NUMBER_TABLE

489: , p6_a61 JTF_NUMBER_TABLE
490: , p6_a62 JTF_NUMBER_TABLE
491: , p6_a63 JTF_NUMBER_TABLE
492: , p6_a64 JTF_NUMBER_TABLE
493: , p6_a65 JTF_NUMBER_TABLE
494: , p6_a66 JTF_NUMBER_TABLE
495: , p6_a67 JTF_VARCHAR2_TABLE_100
496: , p6_a68 JTF_NUMBER_TABLE
497: , p6_a69 JTF_NUMBER_TABLE

Line 494: , p6_a66 JTF_NUMBER_TABLE

490: , p6_a62 JTF_NUMBER_TABLE
491: , p6_a63 JTF_NUMBER_TABLE
492: , p6_a64 JTF_NUMBER_TABLE
493: , p6_a65 JTF_NUMBER_TABLE
494: , p6_a66 JTF_NUMBER_TABLE
495: , p6_a67 JTF_VARCHAR2_TABLE_100
496: , p6_a68 JTF_NUMBER_TABLE
497: , p6_a69 JTF_NUMBER_TABLE
498: , p6_a70 JTF_VARCHAR2_TABLE_300

Line 496: , p6_a68 JTF_NUMBER_TABLE

492: , p6_a64 JTF_NUMBER_TABLE
493: , p6_a65 JTF_NUMBER_TABLE
494: , p6_a66 JTF_NUMBER_TABLE
495: , p6_a67 JTF_VARCHAR2_TABLE_100
496: , p6_a68 JTF_NUMBER_TABLE
497: , p6_a69 JTF_NUMBER_TABLE
498: , p6_a70 JTF_VARCHAR2_TABLE_300
499: , p6_a71 JTF_VARCHAR2_TABLE_300
500: , p6_a72 JTF_VARCHAR2_TABLE_300

Line 497: , p6_a69 JTF_NUMBER_TABLE

493: , p6_a65 JTF_NUMBER_TABLE
494: , p6_a66 JTF_NUMBER_TABLE
495: , p6_a67 JTF_VARCHAR2_TABLE_100
496: , p6_a68 JTF_NUMBER_TABLE
497: , p6_a69 JTF_NUMBER_TABLE
498: , p6_a70 JTF_VARCHAR2_TABLE_300
499: , p6_a71 JTF_VARCHAR2_TABLE_300
500: , p6_a72 JTF_VARCHAR2_TABLE_300
501: , x_error_location out nocopy NUMBER

Line 514: , p6_a5 JTF_NUMBER_TABLE

510: , p6_a1 JTF_VARCHAR2_TABLE_100
511: , p6_a2 JTF_VARCHAR2_TABLE_300
512: , p6_a3 JTF_VARCHAR2_TABLE_300
513: , p6_a4 JTF_VARCHAR2_TABLE_100
514: , p6_a5 JTF_NUMBER_TABLE
515: , p6_a6 JTF_NUMBER_TABLE
516: , p6_a7 JTF_NUMBER_TABLE
517: , p6_a8 JTF_NUMBER_TABLE
518: , p6_a9 JTF_DATE_TABLE

Line 515: , p6_a6 JTF_NUMBER_TABLE

511: , p6_a2 JTF_VARCHAR2_TABLE_300
512: , p6_a3 JTF_VARCHAR2_TABLE_300
513: , p6_a4 JTF_VARCHAR2_TABLE_100
514: , p6_a5 JTF_NUMBER_TABLE
515: , p6_a6 JTF_NUMBER_TABLE
516: , p6_a7 JTF_NUMBER_TABLE
517: , p6_a8 JTF_NUMBER_TABLE
518: , p6_a9 JTF_DATE_TABLE
519: , p6_a10 JTF_DATE_TABLE

Line 516: , p6_a7 JTF_NUMBER_TABLE

512: , p6_a3 JTF_VARCHAR2_TABLE_300
513: , p6_a4 JTF_VARCHAR2_TABLE_100
514: , p6_a5 JTF_NUMBER_TABLE
515: , p6_a6 JTF_NUMBER_TABLE
516: , p6_a7 JTF_NUMBER_TABLE
517: , p6_a8 JTF_NUMBER_TABLE
518: , p6_a9 JTF_DATE_TABLE
519: , p6_a10 JTF_DATE_TABLE
520: , p6_a11 JTF_NUMBER_TABLE

Line 517: , p6_a8 JTF_NUMBER_TABLE

513: , p6_a4 JTF_VARCHAR2_TABLE_100
514: , p6_a5 JTF_NUMBER_TABLE
515: , p6_a6 JTF_NUMBER_TABLE
516: , p6_a7 JTF_NUMBER_TABLE
517: , p6_a8 JTF_NUMBER_TABLE
518: , p6_a9 JTF_DATE_TABLE
519: , p6_a10 JTF_DATE_TABLE
520: , p6_a11 JTF_NUMBER_TABLE
521: , p6_a12 JTF_VARCHAR2_TABLE_100

Line 520: , p6_a11 JTF_NUMBER_TABLE

516: , p6_a7 JTF_NUMBER_TABLE
517: , p6_a8 JTF_NUMBER_TABLE
518: , p6_a9 JTF_DATE_TABLE
519: , p6_a10 JTF_DATE_TABLE
520: , p6_a11 JTF_NUMBER_TABLE
521: , p6_a12 JTF_VARCHAR2_TABLE_100
522: , p6_a13 JTF_VARCHAR2_TABLE_100
523: , p6_a14 JTF_VARCHAR2_TABLE_300
524: , p6_a15 JTF_VARCHAR2_TABLE_300

Line 546: , p6_a0 JTF_NUMBER_TABLE

542: , p_commit VARCHAR2
543: , x_return_status out nocopy VARCHAR2
544: , x_msg_count out nocopy NUMBER
545: , x_msg_data out nocopy VARCHAR2
546: , p6_a0 JTF_NUMBER_TABLE
547: , p6_a1 JTF_VARCHAR2_TABLE_100
548: , p6_a2 JTF_NUMBER_TABLE
549: , p6_a3 JTF_VARCHAR2_TABLE_100
550: , p6_a4 JTF_VARCHAR2_TABLE_100

Line 548: , p6_a2 JTF_NUMBER_TABLE

544: , x_msg_count out nocopy NUMBER
545: , x_msg_data out nocopy VARCHAR2
546: , p6_a0 JTF_NUMBER_TABLE
547: , p6_a1 JTF_VARCHAR2_TABLE_100
548: , p6_a2 JTF_NUMBER_TABLE
549: , p6_a3 JTF_VARCHAR2_TABLE_100
550: , p6_a4 JTF_VARCHAR2_TABLE_100
551: , p6_a5 JTF_VARCHAR2_TABLE_300
552: , p6_a6 JTF_VARCHAR2_TABLE_100

Line 557: , p6_a11 JTF_NUMBER_TABLE

553: , p6_a7 JTF_VARCHAR2_TABLE_100
554: , p6_a8 JTF_VARCHAR2_TABLE_100
555: , p6_a9 JTF_VARCHAR2_TABLE_300
556: , p6_a10 JTF_VARCHAR2_TABLE_300
557: , p6_a11 JTF_NUMBER_TABLE
558: , p6_a12 JTF_VARCHAR2_TABLE_100
559: , x_error_location out nocopy NUMBER
560: );
561: procedure process_adv_options(p_init_msg_list VARCHAR2