DBA Data[Home] [Help]

APPS.AHL_PC_HEADER_PVT dependencies on AHL_PC_ASSOCIATION_PUB

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

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

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

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

Line 885: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;

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;
888:
889: l_assos_data_rec copy_document%ROWTYPE;

Line 1820: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;

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;
1824: --Bug # 9486654

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

2356:
2357: -----------------------------
2358: -- DETACH_UNIT_REMOVE_LINK --
2359: -----------------------------
2360: PROCEDURE DETACH_UNIT_REMOVE_LINK (p_x_assos_rec IN AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC)
2361: IS
2362:
2363:
2364:

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

2379:
2380: -----------------------------
2381: -- DETACH_ITEM_REMOVE_LINK --
2382: -----------------------------
2383: PROCEDURE DETACH_ITEM_REMOVE_LINK (p_x_assos_rec IN AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC)
2384: IS
2385:
2386: BEGIN
2387: -- Knocking off items...

Line 2714: l_assos_rec AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC;

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;
2718: l_node_units_data_rec attach_nodes_units%ROWTYPE;