APPS.AHL_WIP_JOB_PVT dependencies on WIP_JOB_DTLS_INTERFACE

Line 20: FROM wip_job_dtls_interface

16: AND header_id = c_parent_header_id;
17:
18: CURSOR get_interface_ids(c_group_id NUMBER, c_header_id NUMBER) IS
19: SELECT interface_id
20: FROM wip_job_dtls_interface
21: WHERE group_id = c_group_id
22: AND parent_header_id = c_header_id
23: AND interface_id IS NOT NULL;
24:

Line 265: l_wip_job_op_rec wip_job_dtls_interface%ROWTYPE;

261: p_group_id IN NUMBER,
262: p_parent_header_id IN NUMBER,
263: x_return_status OUT NOCOPY VARCHAR2
264: ) IS
265: l_wip_job_op_rec wip_job_dtls_interface%ROWTYPE;
266: l_dummy VARCHAR2(1);
267:
268: BEGIN
269: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 293: -- a NOT NULL column in table wip_job_dtls_interface

289: CLOSE job_header_exists;
290: END IF;
291:
292: -- Validate p_ahl_wo_op_rec.operation_seq_num, because operation_seq_num is
293: -- a NOT NULL column in table wip_job_dtls_interface
294: IF p_ahl_wo_op_rec.operation_seq_num IS NULL THEN
295: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NULL');
296: FND_MSG_PUB.ADD;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 347: INSERT INTO wip_job_dtls_interface

343: l_wip_job_op_rec.backflush_flag := p_ahl_wo_op_rec.backflush_flag;
344: END IF;
345: --Insert into table WJDI
346: BEGIN
347: INSERT INTO wip_job_dtls_interface
348: ( last_update_date,
349: last_updated_by,
350: creation_date,
351: created_by,

Line 421: l_wip_job_res_rec wip_job_dtls_interface%ROWTYPE;

417: p_group_id IN NUMBER,
418: p_parent_header_id IN NUMBER,
419: x_return_status OUT NOCOPY VARCHAR2
420: ) IS
421: l_wip_job_res_rec wip_job_dtls_interface%ROWTYPE;
422: l_dummy VARCHAR2(1);
423:
424: BEGIN
425: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 496: INSERT INTO wip_job_dtls_interface

492: l_wip_job_res_rec.setup_id := p_ahl_wo_res_rec.setup_id;
493:
494: --insert into table WJDI
495: BEGIN
496: INSERT INTO wip_job_dtls_interface
497: ( last_update_date,
498: last_updated_by,
499: creation_date,
500: created_by,

Line 590: l_wip_job_mtl_rec wip_job_dtls_interface%ROWTYPE;

586: p_group_id IN NUMBER,
587: p_parent_header_id IN NUMBER,
588: x_return_status OUT NOCOPY VARCHAR2
589: ) IS
590: l_wip_job_mtl_rec wip_job_dtls_interface%ROWTYPE;
591: l_dummy VARCHAR2(1);
592:
593: BEGIN
594: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 655: INSERT INTO wip_job_dtls_interface

651: l_wip_job_mtl_rec.date_required := p_ahl_wo_mtl_rec.date_required;
652:
653: --Insert into table WJDI
654: BEGIN
655: INSERT INTO wip_job_dtls_interface
656: ( last_update_date,
657: last_updated_by,
658: creation_date,
659: created_by,

Line 1080: DELETE FROM wip_job_dtls_interface

1076: DELETE FROM wip_interface_errors
1077: WHERE interface_id = l_interface_ids(i);
1078: END LOOP;
1079:
1080: DELETE FROM wip_job_dtls_interface
1081: WHERE group_id = l_group_id
1082: AND parent_header_id = l_header_id;
1083:
1084: DELETE FROM wip_job_schedule_interface

Line 1838: DELETE FROM wip_job_dtls_interface

1834: DELETE FROM wip_interface_errors
1835: WHERE interface_id = l_interface_ids(j);
1836: END LOOP;
1837:
1838: DELETE FROM wip_job_dtls_interface
1839: WHERE group_id = l_get_job_attr.group_id
1840: AND parent_header_id = l_get_job_attr.header_id;
1841:
1842: DELETE FROM wip_job_schedule_interface