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.WSM_WLT_VALIDATE_PVT dependencies on WIP_DISCRETE_JOBS

Line 1281: from wip_discrete_jobs wdj,

1277: wdj.coproducts_supply ,
1278: we.organization_id ,
1279: wdj.serialization_start_op ,
1280: wdj.wip_supply_type
1281: from wip_discrete_jobs wdj,
1282: wip_entities we
1283: where we.wip_entity_id = nvl(p_starting_job_rec.wip_entity_id,we.wip_entity_id)
1284: and we.wip_entity_name = p_starting_job_rec.wip_entity_name
1285: and wdj.wip_entity_id = we.wip_entity_id

Line 1320: from wip_discrete_jobs wdj,

1316: wdj.coproducts_supply ,
1317: we.organization_id ,
1318: wdj.serialization_start_op ,
1319: wdj.wip_supply_type
1320: from wip_discrete_jobs wdj,
1321: wip_entities we
1322: where wdj.wip_entity_id = p_starting_job_rec.wip_entity_id
1323: and we.wip_entity_name = nvl(p_starting_job_rec.wip_entity_name,we.wip_entity_name)
1324: and wdj.wip_entity_id = we.wip_entity_id

Line 1360: l_description WIP_DISCRETE_JOBS.description%TYPE ;

1356: and wo.operation_seq_num = operation_seq_num
1357: and (nvl(wo.quantity_in_queue,0) > 0 or nvl(wo.quantity_waiting_to_move,0) > 0);
1358:
1359: l_wip_entity_name WIP_ENTITIES.wip_entity_name%TYPE ;
1360: l_description WIP_DISCRETE_JOBS.description%TYPE ;
1361: l_status_type WIP_DISCRETE_JOBS.status_type%TYPE ;
1362: l_primary_item_id WIP_DISCRETE_JOBS.primary_item_id%TYPE ;
1363: l_job_type WIP_DISCRETE_JOBS.job_type%TYPE ;
1364: l_class_code WIP_DISCRETE_JOBS.class_code%TYPE ;

Line 1361: l_status_type WIP_DISCRETE_JOBS.status_type%TYPE ;

1357: and (nvl(wo.quantity_in_queue,0) > 0 or nvl(wo.quantity_waiting_to_move,0) > 0);
1358:
1359: l_wip_entity_name WIP_ENTITIES.wip_entity_name%TYPE ;
1360: l_description WIP_DISCRETE_JOBS.description%TYPE ;
1361: l_status_type WIP_DISCRETE_JOBS.status_type%TYPE ;
1362: l_primary_item_id WIP_DISCRETE_JOBS.primary_item_id%TYPE ;
1363: l_job_type WIP_DISCRETE_JOBS.job_type%TYPE ;
1364: l_class_code WIP_DISCRETE_JOBS.class_code%TYPE ;
1365: l_date_released WIP_DISCRETE_JOBS.date_released%TYPE ;

Line 1362: l_primary_item_id WIP_DISCRETE_JOBS.primary_item_id%TYPE ;

1358:
1359: l_wip_entity_name WIP_ENTITIES.wip_entity_name%TYPE ;
1360: l_description WIP_DISCRETE_JOBS.description%TYPE ;
1361: l_status_type WIP_DISCRETE_JOBS.status_type%TYPE ;
1362: l_primary_item_id WIP_DISCRETE_JOBS.primary_item_id%TYPE ;
1363: l_job_type WIP_DISCRETE_JOBS.job_type%TYPE ;
1364: l_class_code WIP_DISCRETE_JOBS.class_code%TYPE ;
1365: l_date_released WIP_DISCRETE_JOBS.date_released%TYPE ;
1366: l_scheduled_completion_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE ;

Line 1363: l_job_type WIP_DISCRETE_JOBS.job_type%TYPE ;

1359: l_wip_entity_name WIP_ENTITIES.wip_entity_name%TYPE ;
1360: l_description WIP_DISCRETE_JOBS.description%TYPE ;
1361: l_status_type WIP_DISCRETE_JOBS.status_type%TYPE ;
1362: l_primary_item_id WIP_DISCRETE_JOBS.primary_item_id%TYPE ;
1363: l_job_type WIP_DISCRETE_JOBS.job_type%TYPE ;
1364: l_class_code WIP_DISCRETE_JOBS.class_code%TYPE ;
1365: l_date_released WIP_DISCRETE_JOBS.date_released%TYPE ;
1366: l_scheduled_completion_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE ;
1367: l_scheduled_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE ;

