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

Line 36: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE

32: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
33: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
34: AND wip_entity_id = p_wip_entity_id
35: AND organization_id = p_organization_id
36: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
37: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;
38:
39: l_ret_exp_status boolean := true; --Bug#4675116
40:

Line 37: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;

33: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
34: AND wip_entity_id = p_wip_entity_id
35: AND organization_id = p_organization_id
36: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
37: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;
38:
39: l_ret_exp_status boolean := true; --Bug#4675116
40:
41: BEGIN

Line 113: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE

109: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
110: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
111: AND wip_entity_id = p_wip_entity_id
112: AND organization_id = p_organization_id
113: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
114: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
115:
116: l_scheduling_method number;
117: l_scheduled_start_date date;/* Bug 3669728*/

Line 114: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

110: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
111: AND wip_entity_id = p_wip_entity_id
112: AND organization_id = p_organization_id
113: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
114: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
115:
116: l_scheduling_method number;
117: l_scheduled_start_date date;/* Bug 3669728*/
118: l_scheduled_completion_date date;/* Bug 3669728*/

Line 255: IF WIP_JOB_DETAILS.std_alone = 0 THEN

251: cur_row.maximum_assigned_units,
252: cur_row.parent_seq_num,
253: cur_row.batch_id);
254:
255: IF WIP_JOB_DETAILS.std_alone = 0 THEN
256:
257: SELECT scheduling_method INTO l_scheduling_method
258: FROM WIP_JOB_SCHEDULE_INTERFACE
259: WHERE group_id = p_group_id

Line 269: IF WIP_JOB_DETAILS.std_alone = 1 OR

265: -- We check that whether there're usage records for this resource
266: -- If it's stand alone or the scheduling_method is manaul (3)
267: -- we need default a resource usage.
268:
269: IF WIP_JOB_DETAILS.std_alone = 1 OR
270: ( WIP_JOB_DETAILS.std_alone = 0 AND l_scheduling_method = 3) THEN
271:
272: IF Num_Of_Usage(p_group_id, /* Fix for bug#3636378 */
273: p_wip_entity_id,

Line 270: ( WIP_JOB_DETAILS.std_alone = 0 AND l_scheduling_method = 3) THEN

266: -- If it's stand alone or the scheduling_method is manaul (3)
267: -- we need default a resource usage.
268:
269: IF WIP_JOB_DETAILS.std_alone = 1 OR
270: ( WIP_JOB_DETAILS.std_alone = 0 AND l_scheduling_method = 3) THEN
271:
272: IF Num_Of_Usage(p_group_id, /* Fix for bug#3636378 */
273: p_wip_entity_id,
274: p_organization_id,

Line 381: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE

377: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
378: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
379: AND wip_entity_id = p_wip_entity_id
380: AND organization_id = p_organization_id
381: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
382: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;
383:
384: cursor missing_res_csr
385: is

Line 382: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;

378: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
379: AND wip_entity_id = p_wip_entity_id
380: AND organization_id = p_organization_id
381: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
382: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;
383:
384: cursor missing_res_csr
385: is
386: select wo.first_unit_start_date,

Line 402: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE

398: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
399: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
400: AND wip_entity_id = p_wip_entity_id
401: AND organization_id = p_organization_id
402: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE
403: AND operation_seq_num = wor.operation_seq_num
404: AND resource_seq_num = wor.resource_seq_num
405: ) ;
406:

Line 558: IF WIP_JOB_DETAILS.std_alone = 0 THEN

554: cur_row.resource_seq_num,
555: p_err_code,
556: p_err_msg);
557:
558: IF WIP_JOB_DETAILS.std_alone = 0 THEN
559:
560: SELECT scheduling_method INTO l_scheduling_method
561: FROM WIP_JOB_SCHEDULE_INTERFACE
562: WHERE group_id = p_group_id

Line 572: IF WIP_JOB_DETAILS.std_alone = 1 OR

