APPS.PO_AME_WF_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 3211: FROM po_line_locations_all

3207: FROM po_lines_all
3208: WHERE po_header_id = l_po_header_id
3209: AND from_line_id IS NOT NULL ) AND ad.entity_name = 'PO_LINES') OR
3210: (ad.pk1_value IN (SELECT To_Char(line_location_id)
3211: FROM po_line_locations_all
3212: WHERE po_header_id = l_po_header_id
3213: AND shipment_type IN ('PRICE BREAK', 'STANDARD', 'PREPAYMENT')) AND ad.entity_name = 'PO_SHIPMENTS') OR
3214: (ad.pk2_value IN (SELECT To_Char(item_id)
3215: FROM po_lines_all

Line 3382: FROM po_line_locations_all

3378: WHERE po_header_id = l_document_id
3379: AND from_line_id IS NOT NULL) AND ad.entity_name = 'PO_LINES') OR
3380: --
3381: (ad.pk1_value IN (SELECT line_location_id
3382: FROM po_line_locations_all
3383: WHERE po_header_id = l_document_id
3384: AND shipment_type IN ('PRICE BREAK', 'STANDARD', 'PREPAYMENT'))
3385: AND ad.entity_name = 'PO_SHIPMENTS') OR
3386: --

Line 5946: -- + Update po_line_locations_all for approved flag

5942:
5943: BEGIN
5944: -- Logic :
5945: -- + Update po_headers_all status to APPROVED and corresponding fields.
5946: -- + Update po_line_locations_all for approved flag
5947:
5948: IF (g_po_wf_debug = 'Y') THEN
5949: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key, l_log_head || ' 001');
5950: END IF;

Line 5979: UPDATE po_line_locations_all poll

5975: IF (g_po_wf_debug = 'Y') THEN
5976: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key, l_log_head || ' 003 : After updating po_headers_all ');
5977: END IF;
5978:
5979: UPDATE po_line_locations_all poll
5980: SET poll.approved_flag = 'Y'
5981: ,poll.approved_date = sysdate
5982: ,poll.last_update_date = sysdate
5983: ,poll.last_updated_by = l_user_id

Line 5990: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key, l_log_head || ' After updating po_line_locations_all' );

5986: AND poll.po_release_id IS NULL
5987: AND nvl (poll.approved_flag,'N') <> 'Y';
5988:
5989: IF (g_po_wf_debug = 'Y') THEN
5990: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key, l_log_head || ' After updating po_line_locations_all' );
5991: END IF;
5992:
5993: COMMIT;
5994: