3271: -- added for Bug#4448994 and as a general utility file.
3272: PROCEDURE Get_Region_Code_TL_Data (
3273: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
3274: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3272: PROCEDURE Get_Region_Code_TL_Data (
3273: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
3274: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
3273: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE
3274: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
3274: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE
3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
3282: , x_return_status OUT NOCOPY VARCHAR2
3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
3282: , x_return_status OUT NOCOPY VARCHAR2
3283: , x_msg_count OUT NOCOPY NUMBER
3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%TYPE
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
3282: , x_return_status OUT NOCOPY VARCHAR2
3283: , x_msg_count OUT NOCOPY NUMBER
3284: , x_msg_data OUT NOCOPY VARCHAR2
3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%TYPE
3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%TYPE
3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%TYPE
3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%TYPE
3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%TYPE
3282: , x_return_status OUT NOCOPY VARCHAR2
3283: , x_msg_count OUT NOCOPY NUMBER
3284: , x_msg_data OUT NOCOPY VARCHAR2
3285: ) IS