APPS.AHL_DI_ASSO_DOC_ASO_PUB dependencies on AHL_DOC_REVISIONS_B

Line 84: FROM AHL_DOC_REVISIONS_B

80: CURSOR get_doc_rev_id_info(c_revision_no VARCHAR2,
81: c_document_id NUMBER)
82: IS
83: SELECT doc_revision_id
84: FROM AHL_DOC_REVISIONS_B
85: WHERE revision_no = c_revision_no
86: AND document_id = c_document_id;
87:
88: -- {{ adharia bug #2450326 - added- 9/7/2002

Line 93: FROM AHL_DOC_REVISIONS_B

89: --To retrieve document id
90: CURSOR get_doc_rev_count(c_document_id VARCHAR2)
91: IS
92: SELECT COUNT(*)
93: FROM AHL_DOC_REVISIONS_B
94: WHERE document_id = c_document_id;
95:
96: --to get the rev info based on the doc id used if only one rev is present for the document
97: CURSOR get_doc_rev_info(c_document_id NUMBER)

Line 100: FROM AHL_DOC_REVISIONS_B

96: --to get the rev info based on the doc id used if only one rev is present for the document
97: CURSOR get_doc_rev_info(c_document_id NUMBER)
98: IS
99: SELECT doc_revision_id, revision_no
100: FROM AHL_DOC_REVISIONS_B
101: WHERE document_id = c_document_id;
102: -- }} adharia bug #2450326 - added- 9/7/2002
103:
104: --

Line 555: FROM AHL_DOC_REVISIONS_B

551: --To retrieve count of revisions of the doc
552: CURSOR get_doc_rev_count(c_document_id VARCHAR2)
553: IS
554: SELECT COUNT(*)
555: FROM AHL_DOC_REVISIONS_B
556: WHERE document_id = c_document_id;
557:
558: --to get the rev info based on the doc id used if only one rev is present for the document
559: CURSOR get_doc_rev_info(c_document_id NUMBER)

Line 562: FROM AHL_DOC_REVISIONS_B

558: --to get the rev info based on the doc id used if only one rev is present for the document
559: CURSOR get_doc_rev_info(c_document_id NUMBER)
560: IS
561: SELECT doc_revision_id, revision_no
562: FROM AHL_DOC_REVISIONS_B
563: WHERE document_id = c_document_id;
564: -- }} adharia -- bug #2450326 - added- 9/7/2002
565:
566: --To retrieve document revision

Line 571: FROM AHL_DOC_REVISIONS_B A

567: CURSOR get_doc_rev_id_info(c_revision_no VARCHAR2,
568: c_document_id NUMBER)
569: IS
570: SELECT doc_revision_id
571: FROM AHL_DOC_REVISIONS_B A
572: WHERE revision_no = c_revision_no
573: AND document_id = c_document_id;
574: --
575: l_api_name CONSTANT VARCHAR2(30) := 'MODIFY_ASSOCIATION';

Line 1058: FROM AHL_DOC_REVISIONS_B A

1054: CURSOR get_doc_rev_id_info(c_revision_no VARCHAR2,
1055: c_document_id NUMBER)
1056: IS
1057: SELECT doc_revision_id
1058: FROM AHL_DOC_REVISIONS_B A
1059: WHERE revision_no = c_revision_no
1060: AND document_id = c_document_id;
1061: --
1062: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ASSOCIATION';