Line 1364: l_class_code WIP_DISCRETE_JOBS.class_code%TYPE ;

1360: l_description WIP_DISCRETE_JOBS.description%TYPE ;
1361: l_status_type WIP_DISCRETE_JOBS.status_type%TYPE ;
1362: l_primary_item_id WIP_DISCRETE_JOBS.primary_item_id%TYPE ;
1363: l_job_type WIP_DISCRETE_JOBS.job_type%TYPE ;
1364: l_class_code WIP_DISCRETE_JOBS.class_code%TYPE ;
1365: l_date_released WIP_DISCRETE_JOBS.date_released%TYPE ;
1366: l_scheduled_completion_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE ;
1367: l_scheduled_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE ;
1368: l_start_quantity WIP_DISCRETE_JOBS.start_quantity%TYPE ;

Line 1365: l_date_released WIP_DISCRETE_JOBS.date_released%TYPE ;

1361: l_status_type WIP_DISCRETE_JOBS.status_type%TYPE ;
1362: l_primary_item_id WIP_DISCRETE_JOBS.primary_item_id%TYPE ;
1363: l_job_type WIP_DISCRETE_JOBS.job_type%TYPE ;
1364: l_class_code WIP_DISCRETE_JOBS.class_code%TYPE ;
1365: l_date_released WIP_DISCRETE_JOBS.date_released%TYPE ;
1366: l_scheduled_completion_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE ;
1367: l_scheduled_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE ;
1368: l_start_quantity WIP_DISCRETE_JOBS.start_quantity%TYPE ;
1369: l_net_quantity WIP_DISCRETE_JOBS.net_quantity%TYPE ;

Line 1366: l_scheduled_completion_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE ;

1362: l_primary_item_id WIP_DISCRETE_JOBS.primary_item_id%TYPE ;
1363: l_job_type WIP_DISCRETE_JOBS.job_type%TYPE ;
1364: l_class_code WIP_DISCRETE_JOBS.class_code%TYPE ;
1365: l_date_released WIP_DISCRETE_JOBS.date_released%TYPE ;
1366: l_scheduled_completion_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE ;
1367: l_scheduled_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE ;
1368: l_start_quantity WIP_DISCRETE_JOBS.start_quantity%TYPE ;
1369: l_net_quantity WIP_DISCRETE_JOBS.net_quantity%TYPE ;
1370: l_bom_reference_id WIP_DISCRETE_JOBS.bom_reference_id%TYPE ;

Line 1367: l_scheduled_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE ;

1363: l_job_type WIP_DISCRETE_JOBS.job_type%TYPE ;
1364: l_class_code WIP_DISCRETE_JOBS.class_code%TYPE ;
1365: l_date_released WIP_DISCRETE_JOBS.date_released%TYPE ;
1366: l_scheduled_completion_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE ;
1367: l_scheduled_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE ;
1368: l_start_quantity WIP_DISCRETE_JOBS.start_quantity%TYPE ;
1369: l_net_quantity WIP_DISCRETE_JOBS.net_quantity%TYPE ;
1370: l_bom_reference_id WIP_DISCRETE_JOBS.bom_reference_id%TYPE ;
1371: l_routing_reference_id WIP_DISCRETE_JOBS.routing_reference_id%TYPE ;

Line 1368: l_start_quantity WIP_DISCRETE_JOBS.start_quantity%TYPE ;

1364: l_class_code WIP_DISCRETE_JOBS.class_code%TYPE ;
1365: l_date_released WIP_DISCRETE_JOBS.date_released%TYPE ;
1366: l_scheduled_completion_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE ;
1367: l_scheduled_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE ;
1368: l_start_quantity WIP_DISCRETE_JOBS.start_quantity%TYPE ;
1369: l_net_quantity WIP_DISCRETE_JOBS.net_quantity%TYPE ;
1370: l_bom_reference_id WIP_DISCRETE_JOBS.bom_reference_id%TYPE ;
1371: l_routing_reference_id WIP_DISCRETE_JOBS.routing_reference_id%TYPE ;
1372: l_common_bom_sequence_id WIP_DISCRETE_JOBS.common_bom_sequence_id%TYPE ;

Line 1369: l_net_quantity WIP_DISCRETE_JOBS.net_quantity%TYPE ;

1365: l_date_released WIP_DISCRETE_JOBS.date_released%TYPE ;
1366: l_scheduled_completion_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE ;
1367: l_scheduled_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE ;
1368: l_start_quantity WIP_DISCRETE_JOBS.start_quantity%TYPE ;
1369: l_net_quantity WIP_DISCRETE_JOBS.net_quantity%TYPE ;
1370: l_bom_reference_id WIP_DISCRETE_JOBS.bom_reference_id%TYPE ;
1371: l_routing_reference_id WIP_DISCRETE_JOBS.routing_reference_id%TYPE ;
1372: l_common_bom_sequence_id WIP_DISCRETE_JOBS.common_bom_sequence_id%TYPE ;
1373: l_common_routing_sequence_id WIP_DISCRETE_JOBS.common_routing_sequence_id %TYPE ;

Line 1370: l_bom_reference_id WIP_DISCRETE_JOBS.bom_reference_id%TYPE ;

1366: l_scheduled_completion_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE ;
1367: l_scheduled_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE ;
1368: l_start_quantity WIP_DISCRETE_JOBS.start_quantity%TYPE ;
1369: l_net_quantity WIP_DISCRETE_JOBS.net_quantity%TYPE ;
1370: l_bom_reference_id WIP_DISCRETE_JOBS.bom_reference_id%TYPE ;
1371: l_routing_reference_id WIP_DISCRETE_JOBS.routing_reference_id%TYPE ;
1372: l_common_bom_sequence_id WIP_DISCRETE_JOBS.common_bom_sequence_id%TYPE ;
1373: l_common_routing_sequence_id WIP_DISCRETE_JOBS.common_routing_sequence_id %TYPE ;
1374: l_bom_revision WIP_DISCRETE_JOBS.bom_revision%TYPE ;

Line 1371: l_routing_reference_id WIP_DISCRETE_JOBS.routing_reference_id%TYPE ;

1367: l_scheduled_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE ;
1368: l_start_quantity WIP_DISCRETE_JOBS.start_quantity%TYPE ;
1369: l_net_quantity WIP_DISCRETE_JOBS.net_quantity%TYPE ;
1370: l_bom_reference_id WIP_DISCRETE_JOBS.bom_reference_id%TYPE ;
1371: l_routing_reference_id WIP_DISCRETE_JOBS.routing_reference_id%TYPE ;
1372: l_common_bom_sequence_id WIP_DISCRETE_JOBS.common_bom_sequence_id%TYPE ;
1373: l_common_routing_sequence_id WIP_DISCRETE_JOBS.common_routing_sequence_id %TYPE ;
1374: l_bom_revision WIP_DISCRETE_JOBS.bom_revision%TYPE ;
1375: l_routing_revision WIP_DISCRETE_JOBS.routing_revision%TYPE ;

Line 1372: l_common_bom_sequence_id WIP_DISCRETE_JOBS.common_bom_sequence_id%TYPE ;

1368: l_start_quantity WIP_DISCRETE_JOBS.start_quantity%TYPE ;
1369: l_net_quantity WIP_DISCRETE_JOBS.net_quantity%TYPE ;
1370: l_bom_reference_id WIP_DISCRETE_JOBS.bom_reference_id%TYPE ;
1371: l_routing_reference_id WIP_DISCRETE_JOBS.routing_reference_id%TYPE ;
1372: l_common_bom_sequence_id WIP_DISCRETE_JOBS.common_bom_sequence_id%TYPE ;
1373: l_common_routing_sequence_id WIP_DISCRETE_JOBS.common_routing_sequence_id %TYPE ;
1374: l_bom_revision WIP_DISCRETE_JOBS.bom_revision%TYPE ;
1375: l_routing_revision WIP_DISCRETE_JOBS.routing_revision%TYPE ;
1376: l_bom_revision_date WIP_DISCRETE_JOBS.bom_revision_date%TYPE ;

Line 1373: l_common_routing_sequence_id WIP_DISCRETE_JOBS.common_routing_sequence_id %TYPE ;

1369: l_net_quantity WIP_DISCRETE_JOBS.net_quantity%TYPE ;
1370: l_bom_reference_id WIP_DISCRETE_JOBS.bom_reference_id%TYPE ;
1371: l_routing_reference_id WIP_DISCRETE_JOBS.routing_reference_id%TYPE ;
1372: l_common_bom_sequence_id WIP_DISCRETE_JOBS.common_bom_sequence_id%TYPE ;
1373: l_common_routing_sequence_id WIP_DISCRETE_JOBS.common_routing_sequence_id %TYPE ;
1374: l_bom_revision WIP_DISCRETE_JOBS.bom_revision%TYPE ;
1375: l_routing_revision WIP_DISCRETE_JOBS.routing_revision%TYPE ;
1376: l_bom_revision_date WIP_DISCRETE_JOBS.bom_revision_date%TYPE ;
1377: l_routing_revision_date WIP_DISCRETE_JOBS.routing_revision_date%TYPE ;

