DBA Data[Home] [Help]

APPS.GMS_MULTI_FUNDING dependencies on PA_BUDGET_TYPES

Line 2029: INSERT INTO PA_BUDGET_TYPES(BUDGET_TYPE_CODE,

2025: X_Award_Flag IN VARCHAR2,
2026: X_Err_Code OUT NOCOPY VARCHAR2,
2027: X_Err_Stage OUT NOCOPY VARCHAR2) IS
2028: BEGIN
2029: INSERT INTO PA_BUDGET_TYPES(BUDGET_TYPE_CODE,
2030: LAST_UPDATE_DATE,
2031: LAST_UPDATED_BY,
2032: CREATION_DATE,
2033: CREATED_BY,

Line 2085: UPDATE PA_BUDGET_TYPES

2081: X_End_Date IN DATE,
2082: X_Err_Code OUT NOCOPY VARCHAR2,
2083: X_Err_Stage OUT NOCOPY VARCHAR2) IS
2084: BEGIN
2085: UPDATE PA_BUDGET_TYPES
2086: SET Budget_Type = X_Budget_Type
2087: /* Start_Date_Active = X_Start_Date,
2088: End_Date_Active = X_End_Date */
2089: WHERE

Line 2111: DELETE FROM PA_BUDGET_TYPES

2107: PROCEDURE DELETE_AWARD_BUDGET_TYPE(X_Budget_Type_Code IN VARCHAR2,
2108: X_Err_Code OUT NOCOPY VARCHAR2,
2109: X_Err_Stage OUT NOCOPY VARCHAR2) IS
2110: BEGIN
2111: DELETE FROM PA_BUDGET_TYPES
2112: WHERE
2113: BUDGET_TYPE_CODE = X_Budget_Type_Code;
2114: X_Err_Code := 'S';
2115: IF SQL%ROWCOUNT = 0 THEN