DBA Data[Home] [Help]

APPS.CS_SR_DUP_CHK_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 17: , a1 JTF_VARCHAR2_TABLE_100

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: ) as
20: ddindx binary_integer; indx binary_integer;
21: begin

Line 18: , a2 JTF_VARCHAR2_TABLE_100

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

Line 40: , a1 out nocopy JTF_VARCHAR2_TABLE_100

36: end if;
37: end if;
38: end rosetta_table_copy_in_p1;
39: procedure rosetta_table_copy_out_p1(t cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_VARCHAR2_TABLE_100
41: , a2 out nocopy JTF_VARCHAR2_TABLE_100
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin

Line 41: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 47: a1 := JTF_VARCHAR2_TABLE_100();

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_VARCHAR2_TABLE_100();
49: else
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();

Line 48: a2 := JTF_VARCHAR2_TABLE_100();

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_VARCHAR2_TABLE_100();
49: else
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();
52: a2 := JTF_VARCHAR2_TABLE_100();

Line 51: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 52: a2 := JTF_VARCHAR2_TABLE_100();

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

Line 200: , p12_a1 JTF_VARCHAR2_TABLE_100

196: , p_inv_item_serial_number VARCHAR2
197: , p_customer_id NUMBER
198: , p_inventory_item_id NUMBER
199: , p12_a0 JTF_NUMBER_TABLE
200: , p12_a1 JTF_VARCHAR2_TABLE_100
201: , p12_a2 JTF_VARCHAR2_TABLE_100
202: , p13_a0 VARCHAR2
203: , p13_a1 VARCHAR2
204: , p13_a2 VARCHAR2

Line 201: , p12_a2 JTF_VARCHAR2_TABLE_100

197: , p_customer_id NUMBER
198: , p_inventory_item_id NUMBER
199: , p12_a0 JTF_NUMBER_TABLE
200: , p12_a1 JTF_VARCHAR2_TABLE_100
201: , p12_a2 JTF_VARCHAR2_TABLE_100
202: , p13_a0 VARCHAR2
203: , p13_a1 VARCHAR2
204: , p13_a2 VARCHAR2
205: , p13_a3 VARCHAR2

Line 307: , p2_a1 JTF_VARCHAR2_TABLE_100

303:
304: procedure check_ea_duplicate_setup(p_incident_id NUMBER
305: , p_incident_type_id NUMBER
306: , p2_a0 JTF_NUMBER_TABLE
307: , p2_a1 JTF_VARCHAR2_TABLE_100
308: , p2_a2 JTF_VARCHAR2_TABLE_100
309: , p3_a0 VARCHAR2
310: , p3_a1 VARCHAR2
311: , p3_a2 VARCHAR2

Line 308: , p2_a2 JTF_VARCHAR2_TABLE_100

304: procedure check_ea_duplicate_setup(p_incident_id NUMBER
305: , p_incident_type_id NUMBER
306: , p2_a0 JTF_NUMBER_TABLE
307: , p2_a1 JTF_VARCHAR2_TABLE_100
308: , p2_a2 JTF_VARCHAR2_TABLE_100
309: , p3_a0 VARCHAR2
310: , p3_a1 VARCHAR2
311: , p3_a2 VARCHAR2
312: , p3_a3 VARCHAR2

Line 380: , p2_a1 JTF_VARCHAR2_TABLE_100

376:
377: procedure perform_ea_duplicate(p_incident_id NUMBER
378: , p_incident_type_id NUMBER
379: , p2_a0 JTF_NUMBER_TABLE
380: , p2_a1 JTF_VARCHAR2_TABLE_100
381: , p2_a2 JTF_VARCHAR2_TABLE_100
382: , p3_a0 VARCHAR2
383: , p3_a1 VARCHAR2
384: , p3_a2 VARCHAR2

Line 381: , p2_a2 JTF_VARCHAR2_TABLE_100

377: procedure perform_ea_duplicate(p_incident_id NUMBER
378: , p_incident_type_id NUMBER
379: , p2_a0 JTF_NUMBER_TABLE
380: , p2_a1 JTF_VARCHAR2_TABLE_100
381: , p2_a2 JTF_VARCHAR2_TABLE_100
382: , p3_a0 VARCHAR2
383: , p3_a1 VARCHAR2
384: , p3_a2 VARCHAR2
385: , p3_a3 VARCHAR2