[Home] [Help]
10:
11: /**************************************************************
12: * Procedure : Insert_Row
13: * Description : The purpose of this procedure is to
14: * Insert into the Pa_rbs_prj_assignments table
15: * the values passed as parameters from the
16: * PA_RBS_ASGMT_PVT pkg.
17: ****************************************************************/
18: PROCEDURE Insert_Row(
26: p_primary_rep_flag IN VARCHAR2 DEFAULT 'N',
27: x_return_status OUT NOCOPY VARCHAR2 )
28: IS
29: BEGIN
30: INSERT INTO pa_rbs_prj_assignments
31: (RBS_PRJ_ASSIGNMENT_ID,
32: PROJECT_ID,
33: RBS_VERSION_ID,
34: RBS_HEADER_ID,
69: /***************************/
70: /**************************************************************
71: * Procedure : Update_Row
72: * Description : The purpose of this procedure is to
73: * Update the Pa_rbs_prj_assignments table
74: * the values passed as parameters from the
75: * PA_RBS_ASGMT_PVT pkg.
76: ****************************************************************/
77: PROCEDURE Update_Row(
85: IS
86:
87: BEGIN
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89: UPDATE pa_rbs_prj_assignments
90: SET reporting_usage_flag = 'Y',
91: wp_usage_flag = p_wp_usage_flag,
92: fp_usage_flag = p_fp_usage_flag,
93: prog_rep_usage_flag = p_prog_rep_usage_flag,
112:
113: /**************************************************************
114: * Procedure : Delete_Row
115: * Description : The purpose of this procedure is to
116: * delete the row in Pa_rbs_prj_assignments table
117: * based on the p_rbs_prj_assignment_id parameter
118: * passed from the Pa_rbs_asgmt_Pvt.Delete_Rbs_assignment
119: * procedure.
120: ****************************************************************/
125: BEGIN
126: /***********************************************
127: * Delete the record.
128: **********************************************/
129: DELETE FROM pa_rbs_prj_assignments
130: WHERE RBS_PRJ_ASSIGNMENT_ID = p_rbs_prj_assignment_id;
131:
132: IF SQL%NOTFOUND THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;