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_HEADERS_B

Line 161: SELECT AHL_PC_HEADERS_B_S.NEXTVAL INTO l_header_id FROM DUAL;

157: END IF;
158:
159: -- Insert Record into ahl_pc_header_headers,
160: -- call table handler insert record
161: SELECT AHL_PC_HEADERS_B_S.NEXTVAL INTO l_header_id FROM DUAL;
162:
163: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_LINK
164: THEN
165: l_link_id := p_x_pc_header_rec.LINK_TO_PC_ID;

Line 288: from ahl_pc_headers_b

284:
285: CURSOR is_pc_primary (p_pc_header_id IN NUMBER)
286: IS
287: select primary_flag
288: from ahl_pc_headers_b
289: where pc_header_id = p_pc_header_id;
290:
291: BEGIN
292:

Line 505: FROM AHL_PC_HEADERS_B

501:
502: CURSOR check_header_status (p_pc_header_id varchar2)
503: IS
504: SELECT STATUS
505: FROM AHL_PC_HEADERS_B
506: WHERE PC_HEADER_ID = p_pc_header_id;
507:
508: CURSOR delete_node (p_pc_header_id varchar2)
509: IS

Line 518: FROM AHL_PC_HEADERS_B

514:
515: CURSOR delete_linked_header (p_pc_header_id varchar2)
516: IS
517: SELECT LINK_TO_PC_ID
518: FROM AHL_PC_HEADERS_B
519: WHERE PC_HEADER_ID = p_pc_header_id;
520:
521: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PC_HEADER';
522: l_api_version CONSTANT NUMBER := 1.0;

Line 628: UPDATE AHL_PC_HEADERS_B

624: THEN
625: IF G_DEBUG='Y' THEN
626: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Done for Header ID='||l_link_to_header_id);
627: END IF;
628: UPDATE AHL_PC_HEADERS_B
629: SET DRAFT_FLAG='N'
630: WHERE PC_HEADER_ID = l_link_to_header_id;
631:
632: l_node_id := 0;

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 904: from ahl_pc_headers_b

900:
901: CURSOR is_pc_primary (p_pc_header_id IN NUMBER)
902: IS
903: select primary_flag
904: from ahl_pc_headers_b
905: where pc_header_id = p_pc_header_id;
906:
907: CURSOR node_test(p_node_id IN VARCHAR2)
908: IS

Line 916: FROM AHL_PC_HEADERS_B

912:
913: CURSOR check_name_unique(p_pc_name IN VARCHAR2)
914: IS
915: SELECT 'x'
916: FROM AHL_PC_HEADERS_B
917: WHERE NAME = p_pc_name;
918:
919:
920: BEGIN

Line 1324: FROM AHL_PC_HEADERS_B

1320:
1321: CURSOR get_pc_details(l_pc_header_id IN NUMBER, l_object_version_number IN NUMBER)
1322: IS
1323: SELECT STATUS, NAME
1324: FROM AHL_PC_HEADERS_B
1325: WHERE PC_HEADER_ID = l_pc_header_id AND
1326: OBJECT_VERSION_NUMBER = l_object_version_number;
1327:
1328:

Line 1392: UPDATE AHL_PC_HEADERS_B

1388: IF l_active = 'Y'
1389: THEN
1390: -- Update PC with new status, increase object_version_number
1391: l_object_version_number := p_x_pc_header_rec.OBJECT_VERSION_NUMBER + 1;
1392: UPDATE AHL_PC_HEADERS_B
1393: SET STATUS = 'APPROVAL_PENDING', OBJECT_VERSION_NUMBER = l_object_version_number
1394: WHERE PC_HEADER_ID = p_x_pc_header_rec.PC_HEADER_ID AND
1395: OBJECT_VERSION_NUMBER = p_x_pc_header_rec.OBJECT_VERSION_NUMBER;
1396:

Line 1452: UPDATE AHL_PC_HEADERS_B

