DBA Data[Home] [Help]

APPS.OKL_CNTR_GRP_BILLING_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLICLBB.pls 120.3 2008/02/21 13:25:14 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p14(t out nocopy okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE

Line 51: , a3 out nocopy JTF_VARCHAR2_TABLE_100

47: end rosetta_table_copy_in_p14;
48: procedure rosetta_table_copy_out_p14(t okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_200
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_200
53: , a5 out nocopy JTF_VARCHAR2_TABLE_200
54: , a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 54: , a6 out nocopy JTF_VARCHAR2_TABLE_100

50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_200
53: , a5 out nocopy JTF_VARCHAR2_TABLE_200
54: , a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_DATE_TABLE
57: , a9 out nocopy JTF_DATE_TABLE
58: , a10 out nocopy JTF_NUMBER_TABLE

Line 55: , a7 out nocopy JTF_VARCHAR2_TABLE_100

51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_200
53: , a5 out nocopy JTF_VARCHAR2_TABLE_200
54: , a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_DATE_TABLE
57: , a9 out nocopy JTF_DATE_TABLE
58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_DATE_TABLE

Line 69: a3 := JTF_VARCHAR2_TABLE_100();

65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_VARCHAR2_TABLE_200();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_VARCHAR2_TABLE_200();
71: a5 := JTF_VARCHAR2_TABLE_200();
72: a6 := JTF_VARCHAR2_TABLE_100();
73: a7 := JTF_VARCHAR2_TABLE_100();

Line 72: a6 := JTF_VARCHAR2_TABLE_100();

68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_VARCHAR2_TABLE_200();
71: a5 := JTF_VARCHAR2_TABLE_200();
72: a6 := JTF_VARCHAR2_TABLE_100();
73: a7 := JTF_VARCHAR2_TABLE_100();
74: a8 := JTF_DATE_TABLE();
75: a9 := JTF_DATE_TABLE();
76: a10 := JTF_NUMBER_TABLE();

Line 73: a7 := JTF_VARCHAR2_TABLE_100();

69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_VARCHAR2_TABLE_200();
71: a5 := JTF_VARCHAR2_TABLE_200();
72: a6 := JTF_VARCHAR2_TABLE_100();
73: a7 := JTF_VARCHAR2_TABLE_100();
74: a8 := JTF_DATE_TABLE();
75: a9 := JTF_DATE_TABLE();
76: a10 := JTF_NUMBER_TABLE();
77: a11 := JTF_DATE_TABLE();

Line 84: a3 := JTF_VARCHAR2_TABLE_100();

80: else
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_VARCHAR2_TABLE_200();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_VARCHAR2_TABLE_200();
86: a5 := JTF_VARCHAR2_TABLE_200();
87: a6 := JTF_VARCHAR2_TABLE_100();
88: a7 := JTF_VARCHAR2_TABLE_100();

Line 87: a6 := JTF_VARCHAR2_TABLE_100();

83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_VARCHAR2_TABLE_200();
86: a5 := JTF_VARCHAR2_TABLE_200();
87: a6 := JTF_VARCHAR2_TABLE_100();
88: a7 := JTF_VARCHAR2_TABLE_100();
89: a8 := JTF_DATE_TABLE();
90: a9 := JTF_DATE_TABLE();
91: a10 := JTF_NUMBER_TABLE();

Line 88: a7 := JTF_VARCHAR2_TABLE_100();

84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_VARCHAR2_TABLE_200();
86: a5 := JTF_VARCHAR2_TABLE_200();
87: a6 := JTF_VARCHAR2_TABLE_100();
88: a7 := JTF_VARCHAR2_TABLE_100();
89: a8 := JTF_DATE_TABLE();
90: a9 := JTF_DATE_TABLE();
91: a10 := JTF_NUMBER_TABLE();
92: a11 := JTF_DATE_TABLE();

Line 240: , p5_a3 JTF_VARCHAR2_TABLE_100

236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_VARCHAR2_TABLE_200
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_200
242: , p5_a5 JTF_VARCHAR2_TABLE_200
243: , p5_a6 JTF_VARCHAR2_TABLE_100
244: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 243: , p5_a6 JTF_VARCHAR2_TABLE_100

239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_200
242: , p5_a5 JTF_VARCHAR2_TABLE_200
243: , p5_a6 JTF_VARCHAR2_TABLE_100
244: , p5_a7 JTF_VARCHAR2_TABLE_100
245: , p5_a8 JTF_DATE_TABLE
246: , p5_a9 JTF_DATE_TABLE
247: , p5_a10 JTF_NUMBER_TABLE

Line 244: , p5_a7 JTF_VARCHAR2_TABLE_100

240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_200
242: , p5_a5 JTF_VARCHAR2_TABLE_200
243: , p5_a6 JTF_VARCHAR2_TABLE_100
244: , p5_a7 JTF_VARCHAR2_TABLE_100
245: , p5_a8 JTF_DATE_TABLE
246: , p5_a9 JTF_DATE_TABLE
247: , p5_a10 JTF_NUMBER_TABLE
248: , p5_a11 JTF_DATE_TABLE

Line 254: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

250: , p5_a13 JTF_NUMBER_TABLE
251: , p6_a0 out nocopy JTF_NUMBER_TABLE
252: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
253: , p6_a2 out nocopy JTF_NUMBER_TABLE
254: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
257: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
258: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 257: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

253: , p6_a2 out nocopy JTF_NUMBER_TABLE
254: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
257: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
258: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a8 out nocopy JTF_DATE_TABLE
260: , p6_a9 out nocopy JTF_DATE_TABLE
261: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 258: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

254: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
257: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
258: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a8 out nocopy JTF_DATE_TABLE
260: , p6_a9 out nocopy JTF_DATE_TABLE
261: , p6_a10 out nocopy JTF_NUMBER_TABLE
262: , p6_a11 out nocopy JTF_DATE_TABLE

Line 432: , p5_a3 JTF_VARCHAR2_TABLE_100

428: , x_msg_data out nocopy VARCHAR2
429: , p5_a0 JTF_NUMBER_TABLE
430: , p5_a1 JTF_VARCHAR2_TABLE_200
431: , p5_a2 JTF_NUMBER_TABLE
432: , p5_a3 JTF_VARCHAR2_TABLE_100
433: , p5_a4 JTF_VARCHAR2_TABLE_200
434: , p5_a5 JTF_VARCHAR2_TABLE_200
435: , p5_a6 JTF_VARCHAR2_TABLE_100
436: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 435: , p5_a6 JTF_VARCHAR2_TABLE_100

431: , p5_a2 JTF_NUMBER_TABLE
432: , p5_a3 JTF_VARCHAR2_TABLE_100
433: , p5_a4 JTF_VARCHAR2_TABLE_200
434: , p5_a5 JTF_VARCHAR2_TABLE_200
435: , p5_a6 JTF_VARCHAR2_TABLE_100
436: , p5_a7 JTF_VARCHAR2_TABLE_100
437: , p5_a8 JTF_DATE_TABLE
438: , p5_a9 JTF_DATE_TABLE
439: , p5_a10 JTF_NUMBER_TABLE

Line 436: , p5_a7 JTF_VARCHAR2_TABLE_100

432: , p5_a3 JTF_VARCHAR2_TABLE_100
433: , p5_a4 JTF_VARCHAR2_TABLE_200
434: , p5_a5 JTF_VARCHAR2_TABLE_200
435: , p5_a6 JTF_VARCHAR2_TABLE_100
436: , p5_a7 JTF_VARCHAR2_TABLE_100
437: , p5_a8 JTF_DATE_TABLE
438: , p5_a9 JTF_DATE_TABLE
439: , p5_a10 JTF_NUMBER_TABLE
440: , p5_a11 JTF_DATE_TABLE

Line 446: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

442: , p5_a13 JTF_NUMBER_TABLE
443: , p6_a0 out nocopy JTF_NUMBER_TABLE
444: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
445: , p6_a2 out nocopy JTF_NUMBER_TABLE
446: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
447: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
448: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
449: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 449: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

445: , p6_a2 out nocopy JTF_NUMBER_TABLE
446: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
447: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
448: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
449: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
451: , p6_a8 out nocopy JTF_DATE_TABLE
452: , p6_a9 out nocopy JTF_DATE_TABLE
453: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 450: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

446: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
447: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
448: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
449: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
451: , p6_a8 out nocopy JTF_DATE_TABLE
452: , p6_a9 out nocopy JTF_DATE_TABLE
453: , p6_a10 out nocopy JTF_NUMBER_TABLE
454: , p6_a11 out nocopy JTF_DATE_TABLE