1 package FPA_SCORECARDS_PKG as
2 /* $Header: FPASSCRS.pls 120.2 2005/09/29 13:20:08 ashariff noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_PROJECT_ID in NUMBER,
6 X_STRATEGIC_OBJ_ID in NUMBER,
7 X_SCENARIO_ID in NUMBER,
8 X_COMMENTS in VARCHAR2,
9 X_CREATION_DATE in DATE,
10 X_CREATED_BY in NUMBER,
11 X_LAST_UPDATE_DATE in DATE,
12 X_LAST_UPDATED_BY in NUMBER,
13 X_LAST_UPDATE_LOGIN in NUMBER);
14 procedure LOCK_ROW (
15 X_PROJECT_ID in NUMBER,
16 X_STRATEGIC_OBJ_ID in NUMBER,
17 X_SCENARIO_ID in NUMBER,
18 X_COMMENTS in VARCHAR2
19 );
20 procedure UPDATE_ROW (
21 X_PROJECT_ID in NUMBER,
22 X_STRATEGIC_OBJ_ID in NUMBER,
23 X_SCENARIO_ID in NUMBER,
24 X_COMMENTS in VARCHAR2,
25 X_LAST_UPDATE_DATE in DATE,
26 X_LAST_UPDATED_BY in NUMBER,
27 X_LAST_UPDATE_LOGIN in NUMBER
28 );
29 procedure DELETE_ROW (
30 X_PROJECT_ID in NUMBER,
31 X_STRATEGIC_OBJ_ID in NUMBER,
32 X_SCENARIO_ID in NUMBER
33 );
34 procedure ADD_LANGUAGE;
35
36 procedure TRANSLATE_ROW(
37 P_PROJECT_ID in NUMBER,
38 P_STRATEGIC_OBJ_ID in NUMBER,
39 P_SCENARIO_ID in NUMBER,
40 P_COMMENTS in VARCHAR2,
41 P_OWNER in VARCHAR2
42 );
43
44 procedure LOAD_ROW(
45 P_PROJECT_ID in NUMBER,
46 P_STRATEGIC_OBJ_ID in NUMBER,
47 P_SCENARIO_ID in NUMBER,
48 P_COMMENTS in VARCHAR2,
49 P_OWNER in VARCHAR2
50 );
51 end FPA_SCORECARDS_PKG;