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

Line 507: FROM AHL_PC_NODES_B

503:
504: CURSOR delete_node (p_pc_header_id varchar2)
505: IS
506: SELECT PC_NODE_ID
507: FROM AHL_PC_NODES_B
508: WHERE PC_HEADER_ID = p_pc_header_id AND
509: PARENT_NODE_ID = 0;
510:
511: CURSOR delete_linked_header (p_pc_header_id varchar2)

Line 637: FROM ahl_pc_nodes_b

633: IF (l_node_id <> 0)
634: THEN
635: SELECT pc_node_id
636: BULK COLLECT INTO l_node_tbl
637: FROM ahl_pc_nodes_b
638: WHERE pc_header_id = l_link_to_header_id
639: CONNECT BY parent_node_id = PRIOR pc_node_id
640: START WITH pc_node_id = l_node_id;
641:

Line 647: FROM ahl_pc_nodes_b

643: BULK COLLECT INTO l_assos_tbl
644: FROM ahl_pc_associations ahass
645: WHERE pc_node_id IN (
646: SELECT pc_node_id
647: FROM ahl_pc_nodes_b
648: WHERE pc_header_id = l_link_to_header_id
649: CONNECT BY parent_node_id = PRIOR pc_node_id
650: START WITH pc_node_id = l_node_id
651: );

Line 660: UPDATE AHL_PC_NODES_B

656: LOOP
657: IF G_DEBUG='Y' THEN
658: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Done for Node ID='||l_node_tbl(i));
659: END IF;
660: UPDATE AHL_PC_NODES_B
661: SET DRAFT_FLAG = 'N'
662: WHERE PC_NODE_ID = l_node_tbl(i);
663: END LOOP;
664: END IF;

Line 840: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER

836: AHS.ATTRIBUTE14,
837: AHS.ATTRIBUTE15
838: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
839: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
840: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
841: WHERE p_copy_assos_flag = 'Y'
842: AND NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID
843: AND NODE.PC_NODE_ID = AHS.PC_NODE_ID
844: AND HEADER.PC_HEADER_ID = p_header_id

Line 896: FROM AHL_PC_NODES_B

892:
893: CURSOR node_test(p_node_id IN VARCHAR2)
894: IS
895: SELECT 'x'
896: FROM AHL_PC_NODES_B
897: WHERE pc_node_id = p_node_id;
898:
899: CURSOR check_name_unique(p_pc_name IN VARCHAR2)
900: IS

Line 1457: AHL_PC_NODES_B NODE

1453: NODE_TYPE IN (G_PART, G_UNIT);
1454: */
1455: SELECT 'X'
1456: FROM AHL_PC_ASSOCIATIONS AHS,
1457: AHL_PC_NODES_B NODE
1458: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
1459: AND NODE.PC_HEADER_ID = p_header_id;
1460:
1461: l_dummy VARCHAR2(30);

Line 1515: from ahl_pc_headers_b head, ahl_pc_nodes_b node, ahl_pc_associations ahass

1511:
1512: CURSOR get_dup_assos (p_pc_header_id IN NUMBER)
1513: IS
1514: select ahass.unit_item_id, count(ahass.pc_node_id)
1515: from ahl_pc_headers_b head, ahl_pc_nodes_b node, ahl_pc_associations ahass
1516: where ahass.pc_node_id = node.pc_node_id and
1517: node.pc_header_id = head.pc_header_id and
1518: head.pc_header_id = p_pc_header_id
1519: group by ahass.unit_item_id

Line 1556: FROM AHL_PC_NODES_B

1552: END IF;
1553:
1554: SELECT PC_NODE_ID
1555: BULK COLLECT INTO l_node_tbl
1556: FROM AHL_PC_NODES_B
1557: WHERE PC_HEADER_ID = p_pc_header_id
1558: ORDER BY PC_NODE_ID DESC;
1559:
1560: IF (l_node_tbl.COUNT > 0)

Line 1710: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER

1706: AHS.ATTRIBUTE14,
1707: AHS.ATTRIBUTE15
1708: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
1709: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
1710: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
1711: WHERE NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID
1712: AND NODE.PC_NODE_ID = AHS.PC_NODE_ID
1713: AND HEADER.PC_HEADER_ID = p_header_id
1714: AND UNIT.UNIT_CONFIG_HEADER_ID(+) = AHS.UNIT_ITEM_ID

