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 925: from ahl_pc_headers_b head, ahl_pc_nodes_b node

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

Line 940: update ahl_pc_headers_b

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

Line 985: from ahl_pc_headers_b head, ahl_pc_nodes_b node

981:
982: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)
983: IS
984: select head.primary_flag
985: from ahl_pc_headers_b head, ahl_pc_nodes_b node
986: where node.pc_node_id = p_pc_node_id and
987: node.pc_header_id = head.pc_header_id;
988:
989: CURSOR check_unit_item_exists (p_unit_item_id IN NUMBER, p_pc_node_id IN NUMBER)

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

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

Line 1028: from ahl_pc_headers_b header, ahl_pc_nodes_b node

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