APPS.OKS_ENTITLEMENTS_WEB_W dependencies on JTF_NUMBER_TABLE

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p19(t oks_entitlements_web.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
18: , a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 28: , a11 out nocopy JTF_NUMBER_TABLE

24: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
25: , a8 out nocopy JTF_DATE_TABLE
26: , a9 out nocopy JTF_DATE_TABLE
27: , a10 out nocopy JTF_DATE_TABLE
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );
31:
32: procedure rosetta_table_copy_in_p21(t out nocopy oks_entitlements_web.account_all_id_tbl_type, a0 JTF_NUMBER_TABLE

Line 32: procedure rosetta_table_copy_in_p21(t out nocopy oks_entitlements_web.account_all_id_tbl_type, a0 JTF_NUMBER_TABLE

28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );
31:
32: procedure rosetta_table_copy_in_p21(t out nocopy oks_entitlements_web.account_all_id_tbl_type, a0 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p21(t oks_entitlements_web.account_all_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: );
36:

Line 34: procedure rosetta_table_copy_out_p21(t oks_entitlements_web.account_all_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

30: );
31:
32: procedure rosetta_table_copy_in_p21(t out nocopy oks_entitlements_web.account_all_id_tbl_type, a0 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p21(t oks_entitlements_web.account_all_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: );
36:
37: procedure rosetta_table_copy_in_p23(t out nocopy oks_entitlements_web.party_sites_tbl_type, a0 JTF_NUMBER_TABLE
38: , a1 JTF_VARCHAR2_TABLE_100

Line 37: procedure rosetta_table_copy_in_p23(t out nocopy oks_entitlements_web.party_sites_tbl_type, a0 JTF_NUMBER_TABLE

33: );
34: procedure rosetta_table_copy_out_p21(t oks_entitlements_web.account_all_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: );
36:
37: procedure rosetta_table_copy_in_p23(t out nocopy oks_entitlements_web.party_sites_tbl_type, a0 JTF_NUMBER_TABLE
38: , a1 JTF_VARCHAR2_TABLE_100
39: , a2 JTF_VARCHAR2_TABLE_300
40: , a3 JTF_VARCHAR2_TABLE_300
41: );

Line 42: procedure rosetta_table_copy_out_p23(t oks_entitlements_web.party_sites_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

38: , a1 JTF_VARCHAR2_TABLE_100
39: , a2 JTF_VARCHAR2_TABLE_300
40: , a3 JTF_VARCHAR2_TABLE_300
41: );
42: procedure rosetta_table_copy_out_p23(t oks_entitlements_web.party_sites_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_VARCHAR2_TABLE_300
45: , a3 out nocopy JTF_VARCHAR2_TABLE_300
46: );

Line 48: procedure rosetta_table_copy_in_p25(t out nocopy oks_entitlements_web.party_items_tbl_type, a0 JTF_NUMBER_TABLE

44: , a2 out nocopy JTF_VARCHAR2_TABLE_300
45: , a3 out nocopy JTF_VARCHAR2_TABLE_300
46: );
47:
48: procedure rosetta_table_copy_in_p25(t out nocopy oks_entitlements_web.party_items_tbl_type, a0 JTF_NUMBER_TABLE
49: , a1 JTF_NUMBER_TABLE
50: , a2 JTF_VARCHAR2_TABLE_300
51: , a3 JTF_VARCHAR2_TABLE_300
52: );

Line 49: , a1 JTF_NUMBER_TABLE

45: , a3 out nocopy JTF_VARCHAR2_TABLE_300
46: );
47:
48: procedure rosetta_table_copy_in_p25(t out nocopy oks_entitlements_web.party_items_tbl_type, a0 JTF_NUMBER_TABLE
49: , a1 JTF_NUMBER_TABLE
50: , a2 JTF_VARCHAR2_TABLE_300
51: , a3 JTF_VARCHAR2_TABLE_300
52: );
53: procedure rosetta_table_copy_out_p25(t oks_entitlements_web.party_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 53: procedure rosetta_table_copy_out_p25(t oks_entitlements_web.party_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

49: , a1 JTF_NUMBER_TABLE
50: , a2 JTF_VARCHAR2_TABLE_300
51: , a3 JTF_VARCHAR2_TABLE_300
52: );
53: procedure rosetta_table_copy_out_p25(t oks_entitlements_web.party_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_VARCHAR2_TABLE_300
56: , a3 out nocopy JTF_VARCHAR2_TABLE_300
57: );

Line 54: , a1 out nocopy JTF_NUMBER_TABLE

50: , a2 JTF_VARCHAR2_TABLE_300
51: , a3 JTF_VARCHAR2_TABLE_300
52: );
53: procedure rosetta_table_copy_out_p25(t oks_entitlements_web.party_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_VARCHAR2_TABLE_300
56: , a3 out nocopy JTF_VARCHAR2_TABLE_300
57: );
58:

Line 59: procedure rosetta_table_copy_in_p27(t out nocopy oks_entitlements_web.party_systems_tbl_type, a0 JTF_NUMBER_TABLE

55: , a2 out nocopy JTF_VARCHAR2_TABLE_300
56: , a3 out nocopy JTF_VARCHAR2_TABLE_300
57: );
58:
59: procedure rosetta_table_copy_in_p27(t out nocopy oks_entitlements_web.party_systems_tbl_type, a0 JTF_NUMBER_TABLE
60: , a1 JTF_VARCHAR2_TABLE_100
61: , a2 JTF_VARCHAR2_TABLE_300
62: , a3 JTF_VARCHAR2_TABLE_300
63: );

Line 64: procedure rosetta_table_copy_out_p27(t oks_entitlements_web.party_systems_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

60: , a1 JTF_VARCHAR2_TABLE_100
61: , a2 JTF_VARCHAR2_TABLE_300
62: , a3 JTF_VARCHAR2_TABLE_300
63: );
64: procedure rosetta_table_copy_out_p27(t oks_entitlements_web.party_systems_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_VARCHAR2_TABLE_100
66: , a2 out nocopy JTF_VARCHAR2_TABLE_300
67: , a3 out nocopy JTF_VARCHAR2_TABLE_300
68: );

Line 70: procedure rosetta_table_copy_in_p29(t out nocopy oks_entitlements_web.party_products_tbl_type, a0 JTF_NUMBER_TABLE

66: , a2 out nocopy JTF_VARCHAR2_TABLE_300
67: , a3 out nocopy JTF_VARCHAR2_TABLE_300
68: );
69:
70: procedure rosetta_table_copy_in_p29(t out nocopy oks_entitlements_web.party_products_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_VARCHAR2_TABLE_300
73: , a3 JTF_VARCHAR2_TABLE_300
74: );

Line 75: procedure rosetta_table_copy_out_p29(t oks_entitlements_web.party_products_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_VARCHAR2_TABLE_300
73: , a3 JTF_VARCHAR2_TABLE_300
74: );
75: procedure rosetta_table_copy_out_p29(t oks_entitlements_web.party_products_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_VARCHAR2_TABLE_100
77: , a2 out nocopy JTF_VARCHAR2_TABLE_300
78: , a3 out nocopy JTF_VARCHAR2_TABLE_300
79: );

Line 95: procedure rosetta_table_copy_in_p37(t out nocopy oks_entitlements_web.party_tbl_type, a0 JTF_NUMBER_TABLE

91: procedure rosetta_table_copy_out_p33(t oks_entitlements_web.contract_status_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
92: , a1 out nocopy JTF_VARCHAR2_TABLE_100
93: );
94:
95: procedure rosetta_table_copy_in_p37(t out nocopy oks_entitlements_web.party_tbl_type, a0 JTF_NUMBER_TABLE
96: , a1 JTF_VARCHAR2_TABLE_100
97: , a2 JTF_VARCHAR2_TABLE_100
98: , a3 JTF_VARCHAR2_TABLE_400
99: , a4 JTF_VARCHAR2_TABLE_100

Line 103: procedure rosetta_table_copy_out_p37(t oks_entitlements_web.party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

99: , a4 JTF_VARCHAR2_TABLE_100
100: , a5 JTF_VARCHAR2_TABLE_100
101: , a6 JTF_VARCHAR2_TABLE_100
102: );
103: procedure rosetta_table_copy_out_p37(t oks_entitlements_web.party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_VARCHAR2_TABLE_100
105: , a2 out nocopy JTF_VARCHAR2_TABLE_100
106: , a3 out nocopy JTF_VARCHAR2_TABLE_400
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 112: procedure rosetta_table_copy_in_p39(t out nocopy oks_entitlements_web.line_tbl_type, a0 JTF_NUMBER_TABLE

108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: );
111:
112: procedure rosetta_table_copy_in_p39(t out nocopy oks_entitlements_web.line_tbl_type, a0 JTF_NUMBER_TABLE
113: , a1 JTF_NUMBER_TABLE
114: , a2 JTF_DATE_TABLE
115: , a3 JTF_DATE_TABLE
116: , a4 JTF_VARCHAR2_TABLE_100

Line 113: , a1 JTF_NUMBER_TABLE

109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: );
111:
112: procedure rosetta_table_copy_in_p39(t out nocopy oks_entitlements_web.line_tbl_type, a0 JTF_NUMBER_TABLE
113: , a1 JTF_NUMBER_TABLE
114: , a2 JTF_DATE_TABLE
115: , a3 JTF_DATE_TABLE
116: , a4 JTF_VARCHAR2_TABLE_100
117: , a5 JTF_VARCHAR2_TABLE_100

Line 125: , a13 JTF_NUMBER_TABLE

121: , a9 JTF_VARCHAR2_TABLE_500
122: , a10 JTF_VARCHAR2_TABLE_2000
123: , a11 JTF_VARCHAR2_TABLE_400
124: , a12 JTF_VARCHAR2_TABLE_400
125: , a13 JTF_NUMBER_TABLE
126: , a14 JTF_NUMBER_TABLE
127: , a15 JTF_VARCHAR2_TABLE_200
128: , a16 JTF_VARCHAR2_TABLE_100
129: , a17 JTF_VARCHAR2_TABLE_400

Line 126: , a14 JTF_NUMBER_TABLE

122: , a10 JTF_VARCHAR2_TABLE_2000
123: , a11 JTF_VARCHAR2_TABLE_400
124: , a12 JTF_VARCHAR2_TABLE_400
125: , a13 JTF_NUMBER_TABLE
126: , a14 JTF_NUMBER_TABLE
127: , a15 JTF_VARCHAR2_TABLE_200
128: , a16 JTF_VARCHAR2_TABLE_100
129: , a17 JTF_VARCHAR2_TABLE_400
130: , a18 JTF_VARCHAR2_TABLE_300

Line 137: procedure rosetta_table_copy_out_p39(t oks_entitlements_web.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

133: , a21 JTF_VARCHAR2_TABLE_400
134: , a22 JTF_VARCHAR2_TABLE_300
135: , a23 JTF_VARCHAR2_TABLE_100
136: );
137: procedure rosetta_table_copy_out_p39(t oks_entitlements_web.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
138: , a1 out nocopy JTF_NUMBER_TABLE
139: , a2 out nocopy JTF_DATE_TABLE
140: , a3 out nocopy JTF_DATE_TABLE
141: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 138: , a1 out nocopy JTF_NUMBER_TABLE

134: , a22 JTF_VARCHAR2_TABLE_300
135: , a23 JTF_VARCHAR2_TABLE_100
136: );
137: procedure rosetta_table_copy_out_p39(t oks_entitlements_web.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
138: , a1 out nocopy JTF_NUMBER_TABLE
139: , a2 out nocopy JTF_DATE_TABLE
140: , a3 out nocopy JTF_DATE_TABLE
141: , a4 out nocopy JTF_VARCHAR2_TABLE_100
142: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 150: , a13 out nocopy JTF_NUMBER_TABLE

146: , a9 out nocopy JTF_VARCHAR2_TABLE_500
147: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
148: , a11 out nocopy JTF_VARCHAR2_TABLE_400
149: , a12 out nocopy JTF_VARCHAR2_TABLE_400
150: , a13 out nocopy JTF_NUMBER_TABLE
151: , a14 out nocopy JTF_NUMBER_TABLE
152: , a15 out nocopy JTF_VARCHAR2_TABLE_200
153: , a16 out nocopy JTF_VARCHAR2_TABLE_100
154: , a17 out nocopy JTF_VARCHAR2_TABLE_400

Line 151: , a14 out nocopy JTF_NUMBER_TABLE

147: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
148: , a11 out nocopy JTF_VARCHAR2_TABLE_400
149: , a12 out nocopy JTF_VARCHAR2_TABLE_400
150: , a13 out nocopy JTF_NUMBER_TABLE
151: , a14 out nocopy JTF_NUMBER_TABLE
152: , a15 out nocopy JTF_VARCHAR2_TABLE_200
153: , a16 out nocopy JTF_VARCHAR2_TABLE_100
154: , a17 out nocopy JTF_VARCHAR2_TABLE_400
155: , a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 163: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_web.party_contact_tbl_type, a0 JTF_NUMBER_TABLE

159: , a22 out nocopy JTF_VARCHAR2_TABLE_300
160: , a23 out nocopy JTF_VARCHAR2_TABLE_100
161: );
162:
163: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_web.party_contact_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_100
165: , a2 JTF_VARCHAR2_TABLE_100
166: , a3 JTF_VARCHAR2_TABLE_100
167: , a4 JTF_DATE_TABLE

Line 173: procedure rosetta_table_copy_out_p41(t oks_entitlements_web.party_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

169: , a6 JTF_VARCHAR2_TABLE_400
170: , a7 JTF_VARCHAR2_TABLE_100
171: , a8 JTF_VARCHAR2_TABLE_100
172: );
173: procedure rosetta_table_copy_out_p41(t oks_entitlements_web.party_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
174: , a1 out nocopy JTF_VARCHAR2_TABLE_100
175: , a2 out nocopy JTF_VARCHAR2_TABLE_100
176: , a3 out nocopy JTF_VARCHAR2_TABLE_100
177: , a4 out nocopy JTF_DATE_TABLE

Line 208: , a5 JTF_NUMBER_TABLE

204: , a1 JTF_VARCHAR2_TABLE_500
205: , a2 JTF_VARCHAR2_TABLE_500
206: , a3 JTF_DATE_TABLE
207: , a4 JTF_DATE_TABLE
208: , a5 JTF_NUMBER_TABLE
209: , a6 JTF_VARCHAR2_TABLE_500
210: , a7 JTF_VARCHAR2_TABLE_500
211: , a8 JTF_VARCHAR2_TABLE_500
212: );

Line 218: , a5 out nocopy JTF_NUMBER_TABLE

214: , a1 out nocopy JTF_VARCHAR2_TABLE_500
215: , a2 out nocopy JTF_VARCHAR2_TABLE_500
216: , a3 out nocopy JTF_DATE_TABLE
217: , a4 out nocopy JTF_DATE_TABLE
218: , a5 out nocopy JTF_NUMBER_TABLE
219: , a6 out nocopy JTF_VARCHAR2_TABLE_500
220: , a7 out nocopy JTF_VARCHAR2_TABLE_500
221: , a8 out nocopy JTF_VARCHAR2_TABLE_500
222: );

Line 237: procedure rosetta_table_copy_in_p51(t out nocopy oks_entitlements_web.bus_proc_tbl_type, a0 JTF_NUMBER_TABLE

233: , a3 out nocopy JTF_DATE_TABLE
234: , a4 out nocopy JTF_DATE_TABLE
235: );
236:
237: procedure rosetta_table_copy_in_p51(t out nocopy oks_entitlements_web.bus_proc_tbl_type, a0 JTF_NUMBER_TABLE
238: , a1 JTF_NUMBER_TABLE
239: , a2 JTF_VARCHAR2_TABLE_500
240: , a3 JTF_VARCHAR2_TABLE_500
241: , a4 JTF_VARCHAR2_TABLE_500

Line 238: , a1 JTF_NUMBER_TABLE

234: , a4 out nocopy JTF_DATE_TABLE
235: );
236:
237: procedure rosetta_table_copy_in_p51(t out nocopy oks_entitlements_web.bus_proc_tbl_type, a0 JTF_NUMBER_TABLE
238: , a1 JTF_NUMBER_TABLE
239: , a2 JTF_VARCHAR2_TABLE_500
240: , a3 JTF_VARCHAR2_TABLE_500
241: , a4 JTF_VARCHAR2_TABLE_500
242: , a5 JTF_VARCHAR2_TABLE_500

Line 244: procedure rosetta_table_copy_out_p51(t oks_entitlements_web.bus_proc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

240: , a3 JTF_VARCHAR2_TABLE_500
241: , a4 JTF_VARCHAR2_TABLE_500
242: , a5 JTF_VARCHAR2_TABLE_500
243: );
244: procedure rosetta_table_copy_out_p51(t oks_entitlements_web.bus_proc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
245: , a1 out nocopy JTF_NUMBER_TABLE
246: , a2 out nocopy JTF_VARCHAR2_TABLE_500
247: , a3 out nocopy JTF_VARCHAR2_TABLE_500
248: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 245: , a1 out nocopy JTF_NUMBER_TABLE

241: , a4 JTF_VARCHAR2_TABLE_500
242: , a5 JTF_VARCHAR2_TABLE_500
243: );
244: procedure rosetta_table_copy_out_p51(t oks_entitlements_web.bus_proc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
245: , a1 out nocopy JTF_NUMBER_TABLE
246: , a2 out nocopy JTF_VARCHAR2_TABLE_500
247: , a3 out nocopy JTF_VARCHAR2_TABLE_500
248: , a4 out nocopy JTF_VARCHAR2_TABLE_500
249: , a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 401: , p5_a11 out nocopy JTF_NUMBER_TABLE

397: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_2000
398: , p5_a8 out nocopy JTF_DATE_TABLE
399: , p5_a9 out nocopy JTF_DATE_TABLE
400: , p5_a10 out nocopy JTF_DATE_TABLE
401: , p5_a11 out nocopy JTF_NUMBER_TABLE
402: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
403: );
404: procedure cntrct_srch_rslts(p_contract_number VARCHAR2
405: , p_contract_status_code VARCHAR2

Line 425: , p21_a0 JTF_NUMBER_TABLE

421: , p_entitlement_check_yn VARCHAR2
422: , p_account_check_all VARCHAR2
423: , p_account_id VARCHAR2
424: , p_covlvl_party_id VARCHAR2
425: , p21_a0 JTF_NUMBER_TABLE
426: , x_return_status out nocopy VARCHAR2
427: , x_msg_count out nocopy NUMBER
428: , x_msg_data out nocopy VARCHAR2
429: , p25_a0 out nocopy JTF_VARCHAR2_TABLE_200

Line 440: , p25_a11 out nocopy JTF_NUMBER_TABLE

436: , p25_a7 out nocopy JTF_VARCHAR2_TABLE_2000
437: , p25_a8 out nocopy JTF_DATE_TABLE
438: , p25_a9 out nocopy JTF_DATE_TABLE
439: , p25_a10 out nocopy JTF_DATE_TABLE
440: , p25_a11 out nocopy JTF_NUMBER_TABLE
441: , p25_a12 out nocopy JTF_VARCHAR2_TABLE_100
442: );
443: procedure party_sites(p_party_id_arg VARCHAR2
444: , p_site_name_arg VARCHAR2

Line 446: , p3_a0 out nocopy JTF_NUMBER_TABLE

442: );
443: procedure party_sites(p_party_id_arg VARCHAR2
444: , p_site_name_arg VARCHAR2
445: , x_return_status out nocopy VARCHAR2
446: , p3_a0 out nocopy JTF_NUMBER_TABLE
447: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
448: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
449: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
450: );

Line 460: , p3_a0 out nocopy JTF_NUMBER_TABLE

456: ) return varchar2;
457: procedure party_items(p_party_id_arg VARCHAR2
458: , p_item_name_arg VARCHAR2
459: , x_return_status out nocopy VARCHAR2
460: , p3_a0 out nocopy JTF_NUMBER_TABLE
461: , p3_a1 out nocopy JTF_NUMBER_TABLE
462: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
463: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
464: );

Line 461: , p3_a1 out nocopy JTF_NUMBER_TABLE

457: procedure party_items(p_party_id_arg VARCHAR2
458: , p_item_name_arg VARCHAR2
459: , x_return_status out nocopy VARCHAR2
460: , p3_a0 out nocopy JTF_NUMBER_TABLE
461: , p3_a1 out nocopy JTF_NUMBER_TABLE
462: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
463: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
464: );
465: procedure party_systems(p_party_id_arg VARCHAR2

Line 466: , p1_a0 JTF_NUMBER_TABLE

462: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
463: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
464: );
465: procedure party_systems(p_party_id_arg VARCHAR2
466: , p1_a0 JTF_NUMBER_TABLE
467: , p_system_name_arg VARCHAR2
468: , x_return_status out nocopy VARCHAR2
469: , p4_a0 out nocopy JTF_NUMBER_TABLE
470: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 469: , p4_a0 out nocopy JTF_NUMBER_TABLE

465: procedure party_systems(p_party_id_arg VARCHAR2
466: , p1_a0 JTF_NUMBER_TABLE
467: , p_system_name_arg VARCHAR2
468: , x_return_status out nocopy VARCHAR2
469: , p4_a0 out nocopy JTF_NUMBER_TABLE
470: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
471: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
472: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
473: );

Line 475: , p1_a0 JTF_NUMBER_TABLE

471: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
472: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
473: );
474: procedure party_products(p_party_id_arg VARCHAR2
475: , p1_a0 JTF_NUMBER_TABLE
476: , p_product_name_arg VARCHAR2
477: , x_return_status out nocopy VARCHAR2
478: , p4_a0 out nocopy JTF_NUMBER_TABLE
479: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 478: , p4_a0 out nocopy JTF_NUMBER_TABLE

474: procedure party_products(p_party_id_arg VARCHAR2
475: , p1_a0 JTF_NUMBER_TABLE
476: , p_product_name_arg VARCHAR2
477: , x_return_status out nocopy VARCHAR2
478: , p4_a0 out nocopy JTF_NUMBER_TABLE
479: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
480: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
481: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
482: );

Line 522: , p5_a0 out nocopy JTF_NUMBER_TABLE

518: , p4_a7 out nocopy VARCHAR2
519: , p4_a8 out nocopy VARCHAR2
520: , p4_a9 out nocopy VARCHAR2
521: , p4_a10 out nocopy VARCHAR2
522: , p5_a0 out nocopy JTF_NUMBER_TABLE
523: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
524: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
525: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_400
526: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 529: , p6_a0 out nocopy JTF_NUMBER_TABLE

525: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_400
526: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
527: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
528: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a0 out nocopy JTF_NUMBER_TABLE
530: , p6_a1 out nocopy JTF_NUMBER_TABLE
531: , p6_a2 out nocopy JTF_DATE_TABLE
532: , p6_a3 out nocopy JTF_DATE_TABLE
533: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 530: , p6_a1 out nocopy JTF_NUMBER_TABLE

526: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
527: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
528: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a0 out nocopy JTF_NUMBER_TABLE
530: , p6_a1 out nocopy JTF_NUMBER_TABLE
531: , p6_a2 out nocopy JTF_DATE_TABLE
532: , p6_a3 out nocopy JTF_DATE_TABLE
533: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 542: , p6_a13 out nocopy JTF_NUMBER_TABLE

538: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
539: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
540: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400
541: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_400
542: , p6_a13 out nocopy JTF_NUMBER_TABLE
543: , p6_a14 out nocopy JTF_NUMBER_TABLE
544: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
545: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
546: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_400

Line 543: , p6_a14 out nocopy JTF_NUMBER_TABLE

539: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
540: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400
541: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_400
542: , p6_a13 out nocopy JTF_NUMBER_TABLE
543: , p6_a14 out nocopy JTF_NUMBER_TABLE
544: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
545: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
546: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_400
547: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 584: , p4_a0 out nocopy JTF_NUMBER_TABLE

580: , p3_a7 out nocopy VARCHAR2
581: , p3_a8 out nocopy VARCHAR2
582: , p3_a9 out nocopy VARCHAR2
583: , p3_a10 out nocopy VARCHAR2
584: , p4_a0 out nocopy JTF_NUMBER_TABLE
585: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
586: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
587: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_400
588: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 591: , p5_a0 out nocopy JTF_NUMBER_TABLE

587: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_400
588: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
589: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
590: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
591: , p5_a0 out nocopy JTF_NUMBER_TABLE
592: , p5_a1 out nocopy JTF_NUMBER_TABLE
593: , p5_a2 out nocopy JTF_DATE_TABLE
594: , p5_a3 out nocopy JTF_DATE_TABLE
595: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 592: , p5_a1 out nocopy JTF_NUMBER_TABLE

588: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
589: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
590: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
591: , p5_a0 out nocopy JTF_NUMBER_TABLE
592: , p5_a1 out nocopy JTF_NUMBER_TABLE
593: , p5_a2 out nocopy JTF_DATE_TABLE
594: , p5_a3 out nocopy JTF_DATE_TABLE
595: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
596: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 604: , p5_a13 out nocopy JTF_NUMBER_TABLE

600: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_500
601: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_2000
602: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_400
603: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_400
604: , p5_a13 out nocopy JTF_NUMBER_TABLE
605: , p5_a14 out nocopy JTF_NUMBER_TABLE
606: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200
607: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
608: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_400

Line 605: , p5_a14 out nocopy JTF_NUMBER_TABLE

601: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_2000
602: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_400
603: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_400
604: , p5_a13 out nocopy JTF_NUMBER_TABLE
605: , p5_a14 out nocopy JTF_NUMBER_TABLE
606: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200
607: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
608: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_400
609: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 619: , p3_a0 out nocopy JTF_NUMBER_TABLE

615: );
616: procedure party_overview(p_contract_id_arg VARCHAR2
617: , p_party_rle_code_arg VARCHAR2
618: , x_return_status out nocopy VARCHAR2
619: , p3_a0 out nocopy JTF_NUMBER_TABLE
620: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
621: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
622: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
623: , p3_a4 out nocopy JTF_DATE_TABLE

Line 671: , p3_a5 out nocopy JTF_NUMBER_TABLE

667: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_500
668: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_500
669: , p3_a3 out nocopy JTF_DATE_TABLE
670: , p3_a4 out nocopy JTF_DATE_TABLE
671: , p3_a5 out nocopy JTF_NUMBER_TABLE
672: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_500
673: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_500
674: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_500
675: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_500

Line 688: , p4_a0 out nocopy JTF_NUMBER_TABLE

684: , p3_a0 out nocopy NUMBER
685: , p3_a1 out nocopy VARCHAR2
686: , p3_a2 out nocopy VARCHAR2
687: , p3_a3 out nocopy VARCHAR2
688: , p4_a0 out nocopy JTF_NUMBER_TABLE
689: , p4_a1 out nocopy JTF_NUMBER_TABLE
690: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_500
691: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_500
692: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 689: , p4_a1 out nocopy JTF_NUMBER_TABLE

685: , p3_a1 out nocopy VARCHAR2
686: , p3_a2 out nocopy VARCHAR2
687: , p3_a3 out nocopy VARCHAR2
688: , p4_a0 out nocopy JTF_NUMBER_TABLE
689: , p4_a1 out nocopy JTF_NUMBER_TABLE
690: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_500
691: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_500
692: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_500
693: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_500