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.

APPS.GMI_PURGE_EMPTY_BAL_PKG dependencies on DBMS_SQL

Line 135: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

131: ' WHERE a.item_id = '|| l_where_clause || l_where1
132: ||' and a.lot_id = c.lot_id and b.item_id = c.item_id ';
133: --END BUG#2552369
134:
135: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
136:
137: DBMS_SQL.PARSE(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
138:
139: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fitm',l_from_item);

Line 137: DBMS_SQL.PARSE(l_cursor_id,l_select_stmt,DBMS_SQL.V7);

133: --END BUG#2552369
134:
135: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
136:
137: DBMS_SQL.PARSE(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
138:
139: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fitm',l_from_item);
140: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':titm',l_to_item);
141: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fwh',l_from_whse);

Line 139: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fitm',l_from_item);

135: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
136:
137: DBMS_SQL.PARSE(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
138:
139: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fitm',l_from_item);
140: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':titm',l_to_item);
141: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fwh',l_from_whse);
142: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':twh',l_to_whse);
143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inclass',l_inv_class);

Line 140: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':titm',l_to_item);

136:
137: DBMS_SQL.PARSE(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
138:
139: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fitm',l_from_item);
140: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':titm',l_to_item);
141: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fwh',l_from_whse);
142: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':twh',l_to_whse);
143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inclass',l_inv_class);
144: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':lotind',l_lot_ind);

Line 141: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fwh',l_from_whse);

137: DBMS_SQL.PARSE(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
138:
139: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fitm',l_from_item);
140: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':titm',l_to_item);
141: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fwh',l_from_whse);
142: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':twh',l_to_whse);
143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inclass',l_inv_class);
144: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':lotind',l_lot_ind);
145: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':purge_precision',l_purge_precision); /* Dinesh 3377672 - Purge Empty Balances Enh. */

Line 142: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':twh',l_to_whse);

138:
139: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fitm',l_from_item);
140: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':titm',l_to_item);
141: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fwh',l_from_whse);
142: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':twh',l_to_whse);
143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inclass',l_inv_class);
144: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':lotind',l_lot_ind);
145: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':purge_precision',l_purge_precision); /* Dinesh 3377672 - Purge Empty Balances Enh. */
146:

Line 143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inclass',l_inv_class);

139: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fitm',l_from_item);
140: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':titm',l_to_item);
141: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fwh',l_from_whse);
142: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':twh',l_to_whse);
143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inclass',l_inv_class);
144: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':lotind',l_lot_ind);
145: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':purge_precision',l_purge_precision); /* Dinesh 3377672 - Purge Empty Balances Enh. */
146:
147: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_item_no,32);

Line 144: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':lotind',l_lot_ind);

140: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':titm',l_to_item);
141: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fwh',l_from_whse);
142: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':twh',l_to_whse);
143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inclass',l_inv_class);
144: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':lotind',l_lot_ind);
145: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':purge_precision',l_purge_precision); /* Dinesh 3377672 - Purge Empty Balances Enh. */
146:
147: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_item_no,32);
148: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,2,l_whse_code,4);

Line 145: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':purge_precision',l_purge_precision); /* Dinesh 3377672 - Purge Empty Balances Enh. */

141: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':fwh',l_from_whse);
142: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':twh',l_to_whse);
143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inclass',l_inv_class);
144: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':lotind',l_lot_ind);
145: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':purge_precision',l_purge_precision); /* Dinesh 3377672 - Purge Empty Balances Enh. */
146:
147: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_item_no,32);
148: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,2,l_whse_code,4);
149: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,3,l_location,32);

Line 147: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_item_no,32);

143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inclass',l_inv_class);
144: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':lotind',l_lot_ind);
145: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':purge_precision',l_purge_precision); /* Dinesh 3377672 - Purge Empty Balances Enh. */
146:
147: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_item_no,32);
148: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,2,l_whse_code,4);
149: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,3,l_location,32);
150: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,4,l_loct_onhand);
151: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,5,l_row_id,100);

