[Home] [Help]
3956: END IF;
3957:
3958: -- Update lines in ext_tl table
3959: FORALL i in 1..p_po_line_s_no_lck_tbl.COUNT
3960: UPDATE po_lines_all_ext_tl pltd
3961: SET ( pltd.tl_ext_attr1 ,
3962: pltd.tl_ext_attr2 ,
3963: pltd.tl_ext_attr3 ,
3964: pltd.tl_ext_attr4 ,
4038: pltb.tl_ext_attr37 ,
4039: pltb.tl_ext_attr38 ,
4040: pltb.tl_ext_attr39 ,
4041: pltb.tl_ext_attr40
4042: FROM po_lines_all_ext_tl pltb --base
4043: WHERE pltb.po_line_id = pltd.po_line_id
4044: AND pltb.draft_id = -1
4045: AND pltb.attr_group_id = pltd.attr_group_id
4046: AND pltb.language = pltd.language
4052:
4053:
4054: d_position := 90;
4055: IF (PO_LOG.d_stmt) THEN
4056: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_tl ');
4057: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4058: END IF;
4059: d_position := 100;
4060: IF (PO_LOG.d_proc) THEN