DBA Data[Home] [Help]

APPS.FPA_SCORECARDS_PVT dependencies on FPA_SCORECARDS_PVT

Line 1: package body FPA_SCORECARDS_PVT as

1: package body FPA_SCORECARDS_PVT as
2: /* $Header: FPAVSCRB.pls 120.3 2006/03/16 13:06:42 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_SCORECARDS_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_SCORECARDS_PVT';

1: package body FPA_SCORECARDS_PVT as
2: /* $Header: FPAVSCRB.pls 120.3 2006/03/16 13:06:42 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_SCORECARDS_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;
6: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
7: L_API_NAME CONSTANT VARCHAR2(35) := 'SCORECARDS';
8:

Line 57: p_msg_log => 'Entering Fpa_Scorecards_Pvt.insert_tl_rec');

53: FPA_UTILITIES_PVT.START_ACTIVITY(
54: p_api_name => l_api_name,
55: p_pkg_name => G_PKG_NAME,
56: p_init_msg_list => p_init_msg_list,
57: p_msg_log => 'Entering Fpa_Scorecards_Pvt.insert_tl_rec');
58:
59: --- Setting item attributes
60: l_return_status := Set_Attributes(
61: p_scorecards_tl_rec,

Line 157: p_msg_log => 'Entering Fpa_Scorecards_Pvt.update_tl_rec');

153: FPA_UTILITIES_PVT.START_ACTIVITY(
154: p_api_name => l_api_name,
155: p_pkg_name => G_PKG_NAME,
156: p_init_msg_list => p_init_msg_list,
157: p_msg_log => 'Entering Fpa_Scorecards_Pvt.update_tl_rec');
158:
159: --- Setting item attributes
160: l_return_status := Set_Attributes(
161: p_scorecards_tl_rec,

Line 208: p_scorecard_tbl IN FPA_SCORECARDS_PVT.FPA_SCORECARD_TBL_TYPE,

204: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: p_planning_cycle_id IN NUMBER,
207: p_project_id IN NUMBER,
208: p_scorecard_tbl IN FPA_SCORECARDS_PVT.FPA_SCORECARD_TBL_TYPE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2
212: ) IS

Line 222: l_scorecard_rec FPA_SCORECARDS_PVT.FPA_SCORECARD_REC_TYPE;

218: l_msg_log VARCHAR2(2000) := null;
219: ----------------------------------------------------------------------------
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,

Line 251: p_msg_log => 'Entering Fpa_Scorecards_Pvt.Update_Calc_Pjt_Scorecard_Aw',

247: p_init_msg_list => p_init_msg_list,
248: l_api_version => l_api_version,
249: p_api_version => p_api_version,
250: p_api_type => G_API_TYPE,
251: p_msg_log => 'Entering Fpa_Scorecards_Pvt.Update_Calc_Pjt_Scorecard_Aw',
252: x_return_status => x_return_status);
253:
254: -- check if activity started successfully
255: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

Line 379: p_scorecard_tbl IN FPA_SCORECARDS_PVT.FPA_SCORECARD_TBL_TYPE,

375: p_commit IN VARCHAR2 := FND_API.G_FALSE,
376: p_planning_cycle_id IN NUMBER,
377: p_scenario_id IN NUMBER,
378: p_project_id IN NUMBER,
379: p_scorecard_tbl IN FPA_SCORECARDS_PVT.FPA_SCORECARD_TBL_TYPE,
380: x_return_status OUT NOCOPY VARCHAR2,
381: x_msg_count OUT NOCOPY NUMBER,
382: x_msg_data OUT NOCOPY VARCHAR2
383: ) IS

Line 393: l_scorecard_rec FPA_SCORECARDS_PVT.FPA_SCORECARD_REC_TYPE;

389: l_msg_log VARCHAR2(2000) := null;
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,

Line 420: p_msg_log => 'Entering Fpa_Scorecards_Pvt.Update_Calc_Scen_Scorecard_Aw',

416: p_init_msg_list => p_init_msg_list,
417: l_api_version => l_api_version,
418: p_api_version => p_api_version,
419: p_api_type => G_API_TYPE,
420: p_msg_log => 'Entering Fpa_Scorecards_Pvt.Update_Calc_Scen_Scorecard_Aw',
421: x_return_status => x_return_status);
422:
423: -- check if activity started successfully
424: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

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 881: p_msg_log => 'Entering Fpa_Scorecards_Pvt.Handle_Comments '||p_scenario_id,

877: p_init_msg_list => p_init_msg_list,
878: l_api_version => l_api_version,
879: p_api_version => p_api_version,
880: p_api_type => G_API_TYPE,
881: p_msg_log => 'Entering Fpa_Scorecards_Pvt.Handle_Comments '||p_scenario_id,
882: x_return_status => x_return_status);
883:
884: -- check if activity started successfully
885: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

Line 1117: END FPA_SCORECARDS_PVT;

1113:
1114:
1115:
1116:
1117: END FPA_SCORECARDS_PVT;