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 511: FROM AHL_PC_NODES_B

507:
508: CURSOR delete_node (p_pc_header_id varchar2)
509: IS
510: SELECT PC_NODE_ID
511: FROM AHL_PC_NODES_B
512: WHERE PC_HEADER_ID = p_pc_header_id AND
513: PARENT_NODE_ID = 0;
514:
515: CURSOR delete_linked_header (p_pc_header_id varchar2)

Line 641: FROM ahl_pc_nodes_b

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

Line 651: FROM ahl_pc_nodes_b

647: BULK COLLECT INTO l_assos_tbl
648: FROM ahl_pc_associations ahass
649: WHERE pc_node_id IN (
650: SELECT pc_node_id
651: FROM ahl_pc_nodes_b
652: WHERE pc_header_id = l_link_to_header_id
653: CONNECT BY parent_node_id = PRIOR pc_node_id
654: START WITH pc_node_id = l_node_id
655: );

Line 664: UPDATE AHL_PC_NODES_B

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

Line 851: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER

847: AHS.ATTRIBUTE14,
848: AHS.ATTRIBUTE15
849: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
850: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
851: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
852: WHERE p_copy_assos_flag = 'Y'
853: AND NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID
854: AND NODE.PC_NODE_ID = AHS.PC_NODE_ID
855: AND HEADER.PC_HEADER_ID = p_header_id

Line 910: FROM AHL_PC_NODES_B

906:
907: CURSOR node_test(p_node_id IN VARCHAR2)
908: IS
909: SELECT 'x'
910: FROM AHL_PC_NODES_B
911: WHERE pc_node_id = p_node_id;
912:
913: CURSOR check_name_unique(p_pc_name IN VARCHAR2)
914: IS

Line 1535: AHL_PC_NODES_B NODE

1531: NODE_TYPE IN (G_PART, G_UNIT);
1532: */
1533: SELECT 'X'
1534: FROM AHL_PC_ASSOCIATIONS AHS,
1535: AHL_PC_NODES_B NODE
1536: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
1537: AND NODE.PC_HEADER_ID = p_header_id;
1538:
1539: l_dummy VARCHAR2(30);

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

1589:
1590: CURSOR get_dup_assos (p_pc_header_id IN NUMBER)
1591: IS
1592: select ahass.unit_item_id, count(ahass.pc_node_id)
1593: from ahl_pc_headers_b head, ahl_pc_nodes_b node, ahl_pc_associations ahass
1594: where ahass.pc_node_id = node.pc_node_id and
1595: node.pc_header_id = head.pc_header_id and
1596: head.pc_header_id = p_pc_header_id
1597: group by ahass.unit_item_id

Line 1634: FROM AHL_PC_NODES_B

1630: END IF;
1631:
1632: SELECT PC_NODE_ID
1633: BULK COLLECT INTO l_node_tbl
1634: FROM AHL_PC_NODES_B
1635: WHERE PC_HEADER_ID = p_pc_header_id
1636: ORDER BY PC_NODE_ID DESC;
1637:
1638: IF (l_node_tbl.COUNT > 0)

Line 1794: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER

1790: AHS.ATTRIBUTE14,
1791: AHS.ATTRIBUTE15
1792: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
1793: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
1794: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
1795: WHERE NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID
1796: AND NODE.PC_NODE_ID = AHS.PC_NODE_ID
1797: AND HEADER.PC_HEADER_ID = p_header_id
1798: AND UNIT.UNIT_CONFIG_HEADER_ID(+) = AHS.UNIT_ITEM_ID

Line 1927: UPDATE AHL_PC_NODES_B

1923: l_node_rec.ATTRIBUTE13 := l_node_data_rec.ATTRIBUTE13;
1924: l_node_rec.ATTRIBUTE14 := l_node_data_rec.ATTRIBUTE14;
1925: l_node_rec.ATTRIBUTE15 := l_node_data_rec.ATTRIBUTE15;
1926:
1927: UPDATE AHL_PC_NODES_B
1928: SET DRAFT_FLAG = 'Y'
1929: WHERE PC_NODE_ID = l_node_data_rec.PC_NODE_ID;
1930:
1931: END IF;

