APPS.AHL_DI_ASSO_DOC_GEN_PVT dependencies on AHL_DOC_TITLE_ASSOS_VL

Line 674: FROM AHL_DOC_TITLE_ASSOS_VL

670: c_figure VARCHAR2)
671:
672: IS
673: SELECT doc_title_asso_id
674: FROM AHL_DOC_TITLE_ASSOS_VL
675: WHERE aso_object_id = c_aso_object_id
676: AND aso_object_type_code = c_aso_object_type_code
677: AND document_id = c_document_id
678: AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0)

Line 702: FROM AHL_DOC_TITLE_ASSOS_VL

698: c_figure VARCHAR2)
699:
700: IS
701: SELECT doc_title_asso_id
702: FROM AHL_DOC_TITLE_ASSOS_VL
703: WHERE doc_title_asso_id <> c_doc_title_asso_id
704: AND aso_object_id = c_aso_object_id
705: AND aso_object_type_code = c_aso_object_type_code
706: AND document_id = c_document_id

Line 1300: p_association_rec IN ahl_doc_title_assos_vl%ROWTYPE ,

1296: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
1297: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
1298: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
1299: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1300: p_association_rec IN ahl_doc_title_assos_vl%ROWTYPE ,
1301: x_return_status OUT NOCOPY VARCHAR2 ,
1302: x_msg_count OUT NOCOPY NUMBER ,
1303: x_msg_data OUT NOCOPY VARCHAR2)
1304: IS

Line 1320: FROM AHL_DOC_TITLE_ASSOS_VL

1316: c_figure VARCHAR2)
1317:
1318: IS
1319: SELECT doc_title_asso_id
1320: FROM AHL_DOC_TITLE_ASSOS_VL
1321: WHERE aso_object_id = c_aso_object_id
1322: AND aso_object_type_code = c_aso_object_type_code
1323: AND document_id = c_document_id
1324: AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0)

Line 1815: SELECT * FROM AHL_DOC_TITLE_ASSOS_VL

1811: -- Retrives all the records for passed aso object
1812: CURSOR get_assos_b_cur (c_object_id NUMBER,
1813: c_object_type_code VARCHAR2)
1814: IS
1815: SELECT * FROM AHL_DOC_TITLE_ASSOS_VL
1816: WHERE ASO_OBJECT_ID = c_object_id
1817: AND ASO_OBJECT_TYPE_CODE = c_object_type_code;
1818: --
1819: l_api_name CONSTANT VARCHAR2(30) := 'COPY_ASSOCIATION';