[Home] [Help]
PACKAGE: APPS.CS_SR_DUP_CHK_PVT_W
Source
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
9 , a2 out nocopy 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
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 );
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
27 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
28 );
29
30 procedure duplicate_check(p_api_version NUMBER
31 , p_init_msg_list VARCHAR2
32 , p_commit VARCHAR2
33 , p_validation_level NUMBER
34 , p_incident_id NUMBER
35 , p_incident_type_id NUMBER
36 , p_customer_product_id NUMBER
37 , p_instance_serial_number VARCHAR2
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
47 , p13_a2 VARCHAR2
48 , p13_a3 VARCHAR2
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
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
67 , p3_a2 VARCHAR2
68 , p3_a3 VARCHAR2
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
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
86 , p3_a2 VARCHAR2
87 , p3_a3 VARCHAR2
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
97 );
98 procedure perform_dup_on_sr_field(p_customer_product_id NUMBER
99 , p_customer_id NUMBER
100 , p_inventory_item_id NUMBER
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
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
119 );
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
129 , p_return_status out nocopy VARCHAR2
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
139 , p_return_status out nocopy VARCHAR2
140 );
141 procedure check_sr_custprodserial_dup(p_customer_id NUMBER
142 , p_inventory_item_id NUMBER
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
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
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
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
178 , p_sr_link_id NUMBER
179 ) return varchar2;
180 end cs_sr_dup_chk_pvt_w;