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.6 2011/03/29 21:44:12 skkoppul ship $ */
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.6 2011/03/29 21:44:12 skkoppul ship $ */
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 158: p_msg_log => 'Entering Fpa_Scorecards_Pvt.update_tl_rec');

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

Line 209: p_scorecard_tbl IN FPA_SCORECARDS_PVT.FPA_SCORECARD_TBL_TYPE,

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

Line 223: l_scorecard_rec FPA_SCORECARDS_PVT.FPA_SCORECARD_REC_TYPE;

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

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

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

Line 380: p_scorecard_tbl IN FPA_SCORECARDS_PVT.FPA_SCORECARD_TBL_TYPE,

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

Line 394: l_scorecard_rec FPA_SCORECARDS_PVT.FPA_SCORECARD_REC_TYPE;

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

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

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

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

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

Line 1118: END FPA_SCORECARDS_PVT;

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