PACKAGE: APPS.ZPB_SOLVE

Source

1 PACKAGE ZPB_SOLVE AUTHID CURRENT_USER AS
2 /* $Header: zpbsolve.pls 120.3 2007/12/04 15:47:27 mbhat ship $ */
3 TYPE ref_cursor IS REF CURSOR;
4 TYPE MemberList is table of VARCHAR2(50);
5 TYPE MemberNameList is table of VARCHAR2(256);
6 TYPE MemberOrderList is table of NUMBER;
7 TYPE MemberSourceType is table of NUMBER;
8 TYPE DimensionType is table of VARCHAR2(50);
9   propagateList MemberList;
10   propagateName MemberNameList;
11   propagateOrder MemberOrderList;
12   propagateSourceType MemberSourceType;
13   propagateDefDHDimList DimensionType;
14   propagateDefInputSelDimList DimensionType;
15 
16   LOADED_SOURCE INTEGER := 1000;
17   WS_INPUT_SOURCE INTEGER := 1100;
18   INIT_WS_INPUT_SOURCE INTEGER := 1130;
19   AGGREGATED_SOURCE INTEGER := 1160;
20   CALCULATED_SOURCE INTEGER := 1200;
21   iTrueValue   INTEGER  := 1;
22   iFalseValue  INTEGER := 0;
23   PROCEDURE propagateSolve (
24                        p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
25                        p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
26                        p_view_dim_name IN VARCHAR2,
27                        p_view_member_column IN VARCHAR2,
28                        p_view_short_lbl_column IN VARCHAR2,
29                        p_prop_calc IN INTEGER,
30                        p_prop_alloc IN INTEGER,
31                        p_prop_input IN INTEGER,
32                        p_prop_output IN INTEGER,
33                        p_prop_dimhandling IN INTEGER);
34 
35   FUNCTION getDimSettingMeaning(
36                        p_lookup_code IN FND_LOOKUP_VALUES_VL.LOOKUP_CODE%TYPE
37                        ) RETURN VARCHAR2;
38 
39   PROCEDURE updateCleanup(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
40                         p_line_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
41                         p_src_type IN ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE);
42 
43  PROCEDURE deleteOutputSelections(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
44                                   p_targetIndex IN INTEGER );
45  PROCEDURE  insertDefaultOutput(p_ac_id IN ZPB_SOLVE_OUTPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
46                         p_line_member IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER%TYPE,
47                         p_memberOrder IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER_ORDER%TYPE,
48                         p_dimension IN ZPB_SOLVE_OUTPUT_SELECTIONS.DIMENSION%TYPE);
49 
50  PROCEDURE initialize_solve_selections
51     (p_ac_id   IN zpb_analysis_cycles.analysis_cycle_id%TYPE);
52 
53 procedure run_solve (errbuf out nocopy varchar2,
54                      retcode out nocopy varchar2,
55                      p_business_area_id in number,
56 			   p_instance_id in number);
57 
58 
59 
60 END ZPB_SOLVE;