Line 2182: from ahl_pc_nodes_b

2178:
2179: CURSOR get_linked_node_id (p_pc_node_id IN NUMBER)
2180: IS
2181: select link_to_node_id
2182: from ahl_pc_nodes_b
2183: where pc_node_id = p_pc_node_id;
2184:
2185: BEGIN
2186:

Line 2229: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE

2225:
2226: CURSOR get_pc_details (p_pc_node_id IN NUMBER)
2227: IS
2228: SELECT HEAD.PRIMARY_FLAG, HEAD.ASSOCIATION_TYPE_FLAG
2229: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE
2230: WHERE NODE.PC_HEADER_ID = HEAD.PC_HEADER_ID AND
2231: NODE.PC_NODE_ID = p_pc_node_id;
2232:
2233: BEGIN

Line 2241: FROM ahl_pc_nodes_b

2237: THEN
2238: BEGIN
2239:
2240: SELECT pc_node_id INTO l_node_id
2241: FROM ahl_pc_nodes_b
2242: WHERE pc_header_id = p_x_node_rec.pc_header_id and
2243: parent_node_id = 0;
2244:
2245: EXCEPTION

Line 2274: FROM ahl_pc_nodes_b

2270:
2271: SELECT pc_node_id
2272: BULK COLLECT
2273: INTO l_node_tbl
2274: FROM ahl_pc_nodes_b
2275: WHERE pc_header_id = p_x_node_rec.pc_header_id
2276: CONNECT BY parent_node_id = PRIOR pc_node_id
2277: START WITH pc_node_id = l_node_id
2278: ORDER BY pc_node_id DESC;

Line 2289: FROM ahl_pc_nodes_b

2285: BULK COLLECT INTO l_assos_tbl
2286: FROM ahl_pc_associations ahass
2287: WHERE pc_node_id IN (
2288: SELECT pc_node_id
2289: FROM ahl_pc_nodes_b
2290: WHERE pc_header_id = p_x_node_rec.pc_header_id
2291: CONNECT BY parent_node_id = PRIOR pc_node_id
2292: START WITH pc_node_id = l_node_id
2293: );

Line 2350: UPDATE ahl_pc_nodes_b

2346: END IF;
2347:
2348: IF ((l_node_tbl.COUNT > 0) AND (p_x_node_rec.pc_node_id IS NOT NULL))
2349: THEN
2350: UPDATE ahl_pc_nodes_b
2351: SET child_count = NVL(child_count,1) - 1
2352: WHERE pc_node_id = p_x_node_rec.parent_node_id;
2353: END IF;
2354:

Line 2374: UPDATE ahl_pc_nodes_b

2370: IF G_DEBUG='Y' THEN
2371: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_UNIT_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);
2372: END IF;
2373:
2374: UPDATE ahl_pc_nodes_b
2375: SET child_count = NVL(child_count, 1) - 1
2376: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
2377:
2378: END DETACH_UNIT_REMOVE_LINK;

Line 2395: UPDATE ahl_pc_nodes_b

2391: IF G_DEBUG='Y' THEN
2392: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_ITEM_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);
2393: END IF;
2394:
2395: UPDATE ahl_pc_nodes_b
2396: SET child_count = NVL(child_count, 1) - 1
2397: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
2398:
2399: END DETACH_ITEM_REMOVE_LINK;

Line 2437: FROM AHL_PC_NODES_B NODE

2433: -- PARENT NODE ID IS NOT IN THE LIST OF NEWLY ATTACHED NODES
2434: TREE.PARENT_NODE_ID NOT IN
2435: (
2436: SELECT NODE.PC_NODE_ID
2437: FROM AHL_PC_NODES_B NODE
2438: WHERE NODE.PC_NODE_ID = TREE.PARENT_NODE_ID AND
2439: NODE.LINK_TO_NODE_ID = 0
2440: )
2441: )

Line 2507: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER

2503: AHS.ATTRIBUTE14,
2504: AHS.ATTRIBUTE15
2505: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2506: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2507: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2508: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2509: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID
2510: AND NODE.PC_HEADER_ID = p_header_id
2511: AND UNIT.UNIT_CONFIG_HEADER_ID(+) = AHS.UNIT_ITEM_ID

