APPS.PO_RESCHEDULE_PKG dependencies on DUAL

Line 68: FROM DUAL;

64: /* Bug 5610714,
65: l_shipment_nums,
66: l_estimated_pickup_dates,
67: l_ship_methods */
68: FROM DUAL;
69:
70: IF X_shipment_num IS NOT NULL THEN
71: -- 5610714 Initialize the Collection with the parameter value
72: l_shipment_nums := po_tbl_number(X_shipment_num);

Line 165: from dual;

161: -- debug
162:
163: select instr(x_supply_number, '(')
164: into x_pare_left
165: from dual;
166:
167: if x_pare_left <= 0 then
168: X_po_type := 'PO';
169: ELSE

Line 181: from dual;

177: if X_po_type <> 'PO' then
178: -- Get the index of ')' in the supply number
179: select instr(x_supply_number, ')')
180: into x_pare_right
181: from dual;
182:
183: if x_pare_right <=0 then
184: -- No ending parentheis.
185: add_error_to_msg_list (

Line 195: from dual;

191:
192: select to_number(substr(x_supply_number, x_pare_left+1,
193: x_pare_right - x_pare_left-1))
194: into x_release_num
195: from dual;
196:
197:
198: l_progress:= '020';
199: -- debug