2041: ,nvl(QUANTITY_SOURCE,decode(QUANTITY,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2042: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2043: /* Code Addition for bug 3394907 starts */
2044: ,sysdate
2045: ,FND_GLOBAL.USER_ID
2046: ,FND_GLOBAL.LOGIN_ID
2047: /* Code Addition for bug 3394907 ends */
2048:
2049: FROM pa_fp_rollup_tmp tmp
2042: ,nvl(REVENUE_SOURCE,decode(PROJFUNC_REVENUE,null,null,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M))
2043: /* Code Addition for bug 3394907 starts */
2044: ,sysdate
2045: ,FND_GLOBAL.USER_ID
2046: ,FND_GLOBAL.LOGIN_ID
2047: /* Code Addition for bug 3394907 ends */
2048:
2049: FROM pa_fp_rollup_tmp tmp
2050: WHERE bl.budget_line_id = tmp.budget_line_id
2168: ,pa_budget_lines_s.nextval
2169: ,l_budget_version_id
2170: ,START_DATE
2171: ,SYSDATE
2172: ,FND_GLOBAL.USER_ID
2173: ,SYSDATE
2174: ,FND_GLOBAL.USER_ID
2175: ,FND_GLOBAL.LOGIN_ID
2176: ,END_DATE
2170: ,START_DATE
2171: ,SYSDATE
2172: ,FND_GLOBAL.USER_ID
2173: ,SYSDATE
2174: ,FND_GLOBAL.USER_ID
2175: ,FND_GLOBAL.LOGIN_ID
2176: ,END_DATE
2177: ,PERIOD_NAME
2178: ,QUANTITY
2171: ,SYSDATE
2172: ,FND_GLOBAL.USER_ID
2173: ,SYSDATE
2174: ,FND_GLOBAL.USER_ID
2175: ,FND_GLOBAL.LOGIN_ID
2176: ,END_DATE
2177: ,PERIOD_NAME
2178: ,QUANTITY
2179: ,PROJFUNC_RAW_COST
4125:
4126: UPDATE pa_budget_versions
4127: SET record_version_number = nvl(record_version_number,0) + 1
4128: ,last_update_date = SYSDATE
4129: ,last_updated_by = FND_GLOBAL.user_id
4130: ,last_update_login = FND_GLOBAL.login_id
4131: WHERE budget_version_id = p_budget_version_id;
4132:
4133: -- Bug Fix: 4569365. Removed MRC code.
4126: UPDATE pa_budget_versions
4127: SET record_version_number = nvl(record_version_number,0) + 1
4128: ,last_update_date = SYSDATE
4129: ,last_updated_by = FND_GLOBAL.user_id
4130: ,last_update_login = FND_GLOBAL.login_id
4131: WHERE budget_version_id = p_budget_version_id;
4132:
4133: -- Bug Fix: 4569365. Removed MRC code.
4134: /* Check if MRC is enabled and Call MRC API */