APPS.CS_SR_DUP_CHK_PVT_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 13: , a1 JTF_VARCHAR2_TABLE_2000

9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 JTF_NUMBER_TABLE
13: , a1 JTF_VARCHAR2_TABLE_2000
14: );
15: procedure rosetta_table_copy_out_p3(t cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
17: );

Line 16: , a1 out nocopy JTF_VARCHAR2_TABLE_2000

12: procedure rosetta_table_copy_in_p3(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 JTF_NUMBER_TABLE
13: , a1 JTF_VARCHAR2_TABLE_2000
14: );
15: procedure rosetta_table_copy_out_p3(t cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
17: );
18:
19: procedure rosetta_table_copy_in_p5(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 JTF_NUMBER_TABLE
20: , a1 JTF_NUMBER_TABLE

Line 22: , a3 JTF_VARCHAR2_TABLE_2000

18:
19: procedure rosetta_table_copy_in_p5(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 JTF_NUMBER_TABLE
20: , a1 JTF_NUMBER_TABLE
21: , a2 JTF_NUMBER_TABLE
22: , a3 JTF_VARCHAR2_TABLE_2000
23: );
24: procedure rosetta_table_copy_out_p5(t cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE

Line 27: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

23: );
24: procedure rosetta_table_copy_out_p5(t cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
28: );
29:
30: procedure duplicate_check(p_api_version NUMBER
31: , p_init_msg_list VARCHAR2

Line 54: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_2000

50: , p13_a5 VARCHAR2
51: , p13_a6 VARCHAR2
52: , x_duplicate_flag out nocopy VARCHAR2
53: , p15_a0 out nocopy JTF_NUMBER_TABLE
54: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_2000
55: , x_dup_found_at out nocopy VARCHAR2
56: , x_return_status out nocopy VARCHAR2
57: , x_msg_count out nocopy NUMBER
58: , x_msg_data out nocopy VARCHAR2

Line 74: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_2000

70: , p3_a5 VARCHAR2
71: , p3_a6 VARCHAR2
72: , p_ea_attr_dup_flag in out nocopy VARCHAR2
73: , p5_a0 out nocopy JTF_NUMBER_TABLE
74: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_2000
75: , p_ea_ia_dup out nocopy VARCHAR2
76: , p_ea_ea_dup out nocopy VARCHAR2
77: , p_return_status out nocopy VARCHAR2
78: );

Line 93: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_2000

89: , p3_a5 VARCHAR2
90: , p3_a6 VARCHAR2
91: , p_ea_attr_dup_flag in out nocopy VARCHAR2
92: , p5_a0 out nocopy JTF_NUMBER_TABLE
93: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_2000
94: , p_ea_ia_dup out nocopy VARCHAR2
95: , p_ea_ea_dup out nocopy VARCHAR2
96: , p_return_status out nocopy VARCHAR2
97: );

Line 106: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_2000

102: , p_current_serial_number VARCHAR2
103: , p_inv_item_serial_number VARCHAR2
104: , p_incident_id NUMBER
105: , p7_a0 in out nocopy JTF_NUMBER_TABLE
106: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
107: , p_cs_sr_dup_flag in out nocopy VARCHAR2
108: , p_dup_from in out nocopy NUMBER
109: , p_return_status out nocopy VARCHAR2
110: );

Line 116: , p2_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

