APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 412: from po_line_locations_all pll, po_line_locations_draft_all pld

408: pll.quantity_received,
409: pll.quantity_billed,
410: pll.amount_received,
411: pll.amount_billed*/
412: from po_line_locations_all pll, po_line_locations_draft_all pld
413: where pld.line_location_id = pll.line_location_id
414: and pld.draft_id = p_draft_id
415: and (pld.quantity_received <> pll.quantity_received or
416: pld.quantity_billed <> pll.quantity_billed or

Line 2048: FROM po_line_locations_all pla

2044: l_draft_amount_tbl,
2045: l_draft_old_amount_tbl,
2046: l_line_location_tbl,
2047: l_change_status_tbl
2048: FROM po_line_locations_all pla
2049: ,po_line_locations_draft_all plda
2050: WHERE pla.line_location_id = plda.line_location_id
2051: AND plda.draft_id = p_draft_id
2052: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)

Line 2082: po_line_locations_all pla

2078: BULK COLLECT INTO l_po_line_loc_s_no_lck_tbl
2079: ,l_draft_id_tbl
2080: ,l_delete_flag_tbl
2081: FROM po_line_locations_draft_all plda,
2082: po_line_locations_all pla
2083: WHERE plda.draft_id = p_draft_id
2084: AND pla.line_location_id = plda.line_location_id
2085: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
2086: AND NOT EXISTS (SELECT 'P/F locks'

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

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;