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.

APPS.BIS_AK_REGION_PUB dependencies on AK_REGION_ITEMS

Line 37: -- 01/08/05 mdamle Add Url to AK_REGION_ITEMS routines --

33: -- 11/18/04 sawu Bug#4018318 - Added api Is_View_Based_Report and
34: -- set node_display_flag to 'N' for C_COMPARE_TO_MEASURE_NO_TARGET
35: -- 11/24/04 sawu Bug#4028958: added IS_VIEW_BY_REPORT, IS_AGGREGATE_DEFINED
36: -- and updated UPDATE_REGION_ITEM_ATTR
37: -- 01/08/05 mdamle Add Url to AK_REGION_ITEMS routines --
38: -- 02/01/05 mdamle Add order_sequence, direction to AK_REGION_ITEMS --
39: -- 04/26/05 ankagarw bug#4194925 - saving measure display name as --
40: -- attribute long label in ak_region_items --
41: -- 19-MAY-2005 visuri GSCC Issues bug 4363854 --

Line 38: -- 02/01/05 mdamle Add order_sequence, direction to AK_REGION_ITEMS --

34: -- set node_display_flag to 'N' for C_COMPARE_TO_MEASURE_NO_TARGET
35: -- 11/24/04 sawu Bug#4028958: added IS_VIEW_BY_REPORT, IS_AGGREGATE_DEFINED
36: -- and updated UPDATE_REGION_ITEM_ATTR
37: -- 01/08/05 mdamle Add Url to AK_REGION_ITEMS routines --
38: -- 02/01/05 mdamle Add order_sequence, direction to AK_REGION_ITEMS --
39: -- 04/26/05 ankagarw bug#4194925 - saving measure display name as --
40: -- attribute long label in ak_region_items --
41: -- 19-MAY-2005 visuri GSCC Issues bug 4363854 --
42: -- 07/14/05 adrao Bug#4448994 added API Get_Region_Code_TL_Data --

Line 40: -- attribute long label in ak_region_items --

36: -- and updated UPDATE_REGION_ITEM_ATTR
37: -- 01/08/05 mdamle Add Url to AK_REGION_ITEMS routines --
38: -- 02/01/05 mdamle Add order_sequence, direction to AK_REGION_ITEMS --
39: -- 04/26/05 ankagarw bug#4194925 - saving measure display name as --
40: -- attribute long label in ak_region_items --
41: -- 19-MAY-2005 visuri GSCC Issues bug 4363854 --
42: -- 07/14/05 adrao Bug#4448994 added API Get_Region_Code_TL_Data --
43: -- 10/04/05 adrao Added field Grand_Total_Flag to Bis_Region_Item_Rec_Type
44: -- for Bug#4594984

Line 47: -- 06/19/2006 ankgoel Bug#5256605 - Support MLS for AK Region Items --

43: -- 10/04/05 adrao Added field Grand_Total_Flag to Bis_Region_Item_Rec_Type
44: -- for Bug#4594984
45: -- 01/20/2006 psomesul Bug#4652028 added a new Function GetMeasureName |
46: -- 02/07/2006 hengliu Bug#4955493 Do not overwrite global menu/title --
47: -- 06/19/2006 ankgoel Bug#5256605 - Support MLS for AK Region Items --
48: -- 10/20/06 akoduri Bug#5584162 - Enable Sort For Percent Of Total
49: ----------------------------------------------------------------------------
50: -- Defaults
51: c_BOLD constant varchar2(1) := 'N';

Line 158: , Item_Style AK_REGION_ITEMS.ITEM_STYLE%TYPE

154: , Hide_Target_In_Table VARCHAR2(1)
155: , Parameter_Render_Type VARCHAR2(30)
156: , Privilege VARCHAR2(150)
157: , Grand_Total_Flag BIS_AK_REGION_ITEM_EXTENSION.ATTRIBUTE26%TYPE
158: , Item_Style AK_REGION_ITEMS.ITEM_STYLE%TYPE
159: , Nested_Region_Code AK_REGION_ITEMS.NESTED_REGION_CODE%TYPE
160: , Nested_Region_Application_Id AK_REGION_ITEMS.NESTED_REGION_APPLICATION_ID%TYPE
161: );
162:

Line 159: , Nested_Region_Code AK_REGION_ITEMS.NESTED_REGION_CODE%TYPE

155: , Parameter_Render_Type VARCHAR2(30)
156: , Privilege VARCHAR2(150)
157: , Grand_Total_Flag BIS_AK_REGION_ITEM_EXTENSION.ATTRIBUTE26%TYPE
158: , Item_Style AK_REGION_ITEMS.ITEM_STYLE%TYPE
159: , Nested_Region_Code AK_REGION_ITEMS.NESTED_REGION_CODE%TYPE
160: , Nested_Region_Application_Id AK_REGION_ITEMS.NESTED_REGION_APPLICATION_ID%TYPE
161: );
162:
163: TYPE Bis_Region_Item_Tbl_Type IS TABLE OF Bis_Region_Item_Rec_Type

Line 160: , Nested_Region_Application_Id AK_REGION_ITEMS.NESTED_REGION_APPLICATION_ID%TYPE

156: , Privilege VARCHAR2(150)
157: , Grand_Total_Flag BIS_AK_REGION_ITEM_EXTENSION.ATTRIBUTE26%TYPE
158: , Item_Style AK_REGION_ITEMS.ITEM_STYLE%TYPE
159: , Nested_Region_Code AK_REGION_ITEMS.NESTED_REGION_CODE%TYPE
160: , Nested_Region_Application_Id AK_REGION_ITEMS.NESTED_REGION_APPLICATION_ID%TYPE
161: );
162:
163: TYPE Bis_Region_Item_Tbl_Type IS TABLE OF Bis_Region_Item_Rec_Type
164: INDEX BY BINARY_INTEGER;

Line 508: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE

504: -- rpenneru Added for enh#3757005
505: PROCEDURE GET_REGION_ITEM_REC
506: ( p_region_code IN VARCHAR2
507: , p_region_application_id IN NUMBER
508: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
509: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
510: , x_Region_Item_Rec OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
511: , x_return_status OUT NOCOPY VARCHAR2
512: , x_msg_count OUT NOCOPY NUMBER

Line 509: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE

505: PROCEDURE GET_REGION_ITEM_REC
506: ( p_region_code IN VARCHAR2
507: , p_region_application_id IN NUMBER
508: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
509: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
510: , x_Region_Item_Rec OUT NOCOPY BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
511: , x_return_status OUT NOCOPY VARCHAR2
512: , x_msg_count OUT NOCOPY NUMBER
513: , x_msg_data OUT NOCOPY VARCHAR2

Line 520: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE

516: PROCEDURE UPDATE_REGION_ITEM_ATTR
517: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
518: , p_region_code IN VARCHAR2
519: , p_region_application_id IN NUMBER
520: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
521: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
522: , p_Short_Name IN VARCHAR2
523: , x_return_status OUT NOCOPY VARCHAR2
524: , x_msg_count OUT NOCOPY NUMBER

Line 521: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE

517: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
518: , p_region_code IN VARCHAR2
519: , p_region_application_id IN NUMBER
520: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
521: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
522: , p_Short_Name IN VARCHAR2
523: , x_return_status OUT NOCOPY VARCHAR2
524: , x_msg_count OUT NOCOPY NUMBER
525: , x_msg_data OUT NOCOPY VARCHAR2

Line 532: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE

528: PROCEDURE UPDATE_REGION_ITEM_ATTR
529: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
530: , p_region_code IN VARCHAR2
531: , p_region_application_id IN NUMBER
532: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
533: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
534: , p_Short_Name IN VARCHAR2
535: , p_type IN VARCHAR2
536: , p_Meas_Name IN VARCHAR2

Line 533: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE

529: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
530: , p_region_code IN VARCHAR2
531: , p_region_application_id IN NUMBER
532: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
533: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
534: , p_Short_Name IN VARCHAR2
535: , p_type IN VARCHAR2
536: , p_Meas_Name IN VARCHAR2
537: , x_return_status OUT NOCOPY VARCHAR2

Line 567: --return true if any only if p_compare_code refers to a valid entry in ak_region_items which

563: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
564: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
565: ) RETURN BOOLEAN;
566:
567: --return true if any only if p_compare_code refers to a valid entry in ak_region_items which
568: --subsequently refers to a valid measure
569: FUNCTION VALIDATE_COMPARE(
570: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
571: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

Line 570: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE

566:
567: --return true if any only if p_compare_code refers to a valid entry in ak_region_items which
568: --subsequently refers to a valid measure
569: FUNCTION VALIDATE_COMPARE(
570: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
571: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
572: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
573: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
574: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE

Line 571: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

567: --return true if any only if p_compare_code refers to a valid entry in ak_region_items which
568: --subsequently refers to a valid measure
569: FUNCTION VALIDATE_COMPARE(
570: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
571: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
572: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
573: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
574: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
575: ) RETURN BOOLEAN;

Line 572: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type

568: --subsequently refers to a valid measure
569: FUNCTION VALIDATE_COMPARE(
570: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
571: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
572: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
573: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
574: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
575: ) RETURN BOOLEAN;
576:

Line 578: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE

574: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
575: ) RETURN BOOLEAN;
576:
577: FUNCTION AK_DATA_SET(
578: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
579: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
580: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
581: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
582: ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE

Line 579: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

575: ) RETURN BOOLEAN;
576:
577: FUNCTION AK_DATA_SET(
578: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
579: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
580: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
581: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
582: ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
583: ) RETURN VARCHAR2;

Line 580: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type

576:
577: FUNCTION AK_DATA_SET(
578: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
579: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
580: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
581: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
582: ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
583: ) RETURN VARCHAR2;
584:

Line 581: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type

577: FUNCTION AK_DATA_SET(
578: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
579: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
580: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
581: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
582: ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
583: ) RETURN VARCHAR2;
584:
585: --return 'T' if given report is view based, 'F' otherwise

Line 600: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE

596:
597: --return 'T' if at least one aggregate function is defined in any column
598: --for the given report, 'F' otherwise
599: FUNCTION IS_AGGREGATE_DEFINED(
600: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
601: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
602: ) RETURN VARCHAR2;
603:
604:

Line 601: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

597: --return 'T' if at least one aggregate function is defined in any column
598: --for the given report, 'F' otherwise
599: FUNCTION IS_AGGREGATE_DEFINED(
600: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
601: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
602: ) RETURN VARCHAR2;
603:
604:
605: -- added for Bug#4448994 and as a general utility file.