118:
119: TYPE spread_curve_type IS TABLE OF NUMBER;
120:
121: TYPE resource_assignment_rec_type IS RECORD (
122: RESOURCE_ASSIGNMENT_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_ASSIGNMENT_ID%TYPE
123: ,BUDGET_VERSION_ID PA_FP_RES_ASSIGNMENTS_TMP.BUDGET_VERSION_ID%TYPE
124: ,PROJECT_ID PA_FP_RES_ASSIGNMENTS_TMP.PROJECT_ID%TYPE
125: ,TASK_ID PA_FP_RES_ASSIGNMENTS_TMP.TASK_ID%TYPE
126: ,RESOURCE_LIST_MEMBER_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_LIST_MEMBER_ID%TYPE
119: TYPE spread_curve_type IS TABLE OF NUMBER;
120:
121: TYPE resource_assignment_rec_type IS RECORD (
122: RESOURCE_ASSIGNMENT_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_ASSIGNMENT_ID%TYPE
123: ,BUDGET_VERSION_ID PA_FP_RES_ASSIGNMENTS_TMP.BUDGET_VERSION_ID%TYPE
124: ,PROJECT_ID PA_FP_RES_ASSIGNMENTS_TMP.PROJECT_ID%TYPE
125: ,TASK_ID PA_FP_RES_ASSIGNMENTS_TMP.TASK_ID%TYPE
126: ,RESOURCE_LIST_MEMBER_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_LIST_MEMBER_ID%TYPE
127: ,PLANNING_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_START_DATE%TYPE
120:
121: TYPE resource_assignment_rec_type IS RECORD (
122: RESOURCE_ASSIGNMENT_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_ASSIGNMENT_ID%TYPE
123: ,BUDGET_VERSION_ID PA_FP_RES_ASSIGNMENTS_TMP.BUDGET_VERSION_ID%TYPE
124: ,PROJECT_ID PA_FP_RES_ASSIGNMENTS_TMP.PROJECT_ID%TYPE
125: ,TASK_ID PA_FP_RES_ASSIGNMENTS_TMP.TASK_ID%TYPE
126: ,RESOURCE_LIST_MEMBER_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_LIST_MEMBER_ID%TYPE
127: ,PLANNING_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_START_DATE%TYPE
128: ,PLANNING_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_END_DATE%TYPE
121: TYPE resource_assignment_rec_type IS RECORD (
122: RESOURCE_ASSIGNMENT_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_ASSIGNMENT_ID%TYPE
123: ,BUDGET_VERSION_ID PA_FP_RES_ASSIGNMENTS_TMP.BUDGET_VERSION_ID%TYPE
124: ,PROJECT_ID PA_FP_RES_ASSIGNMENTS_TMP.PROJECT_ID%TYPE
125: ,TASK_ID PA_FP_RES_ASSIGNMENTS_TMP.TASK_ID%TYPE
126: ,RESOURCE_LIST_MEMBER_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_LIST_MEMBER_ID%TYPE
127: ,PLANNING_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_START_DATE%TYPE
128: ,PLANNING_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_END_DATE%TYPE
129: ,SPREAD_CURVE_ID PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_CURVE_ID%TYPE
122: RESOURCE_ASSIGNMENT_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_ASSIGNMENT_ID%TYPE
123: ,BUDGET_VERSION_ID PA_FP_RES_ASSIGNMENTS_TMP.BUDGET_VERSION_ID%TYPE
124: ,PROJECT_ID PA_FP_RES_ASSIGNMENTS_TMP.PROJECT_ID%TYPE
125: ,TASK_ID PA_FP_RES_ASSIGNMENTS_TMP.TASK_ID%TYPE
126: ,RESOURCE_LIST_MEMBER_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_LIST_MEMBER_ID%TYPE
127: ,PLANNING_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_START_DATE%TYPE
128: ,PLANNING_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_END_DATE%TYPE
129: ,SPREAD_CURVE_ID PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_CURVE_ID%TYPE
130: ,SP_FIXED_DATE PA_FP_RES_ASSIGNMENTS_TMP.SP_FIXED_DATE%TYPE
123: ,BUDGET_VERSION_ID PA_FP_RES_ASSIGNMENTS_TMP.BUDGET_VERSION_ID%TYPE
124: ,PROJECT_ID PA_FP_RES_ASSIGNMENTS_TMP.PROJECT_ID%TYPE
125: ,TASK_ID PA_FP_RES_ASSIGNMENTS_TMP.TASK_ID%TYPE
126: ,RESOURCE_LIST_MEMBER_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_LIST_MEMBER_ID%TYPE
127: ,PLANNING_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_START_DATE%TYPE
128: ,PLANNING_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_END_DATE%TYPE
129: ,SPREAD_CURVE_ID PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_CURVE_ID%TYPE
130: ,SP_FIXED_DATE PA_FP_RES_ASSIGNMENTS_TMP.SP_FIXED_DATE%TYPE
131: ,TXN_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
124: ,PROJECT_ID PA_FP_RES_ASSIGNMENTS_TMP.PROJECT_ID%TYPE
125: ,TASK_ID PA_FP_RES_ASSIGNMENTS_TMP.TASK_ID%TYPE
126: ,RESOURCE_LIST_MEMBER_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_LIST_MEMBER_ID%TYPE
127: ,PLANNING_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_START_DATE%TYPE
128: ,PLANNING_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_END_DATE%TYPE
129: ,SPREAD_CURVE_ID PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_CURVE_ID%TYPE
130: ,SP_FIXED_DATE PA_FP_RES_ASSIGNMENTS_TMP.SP_FIXED_DATE%TYPE
131: ,TXN_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
132: ,TXN_CURRENCY_CODE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
125: ,TASK_ID PA_FP_RES_ASSIGNMENTS_TMP.TASK_ID%TYPE
126: ,RESOURCE_LIST_MEMBER_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_LIST_MEMBER_ID%TYPE
127: ,PLANNING_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_START_DATE%TYPE
128: ,PLANNING_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_END_DATE%TYPE
129: ,SPREAD_CURVE_ID PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_CURVE_ID%TYPE
130: ,SP_FIXED_DATE PA_FP_RES_ASSIGNMENTS_TMP.SP_FIXED_DATE%TYPE
131: ,TXN_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
132: ,TXN_CURRENCY_CODE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
133: ,PROJECT_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
126: ,RESOURCE_LIST_MEMBER_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_LIST_MEMBER_ID%TYPE
127: ,PLANNING_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_START_DATE%TYPE
128: ,PLANNING_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_END_DATE%TYPE
129: ,SPREAD_CURVE_ID PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_CURVE_ID%TYPE
130: ,SP_FIXED_DATE PA_FP_RES_ASSIGNMENTS_TMP.SP_FIXED_DATE%TYPE
131: ,TXN_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
132: ,TXN_CURRENCY_CODE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
133: ,PROJECT_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
134: ,PROJFUNC_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
127: ,PLANNING_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_START_DATE%TYPE
128: ,PLANNING_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_END_DATE%TYPE
129: ,SPREAD_CURVE_ID PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_CURVE_ID%TYPE
130: ,SP_FIXED_DATE PA_FP_RES_ASSIGNMENTS_TMP.SP_FIXED_DATE%TYPE
131: ,TXN_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
132: ,TXN_CURRENCY_CODE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
133: ,PROJECT_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
134: ,PROJFUNC_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
135: ,TXN_REVENUE PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE%TYPE
128: ,PLANNING_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_END_DATE%TYPE
129: ,SPREAD_CURVE_ID PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_CURVE_ID%TYPE
130: ,SP_FIXED_DATE PA_FP_RES_ASSIGNMENTS_TMP.SP_FIXED_DATE%TYPE
131: ,TXN_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
132: ,TXN_CURRENCY_CODE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
133: ,PROJECT_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
134: ,PROJFUNC_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
135: ,TXN_REVENUE PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE%TYPE
136: ,TXN_REVENUE_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE_ADDL%TYPE
129: ,SPREAD_CURVE_ID PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_CURVE_ID%TYPE
130: ,SP_FIXED_DATE PA_FP_RES_ASSIGNMENTS_TMP.SP_FIXED_DATE%TYPE
131: ,TXN_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
132: ,TXN_CURRENCY_CODE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
133: ,PROJECT_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
134: ,PROJFUNC_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
135: ,TXN_REVENUE PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE%TYPE
136: ,TXN_REVENUE_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE_ADDL%TYPE
137: ,TXN_RAW_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST%TYPE
130: ,SP_FIXED_DATE PA_FP_RES_ASSIGNMENTS_TMP.SP_FIXED_DATE%TYPE
131: ,TXN_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
132: ,TXN_CURRENCY_CODE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
133: ,PROJECT_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
134: ,PROJFUNC_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
135: ,TXN_REVENUE PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE%TYPE
136: ,TXN_REVENUE_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE_ADDL%TYPE
137: ,TXN_RAW_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST%TYPE
138: ,TXN_RAW_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST_ADDL%TYPE
131: ,TXN_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
132: ,TXN_CURRENCY_CODE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
133: ,PROJECT_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
134: ,PROJFUNC_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
135: ,TXN_REVENUE PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE%TYPE
136: ,TXN_REVENUE_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE_ADDL%TYPE
137: ,TXN_RAW_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST%TYPE
138: ,TXN_RAW_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST_ADDL%TYPE
139: ,TXN_BURDENED_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST%TYPE
132: ,TXN_CURRENCY_CODE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
133: ,PROJECT_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
134: ,PROJFUNC_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
135: ,TXN_REVENUE PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE%TYPE
136: ,TXN_REVENUE_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE_ADDL%TYPE
137: ,TXN_RAW_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST%TYPE
138: ,TXN_RAW_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST_ADDL%TYPE
139: ,TXN_BURDENED_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST%TYPE
140: ,TXN_BURDENED_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST_ADDL%TYPE
133: ,PROJECT_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
134: ,PROJFUNC_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
135: ,TXN_REVENUE PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE%TYPE
136: ,TXN_REVENUE_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE_ADDL%TYPE
137: ,TXN_RAW_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST%TYPE
138: ,TXN_RAW_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST_ADDL%TYPE
139: ,TXN_BURDENED_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST%TYPE
140: ,TXN_BURDENED_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST_ADDL%TYPE
141: ,TXN_PLAN_QUANTITY PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY%TYPE
134: ,PROJFUNC_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE
135: ,TXN_REVENUE PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE%TYPE
136: ,TXN_REVENUE_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE_ADDL%TYPE
137: ,TXN_RAW_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST%TYPE
138: ,TXN_RAW_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST_ADDL%TYPE
139: ,TXN_BURDENED_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST%TYPE
140: ,TXN_BURDENED_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST_ADDL%TYPE
141: ,TXN_PLAN_QUANTITY PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY%TYPE
142: ,TXN_PLAN_QUANTITY_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY_ADDL%TYPE
135: ,TXN_REVENUE PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE%TYPE
136: ,TXN_REVENUE_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE_ADDL%TYPE
137: ,TXN_RAW_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST%TYPE
138: ,TXN_RAW_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST_ADDL%TYPE
139: ,TXN_BURDENED_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST%TYPE
140: ,TXN_BURDENED_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST_ADDL%TYPE
141: ,TXN_PLAN_QUANTITY PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY%TYPE
142: ,TXN_PLAN_QUANTITY_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY_ADDL%TYPE
143: ,LINE_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_START_DATE%TYPE
136: ,TXN_REVENUE_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE_ADDL%TYPE
137: ,TXN_RAW_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST%TYPE
138: ,TXN_RAW_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST_ADDL%TYPE
139: ,TXN_BURDENED_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST%TYPE
140: ,TXN_BURDENED_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST_ADDL%TYPE
141: ,TXN_PLAN_QUANTITY PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY%TYPE
142: ,TXN_PLAN_QUANTITY_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY_ADDL%TYPE
143: ,LINE_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_START_DATE%TYPE
144: ,LINE_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_END_DATE%TYPE
137: ,TXN_RAW_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST%TYPE
138: ,TXN_RAW_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST_ADDL%TYPE
139: ,TXN_BURDENED_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST%TYPE
140: ,TXN_BURDENED_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST_ADDL%TYPE
141: ,TXN_PLAN_QUANTITY PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY%TYPE
142: ,TXN_PLAN_QUANTITY_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY_ADDL%TYPE
143: ,LINE_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_START_DATE%TYPE
144: ,LINE_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_END_DATE%TYPE
145: ,SOURCE_CONTEXT PA_FP_RES_ASSIGNMENTS_TMP.SOURCE_CONTEXT%TYPE
138: ,TXN_RAW_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST_ADDL%TYPE
139: ,TXN_BURDENED_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST%TYPE
140: ,TXN_BURDENED_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST_ADDL%TYPE
141: ,TXN_PLAN_QUANTITY PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY%TYPE
142: ,TXN_PLAN_QUANTITY_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY_ADDL%TYPE
143: ,LINE_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_START_DATE%TYPE
144: ,LINE_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_END_DATE%TYPE
145: ,SOURCE_CONTEXT PA_FP_RES_ASSIGNMENTS_TMP.SOURCE_CONTEXT%TYPE
146: ,RAW_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.RAW_COST_RATE%TYPE
139: ,TXN_BURDENED_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST%TYPE
140: ,TXN_BURDENED_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST_ADDL%TYPE
141: ,TXN_PLAN_QUANTITY PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY%TYPE
142: ,TXN_PLAN_QUANTITY_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY_ADDL%TYPE
143: ,LINE_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_START_DATE%TYPE
144: ,LINE_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_END_DATE%TYPE
145: ,SOURCE_CONTEXT PA_FP_RES_ASSIGNMENTS_TMP.SOURCE_CONTEXT%TYPE
146: ,RAW_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.RAW_COST_RATE%TYPE
147: ,RAW_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.RW_COST_RATE_OVERRIDE%TYPE
140: ,TXN_BURDENED_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST_ADDL%TYPE
141: ,TXN_PLAN_QUANTITY PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY%TYPE
142: ,TXN_PLAN_QUANTITY_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY_ADDL%TYPE
143: ,LINE_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_START_DATE%TYPE
144: ,LINE_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_END_DATE%TYPE
145: ,SOURCE_CONTEXT PA_FP_RES_ASSIGNMENTS_TMP.SOURCE_CONTEXT%TYPE
146: ,RAW_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.RAW_COST_RATE%TYPE
147: ,RAW_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.RW_COST_RATE_OVERRIDE%TYPE
148: ,BURDEN_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE%TYPE
141: ,TXN_PLAN_QUANTITY PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY%TYPE
142: ,TXN_PLAN_QUANTITY_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY_ADDL%TYPE
143: ,LINE_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_START_DATE%TYPE
144: ,LINE_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_END_DATE%TYPE
145: ,SOURCE_CONTEXT PA_FP_RES_ASSIGNMENTS_TMP.SOURCE_CONTEXT%TYPE
146: ,RAW_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.RAW_COST_RATE%TYPE
147: ,RAW_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.RW_COST_RATE_OVERRIDE%TYPE
148: ,BURDEN_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE%TYPE
149: ,BURDEN_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE_OVERRIDE%TYPE
142: ,TXN_PLAN_QUANTITY_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY_ADDL%TYPE
143: ,LINE_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_START_DATE%TYPE
144: ,LINE_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_END_DATE%TYPE
145: ,SOURCE_CONTEXT PA_FP_RES_ASSIGNMENTS_TMP.SOURCE_CONTEXT%TYPE
146: ,RAW_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.RAW_COST_RATE%TYPE
147: ,RAW_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.RW_COST_RATE_OVERRIDE%TYPE
148: ,BURDEN_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE%TYPE
149: ,BURDEN_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE_OVERRIDE%TYPE
150: ,BILL_RATE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE%TYPE
143: ,LINE_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_START_DATE%TYPE
144: ,LINE_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_END_DATE%TYPE
145: ,SOURCE_CONTEXT PA_FP_RES_ASSIGNMENTS_TMP.SOURCE_CONTEXT%TYPE
146: ,RAW_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.RAW_COST_RATE%TYPE
147: ,RAW_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.RW_COST_RATE_OVERRIDE%TYPE
148: ,BURDEN_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE%TYPE
149: ,BURDEN_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE_OVERRIDE%TYPE
150: ,BILL_RATE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE%TYPE
151: ,BILL_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE_OVERRIDE%TYPE
144: ,LINE_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_END_DATE%TYPE
145: ,SOURCE_CONTEXT PA_FP_RES_ASSIGNMENTS_TMP.SOURCE_CONTEXT%TYPE
146: ,RAW_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.RAW_COST_RATE%TYPE
147: ,RAW_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.RW_COST_RATE_OVERRIDE%TYPE
148: ,BURDEN_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE%TYPE
149: ,BURDEN_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE_OVERRIDE%TYPE
150: ,BILL_RATE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE%TYPE
151: ,BILL_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE_OVERRIDE%TYPE
152: ,RATE_BASED_FLAG PA_FP_RES_ASSIGNMENTS_TMP.RATE_BASED_FLAG%TYPE
145: ,SOURCE_CONTEXT PA_FP_RES_ASSIGNMENTS_TMP.SOURCE_CONTEXT%TYPE
146: ,RAW_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.RAW_COST_RATE%TYPE
147: ,RAW_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.RW_COST_RATE_OVERRIDE%TYPE
148: ,BURDEN_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE%TYPE
149: ,BURDEN_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE_OVERRIDE%TYPE
150: ,BILL_RATE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE%TYPE
151: ,BILL_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE_OVERRIDE%TYPE
152: ,RATE_BASED_FLAG PA_FP_RES_ASSIGNMENTS_TMP.RATE_BASED_FLAG%TYPE
153: ,SPREAD_AMOUNTS_FLAG PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_AMOUNTS_FLAG%TYPE
146: ,RAW_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.RAW_COST_RATE%TYPE
147: ,RAW_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.RW_COST_RATE_OVERRIDE%TYPE
148: ,BURDEN_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE%TYPE
149: ,BURDEN_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE_OVERRIDE%TYPE
150: ,BILL_RATE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE%TYPE
151: ,BILL_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE_OVERRIDE%TYPE
152: ,RATE_BASED_FLAG PA_FP_RES_ASSIGNMENTS_TMP.RATE_BASED_FLAG%TYPE
153: ,SPREAD_AMOUNTS_FLAG PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_AMOUNTS_FLAG%TYPE
154: ,INIT_QUANTITY NUMBER
147: ,RAW_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.RW_COST_RATE_OVERRIDE%TYPE
148: ,BURDEN_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE%TYPE
149: ,BURDEN_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE_OVERRIDE%TYPE
150: ,BILL_RATE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE%TYPE
151: ,BILL_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE_OVERRIDE%TYPE
152: ,RATE_BASED_FLAG PA_FP_RES_ASSIGNMENTS_TMP.RATE_BASED_FLAG%TYPE
153: ,SPREAD_AMOUNTS_FLAG PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_AMOUNTS_FLAG%TYPE
154: ,INIT_QUANTITY NUMBER
155: ,TXN_INIT_RAW_COST NUMBER
148: ,BURDEN_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE%TYPE
149: ,BURDEN_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE_OVERRIDE%TYPE
150: ,BILL_RATE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE%TYPE
151: ,BILL_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE_OVERRIDE%TYPE
152: ,RATE_BASED_FLAG PA_FP_RES_ASSIGNMENTS_TMP.RATE_BASED_FLAG%TYPE
153: ,SPREAD_AMOUNTS_FLAG PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_AMOUNTS_FLAG%TYPE
154: ,INIT_QUANTITY NUMBER
155: ,TXN_INIT_RAW_COST NUMBER
156: ,TXN_INIT_BURDENED_COST NUMBER
149: ,BURDEN_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE_OVERRIDE%TYPE
150: ,BILL_RATE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE%TYPE
151: ,BILL_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE_OVERRIDE%TYPE
152: ,RATE_BASED_FLAG PA_FP_RES_ASSIGNMENTS_TMP.RATE_BASED_FLAG%TYPE
153: ,SPREAD_AMOUNTS_FLAG PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_AMOUNTS_FLAG%TYPE
154: ,INIT_QUANTITY NUMBER
155: ,TXN_INIT_RAW_COST NUMBER
156: ,TXN_INIT_BURDENED_COST NUMBER
157: ,TXN_INIT_REVENUE NUMBER
236: --print_msg(l_stage);
237: SELECT sum(nvl(bl.quantity,0))
238: INTO v_bl_total_quantity
239: FROM pa_budget_lines bl
240: ,pa_fp_res_assignments_tmp rtmp
241: WHERE bl.budget_version_id = p_budget_version_id
242: AND bl.RESOURCE_ASSIGNMENT_ID = g_edist_RaId(i)
243: AND bl.TXN_CURRENCY_CODE = g_edist_Curcode(i)
244: AND bl.budget_version_id = rtmp.budget_version_id
3050: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
3051: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
3052: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
3053:
3054: l_txn_quantity_addl pa_fp_res_assignments_tmp.
3055: TXN_PLAN_QUANTITY%TYPE;
3056: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.
3057: TXN_RAW_COST%TYPE;
3058: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.
3052: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
3053:
3054: l_txn_quantity_addl pa_fp_res_assignments_tmp.
3055: TXN_PLAN_QUANTITY%TYPE;
3056: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.
3057: TXN_RAW_COST%TYPE;
3058: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.
3059: TXN_BURDENED_COST%TYPE;
3060: l_txn_revenue_addl pa_fp_res_assignments_tmp.
3054: l_txn_quantity_addl pa_fp_res_assignments_tmp.
3055: TXN_PLAN_QUANTITY%TYPE;
3056: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.
3057: TXN_RAW_COST%TYPE;
3058: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.
3059: TXN_BURDENED_COST%TYPE;
3060: l_txn_revenue_addl pa_fp_res_assignments_tmp.
3061: TXN_REVENUE%TYPE;
3062:
3056: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.
3057: TXN_RAW_COST%TYPE;
3058: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.
3059: TXN_BURDENED_COST%TYPE;
3060: l_txn_revenue_addl pa_fp_res_assignments_tmp.
3061: TXN_REVENUE%TYPE;
3062:
3063: l_bl_count INTEGER;
3064: l_dummy_count INTEGER;
3181: ,NVL(NEG_QUANTITY_CHANGE_FLAG,'N') neg_Qty_Change_flag
3182: ,NVL(NEG_RAWCOST_CHANGE_FLAG,'N') neg_RawCst_Change_flag
3183: ,NVL(NEG_BURDEN_CHANGE_FALG,'N') neg_BurdCst_Change_flag
3184: ,NVL(NEG_REVENUE_CHANGE_FLAG,'N') neg_rev_Change_flag
3185: FROM PA_FP_RES_ASSIGNMENTS_TMP tmp
3186: WHERE tmp.BUDGET_VERSION_ID = p_budget_version_id
3187: AND (NVL(tmp.TXN_PLAN_QUANTITY_ADDL,0) <> 0
3188: OR NVL(tmp.TXN_RAW_COST_ADDL,0) <> 0
3189: OR NVL(tmp.TXN_BURDENED_COST_ADDL,0) <> 0