APPS.AHL_PC_HEADER_PVT dependencies on AHL_PC_NODE_PUB

Line 61: PROCEDURE DELETE_NODES_REMOVE_LINK (p_x_node_rec IN AHL_PC_NODE_PUB.PC_NODE_REC);

57:
58: -----------------------------
59: -- DELETE_NODES_REMOVE_LINK--
60: -----------------------------
61: PROCEDURE DELETE_NODES_REMOVE_LINK (p_x_node_rec IN AHL_PC_NODE_PUB.PC_NODE_REC);
62:
63: -----------------------------
64: -- DETACH_UNIT_REMOVE_LINK --
65: -----------------------------

Line 523: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;

519: l_return_status VARCHAR2(1);
520: l_dummy VARCHAR2(30);
521: l_node_id NUMBER := 0;
522: l_link_to_header_id NUMBER := 0;
523: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;
524: l_status VARCHAR2(30);
525: l_node_tbl T_ID_TBL;
526: l_assos_tbl T_ID_TBL;
527:

Line 871: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;

867: l_api_name CONSTANT VARCHAR2(30) := 'COPY_PC_HEADER';
868: l_api_version CONSTANT NUMBER := 1.0;
869: l_return_status VARCHAR2(1);
870:
871: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;
872: l_assos_doc_tbl AHL_DI_ASSO_DOC_ASO_PVT.ASSOCIATION_TBL;
873: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;
874: l_node_data_rec copy_nodes_data%ROWTYPE;
875: l_assos_data_rec copy_document%ROWTYPE;

Line 1736: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;

1732: FROM AHL_DOC_TITLE_ASSOS_VL
1733: WHERE ASO_OBJECT_TYPE_CODE ='PC' AND
1734: ASO_OBJECT_ID = p_node_id;
1735:
1736: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;
1737: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;
1738: l_assos_doc_tbl AHL_DI_ASSO_DOC_ASO_PVT.ASSOCIATION_TBL;
1739: l_node_data_rec copy_nodes_data%ROWTYPE;
1740: l_assos_data_rec copy_document%ROWTYPE;

Line 2054: PROCEDURE DELETE_NODES_REMOVE_LINK (p_x_node_rec IN AHL_PC_NODE_PUB.PC_NODE_REC)

2050:
2051: ------------------------------
2052: -- DELETE_NODES_REMOVE_LINK --
2053: ------------------------------
2054: PROCEDURE DELETE_NODES_REMOVE_LINK (p_x_node_rec IN AHL_PC_NODE_PUB.PC_NODE_REC)
2055: IS
2056:
2057: TYPE T_ID_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2058:

Line 2555: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;

2551: AND mre.pc_node_id = pcn.pc_node_id
2552: AND pcn.pc_header_id = p_pc_header_id
2553: AND TRUNC(NVL(mrh.effective_to, SYSDATE+1)) > TRUNC(SYSDATE);
2554:
2555: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;
2556: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;
2557: l_assos_doc_tbl AHL_DI_ASSO_DOC_ASO_PVT.ASSOCIATION_TBL;
2558:
2559: l_node_data_rec attach_nodes%ROWTYPE;