APPS.AHL_PC_NODE_PVT dependencies on AHL_PC_HEADERS_B

Line 207: FROM AHL_PC_NODES_B node, AHL_PC_HEADERS_B head

203:
204: CURSOR pc_node_csr(p_pc_node_id IN NUMBER)
205: IS
206: SELECT node.OBJECT_VERSION_NUMBER, head.STATUS
207: FROM AHL_PC_NODES_B node, AHL_PC_HEADERS_B head
208: WHERE head.PC_HEADER_ID = node.PC_HEADER_ID and
209: node.PC_NODE_ID = p_pc_node_id and
210: node.DRAFT_FLAG = 'N';
211:

Line 409: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE

405:
406: CURSOR get_pc_details (p_pc_node_id IN NUMBER)
407: IS
408: SELECT HEAD.PRIMARY_FLAG, HEAD.ASSOCIATION_TYPE_FLAG
409: FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE
410: WHERE NODE.PC_HEADER_ID = HEAD.PC_HEADER_ID AND
411: NODE.PC_NODE_ID = p_pc_node_id;
412:
413: BEGIN

Line 891: from ahl_pc_headers_b

887:
888: CURSOR check_header_id_exists (p_pc_header_id IN NUMBER)
889: IS
890: select pc_header_id, status
891: from ahl_pc_headers_b
892: where pc_header_id = p_pc_header_id;
893:
894: CURSOR check_id_exists (p_pc_header_id IN NUMBER, p_node_id IN NUMBER)
895: IS

Line 929: from ahl_pc_headers_b

925:
926: CURSOR get_pc_header_status (p_pc_header_id IN NUMBER)
927: IS
928: select status
929: from ahl_pc_headers_b
930: where pc_header_id = p_pc_header_id;
931:
932: CURSOR get_node_object_version (p_pc_node_id IN NUMBER)
933: IS

Line 1067: from ahl_pc_headers_b

1063:
1064: CURSOR get_pc_header_status (p_pc_header_id IN NUMBER)
1065: IS
1066: select status
1067: from ahl_pc_headers_b
1068: where pc_header_id = p_pc_header_id;
1069:
1070: l_pc_status VARCHAR2(30) := 'DRAFT';
1071:

Line 1081: update ahl_pc_headers_b

1077:
1078: IF (l_pc_status = 'APPROVAL_REJECTED')
1079: THEN
1080: -- Force updation of PC status; No check of header version number sanity
1081: update ahl_pc_headers_b
1082: set status = 'DRAFT'
1083: where pc_header_id = p_pc_header_id;
1084: END IF;
1085: