[Home] [Help]
172:
173: SAVEPOINT HistoricalCosts_PVT;
174:
175: -------------------------------------------------------------------------
176: -- standard call to check for call compatibility
177: -------------------------------------------------------------------------
178: IF NOT fnd_api.compatible_api_call (
179: l_api_version,
180: p_api_version,
287:
288: l_stmt_num := 50;
289:
290: ---------------------------------------------------------------------------
291: -- Standard Call to get message count and if count = 1, get message info
292: ---------------------------------------------------------------------------
293:
294: FND_MSG_PUB.Count_And_Get (
295: p_count => x_msg_count,
1068: v_forecast_rec eam_forecasts%ROWTYPE;
1069:
1070:
1071: begin
1072: -- Standard Start of API savepoint
1073: SAVEPOINT Extract_Forecast_PVT;
1074: -- Standard call to check for call compatibility.
1075: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1076: p_api_version ,
1070:
1071: begin
1072: -- Standard Start of API savepoint
1073: SAVEPOINT Extract_Forecast_PVT;
1074: -- Standard call to check for call compatibility.
1075: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1076: p_api_version ,
1077: l_api_name ,
1078: G_PKG_NAME
1175: (select wip_entity_id from eam_forecast_cebba where forecast_id =
1176: p_forecast_id);
1177:
1178:
1179: -- Standard check of p_commit.
1180: IF FND_API.To_Boolean( p_commit ) THEN
1181: COMMIT WORK;
1182: END IF;
1183:
1180: IF FND_API.To_Boolean( p_commit ) THEN
1181: COMMIT WORK;
1182: END IF;
1183:
1184: -- Standard call to get message count and if count is 1, get message info.
1185:
1186: FND_MSG_PUB.Count_And_Get
1187: ( p_count => x_msg_count ,
1188: p_data => x_msg_data
2112: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,
2113: PROGRAM_ID, PROGRAM_UPDATE_DATE, RESOURCE_ID,
2114: UOM_CODE, BASIS_TYPE, USAGE_RATE_OR_AMOUNT,
2115: ACTIVITY_ID, SCHEDULED_FLAG, ASSIGNED_UNITS,
2116: AUTOCHARGE_TYPE, STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS,
2117: APPLIED_RESOURCE_VALUE, START_DATE, COMPLETION_DATE,
2118: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
2119: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,
2120: ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,
2139: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,
2140: PROGRAM_ID, PROGRAM_UPDATE_DATE, RESOURCE_ID,
2141: UOM_CODE, BASIS_TYPE, USAGE_RATE_OR_AMOUNT,
2142: ACTIVITY_ID, SCHEDULED_FLAG, ASSIGNED_UNITS,
2143: AUTOCHARGE_TYPE, STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS,
2144: APPLIED_RESOURCE_VALUE, START_DATE, COMPLETION_DATE,
2145: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
2146: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,
2147: ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,
2461: WIP_ENTITY_ID, OPERATION_SEQ_NUM, ORGANIZATION_ID,
2462: REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2463: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
2464: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
2465: PROGRAM_UPDATE_DATE, OPERATION_SEQUENCE_ID, STANDARD_OPERATION_ID,
2466: DEPARTMENT_ID, DESCRIPTION, SCHEDULED_QUANTITY,
2467: QUANTITY_IN_QUEUE, QUANTITY_RUNNING, QUANTITY_WAITING_TO_MOVE,
2468: QUANTITY_REJECTED, QUANTITY_SCRAPPED, QUANTITY_COMPLETED,
2469: FIRST_UNIT_START_DATE, FIRST_UNIT_COMPLETION_DATE, LAST_UNIT_START_DATE,
2489: SELECT WIP_ENTITY_ID, OPERATION_SEQ_NUM, ORGANIZATION_ID,
2490: REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2491: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
2492: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
2493: PROGRAM_UPDATE_DATE, OPERATION_SEQUENCE_ID, STANDARD_OPERATION_ID,
2494: DEPARTMENT_ID, DESCRIPTION, SCHEDULED_QUANTITY,
2495: QUANTITY_IN_QUEUE, QUANTITY_RUNNING, QUANTITY_WAITING_TO_MOVE,
2496: QUANTITY_REJECTED, QUANTITY_SCRAPPED, QUANTITY_COMPLETED,
2497: FIRST_UNIT_START_DATE, FIRST_UNIT_COMPLETION_DATE, LAST_UNIT_START_DATE,