DBA Data[Home] [Help]

APPS.M4R_7B5_OSFM_PKG dependencies on PO_RELEASES_ARCHIVE_ALL

Line 85: FROM po_releases_archive_all

81: g_exception_tracking_msg := 'Query po_releases_all for header_id,release_num';
82:
83: SELECT po_header_id,release_num
84: INTO l_po_header_id, l_po_rel_num
85: FROM po_releases_archive_all
86: WHERE po_release_id = l_po_rel_id
87: AND revision_num = l_po_rel_rev_num;
88:
89: IF (g_debug_level <= 1) THEN

Line 375: FROM po_releases_archive_all

371: g_exception_tracking_msg := 'Query po_releases_all for dates';
372:
373: SELECT revised_date,creation_date
374: INTO l_rev_date,l_creation_date
375: FROM po_releases_archive_all
376: WHERE po_release_id = l_po_rel_id
377: AND revision_num = l_po_rel_rev_num;
378:
379: IF (g_debug_level <= 1) THEN

Line 939: g_exception_tracking_msg := 'Query po_releases_archive_all to find Header change between current and previous revision';

935: END IF;
936:
937: ELSE
938:
939: g_exception_tracking_msg := 'Query po_releases_archive_all to find Header change between current and previous revision';
940:
941: BEGIN
942: SELECT f.release_num ,t.release_num
943: INTO l_from_rel_num,l_to_rel_num

Line 944: FROM po_releases_archive_all f,po_releases_archive_all t

940:
941: BEGIN
942: SELECT f.release_num ,t.release_num
943: INTO l_from_rel_num,l_to_rel_num
944: FROM po_releases_archive_all f,po_releases_archive_all t
945: WHERE f.po_release_id = p_release_id
946: AND f.revision_num = p_revision_num
947: AND t.po_release_id = p_release_id
948: AND t.revision_num = p_revision_num-1;