APPS.WSMPJITH dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 144: SELECT wip_job_schedule_interface_s.NEXTVAL

140: p_wjsi_group_id := 0;
141:
142: l_stmt_num := 20;
143:
144: SELECT wip_job_schedule_interface_s.NEXTVAL
145: INTO p_wjsi_group_id
146: FROM dual;
147:
148: l_stmt_num := 30;

Line 190: INSERT INTO wip_job_schedule_interface (

186: end if;
187:
188: --end bugfix 2050277
189:
190: INSERT INTO wip_job_schedule_interface (
191: last_update_date,
192: last_updated_by,
193: creation_date,
194: created_by,

Line 424: DELETE FROM wip_job_schedule_interface wjsi

420: x_err_code:=0;
421: x_err_msg := NULL;
422:
423:
424: DELETE FROM wip_job_schedule_interface wjsi
425: WHERE wjsi.group_id = p_wjsi_group_id ;
426:
427: DELETE FROM wip_interface_errors wie
428: WHERE interface_id in

Line 430: FROM wip_job_schedule_interface wjsi

426:
427: DELETE FROM wip_interface_errors wie
428: WHERE interface_id in
429: (SELECT interface_id
430: FROM wip_job_schedule_interface wjsi
431: WHERE wjsi.group_id = p_wjsi_group_id);
432:
433: EXCEPTION
434: