152: WHERE Organization_ID = p_organization_id
153: AND Acct_Period_ID = (SELECT
154: MAX(Acct_Period_ID)
155: FROM
156: CST_MGD_INFL_ADJ_PER_STATUSES
157: WHERE Organization_ID = p_organization_id
158: AND Status = 'FINAL')
159: AND Open_Flag = 'N'
160: AND Period_Close_Date IS NOT NULL;
2547:
2548: x_return_status := FND_API.G_RET_STS_SUCCESS;
2549:
2550: INSERT INTO
2551: CST_MGD_INFL_ADJ_PER_STATUSES(
2552: Organization_ID
2553: , Acct_Period_ID
2554: , Last_Update_Date
2555: , Last_Updated_By
2619: BEGIN
2620:
2621: x_return_status := FND_API.G_RET_STS_SUCCESS;
2622:
2623: UPDATE CST_MGD_INFL_ADJ_PER_STATUSES
2624: SET Status = 'FINAL'
2625: , Last_Update_Date = SYSDATE
2626: , Last_Updated_By = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
2627: , Creation_Date = SYSDATE