APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_APPLICABLE_MR_RELNS

Line 66: FROM AHL_APPLICABLE_MR_RELNS

62: -- cursor to fetch all applicable MRs and their related MRs for the instance number
63: Cursor Get_Appl_Mr_Relns
64: IS
65: SELECT CSI_ITEM_INSTANCE_ID, MR_HEADER_ID, RELATED_CSI_ITEM_INSTANCE_ID, RELATED_MR_HEADER_ID, UE_ID
66: FROM AHL_APPLICABLE_MR_RELNS
67: ORDER BY TREE_DEPTH_LEVEL;
68:
69: Cursor get_rel_mr_ue_id( c_mr_header_id NUMBER,c_item_instance_id NUMBER)
70: IS

Line 71: SELECT UE_ID FROM AHL_APPLICABLE_MR_RELNS

67: ORDER BY TREE_DEPTH_LEVEL;
68:
69: Cursor get_rel_mr_ue_id( c_mr_header_id NUMBER,c_item_instance_id NUMBER)
70: IS
71: SELECT UE_ID FROM AHL_APPLICABLE_MR_RELNS
72: where RELATED_MR_HEADER_ID = c_mr_header_id
73: and RELATED_CSI_ITEM_INSTANCE_ID = c_item_instance_id; --amsriniv
74:
75: -- cursor to validate the Mr Header Id

Line 476: 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' );

472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
476: 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' );
477: END IF;
478:
479:
480: -- create Unit Effectivities from Related MRs also

Line 483: 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' );

479:
480: -- create Unit Effectivities from Related MRs also
481:
482: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
483: 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' );
484: END IF;
485:
486: FOR l_appl_mrs_relns IN Get_Appl_Mr_Relns
487: LOOP

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

577: -- BACHANDR - NR project end
578: );
579: -- additional column added to the table AHL_UNIT_EFFECTIVITIES
580:
581: -- update the table AHL_APPLICABLE_MR_RELNS with the new UE_IDs generated in AHL_UNIT_EFFECTIVITIES
582:
583: UPDATE AHL_APPLICABLE_MR_RELNS
584: SET
585: UE_ID = l_unit_effectivity_id --MANUALLY_PLANNED = 'Y'

Line 583: UPDATE AHL_APPLICABLE_MR_RELNS

579: -- additional column added to the table AHL_UNIT_EFFECTIVITIES
580:
581: -- update the table AHL_APPLICABLE_MR_RELNS with the new UE_IDs generated in AHL_UNIT_EFFECTIVITIES
582:
583: UPDATE AHL_APPLICABLE_MR_RELNS
584: SET
585: UE_ID = l_unit_effectivity_id --MANUALLY_PLANNED = 'Y'
586: where CSI_ITEM_INSTANCE_ID = l_appl_mrs_relns.CSI_ITEM_INSTANCE_ID
587: and MR_HEADER_ID = l_appl_mrs_relns.MR_HEADER_ID --amsriniv

Line 594: 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' );

590:
591: END LOOP;
592:
593: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
594: 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' );
595: END IF;
596:
597: -- to update the AHL_UE_RELATIONSHIPS table with the Unit Effectivity Relationships
598:

Line 650: 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' );

646: );
647: END LOOP;
648:
649: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
650: 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' );
651: END IF;
652: END IF;
653:
654: