eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CNTR_GRP_BILLING_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p14(t out nocopy okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 5: , a2 JTF_NUMBER_TABLE

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
9: , a6 JTF_VARCHAR2_TABLE_100

Line 13: , a10 JTF_NUMBER_TABLE

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
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: ) as

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: ) as
18: ddindx binary_integer; indx binary_integer;
19: begin

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: ) as
18: ddindx binary_integer; indx binary_integer;
19: begin
20: if a0 is not null and a0.count > 0 then

Line 48: procedure rosetta_table_copy_out_p14(t okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

44: end loop;
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

Line 50: , a2 out nocopy JTF_NUMBER_TABLE

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
54: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 58: , a10 out nocopy JTF_NUMBER_TABLE

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
60: , a12 out nocopy JTF_NUMBER_TABLE
61: , a13 out nocopy JTF_NUMBER_TABLE
62: ) as

Line 60: , a12 out nocopy JTF_NUMBER_TABLE

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
60: , a12 out nocopy JTF_NUMBER_TABLE
61: , a13 out nocopy JTF_NUMBER_TABLE
62: ) as
63: ddindx binary_integer; indx binary_integer;
64: begin

Line 61: , a13 out nocopy JTF_NUMBER_TABLE

57: , a9 out nocopy JTF_DATE_TABLE
58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_DATE_TABLE
60: , a12 out nocopy JTF_NUMBER_TABLE
61: , a13 out nocopy JTF_NUMBER_TABLE
62: ) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then

Line 66: a0 := JTF_NUMBER_TABLE();

62: ) as
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();

Line 68: a2 := JTF_NUMBER_TABLE();

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();
72: a6 := JTF_VARCHAR2_TABLE_100();

Line 76: a10 := JTF_NUMBER_TABLE();

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

Line 78: a12 := JTF_NUMBER_TABLE();

74: a8 := JTF_DATE_TABLE();
75: a9 := JTF_DATE_TABLE();
76: a10 := JTF_NUMBER_TABLE();
77: a11 := 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();

Line 79: a13 := JTF_NUMBER_TABLE();

75: a9 := JTF_DATE_TABLE();
76: a10 := JTF_NUMBER_TABLE();
77: a11 := 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();

Line 81: a0 := JTF_NUMBER_TABLE();

77: a11 := 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();

Line 83: a2 := 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();
87: a6 := JTF_VARCHAR2_TABLE_100();

Line 91: a10 := JTF_NUMBER_TABLE();

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();
93: a12 := JTF_NUMBER_TABLE();
94: a13 := JTF_NUMBER_TABLE();
95: if t.count > 0 then

Line 93: a12 := JTF_NUMBER_TABLE();

89: a8 := JTF_DATE_TABLE();
90: a9 := JTF_DATE_TABLE();
91: a10 := JTF_NUMBER_TABLE();
92: a11 := JTF_DATE_TABLE();
93: a12 := JTF_NUMBER_TABLE();
94: a13 := JTF_NUMBER_TABLE();
95: if t.count > 0 then
96: a0.extend(t.count);
97: a1.extend(t.count);

Line 94: a13 := JTF_NUMBER_TABLE();

90: a9 := JTF_DATE_TABLE();
91: a10 := JTF_NUMBER_TABLE();
92: a11 := JTF_DATE_TABLE();
93: a12 := JTF_NUMBER_TABLE();
94: a13 := JTF_NUMBER_TABLE();
95: if t.count > 0 then
96: a0.extend(t.count);
97: a1.extend(t.count);
98: a2.extend(t.count);

Line 237: , p5_a0 JTF_NUMBER_TABLE

233: , p_init_msg_list VARCHAR2
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

Line 239: , p5_a2 JTF_NUMBER_TABLE

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
243: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 247: , p5_a10 JTF_NUMBER_TABLE

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
249: , p5_a12 JTF_NUMBER_TABLE
250: , p5_a13 JTF_NUMBER_TABLE
251: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 249: , p5_a12 JTF_NUMBER_TABLE

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

Line 250: , p5_a13 JTF_NUMBER_TABLE

246: , p5_a9 JTF_DATE_TABLE
247: , p5_a10 JTF_NUMBER_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

Line 251: , p6_a0 out nocopy JTF_NUMBER_TABLE

247: , p5_a10 JTF_NUMBER_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

Line 253: , p6_a2 out nocopy JTF_NUMBER_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
257: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 261: , p6_a10 out nocopy JTF_NUMBER_TABLE

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
263: , p6_a12 out nocopy JTF_NUMBER_TABLE
264: , p6_a13 out nocopy JTF_NUMBER_TABLE
265: )

Line 263: , p6_a12 out nocopy JTF_NUMBER_TABLE

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
263: , p6_a12 out nocopy JTF_NUMBER_TABLE
264: , p6_a13 out nocopy JTF_NUMBER_TABLE
265: )
266:
267: as

Line 264: , p6_a13 out nocopy JTF_NUMBER_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
263: , p6_a12 out nocopy JTF_NUMBER_TABLE
264: , p6_a13 out nocopy JTF_NUMBER_TABLE
265: )
266:
267: as
268: ddp_cntr_bill_tbl okl_cntr_grp_billing_pvt.cntr_bill_tbl_type;

Line 429: , p5_a0 JTF_NUMBER_TABLE

425: , p_init_msg_list VARCHAR2
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

Line 431: , p5_a2 JTF_NUMBER_TABLE

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
435: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 439: , p5_a10 JTF_NUMBER_TABLE

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
441: , p5_a12 JTF_NUMBER_TABLE
442: , p5_a13 JTF_NUMBER_TABLE
443: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 441: , p5_a12 JTF_NUMBER_TABLE

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

Line 442: , p5_a13 JTF_NUMBER_TABLE

438: , p5_a9 JTF_DATE_TABLE
439: , p5_a10 JTF_NUMBER_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

Line 443: , p6_a0 out nocopy JTF_NUMBER_TABLE

439: , p5_a10 JTF_NUMBER_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

Line 445: , p6_a2 out nocopy JTF_NUMBER_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
449: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 453: , p6_a10 out nocopy JTF_NUMBER_TABLE

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
455: , p6_a12 out nocopy JTF_NUMBER_TABLE
456: , p6_a13 out nocopy JTF_NUMBER_TABLE
457: )

Line 455: , p6_a12 out nocopy JTF_NUMBER_TABLE

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
455: , p6_a12 out nocopy JTF_NUMBER_TABLE
456: , p6_a13 out nocopy JTF_NUMBER_TABLE
457: )
458:
459: as

Line 456: , p6_a13 out nocopy JTF_NUMBER_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
455: , p6_a12 out nocopy JTF_NUMBER_TABLE
456: , p6_a13 out nocopy JTF_NUMBER_TABLE
457: )
458:
459: as
460: ddp_cntr_bill_tbl okl_cntr_grp_billing_pvt.cntr_bill_tbl_type;