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.

[Home] [Help]

APPS.BIS_AK_REGION_PUB dependencies on AK_REGIONS

Line 587: p_region_code IN Ak_Regions.REGION_CODE%TYPE

583: ) RETURN VARCHAR2;
584:
585: --return 'T' if given report is view based, 'F' otherwise
586: FUNCTION IS_VIEW_BASED_REPORT(
587: p_region_code IN Ak_Regions.REGION_CODE%TYPE
588: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
589: ) RETURN VARCHAR2;
590:
591: --return 'T' if given report is view-by, 'F' otherwise

Line 588: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type

584:
585: --return 'T' if given report is view based, 'F' otherwise
586: FUNCTION IS_VIEW_BASED_REPORT(
587: p_region_code IN Ak_Regions.REGION_CODE%TYPE
588: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
589: ) RETURN VARCHAR2;
590:
591: --return 'T' if given report is view-by, 'F' otherwise
592: FUNCTION IS_VIEW_BY_REPORT(

Line 593: p_region_code IN Ak_Regions.REGION_CODE%TYPE

589: ) RETURN VARCHAR2;
590:
591: --return 'T' if given report is view-by, 'F' otherwise
592: FUNCTION IS_VIEW_BY_REPORT(
593: p_region_code IN Ak_Regions.REGION_CODE%TYPE
594: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
595: ) RETURN VARCHAR2;
596:
597: --return 'T' if at least one aggregate function is defined in any column

Line 594: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type

590:
591: --return 'T' if given report is view-by, 'F' otherwise
592: FUNCTION IS_VIEW_BY_REPORT(
593: p_region_code IN Ak_Regions.REGION_CODE%TYPE
594: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
595: ) RETURN VARCHAR2;
596:
597: --return 'T' if at least one aggregate function is defined in any column
598: --for the given report, 'F' otherwise

Line 607: p_Region_Code IN Ak_Regions.REGION_CODE%TYPE

603:
604:
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

Line 608: , p_Region_Application_Id IN Ak_Regions.REGION_APPLICATION_ID%TYPE

604:
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

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: );