152: -- This API is Autonomous Transaction. And we have to commit or rollback explicitly
153: -- when it exits, so p_commit flag is not necessary here.
154: PROCEDURE load_wip_job (
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
153: -- when it exits, so p_commit flag is not necessary here.
154: PROCEDURE load_wip_job (
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
154: PROCEDURE load_wip_job (
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_ahl_wo_rec IN ahl_wo_rec_type,
191:
192: -- Define Procedure insert_resource_txn --
193: PROCEDURE insert_resource_txn (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
192: -- Define Procedure insert_resource_txn --
193: PROCEDURE insert_resource_txn (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
193: PROCEDURE insert_resource_txn (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_ahl_res_txn_tbl IN ahl_res_txn_tbl_type
243: -- This API is Autonomous Transaction. And we have to commit or rollback explicitly
244: -- when it exits, so p_commit flag is not necessary here.
245: PROCEDURE load_wip_batch_jobs (
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
248: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
249: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
244: -- when it exits, so p_commit flag is not necessary here.
245: PROCEDURE load_wip_batch_jobs (
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
248: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
249: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
245: PROCEDURE load_wip_batch_jobs (
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
248: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
249: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_group_id IN NUMBER,