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.CN_DIM_HIERARCHIES_PVT dependencies on CN_DIM_HIERARCHIES

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 705: FUNCTION is_revenue_hier (p_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,

701: END Delete_Head_Hierarchy;
702:
703:
704: -- Function to identify if the hierarchy is a revenue class hierarchy
705: FUNCTION is_revenue_hier (p_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
706: p_org_id CN_DIM_HIERARCHIES.ORG_ID%TYPE)
707: RETURN NUMBER IS
708: l_count NUMBER := 0;
709: BEGIN

Line 706: p_org_id CN_DIM_HIERARCHIES.ORG_ID%TYPE)

702:
703:
704: -- Function to identify if the hierarchy is a revenue class hierarchy
705: FUNCTION is_revenue_hier (p_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
706: p_org_id CN_DIM_HIERARCHIES.ORG_ID%TYPE)
707: RETURN NUMBER IS
708: l_count NUMBER := 0;
709: BEGIN
710: select count(*)

Line 727: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,

723: (p_api_version IN NUMBER, -- required
724: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
725: p_commit IN VARCHAR2 := FND_API.G_FALSE,
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
728: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
729: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
730: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE, -- not used
731: --R12 MOAC Changes--Start

Line 728: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,

724: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
725: p_commit IN VARCHAR2 := FND_API.G_FALSE,
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
728: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
729: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
730: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE, -- not used
731: --R12 MOAC Changes--Start
732: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,

Line 729: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,

725: p_commit IN VARCHAR2 := FND_API.G_FALSE,
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
728: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
729: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
730: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE, -- not used
731: --R12 MOAC Changes--Start
732: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
733: --R12 MOAC Changes--End

Line 730: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE, -- not used

726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
728: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
729: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
730: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE, -- not used
731: --R12 MOAC Changes--Start
732: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
733: --R12 MOAC Changes--End
734: x_return_status OUT NOCOPY VARCHAR2,

Line 732: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,

728: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
729: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
730: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE, -- not used
731: --R12 MOAC Changes--Start
732: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
733: --R12 MOAC Changes--End
734: x_return_status OUT NOCOPY VARCHAR2,
735: x_msg_count OUT NOCOPY NUMBER,
736: x_msg_data OUT NOCOPY VARCHAR2,

Line 737: x_dim_hierarchy_id OUT NOCOPY CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE) IS

733: --R12 MOAC Changes--End
734: x_return_status OUT NOCOPY VARCHAR2,
735: x_msg_count OUT NOCOPY NUMBER,
736: x_msg_data OUT NOCOPY VARCHAR2,
737: x_dim_hierarchy_id OUT NOCOPY CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE) IS
738:
739: l_api_name CONSTANT VARCHAR2(30) := 'Create_Dim_Hierarchy';
740: l_api_version CONSTANT NUMBER := 1.0;
741: l_count NUMBER;

Line 743: x_root_node CN_DIM_HIERARCHIES.ROOT_NODE%TYPE;

739: l_api_name CONSTANT VARCHAR2(30) := 'Create_Dim_Hierarchy';
740: l_api_version CONSTANT NUMBER := 1.0;
741: l_count NUMBER;
742: l_name CN_HIERARCHY_NODES.NAME%TYPE;
743: x_root_node CN_DIM_HIERARCHIES.ROOT_NODE%TYPE;
744:
745: BEGIN
746: -- Standard Start of API savepoint
747: SAVEPOINT Create_Dim_Hierarchy;

Line 768: from cn_dim_hierarchies

764: -- API body
765:
766: -- validate dates don't overlap
767: select count(1) into l_count
768: from cn_dim_hierarchies
769: where header_dim_hierarchy_id = p_head_hierarchy_id
770: --R12 MOAC Changes--Start
771: and org_id = p_org_id
772: --R12 MOAC Changes--End

Line 792: cn_dim_hierarchies_pkg.insert_row

