APPS.AHL_DI_ASSO_DOCASO_PVT dependencies on AHL_DOC_TITLE_ASSOS_TL

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 1339: delete from AHL_DOC_TITLE_ASSOS_TL

1335: THEN
1336:
1337: IF p_x_association_tbl(i).DML_OPERATION ='D'
1338: THEN
1339: delete from AHL_DOC_TITLE_ASSOS_TL
1340: where DOC_TITLE_ASSO_ID = p_x_association_tbl(I).DOC_TITLE_ASSO_ID;
1341: IF (sql%notfound)
1342: THEN
1343: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

Line 1395: update AHL_DOC_TITLE_ASSOS_TL set

1391: THEN
1392: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1393: FND_MSG_PUB.ADD;
1394: ELSE
1395: update AHL_DOC_TITLE_ASSOS_TL set
1396: CHAPTER = p_x_association_tbl(i).CHAPTER,
1397: SECTION = p_x_association_tbl(i).SECTION,
1398: SUBJECT = p_x_association_tbl(i).SUBJECT,
1399: FIGURE = p_x_association_tbl(i).FIGURE,