APPS.OKL_CREDIT_CHECKLIST_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p21(t out nocopy okl_credit_checklist_pvt.rulv_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p21(t out nocopy okl_credit_checklist_pvt.rulv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p21(t out nocopy okl_credit_checklist_pvt.rulv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500

Line 26: , a4 JTF_NUMBER_TABLE

22: procedure rosetta_table_copy_in_p21(t out nocopy okl_credit_checklist_pvt.rulv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500
30: , a8 JTF_VARCHAR2_TABLE_500

Line 43: , a21 JTF_NUMBER_TABLE

39: , a17 JTF_VARCHAR2_TABLE_500
40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_NUMBER_TABLE
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if a0 is not null and a0.count > 0 then

Line 83: procedure rosetta_table_copy_out_p21(t okl_credit_checklist_pvt.rulv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

79: end loop;
80: end if;
81: end if;
82: end rosetta_table_copy_in_p21;
83: procedure rosetta_table_copy_out_p21(t okl_credit_checklist_pvt.rulv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
84: , a1 out nocopy JTF_VARCHAR2_TABLE_100
85: , a2 out nocopy JTF_VARCHAR2_TABLE_200
86: , a3 out nocopy JTF_NUMBER_TABLE
87: , a4 out nocopy JTF_NUMBER_TABLE

Line 86: , a3 out nocopy JTF_NUMBER_TABLE

82: end rosetta_table_copy_in_p21;
83: procedure rosetta_table_copy_out_p21(t okl_credit_checklist_pvt.rulv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
84: , a1 out nocopy JTF_VARCHAR2_TABLE_100
85: , a2 out nocopy JTF_VARCHAR2_TABLE_200
86: , a3 out nocopy JTF_NUMBER_TABLE
87: , a4 out nocopy JTF_NUMBER_TABLE
88: , a5 out nocopy JTF_VARCHAR2_TABLE_100
89: , a6 out nocopy JTF_VARCHAR2_TABLE_500
90: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 87: , a4 out nocopy JTF_NUMBER_TABLE

83: procedure rosetta_table_copy_out_p21(t okl_credit_checklist_pvt.rulv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
84: , a1 out nocopy JTF_VARCHAR2_TABLE_100
85: , a2 out nocopy JTF_VARCHAR2_TABLE_200
86: , a3 out nocopy JTF_NUMBER_TABLE
87: , a4 out nocopy JTF_NUMBER_TABLE
88: , a5 out nocopy JTF_VARCHAR2_TABLE_100
89: , a6 out nocopy JTF_VARCHAR2_TABLE_500
90: , a7 out nocopy JTF_VARCHAR2_TABLE_500
91: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 104: , a21 out nocopy JTF_NUMBER_TABLE

100: , a17 out nocopy JTF_VARCHAR2_TABLE_500
101: , a18 out nocopy JTF_VARCHAR2_TABLE_500
102: , a19 out nocopy JTF_VARCHAR2_TABLE_500
103: , a20 out nocopy JTF_VARCHAR2_TABLE_500
104: , a21 out nocopy JTF_NUMBER_TABLE
105: ) as
106: ddindx binary_integer; indx binary_integer;
107: begin
108: if t is null or t.count = 0 then

Line 109: a0 := JTF_NUMBER_TABLE();

105: ) as
106: ddindx binary_integer; indx binary_integer;
107: begin
108: if t is null or t.count = 0 then
109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_VARCHAR2_TABLE_100();
111: a2 := JTF_VARCHAR2_TABLE_200();
112: a3 := JTF_NUMBER_TABLE();
113: a4 := JTF_NUMBER_TABLE();

Line 112: a3 := JTF_NUMBER_TABLE();

108: if t is null or t.count = 0 then
109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_VARCHAR2_TABLE_100();
111: a2 := JTF_VARCHAR2_TABLE_200();
112: a3 := JTF_NUMBER_TABLE();
113: a4 := JTF_NUMBER_TABLE();
114: a5 := JTF_VARCHAR2_TABLE_100();
115: a6 := JTF_VARCHAR2_TABLE_500();
116: a7 := JTF_VARCHAR2_TABLE_500();

Line 113: a4 := JTF_NUMBER_TABLE();

109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_VARCHAR2_TABLE_100();
111: a2 := JTF_VARCHAR2_TABLE_200();
112: a3 := JTF_NUMBER_TABLE();
113: a4 := JTF_NUMBER_TABLE();
114: a5 := JTF_VARCHAR2_TABLE_100();
115: a6 := JTF_VARCHAR2_TABLE_500();
116: a7 := JTF_VARCHAR2_TABLE_500();
117: a8 := JTF_VARCHAR2_TABLE_500();

Line 130: a21 := JTF_NUMBER_TABLE();

126: a17 := JTF_VARCHAR2_TABLE_500();
127: a18 := JTF_VARCHAR2_TABLE_500();
128: a19 := JTF_VARCHAR2_TABLE_500();
129: a20 := JTF_VARCHAR2_TABLE_500();
130: a21 := JTF_NUMBER_TABLE();
131: else
132: a0 := JTF_NUMBER_TABLE();
133: a1 := JTF_VARCHAR2_TABLE_100();
134: a2 := JTF_VARCHAR2_TABLE_200();

Line 132: a0 := JTF_NUMBER_TABLE();

128: a19 := JTF_VARCHAR2_TABLE_500();
129: a20 := JTF_VARCHAR2_TABLE_500();
130: a21 := JTF_NUMBER_TABLE();
131: else
132: a0 := JTF_NUMBER_TABLE();
133: a1 := JTF_VARCHAR2_TABLE_100();
134: a2 := JTF_VARCHAR2_TABLE_200();
135: a3 := JTF_NUMBER_TABLE();
136: a4 := JTF_NUMBER_TABLE();

Line 135: a3 := JTF_NUMBER_TABLE();

131: else
132: a0 := JTF_NUMBER_TABLE();
133: a1 := JTF_VARCHAR2_TABLE_100();
134: a2 := JTF_VARCHAR2_TABLE_200();
135: a3 := JTF_NUMBER_TABLE();
136: a4 := JTF_NUMBER_TABLE();
137: a5 := JTF_VARCHAR2_TABLE_100();
138: a6 := JTF_VARCHAR2_TABLE_500();
139: a7 := JTF_VARCHAR2_TABLE_500();

Line 136: a4 := JTF_NUMBER_TABLE();

132: a0 := JTF_NUMBER_TABLE();
133: a1 := JTF_VARCHAR2_TABLE_100();
134: a2 := JTF_VARCHAR2_TABLE_200();
135: a3 := JTF_NUMBER_TABLE();
136: a4 := JTF_NUMBER_TABLE();
137: a5 := JTF_VARCHAR2_TABLE_100();
138: a6 := JTF_VARCHAR2_TABLE_500();
139: a7 := JTF_VARCHAR2_TABLE_500();
140: a8 := JTF_VARCHAR2_TABLE_500();

Line 153: a21 := JTF_NUMBER_TABLE();

149: a17 := JTF_VARCHAR2_TABLE_500();
150: a18 := JTF_VARCHAR2_TABLE_500();
151: a19 := JTF_VARCHAR2_TABLE_500();
152: a20 := JTF_VARCHAR2_TABLE_500();
153: a21 := JTF_NUMBER_TABLE();
154: if t.count > 0 then
155: a0.extend(t.count);
156: a1.extend(t.count);
157: a2.extend(t.count);

Line 217: , p5_a0 JTF_NUMBER_TABLE

213: , p_init_msg_list VARCHAR2
214: , x_return_status out nocopy VARCHAR2
215: , x_msg_count out nocopy NUMBER
216: , x_msg_data out nocopy VARCHAR2
217: , p5_a0 JTF_NUMBER_TABLE
218: , p5_a1 JTF_VARCHAR2_TABLE_100
219: , p5_a2 JTF_VARCHAR2_TABLE_200
220: , p5_a3 JTF_NUMBER_TABLE
221: , p5_a4 JTF_NUMBER_TABLE

Line 220: , p5_a3 JTF_NUMBER_TABLE

216: , x_msg_data out nocopy VARCHAR2
217: , p5_a0 JTF_NUMBER_TABLE
218: , p5_a1 JTF_VARCHAR2_TABLE_100
219: , p5_a2 JTF_VARCHAR2_TABLE_200
220: , p5_a3 JTF_NUMBER_TABLE
221: , p5_a4 JTF_NUMBER_TABLE
222: , p5_a5 JTF_VARCHAR2_TABLE_100
223: , p5_a6 JTF_VARCHAR2_TABLE_500
224: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 221: , p5_a4 JTF_NUMBER_TABLE

217: , p5_a0 JTF_NUMBER_TABLE
218: , p5_a1 JTF_VARCHAR2_TABLE_100
219: , p5_a2 JTF_VARCHAR2_TABLE_200
220: , p5_a3 JTF_NUMBER_TABLE
221: , p5_a4 JTF_NUMBER_TABLE
222: , p5_a5 JTF_VARCHAR2_TABLE_100
223: , p5_a6 JTF_VARCHAR2_TABLE_500
224: , p5_a7 JTF_VARCHAR2_TABLE_500
225: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 238: , p5_a21 JTF_NUMBER_TABLE

234: , p5_a17 JTF_VARCHAR2_TABLE_500
235: , p5_a18 JTF_VARCHAR2_TABLE_500
236: , p5_a19 JTF_VARCHAR2_TABLE_500
237: , p5_a20 JTF_VARCHAR2_TABLE_500
238: , p5_a21 JTF_NUMBER_TABLE
239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
242: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 239: , p6_a0 out nocopy JTF_NUMBER_TABLE

235: , p5_a18 JTF_VARCHAR2_TABLE_500
236: , p5_a19 JTF_VARCHAR2_TABLE_500
237: , p5_a20 JTF_VARCHAR2_TABLE_500
238: , p5_a21 JTF_NUMBER_TABLE
239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
242: , p6_a3 out nocopy JTF_NUMBER_TABLE
243: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 242: , p6_a3 out nocopy JTF_NUMBER_TABLE

238: , p5_a21 JTF_NUMBER_TABLE
239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
242: , p6_a3 out nocopy JTF_NUMBER_TABLE
243: , p6_a4 out nocopy JTF_NUMBER_TABLE
244: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 243: , p6_a4 out nocopy JTF_NUMBER_TABLE

239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
242: , p6_a3 out nocopy JTF_NUMBER_TABLE
243: , p6_a4 out nocopy JTF_NUMBER_TABLE
244: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
247: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 260: , p6_a21 out nocopy JTF_NUMBER_TABLE

256: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
258: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
259: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
260: , p6_a21 out nocopy JTF_NUMBER_TABLE
261: )
262:
263: as
264: ddp_rulv_tbl okl_credit_checklist_pvt.rulv_tbl_type;

Line 346: , p5_a0 JTF_NUMBER_TABLE

342: , p_init_msg_list VARCHAR2
343: , x_return_status out nocopy VARCHAR2
344: , x_msg_count out nocopy NUMBER
345: , x_msg_data out nocopy VARCHAR2
346: , p5_a0 JTF_NUMBER_TABLE
347: , p5_a1 JTF_VARCHAR2_TABLE_100
348: , p5_a2 JTF_VARCHAR2_TABLE_200
349: , p5_a3 JTF_NUMBER_TABLE
350: , p5_a4 JTF_NUMBER_TABLE

Line 349: , p5_a3 JTF_NUMBER_TABLE

345: , x_msg_data out nocopy VARCHAR2
346: , p5_a0 JTF_NUMBER_TABLE
347: , p5_a1 JTF_VARCHAR2_TABLE_100
348: , p5_a2 JTF_VARCHAR2_TABLE_200
349: , p5_a3 JTF_NUMBER_TABLE
350: , p5_a4 JTF_NUMBER_TABLE
351: , p5_a5 JTF_VARCHAR2_TABLE_100
352: , p5_a6 JTF_VARCHAR2_TABLE_500
353: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 350: , p5_a4 JTF_NUMBER_TABLE

346: , p5_a0 JTF_NUMBER_TABLE
347: , p5_a1 JTF_VARCHAR2_TABLE_100
348: , p5_a2 JTF_VARCHAR2_TABLE_200
349: , p5_a3 JTF_NUMBER_TABLE
350: , p5_a4 JTF_NUMBER_TABLE
351: , p5_a5 JTF_VARCHAR2_TABLE_100
352: , p5_a6 JTF_VARCHAR2_TABLE_500
353: , p5_a7 JTF_VARCHAR2_TABLE_500
354: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 367: , p5_a21 JTF_NUMBER_TABLE

363: , p5_a17 JTF_VARCHAR2_TABLE_500
364: , p5_a18 JTF_VARCHAR2_TABLE_500
365: , p5_a19 JTF_VARCHAR2_TABLE_500
366: , p5_a20 JTF_VARCHAR2_TABLE_500
367: , p5_a21 JTF_NUMBER_TABLE
368: , p6_a0 out nocopy JTF_NUMBER_TABLE
369: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
371: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 368: , p6_a0 out nocopy JTF_NUMBER_TABLE

364: , p5_a18 JTF_VARCHAR2_TABLE_500
365: , p5_a19 JTF_VARCHAR2_TABLE_500
366: , p5_a20 JTF_VARCHAR2_TABLE_500
367: , p5_a21 JTF_NUMBER_TABLE
368: , p6_a0 out nocopy JTF_NUMBER_TABLE
369: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
371: , p6_a3 out nocopy JTF_NUMBER_TABLE
372: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 371: , p6_a3 out nocopy JTF_NUMBER_TABLE

367: , p5_a21 JTF_NUMBER_TABLE
368: , p6_a0 out nocopy JTF_NUMBER_TABLE
369: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
371: , p6_a3 out nocopy JTF_NUMBER_TABLE
372: , p6_a4 out nocopy JTF_NUMBER_TABLE
373: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
374: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
375: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 372: , p6_a4 out nocopy JTF_NUMBER_TABLE

368: , p6_a0 out nocopy JTF_NUMBER_TABLE
369: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
371: , p6_a3 out nocopy JTF_NUMBER_TABLE
372: , p6_a4 out nocopy JTF_NUMBER_TABLE
373: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
374: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
375: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
376: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 389: , p6_a21 out nocopy JTF_NUMBER_TABLE

385: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
386: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
387: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
388: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
389: , p6_a21 out nocopy JTF_NUMBER_TABLE
390: )
391:
392: as
393: ddp_rulv_tbl okl_credit_checklist_pvt.rulv_tbl_type;

Line 475: , p5_a0 JTF_NUMBER_TABLE

471: , p_init_msg_list VARCHAR2
472: , x_return_status out nocopy VARCHAR2
473: , x_msg_count out nocopy NUMBER
474: , x_msg_data out nocopy VARCHAR2
475: , p5_a0 JTF_NUMBER_TABLE
476: , p5_a1 JTF_VARCHAR2_TABLE_100
477: , p5_a2 JTF_VARCHAR2_TABLE_200
478: , p5_a3 JTF_NUMBER_TABLE
479: , p5_a4 JTF_NUMBER_TABLE

Line 478: , p5_a3 JTF_NUMBER_TABLE

474: , x_msg_data out nocopy VARCHAR2
475: , p5_a0 JTF_NUMBER_TABLE
476: , p5_a1 JTF_VARCHAR2_TABLE_100
477: , p5_a2 JTF_VARCHAR2_TABLE_200
478: , p5_a3 JTF_NUMBER_TABLE
479: , p5_a4 JTF_NUMBER_TABLE
480: , p5_a5 JTF_VARCHAR2_TABLE_100
481: , p5_a6 JTF_VARCHAR2_TABLE_500
482: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 479: , p5_a4 JTF_NUMBER_TABLE

475: , p5_a0 JTF_NUMBER_TABLE
476: , p5_a1 JTF_VARCHAR2_TABLE_100
477: , p5_a2 JTF_VARCHAR2_TABLE_200
478: , p5_a3 JTF_NUMBER_TABLE
479: , p5_a4 JTF_NUMBER_TABLE
480: , p5_a5 JTF_VARCHAR2_TABLE_100
481: , p5_a6 JTF_VARCHAR2_TABLE_500
482: , p5_a7 JTF_VARCHAR2_TABLE_500
483: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 496: , p5_a21 JTF_NUMBER_TABLE

492: , p5_a17 JTF_VARCHAR2_TABLE_500
493: , p5_a18 JTF_VARCHAR2_TABLE_500
494: , p5_a19 JTF_VARCHAR2_TABLE_500
495: , p5_a20 JTF_VARCHAR2_TABLE_500
496: , p5_a21 JTF_NUMBER_TABLE
497: )
498:
499: as
500: ddp_rulv_tbl okl_credit_checklist_pvt.rulv_tbl_type;

Line 634: , p5_a0 JTF_NUMBER_TABLE

630: , p_init_msg_list VARCHAR2
631: , x_return_status out nocopy VARCHAR2
632: , x_msg_count out nocopy NUMBER
633: , x_msg_data out nocopy VARCHAR2
634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_VARCHAR2_TABLE_100
636: , p5_a2 JTF_VARCHAR2_TABLE_200
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_NUMBER_TABLE

Line 637: , p5_a3 JTF_NUMBER_TABLE

633: , x_msg_data out nocopy VARCHAR2
634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_VARCHAR2_TABLE_100
636: , p5_a2 JTF_VARCHAR2_TABLE_200
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_NUMBER_TABLE
639: , p5_a5 JTF_VARCHAR2_TABLE_100
640: , p5_a6 JTF_VARCHAR2_TABLE_500
641: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 638: , p5_a4 JTF_NUMBER_TABLE

634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_VARCHAR2_TABLE_100
636: , p5_a2 JTF_VARCHAR2_TABLE_200
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_NUMBER_TABLE
639: , p5_a5 JTF_VARCHAR2_TABLE_100
640: , p5_a6 JTF_VARCHAR2_TABLE_500
641: , p5_a7 JTF_VARCHAR2_TABLE_500
642: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 655: , p5_a21 JTF_NUMBER_TABLE

651: , p5_a17 JTF_VARCHAR2_TABLE_500
652: , p5_a18 JTF_VARCHAR2_TABLE_500
653: , p5_a19 JTF_VARCHAR2_TABLE_500
654: , p5_a20 JTF_VARCHAR2_TABLE_500
655: , p5_a21 JTF_NUMBER_TABLE
656: , p6_a0 out nocopy JTF_NUMBER_TABLE
657: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
659: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 656: , p6_a0 out nocopy JTF_NUMBER_TABLE

652: , p5_a18 JTF_VARCHAR2_TABLE_500
653: , p5_a19 JTF_VARCHAR2_TABLE_500
654: , p5_a20 JTF_VARCHAR2_TABLE_500
655: , p5_a21 JTF_NUMBER_TABLE
656: , p6_a0 out nocopy JTF_NUMBER_TABLE
657: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
659: , p6_a3 out nocopy JTF_NUMBER_TABLE
660: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 659: , p6_a3 out nocopy JTF_NUMBER_TABLE

655: , p5_a21 JTF_NUMBER_TABLE
656: , p6_a0 out nocopy JTF_NUMBER_TABLE
657: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
659: , p6_a3 out nocopy JTF_NUMBER_TABLE
660: , p6_a4 out nocopy JTF_NUMBER_TABLE
661: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
662: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
663: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 660: , p6_a4 out nocopy JTF_NUMBER_TABLE

656: , p6_a0 out nocopy JTF_NUMBER_TABLE
657: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
659: , p6_a3 out nocopy JTF_NUMBER_TABLE
660: , p6_a4 out nocopy JTF_NUMBER_TABLE
661: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
662: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
663: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
664: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 677: , p6_a21 out nocopy JTF_NUMBER_TABLE

673: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
674: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
675: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
676: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
677: , p6_a21 out nocopy JTF_NUMBER_TABLE
678: )
679:
680: as
681: ddp_rulv_tbl okl_credit_checklist_pvt.rulv_tbl_type;

Line 890: , p5_a0 JTF_NUMBER_TABLE

886: , p_init_msg_list VARCHAR2
887: , x_return_status out nocopy VARCHAR2
888: , x_msg_count out nocopy NUMBER
889: , x_msg_data out nocopy VARCHAR2
890: , p5_a0 JTF_NUMBER_TABLE
891: , p5_a1 JTF_VARCHAR2_TABLE_100
892: , p5_a2 JTF_VARCHAR2_TABLE_200
893: , p5_a3 JTF_NUMBER_TABLE
894: , p5_a4 JTF_NUMBER_TABLE

Line 893: , p5_a3 JTF_NUMBER_TABLE

889: , x_msg_data out nocopy VARCHAR2
890: , p5_a0 JTF_NUMBER_TABLE
891: , p5_a1 JTF_VARCHAR2_TABLE_100
892: , p5_a2 JTF_VARCHAR2_TABLE_200
893: , p5_a3 JTF_NUMBER_TABLE
894: , p5_a4 JTF_NUMBER_TABLE
895: , p5_a5 JTF_VARCHAR2_TABLE_100
896: , p5_a6 JTF_VARCHAR2_TABLE_500
897: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 894: , p5_a4 JTF_NUMBER_TABLE

890: , p5_a0 JTF_NUMBER_TABLE
891: , p5_a1 JTF_VARCHAR2_TABLE_100
892: , p5_a2 JTF_VARCHAR2_TABLE_200
893: , p5_a3 JTF_NUMBER_TABLE
894: , p5_a4 JTF_NUMBER_TABLE
895: , p5_a5 JTF_VARCHAR2_TABLE_100
896: , p5_a6 JTF_VARCHAR2_TABLE_500
897: , p5_a7 JTF_VARCHAR2_TABLE_500
898: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 911: , p5_a21 JTF_NUMBER_TABLE

907: , p5_a17 JTF_VARCHAR2_TABLE_500
908: , p5_a18 JTF_VARCHAR2_TABLE_500
909: , p5_a19 JTF_VARCHAR2_TABLE_500
910: , p5_a20 JTF_VARCHAR2_TABLE_500
911: , p5_a21 JTF_NUMBER_TABLE
912: , p6_a0 out nocopy JTF_NUMBER_TABLE
913: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
915: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 912: , p6_a0 out nocopy JTF_NUMBER_TABLE

908: , p5_a18 JTF_VARCHAR2_TABLE_500
909: , p5_a19 JTF_VARCHAR2_TABLE_500
910: , p5_a20 JTF_VARCHAR2_TABLE_500
911: , p5_a21 JTF_NUMBER_TABLE
912: , p6_a0 out nocopy JTF_NUMBER_TABLE
913: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
915: , p6_a3 out nocopy JTF_NUMBER_TABLE
916: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 915: , p6_a3 out nocopy JTF_NUMBER_TABLE

911: , p5_a21 JTF_NUMBER_TABLE
912: , p6_a0 out nocopy JTF_NUMBER_TABLE
913: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
915: , p6_a3 out nocopy JTF_NUMBER_TABLE
916: , p6_a4 out nocopy JTF_NUMBER_TABLE
917: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
918: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
919: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 916: , p6_a4 out nocopy JTF_NUMBER_TABLE

912: , p6_a0 out nocopy JTF_NUMBER_TABLE
913: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
915: , p6_a3 out nocopy JTF_NUMBER_TABLE
916: , p6_a4 out nocopy JTF_NUMBER_TABLE
917: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
918: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
919: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
920: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 933: , p6_a21 out nocopy JTF_NUMBER_TABLE

929: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
930: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
931: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
932: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
933: , p6_a21 out nocopy JTF_NUMBER_TABLE
934: )
935:
936: as
937: ddp_rulv_tbl okl_credit_checklist_pvt.rulv_tbl_type;

Line 1098: , p5_a0 JTF_NUMBER_TABLE

1094: , p_init_msg_list VARCHAR2
1095: , x_return_status out nocopy VARCHAR2
1096: , x_msg_count out nocopy NUMBER
1097: , x_msg_data out nocopy VARCHAR2
1098: , p5_a0 JTF_NUMBER_TABLE
1099: , p5_a1 JTF_VARCHAR2_TABLE_100
1100: , p5_a2 JTF_VARCHAR2_TABLE_200
1101: , p5_a3 JTF_NUMBER_TABLE
1102: , p5_a4 JTF_NUMBER_TABLE

Line 1101: , p5_a3 JTF_NUMBER_TABLE

1097: , x_msg_data out nocopy VARCHAR2
1098: , p5_a0 JTF_NUMBER_TABLE
1099: , p5_a1 JTF_VARCHAR2_TABLE_100
1100: , p5_a2 JTF_VARCHAR2_TABLE_200
1101: , p5_a3 JTF_NUMBER_TABLE
1102: , p5_a4 JTF_NUMBER_TABLE
1103: , p5_a5 JTF_VARCHAR2_TABLE_100
1104: , p5_a6 JTF_VARCHAR2_TABLE_500
1105: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1102: , p5_a4 JTF_NUMBER_TABLE

1098: , p5_a0 JTF_NUMBER_TABLE
1099: , p5_a1 JTF_VARCHAR2_TABLE_100
1100: , p5_a2 JTF_VARCHAR2_TABLE_200
1101: , p5_a3 JTF_NUMBER_TABLE
1102: , p5_a4 JTF_NUMBER_TABLE
1103: , p5_a5 JTF_VARCHAR2_TABLE_100
1104: , p5_a6 JTF_VARCHAR2_TABLE_500
1105: , p5_a7 JTF_VARCHAR2_TABLE_500
1106: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 1119: , p5_a21 JTF_NUMBER_TABLE

1115: , p5_a17 JTF_VARCHAR2_TABLE_500
1116: , p5_a18 JTF_VARCHAR2_TABLE_500
1117: , p5_a19 JTF_VARCHAR2_TABLE_500
1118: , p5_a20 JTF_VARCHAR2_TABLE_500
1119: , p5_a21 JTF_NUMBER_TABLE
1120: , p6_a0 out nocopy JTF_NUMBER_TABLE
1121: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1122: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1123: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 1120: , p6_a0 out nocopy JTF_NUMBER_TABLE

1116: , p5_a18 JTF_VARCHAR2_TABLE_500
1117: , p5_a19 JTF_VARCHAR2_TABLE_500
1118: , p5_a20 JTF_VARCHAR2_TABLE_500
1119: , p5_a21 JTF_NUMBER_TABLE
1120: , p6_a0 out nocopy JTF_NUMBER_TABLE
1121: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1122: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1123: , p6_a3 out nocopy JTF_NUMBER_TABLE
1124: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 1123: , p6_a3 out nocopy JTF_NUMBER_TABLE

1119: , p5_a21 JTF_NUMBER_TABLE
1120: , p6_a0 out nocopy JTF_NUMBER_TABLE
1121: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1122: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1123: , p6_a3 out nocopy JTF_NUMBER_TABLE
1124: , p6_a4 out nocopy JTF_NUMBER_TABLE
1125: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1126: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1127: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 1124: , p6_a4 out nocopy JTF_NUMBER_TABLE

1120: , p6_a0 out nocopy JTF_NUMBER_TABLE
1121: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1122: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1123: , p6_a3 out nocopy JTF_NUMBER_TABLE
1124: , p6_a4 out nocopy JTF_NUMBER_TABLE
1125: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1126: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1127: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1128: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 1141: , p6_a21 out nocopy JTF_NUMBER_TABLE

1137: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1138: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1139: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1140: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1141: , p6_a21 out nocopy JTF_NUMBER_TABLE
1142: )
1143:
1144: as
1145: ddp_rulv_tbl okl_credit_checklist_pvt.rulv_tbl_type;

