DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PUB_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy cs_servicerequest_pub.notes_table, a0 JTF_VARCHAR2_TABLE_2000

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_p1(t out nocopy cs_servicerequest_pub.notes_table, a0 JTF_VARCHAR2_TABLE_2000
17: , a1 JTF_VARCHAR2_TABLE_32767
18: , a2 JTF_VARCHAR2_TABLE_300
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 51: procedure rosetta_table_copy_out_p1(t cs_servicerequest_pub.notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000

47: end loop;
48: end if;
49: end if;
50: end rosetta_table_copy_in_p1;
51: procedure rosetta_table_copy_out_p1(t cs_servicerequest_pub.notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
52: , a1 out nocopy JTF_VARCHAR2_TABLE_32767
53: , a2 out nocopy JTF_VARCHAR2_TABLE_300
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_NUMBER_TABLE

Line 64: a0 := JTF_VARCHAR2_TABLE_2000();

60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_VARCHAR2_TABLE_2000();
65: a1 := JTF_VARCHAR2_TABLE_32767();
66: a2 := JTF_VARCHAR2_TABLE_300();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_NUMBER_TABLE();

Line 74: a0 := JTF_VARCHAR2_TABLE_2000();

70: a6 := JTF_NUMBER_TABLE();
71: a7 := JTF_VARCHAR2_TABLE_100();
72: a8 := JTF_NUMBER_TABLE();
73: else
74: a0 := JTF_VARCHAR2_TABLE_2000();
75: a1 := JTF_VARCHAR2_TABLE_32767();
76: a2 := JTF_VARCHAR2_TABLE_300();
77: a3 := JTF_VARCHAR2_TABLE_100();
78: a4 := JTF_NUMBER_TABLE();

Line 536: procedure rosetta_table_copy_in_p17(t out nocopy cs_servicerequest_pub.sr_notes_table, a0 JTF_VARCHAR2_TABLE_2000

532: end if;
533: end if;
534: end rosetta_table_copy_out_p13;
535:
536: procedure rosetta_table_copy_in_p17(t out nocopy cs_servicerequest_pub.sr_notes_table, a0 JTF_VARCHAR2_TABLE_2000
537: , a1 JTF_VARCHAR2_TABLE_100
538: , a2 JTF_CLOB_TABLE
539: , a3 JTF_NUMBER_TABLE
540: ) as

Line 561: procedure rosetta_table_copy_out_p17(t cs_servicerequest_pub.sr_notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000

557: end loop;
558: end if;
559: end if;
560: end rosetta_table_copy_in_p17;
561: procedure rosetta_table_copy_out_p17(t cs_servicerequest_pub.sr_notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
562: , a1 out nocopy JTF_VARCHAR2_TABLE_100
563: , a2 out nocopy JTF_CLOB_TABLE
564: , a3 out nocopy JTF_NUMBER_TABLE
565: ) as

Line 569: a0 := JTF_VARCHAR2_TABLE_2000();

565: ) as
566: ddindx binary_integer; indx binary_integer;
567: begin
568: if t is null or t.count = 0 then
569: a0 := JTF_VARCHAR2_TABLE_2000();
570: a1 := JTF_VARCHAR2_TABLE_100();
571: a2 := JTF_CLOB_TABLE();
572: a3 := JTF_NUMBER_TABLE();
573: else

Line 574: a0 := JTF_VARCHAR2_TABLE_2000();

570: a1 := JTF_VARCHAR2_TABLE_100();
571: a2 := JTF_CLOB_TABLE();
572: a3 := JTF_NUMBER_TABLE();
573: else
574: a0 := JTF_VARCHAR2_TABLE_2000();
575: a1 := JTF_VARCHAR2_TABLE_100();
576: a2 := JTF_CLOB_TABLE();
577: a3 := JTF_NUMBER_TABLE();
578: if t.count > 0 then

Line 2058: , p14_a0 JTF_VARCHAR2_TABLE_2000

2054: , p13_a222 DATE
2055: , p13_a223 NUMBER
2056: , p13_a224 NUMBER
2057: , p13_a225 NUMBER
2058: , p14_a0 JTF_VARCHAR2_TABLE_2000
2059: , p14_a1 JTF_VARCHAR2_TABLE_32767
2060: , p14_a2 JTF_VARCHAR2_TABLE_300
2061: , p14_a3 JTF_VARCHAR2_TABLE_100
2062: , p14_a4 JTF_NUMBER_TABLE

Line 2685: , p14_a0 JTF_VARCHAR2_TABLE_2000

2681: , p13_a222 DATE
2682: , p13_a223 NUMBER
2683: , p13_a224 NUMBER
2684: , p13_a225 NUMBER
2685: , p14_a0 JTF_VARCHAR2_TABLE_2000
2686: , p14_a1 JTF_VARCHAR2_TABLE_32767
2687: , p14_a2 JTF_VARCHAR2_TABLE_300
2688: , p14_a3 JTF_VARCHAR2_TABLE_100
2689: , p14_a4 JTF_NUMBER_TABLE

Line 3288: , p16_a0 JTF_VARCHAR2_TABLE_2000

3284: , p15_a222 DATE
3285: , p15_a223 NUMBER
3286: , p15_a224 NUMBER
3287: , p15_a225 NUMBER
3288: , p16_a0 JTF_VARCHAR2_TABLE_2000
3289: , p16_a1 JTF_VARCHAR2_TABLE_32767
3290: , p16_a2 JTF_VARCHAR2_TABLE_300
3291: , p16_a3 JTF_VARCHAR2_TABLE_100
3292: , p16_a4 JTF_NUMBER_TABLE

Line 3915: , p16_a0 JTF_VARCHAR2_TABLE_2000

3911: , p15_a222 DATE
3912: , p15_a223 NUMBER
3913: , p15_a224 NUMBER
3914: , p15_a225 NUMBER
3915: , p16_a0 JTF_VARCHAR2_TABLE_2000
3916: , p16_a1 JTF_VARCHAR2_TABLE_32767
3917: , p16_a2 JTF_VARCHAR2_TABLE_300
3918: , p16_a3 JTF_VARCHAR2_TABLE_100
3919: , p16_a4 JTF_NUMBER_TABLE

Line 4621: , p14_a0 JTF_VARCHAR2_TABLE_2000

4617: , p13_a222 DATE
4618: , p13_a223 NUMBER
4619: , p13_a224 NUMBER
4620: , p13_a225 NUMBER
4621: , p14_a0 JTF_VARCHAR2_TABLE_2000
4622: , p14_a1 JTF_VARCHAR2_TABLE_32767
4623: , p14_a2 JTF_VARCHAR2_TABLE_300
4624: , p14_a3 JTF_VARCHAR2_TABLE_100
4625: , p14_a4 JTF_NUMBER_TABLE

Line 5260: , p5_a0 in out nocopy JTF_VARCHAR2_TABLE_2000

5256: , p4_a66 in out nocopy JTF_VARCHAR2_TABLE_200
5257: , p4_a67 in out nocopy JTF_VARCHAR2_TABLE_200
5258: , p4_a68 in out nocopy JTF_VARCHAR2_TABLE_200
5259: , p4_a69 in out nocopy JTF_VARCHAR2_TABLE_200
5260: , p5_a0 in out nocopy JTF_VARCHAR2_TABLE_2000
5261: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
5262: , p5_a2 in out nocopy JTF_CLOB_TABLE
5263: , p5_a3 in out nocopy JTF_NUMBER_TABLE
5264: , x_return_status out nocopy VARCHAR2