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.2.12010000.2 2008/11/06 10:55:52 sathapli 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.2.12010000.2 2008/11/06 10:55:52 sathapli ship $ */
3:
4: -- Define global internal variables and cursors
5: G_PKG_NAME VARCHAR2(30) := 'AHL_UC_TREE_PVT';
6:
7: -- Added by rbhavsar on July 25, 2007 to remap IB Tree Nodes to fix FP bug 6276991
8: TYPE T_ID_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
9:

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

2332: AND C.relationship_type_code = 'COMPONENT-OF'
2333: AND trunc(nvl(C.active_start_date,SYSDATE)) <= trunc(SYSDATE)
2334: AND trunc(nvl(C.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2335:
2336: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UC_TREE_PVT.Remap_IB_Tree';
2337: l_extra_instances_tbl T_ID_TBL;
2338: l_relations_tbl T_ID_TBL;
2339: l_premapped_instances_tbl T_ID_TBL;
2340: l_temp NUMBER;

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

2490: AND trunc(nvl(C.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2491:
2492: l_instance_dtls get_instance_dtls_csr%ROWTYPE;
2493: l_ii_rel_dtls get_ii_rel_dtls_csr%ROWTYPE;
2494: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UC_TREE_PVT.Process_instances';
2495: l_map_tbl T_ID_TBL;
2496: l_item_match BOOLEAN;
2497: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2498: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 2662: END AHL_UC_TREE_PVT; -- Package body

2658: END IF;
2659: END Process_instances;
2660:
2661:
2662: END AHL_UC_TREE_PVT; -- Package body