APPS.AHL_DI_ASSO_DOCASO_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 98: FROM AHL_DOC_TITLE_ASSOS_B a, AHL_DOC_TITLE_ASSOS_TL B

94: AS
95: Cursor GetDocDet(C_DOC_TITLE_ASSO_ID NUMBER)
96: IS
97: SELECT A.*,B.CHAPTER,B.SECTION,B.SUBJECT,B.PAGE,B.FIGURE,B.NOTE
98: FROM AHL_DOC_TITLE_ASSOS_B a, AHL_DOC_TITLE_ASSOS_TL B
99: WHERE A.DOC_TITLE_ASSO_ID=B.DOC_TITLE_ASSO_ID
100: AND A.DOC_TITLE_ASSO_ID=C_DOC_TITLE_ASSO_ID
101: AND B.LANGUAGE=USERENV('LANG');
102:

Line 735: FROM AHL_DOC_TITLE_ASSOS_B

731: doc_revision_id,
732: use_latest_rev_flag,
733: aso_object_type_code,
734: aso_object_id
735: FROM AHL_DOC_TITLE_ASSOS_B
736: WHERE doc_title_asso_id = c_doc_title_asso_id;
737:
738: -- Used to validate the document id
739: CURSOR check_doc_info(c_document_id NUMBER)

Line 794: FROM AHL_DOC_TITLE_ASSOS_B

790:
791: CURSOR CheckLatestRevFlag(C_DOC_TITLE_ASSO_ID NUMBER,C_ASO_OBJECT_ID NUMBER,c_aso_object_type_code VARCHAR2,c_document_id NUMBER,c_use_latest_rev_flag VARCHAR2)
792: IS
793: SELECT *
794: FROM AHL_DOC_TITLE_ASSOS_B
795: WHERE aso_object_id=c_aso_object_id
796: AND aso_object_type_code=c_aso_object_type_code
797: AND document_id=c_document_id
798: AND use_latest_rev_flag<>nvl(c_use_latest_rev_flag,'X')

Line 1043: FROM AHL_DOC_TITLE_ASSOS_B

1039:
1040:
1041: -- Latest Rev Flag Check.
1042: SELECT count(*) into l_counter1
1043: FROM AHL_DOC_TITLE_ASSOS_B
1044: WHERE aso_object_id=nvl(p_association_rec.aso_object_id,0)
1045: AND aso_object_type_code=nvl(p_association_rec.aso_object_type_code,'x')
1046: AND document_id=nvl(p_association_rec.document_id,0)
1047: AND nvl(use_latest_rev_flag,'N')='Y'

Line 1052: FROM AHL_DOC_TITLE_ASSOS_B

1048: AND NVL(p_association_rec.DOC_TITLE_ASSO_ID,0)=0;
1049:
1050:
1051: SELECT count(*) into l_counter
1052: FROM AHL_DOC_TITLE_ASSOS_B
1053: WHERE aso_object_id=nvl(p_association_rec.aso_object_id,0)
1054: AND aso_object_type_code=nvl(p_association_rec.aso_object_type_code,'x')
1055: AND document_id=nvl(p_association_rec.document_id,0)
1056: AND use_latest_rev_flag<>NVL(p_association_rec.use_latest_rev_flag,'N');

Line 1346: delete from AHL_DOC_TITLE_ASSOS_B

1342: THEN
1343: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1344: FND_MSG_PUB.ADD;
1345: ELSE
1346: delete from AHL_DOC_TITLE_ASSOS_B
1347: where DOC_TITLE_ASSO_ID = p_x_association_tbl(I).DOC_TITLE_ASSO_ID
1348: and OBJECT_VERSION_NUMBER=p_x_association_tbl(I).OBJECT_VERSION_NUMBER;
1349:
1350: IF (sql%notfound)

Line 1358: update AHL_DOC_TITLE_ASSOS_B set

1354: END IF;
1355: END IF;
1356: ELSIF p_x_association_tbl(i).DML_OPERATION ='U'
1357: THEN
1358: update AHL_DOC_TITLE_ASSOS_B set
1359: SERIAL_NO = p_x_association_tbl(i).SERIAL_NO,
1360: ATTRIBUTE_CATEGORY = p_x_association_tbl(i).ATTRIBUTE_CATEGORY,
1361: ATTRIBUTE1 = p_x_association_tbl(i).ATTRIBUTE1,
1362: ATTRIBUTE2 = p_x_association_tbl(i).ATTRIBUTE2,

Line 1416: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO

1412: END IF;
1413: END IF;
1414: ELSIF p_x_association_tbl(i).DML_OPERATION ='C'
1415: THEN
1416: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO
1417: p_x_association_tbl(i).doc_title_asso_id from DUAL;
1418:
1419: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW(
1420: X_ROWID =>l_rowid,