[Home] [Help]
322:
323: /**************************************************************************
324: * PROCEDURE: archive_on_approval_set
325: * DESCRIPTION: This procedure check for archive revision flag
326: * set in the PO Document Types form.
327: * It returns 'Y' if it is set to 'APPROVAL';
328: * Otherwise 'N'.
329: * This check is mainly used by Change Order.
330: * Change Order should only executed if archive on
364: /* BUG# 1180957: draising
365: ** Forward fix of Bug# 1180198
366: ** Desc : We need to set the org_id and use stripped tables
367: ** to get the ARCHIVE_EXTERNAL_REVISION_CODE. The previous
368: ** code to get data from the PO_DOCUMENT_TYPES_ALL table
369: ** an org_id would fail for non- multi-org environment.
370: */
371:
372: IF x_org_id is NOT NULL THEN
379: Begin
380:
381: SELECT ARCHIVE_EXTERNAL_REVISION_CODE
382: INTO x_archive_code
383: FROM PO_DOCUMENT_TYPES podta
384: WHERE podta.DOCUMENT_TYPE_CODE = x_doc_type
385: AND podta.DOCUMENT_SUBTYPE = x_doc_subtype;
386:
387: Exception