[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);
174: l_Work_Resource_Assign_ID PA_Resource_Assignments.Resource_Assignment_ID%TYPE;
175: l_Bslnd_Budget_Version_ID PA_Budget_Versions.Budget_Version_ID%TYPE;
176: l_Project_ID PA_Projects_all.Project_ID%TYPE;
177: l_Project_Completion_Date DATE;
178: l_Task_ID PA_Tasks.Task_ID%TYPE;
179: l_Budget_Type_Code PA_Budget_Types.Budget_Type_Code%TYPE;
180: l_Encumbrance_Type_ID GL_Encumbrance_Types.Encumbrance_Type_ID%TYPE;
181: l_External_Budget_Code PA_Budgetary_Control_Options.External_Budget_Code%TYPE;
182: l_GL_Budget_Version_ID PA_Budgetary_Control_Options.GL_Budget_Version_ID%TYPE;
594: -- Derive Top Task ID
595: BEGIN
596: SELECT Top_Task_ID
597: INTO l_Top_Task_ID
598: FROM PA_TASKS
599: WHERE Task_ID = l_Task_ID
600: AND Project_ID = l_Project_ID ;
601:
602: IF P_DEBUG_MODE = 'Y' THEN
1549: P_Period_Start_Date IN GL_Periods.Start_Date%TYPE,
1550: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
1551: P_Transfer_Amount IN NUMBER,
1552: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
1553: P_Task_ID IN PA_Tasks.Task_ID%TYPE,
1554: P_Resource_List_Member_ID IN PA_Resource_List_Members.Resource_List_Member_ID%TYPE,
1555: P_Raw_Cost_Flag IN PA_Budget_Entry_Methods.Raw_Cost_Flag%TYPE,
1556: P_Burdened_Cost_Flag IN PA_Budget_Entry_Methods.Burdened_Cost_Flag%TYPE,
1557: P_CCID IN GL_Code_Combinations.Code_Combination_ID%TYPE,
2159: 0,
2160: l_request_id
2161: from pa_budget_lines pb,
2162: pa_resource_assignments pa,
2163: pa_tasks pt,
2164: pa_resource_list_members rm,
2165: pa_budget_versions pbv
2166: where pbv.budget_version_id = p_budget_version_id
2167: and pa.resource_assignment_id = pb.resource_assignment_id