DBA Data[Home] [Help]

APPS.AHL_PC_HEADER_PVT dependencies on AHL_PC_NODE_PUB

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

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

Line 527: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;

523: l_return_status VARCHAR2(1);
524: l_dummy VARCHAR2(30);
525: l_node_id NUMBER := 0;
526: l_link_to_header_id NUMBER := 0;
527: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;
528: l_status VARCHAR2(30);
529: l_node_tbl T_ID_TBL;
530: l_assos_tbl T_ID_TBL;
531:

Line 883: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;

879: l_api_name CONSTANT VARCHAR2(30) := 'COPY_PC_HEADER';
880: l_api_version CONSTANT NUMBER := 1.0;
881: l_return_status VARCHAR2(1);
882:
883: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;
884: l_assos_doc_tbl AHL_DI_ASSO_DOC_ASO_PVT.ASSOCIATION_TBL;
885: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;
886: l_node_data_rec copy_nodes_data%ROWTYPE;
887: l_node_units_data_rec copy_nodes_units_data%ROWTYPE;

Line 1819: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;

1815: FROM AHL_DOC_TITLE_ASSOS_VL
1816: WHERE ASO_OBJECT_TYPE_CODE ='PC' AND
1817: ASO_OBJECT_ID = p_node_id;
1818:
1819: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;
1820: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;
1821: l_assos_doc_tbl AHL_DI_ASSO_DOC_ASO_PVT.ASSOCIATION_TBL;
1822: l_node_data_rec copy_nodes_data%ROWTYPE;
1823: l_assos_data_rec copy_document%ROWTYPE;

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

2204:
2205: ------------------------------
2206: -- DELETE_NODES_REMOVE_LINK --
2207: ------------------------------
2208: PROCEDURE DELETE_NODES_REMOVE_LINK (p_x_node_rec IN AHL_PC_NODE_PUB.PC_NODE_REC)
2209: IS
2210:
2211: TYPE T_ID_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2212:

Line 2713: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;

2709: AND mre.pc_node_id = pcn.pc_node_id
2710: AND pcn.pc_header_id = p_pc_header_id
2711: AND TRUNC(NVL(mrh.effective_to, SYSDATE+1)) > TRUNC(SYSDATE);
2712:
2713: l_node_rec AHL_PC_NODE_PUB.PC_NODE_REC;
2714: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;
2715: l_assos_doc_tbl AHL_DI_ASSO_DOC_ASO_PVT.ASSOCIATION_TBL;
2716:
2717: l_node_data_rec attach_nodes%ROWTYPE;