APPS.M4R_7B5_OSFM_PKG dependencies on PO_RELEASES_ALL

Line 81: g_exception_tracking_msg := 'Query po_releases_all for header_id,release_num';

77:
78: l_po_rel_id := l_po_doc_id;
79: l_po_rel_rev_num := l_po_rev_num;
80:
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

Line 371: g_exception_tracking_msg := 'Query po_releases_all for dates';

367: l_all_new_flag := 'N';
368:
369: IF l_po_doc_type ='RELEASE' THEN
370:
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

Line 380: cln_debug_pub.Add('From po_releases_all Table',1);

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
380: cln_debug_pub.Add('From po_releases_all Table',1);
381: cln_debug_pub.Add('creation_date - ' ||l_creation_date,1);
382: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);
383: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);
384: END IF;

Line 386: g_exception_tracking_msg := 'Query po_releases_all for cance_flag';

382: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);
383: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);
384: END IF;
385:
386: g_exception_tracking_msg := 'Query po_releases_all for cance_flag';
387:
388: -- Query for Cancel flag
389: SELECT cancel_flag
390: INTO l_cancel_flag

Line 391: FROM po_releases_all

387:
388: -- Query for Cancel flag
389: SELECT cancel_flag
390: INTO l_cancel_flag
391: FROM po_releases_all
392: WHERE po_release_id = l_po_rel_id;
393:
394: IF (g_debug_level <= 1) THEN
395: cln_debug_pub.Add('cancel_flag - '||l_cancel_flag,1);