Line 1227: , p5_a0 JTF_NUMBER_TABLE

1223: , p_init_msg_list VARCHAR2
1224: , x_return_status out nocopy VARCHAR2
1225: , x_msg_count out nocopy NUMBER
1226: , x_msg_data out nocopy VARCHAR2
1227: , p5_a0 JTF_NUMBER_TABLE
1228: , p5_a1 JTF_VARCHAR2_TABLE_100
1229: , p5_a2 JTF_VARCHAR2_TABLE_200
1230: , p5_a3 JTF_NUMBER_TABLE
1231: , p5_a4 JTF_NUMBER_TABLE

Line 1230: , p5_a3 JTF_NUMBER_TABLE

1226: , x_msg_data out nocopy VARCHAR2
1227: , p5_a0 JTF_NUMBER_TABLE
1228: , p5_a1 JTF_VARCHAR2_TABLE_100
1229: , p5_a2 JTF_VARCHAR2_TABLE_200
1230: , p5_a3 JTF_NUMBER_TABLE
1231: , p5_a4 JTF_NUMBER_TABLE
1232: , p5_a5 JTF_VARCHAR2_TABLE_100
1233: , p5_a6 JTF_VARCHAR2_TABLE_500
1234: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1231: , p5_a4 JTF_NUMBER_TABLE

1227: , p5_a0 JTF_NUMBER_TABLE
1228: , p5_a1 JTF_VARCHAR2_TABLE_100
1229: , p5_a2 JTF_VARCHAR2_TABLE_200
1230: , p5_a3 JTF_NUMBER_TABLE
1231: , p5_a4 JTF_NUMBER_TABLE
1232: , p5_a5 JTF_VARCHAR2_TABLE_100
1233: , p5_a6 JTF_VARCHAR2_TABLE_500
1234: , p5_a7 JTF_VARCHAR2_TABLE_500
1235: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 1248: , p5_a21 JTF_NUMBER_TABLE

1244: , p5_a17 JTF_VARCHAR2_TABLE_500
1245: , p5_a18 JTF_VARCHAR2_TABLE_500
1246: , p5_a19 JTF_VARCHAR2_TABLE_500
1247: , p5_a20 JTF_VARCHAR2_TABLE_500
1248: , p5_a21 JTF_NUMBER_TABLE
1249: )
1250:
1251: as
1252: ddp_rulv_tbl okl_credit_checklist_pvt.rulv_tbl_type;