eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FPA_SCORECARDS_PVT dependencies on FPA_SCORECARDS_TL

Line 12: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,

8:
9:
10: PROCEDURE insert_tl_rec(
11: p_init_msg_list IN VARCHAR2,
12: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,
15: x_return_status OUT NOCOPY VARCHAR2
16: ) IS

Line 21: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC := p_scorecards_tl_rec;

17:
18: l_api_version CONSTANT NUMBER := 1;
19: l_api_name CONSTANT VARCHAR2(30) := 'insert_tl_rec';
20: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
21: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC := p_scorecards_tl_rec;
22: l_msg_log VARCHAR2(2000) := null;
23:
24: CURSOR get_languages IS
25: SELECT *

Line 30: -- Set_Attributes for:FPA_SCORECARDS_TL --

26: FROM FND_LANGUAGES
27: WHERE INSTALLED_FLAG IN ('I', 'B');
28:
29: -----------------------------------------
30: -- Set_Attributes for:FPA_SCORECARDS_TL --
31: -----------------------------------------
32: FUNCTION Set_Attributes (
33: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,
34: x_scorecards_tl_rec OUT NOCOPY FPA_SCORECARDS_TL_REC

Line 33: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,

29: -----------------------------------------
30: -- Set_Attributes for:FPA_SCORECARDS_TL --
31: -----------------------------------------
32: FUNCTION Set_Attributes (
33: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,
34: x_scorecards_tl_rec OUT NOCOPY FPA_SCORECARDS_TL_REC
35: ) RETURN VARCHAR2 IS
36: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
37: BEGIN

Line 34: x_scorecards_tl_rec OUT NOCOPY FPA_SCORECARDS_TL_REC

30: -- Set_Attributes for:FPA_SCORECARDS_TL --
31: -----------------------------------------
32: FUNCTION Set_Attributes (
33: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,
34: x_scorecards_tl_rec OUT NOCOPY FPA_SCORECARDS_TL_REC
35: ) RETURN VARCHAR2 IS
36: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
37: BEGIN
38: x_scorecards_tl_rec := p_scorecards_tl_rec;

Line 68: INSERT INTO FPA_SCORECARDS_TL(

64: FOR l_lang_rec IN get_languages LOOP
65: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'l_lang_rec.language_code '||l_lang_rec.language_code);
66: l_scorecards_tl_rec.LANGUAGE := l_lang_rec.language_code;
67: l_scorecards_tl_rec.SOURCE_LANG := l_lang_rec.language_code; --bug 11875056
68: INSERT INTO FPA_SCORECARDS_TL(
69: project_id,
70: strategic_obj_id,
71: scenario_id,
72: comments,

Line 123: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,

119:
120:
121: PROCEDURE update_tl_rec(
122: p_init_msg_list IN VARCHAR2,
123: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: x_return_status OUT NOCOPY VARCHAR2
127: ) IS

Line 132: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC := p_scorecards_tl_rec;

128:
129: l_api_version CONSTANT NUMBER := 1;
130: l_api_name CONSTANT VARCHAR2(30) := 'update_tl_rec';
131: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
132: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC := p_scorecards_tl_rec;
133: l_msg_log VARCHAR2(2000) := null;
134: -----------------------------------------
135: -- Set_Attributes for:FPA_SCORECARDS_TL --
136: -----------------------------------------

Line 135: -- Set_Attributes for:FPA_SCORECARDS_TL --

131: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
132: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC := p_scorecards_tl_rec;
133: l_msg_log VARCHAR2(2000) := null;
134: -----------------------------------------
135: -- Set_Attributes for:FPA_SCORECARDS_TL --
136: -----------------------------------------
137: FUNCTION Set_Attributes (
138: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,
139: x_scorecards_tl_rec OUT NOCOPY FPA_SCORECARDS_TL_REC

Line 138: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,

134: -----------------------------------------
135: -- Set_Attributes for:FPA_SCORECARDS_TL --
136: -----------------------------------------
137: FUNCTION Set_Attributes (
138: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,
139: x_scorecards_tl_rec OUT NOCOPY FPA_SCORECARDS_TL_REC
140: ) RETURN VARCHAR2 IS
141: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
142: BEGIN

Line 139: x_scorecards_tl_rec OUT NOCOPY FPA_SCORECARDS_TL_REC

135: -- Set_Attributes for:FPA_SCORECARDS_TL --
136: -----------------------------------------
137: FUNCTION Set_Attributes (
138: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,
139: x_scorecards_tl_rec OUT NOCOPY FPA_SCORECARDS_TL_REC
140: ) RETURN VARCHAR2 IS
141: l_return_status VARCHAR2(1) := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
142: BEGIN
143: x_scorecards_tl_rec := p_scorecards_tl_rec;

Line 165: UPDATE fpa_scorecards_tl

161: l_return_status := Set_Attributes(
162: p_scorecards_tl_rec,
163: l_scorecards_tl_rec);
164:
165: UPDATE fpa_scorecards_tl
166: SET comments = l_scorecards_tl_rec.comments,
167: last_updated_by = l_scorecards_tl_rec.last_updated_by,
168: last_update_date = l_scorecards_tl_rec.last_update_date,
169: last_update_login = l_scorecards_tl_rec.last_update_login

Line 225: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC;

221:
222: i NUMBER := 0;
223: l_scorecard_rec FPA_SCORECARDS_PVT.FPA_SCORECARD_REC_TYPE;
224: l_tl_exists VARCHAR2(1) := null;
225: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC;
226:
227: cursor check_comments_csr (p_project_id IN NUMBER,
228: p_strategic_obj_id IN NUMBER) IS
229: select 'T'

Line 230: from fpa_scorecards_tl

226:
227: cursor check_comments_csr (p_project_id IN NUMBER,
228: p_strategic_obj_id IN NUMBER) IS
229: select 'T'
230: from fpa_scorecards_tl
231: where project_id = p_project_id
232: and strategic_obj_id = p_strategic_obj_id
233: and scenario_id = -1
234: and language = USERENV('LANG')

Line 395: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC;

391: ----------------------------------------------------------------------------
392:
393: i NUMBER := 0;
394: l_scorecard_rec FPA_SCORECARDS_PVT.FPA_SCORECARD_REC_TYPE;
395: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC;
396: l_tl_exists VARCHAR2(1) := null;
397:
398: cursor check_comments_csr (p_project_id IN NUMBER,
399: p_scenario_id IN NUMBER,

Line 402: from fpa_scorecards_tl

398: cursor check_comments_csr (p_project_id IN NUMBER,
399: p_scenario_id IN NUMBER,
400: p_strategic_obj_id IN NUMBER) IS
401: select 'T'
402: from fpa_scorecards_tl
403: where project_id = p_project_id
404: and strategic_obj_id = p_strategic_obj_id
405: and scenario_id = p_scenario_id
406: and language = USERENV('LANG')

Line 813: l_scorecards_tl_rec FPA_SCORECARDS_PVT.FPA_SCORECARDS_TL_REC;

809: l_projects VARCHAR2(2000) := null;
810: l_init_scenario_id NUMBER;
811: l_source_scenario_id NUMBER;
812:
813: l_scorecards_tl_rec FPA_SCORECARDS_PVT.FPA_SCORECARDS_TL_REC;
814:
815: CURSOR initial_scenario_csr (p_scenario_id in number) IS
816: select
817: scei.scenario

Line 834: fpa_aw_proj_str_scores_v sce, fpa_scorecards_tl pjtc

830: sce.project project,
831: sce.investment_criteria investment_criteria,
832: pjtc.comments comments
833: from
834: fpa_aw_proj_str_scores_v sce, fpa_scorecards_tl pjtc
835: where
836: sce.project = pjtc.project_id
837: and sce.investment_criteria = pjtc.strategic_obj_id
838: and pjtc.scenario_id = -1

Line 843: from fpa_scorecards_tl sctl

839: and sce.scenario = p_scenario_id
840: and pjtc.language = userenv('LANG')
841: and not exists
842: (select 1
843: from fpa_scorecards_tl sctl
844: where sctl.scenario_id = sce.scenario
845: and sctl.project_id = sce.project
846: and sctl.language = userenv('LANG')
847: and sctl.strategic_obj_id = sce.investment_criteria);

Line 857: fpa_scorecards_tl pjts

853: pjts.project_id project,
854: pjts.strategic_obj_id investment_criteria,
855: pjts.comments comments
856: from
857: fpa_scorecards_tl pjts
858: where
859: pjts.scenario_id = p_source_scenario_id
860: and pjts.language = userenv('LANG')
861: and not exists

Line 863: from fpa_scorecards_tl sctl

859: pjts.scenario_id = p_source_scenario_id
860: and pjts.language = userenv('LANG')
861: and not exists
862: (select 1
863: from fpa_scorecards_tl sctl
864: where sctl.project_id = pjts.project_id
865: and sctl.strategic_obj_id = pjts.strategic_obj_id
866: and sctl.language = userenv('LANG')
867: and sctl.scenario_id = p_scenario_id);

Line 896: FROM FPA_SCORECARDS_TL

892: end if;
893:
894: IF (p_delete_project_id is not null) then
895: DELETE
896: FROM FPA_SCORECARDS_TL
897: WHERE SCENARIO_ID = P_SCENARIO_ID
898: AND PROJECT_ID = P_DELETE_PROJECT_ID
899: AND LANGUAGE = userenv('LANG')
900: AND SOURCE_LANG = userenv('LANG');