APPS.AHL_PC_HEADER_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 1650: FROM AHL_DOC_TITLE_ASSOS_B

1646: -- Knocking off Doc Associations
1647: DELETE FROM AHL_DOC_TITLE_ASSOS_TL
1648: WHERE DOC_TITLE_ASSO_ID IN (
1649: SELECT DOC_TITLE_ASSO_ID
1650: FROM AHL_DOC_TITLE_ASSOS_B
1651: WHERE ASO_OBJECT_TYPE_CODE = 'PC' and
1652: ASO_OBJECT_ID = l_node_tbl(i)
1653: );
1654:

Line 1655: DELETE FROM AHL_DOC_TITLE_ASSOS_B

1651: WHERE ASO_OBJECT_TYPE_CODE = 'PC' and
1652: ASO_OBJECT_ID = l_node_tbl(i)
1653: );
1654:
1655: DELETE FROM AHL_DOC_TITLE_ASSOS_B
1656: WHERE ASO_OBJECT_TYPE_CODE = 'PC' and
1657: ASO_OBJECT_ID = l_node_tbl(i);
1658:
1659: -- Knocking off the Units / Parts

Line 2329: FROM AHL_DOC_TITLE_ASSOS_B

2325: DELETE
2326: FROM AHL_DOC_TITLE_ASSOS_TL
2327: WHERE DOC_TITLE_ASSO_ID IN (
2328: SELECT DOC_TITLE_ASSO_ID
2329: FROM AHL_DOC_TITLE_ASSOS_B
2330: WHERE aso_object_type_code = 'PC' and
2331: aso_object_id = l_linked_node_id
2332: );
2333:

Line 2335: FROM AHL_DOC_TITLE_ASSOS_B

2331: aso_object_id = l_linked_node_id
2332: );
2333:
2334: DELETE
2335: FROM AHL_DOC_TITLE_ASSOS_B
2336: WHERE aso_object_type_code = 'PC' and
2337: aso_object_id = l_linked_node_id;
2338:
2339: -- Knocking off nodes...

Line 3294: FROM AHL_DOC_TITLE_ASSOS_B

3290: DELETE
3291: FROM AHL_DOC_TITLE_ASSOS_TL
3292: WHERE DOC_TITLE_ASSO_ID IN (
3293: SELECT DOC_TITLE_ASSO_ID
3294: FROM AHL_DOC_TITLE_ASSOS_B
3295: WHERE aso_object_type_code = 'PC' and
3296: aso_object_id = l_comp_nodeId_tbl(I)
3297: );
3298:

Line 3301: FROM AHL_DOC_TITLE_ASSOS_B

3297: );
3298:
3299: FORALL I IN 1..l_comp_nodeId_tbl.count
3300: DELETE
3301: FROM AHL_DOC_TITLE_ASSOS_B
3302: WHERE aso_object_type_code = 'PC' and
3303: aso_object_id = l_comp_nodeId_tbl(I);
3304:
3305:

Line 3307: UPDATE AHL_DOC_TITLE_ASSOS_B

3303: aso_object_id = l_comp_nodeId_tbl(I);
3304:
3305:
3306: FORALL I IN 1..l_draft_nodeId_tbl.count
3307: UPDATE AHL_DOC_TITLE_ASSOS_B
3308: SET ASO_OBJECT_ID = l_comp_nodeId_tbl(I),
3309: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1
3310: WHERE ASO_OBJECT_ID = l_draft_nodeId_tbl(I)
3311: AND ASO_OBJECT_TYPE_CODE = 'PC';