APPS.PA_RETENTION_PKG dependencies on PA_SUMMARY_PROJECT_RETN

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 306: FROM pa_summary_project_retn

302: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Update SPR ');
303: END IF;
304:
305: SELECT 'Y' INTO TmpFlag
306: FROM pa_summary_project_retn
307: WHERE project_id = p_project_id
308: AND nvl(task_id,-99) = NVL(p_task_id,-99)
309: AND agreement_id = p_agreement_id;
310:

Line 328: INSERT INTO pa_summary_project_retn

324: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Projfunc Amount : ' || p_projfunc_amount);
325: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
326: END IF;
327:
328: INSERT INTO pa_summary_project_retn
329: (
330: PROJECT_ID,
331: TASK_ID,
332: AGREEMENT_ID,

Line 379: UPDATE pa_summary_project_retn

375: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Projfunc Amount : ' || p_projfunc_amount);
376: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
377: END IF;
378:
379: UPDATE pa_summary_project_retn
380: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
381: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
382: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
383: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),

Line 431: UPDATE pa_summary_project_retn

427: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Project Amount : ' || p_project_amount);
428: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Invproc Amount : ' || p_amount);
429: END IF;
430:
431: UPDATE pa_summary_project_retn
432: SET total_billed = NVL(total_billed,0) +
433: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
434: project_total_billed = NVL(project_total_billed,0) +
435: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_project_amount,0),p_project_currency),

Line 475: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Delete from pa_summary_project_retn ');

471:
472:
473: IF g1_debug_mode = 'Y' THEN
474: pa_retention_util.write_log('No of Records are deleted : ' || sql%rowcount);
475: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Delete from pa_summary_project_retn ');
476: END IF;
477:
478: DELETE FROM pa_summary_project_retn
479: WHERE project_id = p_project_id

Line 478: DELETE FROM pa_summary_project_retn

474: pa_retention_util.write_log('No of Records are deleted : ' || sql%rowcount);
475: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Delete from pa_summary_project_retn ');
476: END IF;
477:
478: DELETE FROM pa_summary_project_retn
479: WHERE project_id = p_project_id
480: AND NVL(task_id,-99) = NVL(p_task_id,-99)
481: AND agreement_id = p_agreement_id
482: AND NVL(total_retained,0) = 0