eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_COMMON dependencies on WIP_CONSTANTS

Line 44: if(x_entity_type = WIP_CONSTANTS.EAM) then

40: X_ERR_CLASS_1 := NULL;
41: X_ERR_MESG_2 := NULL;
42: X_ERR_CLASS_2 := NULL;
43:
44: if(x_entity_type = WIP_CONSTANTS.EAM) then
45: begin
46: select default_eam_class
47: into V_EAM_CLASS
48: from wip_eam_parameters

Line 62: if( V_COST_METHOD = WIP_CONSTANTS.COST_STD ) then

58: into V_COST_METHOD
59: from mtl_parameters
60: where
61: organization_id = X_ORG_ID;
62: if( V_COST_METHOD = WIP_CONSTANTS.COST_STD ) then
63: -- Standard Costing Organization
64: begin
65: select wdcac.std_discrete_class, wdcac.repetitive_assy_class
66: into V_DISC_CLASS, V_REP_CLASS

Line 121: elsif( V_COST_METHOD in ( WIP_CONSTANTS.COST_AVG,

117: exception
118: when NO_DATA_FOUND then
119: NULL;
120: end;
121: elsif( V_COST_METHOD in ( WIP_CONSTANTS.COST_AVG,
122: WIP_CONSTANTS.COST_FIFO,
123: WIP_CONSTANTS.COST_LIFO ) ) then
124: -- Average Costing Organization
125: if X_PROJECT_ID IS NOT NULL then

Line 122: WIP_CONSTANTS.COST_FIFO,

118: when NO_DATA_FOUND then
119: NULL;
120: end;
121: elsif( V_COST_METHOD in ( WIP_CONSTANTS.COST_AVG,
122: WIP_CONSTANTS.COST_FIFO,
123: WIP_CONSTANTS.COST_LIFO ) ) then
124: -- Average Costing Organization
125: if X_PROJECT_ID IS NOT NULL then
126: select NVL(costing_group_id,1), wip_acct_class_code

Line 123: WIP_CONSTANTS.COST_LIFO ) ) then

119: NULL;
120: end;
121: elsif( V_COST_METHOD in ( WIP_CONSTANTS.COST_AVG,
122: WIP_CONSTANTS.COST_FIFO,
123: WIP_CONSTANTS.COST_LIFO ) ) then
124: -- Average Costing Organization
125: if X_PROJECT_ID IS NOT NULL then
126: select NVL(costing_group_id,1), wip_acct_class_code
127: into V_COST_GROUP_ID, V_PRJ_DEF_CLASS

Line 232: wac.class_type = DECODE(X_ENTITY_TYPE, 1, WIP_CONSTANTS.DISC_CLASS,

228: select nvl(wac.disable_date, SYSDATE + 1) into V_DISABLE_DATE
229: from wip_accounting_classes wac
230: where
231: wac.organization_id = X_ORG_ID and
232: wac.class_type = DECODE(X_ENTITY_TYPE, 1, WIP_CONSTANTS.DISC_CLASS,
233: 2, WIP_CONSTANTS.REP_CLASS,
234: 4, WIP_CONSTANTS.DISC_CLASS,
235: 6, WIP_CONSTANTS.DISC_CLASS) and
236: wac.class_code = X_CLASS;

Line 233: 2, WIP_CONSTANTS.REP_CLASS,

229: from wip_accounting_classes wac
230: where
231: wac.organization_id = X_ORG_ID and
232: wac.class_type = DECODE(X_ENTITY_TYPE, 1, WIP_CONSTANTS.DISC_CLASS,
233: 2, WIP_CONSTANTS.REP_CLASS,
234: 4, WIP_CONSTANTS.DISC_CLASS,
235: 6, WIP_CONSTANTS.DISC_CLASS) and
236: wac.class_code = X_CLASS;
237: if V_DISABLE_DATE <= SYSDATE then

Line 234: 4, WIP_CONSTANTS.DISC_CLASS,

230: where
231: wac.organization_id = X_ORG_ID and
232: wac.class_type = DECODE(X_ENTITY_TYPE, 1, WIP_CONSTANTS.DISC_CLASS,
233: 2, WIP_CONSTANTS.REP_CLASS,
234: 4, WIP_CONSTANTS.DISC_CLASS,
235: 6, WIP_CONSTANTS.DISC_CLASS) and
236: wac.class_code = X_CLASS;
237: if V_DISABLE_DATE <= SYSDATE then
238: return(0);

Line 235: 6, WIP_CONSTANTS.DISC_CLASS) and

231: wac.organization_id = X_ORG_ID and
232: wac.class_type = DECODE(X_ENTITY_TYPE, 1, WIP_CONSTANTS.DISC_CLASS,
233: 2, WIP_CONSTANTS.REP_CLASS,
234: 4, WIP_CONSTANTS.DISC_CLASS,
235: 6, WIP_CONSTANTS.DISC_CLASS) and
236: wac.class_code = X_CLASS;
237: if V_DISABLE_DATE <= SYSDATE then
238: return(0);
239: else

