[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,
1047: v_forecast_rec eam_forecasts%ROWTYPE;
1048:
1049:
1050: begin
1051: -- Standard Start of API savepoint
1052: SAVEPOINT Extract_Forecast_PVT;
1053: -- Standard call to check for call compatibility.
1054: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1055: p_api_version ,
1049:
1050: begin
1051: -- Standard Start of API savepoint
1052: SAVEPOINT Extract_Forecast_PVT;
1053: -- Standard call to check for call compatibility.
1054: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1055: p_api_version ,
1056: l_api_name ,
1057: G_PKG_NAME
1154: (select wip_entity_id from eam_forecast_cebba where forecast_id =
1155: p_forecast_id);
1156:
1157:
1158: -- Standard check of p_commit.
1159: IF FND_API.To_Boolean( p_commit ) THEN
1160: COMMIT WORK;
1161: END IF;
1162:
1159: IF FND_API.To_Boolean( p_commit ) THEN
1160: COMMIT WORK;
1161: END IF;
1162:
1163: -- Standard call to get message count and if count is 1, get message info.
1164:
1165: FND_MSG_PUB.Count_And_Get
1166: ( p_count => x_msg_count ,
1167: p_data => x_msg_data
2120: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,
2121: PROGRAM_ID, PROGRAM_UPDATE_DATE, RESOURCE_ID,
2122: UOM_CODE, BASIS_TYPE, USAGE_RATE_OR_AMOUNT,
2123: ACTIVITY_ID, SCHEDULED_FLAG, ASSIGNED_UNITS,
2124: AUTOCHARGE_TYPE, STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS,
2125: APPLIED_RESOURCE_VALUE, START_DATE, COMPLETION_DATE,
2126: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
2127: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,
2128: ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,
2147: LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID,
2148: PROGRAM_ID, PROGRAM_UPDATE_DATE, RESOURCE_ID,
2149: UOM_CODE, BASIS_TYPE, USAGE_RATE_OR_AMOUNT,
2150: ACTIVITY_ID, SCHEDULED_FLAG, ASSIGNED_UNITS,
2151: AUTOCHARGE_TYPE, STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS,
2152: APPLIED_RESOURCE_VALUE, START_DATE, COMPLETION_DATE,
2153: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
2154: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,
2155: ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,
2302: WIP_ENTITY_ID, OPERATION_SEQ_NUM, ORGANIZATION_ID,
2303: REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2304: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
2305: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
2306: PROGRAM_UPDATE_DATE, OPERATION_SEQUENCE_ID, STANDARD_OPERATION_ID,
2307: DEPARTMENT_ID, DESCRIPTION, SCHEDULED_QUANTITY,
2308: QUANTITY_IN_QUEUE, QUANTITY_RUNNING, QUANTITY_WAITING_TO_MOVE,
2309: QUANTITY_REJECTED, QUANTITY_SCRAPPED, QUANTITY_COMPLETED,
2310: FIRST_UNIT_START_DATE, FIRST_UNIT_COMPLETION_DATE, LAST_UNIT_START_DATE,
2330: SELECT WIP_ENTITY_ID, OPERATION_SEQ_NUM, ORGANIZATION_ID,
2331: REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2332: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
2333: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
2334: PROGRAM_UPDATE_DATE, OPERATION_SEQUENCE_ID, STANDARD_OPERATION_ID,
2335: DEPARTMENT_ID, DESCRIPTION, SCHEDULED_QUANTITY,
2336: QUANTITY_IN_QUEUE, QUANTITY_RUNNING, QUANTITY_WAITING_TO_MOVE,
2337: QUANTITY_REJECTED, QUANTITY_SCRAPPED, QUANTITY_COMPLETED,
2338: FIRST_UNIT_START_DATE, FIRST_UNIT_COMPLETION_DATE, LAST_UNIT_START_DATE,