APPS.AHL_DI_ASSO_DOC_GEN_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 121: FROM AHL_DOC_TITLE_ASSOS_B

117: doc_revision_id,
118: use_latest_rev_flag,
119: aso_object_type_code,
120: aso_object_id
121: FROM AHL_DOC_TITLE_ASSOS_B
122: WHERE doc_title_asso_id = c_doc_title_asso_id;
123:
124: -- Used to validate the document id
125: CURSOR check_doc_info(c_document_id NUMBER)

Line 152: FROM AHL_DOC_TITLE_ASSOS_B

148:
149: CURSOR CheckLatestRevFlag(C_DOC_TITLE_ASSO_ID NUMBER,C_ASO_OBJECT_ID NUMBER,c_aso_object_type_code VARCHAR2,c_document_id NUMBER,c_use_latest_rev_flag VARCHAR2)
150: IS
151: SELECT 'X'
152: FROM AHL_DOC_TITLE_ASSOS_B
153: WHERE aso_object_id=c_aso_object_id
154: AND aso_object_type_code=c_aso_object_type_code
155: AND document_id=c_document_id
156: AND use_latest_rev_flag<>nvl(c_use_latest_rev_flag,'X')

Line 169: FROM AHL_DOC_TITLE_ASSOS_B

165:
166: CURSOR get_doc_assos_ovn(c_doc_title_asso_id NUMBER)
167: IS
168: SELECT object_version_number
169: FROM AHL_DOC_TITLE_ASSOS_B
170: WHERE doc_title_asso_id = c_doc_title_asso_id;
171:
172:
173: l_dummy_char VARCHAR2(1);

Line 387: FROM AHL_DOC_TITLE_ASSOS_B

383: IF p_aso_object_type_code IN ('ROUTE','OPERATION')
384: THEN
385:
386: SELECT count(*) into l_counter1
387: FROM AHL_DOC_TITLE_ASSOS_B
388: WHERE aso_object_id=nvl(p_aso_object_id,0)
389: AND aso_object_type_code=nvl(p_aso_object_type_code,'x')
390: AND document_id=nvl(p_document_id,0)
391: AND nvl(use_latest_rev_flag,'N')='Y'

Line 396: FROM AHL_DOC_TITLE_ASSOS_B

392: AND NVL(p_DOC_TITLE_ASSO_ID,0)=0;
393:
394:
395: SELECT count(*) into l_counter
396: FROM AHL_DOC_TITLE_ASSOS_B
397: WHERE aso_object_id=nvl(p_aso_object_id,0)
398: AND aso_object_type_code=nvl(p_aso_object_type_code,'x')
399: AND document_id=nvl(p_document_id,0)
400: AND use_latest_rev_flag<>NVL(p_use_latest_rev_flag,'N');

Line 474: FROM AHL_DOC_TITLE_ASSOS_B

470: CURSOR get_doc_assos_rec_b_info(c_doc_title_asso_id NUMBER)
471: IS
472: SELECT ROWID,
473: object_version_number
474: FROM AHL_DOC_TITLE_ASSOS_B
475: WHERE doc_title_asso_id = c_doc_title_asso_id
476: FOR UPDATE OF object_version_number NOWAIT;
477: --
478: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ASSOCIATION';

Line 541: DELETE FROM AHL_DOC_TITLE_ASSOS_B

