APPS.PA_RETENTION_PKG dependencies on PA_PROJECT_RETENTIONS

Line 147: -- Update the pa_project_retentions, pa_proj_retn_rules, pa_summary_project_retn

143:
144: END Get_Proj_Inv_Retn_Format;
145:
146: -- Procedure to Update the retention balances
147: -- Update the pa_project_retentions, pa_proj_retn_rules, pa_summary_project_retn
148:
149: /*PROCEDURE Update_Retention_Balances( p_retention_rule_id IN NUMBER DEFAULT NULL, bug 2681003,
150: removed the default values to ensure GSCC complaince */
151: PROCEDURE Update_Retention_Balances( p_retention_rule_id IN NUMBER ,

Line 205: FROM pa_project_retentions

201: -- , rule, project id.
202:
203: BEGIN
204: SELECT 'Y' INTO TmpFlag
205: FROM pa_project_retentions
206: WHERE project_id = p_project_id
207: AND retention_rule_id = p_retention_rule_id
208: AND agreement_id = p_agreement_id
209: AND NVL(task_id,-99) = NVL(p_task_id,-99);

Line 221: SELECT pa_project_retentions_s.NEXTVAL

217: EXCEPTION
218:
219: WHEN NO_DATA_FOUND THEN
220:
221: SELECT pa_project_retentions_s.NEXTVAL
222: INTO l_project_retn_id
223: FROM DUAL;
224:
225: IF g1_debug_mode = 'Y' THEN

Line 232: INSERT INTO pa_project_retentions

228: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Projfunc Amount : ' || p_projfunc_amount);
229: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
230: END IF;
231:
232: INSERT INTO pa_project_retentions
233: ( PROJECT_RETENTION_ID,
234: PROJECT_ID,
235: TASK_ID,
236: AGREEMENT_ID,

Line 283: UPDATE pa_project_retentions

279: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Projfunc Amount : ' || p_projfunc_amount);
280: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
281: END IF;
282:
283: UPDATE pa_project_retentions
284: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
285: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
286: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
287: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),

Line 459: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Delete from pa_project_retentions ');

455: it should not be deleted
456:
457: Delete the 0 Amount Summary Retn Records and project_retention records
458: IF g1_debug_mode = 'Y' THEN
459: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Delete from pa_project_retentions ');
460: END IF;
461:
462: DELETE FROM pa_project_retentions
463: WHERE project_id = p_project_id

Line 462: DELETE FROM pa_project_retentions

458: IF g1_debug_mode = 'Y' THEN
459: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Delete from pa_project_retentions ');
460: END IF;
461:
462: DELETE FROM pa_project_retentions
463: WHERE project_id = p_project_id
464: AND NVL(task_id,-99) = NVL(p_task_id,-99)
465: AND agreement_id = p_agreement_id
466: AND retention_rule_id = p_retention_rule_id

Line 3785: Delete From PA_Proj_Retn_Rules -- PA_Project_Retentions

3781: -- Dbms_Output.Put_Line('Flag value 1 : '|| l_Cust_Top_Task_Flag);
3782: -- Dbms_Output.Put_Line('Flag value 2 : '|| l_Inv_Method_Top_Task_Flag);
3783:
3784: If l_Cust_Top_Task_Flag = 'Y' OR l_Inv_Method_Top_Task_Flag = 'Y' Then
3785: Delete From PA_Proj_Retn_Rules -- PA_Project_Retentions
3786: Where Project_ID = P_Project_ID
3787: And Task_ID = P_Task_ID;
3788: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
3789: End If;