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_JOB_DETAILS dependencies on WIP_JOB_DETAILS

Line 1: Package Body WIP_JOB_DETAILS as

1: Package Body WIP_JOB_DETAILS as
2: /* $Header: wipjdldb.pls 120.3 2011/09/19 14:01:20 sisankar ship $ */
3:
4:
5: Procedure Load_All_Details( p_group_id in number,

Line 40: and load_type = WIP_JOB_DETAILS.WIP_OPERATION

36: and parent_header_id = p_parent_header_id)
37: OR p_std_alone = 1)
38: and wip_entity_id = p_wip_entity_id
39: and organization_id = p_organization_id
40: and load_type = WIP_JOB_DETAILS.WIP_OPERATION
41: and process_phase = WIP_CONSTANTS.ML_VALIDATION
42: and process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING) ;
43:
44: Cursor Res_Cur (p_wip_entity_id number, p_organization_id number) IS

Line 55: and load_type = WIP_JOB_DETAILS.WIP_RESOURCE

51: and parent_header_id = p_parent_header_id)
52: OR p_std_alone = 1)
53: and wip_entity_id = p_wip_entity_id
54: and organization_id = p_organization_id
55: and load_type = WIP_JOB_DETAILS.WIP_RESOURCE
56: and process_phase = WIP_CONSTANTS.ML_VALIDATION
57: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
58:
59: Cursor ResInst_Cur (p_wip_entity_id number, p_organization_id number) IS

Line 70: and load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

66: and parent_header_id = p_parent_header_id)
67: OR p_std_alone = 1)
68: and wip_entity_id = p_wip_entity_id
69: and organization_id = p_organization_id
70: and load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
71: and process_phase = WIP_CONSTANTS.ML_VALIDATION
72: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
73:
74: Cursor Req_Cur (p_wip_entity_id number, p_organization_id number) IS

Line 85: and load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

81: and parent_header_id = p_parent_header_id)
82: OR p_std_alone = 1 )
83: and wip_entity_id = p_wip_entity_id
84: and organization_id = p_organization_id
85: and load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
86: and process_phase = WIP_CONSTANTS.ML_VALIDATION
87: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
88:
89: Cursor Res_Usage_Cur (p_wip_entity_id number, p_organization_id number) IS

Line 100: and load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,

96: and parent_header_id = p_parent_header_id)
97: OR p_std_alone = 1)
98: and wip_entity_id = p_wip_entity_id
99: and organization_id = p_organization_id
100: and load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
101: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
102: and process_phase = WIP_CONSTANTS.ML_VALIDATION
103: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
104:

Line 101: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)

97: OR p_std_alone = 1)
98: and wip_entity_id = p_wip_entity_id
99: and organization_id = p_organization_id
100: and load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
101: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
102: and process_phase = WIP_CONSTANTS.ML_VALIDATION
103: and process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
104:
105: Cursor SubRes_Cur (p_wip_entity_id number, p_organization_id number) IS

Line 116: and load_type = WIP_JOB_DETAILS.WIP_SUB_RES

112: and parent_header_id = p_parent_header_id)
113: OR p_std_alone = 1)
114: and wip_entity_id = p_wip_entity_id
115: and organization_id = p_organization_id
116: and load_type = WIP_JOB_DETAILS.WIP_SUB_RES
117: and process_phase = WIP_CONSTANTS.ML_VALIDATION
118: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
119:
120: Cursor Op_Link_Cur (p_wip_entity_id number, p_organization_id number) IS

Line 131: and load_type = WIP_JOB_DETAILS.WIP_OP_LINK

127: and parent_header_id = p_parent_header_id)
128: OR p_std_alone = 1)
129: and wip_entity_id = p_wip_entity_id
130: and organization_id = p_organization_id
131: and load_type = WIP_JOB_DETAILS.WIP_OP_LINK
132: and process_phase = WIP_CONSTANTS.ML_VALIDATION
133: and process_status IN (WIP_CONSTANTS.RUNNING ,WIP_CONSTANTS.WARNING);
134:
135: Cursor Serials_Cur (p_wip_entity_id number, p_organization_id number) IS

Line 146: and load_type = WIP_JOB_DETAILS.WIP_SERIAL

142: and parent_header_id = p_parent_header_id)
143: OR p_std_alone = 1)
144: and wip_entity_id = p_wip_entity_id
145: and organization_id = p_organization_id
146: and load_type = WIP_JOB_DETAILS.WIP_SERIAL
147: and process_phase = WIP_CONSTANTS.ML_VALIDATION
148: and process_status IN (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);
149:
150: x_count number;

Line 166: wip_logger.entryPoint(p_procName => 'WIP_JOB_DETAILS.Load_All_Details',

162: l_params(2).paramValue := p_parent_header_id;
163: l_params(3).paramName := 'p_std_alone';
164: l_params(3).paramValue := p_std_alone;
165:
166: wip_logger.entryPoint(p_procName => 'WIP_JOB_DETAILS.Load_All_Details',
167: p_params => l_params,
168: x_returnStatus => l_dummy2);
169:
170: begin

Line 291: IF l_cur.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN

287:
288: /* default operation records */
289:
290:
291: IF l_cur.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
292:
293: BEGIN
294:
295: WIP_OPERATION_VALIDATE.Add_Operation(p_group_id,

Line 303: wip_logger.log('Error in WIP_OPERATION_VALIDATE.Add_Operation,l_cur.wip_entity_id='||l_cur.wip_entity_id||' , substitution_type= '||WIP_JOB_DETAILS.WIP_ADD,l_dummy2);

299: x_err_code, x_err_msg,
300: x_return_status);
301: exception
302: when others then
303: wip_logger.log('Error in WIP_OPERATION_VALIDATE.Add_Operation,l_cur.wip_entity_id='||l_cur.wip_entity_id||' , substitution_type= '||WIP_JOB_DETAILS.WIP_ADD,l_dummy2);
304: wip_logger.log(SQLERRM,l_dummy2);
305: raise;
306: end;
307: /* validate operation records */

Line 309: ELSIF l_cur.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN

305: raise;
306: end;
307: /* validate operation records */
308:
309: ELSIF l_cur.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN
310:
311: BEGIN
312: WIP_OPERATION_VALIDATE.Change_Operation(p_group_id,
313: p_parent_header_id,

Line 321: wip_logger.log('Error in WIP_OPERATION_VALIDATE.Change_Operation,l_cur.wip_entity_id='||l_cur.wip_entity_id||' , substitution_type= '||WIP_JOB_DETAILS.WIP_CHANGE,l_dummy2);

317: x_return_status);
318:
319: EXCEPTION
320: when others then
321: wip_logger.log('Error in WIP_OPERATION_VALIDATE.Change_Operation,l_cur.wip_entity_id='||l_cur.wip_entity_id||' , substitution_type= '||WIP_JOB_DETAILS.WIP_CHANGE,l_dummy2);
322: wip_logger.log(SQLERRM,l_dummy2);
323: raise;
324: end;
325:

Line 575: WIP_JOB_DETAILS.WIP_DELETE,

571: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_RESOURCE_INSTANCE(
572: p_group_id,
573: cur_job.wip_entity_id,
574: cur_job.organization_id,
575: WIP_JOB_DETAILS.WIP_DELETE,
576: x_err_code,
577: x_err_msg);
578: EXCEPTION
579: when others then

Line 1191: End WIP_JOB_DETAILS;

1187: end;
1188:
1189: END default_wip_entity_id;
1190:
1191: End WIP_JOB_DETAILS;