APPS.CS_SR_DUP_CHK_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 JTF_NUMBER_TABLE

1: package cs_sr_dup_chk_pvt_w AUTHID CURRENT_USER as
2: /* $Header: csdupws.pls 120.0 2011/12/16 11:45:50 shramana noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 7: procedure rosetta_table_copy_out_p1(t cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 out nocopy JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 out nocopy JTF_NUMBER_TABLE
8: , a1 out nocopy JTF_VARCHAR2_TABLE_100
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:

Line 12: procedure rosetta_table_copy_in_p3(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 JTF_NUMBER_TABLE

8: , a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 15: procedure rosetta_table_copy_out_p3(t cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 out nocopy JTF_NUMBER_TABLE

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: );
18:
19: procedure rosetta_table_copy_in_p5(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 JTF_NUMBER_TABLE

Line 19: procedure rosetta_table_copy_in_p5(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 JTF_NUMBER_TABLE

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
21: , a2 JTF_NUMBER_TABLE
22: , a3 JTF_VARCHAR2_TABLE_2000
23: );

Line 20: , a1 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
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

Line 21: , a2 JTF_NUMBER_TABLE

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
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

Line 24: procedure rosetta_table_copy_out_p5(t cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 out nocopy 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
27: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
28: );

Line 25: , a1 out nocopy 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
27: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
28: );
29:

Line 26: , a2 out nocopy 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
27: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
28: );
29:
30: procedure duplicate_check(p_api_version NUMBER

Line 42: , p12_a0 JTF_NUMBER_TABLE

38: , p_current_serial_number VARCHAR2
39: , p_inv_item_serial_number VARCHAR2
40: , p_customer_id NUMBER
41: , p_inventory_item_id NUMBER
42: , p12_a0 JTF_NUMBER_TABLE
43: , p12_a1 JTF_VARCHAR2_TABLE_100
44: , p12_a2 JTF_VARCHAR2_TABLE_100
45: , p13_a0 VARCHAR2
46: , p13_a1 VARCHAR2

Line 53: , p15_a0 out nocopy JTF_NUMBER_TABLE

49: , p13_a4 VARCHAR2
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

Line 62: , p2_a0 JTF_NUMBER_TABLE

58: , x_msg_data out nocopy VARCHAR2
59: );
60: procedure check_ea_duplicate_setup(p_incident_id NUMBER
61: , p_incident_type_id NUMBER
62: , p2_a0 JTF_NUMBER_TABLE
63: , p2_a1 JTF_VARCHAR2_TABLE_100
64: , p2_a2 JTF_VARCHAR2_TABLE_100
65: , p3_a0 VARCHAR2
66: , p3_a1 VARCHAR2

Line 73: , p5_a0 out nocopy JTF_NUMBER_TABLE

69: , p3_a4 VARCHAR2
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

Line 81: , p2_a0 JTF_NUMBER_TABLE

77: , p_return_status out nocopy VARCHAR2
78: );
79: procedure perform_ea_duplicate(p_incident_id NUMBER
80: , p_incident_type_id NUMBER
81: , p2_a0 JTF_NUMBER_TABLE
82: , p2_a1 JTF_VARCHAR2_TABLE_100
83: , p2_a2 JTF_VARCHAR2_TABLE_100
84: , p3_a0 VARCHAR2
85: , p3_a1 VARCHAR2

Line 92: , p5_a0 out nocopy JTF_NUMBER_TABLE

88: , p3_a4 VARCHAR2
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

Line 105: , p7_a0 in out nocopy JTF_NUMBER_TABLE

101: , p_instance_serial_number VARCHAR2
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

Line 113: , p2_a0 in out nocopy JTF_NUMBER_TABLE

109: , p_return_status out nocopy VARCHAR2
110: );
111: procedure check_sr_instance_dup(p_customer_product_id NUMBER
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

Line 114: , p2_a1 in out nocopy JTF_NUMBER_TABLE

110: );
111: procedure check_sr_instance_dup(p_customer_product_id NUMBER
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

Line 115: , p2_a2 in out nocopy JTF_NUMBER_TABLE

111: procedure check_sr_instance_dup(p_customer_product_id NUMBER
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: );

Line 124: , p4_a0 in out nocopy JTF_NUMBER_TABLE

120: procedure check_sr_serialnum_dup(p_instance_serial_number VARCHAR2
121: , p_current_serial_number VARCHAR2
122: , p_inv_item_serial_number VARCHAR2
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

Line 125: , p4_a1 in out nocopy JTF_NUMBER_TABLE

121: , p_current_serial_number VARCHAR2
122: , p_inv_item_serial_number VARCHAR2
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

Line 126: , p4_a2 in out nocopy JTF_NUMBER_TABLE

122: , p_inv_item_serial_number VARCHAR2
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: );

Line 134: , p3_a0 in out nocopy JTF_NUMBER_TABLE

130: );
131: procedure check_sr_custprod_dup(p_customer_id NUMBER
132: , p_inventory_item_id NUMBER
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

Line 135: , p3_a1 in out nocopy JTF_NUMBER_TABLE

131: procedure check_sr_custprod_dup(p_customer_id NUMBER
132: , p_inventory_item_id NUMBER
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

Line 136: , p3_a2 in out nocopy JTF_NUMBER_TABLE

132: , p_inventory_item_id NUMBER
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: );

Line 147: , p6_a0 in out nocopy JTF_NUMBER_TABLE

143: , p_instance_serial_number VARCHAR2
144: , p_current_serial_number VARCHAR2
145: , p_inv_item_serial_number VARCHAR2
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

Line 148: , p6_a1 in out nocopy JTF_NUMBER_TABLE

144: , p_current_serial_number VARCHAR2
145: , p_inv_item_serial_number VARCHAR2
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

Line 149: , p6_a2 in out nocopy JTF_NUMBER_TABLE

145: , p_inv_item_serial_number VARCHAR2
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: );

Line 154: procedure construct_unique_list_dup_sr(p0_a0 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
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

Line 157: , p2_a0 JTF_NUMBER_TABLE

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
160: , p_dup_from NUMBER
161: , p_ea_ea_dup VARCHAR2

Line 163: , p7_a0 in out nocopy JTF_NUMBER_TABLE

159: , p_cs_sr_dup_flag VARCHAR2
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: );

Line 168: procedure check_dup_sr_link(p0_a0 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
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

Line 169: , p0_a1 JTF_NUMBER_TABLE

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
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

Line 170: , p0_a2 JTF_NUMBER_TABLE

166: , p_return_status out nocopy VARCHAR2
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

Line 172: , p1_a0 in out nocopy JTF_NUMBER_TABLE

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: );
176: function check_if_already_in_list(p0_a0 JTF_NUMBER_TABLE

Line 176: function check_if_already_in_list(p0_a0 JTF_NUMBER_TABLE

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
178: , p_sr_link_id NUMBER
179: ) return varchar2;
180: end cs_sr_dup_chk_pvt_w;