APPS.GMS_MULTI_FUNDING dependencies on PA_PROJECT_FUNDINGS

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

890: X_Err_Stage OUT NOCOPY VARCHAR2) IS
891:
892: --p_msg_count NUMBER;
893:
894: x_currency_code pa_project_fundings.funding_currency_code%type := pa_currency.get_currency_code; -- Bug 2475640 : Added for 11.5 PA-J certification.
895:
896: BEGIN
897: INSERT INTO PA_PROJECT_FUNDINGS(PROJECT_FUNDING_ID,
898: AGREEMENT_ID,

Line 897: INSERT INTO PA_PROJECT_FUNDINGS(PROJECT_FUNDING_ID,

893:
894: x_currency_code pa_project_fundings.funding_currency_code%type := pa_currency.get_currency_code; -- Bug 2475640 : Added for 11.5 PA-J certification.
895:
896: BEGIN
897: INSERT INTO PA_PROJECT_FUNDINGS(PROJECT_FUNDING_ID,
898: AGREEMENT_ID,
899: PROJECT_ID,
900: BUDGET_TYPE_CODE,
901: ALLOCATED_AMOUNT,

Line 944: UPDATE pa_project_fundings proj

940: fnd_global.login_id);
941:
942: -- Bug 2475640 : Added Following UPDATE statement to UPDATE funding_category
943:
944: UPDATE pa_project_fundings proj
945: SET funding_category = 'ORIGINAL'
946: WHERE proj.project_funding_id IN (SELECT min(project_funding_id)
947: FROM pa_project_fundings
948: WHERE project_id = X_award_project_id

Line 947: FROM pa_project_fundings

943:
944: UPDATE pa_project_fundings proj
945: SET funding_category = 'ORIGINAL'
946: WHERE proj.project_funding_id IN (SELECT min(project_funding_id)
947: FROM pa_project_fundings
948: WHERE project_id = X_award_project_id
949: AND agreement_id = X_agreement_id
950: GROUP BY agreement_id,project_id,NVL(task_id,0))
951: AND proj.project_funding_id = X_Project_Funding_Id

Line 955: UPDATE pa_project_fundings

951: AND proj.project_funding_id = X_Project_Funding_Id
952: AND funding_category is null;
953:
954:
955: UPDATE pa_project_fundings
956: SET funding_category='ADDITIONAL'
957: WHERE funding_category is null
958: AND project_funding_id = X_Project_Funding_Id;
959:

Line 1308: PA_PROJECT_FUNDINGS

1304: BUDGET_TYPE_CODE
1305: INTO
1306: St_Budget_Type_Code
1307: FROM
1308: PA_PROJECT_FUNDINGS
1309: WHERE
1310: PROJECT_FUNDING_ID = X_Project_Funding_Id;
1311: X_Err_Code := 'S';
1312: EXCEPTION

Line 1330: UPDATE PA_PROJECT_FUNDINGS

1326:
1327: --IF St_Budget_Type_Code = 'DRAFT' THEN
1328: IF X_Old_Allocated_Amount <> X_New_Allocated_Amount THEN
1329:
1330: UPDATE PA_PROJECT_FUNDINGS
1331: SET ALLOCATED_AMOUNT = X_New_Allocated_Amount,
1332: -- Bug 2475640 : Added for 11.5 PA-J certification.
1333: PROJECT_ALLOCATED_AMOUNT = X_New_Allocated_Amount,
1334: PROJFUNC_ALLOCATED_AMOUNT = X_New_Allocated_Amount,

Line 1361: UPDATE PA_PROJECT_FUNDINGS

1357: END IF;
1358: END IF;
1359: IF X_Old_Date_Allocated <> X_New_Date_Allocated THEN
1360:
1361: UPDATE PA_PROJECT_FUNDINGS
1362: SET DATE_ALLOCATED = X_New_Date_Allocated,
1363: LAST_UPDATE_DATE = SYSDATE ,
1364: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1365: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1412: PA_PROJECT_FUNDINGS

1408: --p_msg_count NUMBER;
1409: BEGIN
1410: delete
1411: FROM
1412: PA_PROJECT_FUNDINGS
1413: WHERE
1414: PROJECT_FUNDING_ID = X_Project_Funding_Id;
1415: -- and BUDGET_TYPE_CODE = 'DRAFT';
1416: IF SQL%ROWCOUNT = 0 THEN

Line 4058: PA_PROJECT_FUNDINGS_S.NEXTVAL

4054: FND_MSG_PUB.Initialize;
4055: --Get next sequence for PA_PROJECT_FUNDING//
4056: BEGIN
4057: Select
4058: PA_PROJECT_FUNDINGS_S.NEXTVAL
4059: INTO
4060: St_Project_Funding_Id
4061: FROM
4062: DUAL;

Line 4113: --dbms_output.put_line('Before Insert INTO PA Project Fundings');

4109: END;
4110:
4111: G_Stage := '(1030:CALLING INSERT_DETAIL_PROJECT_FUNDING)';
4112: --Insert row INTO PA_PROJECT_FUNDING for Award Project //
4113: --dbms_output.put_line('Before Insert INTO PA Project Fundings');
4114: BEGIN
4115: INSERT_DETAIL_PROJECT_FUNDING(St_Project_Funding_Id,
4116: X_Agreement_Id,
4117: X_Award_Project_Id,

Line 4442: -- This function checks for existence of any record in pa_project_fundings before

4438: X_Total_Baselined_Amount NUMBER(22,5) := 0;
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

Line 4453: FROM pa_project_fundings

4449: IS
4450: SELECT 1
4451: FROM DUAL
4452: WHERE EXISTS (SELECT 1
4453: FROM pa_project_fundings
4454: WHERE agreement_id = p_agreement_id
4455: AND project_id = p_award_project_id);
4456:
4457: x_dummy NUMBER := 0;