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_CONSTANTS

Line 32: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

28: attribute8,attribute9,attribute10,attribute11,attribute12,
29: attribute13,attribute14,attribute15
30: FROM WIP_JOB_DTLS_INTERFACE
31: WHERE group_id = p_group_id
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

Line 33: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

29: attribute13,attribute14,attribute15
30: FROM WIP_JOB_DTLS_INTERFACE
31: WHERE group_id = p_group_id
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;

Line 109: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

105: group_sequence_id, group_sequence_number, maximum_assigned_units,
106: parent_seq_num, batch_id
107: FROM WIP_JOB_DTLS_INTERFACE
108: WHERE group_id = p_group_id
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

Line 110: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

106: parent_seq_num, batch_id
107: FROM WIP_JOB_DTLS_INTERFACE
108: WHERE group_id = p_group_id
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;

Line 377: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

373: group_sequence_id, group_sequence_number, maximum_assigned_units,
374: parent_seq_num, batch_id
375: FROM WIP_JOB_DTLS_INTERFACE
376: WHERE group_id = p_group_id
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

Line 378: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)

374: parent_seq_num, batch_id
375: FROM WIP_JOB_DTLS_INTERFACE
376: WHERE group_id = p_group_id
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;

Line 398: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

394: and wor.organization_id = p_organization_id
395: and not exists ( select 1
396: FROM WIP_JOB_DTLS_INTERFACE
397: WHERE group_id = p_group_id
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

Line 399: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)

395: and not exists ( select 1
396: FROM WIP_JOB_DTLS_INTERFACE
397: WHERE group_id = p_group_id
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

Line 663: if (l_source_code = 'MSC' and l_scheduling_method = WIP_CONSTANTS.ML_MANUAL) then

659:
660: /* Fix for Bug#6394857 (FP of 6370245). Removed scheduling method condition in following if and also
661: open cursor when source_code is MSC.
662:
663: if (l_source_code = 'MSC' and l_scheduling_method = WIP_CONSTANTS.ML_MANUAL) then
664: */
665:
666: if (l_source_code = 'MSC') then
667:

Line 686: if (l_logLevel <= wip_constants.trace_logging) then

682: when others then
683: p_err_msg := 'WIPJDSTB, Change_Resource: ' || SQLERRM;
684: p_err_code := SQLCODE;
685: l_logLevel := fnd_log.g_current_runtime_level;
686: if (l_logLevel <= wip_constants.trace_logging) then
687: wip_logger.log(p_err_msg, l_dummy2);
688: end if;
689:
690: /* 4656331. Close cursor if still open */

Line 725: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

721: attribute8,attribute9,attribute10,attribute11,attribute12,
722: attribute13,attribute14,attribute15
723: FROM WIP_JOB_DTLS_INTERFACE
724: WHERE group_id = p_group_id
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

Line 726: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

722: attribute13,attribute14,attribute15
723: FROM WIP_JOB_DTLS_INTERFACE
724: WHERE group_id = p_group_id
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;

Line 791: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

787: attribute13,attribute14,attribute15,schedule_seq_num,
788: substitute_group_num,replacement_group_num
789: FROM WIP_JOB_DTLS_INTERFACE
790: WHERE group_id = p_group_id
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

Line 792: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)

788: substitute_group_num,replacement_group_num
789: FROM WIP_JOB_DTLS_INTERFACE
790: WHERE group_id = p_group_id
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;

Line 941: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

937: attribute13,attribute14,attribute15, schedule_seq_num,
938: substitute_group_num, replacement_group_num
939: FROM WIP_JOB_DTLS_INTERFACE
940: WHERE group_id = p_group_id
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

Line 942: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)

938: substitute_group_num, replacement_group_num
939: FROM WIP_JOB_DTLS_INTERFACE
940: WHERE group_id = p_group_id
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;

Line 1040: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1036: resource_instance_id, start_date, completion_date, batch_id, interface_id,
1037: created_by, creation_date,last_updated_by,last_update_date
1038: FROM WIP_JOB_DTLS_INTERFACE
1039: WHERE group_id = p_group_id
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

Line 1041: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

1037: created_by, creation_date,last_updated_by,last_update_date
1038: FROM WIP_JOB_DTLS_INTERFACE
1039: WHERE group_id = p_group_id
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;