537: X_DOC_TITLE_ASSO_ID => p_association_rec.doc_title_asso_id
538: );
539: /*
540: -- Delete the record from document associations table
541: DELETE FROM AHL_DOC_TITLE_ASSOS_B
542: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
543: --
544: -- Delete the record from document associations Trans table
545: DELETE FROM AHL_DOC_TITLE_ASSOS_TL

Line 653: FROM AHL_DOC_TITLE_ASSOS_B

649: c_doc_revision_id NUMBER)
650:
651: IS
652: SELECT doc_title_asso_id
653: FROM AHL_DOC_TITLE_ASSOS_B
654: WHERE aso_object_id = c_aso_object_id
655: AND aso_object_type_code = c_aso_object_type_code
656: AND document_id = c_document_id
657: AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0);

Line 751: FROM AHL_DOC_TITLE_ASSOS_B AAB

747: attribute12,
748: attribute13,
749: attribute14,
750: attribute15
751: FROM AHL_DOC_TITLE_ASSOS_B AAB
752: WHERE doc_title_asso_id = c_doc_title_asso_id
753: FOR UPDATE OF object_version_number NOWAIT;
754:
755: -- Cursor to retrieve the existing record from trans table

Line 1148: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO

1144:
1145: -----------------------------START CREATE-----------------------------------------------------------------------
1146: ELSIF p_x_association_tbl(i).DML_OPERATION ='C'
1147: THEN
1148: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO
1149: l_doc_title_asso_id from DUAL;
1150:
1151: /*-------------------------------------------------------- */
1152: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */

Line 1341: FROM AHL_DOC_TITLE_ASSOS_B

1337: c_doc_revision_id NUMBER)
1338:
1339: IS
1340: SELECT 'X'
1341: FROM AHL_DOC_TITLE_ASSOS_B
1342: WHERE aso_object_id = c_aso_object_id
1343: AND aso_object_type_code = c_aso_object_type_code
1344: AND document_id = c_document_id
1345: AND nvl(doc_revision_id,0) = NVL(c_doc_revision_id,0);

Line 1656: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL INTO

1652:
1653:
1654:
1655: --Gets the sequence Number
1656: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL INTO
1657: l_doc_title_asso_id FROM DUAL;
1658: /*-------------------------------------------------------- */
1659: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */
1660: /* description : Added by Senthil to call Table Handler */

Line 1868: FROM ahl_doc_title_assos_b

1864: EXIT WHEN get_assos_b_cur%NOTFOUND;
1865: IF get_assos_b_cur%FOUND THEN
1866: BEGIN
1867: SELECT ROWID INTO l_row_id
1868: FROM ahl_doc_title_assos_b
1869: WHERE doc_title_asso_id = l_association_rec.doc_title_asso_id
1870: AND object_version_number
1871: = l_association_rec.object_version_number
1872: FOR UPDATE OF aso_object_id NOWAIT;

Line 2028: SELECT * FROM AHL_DOC_TITLE_ASSOS_B

2024: l_msg_count NUMBER := 0;
2025: CURSOR get_all_doc_assos (c_object_id NUMBER,
2026: c_object_type_code VARCHAR2)
2027: IS
2028: SELECT * FROM AHL_DOC_TITLE_ASSOS_B
2029: WHERE ASO_OBJECT_ID = c_object_id
2030: AND ASO_OBJECT_TYPE_CODE = c_object_type_code;
2031:
2032: l_doc_asso_rec get_all_doc_assos%ROWTYPE;

Line 2113: FROM AHL_DOC_TITLE_ASSOS_B

2109: DELETE
2110: FROM AHL_DOC_TITLE_ASSOS_TL
2111: WHERE DOC_TITLE_ASSO_ID IN (
2112: SELECT DOC_TITLE_ASSO_ID
2113: FROM AHL_DOC_TITLE_ASSOS_B
2114: WHERE aso_object_type_code = p_aso_object_type_code and
2115: aso_object_id = p_aso_object_id
2116: );
2117:

Line 2119: FROM AHL_DOC_TITLE_ASSOS_B

2115: aso_object_id = p_aso_object_id
2116: );
2117:
2118: DELETE
2119: FROM AHL_DOC_TITLE_ASSOS_B
2120: WHERE aso_object_type_code = p_aso_object_type_code and
2121: aso_object_id = p_aso_object_id;
2122:
2123: AHL_DEBUG_PUB.debug( 'exit AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');