DBA Data[Home] [Help]

APPS.CSP_PART_SEARCH_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy csp_part_search_pvt.required_parts_tbl, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy csp_part_search_pvt.required_parts_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: ) as
20: ddindx binary_integer; indx binary_integer;

Line 18: , a2 JTF_NUMBER_TABLE

14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy csp_part_search_pvt.required_parts_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: ) as
20: ddindx binary_integer; indx binary_integer;
21: begin
22: if a0 is not null and a0.count > 0 then

Line 39: procedure rosetta_table_copy_out_p2(t csp_part_search_pvt.required_parts_tbl, a0 out nocopy JTF_NUMBER_TABLE

35: end loop;
36: end if;
37: end if;
38: end rosetta_table_copy_in_p2;
39: procedure rosetta_table_copy_out_p2(t csp_part_search_pvt.required_parts_tbl, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_VARCHAR2_TABLE_100
41: , a2 out nocopy JTF_NUMBER_TABLE
42: ) as
43: ddindx binary_integer; indx binary_integer;

Line 41: , a2 out nocopy JTF_NUMBER_TABLE

37: end if;
38: end rosetta_table_copy_in_p2;
39: procedure rosetta_table_copy_out_p2(t csp_part_search_pvt.required_parts_tbl, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_VARCHAR2_TABLE_100
41: , a2 out nocopy JTF_NUMBER_TABLE
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then

Line 46: a0 := JTF_NUMBER_TABLE();

42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then
46: a0 := JTF_NUMBER_TABLE();
47: a1 := JTF_VARCHAR2_TABLE_100();
48: a2 := JTF_NUMBER_TABLE();
49: else
50: a0 := JTF_NUMBER_TABLE();

Line 48: a2 := JTF_NUMBER_TABLE();

44: begin
45: if t is null or t.count = 0 then
46: a0 := JTF_NUMBER_TABLE();
47: a1 := JTF_VARCHAR2_TABLE_100();
48: a2 := JTF_NUMBER_TABLE();
49: else
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();
52: a2 := JTF_NUMBER_TABLE();

Line 50: a0 := JTF_NUMBER_TABLE();

46: a0 := JTF_NUMBER_TABLE();
47: a1 := JTF_VARCHAR2_TABLE_100();
48: a2 := JTF_NUMBER_TABLE();
49: else
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();
52: a2 := JTF_NUMBER_TABLE();
53: if t.count > 0 then
54: a0.extend(t.count);

Line 52: a2 := JTF_NUMBER_TABLE();

48: a2 := JTF_NUMBER_TABLE();
49: else
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();
52: a2 := JTF_NUMBER_TABLE();
53: if t.count > 0 then
54: a0.extend(t.count);
55: a1.extend(t.count);
56: a2.extend(t.count);

Line 73: procedure search(p0_a0 JTF_NUMBER_TABLE

69: end if;
70: end if;
71: end rosetta_table_copy_out_p2;
72:
73: procedure search(p0_a0 JTF_NUMBER_TABLE
74: , p0_a1 JTF_VARCHAR2_TABLE_100
75: , p0_a2 JTF_NUMBER_TABLE
76: , p1_a0 VARCHAR2
77: , p1_a1 NUMBER

Line 75: , p0_a2 JTF_NUMBER_TABLE

71: end rosetta_table_copy_out_p2;
72:
73: procedure search(p0_a0 JTF_NUMBER_TABLE
74: , p0_a1 JTF_VARCHAR2_TABLE_100
75: , p0_a2 JTF_NUMBER_TABLE
76: , p1_a0 VARCHAR2
77: , p1_a1 NUMBER
78: , p1_a2 NUMBER
79: , p1_a3 NUMBER