DBA Data[Home] [Help]

APPS.MRP_RESCHEDULE_PO dependencies on STANDARD

Line 123: order number(shipment number) -- standard PO */

119: /* in R12, order number(release number)(line number)(shipment number),
120: but release number could be empty,
121: in 11.5.10 and prior,
122: order number(release number)(shipment number) -- blanket PO or
123: order number(shipment number) -- standard PO */
124:
125: first_left_pare_pos := instr(v_po_number(i), '(');
126: second_left_pare_pos := instr(v_po_number(i), '(',1,2);
127: third_left_pare_pos := instr(v_po_number(i), '(',1,3);

Line 145: l_doc_subtype := 'STANDARD';

141: end;
142:
143: if v_release_num is null then
144: l_doc_type := 'PO';
145: l_doc_subtype := 'STANDARD';
146: v_po_number(i) := substr(v_po_number(i), 1,first_left_pare_pos -1);
147: else
148: l_doc_type := 'RELEASE';
149: l_doc_subtype := 'BLANKET';

Line 160: if second_left_pare_pos = 0 then -- standard po

156: -- and will be passed to 'Cancel PO' api.
157: -- -------------------------------------------------
158: if first_left_pare_pos > 0 then -- should not be 0, just in case
159: first_right_pare_pos := instr(v_po_number(i), ')');
160: if second_left_pare_pos = 0 then -- standard po
161: v_po_location_id := substr(v_po_number(i),
162: first_left_pare_pos+1,first_right_pare_pos -
163: first_left_pare_pos -1);
164: v_po_number(i) := substr(v_po_number(i), 1,first_left_pare_pos -1);

Line 166: l_doc_subtype := 'STANDARD';

162: first_left_pare_pos+1,first_right_pare_pos -
163: first_left_pare_pos -1);
164: v_po_number(i) := substr(v_po_number(i), 1,first_left_pare_pos -1);
165: l_doc_type := 'PO';
166: l_doc_subtype := 'STANDARD';
167: else -- blanket po
168: second_right_pare_pos := instr(v_po_number(i), ')', 1,2);
169: v_po_location_id := substr(v_po_number(i),
170: second_left_pare_pos+1,second_right_pare_pos -

Line 185: --5137694, for standard po, group by po_header_id,

181: mrp_cancel_po.cancel_po_program(v_po_header_id(i), v_po_line_id(i),
182: v_po_number(i), v_po_location_id,
183: l_doc_type , l_doc_subtype);
184: else
185: --5137694, for standard po, group by po_header_id,
186: -- for blanket po, group by po_header_id and shipment number
187:
188: if i <> nvl(v_po_line_id.FIRST, 0) and
189: v_po_number(i) <> v_po_number(i-1) then