DBA Data[Home] [Help]

APPS.AMW_PROC_ORG_HIERARCHY_PVT dependencies on AMW_PROC_ORG_HIERARCHY_PVT

Line 1: PACKAGE BODY AMW_PROC_ORG_HIERARCHY_PVT as

1: PACKAGE BODY AMW_PROC_ORG_HIERARCHY_PVT as
2: /* $Header: amwvpohb.pls 120.0 2005/05/31 20:34:58 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_PROC_ORG_HIERARCHY_PVT';

12: --
13: -- End of Comments
14: -- ===============================================================
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_PROC_ORG_HIERARCHY_PVT';
17: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwvpohb.pls';
18:
19: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
20: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 2170: --- this API will be called from the amw_proc_org_hierarchy_pvt

2166: l_api_version_number CONSTANT NUMBER := 1.0;
2167: x_process_organization_id NUMBER := 0;
2168: l_process_id NUMBER;
2169:
2170: --- this API will be called from the amw_proc_org_hierarchy_pvt
2171: --- For a given process, this API traverses all the upward processes
2172: --- in that Process hierarchy for that organization
2173: cursor c1 is
2174: select process_id,

Line 2556: END AMW_PROC_ORG_HIERARCHY_PVT;

2552: return null;
2553: */
2554: end GET_parent_process_id;
2555:
2556: END AMW_PROC_ORG_HIERARCHY_PVT;