Line 1839: UPDATE AHL_PC_NODES_B

1835: l_node_rec.ATTRIBUTE13 := l_node_data_rec.ATTRIBUTE13;
1836: l_node_rec.ATTRIBUTE14 := l_node_data_rec.ATTRIBUTE14;
1837: l_node_rec.ATTRIBUTE15 := l_node_data_rec.ATTRIBUTE15;
1838:
1839: UPDATE AHL_PC_NODES_B
1840: SET DRAFT_FLAG = 'Y'
1841: WHERE PC_NODE_ID = l_node_data_rec.PC_NODE_ID;
1842:
1843: ELSIF l_node_data_rec.node_type IN (G_PART,G_UNIT)

Line 2028: from ahl_pc_nodes_b

2024:
2025: CURSOR get_linked_node_id (p_pc_node_id IN NUMBER)
2026: IS
2027: select link_to_node_id
2028: from ahl_pc_nodes_b
2029: where pc_node_id = p_pc_node_id;
2030:
2031: BEGIN
2032:

Line 2075: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE

2071:
2072: CURSOR get_pc_details (p_pc_node_id IN NUMBER)
2073: IS
2074: SELECT HEAD.PRIMARY_FLAG, HEAD.ASSOCIATION_TYPE_FLAG
2075: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE
2076: WHERE NODE.PC_HEADER_ID = HEAD.PC_HEADER_ID AND
2077: NODE.PC_NODE_ID = p_pc_node_id;
2078:
2079: BEGIN

Line 2087: FROM ahl_pc_nodes_b

2083: THEN
2084: BEGIN
2085:
2086: SELECT pc_node_id INTO l_node_id
2087: FROM ahl_pc_nodes_b
2088: WHERE pc_header_id = p_x_node_rec.pc_header_id and
2089: parent_node_id = 0;
2090:
2091: EXCEPTION

Line 2120: FROM ahl_pc_nodes_b

2116:
2117: SELECT pc_node_id
2118: BULK COLLECT
2119: INTO l_node_tbl
2120: FROM ahl_pc_nodes_b
2121: WHERE pc_header_id = p_x_node_rec.pc_header_id
2122: CONNECT BY parent_node_id = PRIOR pc_node_id
2123: START WITH pc_node_id = l_node_id
2124: ORDER BY pc_node_id DESC;

Line 2135: FROM ahl_pc_nodes_b

2131: BULK COLLECT INTO l_assos_tbl
2132: FROM ahl_pc_associations ahass
2133: WHERE pc_node_id IN (
2134: SELECT pc_node_id
2135: FROM ahl_pc_nodes_b
2136: WHERE pc_header_id = p_x_node_rec.pc_header_id
2137: CONNECT BY parent_node_id = PRIOR pc_node_id
2138: START WITH pc_node_id = l_node_id
2139: );

Line 2196: UPDATE ahl_pc_nodes_b

2192: END IF;
2193:
2194: IF ((l_node_tbl.COUNT > 0) AND (p_x_node_rec.pc_node_id IS NOT NULL))
2195: THEN
2196: UPDATE ahl_pc_nodes_b
2197: SET child_count = NVL(child_count,1) - 1
2198: WHERE pc_node_id = p_x_node_rec.parent_node_id;
2199: END IF;
2200:

Line 2220: UPDATE ahl_pc_nodes_b

2216: IF G_DEBUG='Y' THEN
2217: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_UNIT_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);
2218: END IF;
2219:
2220: UPDATE ahl_pc_nodes_b
2221: SET child_count = NVL(child_count, 1) - 1
2222: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
2223:
2224: END DETACH_UNIT_REMOVE_LINK;

Line 2241: UPDATE ahl_pc_nodes_b

2237: IF G_DEBUG='Y' THEN
2238: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_ITEM_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);
2239: END IF;
2240:
2241: UPDATE ahl_pc_nodes_b
2242: SET child_count = NVL(child_count, 1) - 1
2243: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
2244:
2245: END DETACH_ITEM_REMOVE_LINK;

Line 2279: FROM AHL_PC_NODES_B NODE

2275: -- PARENT NODE ID IS NOT IN THE LIST OF NEWLY ATTACHED NODES
2276: TREE.PARENT_NODE_ID NOT IN
2277: (
2278: SELECT NODE.PC_NODE_ID
2279: FROM AHL_PC_NODES_B NODE
2280: WHERE NODE.PC_NODE_ID = TREE.PARENT_NODE_ID AND
2281: NODE.LINK_TO_NODE_ID = 0
2282: )
2283: )

