eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CS_SR_DUP_CHK_PVT_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 74: , a1 JTF_VARCHAR2_TABLE_2000

70: end if;
71: end rosetta_table_copy_out_p1;
72:
73: procedure rosetta_table_copy_in_p3(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_2000
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin
78: if a0 is not null and a0.count > 0 then

Line 95: , a1 out nocopy JTF_VARCHAR2_TABLE_2000

91: end if;
92: end if;
93: end rosetta_table_copy_in_p3;
94: procedure rosetta_table_copy_out_p3(t cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
96: ) as
97: ddindx binary_integer; indx binary_integer;
98: begin
99: if t is null or t.count = 0 then

Line 101: a1 := JTF_VARCHAR2_TABLE_2000();

97: ddindx binary_integer; indx binary_integer;
98: begin
99: if t is null or t.count = 0 then
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_VARCHAR2_TABLE_2000();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: a1 := JTF_VARCHAR2_TABLE_2000();
105: if t.count > 0 then

Line 104: a1 := JTF_VARCHAR2_TABLE_2000();

100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_VARCHAR2_TABLE_2000();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: a1 := JTF_VARCHAR2_TABLE_2000();
105: if t.count > 0 then
106: a0.extend(t.count);
107: a1.extend(t.count);
108: ddindx := t.first;

Line 126: , a3 JTF_VARCHAR2_TABLE_2000

122:
123: procedure rosetta_table_copy_in_p5(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 JTF_NUMBER_TABLE
124: , a1 JTF_NUMBER_TABLE
125: , a2 JTF_NUMBER_TABLE
126: , a3 JTF_VARCHAR2_TABLE_2000
127: ) as
128: ddindx binary_integer; indx binary_integer;
129: begin
130: if a0 is not null and a0.count > 0 then

Line 151: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

147: end rosetta_table_copy_in_p5;
148: procedure rosetta_table_copy_out_p5(t cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 out nocopy JTF_NUMBER_TABLE
149: , a1 out nocopy JTF_NUMBER_TABLE
150: , a2 out nocopy JTF_NUMBER_TABLE
151: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
152: ) as
153: ddindx binary_integer; indx binary_integer;
154: begin
155: if t is null or t.count = 0 then

Line 159: a3 := JTF_VARCHAR2_TABLE_2000();

155: if t is null or t.count = 0 then
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_NUMBER_TABLE();
158: a2 := JTF_NUMBER_TABLE();
159: a3 := JTF_VARCHAR2_TABLE_2000();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_NUMBER_TABLE();

Line 164: a3 := JTF_VARCHAR2_TABLE_2000();

160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_NUMBER_TABLE();
164: a3 := JTF_VARCHAR2_TABLE_2000();
165: if t.count > 0 then
166: a0.extend(t.count);
167: a1.extend(t.count);
168: a2.extend(t.count);

Line 211: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_2000

207: , p13_a5 VARCHAR2
208: , p13_a6 VARCHAR2
209: , x_duplicate_flag out nocopy VARCHAR2
210: , p15_a0 out nocopy JTF_NUMBER_TABLE
211: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_2000
212: , x_dup_found_at out nocopy VARCHAR2
213: , x_return_status out nocopy VARCHAR2
214: , x_msg_count out nocopy NUMBER
215: , x_msg_data out nocopy VARCHAR2

Line 318: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_2000

314: , p3_a5 VARCHAR2
315: , p3_a6 VARCHAR2
316: , p_ea_attr_dup_flag in out nocopy VARCHAR2
317: , p5_a0 out nocopy JTF_NUMBER_TABLE
318: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_2000
319: , p_ea_ia_dup out nocopy VARCHAR2
320: , p_ea_ea_dup out nocopy VARCHAR2
321: , p_return_status out nocopy VARCHAR2
322: )

Line 391: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_2000

387: , p3_a5 VARCHAR2
388: , p3_a6 VARCHAR2
389: , p_ea_attr_dup_flag in out nocopy VARCHAR2
390: , p5_a0 out nocopy JTF_NUMBER_TABLE
391: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_2000
392: , p_ea_ia_dup out nocopy VARCHAR2
393: , p_ea_ea_dup out nocopy VARCHAR2
394: , p_return_status out nocopy VARCHAR2
395: )

Line 458: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_2000

454: , p_current_serial_number VARCHAR2
455: , p_inv_item_serial_number VARCHAR2
456: , p_incident_id NUMBER
457: , p7_a0 in out nocopy JTF_NUMBER_TABLE
458: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
459: , p_cs_sr_dup_flag in out nocopy VARCHAR2
460: , p_dup_from in out nocopy NUMBER
461: , p_return_status out nocopy VARCHAR2
462: )