Line 1374: l_bom_revision WIP_DISCRETE_JOBS.bom_revision%TYPE ;

1370: l_bom_reference_id WIP_DISCRETE_JOBS.bom_reference_id%TYPE ;
1371: l_routing_reference_id WIP_DISCRETE_JOBS.routing_reference_id%TYPE ;
1372: l_common_bom_sequence_id WIP_DISCRETE_JOBS.common_bom_sequence_id%TYPE ;
1373: l_common_routing_sequence_id WIP_DISCRETE_JOBS.common_routing_sequence_id %TYPE ;
1374: l_bom_revision WIP_DISCRETE_JOBS.bom_revision%TYPE ;
1375: l_routing_revision WIP_DISCRETE_JOBS.routing_revision%TYPE ;
1376: l_bom_revision_date WIP_DISCRETE_JOBS.bom_revision_date%TYPE ;
1377: l_routing_revision_date WIP_DISCRETE_JOBS.routing_revision_date%TYPE ;
1378: l_alternate_bom_designator WIP_DISCRETE_JOBS.alternate_bom_designator%TYPE ;

Line 1375: l_routing_revision WIP_DISCRETE_JOBS.routing_revision%TYPE ;

1371: l_routing_reference_id WIP_DISCRETE_JOBS.routing_reference_id%TYPE ;
1372: l_common_bom_sequence_id WIP_DISCRETE_JOBS.common_bom_sequence_id%TYPE ;
1373: l_common_routing_sequence_id WIP_DISCRETE_JOBS.common_routing_sequence_id %TYPE ;
1374: l_bom_revision WIP_DISCRETE_JOBS.bom_revision%TYPE ;
1375: l_routing_revision WIP_DISCRETE_JOBS.routing_revision%TYPE ;
1376: l_bom_revision_date WIP_DISCRETE_JOBS.bom_revision_date%TYPE ;
1377: l_routing_revision_date WIP_DISCRETE_JOBS.routing_revision_date%TYPE ;
1378: l_alternate_bom_designator WIP_DISCRETE_JOBS.alternate_bom_designator%TYPE ;
1379: l_alternate_routing_designator WIP_DISCRETE_JOBS.alternate_routing_designator%TYPE ;

Line 1376: l_bom_revision_date WIP_DISCRETE_JOBS.bom_revision_date%TYPE ;

1372: l_common_bom_sequence_id WIP_DISCRETE_JOBS.common_bom_sequence_id%TYPE ;
1373: l_common_routing_sequence_id WIP_DISCRETE_JOBS.common_routing_sequence_id %TYPE ;
1374: l_bom_revision WIP_DISCRETE_JOBS.bom_revision%TYPE ;
1375: l_routing_revision WIP_DISCRETE_JOBS.routing_revision%TYPE ;
1376: l_bom_revision_date WIP_DISCRETE_JOBS.bom_revision_date%TYPE ;
1377: l_routing_revision_date WIP_DISCRETE_JOBS.routing_revision_date%TYPE ;
1378: l_alternate_bom_designator WIP_DISCRETE_JOBS.alternate_bom_designator%TYPE ;
1379: l_alternate_routing_designator WIP_DISCRETE_JOBS.alternate_routing_designator%TYPE ;
1380: l_completion_subinventory WIP_DISCRETE_JOBS.completion_subinventory%TYPE ;

Line 1377: l_routing_revision_date WIP_DISCRETE_JOBS.routing_revision_date%TYPE ;

1373: l_common_routing_sequence_id WIP_DISCRETE_JOBS.common_routing_sequence_id %TYPE ;
1374: l_bom_revision WIP_DISCRETE_JOBS.bom_revision%TYPE ;
1375: l_routing_revision WIP_DISCRETE_JOBS.routing_revision%TYPE ;
1376: l_bom_revision_date WIP_DISCRETE_JOBS.bom_revision_date%TYPE ;
1377: l_routing_revision_date WIP_DISCRETE_JOBS.routing_revision_date%TYPE ;
1378: l_alternate_bom_designator WIP_DISCRETE_JOBS.alternate_bom_designator%TYPE ;
1379: l_alternate_routing_designator WIP_DISCRETE_JOBS.alternate_routing_designator%TYPE ;
1380: l_completion_subinventory WIP_DISCRETE_JOBS.completion_subinventory%TYPE ;
1381: l_completion_locator_id WIP_DISCRETE_JOBS.completion_locator_id%TYPE ;

