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 925: from ahl_pc_headers_b head, ahl_pc_nodes_b node

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

Line 944: from ahl_pc_nodes_b

940: update ahl_pc_headers_b
941: set status = 'DRAFT'
942: where pc_header_id = (
943: select pc_header_id
944: from ahl_pc_nodes_b
945: where pc_node_id = p_pc_node_id );
946: END IF;
947:
948: EXCEPTION

Line 985: from ahl_pc_headers_b head, ahl_pc_nodes_b node

981:
982: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)
983: IS
984: select head.primary_flag
985: from ahl_pc_headers_b head, ahl_pc_nodes_b node
986: where node.pc_node_id = p_pc_node_id and
987: node.pc_header_id = head.pc_header_id;
988:
989: CURSOR check_unit_item_exists (p_unit_item_id IN NUMBER, p_pc_node_id IN NUMBER)

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

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

Line 998: from ahl_pc_nodes_b

994: ahass.pc_node_id = node.pc_node_id and
995: node.pc_header_id = header.pc_header_id and
996: header.pc_header_id = (
997: select pc_header_id
998: from ahl_pc_nodes_b
999: where pc_node_id = p_pc_node_id );
1000:
1001: CURSOR check_unit_item_at_same_level (p_unit_item_id IN NUMBER, p_pc_node_id IN NUMBER)
1002: IS

Line 1004: from ahl_pc_associations ahass, ahl_pc_nodes_b node

1000:
1001: CURSOR check_unit_item_at_same_level (p_unit_item_id IN NUMBER, p_pc_node_id IN NUMBER)
1002: IS
1003: select 'X'
1004: from ahl_pc_associations ahass, ahl_pc_nodes_b node
1005: where ahass.unit_item_id = p_unit_item_id and
1006: ahass.pc_node_id = node.pc_node_id and
1007: node.pc_node_id = p_pc_node_id;
1008:

Line 1024: -- ahl_pc_nodes_vl to ahl_pc_nodes_b

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

Line 1028: from ahl_pc_headers_b header, ahl_pc_nodes_b node

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

Line 1035: from ahl_pc_nodes_b

1031:
1032: CURSOR check_child_node_exists (p_pc_node_id IN NUMBER)
1033: IS
1034: select 'X'
1035: from ahl_pc_nodes_b
1036: where parent_node_id = p_pc_node_id;
1037:
1038: CURSOR check_unit_valid (p_unit_item_id IN NUMBER)
1039: IS