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.EAM_PROCESS_ISOLATION_PVT dependencies on EAM_ESTABLISHMENT_DETAILS

Line 641: CURSOR C2 IS SELECT EAM_ESTABLISHMENT_DETAILS_S.NEXTVAL FROM SYS.DUAL;

637: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
638: , x_return_status OUT NOCOPY VARCHAR2
639: ) IS
640:
641: CURSOR C2 IS SELECT EAM_ESTABLISHMENT_DETAILS_S.NEXTVAL FROM SYS.DUAL;
642:
643: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
644: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
645: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 695: From Eam_establishment_details

691: If Eam_process_wo_pvt.Get_debug = 'Y' Then Eam_error_message_pvt.Write_debug(' Checking uniqueness for Sequence type'); End If;
692:
693: SELECT COUNT(*)
694: Into L_count
695: From Eam_establishment_details
696: Where Establishment_source_id = L_establish_iso_rec.Establishment_source_id
697: And Sequence_type = L_establish_iso_rec.Sequence_type
698: And Organization_id= L_establish_iso_rec.Organization_id
699: And Sequence_number=L_establish_iso_rec.Sequence_number;

Line 713: From Eam_establishment_details

709: IF l_establish_iso_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_UPDATE THEN
710: BEGIN
711: Select Establishment_id
712: Into l_temp
713: From Eam_establishment_details
714: Where Establishment_source_id = L_establish_iso_rec.Establishment_source_id
715: And Sequence_type = L_establish_iso_rec.Sequence_type
716: And Organization_id= L_establish_iso_rec.Organization_id
717: And Sequence_number=L_establish_iso_rec.Sequence_number;