605: -- added for Bug#4448994 and as a general utility file.
606: PROCEDURE Get_Region_Code_TL_Data (
607: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
608: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
609: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
610: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
611: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
612: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
613: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
606: PROCEDURE Get_Region_Code_TL_Data (
607: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
608: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
609: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
610: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
611: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
612: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
613: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
614: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
607: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
608: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
609: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
610: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
611: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
612: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
613: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
614: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
615: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
608: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
609: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
610: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
611: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
612: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
613: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
614: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
615: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
616: , x_return_status OUT NOCOPY VARCHAR2
609: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
610: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
611: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
612: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
613: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
614: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
615: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
616: , x_return_status OUT NOCOPY VARCHAR2
617: , x_msg_count OUT NOCOPY NUMBER
610: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
611: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
612: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
613: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
614: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
615: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
616: , x_return_status OUT NOCOPY VARCHAR2
617: , x_msg_count OUT NOCOPY NUMBER
618: , x_msg_data OUT NOCOPY VARCHAR2
611: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
612: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
613: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
614: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
615: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
616: , x_return_status OUT NOCOPY VARCHAR2
617: , x_msg_count OUT NOCOPY NUMBER
618: , x_msg_data OUT NOCOPY VARCHAR2
619: );