APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_APPLICABLE_MR_RELNS

Line 55: FROM AHL_APPLICABLE_MR_RELNS

51: -- cursor to fetch all applicable MRs and their related MRs for the instance number
52: Cursor Get_Appl_Mr_Relns
53: IS
54: SELECT CSI_ITEM_INSTANCE_ID, MR_HEADER_ID, RELATED_CSI_ITEM_INSTANCE_ID, RELATED_MR_HEADER_ID, UE_ID
55: FROM AHL_APPLICABLE_MR_RELNS
56: ORDER BY TREE_DEPTH_LEVEL;
57:
58: Cursor get_rel_mr_ue_id( c_mr_header_id NUMBER,c_item_instance_id NUMBER)
59: IS

Line 60: SELECT UE_ID FROM AHL_APPLICABLE_MR_RELNS

56: ORDER BY TREE_DEPTH_LEVEL;
57:
58: Cursor get_rel_mr_ue_id( c_mr_header_id NUMBER,c_item_instance_id NUMBER)
59: IS
60: SELECT UE_ID FROM AHL_APPLICABLE_MR_RELNS
61: where RELATED_MR_HEADER_ID = c_mr_header_id
62: and RELATED_CSI_ITEM_INSTANCE_ID = c_item_instance_id; --amsriniv
63:
64: -- cursor to validate the Mr Header Id

Line 428: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UMP_UTIL_PKG.process_Group_MR_Instance to populate AHL_APPLICABLE_MR_RELNS' );

424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426:
427: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
428: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UMP_UTIL_PKG.process_Group_MR_Instance to populate AHL_APPLICABLE_MR_RELNS' );
429: END IF;
430:
431:
432: -- create Unit Effectivities from Related MRs also

Line 435: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' BEFORE Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );

431:
432: -- create Unit Effectivities from Related MRs also
433:
434: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
435: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' BEFORE Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );
436: END IF;
437:
438: FOR l_appl_mrs_relns IN Get_Appl_Mr_Relns
439: LOOP

Line 507: -- update the table AHL_APPLICABLE_MR_RELNS with the new UE_IDs generated in AHL_UNIT_EFFECTIVITIES

503: X_LAST_UPDATED_BY => G_USER_ID,
504: X_LAST_UPDATE_LOGIN => G_LOGIN_ID );
505: -- additional column added to the table AHL_UNIT_EFFECTIVITIES
506:
507: -- update the table AHL_APPLICABLE_MR_RELNS with the new UE_IDs generated in AHL_UNIT_EFFECTIVITIES
508:
509: UPDATE AHL_APPLICABLE_MR_RELNS
510: SET
511: UE_ID = l_unit_effectivity_id --MANUALLY_PLANNED = 'Y'

Line 509: UPDATE AHL_APPLICABLE_MR_RELNS

505: -- additional column added to the table AHL_UNIT_EFFECTIVITIES
506:
507: -- update the table AHL_APPLICABLE_MR_RELNS with the new UE_IDs generated in AHL_UNIT_EFFECTIVITIES
508:
509: UPDATE AHL_APPLICABLE_MR_RELNS
510: SET
511: UE_ID = l_unit_effectivity_id --MANUALLY_PLANNED = 'Y'
512: where CSI_ITEM_INSTANCE_ID = l_appl_mrs_relns.CSI_ITEM_INSTANCE_ID
513: and MR_HEADER_ID = l_appl_mrs_relns.MR_HEADER_ID --amsriniv

Line 520: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );

516:
517: END LOOP;
518:
519: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
520: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );
521: END IF;
522:
523: -- to update the AHL_UE_RELATIONSHIPS table with the Unit Effectivity Relationships
524:

Line 576: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW for Related MRs from AHL_APPLICABLE_MR_RELNS' );

572: );
573: END LOOP;
574:
575: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
576: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW for Related MRs from AHL_APPLICABLE_MR_RELNS' );
577: END IF;
578: END IF;
579:
580: