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_PC_ASSOCIATION_PVT dependencies on AHL_PC_NODES_B

Line 151: UPDATE ahl_pc_nodes_b

147: IF G_DEBUG='Y' THEN
148: AHL_DEBUG_PUB.debug('PCA -- PVT -- ATTACH_UNIT for ID='||p_x_assos_rec.PC_ASSOCIATION_ID||' -- unit_id'||p_x_assos_rec.UNIT_ITEM_ID||' -- pc_node_id='||p_x_assos_rec.PC_NODE_ID);
149: END IF;
150:
151: UPDATE ahl_pc_nodes_b
152: SET child_count = NVL(child_count, 0) + 1
153: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
154:
155: SET_PC_HEADER_STATUS (p_x_assos_rec.pc_node_id);

Line 229: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE

225:
226: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)
227: IS
228: SELECT HEAD.PRIMARY_FLAG
229: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE
230: WHERE NODE.PC_HEADER_ID = HEAD.PC_HEADER_ID AND
231: NODE.PC_NODE_ID = p_pc_node_id;
232:
233: BEGIN

Line 299: UPDATE ahl_pc_nodes_b

295: IF G_DEBUG='Y' THEN
296: AHL_DEBUG_PUB.debug('PCA -- PVT -- DETACH_UNIT for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);
297: END IF;
298:
299: UPDATE ahl_pc_nodes_b
300: SET child_count = NVL(child_count, 1) - 1
301: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
302: --ELSE
303: -- FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_DEL_HAS_ASSOS');

Line 492: UPDATE ahl_pc_nodes_b

488: IF G_DEBUG='Y' THEN
489: AHL_DEBUG_PUB.debug('PCA -- PVT -- ATTACH_PART for ID='||p_x_assos_rec.PC_ASSOCIATION_ID||' -- part_id'||p_x_assos_rec.UNIT_ITEM_ID||' -- pc_node_id='||p_x_assos_rec.PC_NODE_ID);
490: END IF;
491:
492: UPDATE ahl_pc_nodes_b
493: SET child_count = NVL(child_count, 0) + 1
494: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
495:
496: SET_PC_HEADER_STATUS (p_x_assos_rec.pc_node_id);

Line 570: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE

566:
567: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)
568: IS
569: SELECT HEAD.PRIMARY_FLAG
570: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE
571: WHERE NODE.PC_HEADER_ID = HEAD.PC_HEADER_ID AND
572: NODE.PC_NODE_ID = p_pc_node_id;
573:
574: BEGIN

Line 645: UPDATE ahl_pc_nodes_b

641: IF G_DEBUG='Y' THEN
642: AHL_DEBUG_PUB.debug('PCA -- PVT -- DETACH_PART for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);
643: END IF;
644:
645: UPDATE ahl_pc_nodes_b
646: SET child_count = NVL(child_count, 1) - 1
647: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
648: --ELSE
649: -- FND_MESSAGE.Set_Name('AHL','AHL_PC_PART_DEL_HAS_ASSOS');

Line 727: FROM ahl_pc_nodes_b

723:
724: CURSOR check_node_exists (p_pc_node_id IN NUMBER)
725: IS
726: SELECT 'X'
727: FROM ahl_pc_nodes_b
728: WHERE pc_node_id = p_pc_node_id;
729:
730: CURSOR get_pc_header_status (p_pc_node_id IN NUMBER)
731: IS

Line 733: from ahl_pc_headers_b header, ahl_pc_nodes_b node

729:
730: CURSOR get_pc_header_status (p_pc_node_id IN NUMBER)
731: IS
732: select header.status
733: from ahl_pc_headers_b header, ahl_pc_nodes_b node
734: where header.pc_header_id = node.pc_header_id and
735: node.pc_node_id = p_pc_node_id;
736:
737: CURSOR check_draft_version_exists (p_pc_node_id IN NUMBER)

Line 740: from ahl_pc_headers_b header, ahl_pc_nodes_b node

736:
737: CURSOR check_draft_version_exists (p_pc_node_id IN NUMBER)
738: IS
739: select 'X'
740: from ahl_pc_headers_b header, ahl_pc_nodes_b node
741: where header.pc_header_id = node.pc_header_id and
742: nvl(node.link_to_node_id,node.pc_node_id) = p_pc_node_id and
743: header.status in ('DRAFT', 'APPROVAL_REJECTED');
744:

Line 921: from ahl_pc_headers_b head, ahl_pc_nodes_b node

917:
918: CURSOR get_pc_header_status (p_pc_node_id IN NUMBER)
919: IS
920: select head.status
921: from ahl_pc_headers_b head, ahl_pc_nodes_b node
922: where head.pc_header_id = node.pc_header_id and
923: node.pc_node_id = p_pc_node_id;
924:
925: l_pc_status VARCHAR2(30) := 'DRAFT';

Line 940: from ahl_pc_nodes_b

936: update ahl_pc_headers_b
937: set status = 'DRAFT'
938: where pc_header_id = (
939: select pc_header_id
940: from ahl_pc_nodes_b
941: where pc_node_id = p_pc_node_id );
942: END IF;
943:
944: EXCEPTION

Line 981: from ahl_pc_headers_b head, ahl_pc_nodes_b node

977:
978: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)
979: IS
980: select head.primary_flag
981: from ahl_pc_headers_b head, ahl_pc_nodes_b node
982: where node.pc_node_id = p_pc_node_id and
983: node.pc_header_id = head.pc_header_id;
984:
985: CURSOR check_unit_item_exists (p_unit_item_id IN NUMBER, p_pc_node_id IN NUMBER)

