APPS.PO_RELGEN_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 237: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */

233: -- Update Release with status INCOMPLETE
234: -- as the tax calculation has failed
235: --
236:
237: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */
238:
239: UPDATE po_releases_all por
240: SET por.authorization_status = 'INCOMPLETE',
241: por.approved_flag = 'N'

Line 244: UPDATE po_line_locations_all plla

240: SET por.authorization_status = 'INCOMPLETE',
241: por.approved_flag = 'N'
242: WHERE por.po_release_id = x_po_release_id;
243:
244: UPDATE po_line_locations_all plla
245: SET plla.approved_flag = 'N'
246: WHERE plla.po_release_id = x_po_release_id;
247:
248: /* Bug 7609663: end */

Line 360: UPDATE po_line_locations_all plla

356: por.approved_flag = 'N',
357: por.approved_date = NULL
358: WHERE por.po_release_id = x_po_release_id;
359:
360: UPDATE po_line_locations_all plla
361: SET plla.approved_flag = 'N',
362: plla.approved_date = NULL,
363: plla.lcm_flag = NULL
364: WHERE plla.po_release_id = x_po_release_id

Line 510: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */

506: -- ECO Bug 4643026
507: -- Update Release with status INCOMPLETE
508: -- as the tax calculation has failed
509: --
510: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */
511:
512: UPDATE po_releases_all por
513: SET por.authorization_status = 'INCOMPLETE',
514: por.approved_flag = 'N'

Line 517: UPDATE po_line_locations_all plla

513: SET por.authorization_status = 'INCOMPLETE',
514: por.approved_flag = 'N'
515: WHERE por.po_release_id = x_po_release_id;
516:
517: UPDATE po_line_locations_all plla
518: SET plla.approved_flag = 'N'
519: WHERE plla.po_release_id = x_po_release_id;
520:
521: /* Bug 7609663: end */

Line 617: UPDATE po_line_locations_all plla

613: por.approved_flag = 'N',
614: por.approved_date = NULL
615: WHERE por.po_release_id = x_po_release_id;
616:
617: UPDATE po_line_locations_all plla
618: SET plla.approved_flag = 'N',
619: plla.approved_date = NULL,
620: plla.lcm_flag = NULL
621: WHERE plla.po_release_id = x_po_release_id

Line 870: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;

866: l_promised_date DATE := NULL;
867: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
868: --
869:
870: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
871: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
872: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
873: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
874:

Line 3264: PO_LINE_LOCATIONS_ALL PLL

3260:
3261: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||l_textline,1,240)
3262: BULK COLLECT INTO l_error_messages
3263: FROM PO_RELEASES_ALL POR,
3264: PO_LINE_LOCATIONS_ALL PLL
3265: WHERE POR.po_release_id = PLL.po_release_id
3266: AND POR.po_release_id = x_po_release_id
3267: AND Nvl(PLL.LCM_FLAG,'N') = 'Y'
3268: AND Nvl(PLL.match_option,'P') <> 'R';