APPS.WIP_JSI_DEFAULTER dependencies on WIP_SCHEDULE_GROUPS

Line 345: from wip_schedule_groups_val_v

341: if(wjsi_row.schedule_group_id is null) then
342: if(wjsi_row.schedule_group_name is not null) then
343: select schedule_group_id
344: into wjsi_row.schedule_group_id
345: from wip_schedule_groups_val_v
346: where schedule_group_name = wjsi_row.schedule_group_name
347: and organization_id = wjsi_row.organization_id;
348: end if;
349: else

Line 372: from wip_schedule_groups wsg,

368: wjsi_row.delivery_id is not null) then
369: begin
370: select schedule_group_id
371: into wjsi_row.schedule_group_id
372: from wip_schedule_groups wsg,
373: wsh_new_deliveries wds
374: where wds.delivery_id = wjsi_row.delivery_id
375: and wsg.schedule_group_name = wds.name
376: and wsg.organization_id = wjsi_row.organization_id;

Line 380: select wip_schedule_groups_s.nextval

376: and wsg.organization_id = wjsi_row.organization_id;
377: exception
378: when no_data_found then
379: --having problems using dml returning...
380: select wip_schedule_groups_s.nextval
381: into wjsi_row.schedule_group_id
382: from dual;
383:
384: insert into wip_schedule_groups (

Line 384: insert into wip_schedule_groups (

380: select wip_schedule_groups_s.nextval
381: into wjsi_row.schedule_group_id
382: from dual;
383:
384: insert into wip_schedule_groups (
385: schedule_group_id,
386: schedule_group_name,
387: organization_id,
388: description,