Line 1114: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1110: resource_instance_id, start_date, completion_date, batch_id,
1111: created_by, creation_date,last_updated_by,last_update_date
1112: FROM WIP_JOB_DTLS_INTERFACE
1113: WHERE group_id = p_group_id
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

Line 1115: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

1111: created_by, creation_date,last_updated_by,last_update_date
1112: FROM WIP_JOB_DTLS_INTERFACE
1113: WHERE group_id = p_group_id
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;

Line 1188: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1184: SELECT distinct operation_seq_num, resource_seq_num, resource_serial_number,
1185: resource_instance_id, start_date, completion_date, batch_id
1186: FROM WIP_JOB_DTLS_INTERFACE
1187: WHERE group_id = p_group_id
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

Line 1189: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

1185: resource_instance_id, start_date, completion_date, batch_id
1186: FROM WIP_JOB_DTLS_INTERFACE
1187: WHERE group_id = p_group_id
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;

Line 1265: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1261: attribute8,attribute9,attribute10,attribute11,attribute12,
1262: attribute13,attribute14,attribute15
1263: FROM WIP_JOB_DTLS_INTERFACE
1264: WHERE group_id = p_group_id
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

Line 1266: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)

1262: attribute13,attribute14,attribute15
1263: FROM WIP_JOB_DTLS_INTERFACE
1264: WHERE group_id = p_group_id
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;

Line 1292: p_wip_entity_type => wip_constants.discrete,

1288:
1289: wip_picking_pvt.cancel_comp_allocations(p_wip_entity_id => p_wip_entity_id,
1290: p_operation_seq_num => cur_row.operation_seq_num,
1291: p_inventory_item_id => cur_row.inventory_item_id_old,
1292: p_wip_entity_type => wip_constants.discrete,
1293: x_return_status => x_return_status,
1294: x_msg_data => x_msg_data);
1295:
1296: if (x_return_status <> fnd_api.g_ret_sts_success) then

Line 1339: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1335: attribute8,attribute9,attribute10,attribute11,attribute12,
1336: attribute13,attribute14,attribute15
1337: FROM WIP_JOB_DTLS_INTERFACE
1338: WHERE group_id = p_group_id
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

Line 1340: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

1336: attribute13,attribute14,attribute15
1337: FROM WIP_JOB_DTLS_INTERFACE
1338: WHERE group_id = p_group_id
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;

Line 1485: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1481: attribute8,attribute9,attribute10,attribute11,attribute12,
1482: attribute13,attribute14,attribute15
1483: FROM WIP_JOB_DTLS_INTERFACE
1484: WHERE group_id = p_group_id
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

Line 1486: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

1482: attribute13,attribute14,attribute15
1483: FROM WIP_JOB_DTLS_INTERFACE
1484: WHERE group_id = p_group_id
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;

Line 1552: p_wip_entity_type => WIP_CONSTANTS.DISCRETE,

1548:
1549: WIP_PICKING_PUB.cancel_comp_allocations(p_wip_entity_id => p_wip_entity_id,
1550: p_operation_seq_num => cur_row.operation_seq_num,
1551: p_inventory_item_id => cur_row.inventory_item_id_old,
1552: p_wip_entity_type => WIP_CONSTANTS.DISCRETE,
1553: x_return_status => x_return_status,
1554: x_msg_data => x_msg_data);
1555:
1556: FND_MESSAGE.set_name('WIP', 'WIP_SUPPLY_CHANGE_WARNING2');

Line 1694: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

1690: attribute6, attribute7, attribute8, attribute9, attribute10,
1691: attribute11, attribute12, attribute13, attribute14, attribute15
1692: FROM WIP_JOB_DTLS_INTERFACE
1693: WHERE group_id = p_group_id
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

Line 1695: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

1691: attribute11, attribute12, attribute13, attribute14, attribute15
1692: FROM WIP_JOB_DTLS_INTERFACE
1693: WHERE group_id = p_group_id
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;

Line 1747: AND we.process_phase = WIP_CONSTANTS.ML_VALIDATION