788: end if;
789:
790:
791: -- call new TH (original form used forms built in TH)
792: cn_dim_hierarchies_pkg.insert_row
793: (x_header_dim_hierarchy_id => p_head_hierarchy_id,
794: x_start_date => p_start_date,
795: x_end_date => p_end_date,
796: x_root_node => x_root_node,

Line 865: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,

861: (p_api_version IN NUMBER, -- required
862: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
865: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
866: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
867: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
868: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
869: --R12 MOAC Changes--Start

Line 866: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,

862: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
865: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
866: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
867: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
868: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
869: --R12 MOAC Changes--Start
870: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,

Line 867: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,

863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
865: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
866: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
867: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
868: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
869: --R12 MOAC Changes--Start
870: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
871: --R12 MOAC Changes--End

Line 868: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,

864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
865: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
866: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
867: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
868: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
869: --R12 MOAC Changes--Start
870: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
871: --R12 MOAC Changes--End
872: x_return_status OUT NOCOPY VARCHAR2,

Line 870: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,

866: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
867: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
868: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
869: --R12 MOAC Changes--Start
870: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
871: --R12 MOAC Changes--End
872: x_return_status OUT NOCOPY VARCHAR2,
873: x_msg_count OUT NOCOPY NUMBER,
874: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 879: l_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;

875:
876: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dim_Hierarchy';
877: l_api_version CONSTANT NUMBER := 1.0;
878: l_count NUMBER;
879: l_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;
880: l_root_node CN_DIM_HIERARCHIES.ROOT_NODE%TYPE;
881: l_old_start_date CN_DIM_HIERARCHIES.START_DATE%TYPE;
882: l_old_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;
883: BEGIN

Line 880: l_root_node CN_DIM_HIERARCHIES.ROOT_NODE%TYPE;

876: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dim_Hierarchy';
877: l_api_version CONSTANT NUMBER := 1.0;
878: l_count NUMBER;
879: l_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;
880: l_root_node CN_DIM_HIERARCHIES.ROOT_NODE%TYPE;
881: l_old_start_date CN_DIM_HIERARCHIES.START_DATE%TYPE;
882: l_old_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;
883: BEGIN
884: -- Standard Start of API savepoint

Line 881: l_old_start_date CN_DIM_HIERARCHIES.START_DATE%TYPE;

877: l_api_version CONSTANT NUMBER := 1.0;
878: l_count NUMBER;
879: l_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;
880: l_root_node CN_DIM_HIERARCHIES.ROOT_NODE%TYPE;
881: l_old_start_date CN_DIM_HIERARCHIES.START_DATE%TYPE;
882: l_old_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;
883: BEGIN
884: -- Standard Start of API savepoint
885: SAVEPOINT Update_Dim_Hierarchy;

Line 882: l_old_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;

878: l_count NUMBER;
879: l_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;
880: l_root_node CN_DIM_HIERARCHIES.ROOT_NODE%TYPE;
881: l_old_start_date CN_DIM_HIERARCHIES.START_DATE%TYPE;
882: l_old_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;
883: BEGIN
884: -- Standard Start of API savepoint
885: SAVEPOINT Update_Dim_Hierarchy;
886: -- Standard call to check for call compatibility.

Line 909: from cn_dim_hierarchies

905:
906: -- get head hierarchy ID and root node
907: select header_dim_hierarchy_id, root_node
908: into l_head_hierarchy_id, l_root_node
909: from cn_dim_hierarchies
910: where dim_hierarchy_id = p_dim_hierarchy_id
911: --R12 MOAC Changes--Start
912: and org_id = p_org_id;
913: --R12 MOAC Changes--End

Line 923: from cn_dim_hierarchies

919: RAISE FND_API.G_EXC_ERROR;
920: end if;
921:
922: select count(1) into l_count
923: from cn_dim_hierarchies
924: where header_dim_hierarchy_id = l_head_hierarchy_id
925: --R12 MOAC Changes--Start
926: and org_id = p_org_id
927: --R12 MOAC Changes--End

Line 944: from cn_dim_hierarchies

940: -- call to insert rows into notify log
941: IF is_revenue_hier (l_head_hierarchy_id,p_org_id) = 1 THEN -- R12 MOAC changes
942: select start_date, end_date
943: into l_old_start_date, l_old_end_date
944: from cn_dim_hierarchies
945: where dim_hierarchy_id = p_dim_hierarchy_id
946: --R12 MOAC Changes--Start
947: and org_id = p_org_id;
948: --R12 MOAC Changes--End

Line 964: cn_dim_hierarchies_pkg.update_row

960: END IF;
961:
962:
963:
964: cn_dim_hierarchies_pkg.update_row
965: (x_dim_hierarchy_id => p_dim_hierarchy_id,
966: x_header_dim_hierarchy_id => l_head_hierarchy_id,
967: x_start_date => p_start_date,
968: x_end_date => p_end_date,

Line 1026: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,

1022: (p_api_version IN NUMBER, -- required
1023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1024: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1025: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1026: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
1027: --R12 MOAC Changes--Start
1028: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
1029: --R12 MOAC Changes--End
1030: x_return_status OUT NOCOPY VARCHAR2,

Line 1028: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,

1024: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1025: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1026: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
1027: --R12 MOAC Changes--Start
1028: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
1029: --R12 MOAC Changes--End
1030: x_return_status OUT NOCOPY VARCHAR2,
1031: x_msg_count OUT NOCOPY NUMBER,
1032: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1036: l_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;

1032: x_msg_data OUT NOCOPY VARCHAR2) IS
1033:
1034: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Dim_Hierarchy';
1035: l_api_version CONSTANT NUMBER := 1.0;
1036: l_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;
1037: l_start_date CN_DIM_HIERARCHIES.START_DATE%TYPE;
1038: l_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;
1039:
1040: BEGIN

Line 1037: l_start_date CN_DIM_HIERARCHIES.START_DATE%TYPE;

1033:
1034: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Dim_Hierarchy';
1035: l_api_version CONSTANT NUMBER := 1.0;
1036: l_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;
1037: l_start_date CN_DIM_HIERARCHIES.START_DATE%TYPE;
1038: l_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;
1039:
1040: BEGIN
1041: -- Standard Start of API savepoint

Line 1038: l_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;

1034: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Dim_Hierarchy';
1035: l_api_version CONSTANT NUMBER := 1.0;
1036: l_head_hierarchy_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;
1037: l_start_date CN_DIM_HIERARCHIES.START_DATE%TYPE;
1038: l_end_date CN_DIM_HIERARCHIES.END_DATE%TYPE;
1039:
1040: BEGIN
1041: -- Standard Start of API savepoint
1042: SAVEPOINT Delete_Dim_Hierarchy;

Line 1064: from cn_dim_hierarchies

1060:
1061: -- get head hierarchy ID, start date and end date
1062: select header_dim_hierarchy_id, start_date, end_date
1063: into l_head_hierarchy_id, l_start_date, l_end_date
1064: from cn_dim_hierarchies
1065: where dim_hierarchy_id = p_dim_hierarchy_id
1066: --R12 MOAC Changes--Start
1067: and org_id = p_org_id;
1068: --R12 MOAC Changes--End

Line 1086: cn_dim_hierarchies_pkg.delete_row (p_dim_hierarchy_id);--,p_org_id);

1082: END IF;
1083:
1084:
1085: -- call the original forms API (CNDIHY.fmb -> CNDIHY2s/b.pls)
1086: cn_dim_hierarchies_pkg.delete_row (p_dim_hierarchy_id);--,p_org_id);
1087:
1088: -- End of API body.
1089:
1090: -- Standard check of p_commit.

Line 1154: l_head_hier_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;

1150: l_max_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
1151: l_start_date DATE;
1152: l_end_date DATE;
1153: l_par_name VARCHAR2(30);
1154: l_head_hier_id CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE;
1155:
1156: CURSOR dup_rev_classes is
1157: select h.start_date, h.end_date, r.name
1158: from cn_quota_rules r1, cn_quota_rules r2, cn_dim_explosion d,

Line 1159: cn_dim_hierarchies h, cn_quotas q, cn_revenue_classes r

1155:
1156: CURSOR dup_rev_classes is
1157: select h.start_date, h.end_date, r.name
1158: from cn_quota_rules r1, cn_quota_rules r2, cn_dim_explosion d,
1159: cn_dim_hierarchies h, cn_quotas q, cn_revenue_classes r
1160: where r1.revenue_class_id = p_external_id
1161: and r2.revenue_class_id = d.ancestor_external_id
1162: AND r.revenue_class_id = d.ancestor_external_id
1163: and d.value_id = p_parent_value_id

Line 1204: FROM cn_dim_hierarchies

1200: -- call the original forms API (CNDIHY.fmb -> CNDIHY2s/b.pls)
1201: BEGIN
1202: -- see if we're dealing with the revenue classes
1203: SELECT header_dim_hierarchy_id INTO l_head_hier_id
1204: FROM cn_dim_hierarchies
1205: WHERE dim_hierarchy_id = p_dim_hierarchy_id
1206: --R12 MOAC Changes--Start
1207: and org_id = p_org_id;
1208: --R12 MOAC Changes--End

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 1451: cn_head_hierarchies h, cn_dim_hierarchies m

1447: M.START_DATE START_DATE,
1448: M.END_DATE END_DATE,
1449: m.dim_hierarchy_id
1450: FROM cn_dimensions d, cn_objects o1, cn_objects o2, cn_objects o3,
1451: cn_head_hierarchies h, cn_dim_hierarchies m
1452: WHERE o1.dimension_id = d.dimension_id
1453: AND o1.table_id = d.source_table_id
1454: AND o1.object_type = 'COL'
1455: AND o1.primary_key = 'Y'

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;