[Home] [Help]
PACKAGE: APPS.FPA_SCORECARDS_PVT
Source
1 PACKAGE FPA_SCORECARDS_PVT AUTHID CURRENT_USER as
2 /* $Header: FPAVSCRS.pls 120.2 2005/08/18 11:50:19 appldev noship $ */
3 G_API_NAME CONSTANT VARCHAR2(80) := 'FPA_SCORECARDS_PVT';
4
5 TYPE FPA_SCORECARD_REC_TYPE IS RECORD (
6 STRATEGIC_OBJ_ID NUMBER,
7 NEW_SCORE NUMBER,
8 COMMENTS VARCHAR2(2000)
9 );
10
11 TYPE FPA_SCORECARD_TBL_TYPE IS TABLE OF FPA_SCORECARD_REC_TYPE
12 INDEX BY BINARY_INTEGER;
13
14 SUBTYPE FPA_SCORECARDS_TL_REC IS FPA_SCORECARDS_TL%ROWTYPE;
15
16 /* ***********************************************************************
17 Desc:
18 parameters:
19 return:
20 ***************************************************************************/
21
22 PROCEDURE Update_Calc_Pjt_Scorecard_Aw
23 (
24 p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26 p_commit IN VARCHAR2 := FND_API.G_FALSE,
27 p_planning_cycle_id IN NUMBER,
28 p_project_id IN NUMBER,
29 p_scorecard_tbl IN FPA_SCORECARDS_PVT.FPA_SCORECARD_TBL_TYPE,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2
33 );
34
35 PROCEDURE Update_Calc_Scen_Scorecard_Aw
36 (
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39 p_commit IN VARCHAR2 := FND_API.G_FALSE,
40 p_planning_cycle_id IN NUMBER,
41 p_scenario_id IN NUMBER,
42 p_project_id IN NUMBER,
43 p_scorecard_tbl IN FPA_SCORECARDS_PVT.FPA_SCORECARD_TBL_TYPE,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2
47 );
48
49 PROCEDURE Calc_Scenario_Wscores_Aw
50 (
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53 p_scenario_id IN NUMBER,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59 PROCEDURE Update_Scenario_App_Scores
60 (
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63 p_scenario_id IN NUMBER,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE insert_tl_rec
70 (
71 p_init_msg_list IN VARCHAR2,
72 p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 x_return_status OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE Handle_Comments
79 (
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82 p_scenario_id IN NUMBER,
83 p_type IN VARCHAR2,
84 p_source_scenario_id IN NUMBER,
85 p_delete_project_id IN NUMBER,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 FUNCTION Read_Only
92 (
93 p_planning_cycle_id IN NUMBER,
94 p_scenario_id IN NUMBER) RETURN VARCHAR2;
95
96 END FPA_SCORECARDS_PVT;