DBA Data[Home] [Help]

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.2.12000000.2 2007/05/03 22:40:34 vjambhek 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 1246: table WIP_JOB_SCHEDULE_INTERFACE otherwise leave it null.

1242: While defaulting the value for completion locator,completion sub inventory mus
1243: t be checked.Completion locator would be defaulted from
1244: table BOM_OPERATIONAL_ROUTINGS only if the completion sub inventory in
1245: BOM_OPERATIONAL_ROUTINGS is same as completion sub inventory given in
1246: table WIP_JOB_SCHEDULE_INTERFACE otherwise leave it null.
1247: */
1248: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;
1249: end if;
1250: else