APPS.CN_DIM_HIERARCHIES_PVT dependencies on CN_DIM_HIERARCHIES_PVT

Line 1: PACKAGE BODY CN_DIM_HIERARCHIES_PVT AS

1: PACKAGE BODY CN_DIM_HIERARCHIES_PVT AS
2: -- $Header: cnvdimhb.pls 120.7 2006/09/18 22:59:36 jxsingh noship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CN_DIM_HIERARCHIES_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CN_DIM_HIERARCHIES_PVT';

1: PACKAGE BODY CN_DIM_HIERARCHIES_PVT AS
2: -- $Header: cnvdimhb.pls 120.7 2006/09/18 22:59:36 jxsingh noship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CN_DIM_HIERARCHIES_PVT';
5:
6: -- Create a new hierarchy type
7: PROCEDURE Create_Hierarchy_Type
8: (p_api_version IN NUMBER, -- required

Line 1210: IF cn_dim_hierarchies_pvt.is_revenue_hier(l_head_hier_id,p_org_id) > 0 THEN

1206: --R12 MOAC Changes--Start
1207: and org_id = p_org_id;
1208: --R12 MOAC Changes--End
1209:
1210: IF cn_dim_hierarchies_pvt.is_revenue_hier(l_head_hier_id,p_org_id) > 0 THEN
1211: OPEN dup_rev_classes;
1212: FETCH dup_rev_classes INTO l_start_date, l_end_date, l_par_name;
1213:
1214: IF dup_rev_classes%found THEN

Line 1646: END CN_DIM_HIERARCHIES_PVT;

1642: cn_message_pkg.end_batch(l_process_audit_id);
1643: END Export;
1644:
1645:
1646: END CN_DIM_HIERARCHIES_PVT;