DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 3157: -- 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.

3153:
3154: l_progress := '027';
3155: x_return_status := FND_API.G_RET_STS_SUCCESS;
3156:
3157: -- 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.
3158: IF p_document_type in ('PO','RELEASE') THEN
3159:
3160: FOR ship_rec in (select line_location_id from po_line_locations_gt)
3161:

Line 18230: FROM PO_DISTRIBUTIONS_ALL POD

18226: FROM PO_DISTRIBUTIONS_MERGE_V POD
18227: WHERE POD.po_distribution_id = l_dist_id_tbl(i)
18228: and pod.draft_id = p_draft_id
18229: /* -- CLM Aprvl
18230: FROM PO_DISTRIBUTIONS_ALL POD
18231: WHERE POD.po_distribution_id = l_dist_id_tbl(i)
18232: */-- CLM Aprvl
18233: -- need to change the entities which should be validated. Only records in the draft tables should be validated.
18234: AND (l_draft_type <> 'PAR'

Line 21835: UPDATE po_distributions_all

21831: UPDATE po_line_locations_all
21832: SET lcm_flag = 'Y'
21833: WHERE line_location_id = p_line_location_id;
21834:
21835: UPDATE po_distributions_all
21836: SET lcm_flag = 'Y'
21837: WHERE line_location_id = p_line_location_id;
21838: END IF;
21839:

Line 21847: UPDATE po_distributions_all

21843: SET lcm_flag = null
21844: WHERE line_location_id = p_line_location_id
21845: AND lcm_flag = 'Y';
21846:
21847: UPDATE po_distributions_all
21848: SET lcm_flag = null
21849: WHERE line_location_id = p_line_location_id
21850: AND lcm_flag = 'Y';
21851: