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 67: INSERT INTO FPA_SCORECARDS_TL(

63:
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: INSERT INTO FPA_SCORECARDS_TL(
68: project_id,
69: strategic_obj_id,
70: scenario_id,
71: comments,

Line 122: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,

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

Line 131: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC := p_scorecards_tl_rec;

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

Line 134: -- Set_Attributes for:FPA_SCORECARDS_TL --

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

Line 137: p_scorecards_tl_rec IN FPA_SCORECARDS_TL_REC,

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

Line 138: x_scorecards_tl_rec OUT NOCOPY FPA_SCORECARDS_TL_REC

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

Line 164: UPDATE fpa_scorecards_tl

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

Line 224: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC;

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

Line 229: from fpa_scorecards_tl

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

Line 394: l_scorecards_tl_rec FPA_SCORECARDS_TL_REC;

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

Line 401: from fpa_scorecards_tl

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

Line 812: l_scorecards_tl_rec FPA_SCORECARDS_PVT.FPA_SCORECARDS_TL_REC;

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

Line 833: fpa_aw_proj_str_scores_v sce, fpa_scorecards_tl pjtc

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

Line 842: from fpa_scorecards_tl sctl

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

Line 856: fpa_scorecards_tl pjts

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

Line 862: from fpa_scorecards_tl sctl

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

Line 895: FROM FPA_SCORECARDS_TL

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