APPS.BSC_DIMENSION_SETS_PUB dependencies on BSC_KPI_DIM_SETS_TL

Line 25: | accomodate BSC_KPI_DIM_SETS_TL.SHORT_NAME |

21: | PAJOHRI 21-MAR-2003 Added Bsc_Dim_Set_Rec_Type.Bsc_View_Name |
22: | Added Bsc_Dim_Set_Rec_Type.Bsc_Analysis_Id |
23: | 19-SEP-2003 ADRAO Added API Reorder_Dim_Level |
24: | 18-JUN-2004 ADRAO Modified Record Bsc_Dim_Set_Rec_Type to |
25: | accomodate BSC_KPI_DIM_SETS_TL.SHORT_NAME |
26: | 07-DEC-2004 ADRAO Added constants C_REL_ONE_TO_MANY and |
27: | C_REL_MANY_TO_MANY for Bug4052221 |
28: +======================================================================================+
29: */

Line 42: , Bsc_Dim_Set_Id BSC_KPI_DIM_SETS_TL.dim_set_id%TYPE

38: , Bsc_Dim_Level_Group_Id BSC_KPI_DIM_GROUPS.dim_group_id%TYPE
39: , Bsc_Dim_Level_Group_Index BSC_KPI_DIM_GROUPS.dim_group_index%TYPE
40: , Bsc_Dim_Level_Help BSC_KPI_DIM_LEVELS_TL.Help%TYPE
41: , Bsc_Dim_Level_Long_Name BSC_KPI_DIM_LEVELS_TL.Name%TYPE
42: , Bsc_Dim_Set_Id BSC_KPI_DIM_SETS_TL.dim_set_id%TYPE
43: , Bsc_Dim_Set_Name BSC_KPI_DIM_SETS_TL.name%TYPE
44: , Bsc_Dim_Tot_Disp_Name BSC_KPI_DIM_LEVELS_TL.Comp_Disp_Name%TYPE
45: , Bsc_Dset_Comp_Order BSC_KPI_DIM_LEVELS_B.comp_order_by%TYPE
46: , Bsc_Dset_Default_Key_Value BSC_KPI_DIM_LEVELS_B.default_key_value%TYPE

Line 43: , Bsc_Dim_Set_Name BSC_KPI_DIM_SETS_TL.name%TYPE

39: , Bsc_Dim_Level_Group_Index BSC_KPI_DIM_GROUPS.dim_group_index%TYPE
40: , Bsc_Dim_Level_Help BSC_KPI_DIM_LEVELS_TL.Help%TYPE
41: , Bsc_Dim_Level_Long_Name BSC_KPI_DIM_LEVELS_TL.Name%TYPE
42: , Bsc_Dim_Set_Id BSC_KPI_DIM_SETS_TL.dim_set_id%TYPE
43: , Bsc_Dim_Set_Name BSC_KPI_DIM_SETS_TL.name%TYPE
44: , Bsc_Dim_Tot_Disp_Name BSC_KPI_DIM_LEVELS_TL.Comp_Disp_Name%TYPE
45: , Bsc_Dset_Comp_Order BSC_KPI_DIM_LEVELS_B.comp_order_by%TYPE
46: , Bsc_Dset_Default_Key_Value BSC_KPI_DIM_LEVELS_B.default_key_value%TYPE
47: , Bsc_Dset_Default_Type BSC_KPI_DIM_LEVELS_B.default_type%TYPE

Line 86: , Bsc_Dim_Set_Short_Name BSC_KPI_DIM_SETS_TL.SHORT_NAME%TYPE

82: , Bsc_Creation_Date DATE -- PMD WHO COLUMN
83: , Bsc_Last_Updated_By NUMBER -- PMD WHO COLUMN
84: , Bsc_Last_Update_Date DATE -- PMD WHO COLUMN
85: , Bsc_Last_Update_Login NUMBER -- PMD WHO COLUMN
86: , Bsc_Dim_Set_Short_Name BSC_KPI_DIM_SETS_TL.SHORT_NAME%TYPE
87: );
88:
89: TYPE Bsc_Dim_Set_Tbl_Type IS TABLE OF Bsc_Dim_Set_Rec_Type
90: INDEX BY BINARY_INTEGER;

Line 126: procedure Create_Bsc_Kpi_Dim_Sets_Tl(

122: ,x_msg_count OUT NOCOPY number
123: ,x_msg_data OUT NOCOPY varchar2
124: );
125:
126: procedure Create_Bsc_Kpi_Dim_Sets_Tl(
127: p_commit IN varchar2 := FND_API.G_FALSE
128: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
129: ,x_return_status OUT NOCOPY varchar2
130: ,x_msg_count OUT NOCOPY number

Line 134: procedure Retrieve_Bsc_Kpi_Dim_Sets_Tl(

130: ,x_msg_count OUT NOCOPY number
131: ,x_msg_data OUT NOCOPY varchar2
132: );
133:
134: procedure Retrieve_Bsc_Kpi_Dim_Sets_Tl(
135: p_commit IN varchar2 := FND_API.G_FALSE
136: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
137: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
138: ,x_return_status OUT NOCOPY varchar2

Line 143: procedure Update_Bsc_Kpi_Dim_Sets_Tl(

139: ,x_msg_count OUT NOCOPY number
140: ,x_msg_data OUT NOCOPY varchar2
141: );
142:
143: procedure Update_Bsc_Kpi_Dim_Sets_Tl(
144: p_commit IN varchar2 := FND_API.G_FALSE
145: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
146: ,x_return_status OUT NOCOPY varchar2
147: ,x_msg_count OUT NOCOPY number

Line 151: procedure Delete_Bsc_Kpi_Dim_Sets_Tl(

147: ,x_msg_count OUT NOCOPY number
148: ,x_msg_data OUT NOCOPY varchar2
149: );
150:
151: procedure Delete_Bsc_Kpi_Dim_Sets_Tl(
152: p_commit IN varchar2 := FND_API.G_FALSE
153: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
154: ,x_return_status OUT NOCOPY varchar2
155: ,x_msg_count OUT NOCOPY number