DBA Data[Home] [Help]

APPS.OKL_CNTR_GRP_BILLING_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 4: , a1 JTF_VARCHAR2_TABLE_200

1: package body okl_cntr_grp_billing_pvt_w as
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

Line 7: , a4 JTF_VARCHAR2_TABLE_200

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
11: , a8 JTF_DATE_TABLE

Line 8: , a5 JTF_VARCHAR2_TABLE_200

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
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE

Line 49: , a1 out nocopy JTF_VARCHAR2_TABLE_200

45: end if;
46: end if;
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

Line 52: , a4 out nocopy JTF_VARCHAR2_TABLE_200

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
56: , a8 out nocopy JTF_DATE_TABLE

Line 53: , a5 out nocopy JTF_VARCHAR2_TABLE_200

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
56: , a8 out nocopy JTF_DATE_TABLE
57: , a9 out nocopy JTF_DATE_TABLE

Line 67: a1 := JTF_VARCHAR2_TABLE_200();

63: ddindx binary_integer; indx binary_integer;
64: begin
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();

Line 70: a4 := JTF_VARCHAR2_TABLE_200();

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();
74: a8 := JTF_DATE_TABLE();

Line 71: a5 := JTF_VARCHAR2_TABLE_200();

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();
74: a8 := JTF_DATE_TABLE();
75: a9 := JTF_DATE_TABLE();

Line 82: a1 := JTF_VARCHAR2_TABLE_200();

78: a12 := JTF_NUMBER_TABLE();
79: a13 := JTF_NUMBER_TABLE();
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();

Line 85: a4 := JTF_VARCHAR2_TABLE_200();

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();
89: a8 := JTF_DATE_TABLE();

Line 86: a5 := JTF_VARCHAR2_TABLE_200();

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();
89: a8 := JTF_DATE_TABLE();
90: a9 := JTF_DATE_TABLE();

Line 238: , p5_a1 JTF_VARCHAR2_TABLE_200

234: , x_return_status out nocopy VARCHAR2
235: , x_msg_count out nocopy NUMBER
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

Line 241: , p5_a4 JTF_VARCHAR2_TABLE_200

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
245: , p5_a8 JTF_DATE_TABLE

Line 242: , p5_a5 JTF_VARCHAR2_TABLE_200

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
245: , p5_a8 JTF_DATE_TABLE
246: , p5_a9 JTF_DATE_TABLE

Line 252: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

248: , p5_a11 JTF_DATE_TABLE
249: , p5_a12 JTF_NUMBER_TABLE
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

Line 255: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

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
259: , p6_a8 out nocopy JTF_DATE_TABLE

Line 256: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

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
259: , p6_a8 out nocopy JTF_DATE_TABLE
260: , p6_a9 out nocopy JTF_DATE_TABLE

Line 430: , p5_a1 JTF_VARCHAR2_TABLE_200

426: , x_return_status out nocopy VARCHAR2
427: , x_msg_count out nocopy NUMBER
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

Line 433: , p5_a4 JTF_VARCHAR2_TABLE_200

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
437: , p5_a8 JTF_DATE_TABLE

Line 434: , p5_a5 JTF_VARCHAR2_TABLE_200

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
437: , p5_a8 JTF_DATE_TABLE
438: , p5_a9 JTF_DATE_TABLE

Line 444: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

440: , p5_a11 JTF_DATE_TABLE
441: , p5_a12 JTF_NUMBER_TABLE
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

Line 447: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

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
451: , p6_a8 out nocopy JTF_DATE_TABLE

Line 448: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

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
451: , p6_a8 out nocopy JTF_DATE_TABLE
452: , p6_a9 out nocopy JTF_DATE_TABLE