APPS.GMS_MULTI_FUNDING dependencies on PA_BUDGET_VERSIONS

Line 1249: FROM PA_BUDGET_VERSIONS

1245: BEGIN
1246: SELECT 1
1247: INTO
1248: Draft_Budget_Check
1249: FROM PA_BUDGET_VERSIONS
1250: WHERE
1251: Project_Id = X_Award_Project_Id and
1252: budget_type_code = 'AR' and
1253: budget_status_code in ('W' , 'S');

Line 1474: PA_BUDGET_VERSIONS

1470: CURSOR GET_BUDGET_VERSION_CSR(X_Award_Project_Id NUMBER) IS
1471: SELECT
1472: BUDGET_VERSION_ID
1473: FROM
1474: PA_BUDGET_VERSIONS
1475: WHERE
1476: PROJECT_ID = X_Award_Project_Id and
1477: BUDGET_TYPE_CODE = 'AR';
1478:

Line 1529: PA_BUDGET_VERSIONS

1525: WHERE PROJECT_ID=X_Award_Project_Id ;
1526: /* BUG NO.1545351 END */
1527: DELETE
1528: FROM
1529: PA_BUDGET_VERSIONS
1530: WHERE
1531: PROJECT_ID = X_Award_Project_Id and
1532: BUDGET_TYPE_CODE = 'AR';
1533: IF SQL%ROWCOUNT = 0 THEN

Line 1535: X_Err_Stage := ('No rows delete FROM PA_BUDGET_VERSIONS for Project Id '||X_Award_Project_Id);

1531: PROJECT_ID = X_Award_Project_Id and
1532: BUDGET_TYPE_CODE = 'AR';
1533: IF SQL%ROWCOUNT = 0 THEN
1534: X_Err_Code := 'E';
1535: X_Err_Stage := ('No rows delete FROM PA_BUDGET_VERSIONS for Project Id '||X_Award_Project_Id);
1536: X_Err_Stage := 'GMS_NO_BUD_VERS_DELETED';
1537: FND_MESSAGE.SET_NAME('GMS','GMS_NO_BUD_VERS_DELETED');
1538: FND_MESSAGE.SET_TOKEN('AWARD_PROJECT_ID',to_char(X_Award_Project_Id) );
1539: FND_MSG_PUB.add;