DBA Data[Home] [Help]

APPS.PO_AP_PURGE_GRP dependencies on STANDARD

Line 293: * Determines if any documents - Standard POs, Requisitions, ASLs -

289: * REQUIRES:
290: * p_po_header_id should correspond to a Global Agreement.
291: *
292: * EFFECTS:
293: * Determines if any documents - Standard POs, Requisitions, ASLs -
294: * (in any status and from any org) still reference the GA from another OU.
295: *
296: * PARAMETERS:
297: * p_po_header_id - Document ID of Global Agreement

Line 453: SELECT 'Standard POs'

449: IS
450: l_dummy VARCHAR2(20);
451: BEGIN
452:
453: SELECT 'Standard POs'
454: INTO l_dummy
455: FROM po_lines_all pol,
456: po_system_parameters psp
457: WHERE pol.from_header_id = p_po_header_id

Line 479: * p_po_header_id should correspond to a standard PO

475: *
476: * FUNCTION: stdpo_ref_open_ga
477: *
478: * REQUIRES:
479: * p_po_header_id should correspond to a standard PO
480: *
481: * EFFECTS:
482: * Determines if this standard PO references any open GA from
483: * another OU or current OU

Line 482: * Determines if this standard PO references any open GA from

478: * REQUIRES:
479: * p_po_header_id should correspond to a standard PO
480: *
481: * EFFECTS:
482: * Determines if this standard PO references any open GA from
483: * another OU or current OU
484: *
485: * PARAMETERS:
486: * p_po_header_id - Document ID of the std PO

Line 489: * TRUE if if this standard PO references any open GA

485: * PARAMETERS:
486: * p_po_header_id - Document ID of the std PO
487: *
488: * RETURNS:
489: * TRUE if if this standard PO references any open GA
490: *
491: *===========================================================================
492: */
493: FUNCTION stdpo_ref_ga_check