APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_LINE_LOCATIONS_ALL_EXT_TL

Line 4318: UPDATE po_line_locations_all_ext_tl plltd

4314: END IF;
4315:
4316: --update for tl tables
4317: FORALL i in 1..p_po_line_loc_s_no_lck_tbl.COUNT
4318: UPDATE po_line_locations_all_ext_tl plltd
4319: SET ( plltd.tl_ext_attr1 ,
4320: plltd.tl_ext_attr2 ,
4321: plltd.tl_ext_attr3 ,
4322: plltd.tl_ext_attr4 ,

Line 4400: FROM po_line_locations_all_ext_tl plltb --base

4396: plltb.tl_ext_attr37 ,
4397: plltb.tl_ext_attr38 ,
4398: plltb.tl_ext_attr39 ,
4399: plltb.tl_ext_attr40
4400: FROM po_line_locations_all_ext_tl plltb --base
4401: WHERE plltb.line_location_id = plltd.line_location_id
4402: AND plltb.draft_id = -1
4403: AND plltb.attr_group_id = plltd.attr_group_id
4404: AND plltb.language = plltd.language

Line 4411: PO_LOG.stmt(d_module,d_position ,'Updated po_line_locations_all_ext_tl for the given p_drat_id');

4407: AND plltd.draft_id = p_draft_id;
4408:
4409: d_position := 70;
4410: IF (PO_LOG.d_stmt) THEN
4411: PO_LOG.stmt(d_module,d_position ,'Updated po_line_locations_all_ext_tl for the given p_drat_id');
4412: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4413: END IF;
4414:
4415: d_position := 100;