DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 1371: -- LCM ER start. If all the submission checks have been passed successfully then update the lcm_flag of po_line_locations_all and po_distributions_all.

1367:
1368: l_progress := '027';
1369: x_return_status := FND_API.G_RET_STS_SUCCESS;
1370:
1371: -- LCM ER start. If all the submission checks have been passed successfully then update the lcm_flag of po_line_locations_all and po_distributions_all.
1372: IF p_document_type in ('PO','RELEASE') THEN
1373:
1374: FOR ship_rec in (select line_location_id from po_line_locations_gt)
1375:

Line 14630: FROM PO_DISTRIBUTIONS_ALL POD

14626: oke_contract_line_id ,
14627: oke_contract_deliverable_id
14628: , distribution_type
14629: , amount_to_encumber
14630: FROM PO_DISTRIBUTIONS_ALL POD
14631: WHERE POD.po_distribution_id = l_dist_id_tbl(i)
14632: ;
14633:
14634: l_progress := '060';

Line 17839: UPDATE po_distributions_all

17835: UPDATE po_line_locations_all
17836: SET lcm_flag = 'Y'
17837: WHERE line_location_id = p_line_location_id;
17838:
17839: UPDATE po_distributions_all
17840: SET lcm_flag = 'Y'
17841: WHERE line_location_id = p_line_location_id;
17842: END IF;
17843:

Line 17851: UPDATE po_distributions_all

17847: SET lcm_flag = null
17848: WHERE line_location_id = p_line_location_id
17849: AND lcm_flag = 'Y';
17850:
17851: UPDATE po_distributions_all
17852: SET lcm_flag = null
17853: WHERE line_location_id = p_line_location_id
17854: AND lcm_flag = 'Y';
17855: