APPS.AHL_DI_ASSO_DOC_ASO_PVT dependencies on AHL_DOCUMENTS_B

Line 59: FROM AHL_DOCUMENTS_B

55: CURSOR check_doc_info(c_document_id NUMBER)
56:
57: IS
58: SELECT 'X'
59: FROM AHL_DOCUMENTS_B
60: WHERE document_id = c_document_id;
61: --
62: CURSOR get_doc_det(c_document_id NUMBER)
63: IS

Line 65: FROM AHL_DOCUMENTS_B

61: --
62: CURSOR get_doc_det(c_document_id NUMBER)
63: IS
64: SELECT document_no
65: FROM AHL_DOCUMENTS_B
66: WHERE document_id = c_document_id;
67: --
68: CURSOR get_rev_det(c_doc_revision_id NUMBER)
69: IS

Line 511: FROM AHL_DOCUMENTS_B

507: --
508: CURSOR get_doc_num(c_document_id NUMBER)
509: IS
510: SELECT document_no
511: FROM AHL_DOCUMENTS_B
512: WHERE document_id = c_document_id;
513: --
514: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ASSOCIATION';
515: l_api_version CONSTANT NUMBER := 1.0;

Line 1093: FROM AHL_DOCUMENTS_B

1089:
1090: CURSOR get_doc_det(c_document_id NUMBER)
1091: IS
1092: SELECT document_no
1093: FROM AHL_DOCUMENTS_B
1094: WHERE document_id = c_document_id;
1095: --
1096: l_api_name CONSTANT VARCHAR2(30) := 'MODIFY_ASSOCIATION';
1097: l_api_version CONSTANT NUMBER := 1.0;

Line 1616: FROM AHL_DOCUMENTS_B

1612: --
1613: CURSOR get_doc_num(c_document_id NUMBER)
1614: IS
1615: SELECT document_no
1616: FROM AHL_DOCUMENTS_B
1617: WHERE document_id = c_document_id;
1618: --
1619: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ASSOC_REC';
1620: l_api_version CONSTANT NUMBER := 1.0;