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: order by operation_seq_num,substitute_group_num,replacement_group_num;
384: -- Modified for Bug 13045227.
385: cursor missing_res_csr

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: order by operation_seq_num,substitute_group_num,replacement_group_num;
384: -- Modified for Bug 13045227.
385: cursor missing_res_csr
386: is

Line 403: AND load_type = WIP_JOB_DETAILS.WIP_RESOURCE

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

Line 564: IF WIP_JOB_DETAILS.std_alone = 0 THEN

560: cur_row.resource_seq_num,
561: p_err_code,
562: p_err_msg);
563:
564: IF WIP_JOB_DETAILS.std_alone = 0 THEN
565:
566: SELECT scheduling_method INTO l_scheduling_method
567: FROM WIP_JOB_SCHEDULE_INTERFACE
568: WHERE group_id = p_group_id

Line 578: IF WIP_JOB_DETAILS.std_alone = 1 OR ( WIP_JOB_DETAILS.std_alone = 0 AND l_scheduling_method = 3) THEN

574: -- We check that whether there're usage records for this resource
575: -- If it's stand alone or the scheduling_method is manual (3)
576: -- we need default a resource usage.
577:
578: IF WIP_JOB_DETAILS.std_alone = 1 OR ( WIP_JOB_DETAILS.std_alone = 0 AND l_scheduling_method = 3) THEN
579: IF Num_Of_Usage(p_group_id, /* Fix for bug#3636378 */
580: p_wip_entity_id,
581: p_organization_id,
582: cur_row.operation_seq_num,

Line 728: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

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

Line 729: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;

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

Line 794: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

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

Line 795: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

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

Line 944: AND load_type = WIP_JOB_DETAILS.WIP_SUB_RES

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

Line 945: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;

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

Line 1045: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

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

Line 1046: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

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

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

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

Line 1119: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

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

Line 1120: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;

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

Line 1195: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

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

Line 1272: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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

Line 1273: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;

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

Line 1346: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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

Line 1347: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

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

Line 1492: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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

Line 1493: AND substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;

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

Line 1719: AND load_type = WIP_JOB_DETAILS.WIP_OPERATION

1715: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1716: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1717: AND wip_entity_id = p_wip_entity_id
1718: AND organization_id = p_organization_id
1719: AND load_type = WIP_JOB_DETAILS.WIP_OPERATION
1720: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
1721: ORDER BY operation_seq_num ; --Added for bug#14511983, this will ensure that serialization start operation is set to the first operation
1722:
1723: CURSOR operations(p_wip_entity_id number,

Line 1720: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD

1716: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1717: AND wip_entity_id = p_wip_entity_id
1718: AND organization_id = p_organization_id
1719: AND load_type = WIP_JOB_DETAILS.WIP_OPERATION
1720: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
1721: ORDER BY operation_seq_num ; --Added for bug#14511983, this will ensure that serialization start operation is set to the first operation
1722:
1723: CURSOR operations(p_wip_entity_id number,
1724: p_organization_id number) IS

Line 1842: and substitution_type = wip_job_details.wip_add;

1838: and process_status in (wip_constants.running,
1839: wip_constants.warning)
1840: and wip_entity_id = p_wip_entity_id
1841: and organization_id = p_organization_id
1842: and substitution_type = wip_job_details.wip_add;
1843:
1844: x_err_code := SQLCODE;
1845: x_err_msg := fnd_message.get;
1846: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1884: and substitution_type = wip_job_details.wip_add;

1880: and process_status in (wip_constants.running,
1881: wip_constants.warning)
1882: and wip_entity_id = p_wip_entity_id
1883: and organization_id = p_organization_id
1884: and substitution_type = wip_job_details.wip_add;
1885:
1886: x_err_code := SQLCODE;
1887: x_err_msg := fnd_message.get;
1888: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2241: AND WJDI.load_type = WIP_JOB_DETAILS.WIP_OPERATION

2237: AND WJDI.process_phase = WIP_CONSTANTS.ML_VALIDATION
2238: AND WJDI.process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2239: AND WJDI.wip_entity_id = p_wip_entity_id
2240: AND WJDI.organization_id = p_organization_id
2241: AND WJDI.load_type = WIP_JOB_DETAILS.WIP_OPERATION
2242: AND WJDI.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE
2243: AND WO.wip_entity_id = p_wip_entity_id
2244: AND WO.organization_id = p_organization_id
2245: AND WO.operation_seq_num = WJDI.operation_seq_num;

Line 2242: AND WJDI.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE

2238: AND WJDI.process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2239: AND WJDI.wip_entity_id = p_wip_entity_id
2240: AND WJDI.organization_id = p_organization_id
2241: AND WJDI.load_type = WIP_JOB_DETAILS.WIP_OPERATION
2242: AND WJDI.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE
2243: AND WO.wip_entity_id = p_wip_entity_id
2244: AND WO.organization_id = p_organization_id
2245: AND WO.operation_seq_num = WJDI.operation_seq_num;
2246:

Line 2425: and wjdi.load_type = wip_job_details.wip_operation

2421: where wjdi.group_id = p_group_id
2422: and wjdi.process_phase = wip_constants.ml_validation
2423: and wjdi.process_status in (wip_constants.running,
2424: wip_constants.warning)
2425: and wjdi.load_type = wip_job_details.wip_operation
2426: and wjdi.substitution_type in (wip_job_details.wip_add, wip_job_details.wip_change)
2427: and wjdi.wip_entity_id = p_wip_entity_id
2428: and wjdi.organization_id = p_organization_id
2429: and (wjdi.first_unit_start_date is not null or

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

2422: and wjdi.process_phase = wip_constants.ml_validation
2423: and wjdi.process_status in (wip_constants.running,
2424: wip_constants.warning)
2425: and wjdi.load_type = wip_job_details.wip_operation
2426: and wjdi.substitution_type in (wip_job_details.wip_add, wip_job_details.wip_change)
2427: and wjdi.wip_entity_id = p_wip_entity_id
2428: and wjdi.organization_id = p_organization_id
2429: and (wjdi.first_unit_start_date is not null or
2430: wjdi.last_unit_completion_date is not null)

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

2462: l_error_exists := true;
2463: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_DATE');
2464: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
2465: --Bug#14487360: Replacing substr with substrb to ensure that non-English error message is not errored out
2466: if(wip_job_details.std_alone = 1) then
2467: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
2468: p_text => substrb(fnd_message.get,1,500),
2469: p_error_type => wip_jdi_utils.msg_error);
2470: else

Line 2484: and wjdi.load_type = wip_job_details.wip_operation

2480: where wjdi.group_id = p_group_id
2481: and wjdi.process_phase = wip_constants.ml_validation
2482: and wjdi.process_status in (wip_constants.running,
2483: wip_constants.warning)
2484: and wjdi.load_type = wip_job_details.wip_operation
2485: and wjdi.substitution_type in (wip_job_details.wip_add, wip_job_details.wip_change)
2486: and wjdi.wip_entity_id = p_wip_entity_id
2487: and wjdi.organization_id = p_organization_id
2488: and (wjdi.first_unit_start_date is not null or

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

2481: and wjdi.process_phase = wip_constants.ml_validation
2482: and wjdi.process_status in (wip_constants.running,
2483: wip_constants.warning)
2484: and wjdi.load_type = wip_job_details.wip_operation
2485: and wjdi.substitution_type in (wip_job_details.wip_add, wip_job_details.wip_change)
2486: and wjdi.wip_entity_id = p_wip_entity_id
2487: and wjdi.organization_id = p_organization_id
2488: and (wjdi.first_unit_start_date is not null or
2489: wjdi.last_unit_completion_date is not null)

Line 2562: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,

2558: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2559: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
2560: AND wip_entity_id = p_wip_entity_id
2561: AND organization_id = p_organization_id
2562: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
2563: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
2564: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
2565:
2566: Begin

Line 2563: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)

2559: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
2560: AND wip_entity_id = p_wip_entity_id
2561: AND organization_id = p_organization_id
2562: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
2563: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
2564: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
2565:
2566: Begin
2567:

Line 2564: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

2560: AND wip_entity_id = p_wip_entity_id
2561: AND organization_id = p_organization_id
2562: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
2563: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
2564: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
2565:
2566: Begin
2567:
2568: FOR cur_row in Usage_info(p_group_id, p_wip_entity_id,p_organization_id)Loop

Line 2603: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,

2599: AND wip_entity_id = p_wip_entity_id
2600: AND organization_id = p_organization_id
2601: AND operation_seq_num = p_operation_seq_num
2602: AND resource_seq_num = p_resource_seq_num
2603: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
2604: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
2605: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
2606:
2607: x_statement varchar2(2000);

Line 2604: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)

2600: AND organization_id = p_organization_id
2601: AND operation_seq_num = p_operation_seq_num
2602: AND resource_seq_num = p_resource_seq_num
2603: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
2604: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
2605: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);
2606:
2607: x_statement varchar2(2000);
2608: l_resource_id number;

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