568: -- We check that whether there're usage records for this resource
569: -- If it's stand alone or the scheduling_method is manual (3)
570: -- we need default a resource usage.
571:
572: IF WIP_JOB_DETAILS.std_alone = 1 OR
573: ( WIP_JOB_DETAILS.std_alone = 0 AND l_scheduling_method = 3) THEN
574:
575: IF Num_Of_Usage(p_group_id, /* Fix for bug#3636378 */
576: p_wip_entity_id,

Line 573: ( WIP_JOB_DETAILS.std_alone = 0 AND l_scheduling_method = 3) THEN

569: -- If it's stand alone or the scheduling_method is manual (3)
570: -- we need default a resource usage.
571:
572: IF WIP_JOB_DETAILS.std_alone = 1 OR
573: ( WIP_JOB_DETAILS.std_alone = 0 AND l_scheduling_method = 3) THEN
574:
575: IF Num_Of_Usage(p_group_id, /* Fix for bug#3636378 */
576: p_wip_entity_id,
577: p_organization_id,

Line 729: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

725: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
726: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
727: AND wip_entity_id = p_wip_entity_id
728: AND organization_id = p_organization_id
729: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
730: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;
731:
732:
733: BEGIN

Line 730: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;

726: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
727: AND wip_entity_id = p_wip_entity_id
728: AND organization_id = p_organization_id
729: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
730: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;
731:
732:
733: BEGIN
734:

Line 795: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

791: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
792: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
793: AND wip_entity_id = p_wip_entity_id
794: AND organization_id = p_organization_id
795: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
796: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
797:
798: l_scheduling_method number;
799:

Line 796: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

792: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
793: AND wip_entity_id = p_wip_entity_id
794: AND organization_id = p_organization_id
795: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
796: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
797:
798: l_scheduling_method number;
799:
800: BEGIN

Line 945: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

941: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
942: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
943: AND wip_entity_id = p_wip_entity_id
944: AND organization_id = p_organization_id
945: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
946: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;
947:
948: l_scheduling_method number := 0;
949:

Line 946: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;

942: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
943: AND wip_entity_id = p_wip_entity_id
944: AND organization_id = p_organization_id
945: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES
946: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;
947:
948: l_scheduling_method number := 0;
949:
950: BEGIN

Line 1044: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

1040: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1041: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1042: AND wip_entity_id = p_wip_entity_id
1043: AND organization_id = p_organization_id
1044: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
1045: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
1046:
1047: BEGIN
1048:

Line 1045: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

1041: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1042: AND wip_entity_id = p_wip_entity_id
1043: AND organization_id = p_organization_id
1044: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
1045: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
1046:
1047: BEGIN
1048:
1049: begin

Line 1053: WIP_JOB_DETAILS.WIP_ADD, p_err_code, p_err_msg);

1049: begin
1050:
1051: /* delete all existing instances on a resource before add */
1052: Delete_Resource_Instance(p_group_id, p_wip_entity_id, p_organization_id,
1053: WIP_JOB_DETAILS.WIP_ADD, p_err_code, p_err_msg);
1054:
1055: FOR cur_row IN res_info(p_group_id,
1056: p_wip_entity_id,
1057: p_organization_id) LOOP

Line 1118: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

1114: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1115: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1116: AND wip_entity_id = p_wip_entity_id
1117: AND organization_id = p_organization_id
1118: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
1119: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;
1120:
1121: l_ret_exp_status boolean := true; --Bug#4675116
1122:

Line 1119: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;

1115: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1116: AND wip_entity_id = p_wip_entity_id
1117: AND organization_id = p_organization_id
1118: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
1119: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;
1120:
1121: l_ret_exp_status boolean := true; --Bug#4675116
1122:
1123: BEGIN

Line 1192: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

1188: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1189: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1190: AND wip_entity_id = p_wip_entity_id
1191: AND organization_id = p_organization_id
1192: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
1193: AND substitution_type = p_substitution_type;
1194:
1195: l_ret_exp_status boolean := true; --Bug#4675116
1196:

Line 1269: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1265: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1266: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1267: AND wip_entity_id = p_wip_entity_id
1268: AND organization_id = p_organization_id
1269: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1270: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;
1271:
1272: x_return_status VARCHAR(1);
1273: x_msg_data VARCHAR(2000);

Line 1270: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;

1266: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1267: AND wip_entity_id = p_wip_entity_id
1268: AND organization_id = p_organization_id
1269: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1270: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;
1271:
1272: x_return_status VARCHAR(1);
1273: x_msg_data VARCHAR(2000);
1274: l_dummy VARCHAR(1);

Line 1343: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1339: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1340: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1341: AND wip_entity_id = p_wip_entity_id
1342: AND organization_id = p_organization_id
1343: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1344: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
1345:
1346: l_material_issue_by_mo VARCHAR2(1);
1347: BEGIN

Line 1344: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

1340: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1341: AND wip_entity_id = p_wip_entity_id
1342: AND organization_id = p_organization_id
1343: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1344: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
1345:
1346: l_material_issue_by_mo VARCHAR2(1);
1347: BEGIN
1348:

Line 1489: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1485: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1486: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1487: AND wip_entity_id = p_wip_entity_id
1488: AND organization_id = p_organization_id
1489: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1490: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;
1491:
1492: l_material_issue_by_mo VARCHAR2(1);
1493: x_return_status VARCHAR2(1);

Line 1490: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;

1486: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1487: AND wip_entity_id = p_wip_entity_id
1488: AND organization_id = p_organization_id
1489: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1490: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;
1491:
1492: l_material_issue_by_mo VARCHAR2(1);
1493: x_return_status VARCHAR2(1);
1494: x_msg_data VARCHAR2(2000);

Line 1698: AND load_type = WIP_JOB_DETAILS.WIP_OPERATION

1694: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1695: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1696: AND wip_entity_id = p_wip_entity_id
1697: AND organization_id = p_organization_id
1698: AND load_type = WIP_JOB_DETAILS.WIP_OPERATION
1699: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
1700:
1701: CURSOR operations(p_wip_entity_id number,
1702: p_organization_id number) IS

Line 1699: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

1695: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1696: AND wip_entity_id = p_wip_entity_id
1697: AND organization_id = p_organization_id
1698: AND load_type = WIP_JOB_DETAILS.WIP_OPERATION
1699: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
1700:
1701: CURSOR operations(p_wip_entity_id number,
1702: p_organization_id number) IS
1703: SELECT operation_seq_num

Line 2118: AND WJDI.load_type = WIP_JOB_DETAILS.WIP_OPERATION

2114: AND WJDI.process_phase = WIP_CONSTANTS.ML_VALIDATION
2115: AND WJDI.process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2116: AND WJDI.wip_entity_id = p_wip_entity_id
2117: AND WJDI.organization_id = p_organization_id
2118: AND WJDI.load_type = WIP_JOB_DETAILS.WIP_OPERATION
2119: AND WJDI.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE
2120: AND WO.wip_entity_id = p_wip_entity_id
2121: AND WO.organization_id = p_organization_id
2122: AND WO.operation_seq_num = WJDI.operation_seq_num;

Line 2119: AND WJDI.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE

2115: AND WJDI.process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2116: AND WJDI.wip_entity_id = p_wip_entity_id
2117: AND WJDI.organization_id = p_organization_id
2118: AND WJDI.load_type = WIP_JOB_DETAILS.WIP_OPERATION
2119: AND WJDI.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE
2120: AND WO.wip_entity_id = p_wip_entity_id
2121: AND WO.organization_id = p_organization_id
2122: AND WO.operation_seq_num = WJDI.operation_seq_num;
2123:

Line 2300: and wjdi.load_type = wip_job_details.wip_operation

2296: where wjdi.group_id = p_group_id
2297: and wjdi.process_phase = wip_constants.ml_validation
2298: and wjdi.process_status in (wip_constants.running,
2299: wip_constants.warning)
2300: and wjdi.load_type = wip_job_details.wip_operation
2301: and wjdi.substitution_type in (wip_job_details.wip_add, wip_job_details.wip_change)
2302: and wjdi.wip_entity_id = p_wip_entity_id
2303: and wjdi.organization_id = p_organization_id
2304: and (wjdi.first_unit_start_date is not null or

Line 2301: and wjdi.substitution_type in (wip_job_details.wip_add, wip_job_details.wip_change)

2297: and wjdi.process_phase = wip_constants.ml_validation
2298: and wjdi.process_status in (wip_constants.running,
2299: wip_constants.warning)
2300: and wjdi.load_type = wip_job_details.wip_operation
2301: and wjdi.substitution_type in (wip_job_details.wip_add, wip_job_details.wip_change)
2302: and wjdi.wip_entity_id = p_wip_entity_id
2303: and wjdi.organization_id = p_organization_id
2304: and (wjdi.first_unit_start_date is not null or
2305: wjdi.last_unit_completion_date is not null)

Line 2340: if(wip_job_details.std_alone = 1) then

2336: for l_inv_row in c_invalid_rows loop
2337: l_error_exists := true;
2338: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_DATE');
2339: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
2340: if(wip_job_details.std_alone = 1) then
2341: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
2342: p_text => substr(fnd_message.get,1,500),
2343: p_error_type => wip_jdi_utils.msg_error);
2344: else

Line 2358: and wjdi.load_type = wip_job_details.wip_operation

2354: where wjdi.group_id = p_group_id
2355: and wjdi.process_phase = wip_constants.ml_validation
2356: and wjdi.process_status in (wip_constants.running,
2357: wip_constants.warning)
2358: and wjdi.load_type = wip_job_details.wip_operation
2359: and wjdi.substitution_type in (wip_job_details.wip_add, wip_job_details.wip_change)
2360: and wjdi.wip_entity_id = p_wip_entity_id
2361: and wjdi.organization_id = p_organization_id
2362: and (wjdi.first_unit_start_date is not null or

Line 2359: and wjdi.substitution_type in (wip_job_details.wip_add, wip_job_details.wip_change)

2355: and wjdi.process_phase = wip_constants.ml_validation
2356: and wjdi.process_status in (wip_constants.running,
2357: wip_constants.warning)
2358: and wjdi.load_type = wip_job_details.wip_operation
2359: and wjdi.substitution_type in (wip_job_details.wip_add, wip_job_details.wip_change)
2360: and wjdi.wip_entity_id = p_wip_entity_id
2361: and wjdi.organization_id = p_organization_id
2362: and (wjdi.first_unit_start_date is not null or
2363: wjdi.last_unit_completion_date is not null)

Line 2436: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,

2432: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2433: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
2434: AND wip_entity_id = p_wip_entity_id
2435: AND organization_id = p_organization_id
2436: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
2437: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
2438: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
2439:
2440: Begin

Line 2437: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)

2433: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
2434: AND wip_entity_id = p_wip_entity_id
2435: AND organization_id = p_organization_id
2436: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
2437: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
2438: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
2439:
2440: Begin
2441:

Line 2438: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

2434: AND wip_entity_id = p_wip_entity_id
2435: AND organization_id = p_organization_id
2436: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
2437: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
2438: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
2439:
2440: Begin
2441:
2442: FOR cur_row in Usage_info(p_group_id, p_wip_entity_id,p_organization_id)Loop

Line 2477: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,

2473: AND wip_entity_id = p_wip_entity_id
2474: AND organization_id = p_organization_id
2475: AND operation_seq_num = p_operation_seq_num
2476: AND resource_seq_num = p_resource_seq_num
2477: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
2478: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
2479: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
2480:
2481: x_statement varchar2(2000);

Line 2478: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)