Line 2347: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER

2343: AHS.ATTRIBUTE14,
2344: AHS.ATTRIBUTE15
2345: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2346: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2347: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2348: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2349: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID
2350: AND NODE.PC_HEADER_ID = p_header_id
2351: AND UNIT.UNIT_CONFIG_HEADER_ID(+) = AHS.UNIT_ITEM_ID

Line 2374: FROM AHL_PC_NODES_B NODE

2370: -- PARENT NODE ID IS NOT IN THE LIST OF NEWLY ATTACHED NODES
2371: NOT EXISTS
2372: (
2373: SELECT 'X'
2374: FROM AHL_PC_NODES_B NODE
2375: WHERE NODE.PC_NODE_ID = TREE.PARENT_NODE_ID AND
2376: NODE.LINK_TO_NODE_ID = 0
2377: )
2378: )

Line 2440: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER

2436: AHS.UNIT_ITEM_ID,
2437: AHS.INVENTORY_ORG_ID
2438: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2439: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2440: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2441: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2442: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID
2443: AND UNIT.UNIT_CONFIG_HEADER_ID(+) = AHS.UNIT_ITEM_ID
2444: AND UNIT.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID(+)

Line 2468: FROM AHL_PC_ASSOCIATIONS ASSOC,AHL_PC_NODES_B NODE

2464: -- if all other conditions are met. Hence changing this into a union
2465: -- of two queries
2466: /*
2467: SELECT 'X'
2468: FROM AHL_PC_ASSOCIATIONS ASSOC,AHL_PC_NODES_B NODE
2469: WHERE NODE.PC_HEADER_ID = p_header_id
2470: AND (
2471: (TREE.NODE_TYPE = 'N' AND
2472: TREE.PC_NODE_ID = NODE.LINK_TO_NODE_ID)

Line 2480: FROM AHL_PC_NODES_B NODE

2476: TREE.PC_NODE_ID = ASSOC.LINK_TO_ASSOCIATION_ID)
2477: )
2478: */
2479: SELECT 'X'
2480: FROM AHL_PC_NODES_B NODE
2481: WHERE NODE.PC_HEADER_ID = p_header_id
2482: AND TREE.NODE_TYPE = 'N'
2483: AND TREE.PC_NODE_ID = NODE.LINK_TO_NODE_ID
2484: UNION ALL

Line 2486: FROM AHL_PC_NODES_B NODE, AHL_PC_ASSOCIATIONS ASSOC

2482: AND TREE.NODE_TYPE = 'N'
2483: AND TREE.PC_NODE_ID = NODE.LINK_TO_NODE_ID
2484: UNION ALL
2485: SELECT 'X'
2486: FROM AHL_PC_NODES_B NODE, AHL_PC_ASSOCIATIONS ASSOC
2487: WHERE NODE.PC_HEADER_ID = p_header_id
2488: AND TREE.NODE_TYPE IN ('I', 'U')
2489: AND ASSOC.PC_NODE_ID = NODE.PC_NODE_ID
2490: AND TREE.PC_NODE_ID = ASSOC.LINK_TO_ASSOCIATION_ID

Line 2501: FROM AHL_PC_NODES_B NODE

2497: -- AS IF PARENT IS BEING DELETED THE CHILD WILL AUTOMATICALLY GETS DELETED
2498: EXISTS
2499: (
2500: SELECT 'X'
2501: FROM AHL_PC_NODES_B NODE
2502: WHERE NODE.PC_HEADER_ID = p_header_id
2503: AND TREE.PARENT_NODE_ID = NODE.LINK_TO_NODE_ID
2504: )
2505: )

Line 2512: FROM ahl_pc_nodes_b

