APPS.PO_RELGEN_PKG dependencies on PO_LINE_LOCATIONS_ALL

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

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

Line 245: UPDATE po_line_locations_all plla

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

Line 361: UPDATE po_line_locations_all plla

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

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

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

Line 518: UPDATE po_line_locations_all plla

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

Line 618: UPDATE po_line_locations_all plla

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

Line 876: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;

872: l_promised_date DATE := NULL;
873: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
874: --
875:
876: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
877: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
878: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
879: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
880:

Line 3318: PO_LINE_LOCATIONS_ALL PLL

3314:
3315: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||l_textline,1,240)
3316: BULK COLLECT INTO l_error_messages
3317: FROM PO_RELEASES_ALL POR,
3318: PO_LINE_LOCATIONS_ALL PLL
3319: WHERE POR.po_release_id = PLL.po_release_id
3320: AND POR.po_release_id = x_po_release_id
3321: AND Nvl(PLL.LCM_FLAG,'N') = 'Y'
3322: AND Nvl(PLL.match_option,'P') <> 'R';