APPS.AHL_WIP_JOB_PVT dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 14: FROM wip_job_schedule_interface

10:
11: -- Define Global Cursors --
12: CURSOR job_header_exists(c_group_id NUMBER, c_parent_header_id NUMBER) IS
13: SELECT 'X'
14: FROM wip_job_schedule_interface
15: WHERE group_id = c_group_id
16: AND header_id = c_parent_header_id;
17:
18: CURSOR get_interface_ids(c_group_id NUMBER, c_header_id NUMBER) IS

Line 46: l_wip_job_rec wip_job_schedule_interface%ROWTYPE;

42: x_group_id OUT NOCOPY NUMBER,
43: x_header_id OUT NOCOPY NUMBER,
44: x_return_status OUT NOCOPY VARCHAR2
45: ) IS
46: l_wip_job_rec wip_job_schedule_interface%ROWTYPE;
47: l_group_id NUMBER;
48: l_header_id NUMBER;
49:
50: BEGIN

Line 70: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;

66: RETURN;
67: END IF;
68:
69: IF p_group_id IS NULL THEN
70: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;
71: l_header_id := l_group_id;
72: ELSE
73: l_group_id := p_group_id;
74: l_header_id := p_header_id + 1;

Line 160: INSERT INTO wip_job_schedule_interface

156: l_wip_job_rec.scheduling_method := 3; --default to 'Manual'
157:
158: --insert into table WJSI
159: BEGIN
160: INSERT INTO wip_job_schedule_interface
161: ( last_update_date,
162: last_updated_by,
163: creation_date,
164: created_by,

Line 743: FROM wip_job_schedule_interface

739: l_dev_status VARCHAR2(80);
740: l_message VARCHAR2(255);
741: CURSOR job_header_exists(c_group_id NUMBER) IS
742: SELECT 'X'
743: FROM wip_job_schedule_interface
744: WHERE group_id = c_group_id;
745:
746: BEGIN
747: -- Validate p_group_id

Line 893: FROM wip_job_schedule_interface

889:
890: CURSOR get_header_interface(c_job_name VARCHAR2, c_organization_id NUMBER,
891: c_group_id NUMBER) IS
892: SELECT interface_id, header_id
893: FROM wip_job_schedule_interface
894: WHERE job_name = c_job_name
895: AND organization_id = c_organization_id
896: AND group_id = c_group_id;
897:

Line 900: FROM wip_job_schedule_interface

896: AND group_id = c_group_id;
897:
898: CURSOR get_cp_sts(c_group_id NUMBER, c_header_id NUMBER) IS
899: SELECT process_phase, process_status
900: FROM wip_job_schedule_interface
901: WHERE group_id = c_group_id
902: AND header_id = c_header_id;
903: l_get_cp_sts get_cp_sts%ROWTYPE;
904:

Line 1084: DELETE FROM wip_job_schedule_interface

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
1085: WHERE group_id = l_group_id
1086: AND header_id = l_header_id;
1087: END IF;
1088:

Line 1567: FROM wip_job_schedule_interface

1563: WHERE wip_entity_id = c_wip_entity_id;
1564: l_job_name get_job_name%ROWTYPE;
1565: CURSOR get_pending_job(c_wip_entity_name VARCHAR2, c_organization_id NUMBER) IS
1566: SELECT 'X'
1567: FROM wip_job_schedule_interface
1568: WHERE job_name = c_wip_entity_name
1569: AND organization_id = c_organization_id
1570: AND (process_status not in (3, 4, 5)); --The successfully loaded records
1571: --or failed records still remain in job header interface table if in debug mode.

Line 1636: FROM wip_job_schedule_interface

1632:
1633: CURSOR get_job_attr(c_group_id NUMBER, c_header_id NUMBER) IS
1634: SELECT group_id, header_id, interface_id, process_phase, process_status,
1635: wip_entity_id, job_name, organization_id
1636: FROM wip_job_schedule_interface
1637: WHERE group_id = c_group_id
1638: AND header_id = c_header_id;
1639: l_get_job_attr get_job_attr%ROWTYPE;
1640:

Line 1842: DELETE FROM wip_job_schedule_interface

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
1843: WHERE group_id = l_get_job_attr.group_id
1844: AND header_id = l_get_job_attr.header_id;
1845: END IF;
1846: