[Home] [Help]
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,
11: P_CCID IN gl_Code_Combinations.code_Combination_Id%TYPE,
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;
48: l_Return_Status VARCHAR2(50);
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,
128: X_Msg_Data OUT NOCOPY VARCHAR2
129: )
146: l_Msg_Count NUMBER;
147: l_Msg_Data VARCHAR2(500);
148:
149: l_Max_Version_Number NUMBER;
150: l_Project_Number PA_Projects_All.Segment1%TYPE;
151: l_Project_Org_Name HR_Organization_Units.Name%TYPE;
152: l_Project_Org_ID HR_Organization_Units.Organization_ID %TYPE;
153: l_Project_Type PA_Project_Types_All.Project_Type%TYPE;
154: l_Project_Class_Code PA_Project_Classes.Class_Code%TYPE; /* Added for bug 2914197 */
276: l_Project_Start_Date,
277: l_Project_End_Date
278: FROM
279: HR_All_Organization_Units ORG,
280: PA_Projects PROJ
281: WHERE
282: PROJ.Project_ID = P_Project_ID
283: AND ORG.Organization_ID = PROJ.Carrying_Out_Organization_ID ;
284: END;
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,
748: P_project_Org_ID IN HR_Organization_Units.Organization_ID %TYPE,
749: P_Project_Type IN PA_Project_Types_All.Project_Type%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,
748: P_project_Org_ID IN HR_Organization_Units.Organization_ID %TYPE,
749: P_Project_Type IN PA_Project_Types_All.Project_Type%TYPE,
750: P_Project_Class_Code IN PA_Project_Classes.Class_Code%TYPE, /* added for bug 2914197 */
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,
1237: P_CCID IN gl_Code_Combinations.code_Combination_Id%TYPE,
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,
1380: X_Msg_Count OUT NOCOPY NUMBER,
1774:
1775: END Derive_Resource_Params ; /* End API Derive_Resource_Params */
1776:
1777: PROCEDURE Derive_Task_Params (
1778: p_project_Id IN pa_projects_All.project_Id%TYPE,
1779: p_top_task_Id IN pa_tasks.task_Id%TYPE,
1780: p_low_task_Id IN pa_tasks.task_Id%TYPE,
1781: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
1782: x_task_organization_Id OUT NOCOPY hr_organization_units.organization_Id%TYPE,