1145: l_return_value BOOLEAN;
1146: l_transaction_type_id NUMBER;
1147: l_version_no NUMBER;
1148: l_uc_header_all ahl_unit_config_headers%ROWTYPE;
1149: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1150: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1151: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1152: l_root_uc_header_id NUMBER;
1153: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1146: l_transaction_type_id NUMBER;
1147: l_version_no NUMBER;
1148: l_uc_header_all ahl_unit_config_headers%ROWTYPE;
1149: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1150: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1151: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1152: l_root_uc_header_id NUMBER;
1153: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1154: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1147: l_version_no NUMBER;
1148: l_uc_header_all ahl_unit_config_headers%ROWTYPE;
1149: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1150: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1151: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1152: l_root_uc_header_id NUMBER;
1153: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1154: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1155: l_root_uc_ovn NUMBER;
1924: l_matched BOOLEAN;
1925: l_return_value BOOLEAN;
1926: l_transaction_type_id NUMBER;
1927: l_version_no NUMBER;
1928: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1929: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1930: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1931: l_new_relationship_id NUMBER;
1932: --In order to check whether the instance belongs to a sub unit or an extra node branch
1925: l_return_value BOOLEAN;
1926: l_transaction_type_id NUMBER;
1927: l_version_no NUMBER;
1928: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1929: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1930: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1931: l_new_relationship_id NUMBER;
1932: --In order to check whether the instance belongs to a sub unit or an extra node branch
1933: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS
1926: l_transaction_type_id NUMBER;
1927: l_version_no NUMBER;
1928: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1929: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1930: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1931: l_new_relationship_id NUMBER;
1932: --In order to check whether the instance belongs to a sub unit or an extra node branch
1933: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS
1934: SELECT object_id, subject_id, position_reference
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;
2404: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2405: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2406: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2407: l_ii_rel_dtls get_ii_rel_dtls_csr%ROWTYPE;
2408: l_return_status VARCHAR2(1);
2401: l_relations_tbl T_ID_TBL;
2402: l_premapped_instances_tbl T_ID_TBL;
2403: l_temp NUMBER;
2404: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2405: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2406: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2407: l_ii_rel_dtls get_ii_rel_dtls_csr%ROWTYPE;
2408: l_return_status VARCHAR2(1);
2409: l_msg_count NUMBER;
2402: l_premapped_instances_tbl T_ID_TBL;
2403: l_temp NUMBER;
2404: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2405: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2406: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2407: l_ii_rel_dtls get_ii_rel_dtls_csr%ROWTYPE;
2408: l_return_status VARCHAR2(1);
2409: l_msg_count NUMBER;
2410: l_msg_data VARCHAR2(2000);
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;
2562: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2563: l_return_value BOOLEAN;
2564: l_transaction_type_id NUMBER;
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;
2562: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2563: l_return_value BOOLEAN;
2564: l_transaction_type_id NUMBER;
2565: l_return_status VARCHAR2(1);
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;
2562: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2563: l_return_value BOOLEAN;
2564: l_transaction_type_id NUMBER;
2565: l_return_status VARCHAR2(1);
2566: l_msg_count NUMBER;