APPS.M4R_7B5_OSFM_PKG dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 503: g_exception_tracking_msg := 'Query po_line_locations_archive_all into l_lines_loc_chk';

499: l_raise_flag := 'Y';
500: l_action_code := 'WON';
501: ELSE
502:
503: g_exception_tracking_msg := 'Query po_line_locations_archive_all into l_lines_loc_chk';
504:
505: BEGIN -- Checks if the Shipments got cancelled
506:
507: SELECT 'x'

Line 509: FROM po_line_locations_archive_all

505: BEGIN -- Checks if the Shipments got cancelled
506:
507: SELECT 'x'
508: INTO l_lines_loc_chk
509: FROM po_line_locations_archive_all
510: WHERE po_header_id = l_po_header_id
511: AND revision_num = l_po_rev_num_x
512: AND po_line_id = lines_rec.po_line_id
513: AND line_location_id = lines_rec.line_location_id

Line 552: FROM po_line_locations_archive_all

548: )
549: UNION
550: (
551: SELECT po_header_id
552: FROM po_line_locations_archive_all
553: WHERE po_header_id = l_po_header_id
554: AND revision_num = l_po_rev_num_x
555: AND po_line_id = lines_rec.po_line_id
556: AND line_location_id = lines_rec.line_location_id

Line 626: g_exception_tracking_msg := 'Query po_line_locations_archive_all for line_location_id,revision_num';

622: IF (g_debug_level <= 1) THEN
623: cln_debug_pub.Add('Line Revision Number : ' || l_line_rev_num, 1);
624: END IF;
625:
626: g_exception_tracking_msg := 'Query po_line_locations_archive_all for line_location_id,revision_num';
627:
628: -- gets the Line Location ID, Line Location Revision Number
629: SELECT line_location_id,revision_num
630: INTO l_line_loc_id,l_line_loc_rev_num

Line 631: FROM po_line_locations_archive_all

627:
628: -- gets the Line Location ID, Line Location Revision Number
629: SELECT line_location_id,revision_num
630: INTO l_line_loc_id,l_line_loc_rev_num
631: FROM po_line_locations_archive_all
632: WHERE po_header_id = l_po_header_id
633: AND po_line_id = lines_rec.po_line_id
634: AND line_location_id = lines_rec.line_location_id
635: AND ((po_release_id = l_po_rel_id) OR (po_release_id IS NULL))

Line 639: FROM po_line_locations_archive_all

635: AND ((po_release_id = l_po_rel_id) OR (po_release_id IS NULL))
636: AND latest_external_flag = 'Y'
637: AND revision_num = (
638: SELECT MAX(revision_num)
639: FROM po_line_locations_archive_all
640: WHERE po_header_id = l_po_header_id
641: AND po_line_id = lines_rec.po_line_id
642: AND line_location_id = lines_rec.line_location_id
643: AND ((po_release_id = l_po_rel_id) OR (po_release_id IS NULL))