Line 148: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,2,l_whse_code,4);

144: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':lotind',l_lot_ind);
145: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':purge_precision',l_purge_precision); /* Dinesh 3377672 - Purge Empty Balances Enh. */
146:
147: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_item_no,32);
148: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,2,l_whse_code,4);
149: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,3,l_location,32);
150: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,4,l_loct_onhand);
151: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,5,l_row_id,100);
152: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,6,l_loct_onhand2);

Line 149: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,3,l_location,32);

145: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':purge_precision',l_purge_precision); /* Dinesh 3377672 - Purge Empty Balances Enh. */
146:
147: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_item_no,32);
148: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,2,l_whse_code,4);
149: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,3,l_location,32);
150: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,4,l_loct_onhand);
151: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,5,l_row_id,100);
152: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,6,l_loct_onhand2);
153: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,7,l_qchold_res_code,10);

Line 150: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,4,l_loct_onhand);

146:
147: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_item_no,32);
148: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,2,l_whse_code,4);
149: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,3,l_location,32);
150: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,4,l_loct_onhand);
151: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,5,l_row_id,100);
152: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,6,l_loct_onhand2);
153: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,7,l_qchold_res_code,10);
154: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,8,l_lot_status,10);

Line 151: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,5,l_row_id,100);

147: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_item_no,32);
148: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,2,l_whse_code,4);
149: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,3,l_location,32);
150: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,4,l_loct_onhand);
151: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,5,l_row_id,100);
152: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,6,l_loct_onhand2);
153: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,7,l_qchold_res_code,10);
154: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,8,l_lot_status,10);
155: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,9,l_lot_no,32);

Line 152: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,6,l_loct_onhand2);

148: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,2,l_whse_code,4);
149: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,3,l_location,32);
150: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,4,l_loct_onhand);
151: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,5,l_row_id,100);
152: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,6,l_loct_onhand2);
153: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,7,l_qchold_res_code,10);
154: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,8,l_lot_status,10);
155: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,9,l_lot_no,32);
156:

Line 153: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,7,l_qchold_res_code,10);

149: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,3,l_location,32);
150: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,4,l_loct_onhand);
151: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,5,l_row_id,100);
152: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,6,l_loct_onhand2);
153: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,7,l_qchold_res_code,10);
154: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,8,l_lot_status,10);
155: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,9,l_lot_no,32);
156:
157:

Line 154: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,8,l_lot_status,10);

150: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,4,l_loct_onhand);
151: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,5,l_row_id,100);
152: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,6,l_loct_onhand2);
153: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,7,l_qchold_res_code,10);
154: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,8,l_lot_status,10);
155: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,9,l_lot_no,32);
156:
157:
158: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

Line 155: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,9,l_lot_no,32);

151: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,5,l_row_id,100);
152: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,6,l_loct_onhand2);
153: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,7,l_qchold_res_code,10);
154: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,8,l_lot_status,10);
155: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,9,l_lot_no,32);
156:
157:
158: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
159:

Line 158: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

154: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,8,l_lot_status,10);
155: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,9,l_lot_no,32);
156:
157:
158: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
159:
160:
161: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) <> 0) LOOP
162: BEGIN

Line 161: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) <> 0) LOOP

157:
158: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
159:
160:
161: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) <> 0) LOOP
162: BEGIN
163: DBMS_SQL.COLUMN_VALUE(l_cursor_id,1,l_item_no);
164: DBMS_SQL.COLUMN_VALUE(l_cursor_id,2,l_whse_code);
165: DBMS_SQL.COLUMN_VALUE(l_cursor_id,3,l_location);

Line 163: DBMS_SQL.COLUMN_VALUE(l_cursor_id,1,l_item_no);

