DBA Data[Home] [Help]

APPS.CN_TRX_FACTOR_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_tbl_type, a0 JTF_NUMBER_TABLE

1: package body cn_trx_factor_pvt_w as
2: /* $Header: cnwtxftb.pls 120.2 2005/09/14 04:30 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package body cn_trx_factor_pvt_w as
2: /* $Header: cnwtxftb.pls 120.2 2005/09/14 04:30 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_NUMBER_TABLE

1: package body cn_trx_factor_pvt_w as
2: /* $Header: cnwtxftb.pls 120.2 2005/09/14 04:30 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: cnwtxftb.pls 120.2 2005/09/14 04:30 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: ) as

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: ) as
12: ddindx binary_integer; indx binary_integer;
13: begin

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: ) as
12: ddindx binary_integer; indx binary_integer;
13: begin
14: if a0 is not null and a0.count > 0 then

Line 36: procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

32: end loop;
33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE

Line 37: , a1 out nocopy JTF_NUMBER_TABLE

33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 38: , a2 out nocopy JTF_NUMBER_TABLE

34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE

Line 39: , a3 out nocopy JTF_NUMBER_TABLE

35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE

Line 40: , a4 out nocopy JTF_NUMBER_TABLE

36: procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as

Line 42: , a6 out nocopy JTF_NUMBER_TABLE

38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin

Line 43: , a7 out nocopy JTF_NUMBER_TABLE

39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then

Line 48: a0 := JTF_NUMBER_TABLE();

44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();

Line 49: a1 := JTF_NUMBER_TABLE();

45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();

Line 50: a2 := JTF_NUMBER_TABLE();

46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();

Line 51: a3 := JTF_NUMBER_TABLE();

47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();

Line 52: a4 := JTF_NUMBER_TABLE();

48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
56: else

Line 54: a6 := JTF_NUMBER_TABLE();

50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();

Line 55: a7 := JTF_NUMBER_TABLE();

51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();

Line 57: a0 := JTF_NUMBER_TABLE();

53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();

Line 58: a1 := JTF_NUMBER_TABLE();

54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();

Line 59: a2 := JTF_NUMBER_TABLE();

55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_NUMBER_TABLE();

Line 60: a3 := JTF_NUMBER_TABLE();

56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_NUMBER_TABLE();

Line 61: a4 := JTF_NUMBER_TABLE();

57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then

Line 63: a6 := JTF_NUMBER_TABLE();

59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then
66: a0.extend(t.count);
67: a1.extend(t.count);

Line 64: a7 := JTF_NUMBER_TABLE();

60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then
66: a0.extend(t.count);
67: a1.extend(t.count);
68: a2.extend(t.count);

Line 392: , p5_a0 out nocopy JTF_NUMBER_TABLE

388: , p_init_msg_list VARCHAR2
389: , p_commit VARCHAR2
390: , p_validation_level NUMBER
391: , p_quota_rule_id NUMBER
392: , p5_a0 out nocopy JTF_NUMBER_TABLE
393: , p5_a1 out nocopy JTF_NUMBER_TABLE
394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE

Line 393: , p5_a1 out nocopy JTF_NUMBER_TABLE

389: , p_commit VARCHAR2
390: , p_validation_level NUMBER
391: , p_quota_rule_id NUMBER
392: , p5_a0 out nocopy JTF_NUMBER_TABLE
393: , p5_a1 out nocopy JTF_NUMBER_TABLE
394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 394: , p5_a2 out nocopy JTF_NUMBER_TABLE

390: , p_validation_level NUMBER
391: , p_quota_rule_id NUMBER
392: , p5_a0 out nocopy JTF_NUMBER_TABLE
393: , p5_a1 out nocopy JTF_NUMBER_TABLE
394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
398: , p5_a6 out nocopy JTF_NUMBER_TABLE

Line 395: , p5_a3 out nocopy JTF_NUMBER_TABLE

391: , p_quota_rule_id NUMBER
392: , p5_a0 out nocopy JTF_NUMBER_TABLE
393: , p5_a1 out nocopy JTF_NUMBER_TABLE
394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
398: , p5_a6 out nocopy JTF_NUMBER_TABLE
399: , p5_a7 out nocopy JTF_NUMBER_TABLE

Line 396: , p5_a4 out nocopy JTF_NUMBER_TABLE

392: , p5_a0 out nocopy JTF_NUMBER_TABLE
393: , p5_a1 out nocopy JTF_NUMBER_TABLE
394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
398: , p5_a6 out nocopy JTF_NUMBER_TABLE
399: , p5_a7 out nocopy JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2

Line 398: , p5_a6 out nocopy JTF_NUMBER_TABLE

394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
398: , p5_a6 out nocopy JTF_NUMBER_TABLE
399: , p5_a7 out nocopy JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2

Line 399: , p5_a7 out nocopy JTF_NUMBER_TABLE

395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
398: , p5_a6 out nocopy JTF_NUMBER_TABLE
399: , p5_a7 out nocopy JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2
403: )