2474: AND organization_id = p_organization_id
2475: AND operation_seq_num = p_operation_seq_num
2476: AND resource_seq_num = p_resource_seq_num
2477: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
2478: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
2479: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
2480:
2481: x_statement varchar2(2000);
2482: l_resource_id number;

Line 2516: IF cur_update.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN

2512: FOR cur_update IN Usage_Update(p_group_id , p_wip_entity_id,
2513: p_organization_id, p_operation_seq_num,
2514: p_resource_seq_num) LOOP
2515:
2516: IF cur_update.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
2517:
2518: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
2519: ( WIP_ENTITY_ID ,
2520: ORGANIZATION_ID,

Line 2594: and load_type = WIP_JOB_DETAILS.WIP_RES_USAGE;

2590: and wip_entity_id = p_wip_entity_id
2591: and organization_id = p_organization_id
2592: and operation_seq_num = p_operation_seq_num
2593: and resource_seq_num = p_resource_seq_num
2594: and load_type = WIP_JOB_DETAILS.WIP_RES_USAGE;
2595:
2596: return x_count;
2597:
2598:

Line 2683: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

2679: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2680: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2681: AND wip_entity_id = p_wip_entity_id
2682: AND organization_id = p_organization_id
2683: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
2684: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
2685:
2686: l_scheduling_method number;
2687:

Line 2684: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

2680: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2681: AND wip_entity_id = p_wip_entity_id
2682: AND organization_id = p_organization_id
2683: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
2684: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
2685:
2686: l_scheduling_method number;
2687:
2688: BEGIN

Line 2782: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

2778: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2779: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2780: AND wip_entity_id = p_wip_entity_id
2781: AND organization_id = p_organization_id
2782: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
2783: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;
2784:
2785: BEGIN
2786:

Line 2783: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;

2779: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2780: AND wip_entity_id = p_wip_entity_id
2781: AND organization_id = p_organization_id
2782: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
2783: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;
2784:
2785: BEGIN
2786:
2787: begin

Line 2830: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL

2826: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
2827: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2828: AND wjdi.wip_entity_id = p_wip_entity_id
2829: AND wjdi.organization_id = p_organization_id
2830: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
2831: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_ADD
2832: AND wjdi.parent_header_id = wjsi.header_id
2833: AND wjsi.wip_entity_id = we.wip_entity_id (+);
2834:

Line 2831: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_ADD

2827: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2828: AND wjdi.wip_entity_id = p_wip_entity_id
2829: AND wjdi.organization_id = p_organization_id
2830: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
2831: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_ADD
2832: AND wjdi.parent_header_id = wjsi.header_id
2833: AND wjsi.wip_entity_id = we.wip_entity_id (+);
2834:
2835: begin

Line 2891: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL

2887: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
2888: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2889: AND wjdi.wip_entity_id = p_wip_entity_id
2890: AND wjdi.organization_id = p_organization_id
2891: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
2892: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE
2893: and wjdi.parent_header_id = wjsi.header_id
2894: and wjsi.wip_entity_id = we.wip_entity_id (+);
2895:

Line 2892: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE

2888: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2889: AND wjdi.wip_entity_id = p_wip_entity_id
2890: AND wjdi.organization_id = p_organization_id
2891: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
2892: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE
2893: and wjdi.parent_header_id = wjsi.header_id
2894: and wjsi.wip_entity_id = we.wip_entity_id (+);
2895:
2896: BEGIN

Line 2964: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL

2960: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
2961: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2962: AND wjdi.wip_entity_id = p_wip_entity_id
2963: AND wjdi.organization_id = p_organization_id
2964: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
2965: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_DELETE
2966: AND wjdi.parent_header_id = wjsi.header_id
2967: AND wjsi.wip_entity_id = we.wip_entity_id (+);
2968:

Line 2965: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_DELETE

2961: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2962: AND wjdi.wip_entity_id = p_wip_entity_id
2963: AND wjdi.organization_id = p_organization_id
2964: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
2965: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_DELETE
2966: AND wjdi.parent_header_id = wjsi.header_id
2967: AND wjsi.wip_entity_id = we.wip_entity_id (+);
2968:
2969: BEGIN