112: , p_incident_id NUMBER
113: , p2_a0 in out nocopy JTF_NUMBER_TABLE
114: , p2_a1 in out nocopy JTF_NUMBER_TABLE
115: , p2_a2 in out nocopy JTF_NUMBER_TABLE
116: , p2_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
117: , p_cs_sr_dup_flag in out nocopy VARCHAR2
118: , p_return_status out nocopy VARCHAR2
119: );
120: procedure check_sr_serialnum_dup(p_instance_serial_number VARCHAR2

Line 127: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

123: , p_incident_id NUMBER
124: , p4_a0 in out nocopy JTF_NUMBER_TABLE
125: , p4_a1 in out nocopy JTF_NUMBER_TABLE
126: , p4_a2 in out nocopy JTF_NUMBER_TABLE
127: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
128: , p_cs_sr_dup_flag in out nocopy VARCHAR2
129: , p_return_status out nocopy VARCHAR2
130: );
131: procedure check_sr_custprod_dup(p_customer_id NUMBER

Line 137: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

133: , p_incident_id NUMBER
134: , p3_a0 in out nocopy JTF_NUMBER_TABLE
135: , p3_a1 in out nocopy JTF_NUMBER_TABLE
136: , p3_a2 in out nocopy JTF_NUMBER_TABLE
137: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
138: , p_cs_sr_dup_flag in out nocopy VARCHAR2
139: , p_return_status out nocopy VARCHAR2
140: );
141: procedure check_sr_custprodserial_dup(p_customer_id NUMBER

Line 150: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

146: , p_incident_id NUMBER
147: , p6_a0 in out nocopy JTF_NUMBER_TABLE
148: , p6_a1 in out nocopy JTF_NUMBER_TABLE
149: , p6_a2 in out nocopy JTF_NUMBER_TABLE
150: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
151: , p_cs_sr_dup_flag in out nocopy VARCHAR2
152: , p_return_status out nocopy VARCHAR2
153: );
154: procedure construct_unique_list_dup_sr(p0_a0 JTF_NUMBER_TABLE

Line 155: , p0_a1 JTF_VARCHAR2_TABLE_2000

151: , p_cs_sr_dup_flag in out nocopy VARCHAR2
152: , p_return_status out nocopy VARCHAR2
153: );
154: procedure construct_unique_list_dup_sr(p0_a0 JTF_NUMBER_TABLE
155: , p0_a1 JTF_VARCHAR2_TABLE_2000
156: , p_ea_attr_dup_flag VARCHAR2
157: , p2_a0 JTF_NUMBER_TABLE
158: , p2_a1 JTF_VARCHAR2_TABLE_2000
159: , p_cs_sr_dup_flag VARCHAR2

Line 158: , p2_a1 JTF_VARCHAR2_TABLE_2000

154: procedure construct_unique_list_dup_sr(p0_a0 JTF_NUMBER_TABLE
155: , p0_a1 JTF_VARCHAR2_TABLE_2000
156: , p_ea_attr_dup_flag VARCHAR2
157: , p2_a0 JTF_NUMBER_TABLE
158: , p2_a1 JTF_VARCHAR2_TABLE_2000
159: , p_cs_sr_dup_flag VARCHAR2
160: , p_dup_from NUMBER
161: , p_ea_ea_dup VARCHAR2
162: , p_ea_ia_dup VARCHAR2

Line 164: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_2000

160: , p_dup_from NUMBER
161: , p_ea_ea_dup VARCHAR2
162: , p_ea_ia_dup VARCHAR2
163: , p7_a0 in out nocopy JTF_NUMBER_TABLE
164: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
165: , p_duplicate_flag in out nocopy VARCHAR2
166: , p_return_status out nocopy VARCHAR2
167: );
168: procedure check_dup_sr_link(p0_a0 JTF_NUMBER_TABLE

Line 171: , p0_a3 JTF_VARCHAR2_TABLE_2000

167: );
168: procedure check_dup_sr_link(p0_a0 JTF_NUMBER_TABLE
169: , p0_a1 JTF_NUMBER_TABLE
170: , p0_a2 JTF_NUMBER_TABLE
171: , p0_a3 JTF_VARCHAR2_TABLE_2000
172: , p1_a0 in out nocopy JTF_NUMBER_TABLE
173: , p1_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
174: , p_return_status out nocopy VARCHAR2
175: );

Line 173: , p1_a1 in out nocopy JTF_VARCHAR2_TABLE_2000

169: , p0_a1 JTF_NUMBER_TABLE
170: , p0_a2 JTF_NUMBER_TABLE
171: , p0_a3 JTF_VARCHAR2_TABLE_2000
172: , p1_a0 in out nocopy JTF_NUMBER_TABLE
173: , p1_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
174: , p_return_status out nocopy VARCHAR2
175: );
176: function check_if_already_in_list(p0_a0 JTF_NUMBER_TABLE
177: , p0_a1 JTF_VARCHAR2_TABLE_2000

Line 177: , p0_a1 JTF_VARCHAR2_TABLE_2000

173: , p1_a1 in out nocopy JTF_VARCHAR2_TABLE_2000
174: , p_return_status out nocopy VARCHAR2
175: );
176: function check_if_already_in_list(p0_a0 JTF_NUMBER_TABLE
177: , p0_a1 JTF_VARCHAR2_TABLE_2000
178: , p_sr_link_id NUMBER
179: ) return varchar2;
180: end cs_sr_dup_chk_pvt_w;