APPS.PA_FP_SPREAD_AMTS_PKG dependencies on PA_FP_RES_ASSIGNMENTS_TMP

Line 122: RESOURCE_ASSIGNMENT_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_ASSIGNMENT_ID%TYPE

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

Line 123: ,BUDGET_VERSION_ID PA_FP_RES_ASSIGNMENTS_TMP.BUDGET_VERSION_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

Line 124: ,PROJECT_ID PA_FP_RES_ASSIGNMENTS_TMP.PROJECT_ID%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

Line 125: ,TASK_ID PA_FP_RES_ASSIGNMENTS_TMP.TASK_ID%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

Line 126: ,RESOURCE_LIST_MEMBER_ID PA_FP_RES_ASSIGNMENTS_TMP.RESOURCE_LIST_MEMBER_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

Line 127: ,PLANNING_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_START_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

Line 128: ,PLANNING_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.PLANNING_END_DATE%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

Line 129: ,SPREAD_CURVE_ID PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_CURVE_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
133: ,PROJECT_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%TYPE

Line 130: ,SP_FIXED_DATE PA_FP_RES_ASSIGNMENTS_TMP.SP_FIXED_DATE%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

Line 131: ,TXN_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

Line 132: ,TXN_CURRENCY_CODE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%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

Line 133: ,PROJECT_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%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

Line 134: ,PROJFUNC_CURRENCY_CODE PA_FP_RES_ASSIGNMENTS_TMP.TXN_CURRENCY_CODE%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

Line 135: ,TXN_REVENUE PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE%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

Line 136: ,TXN_REVENUE_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_REVENUE_ADDL%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

Line 137: ,TXN_RAW_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST%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

Line 138: ,TXN_RAW_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_RAW_COST_ADDL%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

Line 139: ,TXN_BURDENED_COST PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST%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

Line 140: ,TXN_BURDENED_COST_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_BURDENED_COST_ADDL%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

Line 141: ,TXN_PLAN_QUANTITY PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY%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

Line 142: ,TXN_PLAN_QUANTITY_ADDL PA_FP_RES_ASSIGNMENTS_TMP.TXN_PLAN_QUANTITY_ADDL%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

Line 143: ,LINE_START_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_START_DATE%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

Line 144: ,LINE_END_DATE PA_FP_RES_ASSIGNMENTS_TMP.LINE_END_DATE%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

Line 145: ,SOURCE_CONTEXT PA_FP_RES_ASSIGNMENTS_TMP.SOURCE_CONTEXT%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

Line 146: ,RAW_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.RAW_COST_RATE%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

Line 147: ,RAW_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.RW_COST_RATE_OVERRIDE%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

Line 148: ,BURDEN_COST_RATE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE%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

Line 149: ,BURDEN_COST_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BURDEN_COST_RATE_OVERRIDE%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

Line 150: ,BILL_RATE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE%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

Line 151: ,BILL_RATE_OVERRIDE PA_FP_RES_ASSIGNMENTS_TMP.BILL_RATE_OVERRIDE%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
155: ,TXN_INIT_RAW_COST NUMBER

Line 152: ,RATE_BASED_FLAG PA_FP_RES_ASSIGNMENTS_TMP.RATE_BASED_FLAG%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
156: ,TXN_INIT_BURDENED_COST NUMBER

Line 153: ,SPREAD_AMOUNTS_FLAG PA_FP_RES_ASSIGNMENTS_TMP.SPREAD_AMOUNTS_FLAG%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
157: ,TXN_INIT_REVENUE NUMBER

Line 240: ,pa_fp_res_assignments_tmp rtmp

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

Line 2324: l_txn_quantity_addl pa_fp_res_assignments_tmp.

2320: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
2321: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
2322: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
2323:
2324: l_txn_quantity_addl pa_fp_res_assignments_tmp.
2325: TXN_PLAN_QUANTITY%TYPE;
2326: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.
2327: TXN_RAW_COST%TYPE;
2328: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.

Line 2326: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.

2322: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
2323:
2324: l_txn_quantity_addl pa_fp_res_assignments_tmp.
2325: TXN_PLAN_QUANTITY%TYPE;
2326: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.
2327: TXN_RAW_COST%TYPE;
2328: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.
2329: TXN_BURDENED_COST%TYPE;
2330: l_txn_revenue_addl pa_fp_res_assignments_tmp.

Line 2328: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.

2324: l_txn_quantity_addl pa_fp_res_assignments_tmp.
2325: TXN_PLAN_QUANTITY%TYPE;
2326: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.
2327: TXN_RAW_COST%TYPE;
2328: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.
2329: TXN_BURDENED_COST%TYPE;
2330: l_txn_revenue_addl pa_fp_res_assignments_tmp.
2331: TXN_REVENUE%TYPE;
2332:

Line 2330: l_txn_revenue_addl pa_fp_res_assignments_tmp.

2326: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.
2327: TXN_RAW_COST%TYPE;
2328: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.
2329: TXN_BURDENED_COST%TYPE;
2330: l_txn_revenue_addl pa_fp_res_assignments_tmp.
2331: TXN_REVENUE%TYPE;
2332:
2333: l_bl_count INTEGER;
2334: l_dummy_count INTEGER;

Line 2455: FROM PA_FP_RES_ASSIGNMENTS_TMP tmp

2451: ,NVL(NEG_QUANTITY_CHANGE_FLAG,'N') neg_Qty_Change_flag
2452: ,NVL(NEG_RAWCOST_CHANGE_FLAG,'N') neg_RawCst_Change_flag
2453: ,NVL(NEG_BURDEN_CHANGE_FALG,'N') neg_BurdCst_Change_flag
2454: ,NVL(NEG_REVENUE_CHANGE_FLAG,'N') neg_rev_Change_flag
2455: FROM PA_FP_RES_ASSIGNMENTS_TMP tmp
2456: WHERE tmp.BUDGET_VERSION_ID = p_budget_version_id
2457: AND (NVL(tmp.TXN_PLAN_QUANTITY_ADDL,0) <> 0
2458: OR NVL(tmp.TXN_RAW_COST_ADDL,0) <> 0
2459: OR NVL(tmp.TXN_BURDENED_COST_ADDL,0) <> 0