[Home] [Help]
152: )
153: IS
154:
155: -- Local Variables
156: l_Top_Task_ID PA_Tasks.Task_ID%TYPE;
157: l_Parent_Member_ID PA_Resource_List_Members.Parent_Member_ID%TYPE;
158: l_Project_Status_Code VARCHAR2(100);
159: l_Change_Reason_Code VARCHAR2(100);
160: l_Message_Code_Error VARCHAR2(100);
175: l_Work_Resource_Assign_ID PA_Resource_Assignments.Resource_Assignment_ID%TYPE;
176: l_Bslnd_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;
177: l_Project_ID PA_Projects_all.Project_ID%TYPE;
178: l_Project_Completion_Date DATE;
179: l_Task_ID PA_Tasks.Task_ID%TYPE;
180: l_Budget_Type_Code PA_Budget_Types.Budget_Type_Code%TYPE;
181: l_Encumbrance_Type_ID GL_Encumbrance_Types.Encumbrance_Type_ID%TYPE;
182: l_External_Budget_Code PA_Budgetary_Control_Options.External_Budget_Code%TYPE;
183: l_GL_Budget_Version_ID PA_Budgetary_Control_Options.GL_Budget_Version_ID%TYPE;
595: -- Derive Top Task ID
596: BEGIN
597: SELECT Top_Task_ID
598: INTO l_Top_Task_ID
599: FROM PA_TASKS
600: WHERE Task_ID = l_Task_ID
601: AND Project_ID = l_Project_ID ;
602:
603: IF P_DEBUG_MODE = 'Y' THEN
1606: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,
1607: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
1608: P_Transfer_Amount IN NUMBER,
1609: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
1610: P_Task_ID IN PA_Tasks.Task_ID%TYPE,
1611: P_Resource_List_Member_ID IN PA_Resource_List_Members.Resource_List_Member_ID%TYPE,
1612: P_Raw_Cost_Flag IN PA_Budget_Entry_Methods.Raw_Cost_Flag%TYPE,
1613: P_Burdened_Cost_Flag IN PA_Budget_Entry_Methods.Burdened_Cost_Flag%TYPE,
1614: P_CCID IN GL_Code_Combinations.Code_Combination_ID%TYPE,
2216: 0,
2217: l_request_id
2218: from pa_budget_lines pb,
2219: pa_resource_assignments pa,
2220: pa_tasks pt,
2221: pa_resource_list_members rm,
2222: pa_budget_versions pbv
2223: where pbv.budget_version_id = p_budget_version_id
2224: and pa.resource_assignment_id = pb.resource_assignment_id