APPS.WIP_JSI_DEFAULTER dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 5: wjsi_row wip_job_schedule_interface%ROWTYPE;

1: package body wip_jsi_defaulter as
2: /* $Header: wipjsidb.pls 120.5 2011/03/25 02:05:34 hliew ship $ */
3:
4: /* private variables */
5: wjsi_row wip_job_schedule_interface%ROWTYPE;
6:
7: /* forward declarations */
8:
9: /* This package defaults all the column values in the wip mass load process. */

Line 85: procedure default_values(p_wjsi_row in out nocopy wip_job_schedule_interface%ROWTYPE) IS

81: procedure activity_source;
82: procedure pm_schedule_id;
83:
84: /* public procedures */
85: procedure default_values(p_wjsi_row in out nocopy wip_job_schedule_interface%ROWTYPE) IS
86: BEGIN
87: wjsi_row := p_wjsi_row;
88: created_by_name;
89: last_updated_by_name;

Line 187: from wip_parameters wp, wip_job_schedule_interface wjsi

183: l_startOp,
184: l_wipID,
185: l_primaryItem,
186: l_orgID
187: from wip_parameters wp, wip_job_schedule_interface wjsi
188: where wjsi.rowid = wip_jsi_utils.current_rowid
189: and wjsi.organization_id = wp.organization_id;
190:
191: if(l_startOp is not null OR

Line 1258: table WIP_JOB_SCHEDULE_INTERFACE otherwise leave it null.

1254: While defaulting the value for completion locator,completion sub inventory mus
1255: t be checked.Completion locator would be defaulted from
1256: table BOM_OPERATIONAL_ROUTINGS only if the completion sub inventory in
1257: BOM_OPERATIONAL_ROUTINGS is same as completion sub inventory given in
1258: table WIP_JOB_SCHEDULE_INTERFACE otherwise leave it null.
1259: */
1260: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;
1261: /*Fix for Bug#9765343 (FP of 9668143) Derive Completion Locator based on routing_reference_id
1262: for a Non-Standard Job*/