2638: FOR cur_update IN Usage_Update(p_group_id , p_wip_entity_id,
2639: p_organization_id, p_operation_seq_num,
2640: p_resource_seq_num) LOOP
2641:
2642: IF cur_update.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
2643:
2644: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
2645: ( WIP_ENTITY_ID ,
2646: ORGANIZATION_ID,

Line 2720: and load_type = WIP_JOB_DETAILS.WIP_RES_USAGE;

2716: and wip_entity_id = p_wip_entity_id
2717: and organization_id = p_organization_id
2718: and operation_seq_num = p_operation_seq_num
2719: and resource_seq_num = p_resource_seq_num
2720: and load_type = WIP_JOB_DETAILS.WIP_RES_USAGE;
2721:
2722: return x_count;
2723:
2724:

Line 2809: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

2805: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2806: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2807: AND wip_entity_id = p_wip_entity_id
2808: AND organization_id = p_organization_id
2809: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
2810: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
2811:
2812: l_scheduling_method number;
2813:

Line 2810: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

2806: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2807: AND wip_entity_id = p_wip_entity_id
2808: AND organization_id = p_organization_id
2809: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
2810: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
2811:
2812: l_scheduling_method number;
2813:
2814: BEGIN

Line 2908: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

2904: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2905: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2906: AND wip_entity_id = p_wip_entity_id
2907: AND organization_id = p_organization_id
2908: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
2909: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;
2910:
2911: BEGIN
2912:

Line 2909: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;

2905: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2906: AND wip_entity_id = p_wip_entity_id
2907: AND organization_id = p_organization_id
2908: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
2909: AND substitution_type = WIP_JOB_DETAILS.WIP_DELETE;
2910:
2911: BEGIN
2912:
2913: begin

Line 2956: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL

2952: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
2953: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2954: AND wjdi.wip_entity_id = p_wip_entity_id
2955: AND wjdi.organization_id = p_organization_id
2956: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
2957: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_ADD
2958: AND wjdi.parent_header_id = wjsi.header_id
2959: AND wjsi.wip_entity_id = we.wip_entity_id (+);
2960:

Line 2957: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_ADD

2953: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2954: AND wjdi.wip_entity_id = p_wip_entity_id
2955: AND wjdi.organization_id = p_organization_id
2956: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
2957: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_ADD
2958: AND wjdi.parent_header_id = wjsi.header_id
2959: AND wjsi.wip_entity_id = we.wip_entity_id (+);
2960:
2961: begin

Line 3017: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL

3013: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
3014: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
3015: AND wjdi.wip_entity_id = p_wip_entity_id
3016: AND wjdi.organization_id = p_organization_id
3017: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
3018: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE
3019: and wjdi.parent_header_id = wjsi.header_id
3020: and wjsi.wip_entity_id = we.wip_entity_id (+);
3021:

Line 3018: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE

3014: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
3015: AND wjdi.wip_entity_id = p_wip_entity_id
3016: AND wjdi.organization_id = p_organization_id
3017: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
3018: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE
3019: and wjdi.parent_header_id = wjsi.header_id
3020: and wjsi.wip_entity_id = we.wip_entity_id (+);
3021:
3022: BEGIN

Line 3090: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL

3086: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
3087: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
3088: AND wjdi.wip_entity_id = p_wip_entity_id
3089: AND wjdi.organization_id = p_organization_id
3090: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
3091: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_DELETE
3092: AND wjdi.parent_header_id = wjsi.header_id
3093: AND wjsi.wip_entity_id = we.wip_entity_id (+);
3094:

Line 3091: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_DELETE

3087: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
3088: AND wjdi.wip_entity_id = p_wip_entity_id
3089: AND wjdi.organization_id = p_organization_id
3090: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_SERIAL
3091: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_DELETE
3092: AND wjdi.parent_header_id = wjsi.header_id
3093: AND wjsi.wip_entity_id = we.wip_entity_id (+);
3094:
3095: BEGIN