159:
160:
161: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) <> 0) LOOP
162: BEGIN
163: DBMS_SQL.COLUMN_VALUE(l_cursor_id,1,l_item_no);
164: DBMS_SQL.COLUMN_VALUE(l_cursor_id,2,l_whse_code);
165: DBMS_SQL.COLUMN_VALUE(l_cursor_id,3,l_location);
166: DBMS_SQL.COLUMN_VALUE(l_cursor_id,4,l_loct_onhand);
167: DBMS_SQL.COLUMN_VALUE(l_cursor_id,5,l_row_id);

Line 164: DBMS_SQL.COLUMN_VALUE(l_cursor_id,2,l_whse_code);

160:
161: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) <> 0) LOOP
162: BEGIN
163: DBMS_SQL.COLUMN_VALUE(l_cursor_id,1,l_item_no);
164: DBMS_SQL.COLUMN_VALUE(l_cursor_id,2,l_whse_code);
165: DBMS_SQL.COLUMN_VALUE(l_cursor_id,3,l_location);
166: DBMS_SQL.COLUMN_VALUE(l_cursor_id,4,l_loct_onhand);
167: DBMS_SQL.COLUMN_VALUE(l_cursor_id,5,l_row_id);
168: DBMS_SQL.COLUMN_VALUE(l_cursor_id,6,l_loct_onhand2);

Line 165: DBMS_SQL.COLUMN_VALUE(l_cursor_id,3,l_location);

161: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) <> 0) LOOP
162: BEGIN
163: DBMS_SQL.COLUMN_VALUE(l_cursor_id,1,l_item_no);
164: DBMS_SQL.COLUMN_VALUE(l_cursor_id,2,l_whse_code);
165: DBMS_SQL.COLUMN_VALUE(l_cursor_id,3,l_location);
166: DBMS_SQL.COLUMN_VALUE(l_cursor_id,4,l_loct_onhand);
167: DBMS_SQL.COLUMN_VALUE(l_cursor_id,5,l_row_id);
168: DBMS_SQL.COLUMN_VALUE(l_cursor_id,6,l_loct_onhand2);
169: DBMS_SQL.COLUMN_VALUE(l_cursor_id,7,l_qchold_res_code);

Line 166: DBMS_SQL.COLUMN_VALUE(l_cursor_id,4,l_loct_onhand);

162: BEGIN
163: DBMS_SQL.COLUMN_VALUE(l_cursor_id,1,l_item_no);
164: DBMS_SQL.COLUMN_VALUE(l_cursor_id,2,l_whse_code);
165: DBMS_SQL.COLUMN_VALUE(l_cursor_id,3,l_location);
166: DBMS_SQL.COLUMN_VALUE(l_cursor_id,4,l_loct_onhand);
167: DBMS_SQL.COLUMN_VALUE(l_cursor_id,5,l_row_id);
168: DBMS_SQL.COLUMN_VALUE(l_cursor_id,6,l_loct_onhand2);
169: DBMS_SQL.COLUMN_VALUE(l_cursor_id,7,l_qchold_res_code);
170: DBMS_SQL.COLUMN_VALUE(l_cursor_id,8,l_lot_status);

Line 167: DBMS_SQL.COLUMN_VALUE(l_cursor_id,5,l_row_id);

163: DBMS_SQL.COLUMN_VALUE(l_cursor_id,1,l_item_no);
164: DBMS_SQL.COLUMN_VALUE(l_cursor_id,2,l_whse_code);
165: DBMS_SQL.COLUMN_VALUE(l_cursor_id,3,l_location);
166: DBMS_SQL.COLUMN_VALUE(l_cursor_id,4,l_loct_onhand);
167: DBMS_SQL.COLUMN_VALUE(l_cursor_id,5,l_row_id);
168: DBMS_SQL.COLUMN_VALUE(l_cursor_id,6,l_loct_onhand2);
169: DBMS_SQL.COLUMN_VALUE(l_cursor_id,7,l_qchold_res_code);
170: DBMS_SQL.COLUMN_VALUE(l_cursor_id,8,l_lot_status);
171: DBMS_SQL.COLUMN_VALUE(l_cursor_id,9,l_lot_no);

