APPS.FPA_SCORECARDS_PKG dependencies on FPA_SCORECARDS_TL

Line 15: cursor C is select ROWID from FPA_SCORECARDS_TL

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from FPA_SCORECARDS_TL
16: where PROJECT_ID = X_PROJECT_ID
17: and STRATEGIC_OBJ_ID = X_STRATEGIC_OBJ_ID
18: and SCENARIO_ID = X_SCENARIO_ID
19: and LANGUAGE = userenv('LANG')

Line 22: insert into FPA_SCORECARDS_TL (

18: and SCENARIO_ID = X_SCENARIO_ID
19: and LANGUAGE = userenv('LANG')
20: ;
21: begin
22: insert into FPA_SCORECARDS_TL (
23: PROJECT_ID,
24: STRATEGIC_OBJ_ID,
25: COMMENTS,
26: CREATED_BY,

Line 50: from FPA_SCORECARDS_TL T

46: from FND_LANGUAGES L
47: where L.INSTALLED_FLAG in ('I', 'B')
48: and not exists
49: (select NULL
50: from FPA_SCORECARDS_TL T
51: where T.PROJECT_ID = X_PROJECT_ID
52: and T.STRATEGIC_OBJ_ID = X_STRATEGIC_OBJ_ID
53: and T.SCENARIO_ID = X_SCENARIO_ID
54: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 75: from FPA_SCORECARDS_TL

71: ) is
72: cursor c1 is select
73: COMMENTS,
74: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
75: from FPA_SCORECARDS_TL
76: where PROJECT_ID = X_PROJECT_ID
77: and STRATEGIC_OBJ_ID = X_STRATEGIC_OBJ_ID
78: and SCENARIO_ID = X_SCENARIO_ID
79: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 107: update FPA_SCORECARDS_TL set

103: X_LAST_UPDATED_BY in NUMBER,
104: X_LAST_UPDATE_LOGIN in NUMBER
105: ) is
106: begin
107: update FPA_SCORECARDS_TL set
108: COMMENTS = X_COMMENTS,
109: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
110: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
111: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 129: delete from FPA_SCORECARDS_TL

125: X_STRATEGIC_OBJ_ID in NUMBER,
126: X_SCENARIO_ID in NUMBER
127: ) is
128: begin
129: delete from FPA_SCORECARDS_TL
130: where PROJECT_ID = X_PROJECT_ID
131: and STRATEGIC_OBJ_ID = X_STRATEGIC_OBJ_ID
132: and SCENARIO_ID = X_SCENARIO_ID;
133:

Line 143: update FPA_SCORECARDS_TL T set (

139:
140: procedure ADD_LANGUAGE
141: is
142: begin
143: update FPA_SCORECARDS_TL T set (
144: COMMENTS
145: ) = (select
146: B.COMMENTS
147: from FPA_SCORECARDS_TL B

Line 147: from FPA_SCORECARDS_TL B

143: update FPA_SCORECARDS_TL T set (
144: COMMENTS
145: ) = (select
146: B.COMMENTS
147: from FPA_SCORECARDS_TL B
148: where B.PROJECT_ID = T.PROJECT_ID
149: and B.STRATEGIC_OBJ_ID = T.STRATEGIC_OBJ_ID
150: and B.SCENARIO_ID = T.SCENARIO_ID
151: and B.LANGUAGE = T.SOURCE_LANG)

Line 162: from FPA_SCORECARDS_TL SUBB, FPA_SCORECARDS_TL SUBT

158: SUBT.PROJECT_ID,
159: SUBT.STRATEGIC_OBJ_ID,
160: SUBT.SCENARIO_ID,
161: SUBT.LANGUAGE
162: from FPA_SCORECARDS_TL SUBB, FPA_SCORECARDS_TL SUBT
163: where SUBB.PROJECT_ID = SUBT.PROJECT_ID
164: and SUBB.STRATEGIC_OBJ_ID = SUBT.STRATEGIC_OBJ_ID
165: and SUBB.SCENARIO_ID = SUBT.SCENARIO_ID
166: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 172: insert into FPA_SCORECARDS_TL (

168: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
169: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
170: ));
171:
172: insert into FPA_SCORECARDS_TL (
173: PROJECT_ID,
174: STRATEGIC_OBJ_ID,
175: COMMENTS,
176: CREATED_BY,

Line 196: from FPA_SCORECARDS_TL B, FND_LANGUAGES L

192: B.LAST_UPDATE_LOGIN,
193: B.SCENARIO_ID,
194: L.LANGUAGE_CODE,
195: B.SOURCE_LANG
196: from FPA_SCORECARDS_TL B, FND_LANGUAGES L
197: where L.INSTALLED_FLAG in ('I', 'B')
198: and B.LANGUAGE = userenv('LANG')
199: and not exists
200: (select NULL

Line 201: from FPA_SCORECARDS_TL T

197: where L.INSTALLED_FLAG in ('I', 'B')
198: and B.LANGUAGE = userenv('LANG')
199: and not exists
200: (select NULL
201: from FPA_SCORECARDS_TL T
202: where T.PROJECT_ID = B.PROJECT_ID
203: and T.STRATEGIC_OBJ_ID = B.STRATEGIC_OBJ_ID
204: and T.SCENARIO_ID = B.SCENARIO_ID
205: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 218: update fpa_scorecards_tl set

214: P_OWNER in VARCHAR2
215: ) is
216: begin
217:
218: update fpa_scorecards_tl set
219: COMMENTS = P_COMMENTS,
220: LAST_UPDATE_DATE = sysdate,
221: LAST_UPDATED_BY = decode(P_OWNER, 'SEED', 1, 0),
222: LAST_UPDATE_LOGIN = 0,