1 PACKAGE BSC_UPDATE_VAL AS
2 /* $Header: BSCDVALS.pls 120.0 2005/06/01 15:36:12 appldev noship $ */
3
4
5 /*===========================================================================+
6 |
7 | Name: Delete_Invalid_Zero_Codes
8 |
9 | Description: This function delete zero codes from base tables
10 | that are not used for precalculated indicators.
11
12 +============================================================================*/
13 FUNCTION Delete_Invalid_Zero_Codes(
14 x_error_msg OUT NOCOPY VARCHAR2
15 ) RETURN BOOLEAN;
16
17
18 /*===========================================================================+
19 |
20 | Name: Is_Table_For_PreCalc_Kpi
21 |
22 | Description: This function returns TRUE if the given table
23 | (input or base table) affects a precalculated indicator.
24 |
25 +============================================================================*/
26 FUNCTION Is_Table_For_PreCalc_Kpi(
27 x_table IN VARCHAR2
28 ) RETURN BOOLEAN;
29
30
31 /*===========================================================================+
32 |
33 | Name: Validate_Codes
34 |
35 | Description: This function validates the user codes that come in the
36 | input table.
37 | If there are invalid codes then insert them into
38 | bsc_db_validation table.
39 |
40 | Parameters: x_input_table - input table name
41 |
42 | Returns: TRUE - input table doesn't have invalid codes
43 | FALSE - input table has invalid codes
44 | NULL - there was some error in the function. In
45 | this case this function add the error
46 | message in the error stack.
47 | Notes:
48 |
49 +============================================================================*/
50 FUNCTION Validate_Codes(
51 x_input_table IN VARCHAR2
52 ) RETURN BOOLEAN;
53
54 --LOCKING: new function
55 FUNCTION Validate_Codes_AT(
56 x_input_table IN VARCHAR2
57 ) RETURN BOOLEAN;
58
59
60 END BSC_UPDATE_VAL;