1448: END IF;
1449:
1450: l_object_version_number := p_x_pc_header_rec.OBJECT_VERSION_NUMBER + 1;
1451:
1452: UPDATE AHL_PC_HEADERS_B
1453: SET STATUS = 'COMPLETE',
1454: OBJECT_VERSION_NUMBER = l_object_version_number,
1455: LAST_UPDATE_DATE = SYSDATE,
1456: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 1508: FROM AHL_PC_HEADERS_B

1504:
1505: CURSOR check_name (p_name IN VARCHAR2, p_status IN VARCHAR2, p_pc_header_id IN NUMBER)
1506: IS
1507: SELECT 'X'
1508: FROM AHL_PC_HEADERS_B
1509: WHERE PC_HEADER_ID <> nvl(p_pc_header_id,0) AND
1510: -- UPPER(NAME) = UPPER(p_name) AND
1511: NAME = p_name AND
1512: --STATUS = p_status AND

Line 1518: FROM AHL_PC_HEADERS_B

1514:
1515: CURSOR check_prod_type (p_prod_type IN VARCHAR2, p_pc_header_id IN NUMBER)
1516: IS
1517: SELECT 'X'
1518: FROM AHL_PC_HEADERS_B
1519: WHERE PC_HEADER_ID <> p_pc_header_id AND
1520: PRIMARY_FLAG = 'Y' AND
1521: PRODUCT_TYPE_CODE like p_prod_type AND
1522: DRAFT_FLAG = 'N';

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 1696: FROM AHL_PC_HEADERS_B

1692:
1693: CURSOR copy_header_data(p_header_id IN NUMBER)
1694: IS
1695: SELECT *
1696: FROM AHL_PC_HEADERS_B
1697: WHERE PC_HEADER_ID = p_header_id;
1698:
1699: -- For Bug # 9486654 we split cursor copy_nodes_data in to two cursors
1700: -- Separately for nodes and units/parts as copy_nodes_data and copy_asso_data

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 1855: UPDATE AHL_PC_HEADERS_B

1851: IF G_DEBUG='Y' THEN
1852: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- Old Header ID='||l_old_header_id);
1853: END IF;
1854:
1855: UPDATE AHL_PC_HEADERS_B
1856: SET DRAFT_FLAG = 'Y'
1857: WHERE PC_HEADER_ID = l_old_header_id;
1858:
1859: p_x_pc_header_rec.LINK_TO_PC_ID := l_old_header_id;

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 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 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 2681: FROM AHL_PC_HEADERS_B

2677:
2678: CURSOR delete_header(p_link_header_id in number)
2679: IS
2680: SELECT 'X'
2681: FROM AHL_PC_HEADERS_B
2682: WHERE PC_HEADER_ID = p_link_header_id;
2683:
2684:
2685: CURSOR get_mr_for_pc (c_pc_header_id number)

Line 2868: FROM AHL_PC_HEADERS_B

2864: p_x_pc_header_rec.DRAFT_FLAG := 'N';
2865: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
2866:
2867: SELECT OBJECT_VERSION_NUMBER INTO p_x_pc_header_rec.OBJECT_VERSION_NUMBER
2868: FROM AHL_PC_HEADERS_B
2869: WHERE PC_HEADER_ID = l_pc_header_rec.LINK_TO_PC_ID;
2870:
2871: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2872: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

Line 3539: FROM AHL_PC_HEADERS_B

3535:
3536: CURSOR check_prod_type_changed (p_pc_header_id IN NUMBER, p_prod_type IN VARCHAR2, p_assos_type IN VARCHAR2)
3537: IS
3538: SELECT 'X'
3539: FROM AHL_PC_HEADERS_B
3540: WHERE PC_HEADER_ID = p_pc_header_id AND
3541: PRODUCT_TYPE_CODE = p_prod_type AND
3542: ASSOCIATION_TYPE_FLAG = p_assos_type;
3543:

Line 3612: FROM AHL_PC_HEADERS_B

3608: STATUS,
3609: PRIMARY_FLAG,
3610: ASSOCIATION_TYPE_FLAG,
3611: LINK_TO_PC_ID
3612: FROM AHL_PC_HEADERS_B
3613: WHERE PC_HEADER_ID = p_header_id;
3614:
3615: l_old_obj_ver_no NUMBER;
3616: l_old_prod_type_code VARCHAR2(30);