1 package BIS_PostActual as
2 /* $Header: BISPACTS.pls 120.1 2005/10/06 06:58:30 ankgoel noship $ */
3
4 TYPE t_orgTable is TABLE of VARCHAR2(30)
5 INDEX BY BINARY_INTEGER;
6
7 --
8 -- Inserts 1 row into bis_actual_values
9 --
10 PROCEDURE Post_Actual
11 ( x_target_lvl_short_name IN VARCHAR2
12 , x_organization_id IN NUMBER
13 , x_actual_value IN NUMBER
14 , x_timestamp IN DATE DEFAULT NULL
15 , x_DIMENSION1_LEVEL_VALUE IN VARCHAR2 DEFAULT NULL
16 , x_DIMENSION2_LEVEL_VALUE IN VARCHAR2 DEFAULT NULL
17 , x_DIMENSION3_LEVEL_VALUE IN VARCHAR2 DEFAULT NULL
18 , x_DIMENSION4_LEVEL_VALUE IN VARCHAR2 DEFAULT NULL
19 , x_DIMENSION5_LEVEL_VALUE IN VARCHAR2 DEFAULT NULL
20 );
21
22 --
23 -- Gets the orgs that users have chosen to view KPIs for on the Configurable
24 -- Homepage. the index of x_orgtable is the org_id, and the value is the
25 -- most recent start_date||'+'||end_date for that target level and that org.
26 --
27 /*PROCEDURE get_trgt_level_orgs
28 ( p_target_lvl_short_name IN VARCHAR2
29 , x_orgtable OUT NOCOPY t_orgTable
30 );*/
31
32 --
33 -- Gets the most recent start_end date for for p_period_type as defined
34 -- in p_calendar if the calendar or the period is invalid,
35 -- to_char(sysdate)||'+'||to_char(sysdate) is returned. if no data found,
36 -- an empty string is passed back.
37 --
38 FUNCTION Get_Start_End_Date
39 ( p_calendar IN VARCHAR2
40 , p_period_type IN VARCHAR2
41 )
42 RETURN VARCHAR2;
43
44 --
45 -- Gets the set of books id for p_organization_id
46 --
47 /*PROCEDURE Get_SOB
48 ( p_organization_id IN NUMBER
49 , x_sob OUT NOCOPY NUMBER
50 , x_msg OUT NOCOPY VARCHAR2
51 ) ;*/
52
53 --
54 -- Gets the calendar used by p_organization_id at p_target_level_name.
55 -- if the organization does not have a valid sob, the default calendar
56 -- 'Accounting' is returned.
57 --
58 /*PROCEDURE Get_Indicator_Calendar
59 ( p_target_lvl_short_name IN VARCHAR2
60 , p_organization_id IN NUMBER
61 , x_calendar OUT NOCOPY VARCHAR2
62 , x_msg OUT NOCOPY VARCHAR2
63 ) ;*/
64
65 end BIS_PostActual;
[Home] [Help]