2508: CURSOR detach_associations(p_header_id in number, p_link_header_id in number)
2509: IS
2510: SELECT * FROM ahl_pc_associations
2511: WHERE pc_node_id in ( SELECT PC_NODE_ID
2512: FROM ahl_pc_nodes_b
2513: WHERE PC_HEADER_ID = p_link_header_id)
2514: AND pc_association_id NOT IN (
2515: SELECT LINK_TO_ASSOCIATION_ID
2516: FROM ahl_pc_associations

Line 2518: FROM ahl_pc_nodes_b

2514: AND pc_association_id NOT IN (
2515: SELECT LINK_TO_ASSOCIATION_ID
2516: FROM ahl_pc_associations
2517: WHERE pc_node_id IN ( SELECT PC_NODE_ID
2518: FROM ahl_pc_nodes_b
2519: WHERE PC_HEADER_ID = p_header_id));
2520:
2521:
2522: CURSOR delete_header(p_link_header_id in number)

Line 2532: from ahl_mr_headers_app_v mrh, ahl_mr_effectivities mre, ahl_pc_nodes_b pcn

2528:
2529: CURSOR get_mr_for_pc (c_pc_header_id number)
2530: IS
2531: select mrh.mr_header_id, mrh.title, mrh.version_number
2532: from ahl_mr_headers_app_v mrh, ahl_mr_effectivities mre, ahl_pc_nodes_b pcn
2533: where trunc(sysdate) < trunc(nvl(mrh.effective_to, sysdate+1)) and
2534: mrh.mr_header_id = mre.mr_header_id and
2535: mre.pc_node_id = pcn.pc_node_id and
2536: pcn.pc_header_id = c_pc_header_id;

Line 2539: from ahl_mr_pc_nodes_v fmp, ahl_pc_nodes_b node

2535: mre.pc_node_id = pcn.pc_node_id and
2536: pcn.pc_header_id = c_pc_header_id;
2537: /* Commented following code to optimize
2538: select fmp.mr_header_id, fmp.title, fmp.version_number
2539: from ahl_mr_pc_nodes_v fmp, ahl_pc_nodes_b node
2540: where fmp.pc_node_id = node.pc_node_id and
2541: node.pc_header_id = c_pc_header_id;
2542: */
2543:

Line 2549: ahl_pc_nodes_b pcn

2545: -- cursor to get all the applicable MRs for a given PC header id
2546: CURSOR get_mr_for_pc_csr (p_pc_header_id NUMBER) IS
2547: SELECT mrh.mr_header_id, mre.mr_effectivity_id
2548: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,
2549: ahl_pc_nodes_b pcn
2550: WHERE mrh.mr_header_id = mre.mr_header_id
2551: AND mre.pc_node_id = pcn.pc_node_id
2552: AND pcn.pc_header_id = p_pc_header_id
2553: AND TRUNC(NVL(mrh.effective_to, SYSDATE+1)) > TRUNC(SYSDATE);

Line 2905: FROM AHL_PC_NODES_B

2901: l_node_rec.ATTRIBUTE14 := l_node_data_rec.ATTRIBUTE14;
2902: l_node_rec.ATTRIBUTE15 := l_node_data_rec.ATTRIBUTE15;
2903:
2904: SELECT OBJECT_VERSION_NUMBER INTO l_node_rec.OBJECT_VERSION_NUMBER
2905: FROM AHL_PC_NODES_B
2906: WHERE PC_NODE_ID = l_node_rec.PC_NODE_ID;
2907:
2908: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

Line 3048: FROM ahl_pc_nodes_b

3044: link_to_node_id
3045: BULK COLLECT INTO
3046: l_draft_nodeId_tbl,
3047: l_comp_nodeId_tbl
3048: FROM ahl_pc_nodes_b
3049: WHERE PC_HEADER_ID = l_pc_header_rec.pc_header_id
3050: AND NVL(LINK_TO_NODE_ID,0) <> 0
3051: START WITH PARENT_NODE_ID = 0
3052: CONNECT BY PRIOR PC_NODE_ID = PARENT_NODE_ID;

Line 3322: AHL_PC_NODES_B NODE

3318: NODE_TYPE IN (G_PART, G_UNIT);
3319: */
3320: SELECT 'X'
3321: FROM AHL_PC_ASSOCIATIONS AHS,
3322: AHL_PC_NODES_B NODE
3323: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
3324: AND NODE.PC_HEADER_ID = p_pc_header_id;
3325:
3326: l_dummy VARCHAR2(30);

Line 3398: AHL_PC_NODES_B NODE

3394: NODE_TYPE IN (G_PART, G_UNIT);
3395: */
3396: SELECT 'X'
3397: FROM AHL_PC_ASSOCIATIONS AHS,
3398: AHL_PC_NODES_B NODE
3399: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
3400: AND NODE.PC_HEADER_ID = p_header_id;
3401:
3402: l_dummy BOOLEAN;