APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_GA_ORG_ASSIGNMENTS_ARCHIVE

Line 2276: -- PO_GA_ORG_ASSIGNMENTS_ARCHIVE

2272: --Name: ARCHIVE_ORG_ASSIGNMENTS
2273: --Pre-reqs:
2274: -- None.
2275: --Modifies:
2276: -- PO_GA_ORG_ASSIGNMENTS_ARCHIVE
2277: --Locks:
2278: -- None.
2279: --Function:
2280: -- Arcives the global agreement org assignments.

Line 2313: 'INSERT PO_GA_ORG_ASSIGNMENTS_ARCHIVE');

2309: l_progress := '010';
2310: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
2311: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
2312: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2313: 'INSERT PO_GA_ORG_ASSIGNMENTS_ARCHIVE');
2314: END IF;
2315:
2316: INSERT INTO PO_GA_ORG_ASSIGNMENTS_ARCHIVE
2317: (org_assignment_id , --

Line 2316: INSERT INTO PO_GA_ORG_ASSIGNMENTS_ARCHIVE

2312: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2313: 'INSERT PO_GA_ORG_ASSIGNMENTS_ARCHIVE');
2314: END IF;
2315:
2316: INSERT INTO PO_GA_ORG_ASSIGNMENTS_ARCHIVE
2317: (org_assignment_id , --
2318: created_by ,
2319: creation_date ,
2320: enabled_flag ,

Line 2345: PO_GA_ORG_ASSIGNMENTS_ARCHIVE POGA

2341: POG.vendor_site_id ,
2342: 'Y' ,
2343: p_revision_num
2344: FROM PO_GA_ORG_ASSIGNMENTS POG,
2345: PO_GA_ORG_ASSIGNMENTS_ARCHIVE POGA
2346: WHERE POG.po_header_id = p_document_id
2347: --AND POG.po_header_id = POGA.po_header_id (+)
2348: --AND POG.organization_id = POGA.organization_id (+)
2349: AND POG.org_assignment_id = POGA.org_assignment_id (+) --

Line 2369: 'Update PO_GA_ORG_ASSIGNMENTS_ARCHIVE to reset latest_external_flag');

2365: l_progress := '020';
2366: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
2367: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
2368: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2369: 'Update PO_GA_ORG_ASSIGNMENTS_ARCHIVE to reset latest_external_flag');
2370: END IF;
2371:
2372: -- If a row was inserted into PO_GA_ORG_ASSIGNMENTS_ARCHIVE, then set the appropriate flags
2373: UPDATE PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG1

Line 2372: -- If a row was inserted into PO_GA_ORG_ASSIGNMENTS_ARCHIVE, then set the appropriate flags

2368: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2369: 'Update PO_GA_ORG_ASSIGNMENTS_ARCHIVE to reset latest_external_flag');
2370: END IF;
2371:
2372: -- If a row was inserted into PO_GA_ORG_ASSIGNMENTS_ARCHIVE, then set the appropriate flags
2373: UPDATE PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG1
2374: SET latest_external_flag = 'N'
2375: WHERE po_header_id = p_document_id
2376: AND latest_external_flag = 'Y'

Line 2373: UPDATE PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG1

2369: 'Update PO_GA_ORG_ASSIGNMENTS_ARCHIVE to reset latest_external_flag');
2370: END IF;
2371:
2372: -- If a row was inserted into PO_GA_ORG_ASSIGNMENTS_ARCHIVE, then set the appropriate flags
2373: UPDATE PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG1
2374: SET latest_external_flag = 'N'
2375: WHERE po_header_id = p_document_id
2376: AND latest_external_flag = 'Y'
2377: AND revision_num < p_revision_num

Line 2380: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG2

2376: AND latest_external_flag = 'Y'
2377: AND revision_num < p_revision_num
2378: AND EXISTS
2379: (SELECT 'A new archived row'
2380: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG2
2381: WHERE POG2.org_assignment_id = POG1.org_assignment_id --
2382: -- POG2.po_header_id = POG1.po_header_id
2383: --AND POG2.organization_id = POG1.organization_id
2384: AND POG2.latest_external_flag = 'Y'