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.2 2005/12/16 13:39:31 yulin noship $ */
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 270: IF l_cur.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN

266: x_return_status );
267:
268: /* default operation records */
269:
270: IF l_cur.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
271:
272: WIP_OPERATION_VALIDATE.Add_Operation(p_group_id,
273: p_parent_header_id,
274: l_cur.wip_entity_id,

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

276: x_err_code, x_err_msg,
277: x_return_status);
278: /* validate operation records */
279:
280: ELSIF l_cur.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN
281:
282: WIP_OPERATION_VALIDATE.Change_Operation(p_group_id,
283: p_parent_header_id,
284: l_cur.wip_entity_id,

Line 436: WIP_JOB_DETAILS.WIP_DELETE,

432: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_RESOURCE_INSTANCE(
433: p_group_id,
434: cur_job.wip_entity_id,
435: cur_job.organization_id,
436: WIP_JOB_DETAILS.WIP_DELETE,
437: x_err_code,
438: x_err_msg);
439:
440: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_RESOURCE_INSTANCE(

Line 895: End WIP_JOB_DETAILS;

891: end;
892:
893: END default_wip_entity_id;
894:
895: End WIP_JOB_DETAILS;