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_INVESTMENT_CRITERIA_PVT dependencies on FPA_INVESTMENT_CRITERIA_PVT

Line 1: package body FPA_Investment_Criteria_PVT as

1: package body FPA_Investment_Criteria_PVT as
2: /* $Header: FPAVINVB.pls 120.7 2007/11/29 05:44:02 kjai ship $ */
3:
4: -- The procedure Create_StrategicObj_Objects_AW creates the AW objects related to
5: -- strategic objectives: strategic_obj_d

Line 14: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,

10: /*
11: PROCEDURE create_strategicobj_objects_AW
12: (
13: p_commit IN VARCHAR2 := FND_API.G_FALSE,
14: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
15: x_return_status OUT NOCOPY VARCHAR2,
16: x_msg_count OUT NOCOPY NUMBER,
17: x_msg_data OUT NOCOPY VARCHAR2
18: )

Line 95: p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,

91: -- for this purpose.
92: PROCEDURE create_strategicobj_aw
93: (
94: p_commit IN VARCHAR2 := FND_API.G_FALSE,
95: p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
96: p_seeding IN VARCHAR2,
97: x_strategic_obj_id OUT NOCOPY VARCHAR2,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,

Line 129: 'fpa.sql.fpa_investment_criteria_pvt.create_strategicobj_aw.begin',

125: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
126: fnd_log.string
127: (
128: FND_LOG.LEVEL_PROCEDURE,
129: 'fpa.sql.fpa_investment_criteria_pvt.create_strategicobj_aw.begin',
130: 'Entering fpa_investment_criteria_pvt.create_strategicobj_aw'
131: );
132: END IF;
133:

Line 130: 'Entering fpa_investment_criteria_pvt.create_strategicobj_aw'

126: fnd_log.string
127: (
128: FND_LOG.LEVEL_PROCEDURE,
129: 'fpa.sql.fpa_investment_criteria_pvt.create_strategicobj_aw.begin',
130: 'Entering fpa_investment_criteria_pvt.create_strategicobj_aw'
131: );
132: END IF;
133:
134:

Line 138: 'fpa.sql.fpa_investment_criteria_pvt.create_strategicobj_aw',

134:
135: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
136: fnd_log.string
137: (FND_LOG.LEVEL_PROCEDURE,
138: 'fpa.sql.fpa_investment_criteria_pvt.create_strategicobj_aw',
139: 'Evaluating p_seeding parameter'
140: );
141: END IF;
142:

Line 158: 'fpa.sql.fpa_investment_criteria_pvt.create_strategicobj_aw',

154:
155: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
156: fnd_log.string
157: (FND_LOG.LEVEL_PROCEDURE,
158: 'fpa.sql.fpa_investment_criteria_pvt.create_strategicobj_aw',
159: 'Inserting into FPA_OBJECTS_TL'
160: );
161: END IF;
162:

Line 231: p_investment_rec_type IN fpa_investment_criteria_pvt.investment_rec_type,

227: -- the AW space.
228: PROCEDURE delete_strategicobj_aw
229: (
230: p_api_version IN NUMBER,
231: p_investment_rec_type IN fpa_investment_criteria_pvt.investment_rec_type,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2
235: )

Line 282: p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,

278:
279: PROCEDURE update_strategicobj
280: (
281: p_commit IN VARCHAR2 := FND_API.G_FALSE,
282: p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
285: x_msg_data OUT NOCOPY VARCHAR2
286: )

Line 294: 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.begin',

290:
291: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
292: fnd_log.string
293: ( FND_LOG.LEVEL_PROCEDURE,
294: 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.begin',
295: 'Entering fpa_investment_criteria_pvt.update_strategicobj');
296: END IF;
297:
298: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 295: 'Entering fpa_investment_criteria_pvt.update_strategicobj');

291: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
292: fnd_log.string
293: ( FND_LOG.LEVEL_PROCEDURE,
294: 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.begin',
295: 'Entering fpa_investment_criteria_pvt.update_strategicobj');
296: END IF;
297:
298: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
299: fnd_log.string

Line 301: 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.begin',

297:
298: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
299: fnd_log.string
300: (FND_LOG.LEVEL_PROCEDURE,
301: 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.begin',
302: 'Updating FPA_OBJECTS_TL for the investment criteria');
303: END IF;
304:
305: update FPA_OBJECTS_TL

Line 317: 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.end',

313:
314: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
315: fnd_log.string
316: ( FND_LOG.LEVEL_PROCEDURE,
317: 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.end',
318: 'Exiting fpa_investment_criteria_pvt.update_strategicobj');
319: END IF;
320:
321:

Line 318: 'Exiting fpa_investment_criteria_pvt.update_strategicobj');

314: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
315: fnd_log.string
316: ( FND_LOG.LEVEL_PROCEDURE,
317: 'fpa.sql.fpa_investment_criteria_pvt.update_strategicobj.end',
318: 'Exiting fpa_investment_criteria_pvt.update_strategicobj');
319: END IF;
320:
321:
322:

Line 346: p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,

342:
343: PROCEDURE update_strategicobj_status_aw
344: (
345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
346: p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2
350: )

Line 389: p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,

385:
386: PROCEDURE update_strategicobj_level_aw
387: (
388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
389: p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
390: x_return_status OUT NOCOPY VARCHAR2,
391: x_msg_count OUT NOCOPY NUMBER,
392: x_msg_data OUT NOCOPY VARCHAR2
393: ) is

Line 401: 'fpa.sql.FPA_Investment_Criteria_PVT.update_strategicobj_level_aw.begin',

397: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
398: fnd_log.string
399: (
400: FND_LOG.LEVEL_PROCEDURE,
401: 'fpa.sql.FPA_Investment_Criteria_PVT.update_strategicobj_level_aw.begin',
402: 'Entering FPA_Investment_Criteria_PVT.update_strategicobj_level_aw'
403: );
404: END IF;
405:

Line 402: 'Entering FPA_Investment_Criteria_PVT.update_strategicobj_level_aw'

398: fnd_log.string
399: (
400: FND_LOG.LEVEL_PROCEDURE,
401: 'fpa.sql.FPA_Investment_Criteria_PVT.update_strategicobj_level_aw.begin',
402: 'Entering FPA_Investment_Criteria_PVT.update_strategicobj_level_aw'
403: );
404: END IF;
405:
406:

Line 432: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,

428: -- The procedure Update_StrategicObj_Weight_AW updates the Strategic Objective
429: -- Weight measure in AW.Update_StrategicObj_Weight_AW. (strategic_obj_weight_m)
430: PROCEDURE update_strategicobj_weight_aw
431: (
432: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
433: x_return_status OUT NOCOPY varchar2,
434: x_msg_count OUT NOCOPY number,
435: x_msg_data OUT NOCOPY varchar2
436: )

Line 441: l_investment_rec_type FPA_Investment_Criteria_PVT.Investment_rec_type;

437: IS
438:
439: l_api_version CONSTANT NUMBER := 1.0;
440:
441: l_investment_rec_type FPA_Investment_Criteria_PVT.Investment_rec_type;
442:
443: l_objective_string VARCHAR2(5000); -- used to hold current obj string.
444: l_temp_string VARCHAR2(500); -- string to hold current obj and score.
445:

Line 521: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,

517: -- We will add all scores for all Projects and then we will take the average.
518: PROCEDURE Update_ProjectTypeObjScore_AW
519: (
520: p_commit IN VARCHAR2 := FND_API.G_FALSE,
521: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
522: x_return_status OUT NOCOPY VARCHAR2,
523: x_msg_count OUT NOCOPY NUMBER,
524: x_msg_data OUT NOCOPY VARCHAR2
525: )

Line 579: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,

575: PROCEDURE update_strategicobj_wscore_aw
576: (
577: p_api_version IN NUMBER,
578: p_commit IN VARCHAR2 := FND_API.G_FALSE,
579: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
580: x_return_status OUT NOCOPY VARCHAR2,
581: x_msg_count OUT NOCOPY NUMBER,
582: x_msg_data OUT NOCOPY VARCHAR2
583: )

Line 628: p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,

624: PROCEDURE Update_ProjectTypeObjWScore_AW
625: (
626: p_api_version IN NUMBER,
627: p_commit IN VARCHAR2 := FND_API.G_FALSE,
628: p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
629: x_return_status OUT NOCOPY VARCHAR2,
630: x_msg_count OUT NOCOPY NUMBER,
631: x_msg_data OUT NOCOPY VARCHAR2
632: )

Line 695: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,

691: PROCEDURE Update_StrategicObj_AScore_AW
692: (
693: p_api_version IN number,
694: p_commit IN varchar2 := FND_API.G_FALSE,
695: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
696: x_return_status OUT NOCOPY varchar2,
697: x_msg_count OUT NOCOPY number,
698: x_msg_data OUT NOCOPY varchar2
699: )

Line 797: ,p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type

793: /*
794: -- Update the Average Score for the Project Type for the particular Objective Group.
795: procedure Update_ProjectTypeObjAScore_AW(
796: p_commit IN varchar2 := FND_API.G_FALSE
797: ,p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type
798: ,x_return_status OUT NOCOPY varchar2
799: ,x_msg_count OUT NOCOPY number
800: ,x_msg_data OUT NOCOPY varchar2
801: ) is

Line 868: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,

864: PROCEDURE Rollup_StrategicObj_WScore_AW
865: (
866: p_api_version IN NUMBER,
867: p_commit IN VARCHAR2 := FND_API.G_FALSE,
868: p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
869: x_return_status OUT NOCOPY VARCHAR2,
870: x_msg_count OUT NOCOPY NUMBER,
871: x_msg_data OUT NOCOPY VARCHAR2
872: )

Line 937: -- FPA_Investment_Criteria_PVT.Investment_rec_type as a parameter

933: /*******************************************************************************
934: *******************************************************************************/
935: -------------------------------------------------------------------------------
936: -- API create_strategicobj_aw , Overloaded API which does not take
937: -- FPA_Investment_Criteria_PVT.Investment_rec_type as a parameter
938: --
939: -- Params
940: -- p_commit IN VARCHAR2
941: -- p_seeding IN VARCHAR2

Line 967: l_Investment_rec_type FPA_Investment_Criteria_PVT.Investment_rec_type;

963: x_msg_count OUT NOCOPY NUMBER,
964: x_msg_data OUT NOCOPY VARCHAR2
965: )
966: IS
967: l_Investment_rec_type FPA_Investment_Criteria_PVT.Investment_rec_type;
968: BEGIN
969: l_Investment_rec_type.strategic_obj_shortname := p_strategic_obj_shortname;
970: l_Investment_rec_type.strategic_obj_desc := p_strategic_obj_desc;
971: l_Investment_rec_type.strategic_obj_name := p_strategic_obj_name;

Line 985: -- FPA_Investment_Criteria_PVT.Investment_rec_type as a parameter

981: END create_strategicobj_aw;
982:
983: --------------------------------------------------------------------------------
984: -- API update_strategicobj_status_aw , Overloaded API which does not take
985: -- FPA_Investment_Criteria_PVT.Investment_rec_type as a parameter
986: --
987: -- Params
988: -- p_commit IN VARCHAR2
989: -- x_return_status OUT NOCOPY VARCHAR2

Line 1013: l_Investment_rec_type FPA_Investment_Criteria_PVT.Investment_rec_type;

1009: x_msg_count OUT NOCOPY NUMBER,
1010: x_msg_data OUT NOCOPY VARCHAR2
1011: )
1012: IS
1013: l_Investment_rec_type FPA_Investment_Criteria_PVT.Investment_rec_type;
1014: BEGIN
1015: l_Investment_rec_type.strategic_obj_shortname := p_strategic_obj_shortname;
1016: l_Investment_rec_type.strategic_obj_desc := p_strategic_obj_desc;
1017: l_Investment_rec_type.strategic_obj_name := p_strategic_obj_name;

