DBA Data[Home] [Help]

APPS.BIS_AK_REGION_PUB dependencies on AK_REGIONS_TL

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

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

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

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

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

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

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

Line 615: , x_Region_Last_Update_Login OUT NOCOPY Ak_Regions_Tl.LAST_UPDATE_LOGIN%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
619: );