[Home] [Help]
5202: l_txn_resource_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5203:
5204: /* Variables for Manually Added Plan Lines logic */
5205: l_etc_start_date DATE;
5206: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
5207: BEGIN
5208: X_MSG_COUNT := 0;
5209: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5210:
5519: -- Bug 4159172: Moved update of sp_fixed_date from CREATE_RES_ASG to here.
5520:
5521: SELECT spread_curve_id
5522: INTO l_spread_curve_id
5523: FROM pa_spread_curves_b
5524: WHERE spread_curve_code = 'FIXED_DATE';
5525:
5526: UPDATE PA_RESOURCE_ASSIGNMENTS
5527: SET SP_FIXED_DATE = PLANNING_START_DATE