Line 1030: -- FPA_Investment_Criteria_PVT.Investment_rec_type as a parameter

1026: END update_strategicobj_status_aw;
1027:
1028: -------------------------------------------------------------------------------
1029: -- API update_strategicobj_status_aw , Overloaded API which does not take
1030: -- FPA_Investment_Criteria_PVT.Investment_rec_type as a parameter
1031: --
1032: -- Params
1033: -- p_commit IN VARCHAR2
1034: -- x_return_status OUT NOCOPY VARCHAR2

Line 1056: l_Investment_rec_type FPA_Investment_Criteria_PVT.Investment_rec_type;

1052: x_msg_count OUT NOCOPY NUMBER,
1053: x_msg_data OUT NOCOPY VARCHAR2
1054: )
1055: IS
1056: l_Investment_rec_type FPA_Investment_Criteria_PVT.Investment_rec_type;
1057: BEGIN
1058: l_Investment_rec_type.strategic_obj_shortname := p_strategic_obj_shortname;
1059: l_Investment_rec_type.strategic_obj_desc := p_strategic_obj_desc;
1060: l_Investment_rec_type.strategic_obj_name := p_strategic_obj_name;

Line 1070: END fpa_investment_criteria_pvt;

1066: x_msg_count => x_msg_count,
1067: x_msg_data => x_msg_data);
1068: END update_strategicobj_level_aw;
1069:
1070: END fpa_investment_criteria_pvt;