Line 1378: l_alternate_bom_designator WIP_DISCRETE_JOBS.alternate_bom_designator%TYPE ;

1374: l_bom_revision WIP_DISCRETE_JOBS.bom_revision%TYPE ;
1375: l_routing_revision WIP_DISCRETE_JOBS.routing_revision%TYPE ;
1376: l_bom_revision_date WIP_DISCRETE_JOBS.bom_revision_date%TYPE ;
1377: l_routing_revision_date WIP_DISCRETE_JOBS.routing_revision_date%TYPE ;
1378: l_alternate_bom_designator WIP_DISCRETE_JOBS.alternate_bom_designator%TYPE ;
1379: l_alternate_routing_designator WIP_DISCRETE_JOBS.alternate_routing_designator%TYPE ;
1380: l_completion_subinventory WIP_DISCRETE_JOBS.completion_subinventory%TYPE ;
1381: l_completion_locator_id WIP_DISCRETE_JOBS.completion_locator_id%TYPE ;
1382: l_kanban_card_id WIP_DISCRETE_JOBS.kanban_card_id%TYPE ;

Line 1379: l_alternate_routing_designator WIP_DISCRETE_JOBS.alternate_routing_designator%TYPE ;

1375: l_routing_revision WIP_DISCRETE_JOBS.routing_revision%TYPE ;
1376: l_bom_revision_date WIP_DISCRETE_JOBS.bom_revision_date%TYPE ;
1377: l_routing_revision_date WIP_DISCRETE_JOBS.routing_revision_date%TYPE ;
1378: l_alternate_bom_designator WIP_DISCRETE_JOBS.alternate_bom_designator%TYPE ;
1379: l_alternate_routing_designator WIP_DISCRETE_JOBS.alternate_routing_designator%TYPE ;
1380: l_completion_subinventory WIP_DISCRETE_JOBS.completion_subinventory%TYPE ;
1381: l_completion_locator_id WIP_DISCRETE_JOBS.completion_locator_id%TYPE ;
1382: l_kanban_card_id WIP_DISCRETE_JOBS.kanban_card_id%TYPE ;
1383: l_coproducts_supply WIP_DISCRETE_JOBS.coproducts_supply%TYPE ;

Line 1380: l_completion_subinventory WIP_DISCRETE_JOBS.completion_subinventory%TYPE ;

1376: l_bom_revision_date WIP_DISCRETE_JOBS.bom_revision_date%TYPE ;
1377: l_routing_revision_date WIP_DISCRETE_JOBS.routing_revision_date%TYPE ;
1378: l_alternate_bom_designator WIP_DISCRETE_JOBS.alternate_bom_designator%TYPE ;
1379: l_alternate_routing_designator WIP_DISCRETE_JOBS.alternate_routing_designator%TYPE ;
1380: l_completion_subinventory WIP_DISCRETE_JOBS.completion_subinventory%TYPE ;
1381: l_completion_locator_id WIP_DISCRETE_JOBS.completion_locator_id%TYPE ;
1382: l_kanban_card_id WIP_DISCRETE_JOBS.kanban_card_id%TYPE ;
1383: l_coproducts_supply WIP_DISCRETE_JOBS.coproducts_supply%TYPE ;
1384: l_organization_id WIP_ENTITIES.organization_id%TYPE ;

Line 1381: l_completion_locator_id WIP_DISCRETE_JOBS.completion_locator_id%TYPE ;

1377: l_routing_revision_date WIP_DISCRETE_JOBS.routing_revision_date%TYPE ;
1378: l_alternate_bom_designator WIP_DISCRETE_JOBS.alternate_bom_designator%TYPE ;
1379: l_alternate_routing_designator WIP_DISCRETE_JOBS.alternate_routing_designator%TYPE ;
1380: l_completion_subinventory WIP_DISCRETE_JOBS.completion_subinventory%TYPE ;
1381: l_completion_locator_id WIP_DISCRETE_JOBS.completion_locator_id%TYPE ;
1382: l_kanban_card_id WIP_DISCRETE_JOBS.kanban_card_id%TYPE ;
1383: l_coproducts_supply WIP_DISCRETE_JOBS.coproducts_supply%TYPE ;
1384: l_organization_id WIP_ENTITIES.organization_id%TYPE ;
1385: l_wip_supply_type NUMBER ;

