eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: -- FP #8410484
173: --Cursor To get revision status code

Line 459: FROM AHL_DOC_TITLE_ASSOS_B

455: -- Latest Rev Flag Check.
456: IF p_aso_object_type_code IN ('ROUTE','OPERATION')
457: THEN
458: SELECT count(*) into l_counter1
459: FROM AHL_DOC_TITLE_ASSOS_B
460: WHERE aso_object_id=nvl(p_aso_object_id,0)
461: AND aso_object_type_code=nvl(p_aso_object_type_code,'x')
462: AND document_id=nvl(p_document_id,0)
463: AND nvl(use_latest_rev_flag,'N')='Y'

Line 468: FROM AHL_DOC_TITLE_ASSOS_B

464: AND NVL(p_DOC_TITLE_ASSO_ID,0)=0;
465:
466:
467: SELECT count(*) into l_counter
468: FROM AHL_DOC_TITLE_ASSOS_B
469: WHERE aso_object_id=nvl(p_aso_object_id,0)
470: AND aso_object_type_code=nvl(p_aso_object_type_code,'x')
471: AND document_id=nvl(p_document_id,0)
472: AND use_latest_rev_flag<>NVL(p_use_latest_rev_flag,'N');

Line 519: From AHL_DOC_TITLE_ASSOS_B

515: AHL_DEBUG_PUB.debug( 'Checking latest revision doc attach');
516: END IF;
517: --Number of records(other than this record) having this document attached and use_latest =Yes
518: Select count(*) into l_counter
519: From AHL_DOC_TITLE_ASSOS_B
520: Where Aso_object_id = P_ASO_OBJECT_ID
521: And Aso_object_type_code = p_aso_object_type_code
522: And document_id = p_document_id
523: And USE_LATEST_REV_FLAG = 'Y'

Line 528: From AHL_DOC_TITLE_ASSOS_B

524: And doc_title_Asso_id <> nvl(p_doc_title_asso_id,0);
525:
526: -- Number of records having this document attached
527: Select count(*) into l_counter1
528: From AHL_DOC_TITLE_ASSOS_B
529: Where Aso_object_id = p_aso_object_id
530: And Aso_object_type_code = p_aso_object_type_code
531: And document_id = p_document_id
532: And doc_title_Asso_id <> nvl(p_doc_title_asso_id,0);

Line 622: FROM AHL_DOC_TITLE_ASSOS_B

618: CURSOR get_doc_assos_rec_b_info(c_doc_title_asso_id NUMBER)
619: IS
620: SELECT ROWID,
621: object_version_number
622: FROM AHL_DOC_TITLE_ASSOS_B
623: WHERE doc_title_asso_id = c_doc_title_asso_id
624: FOR UPDATE OF object_version_number NOWAIT;
625: --
626: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ASSOCIATION';

Line 689: DELETE FROM AHL_DOC_TITLE_ASSOS_B

685: X_DOC_TITLE_ASSO_ID => p_association_rec.doc_title_asso_id
686: );
687: /*
688: -- Delete the record from document associations table
689: DELETE FROM AHL_DOC_TITLE_ASSOS_B
690: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
691: --
692: -- Delete the record from document associations Trans table
693: DELETE FROM AHL_DOC_TITLE_ASSOS_TL

Line 801: FROM AHL_DOC_TITLE_ASSOS_B

797: c_doc_revision_id NUMBER)
798:
799: IS
800: SELECT doc_title_asso_id
801: FROM AHL_DOC_TITLE_ASSOS_B
802: WHERE aso_object_id = c_aso_object_id
803: AND aso_object_type_code = c_aso_object_type_code
804: AND document_id = c_document_id
805: AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0);

Line 899: FROM AHL_DOC_TITLE_ASSOS_B AAB

895: attribute12,
896: attribute13,
897: attribute14,
898: attribute15
899: FROM AHL_DOC_TITLE_ASSOS_B AAB
900: WHERE doc_title_asso_id = c_doc_title_asso_id
901: FOR UPDATE OF object_version_number NOWAIT;
902:
903: -- Cursor to retrieve the existing record from trans table

Line 1298: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO

1294:
1295: -----------------------------START CREATE-----------------------------------------------------------------------
1296: ELSIF p_x_association_tbl(i).DML_OPERATION ='C'
1297: THEN
1298: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO
1299: l_doc_title_asso_id from DUAL;
1300:
1301: /*-------------------------------------------------------- */
1302: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */

Line 1498: FROM AHL_DOC_TITLE_ASSOS_B

1494: c_doc_revision_id NUMBER)
1495:
1496: IS
1497: SELECT 'X'
1498: FROM AHL_DOC_TITLE_ASSOS_B
1499: WHERE aso_object_id = c_aso_object_id
1500: AND aso_object_type_code = c_aso_object_type_code
1501: AND document_id = c_document_id
1502: AND nvl(doc_revision_id,0) = NVL(c_doc_revision_id,0);

Line 1813: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL INTO

1809:
1810:
1811:
1812: --Gets the sequence Number
1813: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL INTO
1814: l_doc_title_asso_id FROM DUAL;
1815: /*-------------------------------------------------------- */
1816: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW */
1817: /* description : Added by Senthil to call Table Handler */

Line 2025: FROM ahl_doc_title_assos_b

2021: EXIT WHEN get_assos_b_cur%NOTFOUND;
2022: IF get_assos_b_cur%FOUND THEN
2023: BEGIN
2024: SELECT ROWID INTO l_row_id
2025: FROM ahl_doc_title_assos_b
2026: WHERE doc_title_asso_id = l_association_rec.doc_title_asso_id
2027: AND object_version_number
2028: = l_association_rec.object_version_number
2029: FOR UPDATE OF aso_object_id NOWAIT;

Line 2185: SELECT * FROM AHL_DOC_TITLE_ASSOS_B

2181: l_msg_count NUMBER := 0;
2182: CURSOR get_all_doc_assos (c_object_id NUMBER,
2183: c_object_type_code VARCHAR2)
2184: IS
2185: SELECT * FROM AHL_DOC_TITLE_ASSOS_B
2186: WHERE ASO_OBJECT_ID = c_object_id
2187: AND ASO_OBJECT_TYPE_CODE = c_object_type_code;
2188:
2189: l_doc_asso_rec get_all_doc_assos%ROWTYPE;

Line 2270: FROM AHL_DOC_TITLE_ASSOS_B

2266: DELETE
2267: FROM AHL_DOC_TITLE_ASSOS_TL
2268: WHERE DOC_TITLE_ASSO_ID IN (
2269: SELECT DOC_TITLE_ASSO_ID
2270: FROM AHL_DOC_TITLE_ASSOS_B
2271: WHERE aso_object_type_code = p_aso_object_type_code and
2272: aso_object_id = p_aso_object_id
2273: );
2274:

Line 2276: FROM AHL_DOC_TITLE_ASSOS_B

2272: aso_object_id = p_aso_object_id
2273: );
2274:
2275: DELETE
2276: FROM AHL_DOC_TITLE_ASSOS_B
2277: WHERE aso_object_type_code = p_aso_object_type_code and
2278: aso_object_id = p_aso_object_id;
2279:
2280: AHL_DEBUG_PUB.debug( 'exit AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');