DBA Data[Home] [Help]

APPS.AHL_PC_HEADER_PVT dependencies on AHL_PC_ASSOCIATION_PUB

Line 66: PROCEDURE DETACH_UNIT_REMOVE_LINK (p_x_assos_rec IN AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC);

62:
63: -----------------------------
64: -- DETACH_UNIT_REMOVE_LINK --
65: -----------------------------
66: PROCEDURE DETACH_UNIT_REMOVE_LINK (p_x_assos_rec IN AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC);
67:
68: -----------------------------
69: -- DETACH_ITEM_REMOVE_LINK --
70: -----------------------------

Line 71: PROCEDURE DETACH_ITEM_REMOVE_LINK (p_x_assos_rec IN AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC);

67:
68: -----------------------------
69: -- DETACH_ITEM_REMOVE_LINK --
70: -----------------------------
71: PROCEDURE DETACH_ITEM_REMOVE_LINK (p_x_assos_rec IN AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC);
72:
73: -----------------
74: -- REMOVE_LINK --
75: -----------------

Line 873: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;

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;
876: l_nodeId_tbl PC_NODE_ID_TBL;
877: l_nodeCtr NUMBER;

Line 1737: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;

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;
1741: l_nodeId_tbl PC_NODE_ID_TBL;

Line 2206: PROCEDURE DETACH_UNIT_REMOVE_LINK (p_x_assos_rec IN AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC)

2202:
2203: -----------------------------
2204: -- DETACH_UNIT_REMOVE_LINK --
2205: -----------------------------
2206: PROCEDURE DETACH_UNIT_REMOVE_LINK (p_x_assos_rec IN AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC)
2207: IS
2208:
2209:
2210:

Line 2229: PROCEDURE DETACH_ITEM_REMOVE_LINK (p_x_assos_rec IN AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC)

2225:
2226: -----------------------------
2227: -- DETACH_ITEM_REMOVE_LINK --
2228: -----------------------------
2229: PROCEDURE DETACH_ITEM_REMOVE_LINK (p_x_assos_rec IN AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC)
2230: IS
2231:
2232: BEGIN
2233: -- Knocking off items...

Line 2556: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;

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;
2560: l_node_data_rec_det detach_nodes%ROWTYPE;