Line 1382: l_kanban_card_id WIP_DISCRETE_JOBS.kanban_card_id%TYPE ;

1378: l_alternate_bom_designator WIP_DISCRETE_JOBS.alternate_bom_designator%TYPE ;
1379: l_alternate_routing_designator WIP_DISCRETE_JOBS.alternate_routing_designator%TYPE ;
1380: l_completion_subinventory WIP_DISCRETE_JOBS.completion_subinventory%TYPE ;
1381: l_completion_locator_id WIP_DISCRETE_JOBS.completion_locator_id%TYPE ;
1382: l_kanban_card_id WIP_DISCRETE_JOBS.kanban_card_id%TYPE ;
1383: l_coproducts_supply WIP_DISCRETE_JOBS.coproducts_supply%TYPE ;
1384: l_organization_id WIP_ENTITIES.organization_id%TYPE ;
1385: l_wip_supply_type NUMBER ;
1386: l_serial_track_flag NUMBER ;

Line 1383: l_coproducts_supply WIP_DISCRETE_JOBS.coproducts_supply%TYPE ;

1379: l_alternate_routing_designator WIP_DISCRETE_JOBS.alternate_routing_designator%TYPE ;
1380: l_completion_subinventory WIP_DISCRETE_JOBS.completion_subinventory%TYPE ;
1381: l_completion_locator_id WIP_DISCRETE_JOBS.completion_locator_id%TYPE ;
1382: l_kanban_card_id WIP_DISCRETE_JOBS.kanban_card_id%TYPE ;
1383: l_coproducts_supply WIP_DISCRETE_JOBS.coproducts_supply%TYPE ;
1384: l_organization_id WIP_ENTITIES.organization_id%TYPE ;
1385: l_wip_supply_type NUMBER ;
1386: l_serial_track_flag NUMBER ;
1387:

Line 5740: l_rtg_revision WIP_DISCRETE_JOBS.ROUTING_REVISION%TYPE; --varchar2(10); -- ST : Changed

5736: x_msg_count OUT NOCOPY NUMBER,
5737: x_msg_data OUT NOCOPY VARCHAR2
5738: ) is
5739:
5740: l_rtg_revision WIP_DISCRETE_JOBS.ROUTING_REVISION%TYPE; --varchar2(10); -- ST : Changed
5741: l_null_char VARCHAR2(10) := FND_API.G_NULL_CHAR;
5742:
5743: l_rj_compl_subinv WIP_DISCRETE_JOBS.completion_subinventory%TYPE; -- VARCHAR2(1000); -- ST : Changed
5744: l_rj_loc_id NUMBER;

Line 5743: l_rj_compl_subinv WIP_DISCRETE_JOBS.completion_subinventory%TYPE; -- VARCHAR2(1000); -- ST : Changed

5739:
5740: l_rtg_revision WIP_DISCRETE_JOBS.ROUTING_REVISION%TYPE; --varchar2(10); -- ST : Changed
5741: l_null_char VARCHAR2(10) := FND_API.G_NULL_CHAR;
5742:
5743: l_rj_compl_subinv WIP_DISCRETE_JOBS.completion_subinventory%TYPE; -- VARCHAR2(1000); -- ST : Changed
5744: l_rj_loc_id NUMBER;
5745: l_rj_rtg_seq_id NUMBER;
5746: l_rj_common_rtg_seq_id NUMBER;
5747: l_return_status VARCHAR2(1);

Line 6129: l_bom_revision WIP_DISCRETE_JOBS.BOM_REVISION%TYPE; -- VARCHAR2(10); --ST : Changed

6125: l_return_status VARCHAR2(1);
6126: l_msg_data VARCHAR2(1000);
6127: l_msg_count NUMBER;
6128: l_item_id NUMBER;
6129: l_bom_revision WIP_DISCRETE_JOBS.BOM_REVISION%TYPE; -- VARCHAR2(10); --ST : Changed
6130: l_error_out NUMBER := 0; -- ST : Added for bug 5218479 --
6131: e_invalid_revision exception; -- ST : Added for bug 5218479 --
6132:
6133: -- ST : Added for bug 5218479