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.AHL_UC_TREE_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 1107: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;

1103: l_return_value BOOLEAN;
1104: l_transaction_type_id NUMBER;
1105: l_version_no NUMBER;
1106: l_uc_header_all ahl_unit_config_headers%ROWTYPE;
1107: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1108: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1109: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1110: l_root_uc_header_id NUMBER;
1111: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 1108: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

1104: l_transaction_type_id NUMBER;
1105: l_version_no NUMBER;
1106: l_uc_header_all ahl_unit_config_headers%ROWTYPE;
1107: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1108: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1109: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1110: l_root_uc_header_id NUMBER;
1111: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1112: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 1109: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;

1105: l_version_no NUMBER;
1106: l_uc_header_all ahl_unit_config_headers%ROWTYPE;
1107: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1108: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1109: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1110: l_root_uc_header_id NUMBER;
1111: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1112: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1113: l_root_uc_ovn NUMBER;

Line 1865: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;

1861: l_matched BOOLEAN;
1862: l_return_value BOOLEAN;
1863: l_transaction_type_id NUMBER;
1864: l_version_no NUMBER;
1865: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1866: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1867: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1868: l_new_relationship_id NUMBER;
1869: --In order to check whether the instance belongs to a sub unit or an extra node branch

Line 1866: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

1862: l_return_value BOOLEAN;
1863: l_transaction_type_id NUMBER;
1864: l_version_no NUMBER;
1865: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1866: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1867: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1868: l_new_relationship_id NUMBER;
1869: --In order to check whether the instance belongs to a sub unit or an extra node branch
1870: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS

Line 1867: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;

1863: l_transaction_type_id NUMBER;
1864: l_version_no NUMBER;
1865: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1866: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1867: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1868: l_new_relationship_id NUMBER;
1869: --In order to check whether the instance belongs to a sub unit or an extra node branch
1870: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS
1871: SELECT object_id, subject_id, position_reference

Line 2341: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;

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;
2341: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2342: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2343: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2344: l_ii_rel_dtls get_ii_rel_dtls_csr%ROWTYPE;
2345: l_return_status VARCHAR2(1);

Line 2342: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

2338: l_relations_tbl T_ID_TBL;
2339: l_premapped_instances_tbl T_ID_TBL;
2340: l_temp NUMBER;
2341: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2342: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2343: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2344: l_ii_rel_dtls get_ii_rel_dtls_csr%ROWTYPE;
2345: l_return_status VARCHAR2(1);
2346: l_msg_count NUMBER;

Line 2343: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;

2339: l_premapped_instances_tbl T_ID_TBL;
2340: l_temp NUMBER;
2341: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2342: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2343: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2344: l_ii_rel_dtls get_ii_rel_dtls_csr%ROWTYPE;
2345: l_return_status VARCHAR2(1);
2346: l_msg_count NUMBER;
2347: l_msg_data VARCHAR2(2000);

Line 2497: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;

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;
2499: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2500: l_return_value BOOLEAN;
2501: l_transaction_type_id NUMBER;

Line 2498: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

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;
2499: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2500: l_return_value BOOLEAN;
2501: l_transaction_type_id NUMBER;
2502: l_return_status VARCHAR2(1);

Line 2499: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;

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;
2499: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2500: l_return_value BOOLEAN;
2501: l_transaction_type_id NUMBER;
2502: l_return_status VARCHAR2(1);
2503: l_msg_count NUMBER;