DBA Data[Home] [Help]

PACKAGE: APPS.BSC_CALCULATIONS_PVT

Source


1 PACKAGE BSC_CALCULATIONS_PVT AS
2 /* $Header: BSCVCLCS.pls 120.0.12000000.1 2007/07/17 07:44:34 appldev noship $ */
3 /*
4  +======================================================================================+
5  |    Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA                    |
6  |                         All rights reserved.                                         |
7  +======================================================================================+
8  | FILENAME                                                                             |
9  |                      BSCVCLCS.pls                                                    |
10  |                                                                                      |
11  | Creation Date:                                                                       |
12  |                      December 28, 2006                                               |
13  |                                                                                      |
14  | Creator:                                                                             |
15  |                      Pradeep Kishore Somesula                                        |
16  |                                                                                      |
17  | Description:                                                                         |
18  |                      Private Specs version.                                           |
19  |      This package handles calculations                                               |
20  |                                                                                      |
21  +======================================================================================+
22 */
23 
24 PROCEDURE delete_objective_calculation (
25   p_indicator            IN    bsc_kpi_calculations.indicator%TYPE,
26   p_calculation_id       IN    bsc_kpi_calculations.calculation_id%TYPE,
27   x_return_status      OUT   NOCOPY   VARCHAR2,
28   x_msg_count          OUT   NOCOPY   NUMBER,
29   x_msg_data           OUT   NOCOPY   VARCHAR2
30 );
31 
32 PROCEDURE insert_objective_calculation (
33   p_indicator            IN    bsc_kpi_calculations.indicator%TYPE,
34   p_calculation_id       IN    bsc_kpi_calculations.calculation_id%TYPE,
35   p_user_level0          IN    bsc_kpi_calculations.user_level0%TYPE,
36   p_user_level1          IN    bsc_kpi_calculations.user_level1%TYPE,
37   p_user_level1_default  IN    bsc_kpi_calculations.user_level1_default%TYPE,
38   p_user_level2          IN    bsc_kpi_calculations.user_level2%TYPE,
39   p_user_level2_default  IN    bsc_kpi_calculations.user_level2_default%TYPE,
40   p_default_value        IN    bsc_kpi_calculations.default_value%TYPE,
41   x_return_status      OUT   NOCOPY   VARCHAR2,
42   x_msg_count          OUT   NOCOPY   NUMBER,
43   x_msg_data           OUT   NOCOPY   VARCHAR2
44 );
45 
46 
47 END BSC_CALCULATIONS_PVT;