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.

[Home] [Help]

APPS.AHL_OSP_ACCOMP_PVT dependencies on AHL_OSP_ACCOMPLISHMENTS

Line 368: -- The records in the AHL_OSP_ACCOMPLISHMENTS will also be updated

364: -- Start of Comments --
365: -- Procedure name : accomplish_osp_mrs
366: -- Type : Private
367: -- Function : Procedure to Accomplish one or more MRs associated to a OSP Line.
368: -- The records in the AHL_OSP_ACCOMPLISHMENTS will also be updated
369: -- Will be called from the Service Details UI.
370: -- Pre-reqs :
371: -- Parameters :
372: --

Line 430: FROM ahl_osp_accomplishments

426: l_accomp_dates_tbl DATE_TBL_TYPE;
427:
428: CURSOR chk_accomplishment_csr(c_accomplishment_id NUMBER) IS
429: SELECT osp_order_line_id
430: FROM ahl_osp_accomplishments
431: WHERE accomplishment_id = c_accomplishment_id
432: AND status_code = 'OPEN'
433: AND accomplished_date is not null;
434:

Line 442: FROM ahl_osp_accomplishments

438: WHERE osp_order_line_id = c_osp_order_line_id;
439:
440: CURSOR get_accomplishments_csr(c_osp_order_line_id NUMBER) IS
441: SELECT accomplishment_id
442: FROM ahl_osp_accomplishments
443: WHERE osp_order_line_id = c_osp_order_line_id
444: AND status_code = 'OPEN'
445: AND accomplished_date is not null;
446:

Line 452: FROM ahl_osp_accomplishments

448: SELECT item_instance_id,
449: mr_header_id,
450: accomplished_date,
451: object_version_number
452: FROM ahl_osp_accomplishments
453: WHERE accomplishment_id = c_accomplishment_id
454: AND status_code = 'OPEN'
455: AND accomplished_date is not null
456: FOR UPDATE of object_version_number;

Line 586: -- Retrieve details from AHL_OSP_ACCOMPLISHMENTS and lock the row for update

582: WHILE (i IS NOT NULL) LOOP
583: IF (l_log_statement >= l_log_current_level) THEN
584: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Processing index ' || i || ', Accomplishment Id = ' || l_accomplishment_ids_tbl(i));
585: END IF;
586: -- Retrieve details from AHL_OSP_ACCOMPLISHMENTS and lock the row for update
587: OPEN get_accomplishment_dtls_csr(c_accomplishment_id => l_accomplishment_ids_tbl(i));
588: FETCH get_accomplishment_dtls_csr INTO l_accomplishment_dtls;
589:
590: -- Call the helper procedure Create_And_Accomplish_Mr

Line 616: UPDATE AHL_OSP_ACCOMPLISHMENTS

612: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to update Accomplishments table for row with accomplishment_id ' || l_accomplishment_ids_tbl(i) ||
613: ' : Setting UNIT_EFFECTIVITY_ID as ' || l_unit_effectivity_id);
614: END IF;
615:
616: UPDATE AHL_OSP_ACCOMPLISHMENTS
617: SET UNIT_EFFECTIVITY_ID = l_unit_effectivity_id,
618: STATUS_CODE = 'ACCOMPLISHED',
619: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
620: LAST_UPDATE_DATE = SYSDATE,

Line 627: -- If this is a Group MR, insert the additional records into the AHL_OSP_ACCOMPLISHMENTS table

623: WHERE ACCOMPLISHMENT_ID = l_accomplishment_ids_tbl(i);
624:
625: CLOSE get_accomplishment_dtls_csr;
626:
627: -- If this is a Group MR, insert the additional records into the AHL_OSP_ACCOMPLISHMENTS table
628: OPEN get_descendant_UEs_csr(l_unit_effectivity_id);
629: FETCH get_descendant_UEs_csr BULK COLLECT INTO l_child_ue_ids_tbl, l_instance_ids_tbl, l_mr_ids_tbl, l_accomp_dates_tbl;
630: CLOSE get_descendant_UEs_csr;
631: IF (l_child_ue_ids_tbl IS NOT NULL AND l_child_ue_ids_tbl.COUNT > 0) THEN

Line 634: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to insert additional records into AHL_OSP_ACCOMPLISHMENTS.');

630: CLOSE get_descendant_UEs_csr;
631: IF (l_child_ue_ids_tbl IS NOT NULL AND l_child_ue_ids_tbl.COUNT > 0) THEN
632: IF (l_log_statement >= l_log_current_level) THEN
633: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Accomplishment for Group MR. l_child_ue_ids_tbl.COUNT = ' || l_child_ue_ids_tbl.COUNT);
634: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to insert additional records into AHL_OSP_ACCOMPLISHMENTS.');
635: END IF;
636: FOR j IN l_child_ue_ids_tbl.FIRST..l_child_ue_ids_tbl.LAST LOOP
637: INSERT INTO AHL_OSP_ACCOMPLISHMENTS(ACCOMPLISHMENT_ID,
638: OBJECT_VERSION_NUMBER,

Line 637: INSERT INTO AHL_OSP_ACCOMPLISHMENTS(ACCOMPLISHMENT_ID,

633: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Accomplishment for Group MR. l_child_ue_ids_tbl.COUNT = ' || l_child_ue_ids_tbl.COUNT);
634: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'About to insert additional records into AHL_OSP_ACCOMPLISHMENTS.');
635: END IF;
636: FOR j IN l_child_ue_ids_tbl.FIRST..l_child_ue_ids_tbl.LAST LOOP
637: INSERT INTO AHL_OSP_ACCOMPLISHMENTS(ACCOMPLISHMENT_ID,
638: OBJECT_VERSION_NUMBER,
639: LAST_UPDATE_DATE,
640: LAST_UPDATED_BY,
641: CREATION_DATE,

Line 651: VALUES (AHL_OSP_ACCOMPLISHMENTS_S.NEXTVAL,

647: MR_HEADER_ID,
648: PLANNING_TYPE_CODE,
649: STATUS_CODE,
650: ACCOMPLISHED_DATE)
651: VALUES (AHL_OSP_ACCOMPLISHMENTS_S.NEXTVAL,
652: 1,
653: SYSDATE,
654: FND_GLOBAL.user_id,
655: SYSDATE,

Line 758: FROM AHL_OSP_ACCOMPLISHMENTS

754:
755: -- Cursor to get the instances for which accomplishments are recorded
756: CURSOR get_recorded_instances_csr IS
757: SELECT distinct ITEM_INSTANCE_ID
758: FROM AHL_OSP_ACCOMPLISHMENTS
759: WHERE osp_order_line_id = p_osp_order_line_id;
760:
761: CURSOR get_received_quantity_csr IS
762: SELECT OEL.shipped_quantity