Line 2532: FROM AHL_PC_NODES_B NODE

2528: -- PARENT NODE ID IS NOT IN THE LIST OF NEWLY ATTACHED NODES
2529: NOT EXISTS
2530: (
2531: SELECT 'X'
2532: FROM AHL_PC_NODES_B NODE
2533: WHERE NODE.PC_NODE_ID = TREE.PARENT_NODE_ID AND
2534: NODE.LINK_TO_NODE_ID = 0
2535: )
2536: );

Line 2596: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER

2592: AHS.UNIT_ITEM_ID,
2593: AHS.INVENTORY_ORG_ID
2594: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2595: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2596: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2597: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2598: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID
2599: AND UNIT.UNIT_CONFIG_HEADER_ID(+) = AHS.UNIT_ITEM_ID
2600: AND UNIT.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID(+)

Line 2624: FROM AHL_PC_ASSOCIATIONS ASSOC,AHL_PC_NODES_B NODE

2620: -- if all other conditions are met. Hence changing this into a union
2621: -- of two queries
2622: /*
2623: SELECT 'X'
2624: FROM AHL_PC_ASSOCIATIONS ASSOC,AHL_PC_NODES_B NODE
2625: WHERE NODE.PC_HEADER_ID = p_header_id
2626: AND (
2627: (TREE.NODE_TYPE = 'N' AND
2628: TREE.PC_NODE_ID = NODE.LINK_TO_NODE_ID)

Line 2636: FROM AHL_PC_NODES_B NODE

2632: TREE.PC_NODE_ID = ASSOC.LINK_TO_ASSOCIATION_ID)
2633: )
2634: */
2635: SELECT 'X'
2636: FROM AHL_PC_NODES_B NODE
2637: WHERE NODE.PC_HEADER_ID = p_header_id
2638: AND TREE.NODE_TYPE = 'N'
2639: AND TREE.PC_NODE_ID = NODE.LINK_TO_NODE_ID
2640: UNION ALL

Line 2642: FROM AHL_PC_NODES_B NODE, AHL_PC_ASSOCIATIONS ASSOC

2638: AND TREE.NODE_TYPE = 'N'
2639: AND TREE.PC_NODE_ID = NODE.LINK_TO_NODE_ID
2640: UNION ALL
2641: SELECT 'X'
2642: FROM AHL_PC_NODES_B NODE, AHL_PC_ASSOCIATIONS ASSOC
2643: WHERE NODE.PC_HEADER_ID = p_header_id
2644: AND TREE.NODE_TYPE IN ('I', 'U')
2645: AND ASSOC.PC_NODE_ID = NODE.PC_NODE_ID
2646: AND TREE.PC_NODE_ID = ASSOC.LINK_TO_ASSOCIATION_ID

Line 2657: FROM AHL_PC_NODES_B NODE

2653: -- AS IF PARENT IS BEING DELETED THE CHILD WILL AUTOMATICALLY GETS DELETED
2654: EXISTS
2655: (
2656: SELECT 'X'
2657: FROM AHL_PC_NODES_B NODE
2658: WHERE NODE.PC_HEADER_ID = p_header_id
2659: AND TREE.PARENT_NODE_ID = NODE.LINK_TO_NODE_ID
2660: )
2661: )

Line 2668: FROM ahl_pc_nodes_b

