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_GA_ORG_ASSIGNMENTS_ARCHIVE

Line 2634: -- PO_GA_ORG_ASSIGNMENTS_ARCHIVE

2630: --Name: ARCHIVE_ORG_ASSIGNMENTS
2631: --Pre-reqs:
2632: -- None.
2633: --Modifies:
2634: -- PO_GA_ORG_ASSIGNMENTS_ARCHIVE
2635: --Locks:
2636: -- None.
2637: --Function:
2638: -- Arcives the global agreement org assignments.

Line 2671: 'INSERT PO_GA_ORG_ASSIGNMENTS_ARCHIVE');

2667: l_progress := '010';
2668: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
2669: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
2670: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2671: 'INSERT PO_GA_ORG_ASSIGNMENTS_ARCHIVE');
2672: END IF;
2673:
2674: INSERT INTO PO_GA_ORG_ASSIGNMENTS_ARCHIVE
2675: (org_assignment_id , --

Line 2674: INSERT INTO PO_GA_ORG_ASSIGNMENTS_ARCHIVE

2670: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2671: 'INSERT PO_GA_ORG_ASSIGNMENTS_ARCHIVE');
2672: END IF;
2673:
2674: INSERT INTO PO_GA_ORG_ASSIGNMENTS_ARCHIVE
2675: (org_assignment_id , --
2676: created_by ,
2677: creation_date ,
2678: enabled_flag ,

Line 2703: PO_GA_ORG_ASSIGNMENTS_ARCHIVE POGA

2699: POG.vendor_site_id ,
2700: 'Y' ,
2701: p_revision_num
2702: FROM PO_GA_ORG_ASSIGNMENTS POG,
2703: PO_GA_ORG_ASSIGNMENTS_ARCHIVE POGA
2704: WHERE POG.po_header_id = p_document_id
2705: --AND POG.po_header_id = POGA.po_header_id (+)
2706: --AND POG.organization_id = POGA.organization_id (+)
2707: AND POG.org_assignment_id = POGA.org_assignment_id (+) --

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

2723: l_progress := '020';
2724: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
2725: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
2726: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2727: 'Update PO_GA_ORG_ASSIGNMENTS_ARCHIVE to reset latest_external_flag');
2728: END IF;
2729:
2730: -- If a row was inserted into PO_GA_ORG_ASSIGNMENTS_ARCHIVE, then set the appropriate flags
2731: UPDATE PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG1

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

2726: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2727: 'Update PO_GA_ORG_ASSIGNMENTS_ARCHIVE to reset latest_external_flag');
2728: END IF;
2729:
2730: -- If a row was inserted into PO_GA_ORG_ASSIGNMENTS_ARCHIVE, then set the appropriate flags
2731: UPDATE PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG1
2732: SET latest_external_flag = 'N'
2733: WHERE po_header_id = p_document_id
2734: AND latest_external_flag = 'Y'

Line 2731: UPDATE PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG1

2727: 'Update PO_GA_ORG_ASSIGNMENTS_ARCHIVE to reset latest_external_flag');
2728: END IF;
2729:
2730: -- If a row was inserted into PO_GA_ORG_ASSIGNMENTS_ARCHIVE, then set the appropriate flags
2731: UPDATE PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG1
2732: SET latest_external_flag = 'N'
2733: WHERE po_header_id = p_document_id
2734: AND latest_external_flag = 'Y'
2735: AND revision_num < p_revision_num

Line 2738: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG2

2734: AND latest_external_flag = 'Y'
2735: AND revision_num < p_revision_num
2736: AND EXISTS
2737: (SELECT 'A new archived row'
2738: FROM PO_GA_ORG_ASSIGNMENTS_ARCHIVE POG2
2739: WHERE POG2.org_assignment_id = POG1.org_assignment_id --
2740: -- POG2.po_header_id = POG1.po_header_id
2741: --AND POG2.organization_id = POG1.organization_id
2742: AND POG2.latest_external_flag = 'Y'