Line 260: if v_primary_cost_method in ( WIP_CONSTANTS.COST_AVG,

256: from mtl_parameters mp
257: where
258: mp.organization_id = X_ORG_ID;
259:
260: if v_primary_cost_method in ( WIP_CONSTANTS.COST_AVG,
261: WIP_CONSTANTS.COST_FIFO,
262: WIP_CONSTANTS.COST_LIFO ) and
263: v_project_reference_enabled = 1 then
264: begin

Line 261: WIP_CONSTANTS.COST_FIFO,

257: where
258: mp.organization_id = X_ORG_ID;
259:
260: if v_primary_cost_method in ( WIP_CONSTANTS.COST_AVG,
261: WIP_CONSTANTS.COST_FIFO,
262: WIP_CONSTANTS.COST_LIFO ) and
263: v_project_reference_enabled = 1 then
264: begin
265: select distinct class_code

Line 262: WIP_CONSTANTS.COST_LIFO ) and

258: mp.organization_id = X_ORG_ID;
259:
260: if v_primary_cost_method in ( WIP_CONSTANTS.COST_AVG,
261: WIP_CONSTANTS.COST_FIFO,
262: WIP_CONSTANTS.COST_LIFO ) and
263: v_project_reference_enabled = 1 then
264: begin
265: select distinct class_code
266: into dummy

Line 444: -1, wip_constants.discrete,

440: wop.organization_id = p_organization_id
441: AND wop.wip_entity_id = p_wip_entity_id
442: AND
443: Decode(Decode(Nvl(p_repetitive_schedule_id,-1),
444: -1, wip_constants.discrete,
445: wip_constants.repetitive),
446: wip_constants.discrete,0,
447: wip_constants.repetitive,wop.repetitive_schedule_id)
448: = Decode(Decode(Nvl(p_repetitive_schedule_id,-1),

Line 445: wip_constants.repetitive),

441: AND wop.wip_entity_id = p_wip_entity_id
442: AND
443: Decode(Decode(Nvl(p_repetitive_schedule_id,-1),
444: -1, wip_constants.discrete,
445: wip_constants.repetitive),
446: wip_constants.discrete,0,
447: wip_constants.repetitive,wop.repetitive_schedule_id)
448: = Decode(Decode(Nvl(p_repetitive_schedule_id,-1),
449: -1, wip_constants.discrete,

Line 446: wip_constants.discrete,0,

442: AND
443: Decode(Decode(Nvl(p_repetitive_schedule_id,-1),
444: -1, wip_constants.discrete,
445: wip_constants.repetitive),
446: wip_constants.discrete,0,
447: wip_constants.repetitive,wop.repetitive_schedule_id)
448: = Decode(Decode(Nvl(p_repetitive_schedule_id,-1),
449: -1, wip_constants.discrete,
450: wip_constants.repetitive),

Line 447: wip_constants.repetitive,wop.repetitive_schedule_id)

443: Decode(Decode(Nvl(p_repetitive_schedule_id,-1),
444: -1, wip_constants.discrete,
445: wip_constants.repetitive),
446: wip_constants.discrete,0,
447: wip_constants.repetitive,wop.repetitive_schedule_id)
448: = Decode(Decode(Nvl(p_repetitive_schedule_id,-1),
449: -1, wip_constants.discrete,
450: wip_constants.repetitive),
451: wip_constants.discrete,0,

Line 449: -1, wip_constants.discrete,

445: wip_constants.repetitive),
446: wip_constants.discrete,0,
447: wip_constants.repetitive,wop.repetitive_schedule_id)
448: = Decode(Decode(Nvl(p_repetitive_schedule_id,-1),
449: -1, wip_constants.discrete,
450: wip_constants.repetitive),
451: wip_constants.discrete,0,
452: wip_constants.repetitive,p_repetitive_schedule_id);
453:

Line 450: wip_constants.repetitive),

446: wip_constants.discrete,0,
447: wip_constants.repetitive,wop.repetitive_schedule_id)
448: = Decode(Decode(Nvl(p_repetitive_schedule_id,-1),
449: -1, wip_constants.discrete,
450: wip_constants.repetitive),
451: wip_constants.discrete,0,
452: wip_constants.repetitive,p_repetitive_schedule_id);
453:
454: IF(p_repetitive_schedule_id IS NULL) THEN /* Discrete Job */

Line 451: wip_constants.discrete,0,

447: wip_constants.repetitive,wop.repetitive_schedule_id)
448: = Decode(Decode(Nvl(p_repetitive_schedule_id,-1),
449: -1, wip_constants.discrete,
450: wip_constants.repetitive),
451: wip_constants.discrete,0,
452: wip_constants.repetitive,p_repetitive_schedule_id);
453:
454: IF(p_repetitive_schedule_id IS NULL) THEN /* Discrete Job */
455:

Line 452: wip_constants.repetitive,p_repetitive_schedule_id);

448: = Decode(Decode(Nvl(p_repetitive_schedule_id,-1),
449: -1, wip_constants.discrete,
450: wip_constants.repetitive),
451: wip_constants.discrete,0,
452: wip_constants.repetitive,p_repetitive_schedule_id);
453:
454: IF(p_repetitive_schedule_id IS NULL) THEN /* Discrete Job */
455:
456: SELECT NVL(p_total_quantity,0) + Nvl(wdj.quantity_completed,0)