DBA Data[Home] [Help]

APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PA_BUDGET_VERSIONS

Line 12: P_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,

8: p_Period_Name IN GL_PERIODS.period_name%TYPE,
9: p_Start_Date IN DATE,
10: p_End_Date IN DATE,
11: P_CCID IN gl_Code_Combinations.code_Combination_Id%TYPE,
12: P_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,
13: p_Prev_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,
14: p_Amount IN NUMBER,
15: X_Return_Status OUT NOCOPY VARCHAR2,
16: X_Msg_Count OUT NOCOPY NUMBER,

Line 13: p_Prev_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,

9: p_Start_Date IN DATE,
10: p_End_Date IN DATE,
11: P_CCID IN gl_Code_Combinations.code_Combination_Id%TYPE,
12: P_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,
13: p_Prev_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,
14: p_Amount IN NUMBER,
15: X_Return_Status OUT NOCOPY VARCHAR2,
16: X_Msg_Count OUT NOCOPY NUMBER,
17: X_Msg_Data OUT NOCOPY VARCHAR2

Line 34: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,

30: -- P_Calling_Mode--> SUBMIT/ BASELINE / GENERATE_ACCOUNT
31: ----------------------------------------------------------------------------------------+
32:
33: PROCEDURE Gen_Account (
34: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
35: P_Calling_Mode IN VARCHAR2,
36: X_Return_Status OUT NOCOPY VARCHAR2,
37: X_Msg_Count OUT NOCOPY NUMBER,
38: X_Msg_Data OUT NOCOPY VARCHAR2

Line 75: PA_Budget_versions BVER,

71: l_Budget_Type_Code,
72: l_Project_ID,
73: l_Budget_Entry_Level_Code
74: FROM
75: PA_Budget_versions BVER,
76: PA_Budget_Entry_Methods BEM,
77: PA_Budgetary_Control_Options BCO
78: WHERE
79: BVER.Budget_Version_ID = p_Budget_version_Id

Line 121: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,

117: P_Procedure_Name => 'Gen_Account');
118: END Gen_Account; /* End of Gen_Account API */
119:
120: PROCEDURE Gen_Acct_All_Lines (
121: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
122: P_Calling_Mode IN VARCHAR2,
123: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
124: P_Budget_Entry_Level_Code IN PA_Budget_Entry_Methods.Entry_Level_Code%TYPE,
125: P_Project_ID IN PA_projects_All.project_Id%TYPE,

Line 136: l_Prev_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;

132: -- Local Parameters
133: l_acc_gen_error EXCEPTION;
134: l_no_budgetary_control EXCEPTION;
135:
136: l_Prev_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;
137: l_Concat_Segs VARCHAR2(500);
138: l_Concat_IDs VARCHAR2(500);
139: l_Concat_Descrs VARCHAR2(500);
140: l_Error_Message VARCHAR2(2000);

Line 228: PA_BUDGET_VERSIONS PBV ,

224: Cursor c_Budget_funds is
225: Select PBCO.Balance_type,
226: PBT.Budget_Amount_Code
227: From PA_BUDGETARY_CONTROL_OPTIONS PBCO ,
228: PA_BUDGET_VERSIONS PBV ,
229: PA_BUDGET_TYPES PBT
230: WHERE PBCO.Project_Id = p_project_id
231: AND PBV.Budget_version_id = p_Budget_version_id
232: AND PBV.Budget_Type_Code = PBCO.Budget_Type_Code

Line 320: PA_Budget_Versions

316: MAX(Version_Number)
317: INTO
318: l_Max_Version_Number
319: FROM
320: PA_Budget_Versions
321: WHERE
322: Project_ID = p_Project_ID
323: AND Budget_Status_Code = 'B'
324: AND Budget_Type_Code = p_Budget_Type_Code ;

Line 335: PA_Budget_Versions

331: Budget_Version_ID
332: INTO
333: l_Prev_Budget_Version_ID
334: FROM
335: PA_Budget_Versions
336: WHERE
337: Project_ID = p_Project_ID
338: AND Budget_Status_Code = 'B'
339: AND Budget_Type_Code = p_Budget_Type_Code

Line 743: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,

739: PROCEDURE Gen_Acct_Line (
740:
741: P_Budget_Entry_Level_Code IN PA_Budget_Entry_Methods.Entry_Level_Code%TYPE,
742: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
743: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
744:
745: P_Project_ID IN PA_Projects_All.Project_ID%TYPE,
746: P_Project_Number IN PA_Projects_All.Segment1%TYPE,
747: P_Project_Org_Name IN HR_Organization_Units.Name%TYPE,

Line 1238: P_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,

1234: p_Period_Name IN GL_PERIODS.period_name%TYPE,
1235: p_Start_Date IN DATE,
1236: p_End_Date IN DATE,
1237: P_CCID IN gl_Code_Combinations.code_Combination_Id%TYPE,
1238: P_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,
1239: p_Prev_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,
1240: p_Amount IN NUMBER,
1241: X_Return_Status OUT NOCOPY VARCHAR2,
1242: X_Msg_Count OUT NOCOPY NUMBER,

Line 1239: p_Prev_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,

1235: p_Start_Date IN DATE,
1236: p_End_Date IN DATE,
1237: P_CCID IN gl_Code_Combinations.code_Combination_Id%TYPE,
1238: P_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,
1239: p_Prev_Budget_Version_ID IN pa_Budget_versions.budget_version_Id%TYPE,
1240: p_Amount IN NUMBER,
1241: X_Return_Status OUT NOCOPY VARCHAR2,
1242: X_Msg_Count OUT NOCOPY NUMBER,
1243: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1375: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,

1371:
1372: END Upd_Budget_Acct_Line; /* End API UPD_Budget_Acct_Line */
1373:
1374: PROCEDURE Insert_Into_Budget_Lines (
1375: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
1376: P_Project_ID IN PA_projects_All.project_Id%TYPE,
1377: P_Project_Start_Date IN DATE,
1378: P_Project_End_Date IN DATE,
1379: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1478: PA_BUDGET_VERSIONS PBV

1474:
1475: SELECT PBCO.boundary_code
1476: INTO l_boundary_code
1477: FROM PA_BUDGETARY_CONTROL_OPTIONS PBCO,
1478: PA_BUDGET_VERSIONS PBV
1479: WHERE PBV.Project_Id = p_project_id
1480: AND PBV.Budget_version_id = p_Budget_version_id
1481: AND PBCO.Project_id = PBV.Project_id
1482: AND PBCO.Budget_Type_Code = PBV.Budget_Type_Code;