DBA Data[Home] [Help]

APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PA_BUDGET_TYPES

Line 6: p_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,

2: -- $Header: PABDACGB.pls 120.6.12000000.3 2007/10/26 05:42:44 pvishnoi ship $
3:
4: -- ## Forward Declaration
5: PROCEDURE Upd_Budget_Acct_Line (
6: p_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
7: p_Project_ID IN PA_Projects_All.Project_ID%TYPE,
8: p_Period_Name IN GL_PERIODS.period_name%TYPE,
9: p_Start_Date IN DATE,
10: p_End_Date IN DATE,

Line 43: l_Budget_Type_Code PA_Budget_Types.Budget_Type_Code%TYPE;

39: )
40: AS
41:
42: -- Local Parameters:
43: l_Budget_Type_Code PA_Budget_Types.Budget_Type_Code%TYPE;
44: l_Project_ID PA_Projects_All.Project_ID%TYPE;
45: l_Budget_Entry_Level_Code PA_Budget_Entry_Methods.Entry_Level_Code%TYPE;
46:
47: l_msg_Index_out NUMBER;

Line 123: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,

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,
126: X_Return_Status OUT NOCOPY VARCHAR2,
127: X_Msg_Count OUT NOCOPY NUMBER,

Line 161: l_budget_amount_code Pa_Budget_Types.Budget_Amount_Code%TYPE ;

157:
158: l_Msg_Index_Out NUMBER;
159:
160: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;
161: l_budget_amount_code Pa_Budget_Types.Budget_Amount_Code%TYPE ;
162:
163: l_is_cc_budget varchar2(1); --Bug 6524116
164: -----------------------------------------------------------------------+
165: -- Need cursor to fetch all the budget line details from Budget Lines

Line 229: PA_BUDGET_TYPES PBT

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
233: AND PBV.Budget_Type_Code = PBT.Budget_Type_Code;

Line 742: P_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,

738:
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,

Line 1232: p_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,

1228:
1229: END Gen_Acct_Line ; /* End API Gen_Acct_Line */
1230:
1231: PROCEDURE Upd_Budget_Acct_Line (
1232: p_Budget_Type_Code IN PA_Budget_Types.Budget_Type_Code%TYPE,
1233: p_Project_ID IN PA_Projects_All.Project_ID%TYPE,
1234: p_Period_Name IN GL_PERIODS.period_name%TYPE,
1235: p_Start_Date IN DATE,
1236: p_End_Date IN DATE,