APPS.AHL_DI_DOC_REVISION_PVT dependencies on AHL_DOC_REVISIONS_B

Line 95: FROM AHL_DOC_REVISIONS_B

91: enigma_doc_id,
92: enigma_model_code,
93: --pekambar Enigma Phase II changes -- end
94: issue_number
95: FROM AHL_DOC_REVISIONS_B
96: WHERE doc_revision_id = c_doc_revision_id;
97:
98: -- Check for Duplicate Record
99: CURSOR dup_rec(c_document_id NUMBER,

Line 103: FROM AHL_DOC_REVISIONS_B

99: CURSOR dup_rec(c_document_id NUMBER,
100: c_revision_no VARCHAR2)
101: IS
102: SELECT 'X'
103: FROM AHL_DOC_REVISIONS_B
104: WHERE document_id = c_document_id
105: AND revision_no = c_revision_no;
106:
107: --Modified pjha 25-Jun-2002 for restricting Media Type to Electronic File

Line 508: FROM AHL_DOC_REVISIONS_B

504: --Cursor To get revision status code
505: CURSOR get_revision_status_code(c_doc_revision_id NUMBER)
506: IS
507: SELECT revision_status_code
508: FROM AHL_DOC_REVISIONS_B
509: WHERE doc_revision_id = c_doc_revision_id;
510:
511: -- Cursor to get MC status
512: CURSOR get_mc_status(c_relationship_id NUMBER)

Line 555: FROM ahl_doc_revisions_b

551:
552: BEGIN
553: --Query to select the latest revision id
554: SELECT MAX(doc_revision_id) INTO l_latest_doc_revision_id
555: FROM ahl_doc_revisions_b
556: WHERE NVL(effective_date,revision_date) = (SELECT MAX(NVL(effective_date,revision_date))
557: FROM ahl_doc_revisions_b
558: WHERE document_id = p_document_id
559: AND NVL(effective_date,revision_date) <= SYSDATE

Line 557: FROM ahl_doc_revisions_b

553: --Query to select the latest revision id
554: SELECT MAX(doc_revision_id) INTO l_latest_doc_revision_id
555: FROM ahl_doc_revisions_b
556: WHERE NVL(effective_date,revision_date) = (SELECT MAX(NVL(effective_date,revision_date))
557: FROM ahl_doc_revisions_b
558: WHERE document_id = p_document_id
559: AND NVL(effective_date,revision_date) <= SYSDATE
560: AND revision_status_code = 'CURRENT')
561: AND document_id = p_document_id

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

866: l_revision_info.attribute14 := p_x_revision_tbl(i).attribute14;
867: l_revision_info.attribute15 := p_x_revision_tbl(i).attribute15;*/
868: --End of changes for Bug 9532118
869: -- Gets the value from sequence
870: Select AHL_DOC_REVISIONS_B_S.Nextval Into l_doc_revision_id from dual;
871: --Insert the record into doc revisions table
872: AHL_DOC_REVISIONS_PKG.INSERT_ROW(X_ROWID => l_row_id,
873: X_DOC_REVISION_ID => l_doc_revision_id,
874: X_APPROVED_DATE => l_revision_info.approved_date,

Line 1074: FROM AHL_DOC_REVISIONS_B

1070: attribute12,
1071: attribute13,
1072: attribute14,
1073: attribute15
1074: FROM AHL_DOC_REVISIONS_B
1075: WHERE doc_revision_id = c_doc_revision_id
1076: FOR UPDATE OF object_version_number NOWAIT;
1077: --Used to retrieve the record from trans table
1078: CURSOR get_doc_revisions_tl_rec_info(c_doc_revision_id NUMBER)

Line 1503: FROM AHL_DOC_REVISIONS_B

1499: SELECT ROWID,
1500: effective_date,
1501: obsolete_date,
1502: object_version_number
1503: FROM AHL_DOC_REVISIONS_B
1504: WHERE doc_revision_id = c_doc_revision_id
1505: FOR UPDATE OF object_version_number NOWAIT;
1506: --
1507: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_REVISION';

Line 1565: UPDATE AHL_DOC_REVISIONS_B

1561: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OBSOLETE_DATE_INVALID');
1562: FND_MSG_PUB.ADD;
1563: END IF;
1564: -- Update the end date in subscriptions table
1565: UPDATE AHL_DOC_REVISIONS_B
1566: SET OBSOLETE_DATE = p_x_revision_tbl(i).obsolete_date
1567: WHERE ROWID = l_rowid;
1568: END LOOP;
1569: END IF;

Line 1633: update ahl_doc_revisions_b

1629: errbuf := FND_MSG_PUB.Get;
1630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1631: END IF;
1632: -- To change the status of the documents obsoleted using future obsolete date to 'obsolete' status.
1633: update ahl_doc_revisions_b
1634: set revision_status_code ='OBSOLETE'
1635: where trunc(obsolete_date) <= trunc(sysdate)
1636: and revision_status_code <> 'OBSOLETE';
1637: