APPS.AHL_PC_HEADER_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 1572: FROM AHL_DOC_TITLE_ASSOS_B

1568: -- Knocking off Doc Associations
1569: DELETE FROM AHL_DOC_TITLE_ASSOS_TL
1570: WHERE DOC_TITLE_ASSO_ID IN (
1571: SELECT DOC_TITLE_ASSO_ID
1572: FROM AHL_DOC_TITLE_ASSOS_B
1573: WHERE ASO_OBJECT_TYPE_CODE = 'PC' and
1574: ASO_OBJECT_ID = l_node_tbl(i)
1575: );
1576:

Line 1577: DELETE FROM AHL_DOC_TITLE_ASSOS_B

1573: WHERE ASO_OBJECT_TYPE_CODE = 'PC' and
1574: ASO_OBJECT_ID = l_node_tbl(i)
1575: );
1576:
1577: DELETE FROM AHL_DOC_TITLE_ASSOS_B
1578: WHERE ASO_OBJECT_TYPE_CODE = 'PC' and
1579: ASO_OBJECT_ID = l_node_tbl(i);
1580:
1581: -- Knocking off the Units / Parts

Line 2175: FROM AHL_DOC_TITLE_ASSOS_B

2171: DELETE
2172: FROM AHL_DOC_TITLE_ASSOS_TL
2173: WHERE DOC_TITLE_ASSO_ID IN (
2174: SELECT DOC_TITLE_ASSO_ID
2175: FROM AHL_DOC_TITLE_ASSOS_B
2176: WHERE aso_object_type_code = 'PC' and
2177: aso_object_id = l_linked_node_id
2178: );
2179:

Line 2181: FROM AHL_DOC_TITLE_ASSOS_B

2177: aso_object_id = l_linked_node_id
2178: );
2179:
2180: DELETE
2181: FROM AHL_DOC_TITLE_ASSOS_B
2182: WHERE aso_object_type_code = 'PC' and
2183: aso_object_id = l_linked_node_id;
2184:
2185: -- Knocking off nodes...

Line 3070: FROM AHL_DOC_TITLE_ASSOS_B

3066: DELETE
3067: FROM AHL_DOC_TITLE_ASSOS_TL
3068: WHERE DOC_TITLE_ASSO_ID IN (
3069: SELECT DOC_TITLE_ASSO_ID
3070: FROM AHL_DOC_TITLE_ASSOS_B
3071: WHERE aso_object_type_code = 'PC' and
3072: aso_object_id = l_comp_nodeId_tbl(I)
3073: );
3074:

Line 3077: FROM AHL_DOC_TITLE_ASSOS_B

3073: );
3074:
3075: FORALL I IN 1..l_comp_nodeId_tbl.count
3076: DELETE
3077: FROM AHL_DOC_TITLE_ASSOS_B
3078: WHERE aso_object_type_code = 'PC' and
3079: aso_object_id = l_comp_nodeId_tbl(I);
3080:
3081:

Line 3083: UPDATE AHL_DOC_TITLE_ASSOS_B

3079: aso_object_id = l_comp_nodeId_tbl(I);
3080:
3081:
3082: FORALL I IN 1..l_draft_nodeId_tbl.count
3083: UPDATE AHL_DOC_TITLE_ASSOS_B
3084: SET ASO_OBJECT_ID = l_comp_nodeId_tbl(I),
3085: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1
3086: WHERE ASO_OBJECT_ID = l_draft_nodeId_tbl(I)
3087: AND ASO_OBJECT_TYPE_CODE = 'PC';