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
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
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
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
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
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
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();
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();
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();
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();
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();
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();
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
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
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
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
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
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
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
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
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
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
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
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