APPS.PA_RETENTION_PKG dependencies on PA_SUMMARY_PROJECT_RETN

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

125:
126: END Get_Proj_Inv_Retn_Format;
127:
128: -- Procedure to Update the retention balances
129: -- Update the pa_project_retentions, pa_proj_retn_rules, pa_summary_project_retn
130:
131: /*PROCEDURE Update_Retention_Balances( p_retention_rule_id IN NUMBER DEFAULT NULL, bug 2681003,
132: removed the default values to ensure GSCC complaince */
133: PROCEDURE Update_Retention_Balances( p_retention_rule_id IN NUMBER ,

Line 288: FROM pa_summary_project_retn

284: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Update SPR ');
285: END IF;
286:
287: SELECT 'Y' INTO TmpFlag
288: FROM pa_summary_project_retn
289: WHERE project_id = p_project_id
290: AND nvl(task_id,-99) = NVL(p_task_id,-99)
291: AND agreement_id = p_agreement_id;
292:

Line 310: INSERT INTO pa_summary_project_retn

306: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Projfunc Amount : ' || p_projfunc_amount);
307: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
308: END IF;
309:
310: INSERT INTO pa_summary_project_retn
311: (
312: PROJECT_ID,
313: TASK_ID,
314: AGREEMENT_ID,

Line 361: UPDATE pa_summary_project_retn

357: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Projfunc Amount : ' || p_projfunc_amount);
358: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
359: END IF;
360:
361: UPDATE pa_summary_project_retn
362: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
363: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
364: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
365: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),

Line 413: UPDATE pa_summary_project_retn

409: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Project Amount : ' || p_project_amount);
410: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Invproc Amount : ' || p_amount);
411: END IF;
412:
413: UPDATE pa_summary_project_retn
414: SET total_billed = NVL(total_billed,0) +
415: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
416: project_total_billed = NVL(project_total_billed,0) +
417: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_project_amount,0),p_project_currency),

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

453:
454:
455: IF g1_debug_mode = 'Y' THEN
456: pa_retention_util.write_log('No of Records are deleted : ' || sql%rowcount);
457: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Delete from pa_summary_project_retn ');
458: END IF;
459:
460: DELETE FROM pa_summary_project_retn
461: WHERE project_id = p_project_id

Line 460: DELETE FROM pa_summary_project_retn

456: pa_retention_util.write_log('No of Records are deleted : ' || sql%rowcount);
457: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Delete from pa_summary_project_retn ');
458: END IF;
459:
460: DELETE FROM pa_summary_project_retn
461: WHERE project_id = p_project_id
462: AND NVL(task_id,-99) = NVL(p_task_id,-99)
463: AND agreement_id = p_agreement_id
464: AND NVL(total_retained,0) = 0