APPS.AHL_PC_ASSOCIATION_PVT dependencies on AHL_PC_HEADERS_B

Line 229: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE

225:
226: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)
227: IS
228: SELECT HEAD.PRIMARY_FLAG
229: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE
230: WHERE NODE.PC_HEADER_ID = HEAD.PC_HEADER_ID AND
231: NODE.PC_NODE_ID = p_pc_node_id;
232:
233: BEGIN

Line 570: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE

566:
567: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)
568: IS
569: SELECT HEAD.PRIMARY_FLAG
570: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE
571: WHERE NODE.PC_HEADER_ID = HEAD.PC_HEADER_ID AND
572: NODE.PC_NODE_ID = p_pc_node_id;
573:
574: BEGIN

Line 733: from ahl_pc_headers_b header, ahl_pc_nodes_b node

729:
730: CURSOR get_pc_header_status (p_pc_node_id IN NUMBER)
731: IS
732: select header.status
733: from ahl_pc_headers_b header, ahl_pc_nodes_b node
734: where header.pc_header_id = node.pc_header_id and
735: node.pc_node_id = p_pc_node_id;
736:
737: CURSOR check_draft_version_exists (p_pc_node_id IN NUMBER)

Line 740: from ahl_pc_headers_b header, ahl_pc_nodes_b node

736:
737: CURSOR check_draft_version_exists (p_pc_node_id IN NUMBER)
738: IS
739: select 'X'
740: from ahl_pc_headers_b header, ahl_pc_nodes_b node
741: where header.pc_header_id = node.pc_header_id and
742: nvl(node.link_to_node_id,node.pc_node_id) = p_pc_node_id and
743: header.status in ('DRAFT', 'APPROVAL_REJECTED');
744:

Line 921: from ahl_pc_headers_b head, ahl_pc_nodes_b node

917:
918: CURSOR get_pc_header_status (p_pc_node_id IN NUMBER)
919: IS
920: select head.status
921: from ahl_pc_headers_b head, ahl_pc_nodes_b node
922: where head.pc_header_id = node.pc_header_id and
923: node.pc_node_id = p_pc_node_id;
924:
925: l_pc_status VARCHAR2(30) := 'DRAFT';

Line 936: update ahl_pc_headers_b

932:
933: IF (l_pc_status = 'APPROVAL_REJECTED')
934: THEN
935: -- Force updation of PC status; No check of header version number sanity
936: update ahl_pc_headers_b
937: set status = 'DRAFT'
938: where pc_header_id = (
939: select pc_header_id
940: from ahl_pc_nodes_b

Line 981: from ahl_pc_headers_b head, ahl_pc_nodes_b node

977:
978: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)
979: IS
980: select head.primary_flag
981: from ahl_pc_headers_b head, ahl_pc_nodes_b node
982: where node.pc_node_id = p_pc_node_id and
983: node.pc_header_id = head.pc_header_id;
984:
985: CURSOR check_unit_item_exists (p_unit_item_id IN NUMBER, p_pc_node_id IN NUMBER)

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 1019: -- ahl_pc_headers_vl to ahl_pc_headers_b

1015: where inventory_item_id = p_unit_item_id;
1016:
1017: -- Bug 4913773
1018: -- Modified References to Base tables in Cursor get_pc_header_status below
1019: -- ahl_pc_headers_vl to ahl_pc_headers_b
1020: -- ahl_pc_nodes_vl to ahl_pc_nodes_b
1021: CURSOR get_pc_header_status (p_pc_node_id IN NUMBER)
1022: IS
1023: select header.status

Line 1024: from ahl_pc_headers_b header, ahl_pc_nodes_b node

1020: -- ahl_pc_nodes_vl to ahl_pc_nodes_b
1021: CURSOR get_pc_header_status (p_pc_node_id IN NUMBER)
1022: IS
1023: select header.status
1024: from ahl_pc_headers_b header, ahl_pc_nodes_b node
1025: where header.pc_header_id = node.pc_header_id and
1026: node.pc_node_id = p_pc_node_id;
1027:
1028: CURSOR check_child_node_exists (p_pc_node_id IN NUMBER)