DBA Data[Home] [Help]

APPS.OKL_VP_RULE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body okl_vp_rule_pvt_w as
2: /* $Header: OKLERLGB.pls 120.6 2005/10/20 18:48:08 smereddy noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy okl_vp_rule_pvt.vrs_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_vp_rule_pvt_w as
2: /* $Header: OKLERLGB.pls 120.6 2005/10/20 18:48:08 smereddy noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy okl_vp_rule_pvt.vrs_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500
8: , a5 JTF_VARCHAR2_TABLE_100
9: ) as

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500
8: , a5 JTF_VARCHAR2_TABLE_100
9: ) as
10: ddindx binary_integer; indx binary_integer;
11: begin
12: if a0 is not null and a0.count > 0 then

Line 33: , a1 out nocopy JTF_VARCHAR2_TABLE_100

29: end if;
30: end if;
31: end rosetta_table_copy_in_p3;
32: procedure rosetta_table_copy_out_p3(t okl_vp_rule_pvt.vrs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_VARCHAR2_TABLE_500
36: , a4 out nocopy JTF_VARCHAR2_TABLE_500
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 34: , a2 out nocopy JTF_VARCHAR2_TABLE_100

30: end if;
31: end rosetta_table_copy_in_p3;
32: procedure rosetta_table_copy_out_p3(t okl_vp_rule_pvt.vrs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_VARCHAR2_TABLE_500
36: , a4 out nocopy JTF_VARCHAR2_TABLE_500
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: ) as

Line 37: , a5 out nocopy JTF_VARCHAR2_TABLE_100

33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_VARCHAR2_TABLE_500
36: , a4 out nocopy JTF_VARCHAR2_TABLE_500
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: ) as
39: ddindx binary_integer; indx binary_integer;
40: begin
41: if t is null or t.count = 0 then

Line 43: a1 := JTF_VARCHAR2_TABLE_100();

39: ddindx binary_integer; indx binary_integer;
40: begin
41: if t is null or t.count = 0 then
42: a0 := JTF_NUMBER_TABLE();
43: a1 := JTF_VARCHAR2_TABLE_100();
44: a2 := JTF_VARCHAR2_TABLE_100();
45: a3 := JTF_VARCHAR2_TABLE_500();
46: a4 := JTF_VARCHAR2_TABLE_500();
47: a5 := JTF_VARCHAR2_TABLE_100();

Line 44: a2 := JTF_VARCHAR2_TABLE_100();

40: begin
41: if t is null or t.count = 0 then
42: a0 := JTF_NUMBER_TABLE();
43: a1 := JTF_VARCHAR2_TABLE_100();
44: a2 := JTF_VARCHAR2_TABLE_100();
45: a3 := JTF_VARCHAR2_TABLE_500();
46: a4 := JTF_VARCHAR2_TABLE_500();
47: a5 := JTF_VARCHAR2_TABLE_100();
48: else

Line 47: a5 := JTF_VARCHAR2_TABLE_100();

43: a1 := JTF_VARCHAR2_TABLE_100();
44: a2 := JTF_VARCHAR2_TABLE_100();
45: a3 := JTF_VARCHAR2_TABLE_500();
46: a4 := JTF_VARCHAR2_TABLE_500();
47: a5 := JTF_VARCHAR2_TABLE_100();
48: else
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();

Line 50: a1 := JTF_VARCHAR2_TABLE_100();

46: a4 := JTF_VARCHAR2_TABLE_500();
47: a5 := JTF_VARCHAR2_TABLE_100();
48: else
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_VARCHAR2_TABLE_500();
53: a4 := JTF_VARCHAR2_TABLE_500();
54: a5 := JTF_VARCHAR2_TABLE_100();

Line 51: a2 := JTF_VARCHAR2_TABLE_100();

47: a5 := JTF_VARCHAR2_TABLE_100();
48: else
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_VARCHAR2_TABLE_500();
53: a4 := JTF_VARCHAR2_TABLE_500();
54: a5 := JTF_VARCHAR2_TABLE_100();
55: if t.count > 0 then

Line 54: a5 := JTF_VARCHAR2_TABLE_100();

50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_VARCHAR2_TABLE_500();
53: a4 := JTF_VARCHAR2_TABLE_500();
54: a5 := JTF_VARCHAR2_TABLE_100();
55: if t.count > 0 then
56: a0.extend(t.count);
57: a1.extend(t.count);
58: a2.extend(t.count);

Line 522: , p7_a1 JTF_VARCHAR2_TABLE_100

518: , x_msg_data out nocopy VARCHAR2
519: , p_chr_id NUMBER
520: , p_rgp_id NUMBER
521: , p7_a0 JTF_NUMBER_TABLE
522: , p7_a1 JTF_VARCHAR2_TABLE_100
523: , p7_a2 JTF_VARCHAR2_TABLE_100
524: , p7_a3 JTF_VARCHAR2_TABLE_500
525: , p7_a4 JTF_VARCHAR2_TABLE_500
526: , p7_a5 JTF_VARCHAR2_TABLE_100

Line 523: , p7_a2 JTF_VARCHAR2_TABLE_100

519: , p_chr_id NUMBER
520: , p_rgp_id NUMBER
521: , p7_a0 JTF_NUMBER_TABLE
522: , p7_a1 JTF_VARCHAR2_TABLE_100
523: , p7_a2 JTF_VARCHAR2_TABLE_100
524: , p7_a3 JTF_VARCHAR2_TABLE_500
525: , p7_a4 JTF_VARCHAR2_TABLE_500
526: , p7_a5 JTF_VARCHAR2_TABLE_100
527: )

Line 526: , p7_a5 JTF_VARCHAR2_TABLE_100

522: , p7_a1 JTF_VARCHAR2_TABLE_100
523: , p7_a2 JTF_VARCHAR2_TABLE_100
524: , p7_a3 JTF_VARCHAR2_TABLE_500
525: , p7_a4 JTF_VARCHAR2_TABLE_500
526: , p7_a5 JTF_VARCHAR2_TABLE_100
527: )
528:
529: as
530: ddp_vrs_tbl okl_vp_rule_pvt.vrs_tbl_type;