APPS.AHL_DI_DOC_REVISION_PVT dependencies on AHL_DOC_REVISIONS_B

Line 86: FROM AHL_DOC_REVISIONS_B

82: issue_date,
83: received_date,
84: media_type_code,
85: issue_number
86: FROM AHL_DOC_REVISIONS_B
87: WHERE doc_revision_id = c_doc_revision_id;
88:
89: -- Check for Duplicate Record
90: CURSOR dup_rec(c_document_id NUMBER,

Line 94: FROM AHL_DOC_REVISIONS_B

90: CURSOR dup_rec(c_document_id NUMBER,
91: c_revision_no VARCHAR2)
92: IS
93: SELECT 'X'
94: FROM AHL_DOC_REVISIONS_B
95: WHERE document_id = c_document_id
96: AND revision_no = c_revision_no;
97:
98: --Modified pjha 25-Jun-2002 for restricting Media Type to Electronic File

Line 476: Select AHL_DOC_REVISIONS_B_S.Nextval Into l_doc_revision_id from dual;

472: l_revision_info.attribute13 := p_x_revision_tbl(i).attribute13;
473: l_revision_info.attribute14 := p_x_revision_tbl(i).attribute14;
474: l_revision_info.attribute15 := p_x_revision_tbl(i).attribute15;
475: -- Gets the value from sequence
476: Select AHL_DOC_REVISIONS_B_S.Nextval Into l_doc_revision_id from dual;
477: --Insert the record into doc revisions table
478: AHL_DOC_REVISIONS_PKG.INSERT_ROW(X_ROWID => l_row_id,
479: X_DOC_REVISION_ID => l_doc_revision_id,
480: X_APPROVED_DATE => l_revision_info.approved_date,

Line 665: FROM AHL_DOC_REVISIONS_B

661: attribute12,
662: attribute13,
663: attribute14,
664: attribute15
665: FROM AHL_DOC_REVISIONS_B
666: WHERE doc_revision_id = c_doc_revision_id
667: FOR UPDATE OF object_version_number NOWAIT;
668: --Used to retrieve the record from trans table
669: CURSOR get_doc_revisions_tl_rec_info(c_doc_revision_id NUMBER)

Line 957: FROM AHL_DOC_REVISIONS_B

953: SELECT ROWID,
954: effective_date,
955: obsolete_date,
956: object_version_number
957: FROM AHL_DOC_REVISIONS_B
958: WHERE doc_revision_id = c_doc_revision_id
959: FOR UPDATE OF object_version_number NOWAIT;
960: --
961: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_REVISION';

Line 1019: UPDATE AHL_DOC_REVISIONS_B

1015: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSOLETE_DATE_INVALID');
1016: FND_MSG_PUB.ADD;
1017: END IF;
1018: -- Update the end date in subscriptions table
1019: UPDATE AHL_DOC_REVISIONS_B
1020: SET OBSOLETE_DATE = p_x_revision_tbl(i).obsolete_date
1021: WHERE ROWID = l_rowid;
1022: END LOOP;
1023: END IF;