Line 988: from ahl_pc_associations ahass, ahl_pc_nodes_b node, ahl_pc_headers_b header

984:
985: CURSOR check_unit_item_exists (p_unit_item_id IN NUMBER, p_pc_node_id IN NUMBER)
986: IS
987: select 'X'
988: from ahl_pc_associations ahass, ahl_pc_nodes_b node, ahl_pc_headers_b header
989: where ahass.unit_item_id = p_unit_item_id and
990: ahass.pc_node_id = node.pc_node_id and
991: node.pc_header_id = header.pc_header_id and
992: header.pc_header_id = (

Line 994: from ahl_pc_nodes_b

990: ahass.pc_node_id = node.pc_node_id and
991: node.pc_header_id = header.pc_header_id and
992: header.pc_header_id = (
993: select pc_header_id
994: from ahl_pc_nodes_b
995: where pc_node_id = p_pc_node_id );
996:
997: CURSOR check_unit_item_at_same_level (p_unit_item_id IN NUMBER, p_pc_node_id IN NUMBER)
998: IS

Line 1000: from ahl_pc_associations ahass, ahl_pc_nodes_b node

996:
997: CURSOR check_unit_item_at_same_level (p_unit_item_id IN NUMBER, p_pc_node_id IN NUMBER)
998: IS
999: select 'X'
1000: from ahl_pc_associations ahass, ahl_pc_nodes_b node
1001: where ahass.unit_item_id = p_unit_item_id and
1002: ahass.pc_node_id = node.pc_node_id and
1003: node.pc_node_id = p_pc_node_id;
1004:

Line 1020: -- ahl_pc_nodes_vl to ahl_pc_nodes_b

1016:
1017: -- Bug 4913773
1018: -- Modified References to Base tables in Cursor get_pc_header_status below
1019: -- ahl_pc_headers_vl to ahl_pc_headers_b
1020: -- ahl_pc_nodes_vl to ahl_pc_nodes_b
1021: CURSOR get_pc_header_status (p_pc_node_id IN NUMBER)
1022: IS
1023: select header.status
1024: from ahl_pc_headers_b header, ahl_pc_nodes_b node

Line 1024: from ahl_pc_headers_b header, ahl_pc_nodes_b node

1020: -- ahl_pc_nodes_vl to ahl_pc_nodes_b
1021: CURSOR get_pc_header_status (p_pc_node_id IN NUMBER)
1022: IS
1023: select header.status
1024: from ahl_pc_headers_b header, ahl_pc_nodes_b node
1025: where header.pc_header_id = node.pc_header_id and
1026: node.pc_node_id = p_pc_node_id;
1027:
1028: CURSOR check_child_node_exists (p_pc_node_id IN NUMBER)

Line 1031: from ahl_pc_nodes_b

1027:
1028: CURSOR check_child_node_exists (p_pc_node_id IN NUMBER)
1029: IS
1030: select 'X'
1031: from ahl_pc_nodes_b
1032: where parent_node_id = p_pc_node_id;
1033:
1034: CURSOR check_unit_valid (p_unit_item_id IN NUMBER)
1035: IS