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

Line 90: SELECT AHL_PC_NODES_B_S.NEXTVAL INTO l_pc_node_id FROM DUAL;

86: THEN
87: l_link_id := p_x_node_rec.LINK_TO_NODE_ID;
88: END IF;
89:
90: SELECT AHL_PC_NODES_B_S.NEXTVAL INTO l_pc_node_id FROM DUAL;
91:
92: AHL_PC_NODES_PKG.INSERT_ROW
93: (
94: X_ROWID => l_row_id,

Line 134: UPDATE ahl_pc_nodes_b

130:
131:
132: IF (p_x_node_rec.pc_node_id IS NOT NULL)
133: THEN
134: UPDATE ahl_pc_nodes_b
135: SET child_count = NVL(child_count,0) + 1
136: WHERE pc_node_id = p_x_node_rec.parent_node_id;
137: END IF;
138:

Line 207: FROM AHL_PC_NODES_B node, AHL_PC_HEADERS_B head

203:
204: CURSOR pc_node_csr(p_pc_node_id IN NUMBER)
205: IS
206: SELECT node.OBJECT_VERSION_NUMBER, head.STATUS
207: FROM AHL_PC_NODES_B node, AHL_PC_HEADERS_B head
208: WHERE head.PC_HEADER_ID = node.PC_HEADER_ID and
209: node.PC_NODE_ID = p_pc_node_id and
210: node.DRAFT_FLAG = 'N';
211:

Line 286: FROM AHL_PC_NODES_B

282:
283: -- Retrieve link id for this node; this is non-updatable field for this package
284: SELECT LINK_TO_NODE_ID
285: INTO l_link_id
286: FROM AHL_PC_NODES_B
287: WHERE PC_NODE_ID = p_x_node_rec.pc_node_id;
288:
289: AHL_PC_NODES_PKG.UPDATE_ROW
290: (

Line 409: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE

405:
406: CURSOR get_pc_details (p_pc_node_id IN NUMBER)
407: IS
408: SELECT HEAD.PRIMARY_FLAG, HEAD.ASSOCIATION_TYPE_FLAG
409: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE
410: WHERE NODE.PC_HEADER_ID = HEAD.PC_HEADER_ID AND
411: NODE.PC_NODE_ID = p_pc_node_id;
412:
413: BEGIN

Line 446: FROM ahl_pc_nodes_b

442: THEN
443: BEGIN
444:
445: SELECT pc_node_id INTO l_node_id
446: FROM ahl_pc_nodes_b
447: WHERE pc_header_id = p_x_node_rec.pc_header_id and
448: parent_node_id = 0;
449:
450: EXCEPTION

Line 475: FROM ahl_pc_nodes_b

471:
472: SELECT pc_node_id
473: BULK COLLECT
474: INTO l_node_tbl
475: FROM ahl_pc_nodes_b
476: WHERE pc_header_id = p_x_node_rec.pc_header_id
477: CONNECT BY parent_node_id = PRIOR pc_node_id
478: START WITH pc_node_id = l_node_id
479: ORDER BY pc_node_id DESC;

Line 487: FROM ahl_pc_nodes_b

483: FROM ahl_pc_associations ahass
484: WHERE pc_node_id IN
485: (
486: SELECT pc_node_id
487: FROM ahl_pc_nodes_b
488: WHERE pc_header_id = p_x_node_rec.pc_header_id
489: CONNECT BY parent_node_id = PRIOR pc_node_id
490: START WITH pc_node_id = l_node_id
491: );

Line 513: FROM ahl_pc_nodes_b

509: mrh.mr_header_id = mre.mr_header_id and
510: mre.pc_node_id IN
511: (
512: SELECT pc_node_id
513: FROM ahl_pc_nodes_b
514: CONNECT BY parent_node_id = PRIOR pc_node_id
515: START WITH pc_node_id = l_linked_node_id
516: );
517:

Line 540: FROM ahl_pc_nodes_b

536: FROM ahl_mel_cdl_headers
537: WHERE pc_node_id IN
538: (
539: SELECT pc_node_id
540: FROM ahl_pc_nodes_b
541: CONNECT BY parent_node_id = PRIOR pc_node_id
542: START WITH pc_node_id = l_linked_node_id
543: );
544:

Line 580: FROM ahl_pc_nodes_b

576: FROM ahl_utilization_forecast_v
577: WHERE pc_node_id IN
578: (
579: SELECT pc_node_id
580: FROM ahl_pc_nodes_b
581: CONNECT BY parent_node_id = PRIOR pc_node_id
582: START WITH pc_node_id = l_linked_node_id
583: );
584:

Line 601: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node

597: BEGIN
598:
599: SELECT distinct 'X'
600: INTO l_exist
601: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node
602: WHERE uf.unit_config_header_id = assos.unit_item_id and
603: assos.pc_node_id = node.pc_node_id and
604: node.pc_node_id IN (
605: SELECT pc_node_id

Line 606: FROM ahl_pc_nodes_b

602: WHERE uf.unit_config_header_id = assos.unit_item_id and
603: assos.pc_node_id = node.pc_node_id and
604: node.pc_node_id IN (
605: SELECT pc_node_id
606: FROM ahl_pc_nodes_b
607: CONNECT BY parent_node_id = PRIOR pc_node_id
608: START WITH pc_node_id = l_linked_node_id
609: );
610:

Line 625: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node

621: BEGIN
622:
623: SELECT distinct 'X'
624: INTO l_exist
625: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node
626: WHERE uf.inventory_item_id = assos.unit_item_id and
627: uf.inventory_org_id = assos.inventory_org_id and
628: assos.pc_node_id = node.pc_node_id and
629: node.pc_node_id IN (

Line 631: FROM ahl_pc_nodes_b

627: uf.inventory_org_id = assos.inventory_org_id and
628: assos.pc_node_id = node.pc_node_id and
629: node.pc_node_id IN (
630: SELECT pc_node_id
631: FROM ahl_pc_nodes_b
632: CONNECT BY parent_node_id = PRIOR pc_node_id
633: START WITH pc_node_id = l_linked_node_id
634: );
635:

Line 736: UPDATE ahl_pc_nodes_b

732: END IF;
733:
734: IF ((l_node_tbl.COUNT > 0) AND (p_x_node_rec.pc_node_id IS NOT NULL))
735: THEN
736: UPDATE ahl_pc_nodes_b
737: SET child_count = NVL(child_count,1) - 1
738: WHERE pc_node_id = p_x_node_rec.parent_node_id;
739: END IF;
740:

Line 756: FROM ahl_pc_nodes_b

752: THEN
753:
754: SELECT name
755: INTO p_x_node_rec.name
756: FROM ahl_pc_nodes_b
757: WHERE pc_node_id = p_x_node_rec.pc_node_id;
758:
759: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_OPEN_NR');
760: FND_MESSAGE.Set_Token('PCN',p_x_node_rec.name);

Line 852: from ahl_pc_nodes_b

848:
849: CURSOR get_linked_node_id (p_pc_node_id IN NUMBER)
850: IS
851: select link_to_node_id
852: from ahl_pc_nodes_b
853: where pc_node_id = p_pc_node_id;
854:
855: BEGIN
856:

Line 897: from ahl_pc_nodes_b

893:
894: CURSOR check_id_exists (p_pc_header_id IN NUMBER, p_node_id IN NUMBER)
895: IS
896: select 'X'
897: from ahl_pc_nodes_b
898: where pc_node_id = p_node_id and
899: pc_header_id = p_pc_header_id;
900:
901: CURSOR check_parent_exists (p_pc_header_id IN NUMBER, p_parent_node_id IN NUMBER)

Line 904: from ahl_pc_nodes_b

900:
901: CURSOR check_parent_exists (p_pc_header_id IN NUMBER, p_parent_node_id IN NUMBER)
902: IS
903: select 'X'
904: from ahl_pc_nodes_b
905: where pc_node_id = p_parent_node_id and
906: pc_header_id = p_pc_header_id;
907:
908: CURSOR check_root_node_exists (p_pc_header_id IN NUMBER)

Line 911: from ahl_pc_nodes_b

907:
908: CURSOR check_root_node_exists (p_pc_header_id IN NUMBER)
909: IS
910: select 'X'
911: from ahl_pc_nodes_b
912: where pc_header_id = p_pc_header_id and
913: NVL(parent_node_id,0) = 0;
914:
915: CURSOR check_name_exists ( p_node_parent_id IN NUMBER, p_pc_node_id IN NUMBER, p_name IN VARCHAR2)

Line 918: from ahl_pc_nodes_b

914:
915: CURSOR check_name_exists ( p_node_parent_id IN NUMBER, p_pc_node_id IN NUMBER, p_name IN VARCHAR2)
916: IS
917: select 'X'
918: from ahl_pc_nodes_b
919: where name = p_name and
920: -- upper(name) = upper(p_name) and
921: parent_node_id = p_node_parent_id and
922: pc_node_id <> NVL(p_pc_node_id, 0) and

Line 935: from ahl_pc_nodes_b

931:
932: CURSOR get_node_object_version (p_pc_node_id IN NUMBER)
933: IS
934: select object_version_number
935: from ahl_pc_nodes_b
936: where pc_node_id = p_pc_node_id;
937:
938: CURSOR check_leaf_node (p_parent_node_id IN NUMBER)
939: IS

Line 941: from ahl_pc_nodes_b node, ahl_pc_associations ahass

937:
938: CURSOR check_leaf_node (p_parent_node_id IN NUMBER)
939: IS
940: select 'X'
941: from ahl_pc_nodes_b node, ahl_pc_associations ahass
942: where node.pc_node_id = p_parent_node_id and
943: ahass.pc_node_id = p_parent_node_id;
944:
945: BEGIN