Line 518: , p2_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

514: , p_incident_id NUMBER
515: , p2_a0 in out nocopy JTF_NUMBER_TABLE
516: , p2_a1 in out nocopy JTF_NUMBER_TABLE
517: , p2_a2 in out nocopy JTF_NUMBER_TABLE
518: , p2_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
519: , p_cs_sr_dup_flag in out nocopy VARCHAR2
520: , p_return_status out nocopy VARCHAR2
521: )
522:

Line 565: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

561: , p_incident_id NUMBER
562: , p4_a0 in out nocopy JTF_NUMBER_TABLE
563: , p4_a1 in out nocopy JTF_NUMBER_TABLE
564: , p4_a2 in out nocopy JTF_NUMBER_TABLE
565: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
566: , p_cs_sr_dup_flag in out nocopy VARCHAR2
567: , p_return_status out nocopy VARCHAR2
568: )
569:

Line 617: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

613: , p_incident_id NUMBER
614: , p3_a0 in out nocopy JTF_NUMBER_TABLE
615: , p3_a1 in out nocopy JTF_NUMBER_TABLE
616: , p3_a2 in out nocopy JTF_NUMBER_TABLE
617: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
618: , p_cs_sr_dup_flag in out nocopy VARCHAR2
619: , p_return_status out nocopy VARCHAR2
620: )
621:

Line 669: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

665: , p_incident_id NUMBER
666: , p6_a0 in out nocopy JTF_NUMBER_TABLE
667: , p6_a1 in out nocopy JTF_NUMBER_TABLE
668: , p6_a2 in out nocopy JTF_NUMBER_TABLE
669: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
670: , p_cs_sr_dup_flag in out nocopy VARCHAR2
671: , p_return_status out nocopy VARCHAR2
672: )
673:

Line 722: , p0_a1 JTF_VARCHAR2_TABLE_2000

718:
719: end;
720:
721: procedure construct_unique_list_dup_sr(p0_a0 JTF_NUMBER_TABLE
722: , p0_a1 JTF_VARCHAR2_TABLE_2000
723: , p_ea_attr_dup_flag VARCHAR2
724: , p2_a0 JTF_NUMBER_TABLE
725: , p2_a1 JTF_VARCHAR2_TABLE_2000
726: , p_cs_sr_dup_flag VARCHAR2

Line 725: , p2_a1 JTF_VARCHAR2_TABLE_2000

721: procedure construct_unique_list_dup_sr(p0_a0 JTF_NUMBER_TABLE
722: , p0_a1 JTF_VARCHAR2_TABLE_2000
723: , p_ea_attr_dup_flag VARCHAR2
724: , p2_a0 JTF_NUMBER_TABLE
725: , p2_a1 JTF_VARCHAR2_TABLE_2000
726: , p_cs_sr_dup_flag VARCHAR2
727: , p_dup_from NUMBER
728: , p_ea_ea_dup VARCHAR2
729: , p_ea_ia_dup VARCHAR2

Line 731: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_2000

727: , p_dup_from NUMBER
728: , p_ea_ea_dup VARCHAR2
729: , p_ea_ia_dup VARCHAR2
730: , p7_a0 in out nocopy JTF_NUMBER_TABLE
731: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
732: , p_duplicate_flag in out nocopy VARCHAR2
733: , p_return_status out nocopy VARCHAR2
734: )
735:

Line 793: , p0_a3 JTF_VARCHAR2_TABLE_2000

789:
790: procedure check_dup_sr_link(p0_a0 JTF_NUMBER_TABLE
791: , p0_a1 JTF_NUMBER_TABLE
792: , p0_a2 JTF_NUMBER_TABLE
793: , p0_a3 JTF_VARCHAR2_TABLE_2000
794: , p1_a0 in out nocopy JTF_NUMBER_TABLE
795: , p1_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
796: , p_return_status out nocopy VARCHAR2
797: )

Line 795: , p1_a1 in out nocopy JTF_VARCHAR2_TABLE_2000

791: , p0_a1 JTF_NUMBER_TABLE
792: , p0_a2 JTF_NUMBER_TABLE
793: , p0_a3 JTF_VARCHAR2_TABLE_2000
794: , p1_a0 in out nocopy JTF_NUMBER_TABLE
795: , p1_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
796: , p_return_status out nocopy VARCHAR2
797: )
798:
799: as

Line 831: , p0_a1 JTF_VARCHAR2_TABLE_2000

827:
828: end;
829:
830: function check_if_already_in_list(p0_a0 JTF_NUMBER_TABLE
831: , p0_a1 JTF_VARCHAR2_TABLE_2000
832: , p_sr_link_id NUMBER
833: ) return varchar2
834:
835: as