DBA Data[Home] [Help]

APPS.PA_RBS_ASGMT_PVT dependencies on PA_RBS_ASGMT_PKG

Line 59: * necessary and then call the PA_RBS_ASGMT_Pkg to

55: * Program Reporting.
56: * Reporting is the Default Usage type for all the
57: * associations.
58: * This Package would take care of all the validations
59: * necessary and then call the PA_RBS_ASGMT_Pkg to
60: * do the insertion.
61: *Called From : PA_RBS_ASGMT_PUB.Create_RBS_Assignment
62: ****************************************************************/
63: PROCEDURE Create_RBS_Assignment(

Line 315: * Call to PA_RBS_ASGMT_PKG.Update_Row procedure, which would

311: RETURN;
312: END;
313:
314: /************************************************
315: * Call to PA_RBS_ASGMT_PKG.Update_Row procedure, which would
316: * take care of Updation of the pa_rbs_prj_assignments
317: * table.
318: *****************************************************/
319: PA_RBS_ASGMT_PKG.Update_Row(

Line 319: PA_RBS_ASGMT_PKG.Update_Row(

315: * Call to PA_RBS_ASGMT_PKG.Update_Row procedure, which would
316: * take care of Updation of the pa_rbs_prj_assignments
317: * table.
318: *****************************************************/
319: PA_RBS_ASGMT_PKG.Update_Row(
320: p_rbs_prj_assignment_id => l_rbs_prj_assignment_id ,
321: p_wp_usage_flag => l_wp_flag,
322: p_fp_usage_flag => l_fp_flag,
323: p_prog_rep_usage_flag => l_prog_flag,

Line 342: * Call to PA_RBS_ASGMT_PKG.Insert_Row procedure, which would

338: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
339: INTO l_rbs_prj_assignment_id
340: FROM DUAL;
341: /************************************************
342: * Call to PA_RBS_ASGMT_PKG.Insert_Row procedure, which would
343: * take care of Insertion into the pa_rbs_prj_assignments
344: * table.
345: *****************************************************/
346: BEGIN

Line 359: PA_RBS_ASGMT_PKG.Insert_Row(

355: ELSE
356: l_primary_assignment := p_primary_rep_flag;
357: END IF;
358:
359: PA_RBS_ASGMT_PKG.Insert_Row(
360: p_rbs_assignment_id => l_rbs_prj_assignment_id,
361: p_rbs_header_id => p_rbs_header_id,
362: p_rbs_version_id => l_rbs_version_id,
363: p_project_id => p_project_id,

Line 428: * necessary and then call the PA_RBS_ASGMT_Pkg.Update_Row to

424: * Program Reporting.
425: * Reporting is the Default Usage type for all the
426: * associations.
427: * This Package would take care of all the validations
428: * necessary and then call the PA_RBS_ASGMT_Pkg.Update_Row to
429: * do the Updation.
430: *Called From : PA_RBS_ASGMT_PUB.Update_RBS_Assignment
431: ****************************************************************/
432: PROCEDURE Update_RBS_Assignment(

Line 496: * Call to the Pa_rbs_Asgmt_pkg.Update_Row Procedure

492: END IF;
493: END IF;
494:
495: /******************************************************
496: * Call to the Pa_rbs_Asgmt_pkg.Update_Row Procedure
497: * Which would update the values in the table
498: * pa_rbs_prj_asignemnts with the values passed.
499: *****************************************************/
500: Pa_Rbs_Asgmt_Pkg.Update_Row(

Line 500: Pa_Rbs_Asgmt_Pkg.Update_Row(

496: * Call to the Pa_rbs_Asgmt_pkg.Update_Row Procedure
497: * Which would update the values in the table
498: * pa_rbs_prj_asignemnts with the values passed.
499: *****************************************************/
500: Pa_Rbs_Asgmt_Pkg.Update_Row(
501: p_rbs_prj_assignment_id => p_rbs_prj_assignment_id ,
502: p_wp_usage_flag => p_wp_usage_flag,
503: p_fp_usage_flag => p_fp_usage_flag,
504: p_prog_rep_usage_flag => p_prog_rep_usage_flag,

Line 529: * necessary and then call the PA_RBS_ASGMT_Pkg.Delete_Row to

525: * Procedure : Delete_RBS_Assignment
526: * Description : The purpose of this procedure is to Delete an associate
527: * of an RBS to a project for any of the 4 uasges:-
528: * This Package would take care of all the validations
529: * necessary and then call the PA_RBS_ASGMT_Pkg.Delete_Row to
530: * do the Remove operation.
531: * We cannot Remove any RBS that is being used for
532: * Workplan or Financial Plan.
533: * Called From : PA_RBS_ASGMT_PUB.Delete_RBS_Assignment

Line 599: PA_RBS_ASGMT_PKG.Delete_Row(

595: RETURN;
596: END IF;
597:
598:
599: PA_RBS_ASGMT_PKG.Delete_Row(
600: p_rbs_prj_assignment_id => p_rbs_prj_assignment_id,
601: x_return_status => x_return_status);
602:
603: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 742: * Call to PA_RBS_ASGMT_PKG.Update_Row procedure, which would

738: RETURN;
739: END;
740:
741: /************************************************
742: * Call to PA_RBS_ASGMT_PKG.Update_Row procedure, which would
743: * take care of Updation of the pa_rbs_prj_assignments
744: * table.
745: * We only need to set the value for the
746: * reporting_usage flag = 'Y' and the prog_rep_usage_flag

Line 774: PA_RBS_ASGMT_PKG.Insert_Row(

770: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
771: INTO l_rbs_prj_assignment_id
772: FROM DUAL;
773:
774: PA_RBS_ASGMT_PKG.Insert_Row(
775: p_rbs_assignment_id => l_rbs_prj_assignment_id,
776: p_rbs_header_id => p_rbs_header_id,
777: p_rbs_version_id => l_rbs_version_id,
778: p_project_id => p_project_id_tbl(i),