APPS.WIP_JSI_VALIDATOR dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 101: wjsi_row wip_job_schedule_interface%ROWTYPE;

97: fixed_lead_time NUMBER,
98: variable_lead_time NUMBER);
99:
100:
101: wjsi_row wip_job_schedule_interface%ROWTYPE;
102: wdj_row wdj_rec_t;
103: primary_item_row item_rec_t;
104: routing_ref_row item_rec_t;
105: g_dummy NUMBER;

Line 124: from wip_job_schedule_interface

120: x_application_id := fnd_global.prog_appl_id ;
121:
122: select *
123: into wjsi_row
124: from wip_job_schedule_interface
125: where rowid = wip_jsi_utils.current_rowid;
126:
127: -- Save Original org context
128: orig_org_context := nvl(fnd_profile.value('ORG_ID'), -1) ;

Line 253: update wip_job_schedule_interface

249: shutdown_type;
250: activity_type;
251: --
252: end if;
253: update wip_job_schedule_interface
254: set created_by = wjsi_row.created_by,
255: last_updated_by = wjsi_row.last_updated_by,
256: organization_id = wjsi_row.organization_id,
257: wip_entity_id = wjsi_row.wip_entity_id,

Line 364: from wip_job_schedule_interface wjsi

360: l_opFound boolean := false;
361: begin
362: select wip_entity_id, serialization_start_op, load_type, primary_item_id
363: into l_wipID, l_serialOp, l_loadType, l_primaryItemID
364: from wip_job_schedule_interface wjsi
365: where wjsi.rowid = wip_jsi_utils.current_rowid;
366:
367:
368: if(l_serialOp is null) then

Line 919: in wip_job_schedule_interface is null */

915: WIP_CONSTANTS.COMP_CHRG,
916: WIP_CONSTANTS.COMP_NOCHRG)) THEN
917:
918: /* Bug#2893368 - Added if condition to check whether primary item id
919: in wip_job_schedule_interface is null */
920: if ( wjsi_row.primary_item_id is null ) then
921: select primary_item_id /* for Bug2792736 */
922: into l_Primary_Item_Id
923: from wip_discrete_jobs

Line 2015: from wip_job_schedule_interface

2011: select end_item_unit_number into wjsi_row.end_item_unit_number
2012: from wip_discrete_jobs
2013: where wip_entity_id =
2014: (select wip_entity_id
2015: from wip_job_schedule_interface
2016: where rowid = WIP_JSI_UTILS.CURRENT_ROWID
2017: );
2018: exception
2019: when others then

Line 2049: from wip_job_schedule_interface

2045: select end_item_unit_number into wjsi_row.end_item_unit_number
2046: from wip_discrete_jobs
2047: where wip_entity_id =
2048: (select wip_entity_id
2049: from wip_job_schedule_interface
2050: where rowid = WIP_JSI_UTILS.CURRENT_ROWID
2051: );
2052: exception
2053: when others then

Line 2736: update wip_job_schedule_interface

2732: Elsif (wjsi_row.status_type = WIP_CONSTANTS.RELEASED) then
2733: if (nvl(wjsi_row.date_released,sysdate) > sysdate) then
2734: WIP_JSI_Utils.record_error('WIP_INVALID_RELEASE_DATE',TRUE) ;
2735:
2736: update wip_job_schedule_interface
2737: set date_released = sysdate
2738: where rowid = WIP_JSI_Utils.current_rowid ;
2739: end if;
2740: