1 package FPA_Utils_PVT as
2 /* $Header: FPAVUTIS.pls 120.1 2005/08/18 11:02:17 appldev noship $ */
3
4 --The procedure Get_Scenario_Wscore_Color is used to compare the
5 --scenario weighted score against the Planning Cycle From and To
6 --weighted score targets.
7 --It returns the appropriate color.
8 function Get_Scenario_Wscore_Color(
9 p_pc_id IN number
10 ,p_scenario_id IN number
11 ) return varchar2;
12
13 --The procedure Get_Scenario_NPV_Color is used to compare the
14 --scenario NPV against the Planning Cycle From and To
15 --NPV targets.
16 --It returns the appropriate color.
17 function Get_Scenario_NPV_Color(
18 p_pc_id IN number
19 ,p_scenario_id IN number
20 ) return varchar2;
21
22 --The procedure Get_Scenario_ROI_Color is used to compare the
23 --scenario ROI against the Planning Cycle From and To
24 --ROI targets.
25 --It returns the appropriate color.
26 function Get_Scenario_ROI_Color(
27 p_pc_id IN number
28 ,p_scenario_id IN number
29 ) return varchar2;
30
31 --This procedure is used by the UI to determine which icon to render
32 --in the PC Checklist Table.
33 --It evaluates the Planning Cycle status and lookup code. Depending on
34 --combination of these returns the appropriate value.
35 function Determine_PC_Checklist_status(
36 p_pc_id IN number
37 ,p_lookup_code IN varchar2
38 ) return varchar2;
39
40 -- This function determines if an organization is member of the
41 -- Organization hierarchy set in the PJP Profile Option
42 function Is_Org_In_PJP_Org_Hier(
43 p_org_id IN number
44 ) return number;
45
46 -- This function validates if a Class code can be assigned to a new Portfolio.
47 function Is_Class_Code_Available(
48 p_class_code IN number
49 ,p_org_id IN number
50 ) return varchar2;
51
52 -- This function validates if an Organization can be assigned to a new Portfolio.
53 function Is_Organization_Available(
54 p_org_id IN number
55 ,p_class_code IN number
56 ) return varchar2;
57
58 procedure load_gl_calendar (
59 p_api_version IN NUMBER,
60 p_commit IN VARCHAR2,
61 p_calendar_name IN VARCHAR2,
62 p_period_type IN VARCHAR2,
63 p_cal_period_type IN VARCHAR2,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER );
67
68
69 -- Function call to check if one or more scenarios were recommended in this planning cycle.
70 -- This is one of the conditions to be met prior to enabling 'Recommend plan" icon on PC checklist page
71 function scenarios_recommended(
72 p_planning_cycle_id IN NUMBER
73 )
74 return varchar2;
75
76 function scenario_approved(
77 p_planning_cycle_id IN NUMBER
78 )
79 return varchar2;
80
81 procedure get_inv_category_name(
82 p_planning_cycle_id in number,
83 x_inv_category_name out nocopy varchar2
84 );
85
86 procedure get_approver_name(
87 p_portfolio_id in number,
88 x_approver_names out nocopy varchar2
89 );
90
91 -- Function to retrun the Units of Measure
92 function Get_Fin_Metric_Unit(
93 p_planning_cycle_id IN NUMBER,
94 p_metric_code IN VARCHAR2
95 ) return VARCHAR2;
96
97 /****END: Section for common API messages, exception handling and logging.******
98 ********************************************************************************/
99
100 end FPA_Utils_PVT;