DBA Data[Home] [Help]

APPS.OKL_POPULATE_PRCENG_RST_PUB_W dependencies on JTF_VARCHAR2_TABLE_200

Line 22: procedure rosetta_table_copy_in_p19(t out nocopy okl_populate_prceng_rst_pub.strm_tbl_type, a0 JTF_VARCHAR2_TABLE_200

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p19(t out nocopy okl_populate_prceng_rst_pub.strm_tbl_type, a0 JTF_VARCHAR2_TABLE_200
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 23: , a1 JTF_VARCHAR2_TABLE_200

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p19(t out nocopy okl_populate_prceng_rst_pub.strm_tbl_type, a0 JTF_VARCHAR2_TABLE_200
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: ) as

Line 49: procedure rosetta_table_copy_out_p19(t okl_populate_prceng_rst_pub.strm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200

45: end loop;
46: end if;
47: end if;
48: end rosetta_table_copy_in_p19;
49: procedure rosetta_table_copy_out_p19(t okl_populate_prceng_rst_pub.strm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
50: , a1 out nocopy JTF_VARCHAR2_TABLE_200
51: , a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_NUMBER_TABLE

Line 50: , a1 out nocopy JTF_VARCHAR2_TABLE_200

46: end if;
47: end if;
48: end rosetta_table_copy_in_p19;
49: procedure rosetta_table_copy_out_p19(t okl_populate_prceng_rst_pub.strm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
50: , a1 out nocopy JTF_VARCHAR2_TABLE_200
51: , a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_NUMBER_TABLE
54: ) as

Line 58: a0 := JTF_VARCHAR2_TABLE_200();

54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin
57: if t is null or t.count = 0 then
58: a0 := JTF_VARCHAR2_TABLE_200();
59: a1 := JTF_VARCHAR2_TABLE_200();
60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_NUMBER_TABLE();

Line 59: a1 := JTF_VARCHAR2_TABLE_200();

55: ddindx binary_integer; indx binary_integer;
56: begin
57: if t is null or t.count = 0 then
58: a0 := JTF_VARCHAR2_TABLE_200();
59: a1 := JTF_VARCHAR2_TABLE_200();
60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_NUMBER_TABLE();
63: else

Line 64: a0 := JTF_VARCHAR2_TABLE_200();

60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_NUMBER_TABLE();
63: else
64: a0 := JTF_VARCHAR2_TABLE_200();
65: a1 := JTF_VARCHAR2_TABLE_200();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_NUMBER_TABLE();
68: a4 := JTF_NUMBER_TABLE();

Line 65: a1 := JTF_VARCHAR2_TABLE_200();

61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_NUMBER_TABLE();
63: else
64: a0 := JTF_VARCHAR2_TABLE_200();
65: a1 := JTF_VARCHAR2_TABLE_200();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_NUMBER_TABLE();
68: a4 := JTF_NUMBER_TABLE();
69: if t.count > 0 then

Line 152: , p2_a0 JTF_VARCHAR2_TABLE_200

148: end rosetta_table_copy_out_p21;
149:
150: procedure populate_sif_ret_strms(x_return_status out nocopy VARCHAR2
151: , p_index_number NUMBER
152: , p2_a0 JTF_VARCHAR2_TABLE_200
153: , p2_a1 JTF_VARCHAR2_TABLE_200
154: , p2_a2 JTF_VARCHAR2_TABLE_100
155: , p2_a3 JTF_NUMBER_TABLE
156: , p2_a4 JTF_NUMBER_TABLE

Line 153: , p2_a1 JTF_VARCHAR2_TABLE_200

149:
150: procedure populate_sif_ret_strms(x_return_status out nocopy VARCHAR2
151: , p_index_number NUMBER
152: , p2_a0 JTF_VARCHAR2_TABLE_200
153: , p2_a1 JTF_VARCHAR2_TABLE_200
154: , p2_a2 JTF_VARCHAR2_TABLE_100
155: , p2_a3 JTF_NUMBER_TABLE
156: , p2_a4 JTF_NUMBER_TABLE
157: , p_sir_id NUMBER