1743: AND wdj.organization_id = p_organization_id
1744: AND wdj.wip_entity_id = we.wip_entity_id (+)
1745: AND wdj.organization_id = we.organization_id (+)
1746: AND we.group_id = p_group_id
1747: AND we.process_phase = WIP_CONSTANTS.ML_VALIDATION
1748: AND we.process_status in ( WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING )
1749: AND we.header_id = cur_oper.parent_header_id;
1750:
1751: begin

Line 1748: AND we.process_status in ( WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING )

1744: AND wdj.wip_entity_id = we.wip_entity_id (+)
1745: AND wdj.organization_id = we.organization_id (+)
1746: AND we.group_id = p_group_id
1747: AND we.process_phase = WIP_CONSTANTS.ML_VALIDATION
1748: AND we.process_status in ( WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING )
1749: AND we.header_id = cur_oper.parent_header_id;
1750:
1751: begin
1752: SELECT min(operation_seq_num)

Line 1766: if l_status_type = WIP_CONSTANTS.UNRELEASED or

1762: -- Bug 3484856 - If job is 'Unreleased' or creating a work-order,
1763: -- then quantity_in_queue should be 0 else create the operation with
1764: -- open qty in queue
1765: IF l_first_operation is null then
1766: if l_status_type = WIP_CONSTANTS.UNRELEASED or
1767: ( l_load_type is NOT NULL and
1768: l_load_type in ( WIP_CONSTANTS.CREATE_JOB,
1769: WIP_CONSTANTS.CREATE_NS_JOB,
1770: WIP_CONSTANTS.CREATE_EAM_JOB ) ) then

Line 1768: l_load_type in ( WIP_CONSTANTS.CREATE_JOB,

1764: -- open qty in queue
1765: IF l_first_operation is null then
1766: if l_status_type = WIP_CONSTANTS.UNRELEASED or
1767: ( l_load_type is NOT NULL and
1768: l_load_type in ( WIP_CONSTANTS.CREATE_JOB,
1769: WIP_CONSTANTS.CREATE_NS_JOB,
1770: WIP_CONSTANTS.CREATE_EAM_JOB ) ) then
1771: l_quantity_in_queue := 0;
1772: else

Line 1769: WIP_CONSTANTS.CREATE_NS_JOB,

1765: IF l_first_operation is null then
1766: if l_status_type = WIP_CONSTANTS.UNRELEASED or
1767: ( l_load_type is NOT NULL and
1768: l_load_type in ( WIP_CONSTANTS.CREATE_JOB,
1769: WIP_CONSTANTS.CREATE_NS_JOB,
1770: WIP_CONSTANTS.CREATE_EAM_JOB ) ) then
1771: l_quantity_in_queue := 0;
1772: else
1773: l_quantity_in_queue := l_open_quantity;

Line 1770: WIP_CONSTANTS.CREATE_EAM_JOB ) ) then

1766: if l_status_type = WIP_CONSTANTS.UNRELEASED or
1767: ( l_load_type is NOT NULL and
1768: l_load_type in ( WIP_CONSTANTS.CREATE_JOB,
1769: WIP_CONSTANTS.CREATE_NS_JOB,
1770: WIP_CONSTANTS.CREATE_EAM_JOB ) ) then
1771: l_quantity_in_queue := 0;
1772: else
1773: l_quantity_in_queue := l_open_quantity;
1774: end if;

Line 2114: AND WJDI.process_phase = WIP_CONSTANTS.ML_VALIDATION

2110: WJDI.attribute11, WJDI.attribute12, WJDI.attribute13, WJDI.attribute14, WJDI.attribute15,
2111: WO.standard_operation_id curr_standard_operation_id
2112: FROM WIP_JOB_DTLS_INTERFACE WJDI, WIP_OPERATIONS WO
2113: WHERE group_id = p_group_id
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

Line 2115: AND WJDI.process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

2111: WO.standard_operation_id curr_standard_operation_id
2112: FROM WIP_JOB_DTLS_INTERFACE WJDI, WIP_OPERATIONS WO
2113: WHERE group_id = p_group_id
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

Line 2297: and wjdi.process_phase = wip_constants.ml_validation

2293: cursor c_invalid_rows is
2294: select wjdi.interface_id
2295: from wip_job_dtls_interface wjdi
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)

