[Home] [Help]
306: INTO v_line_no
307: FROM po_line_locations_all
308: WHERE line_location_id = v_po_line_location_id;
309:
310: /* If it is a standard PO, we'll retain the line number from apps as long as
311: there is only one shipment per line.We'll generate a number if there is
312: more than one shipment per line */
313:
314: ELSE /* STANDARD */
310: /* If it is a standard PO, we'll retain the line number from apps as long as
311: there is only one shipment per line.We'll generate a number if there is
312: more than one shipment per line */
313:
314: ELSE /* STANDARD */
315: SELECT count(*)
316: INTO v_line_count
317: FROM po_lines_all
318: WHERE po_header_id = v_po_header_id;
1258: | perform GL mapping |
1259: | 06/NOV/98 Tony Ricci removed call to GML_PO_SYNCH. |
1260: | cpg_conv_duom and replaced with |
1261: | GMICUOM.icuomcv which is the OPM |
1262: | standard uom conversion |
1263: | 11/10/98 Tony Ricci set trans_cnt on insert to '0' |
1264: | as per OPM 11.0 |
1265: | 11/10/98 Tony Ricci added frtbill_mthd_cur so OPM |
1266: | value will be used |
1391: source_shipment_id,
1392: line_no
1393: FROM cpg_purchasing_interface
1394: WHERE invalid_ind ='N'
1395: AND (transaction_type IN ('STANDARD','BLANKET') /* Bug 2031029 - Do not select TEMPLATE PPOs */
1396: OR
1397: (transaction_type = 'PLANNED' AND nvl(po_release_id,0) <> 0 AND nvl(release_num,0) <> 0)
1398: )
1399: ORDER BY transaction_id;
1841: retcode :=1;
1842:
1843: ELSE /* all fields are validate*/
1844:
1845: /*IF int_rec.transaction_type = 'STANDARD' THEN
1846: v_doc_type := 'PORD';
1847: ELSE
1848: v_doc_type := 'PBPO';
1849: END IF;*/
1925: v_po_no := CONCAT (CONCAT(int_rec.po_no, '-'),
1926: TO_CHAR(int_rec.release_num)
1927: );
1928:
1929: ELSE /* Standard PO's */
1930: v_bpo_id :=NULL; /* T.Ricci 7/6/98 integ constraint change*/
1931: v_bpo_line_id :=NULL; /* T.Ricci 7/7/98 integ constraint change*/
1932: v_po_no := int_rec.po_no;
1933: END IF;
3283: /* retcode :=1;
3284: raise_application_error(-20001, err_msg);*/
3285: END; /*update ic_tran_pnd*/
3286:
3287: /* For Standard/PPO release/Blanket release*/
3288:
3289: IF ic_summ_inv_view_exists = 0 THEN /* Bug 3019986 Mohit Kapoor */
3290: /*Bug 1365777 - If item is a non-inventory item then do not update or insert
3291: into ic_summ_inv table - PPB */
3575: END IF;
3576:
3577: IF error_ind = 0 THEN /* B2594000 */
3578: BEGIN
3579: UPDATE po_ordr_dtl /* For standard, blanket and PPOs */
3580: SET acct_map_ind = v_acct_map_ind,
3581: last_update_date = nvl(v_last_update_date, SYSDATE),/* lswamy - BUG 1829102 */
3582: last_updated_by = nvl(v_last_updated_by, 0), /* lswamy - BUG 1829102 */
3583: last_update_login = int_rec.last_update_login /* LE 26/AUG/98 NULL OK*/