DBA Data[Home] [Help]

APPS.OKL_VP_STS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_vp_sts_pvt.vp_sts_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body okl_vp_sts_pvt_w as
2: /* $Header: OKLESSCB.pls 120.2 2005/08/04 03:07:03 manumanu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_vp_sts_pvt.vp_sts_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body okl_vp_sts_pvt_w as
2: /* $Header: OKLESSCB.pls 120.2 2005/08/04 03:07:03 manumanu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_vp_sts_pvt.vp_sts_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin
8: if a0 is not null and a0.count > 0 then

Line 24: procedure rosetta_table_copy_out_p1(t okl_vp_sts_pvt.vp_sts_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

20: end loop;
21: end if;
22: end if;
23: end rosetta_table_copy_in_p1;
24: procedure rosetta_table_copy_out_p1(t okl_vp_sts_pvt.vp_sts_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_VARCHAR2_TABLE_100
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin

Line 25: , a1 out nocopy JTF_VARCHAR2_TABLE_100

21: end if;
22: end if;
23: end rosetta_table_copy_in_p1;
24: procedure rosetta_table_copy_out_p1(t okl_vp_sts_pvt.vp_sts_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_VARCHAR2_TABLE_100
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if t is null or t.count = 0 then

Line 30: a0 := JTF_VARCHAR2_TABLE_100();

26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if t is null or t.count = 0 then
30: a0 := JTF_VARCHAR2_TABLE_100();
31: a1 := JTF_VARCHAR2_TABLE_100();
32: else
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_VARCHAR2_TABLE_100();

Line 31: a1 := JTF_VARCHAR2_TABLE_100();

27: ddindx binary_integer; indx binary_integer;
28: begin
29: if t is null or t.count = 0 then
30: a0 := JTF_VARCHAR2_TABLE_100();
31: a1 := JTF_VARCHAR2_TABLE_100();
32: else
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: if t.count > 0 then

Line 33: a0 := JTF_VARCHAR2_TABLE_100();

29: if t is null or t.count = 0 then
30: a0 := JTF_VARCHAR2_TABLE_100();
31: a1 := JTF_VARCHAR2_TABLE_100();
32: else
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: if t.count > 0 then
36: a0.extend(t.count);
37: a1.extend(t.count);

Line 34: a1 := JTF_VARCHAR2_TABLE_100();

30: a0 := JTF_VARCHAR2_TABLE_100();
31: a1 := JTF_VARCHAR2_TABLE_100();
32: else
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: if t.count > 0 then
36: a0.extend(t.count);
37: a1.extend(t.count);
38: ddindx := t.first;

Line 62: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100

58: , p_ste_code VARCHAR2
59: , p_sts_code VARCHAR2
60: , p_start_date DATE
61: , p_end_date DATE
62: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
63: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
64: )
65:
66: as

Line 63: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

59: , p_sts_code VARCHAR2
60: , p_start_date DATE
61: , p_end_date DATE
62: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
63: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
64: )
65:
66: as
67: ddx_sts_tbl okl_vp_sts_pvt.sts_tbl_type;