Line 2298: and wjdi.process_status in (wip_constants.running,

2294: select wjdi.interface_id
2295: from wip_job_dtls_interface wjdi
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

Line 2299: wip_constants.warning)

2295: from wip_job_dtls_interface wjdi
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

Line 2353: set process_status = wip_constants.error

2349: end loop;
2350:
2351: if(l_error_exists) then
2352: update wip_job_dtls_interface wjdi
2353: set process_status = wip_constants.error
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)

Line 2355: and wjdi.process_phase = wip_constants.ml_validation

2351: if(l_error_exists) then
2352: update wip_job_dtls_interface wjdi
2353: set process_status = wip_constants.error
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)

Line 2356: and wjdi.process_status in (wip_constants.running,

2352: update wip_job_dtls_interface wjdi
2353: set process_status = wip_constants.error
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

Line 2357: wip_constants.warning)

2353: set process_status = wip_constants.error
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

Line 2432: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

2428: p_organization_id number) IS
2429: SELECT operation_seq_num, resource_seq_num
2430: FROM WIP_JOB_DTLS_INTERFACE
2431: WHERE group_id = p_group_id
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,

Line 2433: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)

2429: SELECT operation_seq_num, resource_seq_num
2430: FROM WIP_JOB_DTLS_INTERFACE
2431: WHERE group_id = p_group_id
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)

Line 2479: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING);

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;
2483:

Line 2679: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

2675: attribute13,attribute14,attribute15,schedule_seq_num,
2676: substitute_group_num,replacement_group_num,batch_id
2677: FROM WIP_JOB_DTLS_INTERFACE
2678: WHERE group_id = p_group_id
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

Line 2680: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

2676: substitute_group_num,replacement_group_num,batch_id
2677: FROM WIP_JOB_DTLS_INTERFACE
2678: WHERE group_id = p_group_id
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;

Line 2778: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

2774: attribute13,attribute14,attribute15,schedule_seq_num,
2775: substitute_group_num,replacement_group_num,batch_id
2776: FROM WIP_JOB_DTLS_INTERFACE
2777: WHERE group_id = p_group_id
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

Line 2779: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

2775: substitute_group_num,replacement_group_num,batch_id
2776: FROM WIP_JOB_DTLS_INTERFACE
2777: WHERE group_id = p_group_id
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;

Line 2826: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION

2822: wip_job_schedule_interface wjsi,
2823: wip_entities we
2824: WHERE wjdi.group_id = p_group_id
2825: AND wjsi.group_id = p_group_id
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

Line 2827: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

2823: wip_entities we
2824: WHERE wjdi.group_id = p_group_id
2825: AND wjsi.group_id = p_group_id
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

Line 2887: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION

2883: wip_job_schedule_interface wjsi,
2884: wip_entities we
2885: WHERE wjdi.group_id = p_group_id
2886: AND wjsi.group_id = p_group_id
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

Line 2888: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

2884: wip_entities we
2885: WHERE wjdi.group_id = p_group_id
2886: AND wjsi.group_id = p_group_id
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

Line 2960: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION

2956: wip_job_schedule_interface wjsi,
2957: wip_entities we
2958: WHERE wjdi.group_id = p_group_id
2959: AND wjsi.group_id = p_group_id
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

Line 2961: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

2957: wip_entities we
2958: WHERE wjdi.group_id = p_group_id
2959: AND wjsi.group_id = p_group_id
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

Line 3029: if(l_defaultSN = wip_constants.yes and

3025: into l_load_type
3026: from wip_job_schedule_interface
3027: where rowid = p_rowid;
3028:
3029: if(l_defaultSN = wip_constants.yes and
3030: l_load_type = wip_constants.create_job) then
3031: --get the number of serial numbers defaulted and the start quantity of the job
3032:
3033: SELECT count(*)

Line 3030: l_load_type = wip_constants.create_job) then

3026: from wip_job_schedule_interface
3027: where rowid = p_rowid;
3028:
3029: if(l_defaultSN = wip_constants.yes and
3030: l_load_type = wip_constants.create_job) then
3031: --get the number of serial numbers defaulted and the start quantity of the job
3032:
3033: SELECT count(*)
3034: INTO l_rowCount