Line 168: DBMS_SQL.COLUMN_VALUE(l_cursor_id,6,l_loct_onhand2);

164: DBMS_SQL.COLUMN_VALUE(l_cursor_id,2,l_whse_code);
165: DBMS_SQL.COLUMN_VALUE(l_cursor_id,3,l_location);
166: DBMS_SQL.COLUMN_VALUE(l_cursor_id,4,l_loct_onhand);
167: DBMS_SQL.COLUMN_VALUE(l_cursor_id,5,l_row_id);
168: DBMS_SQL.COLUMN_VALUE(l_cursor_id,6,l_loct_onhand2);
169: DBMS_SQL.COLUMN_VALUE(l_cursor_id,7,l_qchold_res_code);
170: DBMS_SQL.COLUMN_VALUE(l_cursor_id,8,l_lot_status);
171: DBMS_SQL.COLUMN_VALUE(l_cursor_id,9,l_lot_no);
172:

Line 169: DBMS_SQL.COLUMN_VALUE(l_cursor_id,7,l_qchold_res_code);

165: DBMS_SQL.COLUMN_VALUE(l_cursor_id,3,l_location);
166: DBMS_SQL.COLUMN_VALUE(l_cursor_id,4,l_loct_onhand);
167: DBMS_SQL.COLUMN_VALUE(l_cursor_id,5,l_row_id);
168: DBMS_SQL.COLUMN_VALUE(l_cursor_id,6,l_loct_onhand2);
169: DBMS_SQL.COLUMN_VALUE(l_cursor_id,7,l_qchold_res_code);
170: DBMS_SQL.COLUMN_VALUE(l_cursor_id,8,l_lot_status);
171: DBMS_SQL.COLUMN_VALUE(l_cursor_id,9,l_lot_no);
172:
173: --BEGIN BUG#2552369 V. Ajay Kumar

Line 170: DBMS_SQL.COLUMN_VALUE(l_cursor_id,8,l_lot_status);

166: DBMS_SQL.COLUMN_VALUE(l_cursor_id,4,l_loct_onhand);
167: DBMS_SQL.COLUMN_VALUE(l_cursor_id,5,l_row_id);
168: DBMS_SQL.COLUMN_VALUE(l_cursor_id,6,l_loct_onhand2);
169: DBMS_SQL.COLUMN_VALUE(l_cursor_id,7,l_qchold_res_code);
170: DBMS_SQL.COLUMN_VALUE(l_cursor_id,8,l_lot_status);
171: DBMS_SQL.COLUMN_VALUE(l_cursor_id,9,l_lot_no);
172:
173: --BEGIN BUG#2552369 V. Ajay Kumar
174: --Commented the additional WHERE clause from the DELETE statement.

Line 171: DBMS_SQL.COLUMN_VALUE(l_cursor_id,9,l_lot_no);

167: DBMS_SQL.COLUMN_VALUE(l_cursor_id,5,l_row_id);
168: DBMS_SQL.COLUMN_VALUE(l_cursor_id,6,l_loct_onhand2);
169: DBMS_SQL.COLUMN_VALUE(l_cursor_id,7,l_qchold_res_code);
170: DBMS_SQL.COLUMN_VALUE(l_cursor_id,8,l_lot_status);
171: DBMS_SQL.COLUMN_VALUE(l_cursor_id,9,l_lot_no);
172:
173: --BEGIN BUG#2552369 V. Ajay Kumar
174: --Commented the additional WHERE clause from the DELETE statement.
175:

Line 202: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

198: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
199: END IF;
200: END;
201: END LOOP;
202: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
203:
204: /******** 3377672 Purge Empty Balances Enhancement - Start *********/
205: /* Added IF Condition -- Update the ic_purg_prm only if it is called from Purge Empty Balances Form*/
206: