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.

[Home] [Help]

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 969: from ahl_pc_associations

965:
966: CURSOR get_node_object_version (p_pc_assos_id IN NUMBER)
967: IS
968: select object_version_number
969: from ahl_pc_associations
970: where pc_association_id = p_pc_assos_id;
971:
972: CURSOR check_id_exists_in_PC (p_pc_assos_id IN NUMBER)
973: IS

Line 975: from ahl_pc_associations

971:
972: CURSOR check_id_exists_in_PC (p_pc_assos_id IN NUMBER)
973: IS
974: select 'X'
975: from ahl_pc_associations
976: where pc_association_id = p_pc_assos_id;
977:
978: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)
979: IS

Line 988: from ahl_pc_associations ahass, ahl_pc_nodes_b node, ahl_pc_headers_b header

984:
985: CURSOR check_unit_item_exists (p_unit_item_id IN NUMBER, p_pc_node_id IN NUMBER)
986: IS
987: select 'X'
988: from ahl_pc_associations ahass, ahl_pc_nodes_b node, ahl_pc_headers_b header
989: where ahass.unit_item_id = p_unit_item_id and
990: ahass.pc_node_id = node.pc_node_id and
991: node.pc_header_id = header.pc_header_id and
992: header.pc_header_id = (

Line 1000: from ahl_pc_associations ahass, ahl_pc_nodes_b node

996:
997: CURSOR check_unit_item_at_same_level (p_unit_item_id IN NUMBER, p_pc_node_id IN NUMBER)
998: IS
999: select 'X'
1000: from ahl_pc_associations ahass, ahl_pc_nodes_b node
1001: where ahass.unit_item_id = p_unit_item_id and
1002: ahass.pc_node_id = node.pc_node_id and
1003: node.pc_node_id = p_pc_node_id;
1004: