[Home] [Help]
PACKAGE: APPS.CSP_EXCESS_LISTS_PKG_W
Source
1 package csp_excess_lists_pkg_w AUTHID CURRENT_USER as
2 /* $Header: csptexcws.pls 120.1 2011/04/09 18:12:35 htank noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy csp_excess_lists_pkg.excess_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_VARCHAR2_TABLE_200
20 , a17 JTF_VARCHAR2_TABLE_200
21 , a18 JTF_VARCHAR2_TABLE_200
22 , a19 JTF_VARCHAR2_TABLE_200
23 , a20 JTF_VARCHAR2_TABLE_200
24 , a21 JTF_VARCHAR2_TABLE_200
25 , a22 JTF_VARCHAR2_TABLE_200
26 , a23 JTF_VARCHAR2_TABLE_200
27 , a24 JTF_VARCHAR2_TABLE_200
28 , a25 JTF_VARCHAR2_TABLE_200
29 , a26 JTF_VARCHAR2_TABLE_200
30 , a27 JTF_VARCHAR2_TABLE_200
31 , a28 JTF_VARCHAR2_TABLE_200
32 , a29 JTF_VARCHAR2_TABLE_200
33 , a30 JTF_VARCHAR2_TABLE_200
34 , a31 JTF_NUMBER_TABLE
35 , a32 JTF_VARCHAR2_TABLE_300
36 , a33 JTF_NUMBER_TABLE
37 , a34 JTF_VARCHAR2_TABLE_100
38 );
39 procedure rosetta_table_copy_out_p2(t csp_excess_lists_pkg.excess_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40 , a1 out nocopy JTF_NUMBER_TABLE
41 , a2 out nocopy JTF_NUMBER_TABLE
42 , a3 out nocopy JTF_NUMBER_TABLE
43 , a4 out nocopy JTF_VARCHAR2_TABLE_100
44 , a5 out nocopy JTF_NUMBER_TABLE
45 , a6 out nocopy JTF_DATE_TABLE
46 , a7 out nocopy JTF_NUMBER_TABLE
47 , a8 out nocopy JTF_DATE_TABLE
48 , a9 out nocopy JTF_NUMBER_TABLE
49 , a10 out nocopy JTF_VARCHAR2_TABLE_100
50 , a11 out nocopy JTF_NUMBER_TABLE
51 , a12 out nocopy JTF_NUMBER_TABLE
52 , a13 out nocopy JTF_NUMBER_TABLE
53 , a14 out nocopy JTF_VARCHAR2_TABLE_100
54 , a15 out nocopy JTF_VARCHAR2_TABLE_100
55 , a16 out nocopy JTF_VARCHAR2_TABLE_200
56 , a17 out nocopy JTF_VARCHAR2_TABLE_200
57 , a18 out nocopy JTF_VARCHAR2_TABLE_200
58 , a19 out nocopy JTF_VARCHAR2_TABLE_200
59 , a20 out nocopy JTF_VARCHAR2_TABLE_200
60 , a21 out nocopy JTF_VARCHAR2_TABLE_200
61 , a22 out nocopy JTF_VARCHAR2_TABLE_200
62 , a23 out nocopy JTF_VARCHAR2_TABLE_200
63 , a24 out nocopy JTF_VARCHAR2_TABLE_200
64 , a25 out nocopy JTF_VARCHAR2_TABLE_200
65 , a26 out nocopy JTF_VARCHAR2_TABLE_200
66 , a27 out nocopy JTF_VARCHAR2_TABLE_200
67 , a28 out nocopy JTF_VARCHAR2_TABLE_200
68 , a29 out nocopy JTF_VARCHAR2_TABLE_200
69 , a30 out nocopy JTF_VARCHAR2_TABLE_200
70 , a31 out nocopy JTF_NUMBER_TABLE
71 , a32 out nocopy JTF_VARCHAR2_TABLE_300
72 , a33 out nocopy JTF_NUMBER_TABLE
73 , a34 out nocopy JTF_VARCHAR2_TABLE_100
74 );
75
76 procedure insert_row(px_excess_line_id in out nocopy NUMBER
77 , p_created_by NUMBER
78 , p_creation_date date
79 , p_last_updated_by NUMBER
80 , p_last_update_date date
81 , p_last_update_login NUMBER
82 , p_organization_id NUMBER
83 , p_subinventory_code VARCHAR2
84 , p_condition_code VARCHAR2
85 , p_inventory_item_id NUMBER
86 , p_excess_quantity NUMBER
87 , p_requisition_line_id NUMBER
88 , p_returned_quantity NUMBER
89 , p_current_return_qty NUMBER
90 , p_excess_status VARCHAR2
91 , p_return_org_id NUMBER
92 , p_return_sub_inv VARCHAR2
93 , p_attribute_category VARCHAR2
94 , p_attribute1 VARCHAR2
95 , p_attribute2 VARCHAR2
96 , p_attribute3 VARCHAR2
97 , p_attribute4 VARCHAR2
98 , p_attribute5 VARCHAR2
99 , p_attribute6 VARCHAR2
100 , p_attribute7 VARCHAR2
101 , p_attribute8 VARCHAR2
102 , p_attribute9 VARCHAR2
103 , p_attribute10 VARCHAR2
104 , p_attribute11 VARCHAR2
105 , p_attribute12 VARCHAR2
106 , p_attribute13 VARCHAR2
107 , p_attribute14 VARCHAR2
108 , p_attribute15 VARCHAR2
109 );
110 procedure update_row(p_excess_line_id NUMBER
111 , p_created_by NUMBER
112 , p_creation_date date
113 , p_last_updated_by NUMBER
114 , p_last_update_date date
115 , p_last_update_login NUMBER
116 , p_organization_id NUMBER
117 , p_subinventory_code VARCHAR2
118 , p_condition_code VARCHAR2
119 , p_inventory_item_id NUMBER
120 , p_excess_quantity NUMBER
121 , p_requisition_line_id NUMBER
122 , p_returned_quantity NUMBER
123 , p_current_return_qty NUMBER
124 , p_attribute_category VARCHAR2
125 , p_attribute1 VARCHAR2
126 , p_attribute2 VARCHAR2
127 , p_attribute3 VARCHAR2
128 , p_attribute4 VARCHAR2
129 , p_attribute5 VARCHAR2
130 , p_attribute6 VARCHAR2
131 , p_attribute7 VARCHAR2
132 , p_attribute8 VARCHAR2
133 , p_attribute9 VARCHAR2
134 , p_attribute10 VARCHAR2
135 , p_attribute11 VARCHAR2
136 , p_attribute12 VARCHAR2
137 , p_attribute13 VARCHAR2
138 , p_attribute14 VARCHAR2
139 , p_attribute15 VARCHAR2
140 );
141 procedure lock_row(p_excess_line_id NUMBER
142 , p_created_by NUMBER
143 , p_creation_date date
144 , p_last_updated_by NUMBER
145 , p_last_update_date date
146 , p_last_update_login NUMBER
147 , p_organization_id NUMBER
148 , p_subinventory_code VARCHAR2
149 , p_condition_code VARCHAR2
150 , p_inventory_item_id NUMBER
151 , p_excess_quantity NUMBER
152 , p_requisition_line_id NUMBER
153 , p_returned_quantity NUMBER
154 , p_current_return_qty NUMBER
155 , p_attribute_category VARCHAR2
156 , p_attribute1 VARCHAR2
157 , p_attribute2 VARCHAR2
158 , p_attribute3 VARCHAR2
159 , p_attribute4 VARCHAR2
160 , p_attribute5 VARCHAR2
161 , p_attribute6 VARCHAR2
162 , p_attribute7 VARCHAR2
163 , p_attribute8 VARCHAR2
164 , p_attribute9 VARCHAR2
165 , p_attribute10 VARCHAR2
166 , p_attribute11 VARCHAR2
167 , p_attribute12 VARCHAR2
168 , p_attribute13 VARCHAR2
169 , p_attribute14 VARCHAR2
170 , p_attribute15 VARCHAR2
171 );
172 end csp_excess_lists_pkg_w;