APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_LINE_LOCATIONS_ALL_EXT_B

Line 4120: UPDATE po_line_locations_all_ext_b plld

4116: PO_LOG.stmt(d_module,d_position ,'line_loc_id for S and No locks excluding Price break', p_po_line_loc_s_no_lck_tbl);
4117: END IF;
4118:
4119: FORALL i in 1..p_po_line_loc_s_no_lck_tbl.COUNT
4120: UPDATE po_line_locations_all_ext_b plld
4121: SET ( plld.c_ext_attr1,
4122: plld.c_ext_attr2 ,
4123: plld.c_ext_attr3 ,
4124: plld.c_ext_attr4 ,

Line 4302: FROM po_line_locations_all_ext_b pllb --base

4298: pllb.d_ext_attr7 ,
4299: pllb.d_ext_attr8 ,
4300: pllb.d_ext_attr9 ,
4301: pllb.d_ext_attr10
4302: FROM po_line_locations_all_ext_b pllb --base
4303: WHERE pllb.line_location_id = plld.line_location_id
4304: AND pllb.draft_id = -1
4305: AND pllb.attr_group_id = plld.attr_group_id
4306: )

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

4308: AND plld.draft_id = p_draft_id;
4309:
4310: d_position := 50;
4311: IF (PO_LOG.d_stmt) THEN
4312: PO_LOG.stmt(d_module,d_position ,'Updated po_line_locations_all_ext_b for the given p_drat_id');
4313: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4314: END IF;
4315:
4316: --update for tl tables