APPS.GMS_MULTI_FUNDING dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 1002: FROM PA_SUMMARY_PROJECT_FUNDINGS

998: BEGIN
999: BEGIN
1000: SELECT 1
1001: INTO Summary_Funding_Check
1002: FROM PA_SUMMARY_PROJECT_FUNDINGS
1003: WHERE Agreement_Id = X_Agreement_Id
1004: AND Project_Id = X_Award_Project_Id;
1005:
1006: X_Err_Code := 'S';

Line 1059: PA_SUMMARY_PROJECT_FUNDINGS

1055: INTO
1056: St_Total_Unbaselined_Amount ,
1057: St_Total_Baselined_Amount
1058: FROM
1059: PA_SUMMARY_PROJECT_FUNDINGS
1060: WHERE
1061: Project_Id = X_Award_Project_Id;
1062: END;
1063: X_Err_Code := 'S';

Line 1096: FROM PA_SUMMARY_PROJECT_FUNDINGS

1092: SELECT nvl(total_unbaselined_amount,0),
1093: nvl(total_baselined_amount,0)
1094: INTO St_Total_Unbaselined_Amount ,
1095: St_Total_Baselined_Amount
1096: FROM PA_SUMMARY_PROJECT_FUNDINGS
1097: WHERE Agreement_id = X_Agreement_Id
1098: AND Project_Id = X_Award_Project_Id;
1099:
1100: X_Err_Code := 'S';

Line 1140: UPDATE PA_SUMMARY_PROJECT_FUNDINGS

1136: X_Err_Code OUT NOCOPY VARCHAR2,
1137: X_Err_Stage OUT NOCOPY VARCHAR2) IS
1138: --p_msg_count NUMBER;
1139: BEGIN
1140: UPDATE PA_SUMMARY_PROJECT_FUNDINGS
1141: SET TOTAL_UNBASELINED_AMOUNT = X_Total_Unbaselined_Amount,
1142: -- Bug 2475640 : Added for 11.5 PA-J certification.
1143: PROJECT_UNBASELINED_AMOUNT = X_Total_Unbaselined_Amount,
1144: PROJFUNC_UNBASELINED_AMOUNT = X_Total_Unbaselined_Amount,

Line 1181: x_currency_code pa_summary_project_fundings.funding_currency_code%type := pa_currency.get_currency_code; -- Bug 2475640 : Added for 11.5 PA-J certification.

1177: X_Err_Stage OUT NOCOPY VARCHAR2) IS
1178: --p_msg_count NUMBER;
1179:
1180:
1181: x_currency_code pa_summary_project_fundings.funding_currency_code%type := pa_currency.get_currency_code; -- Bug 2475640 : Added for 11.5 PA-J certification.
1182:
1183: BEGIN
1184: INSERT INTO
1185: PA_SUMMARY_PROJECT_FUNDINGS(AGREEMENT_ID,

Line 1185: PA_SUMMARY_PROJECT_FUNDINGS(AGREEMENT_ID,

1181: x_currency_code pa_summary_project_fundings.funding_currency_code%type := pa_currency.get_currency_code; -- Bug 2475640 : Added for 11.5 PA-J certification.
1182:
1183: BEGIN
1184: INSERT INTO
1185: PA_SUMMARY_PROJECT_FUNDINGS(AGREEMENT_ID,
1186: PROJECT_ID,
1187: TOTAL_UNBASELINED_AMOUNT,
1188: -- Bug 2475640 : Added for 11.5 PA-J certification.
1189: FUNDING_CURRENCY_CODE,

Line 1449: PA_SUMMARY_PROJECT_FUNDINGS

1445: --p_msg_count NUMBER;
1446: BEGIN
1447: delete
1448: FROM
1449: PA_SUMMARY_PROJECT_FUNDINGS
1450: WHERE
1451: AGREEMENT_ID = X_Agreement_Id and
1452: PROJECT_ID = X_Award_Project_Id;
1453: IF SQL%ROWCOUNT = 0 THEN

Line 1455: X_Err_Stage := 'There were no rows deleted FROM PA_SUMMARY_PROJECT_FUNDINGS';

1451: AGREEMENT_ID = X_Agreement_Id and
1452: PROJECT_ID = X_Award_Project_Id;
1453: IF SQL%ROWCOUNT = 0 THEN
1454: X_Err_Code := 'E';
1455: X_Err_Stage := 'There were no rows deleted FROM PA_SUMMARY_PROJECT_FUNDINGS';
1456: X_Err_Stage := 'GMS_NO_SUMM_FUNDING_DELETED';
1457: FND_MESSAGE.SET_NAME('GMS','GMS_NO_SUMM_FUNDING_DELETED');
1458: FND_MSG_PUB.add;
1459: FND_MSG_PUB.Count_And_Get

Line 1682: FROM PA_SUMMARY_PROJECT_FUNDINGS

1678: BEGIN
1679: SELECT COUNT(X_Agreement_Id)
1680: INTO
1681: Check_Funding_Exists
1682: FROM PA_SUMMARY_PROJECT_FUNDINGS
1683: WHERE AGREEMENT_ID = X_Agreement_Id;
1684: IF Check_Funding_Exists >= 1 THEN
1685: RETCODE := 'E';
1686: ERRBUF := 'Cannot delete Agreement while Funding Exists ';

Line 4443: -- deleting records FROM pa_summary_project_fundings

4439: X_Total_Funding_Budget NUMBER(22,5) := 0;
4440:
4441: -- Bug 2270436 : Added function pa_funding_exists
4442: -- This function checks for existence of any record in pa_project_fundings before
4443: -- deleting records FROM pa_summary_project_fundings
4444:
4445: FUNCTION pa_funding_exists (p_agreement_id NUMBER, p_award_project_id NUMBER)
4446: RETURN BOOLEAN
4447: IS