DBA Data[Home] [Help]

APPS.BIS_AK_REGION_PUB dependencies on AK_REGIONS_TL

Line 3275: , x_Region_Name OUT NOCOPY Ak_Regions_Tl.NAME%TYPE

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

Line 3276: , x_Region_Description OUT NOCOPY Ak_Regions_Tl.DESCRIPTION%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

Line 3277: , x_Region_Created_By OUT NOCOPY Ak_Regions_Tl.CREATED_BY%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

Line 3278: , x_Region_Creation_Date OUT NOCOPY Ak_Regions_Tl.CREATION_DATE%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

Line 3279: , x_Region_Last_Updated_By OUT NOCOPY Ak_Regions_Tl.LAST_UPDATED_BY%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
3283: , x_msg_count OUT NOCOPY NUMBER

Line 3280: , x_Region_Last_Update_Date OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_DATE%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
3284: , x_msg_data OUT NOCOPY VARCHAR2

Line 3281: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%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
3285: ) IS