APPS.AHL_UC_TREE_PVT dependencies on AHL_UC_TREE_PVT

Line 1: PACKAGE BODY AHL_UC_TREE_PVT AS

1: PACKAGE BODY AHL_UC_TREE_PVT AS
2: /* $Header: AHLVUCTB.pls 120.3.12020000.2 2012/12/07 15:42:28 sareepar ship $ */
3:
4: -- Define global internal variables and cursors
5: G_PKG_NAME VARCHAR2(30) := 'AHL_UC_TREE_PVT';

Line 5: G_PKG_NAME VARCHAR2(30) := 'AHL_UC_TREE_PVT';

1: PACKAGE BODY AHL_UC_TREE_PVT AS
2: /* $Header: AHLVUCTB.pls 120.3.12020000.2 2012/12/07 15:42:28 sareepar ship $ */
3:
4: -- Define global internal variables and cursors
5: G_PKG_NAME VARCHAR2(30) := 'AHL_UC_TREE_PVT';
6:
7: ------------------------------------------------------------------------------------
8: -- Common variables
9: ------------------------------------------------------------------------------------

Line 2399: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UC_TREE_PVT.Remap_IB_Tree';

2395: AND C.relationship_type_code = 'COMPONENT-OF'
2396: AND trunc(nvl(C.active_start_date,SYSDATE)) <= trunc(SYSDATE)
2397: AND trunc(nvl(C.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2398:
2399: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UC_TREE_PVT.Remap_IB_Tree';
2400: l_extra_instances_tbl T_ID_TBL;
2401: l_relations_tbl T_ID_TBL;
2402: l_premapped_instances_tbl T_ID_TBL;
2403: l_temp NUMBER;

Line 2557: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UC_TREE_PVT.Process_instances';

2553: AND trunc(nvl(C.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2554:
2555: l_instance_dtls get_instance_dtls_csr%ROWTYPE;
2556: l_ii_rel_dtls get_ii_rel_dtls_csr%ROWTYPE;
2557: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UC_TREE_PVT.Process_instances';
2558: l_map_tbl T_ID_TBL;
2559: l_item_match BOOLEAN;
2560: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2561: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 2725: END AHL_UC_TREE_PVT; -- Package body

2721: END IF;
2722: END Process_instances;
2723:
2724:
2725: END AHL_UC_TREE_PVT; -- Package body