DBA Data[Home] [Help]

APPS.MRP_RESCHEDULE_PO dependencies on STANDARD

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

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

Line 150: l_doc_subtype := 'STANDARD';

146: end;
147:
148: if v_release_num is null then
149: l_doc_type := 'PO';
150: l_doc_subtype := 'STANDARD';
151: v_po_number(i) := substr(v_po_number(i), 1,first_left_pare_pos -1);
152: else
153: l_doc_type := 'RELEASE';
154: l_doc_subtype := 'BLANKET';

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

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

Line 171: l_doc_subtype := 'STANDARD';

167: first_left_pare_pos+1,first_right_pare_pos -
168: first_left_pare_pos -1);
169: v_po_number(i) := substr(v_po_number(i), 1,first_left_pare_pos -1);
170: l_doc_type := 'PO';
171: l_doc_subtype := 'STANDARD';
172: else -- blanket po
173: second_right_pare_pos := instr(v_po_number(i), ')', 1,2);
174: v_po_location_id := substr(v_po_number(i),
175: second_left_pare_pos+1,second_right_pare_pos -

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

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