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_ASSOCIATIONS

Line 77: SELECT AHL_PC_ASSOCIATIONS_S.NEXTVAL INTO l_assos_id FROM DUAL;

73: THEN
74: l_link_id := p_x_assos_rec.LINK_TO_ASSOCIATION_ID;
75: END IF;
76:
77: SELECT AHL_PC_ASSOCIATIONS_S.NEXTVAL INTO l_assos_id FROM DUAL;
78:
79: INSERT INTO AHL_PC_ASSOCIATIONS (
80: PC_ASSOCIATION_ID,
81: PC_NODE_ID,

Line 79: INSERT INTO AHL_PC_ASSOCIATIONS (

75: END IF;
76:
77: SELECT AHL_PC_ASSOCIATIONS_S.NEXTVAL INTO l_assos_id FROM DUAL;
78:
79: INSERT INTO AHL_PC_ASSOCIATIONS (
80: PC_ASSOCIATION_ID,
81: PC_NODE_ID,
82: UNIT_ITEM_ID,
83: INVENTORY_ORG_ID,

Line 292: DELETE FROM AHL_PC_ASSOCIATIONS

288:
289: IF (l_ump_attached = FND_API.G_FALSE)
290: THEN
291: -- Knocking off units...
292: DELETE FROM AHL_PC_ASSOCIATIONS
293: WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;
294:
295: IF G_DEBUG='Y' THEN
296: AHL_DEBUG_PUB.debug('PCA -- PVT -- DETACH_UNIT for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);

Line 418: SELECT AHL_PC_ASSOCIATIONS_S.NEXTVAL INTO l_assos_id FROM DUAL;

414: l_link_id := p_x_assos_rec.LINK_TO_ASSOCIATION_ID;
415: END IF;
416:
417: -- API BODY here...
418: SELECT AHL_PC_ASSOCIATIONS_S.NEXTVAL INTO l_assos_id FROM DUAL;
419:
420: INSERT INTO AHL_PC_ASSOCIATIONS (
421: PC_ASSOCIATION_ID,
422: PC_NODE_ID,

Line 420: INSERT INTO AHL_PC_ASSOCIATIONS (

416:
417: -- API BODY here...
418: SELECT AHL_PC_ASSOCIATIONS_S.NEXTVAL INTO l_assos_id FROM DUAL;
419:
420: INSERT INTO AHL_PC_ASSOCIATIONS (
421: PC_ASSOCIATION_ID,
422: PC_NODE_ID,
423: UNIT_ITEM_ID,
424: INVENTORY_ORG_ID,

Line 638: DELETE FROM AHL_PC_ASSOCIATIONS

634: IF (l_ump_attached = FND_API.G_FALSE)
635: THEN
636: -- Knocking off items...
637:
638: DELETE FROM AHL_PC_ASSOCIATIONS
639: WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;
640:
641: IF G_DEBUG='Y' THEN
642: AHL_DEBUG_PUB.debug('PCA -- PVT -- DETACH_PART for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);

Line 973: from ahl_pc_associations

969:
970: CURSOR get_node_object_version (p_pc_assos_id IN NUMBER)
971: IS
972: select object_version_number
973: from ahl_pc_associations
974: where pc_association_id = p_pc_assos_id;
975:
976: CURSOR check_id_exists_in_PC (p_pc_assos_id IN NUMBER)
977: IS

Line 979: from ahl_pc_associations

975:
976: CURSOR check_id_exists_in_PC (p_pc_assos_id IN NUMBER)
977: IS
978: select 'X'
979: from ahl_pc_associations
980: where pc_association_id = p_pc_assos_id;
981:
982: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)
983: IS

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 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: