APPS.PA_RETENTION_PKG dependencies on PA_PROJECT_RETENTIONS

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 187: FROM pa_project_retentions

183: -- , rule, project id.
184:
185: BEGIN
186: SELECT 'Y' INTO TmpFlag
187: FROM pa_project_retentions
188: WHERE project_id = p_project_id
189: AND retention_rule_id = p_retention_rule_id
190: AND agreement_id = p_agreement_id
191: AND NVL(task_id,-99) = NVL(p_task_id,-99);

Line 203: SELECT pa_project_retentions_s.NEXTVAL

199: EXCEPTION
200:
201: WHEN NO_DATA_FOUND THEN
202:
203: SELECT pa_project_retentions_s.NEXTVAL
204: INTO l_project_retn_id
205: FROM DUAL;
206:
207: IF g1_debug_mode = 'Y' THEN

Line 214: INSERT INTO pa_project_retentions

210: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Projfunc Amount : ' || p_projfunc_amount);
211: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
212: END IF;
213:
214: INSERT INTO pa_project_retentions
215: ( PROJECT_RETENTION_ID,
216: PROJECT_ID,
217: TASK_ID,
218: AGREEMENT_ID,

Line 265: UPDATE pa_project_retentions

261: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Projfunc Amount : ' || p_projfunc_amount);
262: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
263: END IF;
264:
265: UPDATE pa_project_retentions
266: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
267: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
268: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
269: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),

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

437: it should not be deleted
438:
439: Delete the 0 Amount Summary Retn Records and project_retention records
440: IF g1_debug_mode = 'Y' THEN
441: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Delete from pa_project_retentions ');
442: END IF;
443:
444: DELETE FROM pa_project_retentions
445: WHERE project_id = p_project_id

Line 444: DELETE FROM pa_project_retentions

440: IF g1_debug_mode = 'Y' THEN
441: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Delete from pa_project_retentions ');
442: END IF;
443:
444: DELETE FROM pa_project_retentions
445: WHERE project_id = p_project_id
446: AND NVL(task_id,-99) = NVL(p_task_id,-99)
447: AND agreement_id = p_agreement_id
448: AND retention_rule_id = p_retention_rule_id

Line 3748: Delete From PA_Proj_Retn_Rules -- PA_Project_Retentions

3744: -- Dbms_Output.Put_Line('Flag value 1 : '|| l_Cust_Top_Task_Flag);
3745: -- Dbms_Output.Put_Line('Flag value 2 : '|| l_Inv_Method_Top_Task_Flag);
3746:
3747: If l_Cust_Top_Task_Flag = 'Y' OR l_Inv_Method_Top_Task_Flag = 'Y' Then
3748: Delete From PA_Proj_Retn_Rules -- PA_Project_Retentions
3749: Where Project_ID = P_Project_ID
3750: And Task_ID = P_Task_ID;
3751: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
3752: End If;