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.BSC_ANALYSIS_OPTION_PVT dependencies on BSC_ANALYSIS_OPTION_PUB

Line 35: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

31: C_API_CREATE CONSTANT VARCHAR2(6) := 'CREATE';
32:
33: procedure Create_Analysis_Options(
34: p_commit IN varchar2 -- := FND_API.G_FALSE
35: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
36: ,x_return_status OUT NOCOPY varchar2
37: ,x_msg_count OUT NOCOPY number
38: ,x_msg_data OUT NOCOPY varchar2
39: );

Line 44: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

40:
41: procedure Retrieve_Analysis_Options
42: (
43: p_commit IN varchar2 -- := FND_API.G_FALSE
44: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
45: , x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
46: , p_data_source IN VARCHAR2
47: , x_return_status OUT NOCOPY varchar2
48: , x_msg_count OUT NOCOPY number

Line 45: , x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

41: procedure Retrieve_Analysis_Options
42: (
43: p_commit IN varchar2 -- := FND_API.G_FALSE
44: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
45: , x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
46: , p_data_source IN VARCHAR2
47: , x_return_status OUT NOCOPY varchar2
48: , x_msg_count OUT NOCOPY number
49: , x_msg_data OUT NOCOPY varchar2

Line 55: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

51:
52: procedure Update_Analysis_Options
53: (
54: p_commit IN varchar2 -- := FND_API.G_FALSE
55: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
56: , p_data_source IN VARCHAR2
57: , x_return_status OUT NOCOPY VARCHAR2
58: , x_msg_count OUT NOCOPY NUMBER
59: , x_msg_data OUT NOCOPY VARCHAR2

Line 64: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

60: );
61:
62: procedure Delete_Analysis_Options(
63: p_commit IN varchar2 -- := FND_API.G_FALSE
64: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
65: ,x_return_status OUT NOCOPY varchar2
66: ,x_msg_count OUT NOCOPY number
67: ,x_msg_data OUT NOCOPY varchar2
68: );

Line 72: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

68: );
69:
70: procedure Create_Analysis_Measures(
71: p_commit IN varchar2 -- := FND_API.G_FALSE
72: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
73: ,x_return_status OUT NOCOPY varchar2
74: ,x_msg_count OUT NOCOPY number
75: ,x_msg_data OUT NOCOPY varchar2
76: );

Line 80: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

76: );
77:
78: procedure Retrieve_Analysis_Measures(
79: p_commit IN varchar2 -- := FND_API.G_FALSE
80: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
81: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
82: ,x_return_status OUT NOCOPY varchar2
83: ,x_msg_count OUT NOCOPY number
84: ,x_msg_data OUT NOCOPY varchar2

Line 81: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

77:
78: procedure Retrieve_Analysis_Measures(
79: p_commit IN varchar2 -- := FND_API.G_FALSE
80: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
81: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
82: ,x_return_status OUT NOCOPY varchar2
83: ,x_msg_count OUT NOCOPY number
84: ,x_msg_data OUT NOCOPY varchar2
85: );

Line 89: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

85: );
86:
87: procedure Update_Analysis_Measures(
88: p_commit IN varchar2 -- := FND_API.G_FALSE
89: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
90: ,x_return_status OUT NOCOPY varchar2
91: ,x_msg_count OUT NOCOPY number
92: ,x_msg_data OUT NOCOPY varchar2
93: );

Line 97: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

93: );
94:
95: procedure Delete_Data_Series(
96: p_commit IN varchar2 -- := FND_API.G_FALSE
97: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
98: ,x_return_status OUT NOCOPY varchar2
99: ,x_msg_count OUT NOCOPY number
100: ,x_msg_data OUT NOCOPY varchar2
101: );

Line 105: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

101: );
102:
103: procedure Delete_Analysis_Measures(
104: p_commit IN varchar2 -- := FND_API.G_FALSE
105: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
106: ,x_return_status OUT NOCOPY varchar2
107: ,x_msg_count OUT NOCOPY number
108: ,x_msg_data OUT NOCOPY varchar2
109: );

Line 126: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

122: /***********************************************************/
123: PROCEDURE Delete_Ana_Opt_Mult_Groups
124: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
125: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
126: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
127: , p_max_group_count IN NUMBER
128: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
129: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
130: , x_return_status OUT NOCOPY VARCHAR2

Line 128: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

124: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
125: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
126: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
127: , p_max_group_count IN NUMBER
128: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
129: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
130: , x_return_status OUT NOCOPY VARCHAR2
131: , x_msg_count OUT NOCOPY NUMBER
132: , x_msg_data OUT NOCOPY VARCHAR2

Line 129: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

125: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
126: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
127: , p_max_group_count IN NUMBER
128: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
129: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
130: , x_return_status OUT NOCOPY VARCHAR2
131: , x_msg_count OUT NOCOPY NUMBER
132: , x_msg_data OUT NOCOPY VARCHAR2
133: );

Line 139: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

135: PROCEDURE Synch_Kpi_Anal_Group
136: (
137: p_commit IN VARCHAR2:=FND_API.G_FALSE
138: , p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE
139: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
140: , x_return_status OUT NOCOPY VARCHAR2
141: , x_msg_count OUT NOCOPY NUMBER
142: , x_msg_data OUT NOCOPY VARCHAR2
143: );

Line 148: , x_Anal_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

144:
145:
146: PROCEDURE store_anal_opt_grp_count
147: ( p_kpi_id IN NUMBER
148: , x_Anal_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
149: ) ;
150:
151:
152: -- Added for Start-to-End KPI Project, Bug#3691035

Line 172: p_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

168: , x_msg_count OUT NOCOPY NUMBER
169: , x_msg_data OUT NOCOPY VARCHAR2
170: );
171: PROCEDURE delete_extra_series(
172: p_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_msg_count OUT NOCOPY NUMBER
175: , x_msg_data OUT NOCOPY VARCHAR2
176: );

Line 180: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

176: );
177:
178: procedure Swap_Data_Series_Id(
179: p_commit IN varchar2 -- := FND_API.G_FALSE
180: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
181: ,x_return_status OUT NOCOPY varchar2
182: ,x_msg_count OUT NOCOPY number
183: ,x_msg_data OUT NOCOPY varchar2
184: ) ;

Line 229: p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

225: );
226:
227: FUNCTION Validate_If_single_Anal_Opt
228: (
229: p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
230:
231: )RETURN BOOLEAN;
232:
233: PROCEDURE Initialize_Anal_Opt_Tbl

Line 236: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

232:
233: PROCEDURE Initialize_Anal_Opt_Tbl
234: (
235: p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
236: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
237: , p_max_group_count IN NUMBER
238: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
239: , p_Anal_Det_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type
240: );

Line 238: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

234: (
235: p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
236: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
237: , p_max_group_count IN NUMBER
238: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
239: , p_Anal_Det_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type
240: );
241:
242: PROCEDURE Set_Default_Analysis_Option

Line 239: , p_Anal_Det_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type

235: p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
236: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
237: , p_max_group_count IN NUMBER
238: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
239: , p_Anal_Det_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type
240: );
241:
242: PROCEDURE Set_Default_Analysis_Option
243: (

Line 246: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

242: PROCEDURE Set_Default_Analysis_Option
243: (
244: p_commit IN VARCHAR2
245: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
246: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
247: , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE
248: , x_return_status OUT NOCOPY VARCHAR2
249: , x_msg_count OUT NOCOPY NUMBER
250: , x_msg_data OUT NOCOPY VARCHAR2