eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_EXHIBIT_DETAILS

Line 7179: -- PO_EXHIBIT_DETAILS_ARCHIVE

7175: --Name: ARCHIVE_EXHIBITS
7176: --Pre-reqs:
7177: -- None.
7178: --Modifies:
7179: -- PO_EXHIBIT_DETAILS_ARCHIVE
7180: --Locks:
7181: -- None.
7182: --Function:
7183: -- Arcives the po document exhibits.

Line 7220: 'INSERT PO_EXHIBIT_DETAILS_ARCHIVE');

7216:
7217: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
7218: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
7219: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
7220: 'INSERT PO_EXHIBIT_DETAILS_ARCHIVE');
7221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
7222: 'l_clm_flag : ' || l_clm_flag);
7223: END IF;
7224:

Line 7225: INSERT INTO po_exhibit_details_archive

7221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
7222: 'l_clm_flag : ' || l_clm_flag);
7223: END IF;
7224:
7225: INSERT INTO po_exhibit_details_archive
7226: (
7227: po_exhibit_details_id,
7228: po_header_id,
7229: exhibit_name,

Line 7227: po_exhibit_details_id,

7223: END IF;
7224:
7225: INSERT INTO po_exhibit_details_archive
7226: (
7227: po_exhibit_details_id,
7228: po_header_id,
7229: exhibit_name,
7230: exhibit_description,
7231: is_cdrl,

Line 7242: pex.po_exhibit_details_id,

7238: CREATED_BY,
7239: LAST_UPDATE_LOGIN
7240: )
7241: SELECT
7242: pex.po_exhibit_details_id,
7243: pex.po_header_id,
7244: pex.exhibit_name,
7245: pex.exhibit_description,
7246: pex.is_cdrl,

Line 7255: FROM po_exhibit_details pex,

7251: pex.LAST_UPDATED_BY,
7252: pex.CREATION_DATE,
7253: pex.CREATED_BY,
7254: pex.LAST_UPDATE_LOGIN
7255: FROM po_exhibit_details pex,
7256: po_exhibit_details_archive pexa
7257: WHERE pex.po_header_id = p_document_id
7258: AND pex.po_exhibit_details_id = pexa.po_exhibit_details_id (+)
7259: AND pexa.latest_external_flag (+) = 'Y'

Line 7256: po_exhibit_details_archive pexa

7252: pex.CREATION_DATE,
7253: pex.CREATED_BY,
7254: pex.LAST_UPDATE_LOGIN
7255: FROM po_exhibit_details pex,
7256: po_exhibit_details_archive pexa
7257: WHERE pex.po_header_id = p_document_id
7258: AND pex.po_exhibit_details_id = pexa.po_exhibit_details_id (+)
7259: AND pexa.latest_external_flag (+) = 'Y'
7260: AND (

Line 7258: AND pex.po_exhibit_details_id = pexa.po_exhibit_details_id (+)

7254: pex.LAST_UPDATE_LOGIN
7255: FROM po_exhibit_details pex,
7256: po_exhibit_details_archive pexa
7257: WHERE pex.po_header_id = p_document_id
7258: AND pex.po_exhibit_details_id = pexa.po_exhibit_details_id (+)
7259: AND pexa.latest_external_flag (+) = 'Y'
7260: AND (
7261: (pex.exhibit_description IS NULL AND pexa.exhibit_description IS NOT NULL OR
7262: pex.exhibit_description IS NOT NULL AND pexa.exhibit_description IS NULL OR

Line 7278: 'Update po_exhibit_details_archive to reset latest_external_flag');

7274: l_progress := '020';
7275: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
7276: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
7277: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
7278: 'Update po_exhibit_details_archive to reset latest_external_flag');
7279: END IF;
7280:
7281: -- If a row was inserted into po_exhibit_details_archive, then set the appropriate flags
7282: UPDATE po_exhibit_details_archive PEXA

Line 7281: -- If a row was inserted into po_exhibit_details_archive, then set the appropriate flags

7277: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
7278: 'Update po_exhibit_details_archive to reset latest_external_flag');
7279: END IF;
7280:
7281: -- If a row was inserted into po_exhibit_details_archive, then set the appropriate flags
7282: UPDATE po_exhibit_details_archive PEXA
7283: SET latest_external_flag = 'N'
7284: WHERE po_header_id = p_document_id
7285: AND latest_external_flag = 'Y'

Line 7282: UPDATE po_exhibit_details_archive PEXA

7278: 'Update po_exhibit_details_archive to reset latest_external_flag');
7279: END IF;
7280:
7281: -- If a row was inserted into po_exhibit_details_archive, then set the appropriate flags
7282: UPDATE po_exhibit_details_archive PEXA
7283: SET latest_external_flag = 'N'
7284: WHERE po_header_id = p_document_id
7285: AND latest_external_flag = 'Y'
7286: AND revision_num < p_revision_num

Line 7289: FROM po_exhibit_details_archive PEXA2

7285: AND latest_external_flag = 'Y'
7286: AND revision_num < p_revision_num
7287: AND EXISTS
7288: (SELECT 'A new archived row'
7289: FROM po_exhibit_details_archive PEXA2
7290: WHERE PEXA2.po_exhibit_details_id = PEXA.po_exhibit_details_id
7291: AND PEXA2.latest_external_flag = 'Y'
7292: AND PEXA2.revision_num = p_revision_num);
7293: ELSE

Line 7290: WHERE PEXA2.po_exhibit_details_id = PEXA.po_exhibit_details_id

7286: AND revision_num < p_revision_num
7287: AND EXISTS
7288: (SELECT 'A new archived row'
7289: FROM po_exhibit_details_archive PEXA2
7290: WHERE PEXA2.po_exhibit_details_id = PEXA.po_exhibit_details_id
7291: AND PEXA2.latest_external_flag = 'Y'
7292: AND PEXA2.revision_num = p_revision_num);
7293: ELSE
7294: l_progress := '030';