2664: CURSOR detach_associations(p_header_id in number, p_link_header_id in number)
2665: IS
2666: SELECT * FROM ahl_pc_associations
2667: WHERE pc_node_id in ( SELECT PC_NODE_ID
2668: FROM ahl_pc_nodes_b
2669: WHERE PC_HEADER_ID = p_link_header_id)
2670: AND pc_association_id NOT IN (
2671: SELECT LINK_TO_ASSOCIATION_ID
2672: FROM ahl_pc_associations

Line 2674: FROM ahl_pc_nodes_b

2670: AND pc_association_id NOT IN (
2671: SELECT LINK_TO_ASSOCIATION_ID
2672: FROM ahl_pc_associations
2673: WHERE pc_node_id IN ( SELECT PC_NODE_ID
2674: FROM ahl_pc_nodes_b
2675: WHERE PC_HEADER_ID = p_header_id));
2676:
2677:
2678: CURSOR delete_header(p_link_header_id in number)

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

2684:
2685: CURSOR get_mr_for_pc (c_pc_header_id number)
2686: IS
2687: select mrh.mr_header_id, mrh.title, mrh.version_number
2688: from ahl_mr_headers_app_v mrh, ahl_mr_effectivities mre, ahl_pc_nodes_b pcn
2689: where trunc(sysdate) < trunc(nvl(mrh.effective_to, sysdate+1)) and
2690: mrh.mr_header_id = mre.mr_header_id and
2691: mre.pc_node_id = pcn.pc_node_id and
2692: pcn.pc_header_id = c_pc_header_id;

Line 2695: from ahl_mr_pc_nodes_v fmp, ahl_pc_nodes_b node

2691: mre.pc_node_id = pcn.pc_node_id and
2692: pcn.pc_header_id = c_pc_header_id;
2693: /* Commented following code to optimize
2694: select fmp.mr_header_id, fmp.title, fmp.version_number
2695: from ahl_mr_pc_nodes_v fmp, ahl_pc_nodes_b node
2696: where fmp.pc_node_id = node.pc_node_id and
2697: node.pc_header_id = c_pc_header_id;
2698: */
2699:

Line 2707: ahl_pc_nodes_b pcn

2703: -- AJPRASAN:: Bug #9596384 : Removed the comment to enable cursor definition
2704: CURSOR get_mr_for_pc_csr (p_pc_header_id NUMBER) IS
2705: SELECT mrh.mr_header_id, mre.mr_effectivity_id
2706: FROM ahl_mr_headers_b mrh, ahl_mr_effectivities mre,
2707: ahl_pc_nodes_b pcn
2708: WHERE mrh.mr_header_id = mre.mr_header_id
2709: AND mre.pc_node_id = pcn.pc_node_id
2710: AND pcn.pc_header_id = p_pc_header_id
2711: AND TRUNC(NVL(mrh.effective_to, SYSDATE+1)) > TRUNC(SYSDATE);

Line 3072: FROM AHL_PC_NODES_B

3068: l_node_rec.ATTRIBUTE14 := l_node_data_rec.ATTRIBUTE14;
3069: l_node_rec.ATTRIBUTE15 := l_node_data_rec.ATTRIBUTE15;
3070:
3071: SELECT OBJECT_VERSION_NUMBER INTO l_node_rec.OBJECT_VERSION_NUMBER
3072: FROM AHL_PC_NODES_B
3073: WHERE PC_NODE_ID = l_node_rec.PC_NODE_ID;
3074:
3075: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

Line 3272: FROM ahl_pc_nodes_b

3268: link_to_node_id
3269: BULK COLLECT INTO
3270: l_draft_nodeId_tbl,
3271: l_comp_nodeId_tbl
3272: FROM ahl_pc_nodes_b
3273: WHERE PC_HEADER_ID = l_pc_header_rec.pc_header_id
3274: AND NVL(LINK_TO_NODE_ID,0) <> 0
3275: START WITH PARENT_NODE_ID = 0
3276: CONNECT BY PRIOR PC_NODE_ID = PARENT_NODE_ID;

Line 3555: AHL_PC_NODES_B NODE

3551: NODE_TYPE IN (G_PART, G_UNIT);
3552: */
3553: SELECT 'X'
3554: FROM AHL_PC_ASSOCIATIONS AHS,
3555: AHL_PC_NODES_B NODE
3556: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
3557: AND NODE.PC_HEADER_ID = p_pc_header_id;
3558:
3559: l_dummy VARCHAR2(30);

Line 3632: AHL_PC_NODES_B NODE

3628: NODE_TYPE IN (G_PART, G_UNIT);
3629: */
3630: SELECT 'X'
3631: FROM AHL_PC_ASSOCIATIONS AHS,
3632: AHL_PC_NODES_B NODE
3633: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
3634: AND NODE.PC_HEADER_ID = p_header_id;
3635:
3636: l_dummy BOOLEAN;