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 248: update wip_job_schedule_interface

244: shutdown_type;
245: activity_type;
246: --
247: end if;
248: update wip_job_schedule_interface
249: set created_by = wjsi_row.created_by,
250: last_updated_by = wjsi_row.last_updated_by,
251: organization_id = wjsi_row.organization_id,
252: wip_entity_id = wjsi_row.wip_entity_id,

Line 359: from wip_job_schedule_interface wjsi

355: l_opFound boolean := false;
356: begin
357: select wip_entity_id, serialization_start_op, load_type, primary_item_id
358: into l_wipID, l_serialOp, l_loadType, l_primaryItemID
359: from wip_job_schedule_interface wjsi
360: where wjsi.rowid = wip_jsi_utils.current_rowid;
361:
362:
363: if(l_serialOp is null) then

Line 914: in wip_job_schedule_interface is null */

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

Line 2010: from wip_job_schedule_interface

2006: select end_item_unit_number into wjsi_row.end_item_unit_number
2007: from wip_discrete_jobs
2008: where wip_entity_id =
2009: (select wip_entity_id
2010: from wip_job_schedule_interface
2011: where rowid = WIP_JSI_UTILS.CURRENT_ROWID
2012: );
2013: exception
2014: when others then

Line 2044: from wip_job_schedule_interface

2040: select end_item_unit_number into wjsi_row.end_item_unit_number
2041: from wip_discrete_jobs
2042: where wip_entity_id =
2043: (select wip_entity_id
2044: from wip_job_schedule_interface
2045: where rowid = WIP_JSI_UTILS.CURRENT_ROWID
2046: );
2047: exception
2048: when others then

Line 2731: update wip_job_schedule_interface

2727: Elsif (wjsi_row.status_type = WIP_CONSTANTS.RELEASED) then
2728: if (nvl(wjsi_row.date_released,sysdate) > sysdate) then
2729: WIP_JSI_Utils.record_error('WIP_INVALID_RELEASE_DATE',TRUE) ;
2730:
2731: update wip_job_schedule_interface
2732: set date_released = sysdate
2733: where rowid = WIP_JSI_Utils.current_rowid ;
2734: end if;
2735: