APPS.AHL_DI_ASSO_DOC_ASO_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 51: FROM AHL_DOC_TITLE_ASSOS_B

47: doc_revision_id,
48: use_latest_rev_flag,
49: aso_object_type_code,
50: aso_object_id
51: FROM AHL_DOC_TITLE_ASSOS_B
52: WHERE doc_title_asso_id = c_doc_title_asso_id;
53:
54: -- Used to validate the document id
55: CURSOR check_doc_info(c_document_id NUMBER)

Line 95: FROM AHL_DOC_TITLE_ASSOS_B

91: c_doc_revision_id NUMBER)
92:
93: IS
94: SELECT 'X'
95: FROM AHL_DOC_TITLE_ASSOS_B
96: WHERE aso_object_id = c_aso_object_id
97: AND aso_object_type_code = c_aso_object_type_code
98: AND document_id = c_document_id
99: AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0);

Line 301: FROM AHL_DOC_TITLE_ASSOS_B

297: CURSOR get_doc_assos_rec_b_info(c_doc_title_asso_id NUMBER)
298: IS
299: SELECT ROWID,
300: object_version_number
301: FROM AHL_DOC_TITLE_ASSOS_B
302: WHERE doc_title_asso_id = c_doc_title_asso_id
303: FOR UPDATE OF object_version_number NOWAIT;
304: --
305: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ASSOCIATION';

Line 367: DELETE FROM AHL_DOC_TITLE_ASSOS_B

363: X_DOC_TITLE_ASSO_ID => p_association_rec.doc_title_asso_id
364: );
365: /*
366: -- Delete the record from document associations table
367: DELETE FROM AHL_DOC_TITLE_ASSOS_B
368: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
369: --
370: -- Delete the record from document associations Trans table
371: DELETE FROM AHL_DOC_TITLE_ASSOS_TL

Line 478: FROM AHL_DOC_TITLE_ASSOS_B

474: c_doc_revision_id NUMBER)
475:
476: IS
477: SELECT 'X'
478: FROM AHL_DOC_TITLE_ASSOS_B
479: WHERE aso_object_id = c_aso_object_id
480: AND aso_object_type_code = c_aso_object_type_code
481: AND document_id = c_document_id
482: AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0);

Line 847: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO

843: END IF;
844: CLOSE dup_rec_check;
845: END IF;
846: --Gets the sequence Number
847: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO
848: l_doc_title_asso_id from DUAL;
849:
850: /*-------------------------------------------------------- */
851: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */

Line 1033: FROM AHL_DOC_TITLE_ASSOS_B AAB

1029: attribute12,
1030: attribute13,
1031: attribute14,
1032: attribute15
1033: FROM AHL_DOC_TITLE_ASSOS_B AAB
1034: WHERE doc_title_asso_id = c_doc_title_asso_id
1035: FOR UPDATE OF object_version_number NOWAIT;
1036:
1037: -- Cursor to retrieve the existing record from trans table

Line 1057: FROM AHL_DOC_TITLE_ASSOS_B

1053: c_doc_revision_id NUMBER)
1054:
1055: IS
1056: SELECT doc_title_asso_id
1057: FROM AHL_DOC_TITLE_ASSOS_B
1058: WHERE aso_object_id = c_aso_object_id
1059: AND aso_object_type_code = c_aso_object_type_code
1060: AND document_id = c_document_id
1061: AND doc_revision_id = c_doc_revision_id;

Line 1607: FROM AHL_DOC_TITLE_ASSOS_B

1603: c_doc_revision_id NUMBER)
1604:
1605: IS
1606: SELECT 'X'
1607: FROM AHL_DOC_TITLE_ASSOS_B
1608: WHERE aso_object_id = c_aso_object_id
1609: AND aso_object_type_code = c_aso_object_type_code
1610: AND document_id = c_document_id
1611: AND nvl(doc_revision_id,0) = NVL(c_doc_revision_id,0);

Line 1886: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL INTO

1882: RAISE Fnd_Api.G_EXC_ERROR;
1883: END IF;
1884: CLOSE dup_rec;
1885: --Gets the sequence Number
1886: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL INTO
1887: l_doc_title_asso_id FROM DUAL;
1888: /*-------------------------------------------------------- */
1889: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */
1890: /* description : Added by Senthil to call Table Handler */

Line 2098: FROM ahl_doc_title_assos_b

2094: EXIT WHEN get_assos_b_cur%NOTFOUND;
2095: IF get_assos_b_cur%FOUND THEN
2096: BEGIN
2097: SELECT ROWID INTO l_row_id
2098: FROM ahl_doc_title_assos_b
2099: WHERE doc_title_asso_id = l_association_rec.doc_title_asso_id
2100: AND object_version_number
2101: = l_association_rec.object_version_number
2102: FOR UPDATE OF aso_object_id NOWAIT;