DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1183: UPDATE wip_requirement_operations

1179: -- FROM wsm_parameters
1180: -- WHERE organization_id = x_organization_id ) ;
1181: -- ED: CZH.I_9999
1182:
1183: UPDATE wip_requirement_operations
1184: SET required_quantity = 0
1185: --quantity_per_assembly = 0 abb, bug 2931071
1186: WHERE wip_entity_id = x_wip_entity_id
1187: AND operation_seq_num > x_from_op;

Line 1263: DELETE FROM WIP_REQUIREMENT_OPERATIONS

1259: AND PROGRAM_ID = -999
1260: AND ORGANIZATION_ID = X_Organization_Id;
1261:
1262: l_stat_num := 50;
1263: DELETE FROM WIP_REQUIREMENT_OPERATIONS
1264: WHERE WIP_ENTITY_ID = X_Wip_Entity_id
1265: --AND OPERATION_SEQ_NUM > X_From_Op
1266: AND OPERATION_SEQ_NUM = X_To_Op
1267: AND ORGANIZATION_ID = X_Organization_Id;

Line 2580: type t_inventory_item_id is table of WIP_REQUIREMENT_OPERATIONS.inventory_item_id%type index by binary_integer;

2576: AND WCRO1.OPERATION_SEQ_NUM(+)= -1*p_to_rtg_op_seq_num
2577: AND WCRO.source_phantom_id = WCRO1.component_item_id(+)
2578: ORDER BY WCRO.component_item_id, WCRO.wip_supply_type desc;
2579:
2580: type t_inventory_item_id is table of WIP_REQUIREMENT_OPERATIONS.inventory_item_id%type index by binary_integer;
2581: type t_organization_id is table of WIP_REQUIREMENT_OPERATIONS.organization_id%type index by binary_integer;
2582: type t_wip_entity_id is table of WIP_REQUIREMENT_OPERATIONS.wip_entity_id%type index by binary_integer;
2583: type t_component_sequence_id is table of WIP_REQUIREMENT_OPERATIONS.component_sequence_id%type index by binary_integer;
2584: type t_wip_supply_type is table of WIP_REQUIREMENT_OPERATIONS.wip_supply_type%type index by binary_integer;

Line 2581: type t_organization_id is table of WIP_REQUIREMENT_OPERATIONS.organization_id%type index by binary_integer;

2577: AND WCRO.source_phantom_id = WCRO1.component_item_id(+)
2578: ORDER BY WCRO.component_item_id, WCRO.wip_supply_type desc;
2579:
2580: type t_inventory_item_id is table of WIP_REQUIREMENT_OPERATIONS.inventory_item_id%type index by binary_integer;
2581: type t_organization_id is table of WIP_REQUIREMENT_OPERATIONS.organization_id%type index by binary_integer;
2582: type t_wip_entity_id is table of WIP_REQUIREMENT_OPERATIONS.wip_entity_id%type index by binary_integer;
2583: type t_component_sequence_id is table of WIP_REQUIREMENT_OPERATIONS.component_sequence_id%type index by binary_integer;
2584: type t_wip_supply_type is table of WIP_REQUIREMENT_OPERATIONS.wip_supply_type%type index by binary_integer;
2585: type t_date_required is table of WIP_REQUIREMENT_OPERATIONS.date_required%type index by binary_integer;

Line 2582: type t_wip_entity_id is table of WIP_REQUIREMENT_OPERATIONS.wip_entity_id%type index by binary_integer;

2578: ORDER BY WCRO.component_item_id, WCRO.wip_supply_type desc;
2579:
2580: type t_inventory_item_id is table of WIP_REQUIREMENT_OPERATIONS.inventory_item_id%type index by binary_integer;
2581: type t_organization_id is table of WIP_REQUIREMENT_OPERATIONS.organization_id%type index by binary_integer;
2582: type t_wip_entity_id is table of WIP_REQUIREMENT_OPERATIONS.wip_entity_id%type index by binary_integer;
2583: type t_component_sequence_id is table of WIP_REQUIREMENT_OPERATIONS.component_sequence_id%type index by binary_integer;
2584: type t_wip_supply_type is table of WIP_REQUIREMENT_OPERATIONS.wip_supply_type%type index by binary_integer;
2585: type t_date_required is table of WIP_REQUIREMENT_OPERATIONS.date_required%type index by binary_integer;
2586: type t_basis_type is table of WIP_REQUIREMENT_OPERATIONS.basis_type%type index by binary_integer; --LBM enh

Line 2583: type t_component_sequence_id is table of WIP_REQUIREMENT_OPERATIONS.component_sequence_id%type index by binary_integer;

2579:
2580: type t_inventory_item_id is table of WIP_REQUIREMENT_OPERATIONS.inventory_item_id%type index by binary_integer;
2581: type t_organization_id is table of WIP_REQUIREMENT_OPERATIONS.organization_id%type index by binary_integer;
2582: type t_wip_entity_id is table of WIP_REQUIREMENT_OPERATIONS.wip_entity_id%type index by binary_integer;
2583: type t_component_sequence_id is table of WIP_REQUIREMENT_OPERATIONS.component_sequence_id%type index by binary_integer;
2584: type t_wip_supply_type is table of WIP_REQUIREMENT_OPERATIONS.wip_supply_type%type index by binary_integer;
2585: type t_date_required is table of WIP_REQUIREMENT_OPERATIONS.date_required%type index by binary_integer;
2586: type t_basis_type is table of WIP_REQUIREMENT_OPERATIONS.basis_type%type index by binary_integer; --LBM enh
2587: type t_component_yield_factor is table of WIP_REQUIREMENT_OPERATIONS.component_yield_factor%type index by binary_integer; --LBM enh

Line 2584: type t_wip_supply_type is table of WIP_REQUIREMENT_OPERATIONS.wip_supply_type%type index by binary_integer;

2580: type t_inventory_item_id is table of WIP_REQUIREMENT_OPERATIONS.inventory_item_id%type index by binary_integer;
2581: type t_organization_id is table of WIP_REQUIREMENT_OPERATIONS.organization_id%type index by binary_integer;
2582: type t_wip_entity_id is table of WIP_REQUIREMENT_OPERATIONS.wip_entity_id%type index by binary_integer;
2583: type t_component_sequence_id is table of WIP_REQUIREMENT_OPERATIONS.component_sequence_id%type index by binary_integer;
2584: type t_wip_supply_type is table of WIP_REQUIREMENT_OPERATIONS.wip_supply_type%type index by binary_integer;
2585: type t_date_required is table of WIP_REQUIREMENT_OPERATIONS.date_required%type index by binary_integer;
2586: type t_basis_type is table of WIP_REQUIREMENT_OPERATIONS.basis_type%type index by binary_integer; --LBM enh
2587: type t_component_yield_factor is table of WIP_REQUIREMENT_OPERATIONS.component_yield_factor%type index by binary_integer; --LBM enh
2588: type t_required_quantity is table of WIP_REQUIREMENT_OPERATIONS.required_quantity%type index by binary_integer;

Line 2585: type t_date_required is table of WIP_REQUIREMENT_OPERATIONS.date_required%type index by binary_integer;

2581: type t_organization_id is table of WIP_REQUIREMENT_OPERATIONS.organization_id%type index by binary_integer;
2582: type t_wip_entity_id is table of WIP_REQUIREMENT_OPERATIONS.wip_entity_id%type index by binary_integer;
2583: type t_component_sequence_id is table of WIP_REQUIREMENT_OPERATIONS.component_sequence_id%type index by binary_integer;
2584: type t_wip_supply_type is table of WIP_REQUIREMENT_OPERATIONS.wip_supply_type%type index by binary_integer;
2585: type t_date_required is table of WIP_REQUIREMENT_OPERATIONS.date_required%type index by binary_integer;
2586: type t_basis_type is table of WIP_REQUIREMENT_OPERATIONS.basis_type%type index by binary_integer; --LBM enh
2587: type t_component_yield_factor is table of WIP_REQUIREMENT_OPERATIONS.component_yield_factor%type index by binary_integer; --LBM enh
2588: type t_required_quantity is table of WIP_REQUIREMENT_OPERATIONS.required_quantity%type index by binary_integer;
2589: type t_quantity_per_assembly is table of WIP_REQUIREMENT_OPERATIONS.quantity_per_assembly%type index by binary_integer;

Line 2586: type t_basis_type is table of WIP_REQUIREMENT_OPERATIONS.basis_type%type index by binary_integer; --LBM enh

2582: type t_wip_entity_id is table of WIP_REQUIREMENT_OPERATIONS.wip_entity_id%type index by binary_integer;
2583: type t_component_sequence_id is table of WIP_REQUIREMENT_OPERATIONS.component_sequence_id%type index by binary_integer;
2584: type t_wip_supply_type is table of WIP_REQUIREMENT_OPERATIONS.wip_supply_type%type index by binary_integer;
2585: type t_date_required is table of WIP_REQUIREMENT_OPERATIONS.date_required%type index by binary_integer;
2586: type t_basis_type is table of WIP_REQUIREMENT_OPERATIONS.basis_type%type index by binary_integer; --LBM enh
2587: type t_component_yield_factor is table of WIP_REQUIREMENT_OPERATIONS.component_yield_factor%type index by binary_integer; --LBM enh
2588: type t_required_quantity is table of WIP_REQUIREMENT_OPERATIONS.required_quantity%type index by binary_integer;
2589: type t_quantity_per_assembly is table of WIP_REQUIREMENT_OPERATIONS.quantity_per_assembly%type index by binary_integer;
2590: type t_supply_subinventory is table of WIP_REQUIREMENT_OPERATIONS.supply_subinventory%type index by binary_integer;

Line 2587: type t_component_yield_factor is table of WIP_REQUIREMENT_OPERATIONS.component_yield_factor%type index by binary_integer; --LBM enh

2583: type t_component_sequence_id is table of WIP_REQUIREMENT_OPERATIONS.component_sequence_id%type index by binary_integer;
2584: type t_wip_supply_type is table of WIP_REQUIREMENT_OPERATIONS.wip_supply_type%type index by binary_integer;
2585: type t_date_required is table of WIP_REQUIREMENT_OPERATIONS.date_required%type index by binary_integer;
2586: type t_basis_type is table of WIP_REQUIREMENT_OPERATIONS.basis_type%type index by binary_integer; --LBM enh
2587: type t_component_yield_factor is table of WIP_REQUIREMENT_OPERATIONS.component_yield_factor%type index by binary_integer; --LBM enh
2588: type t_required_quantity is table of WIP_REQUIREMENT_OPERATIONS.required_quantity%type index by binary_integer;
2589: type t_quantity_per_assembly is table of WIP_REQUIREMENT_OPERATIONS.quantity_per_assembly%type index by binary_integer;
2590: type t_supply_subinventory is table of WIP_REQUIREMENT_OPERATIONS.supply_subinventory%type index by binary_integer;
2591: type t_supply_locator_id is table of WIP_REQUIREMENT_OPERATIONS.supply_locator_id%type index by binary_integer;

Line 2588: type t_required_quantity is table of WIP_REQUIREMENT_OPERATIONS.required_quantity%type index by binary_integer;

2584: type t_wip_supply_type is table of WIP_REQUIREMENT_OPERATIONS.wip_supply_type%type index by binary_integer;
2585: type t_date_required is table of WIP_REQUIREMENT_OPERATIONS.date_required%type index by binary_integer;
2586: type t_basis_type is table of WIP_REQUIREMENT_OPERATIONS.basis_type%type index by binary_integer; --LBM enh
2587: type t_component_yield_factor is table of WIP_REQUIREMENT_OPERATIONS.component_yield_factor%type index by binary_integer; --LBM enh
2588: type t_required_quantity is table of WIP_REQUIREMENT_OPERATIONS.required_quantity%type index by binary_integer;
2589: type t_quantity_per_assembly is table of WIP_REQUIREMENT_OPERATIONS.quantity_per_assembly%type index by binary_integer;
2590: type t_supply_subinventory is table of WIP_REQUIREMENT_OPERATIONS.supply_subinventory%type index by binary_integer;
2591: type t_supply_locator_id is table of WIP_REQUIREMENT_OPERATIONS.supply_locator_id%type index by binary_integer;
2592: type t_mrp_net_flag is table of WIP_REQUIREMENT_OPERATIONS.mrp_net_flag%type index by binary_integer;

Line 2589: type t_quantity_per_assembly is table of WIP_REQUIREMENT_OPERATIONS.quantity_per_assembly%type index by binary_integer;

2585: type t_date_required is table of WIP_REQUIREMENT_OPERATIONS.date_required%type index by binary_integer;
2586: type t_basis_type is table of WIP_REQUIREMENT_OPERATIONS.basis_type%type index by binary_integer; --LBM enh
2587: type t_component_yield_factor is table of WIP_REQUIREMENT_OPERATIONS.component_yield_factor%type index by binary_integer; --LBM enh
2588: type t_required_quantity is table of WIP_REQUIREMENT_OPERATIONS.required_quantity%type index by binary_integer;
2589: type t_quantity_per_assembly is table of WIP_REQUIREMENT_OPERATIONS.quantity_per_assembly%type index by binary_integer;
2590: type t_supply_subinventory is table of WIP_REQUIREMENT_OPERATIONS.supply_subinventory%type index by binary_integer;
2591: type t_supply_locator_id is table of WIP_REQUIREMENT_OPERATIONS.supply_locator_id%type index by binary_integer;
2592: type t_mrp_net_flag is table of WIP_REQUIREMENT_OPERATIONS.mrp_net_flag%type index by binary_integer;
2593: type t_comments is table of WIP_REQUIREMENT_OPERATIONS.comments%type index by binary_integer;

Line 2590: type t_supply_subinventory is table of WIP_REQUIREMENT_OPERATIONS.supply_subinventory%type index by binary_integer;

2586: type t_basis_type is table of WIP_REQUIREMENT_OPERATIONS.basis_type%type index by binary_integer; --LBM enh
2587: type t_component_yield_factor is table of WIP_REQUIREMENT_OPERATIONS.component_yield_factor%type index by binary_integer; --LBM enh
2588: type t_required_quantity is table of WIP_REQUIREMENT_OPERATIONS.required_quantity%type index by binary_integer;
2589: type t_quantity_per_assembly is table of WIP_REQUIREMENT_OPERATIONS.quantity_per_assembly%type index by binary_integer;
2590: type t_supply_subinventory is table of WIP_REQUIREMENT_OPERATIONS.supply_subinventory%type index by binary_integer;
2591: type t_supply_locator_id is table of WIP_REQUIREMENT_OPERATIONS.supply_locator_id%type index by binary_integer;
2592: type t_mrp_net_flag is table of WIP_REQUIREMENT_OPERATIONS.mrp_net_flag%type index by binary_integer;
2593: type t_comments is table of WIP_REQUIREMENT_OPERATIONS.comments%type index by binary_integer;
2594: type t_attribute_category is table of WIP_REQUIREMENT_OPERATIONS.attribute_category%type index by binary_integer;

Line 2591: type t_supply_locator_id is table of WIP_REQUIREMENT_OPERATIONS.supply_locator_id%type index by binary_integer;

2587: type t_component_yield_factor is table of WIP_REQUIREMENT_OPERATIONS.component_yield_factor%type index by binary_integer; --LBM enh
2588: type t_required_quantity is table of WIP_REQUIREMENT_OPERATIONS.required_quantity%type index by binary_integer;
2589: type t_quantity_per_assembly is table of WIP_REQUIREMENT_OPERATIONS.quantity_per_assembly%type index by binary_integer;
2590: type t_supply_subinventory is table of WIP_REQUIREMENT_OPERATIONS.supply_subinventory%type index by binary_integer;
2591: type t_supply_locator_id is table of WIP_REQUIREMENT_OPERATIONS.supply_locator_id%type index by binary_integer;
2592: type t_mrp_net_flag is table of WIP_REQUIREMENT_OPERATIONS.mrp_net_flag%type index by binary_integer;
2593: type t_comments is table of WIP_REQUIREMENT_OPERATIONS.comments%type index by binary_integer;
2594: type t_attribute_category is table of WIP_REQUIREMENT_OPERATIONS.attribute_category%type index by binary_integer;
2595: type t_attribute1 is table of WIP_REQUIREMENT_OPERATIONS.attribute1%type index by binary_integer;

Line 2592: type t_mrp_net_flag is table of WIP_REQUIREMENT_OPERATIONS.mrp_net_flag%type index by binary_integer;

2588: type t_required_quantity is table of WIP_REQUIREMENT_OPERATIONS.required_quantity%type index by binary_integer;
2589: type t_quantity_per_assembly is table of WIP_REQUIREMENT_OPERATIONS.quantity_per_assembly%type index by binary_integer;
2590: type t_supply_subinventory is table of WIP_REQUIREMENT_OPERATIONS.supply_subinventory%type index by binary_integer;
2591: type t_supply_locator_id is table of WIP_REQUIREMENT_OPERATIONS.supply_locator_id%type index by binary_integer;
2592: type t_mrp_net_flag is table of WIP_REQUIREMENT_OPERATIONS.mrp_net_flag%type index by binary_integer;
2593: type t_comments is table of WIP_REQUIREMENT_OPERATIONS.comments%type index by binary_integer;
2594: type t_attribute_category is table of WIP_REQUIREMENT_OPERATIONS.attribute_category%type index by binary_integer;
2595: type t_attribute1 is table of WIP_REQUIREMENT_OPERATIONS.attribute1%type index by binary_integer;
2596: type t_attribute2 is table of WIP_REQUIREMENT_OPERATIONS.attribute2%type index by binary_integer;

Line 2593: type t_comments is table of WIP_REQUIREMENT_OPERATIONS.comments%type index by binary_integer;

2589: type t_quantity_per_assembly is table of WIP_REQUIREMENT_OPERATIONS.quantity_per_assembly%type index by binary_integer;
2590: type t_supply_subinventory is table of WIP_REQUIREMENT_OPERATIONS.supply_subinventory%type index by binary_integer;
2591: type t_supply_locator_id is table of WIP_REQUIREMENT_OPERATIONS.supply_locator_id%type index by binary_integer;
2592: type t_mrp_net_flag is table of WIP_REQUIREMENT_OPERATIONS.mrp_net_flag%type index by binary_integer;
2593: type t_comments is table of WIP_REQUIREMENT_OPERATIONS.comments%type index by binary_integer;
2594: type t_attribute_category is table of WIP_REQUIREMENT_OPERATIONS.attribute_category%type index by binary_integer;
2595: type t_attribute1 is table of WIP_REQUIREMENT_OPERATIONS.attribute1%type index by binary_integer;
2596: type t_attribute2 is table of WIP_REQUIREMENT_OPERATIONS.attribute2%type index by binary_integer;
2597: type t_attribute3 is table of WIP_REQUIREMENT_OPERATIONS.attribute3%type index by binary_integer;

Line 2594: type t_attribute_category is table of WIP_REQUIREMENT_OPERATIONS.attribute_category%type index by binary_integer;

2590: type t_supply_subinventory is table of WIP_REQUIREMENT_OPERATIONS.supply_subinventory%type index by binary_integer;
2591: type t_supply_locator_id is table of WIP_REQUIREMENT_OPERATIONS.supply_locator_id%type index by binary_integer;
2592: type t_mrp_net_flag is table of WIP_REQUIREMENT_OPERATIONS.mrp_net_flag%type index by binary_integer;
2593: type t_comments is table of WIP_REQUIREMENT_OPERATIONS.comments%type index by binary_integer;
2594: type t_attribute_category is table of WIP_REQUIREMENT_OPERATIONS.attribute_category%type index by binary_integer;
2595: type t_attribute1 is table of WIP_REQUIREMENT_OPERATIONS.attribute1%type index by binary_integer;
2596: type t_attribute2 is table of WIP_REQUIREMENT_OPERATIONS.attribute2%type index by binary_integer;
2597: type t_attribute3 is table of WIP_REQUIREMENT_OPERATIONS.attribute3%type index by binary_integer;
2598: type t_attribute4 is table of WIP_REQUIREMENT_OPERATIONS.attribute4%type index by binary_integer;

Line 2595: type t_attribute1 is table of WIP_REQUIREMENT_OPERATIONS.attribute1%type index by binary_integer;

2591: type t_supply_locator_id is table of WIP_REQUIREMENT_OPERATIONS.supply_locator_id%type index by binary_integer;
2592: type t_mrp_net_flag is table of WIP_REQUIREMENT_OPERATIONS.mrp_net_flag%type index by binary_integer;
2593: type t_comments is table of WIP_REQUIREMENT_OPERATIONS.comments%type index by binary_integer;
2594: type t_attribute_category is table of WIP_REQUIREMENT_OPERATIONS.attribute_category%type index by binary_integer;
2595: type t_attribute1 is table of WIP_REQUIREMENT_OPERATIONS.attribute1%type index by binary_integer;
2596: type t_attribute2 is table of WIP_REQUIREMENT_OPERATIONS.attribute2%type index by binary_integer;
2597: type t_attribute3 is table of WIP_REQUIREMENT_OPERATIONS.attribute3%type index by binary_integer;
2598: type t_attribute4 is table of WIP_REQUIREMENT_OPERATIONS.attribute4%type index by binary_integer;
2599: type t_attribute5 is table of WIP_REQUIREMENT_OPERATIONS.attribute5%type index by binary_integer;

Line 2596: type t_attribute2 is table of WIP_REQUIREMENT_OPERATIONS.attribute2%type index by binary_integer;

2592: type t_mrp_net_flag is table of WIP_REQUIREMENT_OPERATIONS.mrp_net_flag%type index by binary_integer;
2593: type t_comments is table of WIP_REQUIREMENT_OPERATIONS.comments%type index by binary_integer;
2594: type t_attribute_category is table of WIP_REQUIREMENT_OPERATIONS.attribute_category%type index by binary_integer;
2595: type t_attribute1 is table of WIP_REQUIREMENT_OPERATIONS.attribute1%type index by binary_integer;
2596: type t_attribute2 is table of WIP_REQUIREMENT_OPERATIONS.attribute2%type index by binary_integer;
2597: type t_attribute3 is table of WIP_REQUIREMENT_OPERATIONS.attribute3%type index by binary_integer;
2598: type t_attribute4 is table of WIP_REQUIREMENT_OPERATIONS.attribute4%type index by binary_integer;
2599: type t_attribute5 is table of WIP_REQUIREMENT_OPERATIONS.attribute5%type index by binary_integer;
2600: type t_attribute6 is table of WIP_REQUIREMENT_OPERATIONS.attribute6%type index by binary_integer;

Line 2597: type t_attribute3 is table of WIP_REQUIREMENT_OPERATIONS.attribute3%type index by binary_integer;

2593: type t_comments is table of WIP_REQUIREMENT_OPERATIONS.comments%type index by binary_integer;
2594: type t_attribute_category is table of WIP_REQUIREMENT_OPERATIONS.attribute_category%type index by binary_integer;
2595: type t_attribute1 is table of WIP_REQUIREMENT_OPERATIONS.attribute1%type index by binary_integer;
2596: type t_attribute2 is table of WIP_REQUIREMENT_OPERATIONS.attribute2%type index by binary_integer;
2597: type t_attribute3 is table of WIP_REQUIREMENT_OPERATIONS.attribute3%type index by binary_integer;
2598: type t_attribute4 is table of WIP_REQUIREMENT_OPERATIONS.attribute4%type index by binary_integer;
2599: type t_attribute5 is table of WIP_REQUIREMENT_OPERATIONS.attribute5%type index by binary_integer;
2600: type t_attribute6 is table of WIP_REQUIREMENT_OPERATIONS.attribute6%type index by binary_integer;
2601: type t_attribute7 is table of WIP_REQUIREMENT_OPERATIONS.attribute7%type index by binary_integer;

Line 2598: type t_attribute4 is table of WIP_REQUIREMENT_OPERATIONS.attribute4%type index by binary_integer;

2594: type t_attribute_category is table of WIP_REQUIREMENT_OPERATIONS.attribute_category%type index by binary_integer;
2595: type t_attribute1 is table of WIP_REQUIREMENT_OPERATIONS.attribute1%type index by binary_integer;
2596: type t_attribute2 is table of WIP_REQUIREMENT_OPERATIONS.attribute2%type index by binary_integer;
2597: type t_attribute3 is table of WIP_REQUIREMENT_OPERATIONS.attribute3%type index by binary_integer;
2598: type t_attribute4 is table of WIP_REQUIREMENT_OPERATIONS.attribute4%type index by binary_integer;
2599: type t_attribute5 is table of WIP_REQUIREMENT_OPERATIONS.attribute5%type index by binary_integer;
2600: type t_attribute6 is table of WIP_REQUIREMENT_OPERATIONS.attribute6%type index by binary_integer;
2601: type t_attribute7 is table of WIP_REQUIREMENT_OPERATIONS.attribute7%type index by binary_integer;
2602: type t_attribute8 is table of WIP_REQUIREMENT_OPERATIONS.attribute8%type index by binary_integer;

Line 2599: type t_attribute5 is table of WIP_REQUIREMENT_OPERATIONS.attribute5%type index by binary_integer;

2595: type t_attribute1 is table of WIP_REQUIREMENT_OPERATIONS.attribute1%type index by binary_integer;
2596: type t_attribute2 is table of WIP_REQUIREMENT_OPERATIONS.attribute2%type index by binary_integer;
2597: type t_attribute3 is table of WIP_REQUIREMENT_OPERATIONS.attribute3%type index by binary_integer;
2598: type t_attribute4 is table of WIP_REQUIREMENT_OPERATIONS.attribute4%type index by binary_integer;
2599: type t_attribute5 is table of WIP_REQUIREMENT_OPERATIONS.attribute5%type index by binary_integer;
2600: type t_attribute6 is table of WIP_REQUIREMENT_OPERATIONS.attribute6%type index by binary_integer;
2601: type t_attribute7 is table of WIP_REQUIREMENT_OPERATIONS.attribute7%type index by binary_integer;
2602: type t_attribute8 is table of WIP_REQUIREMENT_OPERATIONS.attribute8%type index by binary_integer;
2603: type t_attribute9 is table of WIP_REQUIREMENT_OPERATIONS.attribute9%type index by binary_integer;

Line 2600: type t_attribute6 is table of WIP_REQUIREMENT_OPERATIONS.attribute6%type index by binary_integer;

2596: type t_attribute2 is table of WIP_REQUIREMENT_OPERATIONS.attribute2%type index by binary_integer;
2597: type t_attribute3 is table of WIP_REQUIREMENT_OPERATIONS.attribute3%type index by binary_integer;
2598: type t_attribute4 is table of WIP_REQUIREMENT_OPERATIONS.attribute4%type index by binary_integer;
2599: type t_attribute5 is table of WIP_REQUIREMENT_OPERATIONS.attribute5%type index by binary_integer;
2600: type t_attribute6 is table of WIP_REQUIREMENT_OPERATIONS.attribute6%type index by binary_integer;
2601: type t_attribute7 is table of WIP_REQUIREMENT_OPERATIONS.attribute7%type index by binary_integer;
2602: type t_attribute8 is table of WIP_REQUIREMENT_OPERATIONS.attribute8%type index by binary_integer;
2603: type t_attribute9 is table of WIP_REQUIREMENT_OPERATIONS.attribute9%type index by binary_integer;
2604: type t_attribute10 is table of WIP_REQUIREMENT_OPERATIONS.attribute10%type index by binary_integer;

Line 2601: type t_attribute7 is table of WIP_REQUIREMENT_OPERATIONS.attribute7%type index by binary_integer;

2597: type t_attribute3 is table of WIP_REQUIREMENT_OPERATIONS.attribute3%type index by binary_integer;
2598: type t_attribute4 is table of WIP_REQUIREMENT_OPERATIONS.attribute4%type index by binary_integer;
2599: type t_attribute5 is table of WIP_REQUIREMENT_OPERATIONS.attribute5%type index by binary_integer;
2600: type t_attribute6 is table of WIP_REQUIREMENT_OPERATIONS.attribute6%type index by binary_integer;
2601: type t_attribute7 is table of WIP_REQUIREMENT_OPERATIONS.attribute7%type index by binary_integer;
2602: type t_attribute8 is table of WIP_REQUIREMENT_OPERATIONS.attribute8%type index by binary_integer;
2603: type t_attribute9 is table of WIP_REQUIREMENT_OPERATIONS.attribute9%type index by binary_integer;
2604: type t_attribute10 is table of WIP_REQUIREMENT_OPERATIONS.attribute10%type index by binary_integer;
2605: type t_attribute11 is table of WIP_REQUIREMENT_OPERATIONS.attribute11%type index by binary_integer;

Line 2602: type t_attribute8 is table of WIP_REQUIREMENT_OPERATIONS.attribute8%type index by binary_integer;

2598: type t_attribute4 is table of WIP_REQUIREMENT_OPERATIONS.attribute4%type index by binary_integer;
2599: type t_attribute5 is table of WIP_REQUIREMENT_OPERATIONS.attribute5%type index by binary_integer;
2600: type t_attribute6 is table of WIP_REQUIREMENT_OPERATIONS.attribute6%type index by binary_integer;
2601: type t_attribute7 is table of WIP_REQUIREMENT_OPERATIONS.attribute7%type index by binary_integer;
2602: type t_attribute8 is table of WIP_REQUIREMENT_OPERATIONS.attribute8%type index by binary_integer;
2603: type t_attribute9 is table of WIP_REQUIREMENT_OPERATIONS.attribute9%type index by binary_integer;
2604: type t_attribute10 is table of WIP_REQUIREMENT_OPERATIONS.attribute10%type index by binary_integer;
2605: type t_attribute11 is table of WIP_REQUIREMENT_OPERATIONS.attribute11%type index by binary_integer;
2606: type t_attribute12 is table of WIP_REQUIREMENT_OPERATIONS.attribute12%type index by binary_integer;

Line 2603: type t_attribute9 is table of WIP_REQUIREMENT_OPERATIONS.attribute9%type index by binary_integer;

2599: type t_attribute5 is table of WIP_REQUIREMENT_OPERATIONS.attribute5%type index by binary_integer;
2600: type t_attribute6 is table of WIP_REQUIREMENT_OPERATIONS.attribute6%type index by binary_integer;
2601: type t_attribute7 is table of WIP_REQUIREMENT_OPERATIONS.attribute7%type index by binary_integer;
2602: type t_attribute8 is table of WIP_REQUIREMENT_OPERATIONS.attribute8%type index by binary_integer;
2603: type t_attribute9 is table of WIP_REQUIREMENT_OPERATIONS.attribute9%type index by binary_integer;
2604: type t_attribute10 is table of WIP_REQUIREMENT_OPERATIONS.attribute10%type index by binary_integer;
2605: type t_attribute11 is table of WIP_REQUIREMENT_OPERATIONS.attribute11%type index by binary_integer;
2606: type t_attribute12 is table of WIP_REQUIREMENT_OPERATIONS.attribute12%type index by binary_integer;
2607: type t_attribute13 is table of WIP_REQUIREMENT_OPERATIONS.attribute13%type index by binary_integer;

Line 2604: type t_attribute10 is table of WIP_REQUIREMENT_OPERATIONS.attribute10%type index by binary_integer;

2600: type t_attribute6 is table of WIP_REQUIREMENT_OPERATIONS.attribute6%type index by binary_integer;
2601: type t_attribute7 is table of WIP_REQUIREMENT_OPERATIONS.attribute7%type index by binary_integer;
2602: type t_attribute8 is table of WIP_REQUIREMENT_OPERATIONS.attribute8%type index by binary_integer;
2603: type t_attribute9 is table of WIP_REQUIREMENT_OPERATIONS.attribute9%type index by binary_integer;
2604: type t_attribute10 is table of WIP_REQUIREMENT_OPERATIONS.attribute10%type index by binary_integer;
2605: type t_attribute11 is table of WIP_REQUIREMENT_OPERATIONS.attribute11%type index by binary_integer;
2606: type t_attribute12 is table of WIP_REQUIREMENT_OPERATIONS.attribute12%type index by binary_integer;
2607: type t_attribute13 is table of WIP_REQUIREMENT_OPERATIONS.attribute13%type index by binary_integer;
2608: type t_attribute14 is table of WIP_REQUIREMENT_OPERATIONS.attribute14%type index by binary_integer;

Line 2605: type t_attribute11 is table of WIP_REQUIREMENT_OPERATIONS.attribute11%type index by binary_integer;

2601: type t_attribute7 is table of WIP_REQUIREMENT_OPERATIONS.attribute7%type index by binary_integer;
2602: type t_attribute8 is table of WIP_REQUIREMENT_OPERATIONS.attribute8%type index by binary_integer;
2603: type t_attribute9 is table of WIP_REQUIREMENT_OPERATIONS.attribute9%type index by binary_integer;
2604: type t_attribute10 is table of WIP_REQUIREMENT_OPERATIONS.attribute10%type index by binary_integer;
2605: type t_attribute11 is table of WIP_REQUIREMENT_OPERATIONS.attribute11%type index by binary_integer;
2606: type t_attribute12 is table of WIP_REQUIREMENT_OPERATIONS.attribute12%type index by binary_integer;
2607: type t_attribute13 is table of WIP_REQUIREMENT_OPERATIONS.attribute13%type index by binary_integer;
2608: type t_attribute14 is table of WIP_REQUIREMENT_OPERATIONS.attribute14%type index by binary_integer;
2609: type t_attribute15 is table of WIP_REQUIREMENT_OPERATIONS.attribute15%type index by binary_integer;

Line 2606: type t_attribute12 is table of WIP_REQUIREMENT_OPERATIONS.attribute12%type index by binary_integer;

2602: type t_attribute8 is table of WIP_REQUIREMENT_OPERATIONS.attribute8%type index by binary_integer;
2603: type t_attribute9 is table of WIP_REQUIREMENT_OPERATIONS.attribute9%type index by binary_integer;
2604: type t_attribute10 is table of WIP_REQUIREMENT_OPERATIONS.attribute10%type index by binary_integer;
2605: type t_attribute11 is table of WIP_REQUIREMENT_OPERATIONS.attribute11%type index by binary_integer;
2606: type t_attribute12 is table of WIP_REQUIREMENT_OPERATIONS.attribute12%type index by binary_integer;
2607: type t_attribute13 is table of WIP_REQUIREMENT_OPERATIONS.attribute13%type index by binary_integer;
2608: type t_attribute14 is table of WIP_REQUIREMENT_OPERATIONS.attribute14%type index by binary_integer;
2609: type t_attribute15 is table of WIP_REQUIREMENT_OPERATIONS.attribute15%type index by binary_integer;
2610: type t_segment1 is table of WIP_REQUIREMENT_OPERATIONS.segment1%type index by binary_integer;

Line 2607: type t_attribute13 is table of WIP_REQUIREMENT_OPERATIONS.attribute13%type index by binary_integer;

2603: type t_attribute9 is table of WIP_REQUIREMENT_OPERATIONS.attribute9%type index by binary_integer;
2604: type t_attribute10 is table of WIP_REQUIREMENT_OPERATIONS.attribute10%type index by binary_integer;
2605: type t_attribute11 is table of WIP_REQUIREMENT_OPERATIONS.attribute11%type index by binary_integer;
2606: type t_attribute12 is table of WIP_REQUIREMENT_OPERATIONS.attribute12%type index by binary_integer;
2607: type t_attribute13 is table of WIP_REQUIREMENT_OPERATIONS.attribute13%type index by binary_integer;
2608: type t_attribute14 is table of WIP_REQUIREMENT_OPERATIONS.attribute14%type index by binary_integer;
2609: type t_attribute15 is table of WIP_REQUIREMENT_OPERATIONS.attribute15%type index by binary_integer;
2610: type t_segment1 is table of WIP_REQUIREMENT_OPERATIONS.segment1%type index by binary_integer;
2611: type t_segment2 is table of WIP_REQUIREMENT_OPERATIONS.segment2%type index by binary_integer;

Line 2608: type t_attribute14 is table of WIP_REQUIREMENT_OPERATIONS.attribute14%type index by binary_integer;

2604: type t_attribute10 is table of WIP_REQUIREMENT_OPERATIONS.attribute10%type index by binary_integer;
2605: type t_attribute11 is table of WIP_REQUIREMENT_OPERATIONS.attribute11%type index by binary_integer;
2606: type t_attribute12 is table of WIP_REQUIREMENT_OPERATIONS.attribute12%type index by binary_integer;
2607: type t_attribute13 is table of WIP_REQUIREMENT_OPERATIONS.attribute13%type index by binary_integer;
2608: type t_attribute14 is table of WIP_REQUIREMENT_OPERATIONS.attribute14%type index by binary_integer;
2609: type t_attribute15 is table of WIP_REQUIREMENT_OPERATIONS.attribute15%type index by binary_integer;
2610: type t_segment1 is table of WIP_REQUIREMENT_OPERATIONS.segment1%type index by binary_integer;
2611: type t_segment2 is table of WIP_REQUIREMENT_OPERATIONS.segment2%type index by binary_integer;
2612: type t_segment3 is table of WIP_REQUIREMENT_OPERATIONS.segment3%type index by binary_integer;

Line 2609: type t_attribute15 is table of WIP_REQUIREMENT_OPERATIONS.attribute15%type index by binary_integer;

2605: type t_attribute11 is table of WIP_REQUIREMENT_OPERATIONS.attribute11%type index by binary_integer;
2606: type t_attribute12 is table of WIP_REQUIREMENT_OPERATIONS.attribute12%type index by binary_integer;
2607: type t_attribute13 is table of WIP_REQUIREMENT_OPERATIONS.attribute13%type index by binary_integer;
2608: type t_attribute14 is table of WIP_REQUIREMENT_OPERATIONS.attribute14%type index by binary_integer;
2609: type t_attribute15 is table of WIP_REQUIREMENT_OPERATIONS.attribute15%type index by binary_integer;
2610: type t_segment1 is table of WIP_REQUIREMENT_OPERATIONS.segment1%type index by binary_integer;
2611: type t_segment2 is table of WIP_REQUIREMENT_OPERATIONS.segment2%type index by binary_integer;
2612: type t_segment3 is table of WIP_REQUIREMENT_OPERATIONS.segment3%type index by binary_integer;
2613: type t_segment4 is table of WIP_REQUIREMENT_OPERATIONS.segment4%type index by binary_integer;

Line 2610: type t_segment1 is table of WIP_REQUIREMENT_OPERATIONS.segment1%type index by binary_integer;

2606: type t_attribute12 is table of WIP_REQUIREMENT_OPERATIONS.attribute12%type index by binary_integer;
2607: type t_attribute13 is table of WIP_REQUIREMENT_OPERATIONS.attribute13%type index by binary_integer;
2608: type t_attribute14 is table of WIP_REQUIREMENT_OPERATIONS.attribute14%type index by binary_integer;
2609: type t_attribute15 is table of WIP_REQUIREMENT_OPERATIONS.attribute15%type index by binary_integer;
2610: type t_segment1 is table of WIP_REQUIREMENT_OPERATIONS.segment1%type index by binary_integer;
2611: type t_segment2 is table of WIP_REQUIREMENT_OPERATIONS.segment2%type index by binary_integer;
2612: type t_segment3 is table of WIP_REQUIREMENT_OPERATIONS.segment3%type index by binary_integer;
2613: type t_segment4 is table of WIP_REQUIREMENT_OPERATIONS.segment4%type index by binary_integer;
2614: type t_segment5 is table of WIP_REQUIREMENT_OPERATIONS.segment5%type index by binary_integer;

Line 2611: type t_segment2 is table of WIP_REQUIREMENT_OPERATIONS.segment2%type index by binary_integer;

2607: type t_attribute13 is table of WIP_REQUIREMENT_OPERATIONS.attribute13%type index by binary_integer;
2608: type t_attribute14 is table of WIP_REQUIREMENT_OPERATIONS.attribute14%type index by binary_integer;
2609: type t_attribute15 is table of WIP_REQUIREMENT_OPERATIONS.attribute15%type index by binary_integer;
2610: type t_segment1 is table of WIP_REQUIREMENT_OPERATIONS.segment1%type index by binary_integer;
2611: type t_segment2 is table of WIP_REQUIREMENT_OPERATIONS.segment2%type index by binary_integer;
2612: type t_segment3 is table of WIP_REQUIREMENT_OPERATIONS.segment3%type index by binary_integer;
2613: type t_segment4 is table of WIP_REQUIREMENT_OPERATIONS.segment4%type index by binary_integer;
2614: type t_segment5 is table of WIP_REQUIREMENT_OPERATIONS.segment5%type index by binary_integer;
2615: type t_segment6 is table of WIP_REQUIREMENT_OPERATIONS.segment6%type index by binary_integer;

Line 2612: type t_segment3 is table of WIP_REQUIREMENT_OPERATIONS.segment3%type index by binary_integer;

2608: type t_attribute14 is table of WIP_REQUIREMENT_OPERATIONS.attribute14%type index by binary_integer;
2609: type t_attribute15 is table of WIP_REQUIREMENT_OPERATIONS.attribute15%type index by binary_integer;
2610: type t_segment1 is table of WIP_REQUIREMENT_OPERATIONS.segment1%type index by binary_integer;
2611: type t_segment2 is table of WIP_REQUIREMENT_OPERATIONS.segment2%type index by binary_integer;
2612: type t_segment3 is table of WIP_REQUIREMENT_OPERATIONS.segment3%type index by binary_integer;
2613: type t_segment4 is table of WIP_REQUIREMENT_OPERATIONS.segment4%type index by binary_integer;
2614: type t_segment5 is table of WIP_REQUIREMENT_OPERATIONS.segment5%type index by binary_integer;
2615: type t_segment6 is table of WIP_REQUIREMENT_OPERATIONS.segment6%type index by binary_integer;
2616: type t_segment7 is table of WIP_REQUIREMENT_OPERATIONS.segment7%type index by binary_integer;

Line 2613: type t_segment4 is table of WIP_REQUIREMENT_OPERATIONS.segment4%type index by binary_integer;

2609: type t_attribute15 is table of WIP_REQUIREMENT_OPERATIONS.attribute15%type index by binary_integer;
2610: type t_segment1 is table of WIP_REQUIREMENT_OPERATIONS.segment1%type index by binary_integer;
2611: type t_segment2 is table of WIP_REQUIREMENT_OPERATIONS.segment2%type index by binary_integer;
2612: type t_segment3 is table of WIP_REQUIREMENT_OPERATIONS.segment3%type index by binary_integer;
2613: type t_segment4 is table of WIP_REQUIREMENT_OPERATIONS.segment4%type index by binary_integer;
2614: type t_segment5 is table of WIP_REQUIREMENT_OPERATIONS.segment5%type index by binary_integer;
2615: type t_segment6 is table of WIP_REQUIREMENT_OPERATIONS.segment6%type index by binary_integer;
2616: type t_segment7 is table of WIP_REQUIREMENT_OPERATIONS.segment7%type index by binary_integer;
2617: type t_segment8 is table of WIP_REQUIREMENT_OPERATIONS.segment8%type index by binary_integer;

Line 2614: type t_segment5 is table of WIP_REQUIREMENT_OPERATIONS.segment5%type index by binary_integer;

2610: type t_segment1 is table of WIP_REQUIREMENT_OPERATIONS.segment1%type index by binary_integer;
2611: type t_segment2 is table of WIP_REQUIREMENT_OPERATIONS.segment2%type index by binary_integer;
2612: type t_segment3 is table of WIP_REQUIREMENT_OPERATIONS.segment3%type index by binary_integer;
2613: type t_segment4 is table of WIP_REQUIREMENT_OPERATIONS.segment4%type index by binary_integer;
2614: type t_segment5 is table of WIP_REQUIREMENT_OPERATIONS.segment5%type index by binary_integer;
2615: type t_segment6 is table of WIP_REQUIREMENT_OPERATIONS.segment6%type index by binary_integer;
2616: type t_segment7 is table of WIP_REQUIREMENT_OPERATIONS.segment7%type index by binary_integer;
2617: type t_segment8 is table of WIP_REQUIREMENT_OPERATIONS.segment8%type index by binary_integer;
2618: type t_segment9 is table of WIP_REQUIREMENT_OPERATIONS.segment9%type index by binary_integer;

Line 2615: type t_segment6 is table of WIP_REQUIREMENT_OPERATIONS.segment6%type index by binary_integer;

2611: type t_segment2 is table of WIP_REQUIREMENT_OPERATIONS.segment2%type index by binary_integer;
2612: type t_segment3 is table of WIP_REQUIREMENT_OPERATIONS.segment3%type index by binary_integer;
2613: type t_segment4 is table of WIP_REQUIREMENT_OPERATIONS.segment4%type index by binary_integer;
2614: type t_segment5 is table of WIP_REQUIREMENT_OPERATIONS.segment5%type index by binary_integer;
2615: type t_segment6 is table of WIP_REQUIREMENT_OPERATIONS.segment6%type index by binary_integer;
2616: type t_segment7 is table of WIP_REQUIREMENT_OPERATIONS.segment7%type index by binary_integer;
2617: type t_segment8 is table of WIP_REQUIREMENT_OPERATIONS.segment8%type index by binary_integer;
2618: type t_segment9 is table of WIP_REQUIREMENT_OPERATIONS.segment9%type index by binary_integer;
2619: type t_segment10 is table of WIP_REQUIREMENT_OPERATIONS.segment10%type index by binary_integer;

Line 2616: type t_segment7 is table of WIP_REQUIREMENT_OPERATIONS.segment7%type index by binary_integer;

2612: type t_segment3 is table of WIP_REQUIREMENT_OPERATIONS.segment3%type index by binary_integer;
2613: type t_segment4 is table of WIP_REQUIREMENT_OPERATIONS.segment4%type index by binary_integer;
2614: type t_segment5 is table of WIP_REQUIREMENT_OPERATIONS.segment5%type index by binary_integer;
2615: type t_segment6 is table of WIP_REQUIREMENT_OPERATIONS.segment6%type index by binary_integer;
2616: type t_segment7 is table of WIP_REQUIREMENT_OPERATIONS.segment7%type index by binary_integer;
2617: type t_segment8 is table of WIP_REQUIREMENT_OPERATIONS.segment8%type index by binary_integer;
2618: type t_segment9 is table of WIP_REQUIREMENT_OPERATIONS.segment9%type index by binary_integer;
2619: type t_segment10 is table of WIP_REQUIREMENT_OPERATIONS.segment10%type index by binary_integer;
2620: type t_segment11 is table of WIP_REQUIREMENT_OPERATIONS.segment11%type index by binary_integer;

Line 2617: type t_segment8 is table of WIP_REQUIREMENT_OPERATIONS.segment8%type index by binary_integer;

2613: type t_segment4 is table of WIP_REQUIREMENT_OPERATIONS.segment4%type index by binary_integer;
2614: type t_segment5 is table of WIP_REQUIREMENT_OPERATIONS.segment5%type index by binary_integer;
2615: type t_segment6 is table of WIP_REQUIREMENT_OPERATIONS.segment6%type index by binary_integer;
2616: type t_segment7 is table of WIP_REQUIREMENT_OPERATIONS.segment7%type index by binary_integer;
2617: type t_segment8 is table of WIP_REQUIREMENT_OPERATIONS.segment8%type index by binary_integer;
2618: type t_segment9 is table of WIP_REQUIREMENT_OPERATIONS.segment9%type index by binary_integer;
2619: type t_segment10 is table of WIP_REQUIREMENT_OPERATIONS.segment10%type index by binary_integer;
2620: type t_segment11 is table of WIP_REQUIREMENT_OPERATIONS.segment11%type index by binary_integer;
2621: type t_segment12 is table of WIP_REQUIREMENT_OPERATIONS.segment12%type index by binary_integer;

Line 2618: type t_segment9 is table of WIP_REQUIREMENT_OPERATIONS.segment9%type index by binary_integer;

2614: type t_segment5 is table of WIP_REQUIREMENT_OPERATIONS.segment5%type index by binary_integer;
2615: type t_segment6 is table of WIP_REQUIREMENT_OPERATIONS.segment6%type index by binary_integer;
2616: type t_segment7 is table of WIP_REQUIREMENT_OPERATIONS.segment7%type index by binary_integer;
2617: type t_segment8 is table of WIP_REQUIREMENT_OPERATIONS.segment8%type index by binary_integer;
2618: type t_segment9 is table of WIP_REQUIREMENT_OPERATIONS.segment9%type index by binary_integer;
2619: type t_segment10 is table of WIP_REQUIREMENT_OPERATIONS.segment10%type index by binary_integer;
2620: type t_segment11 is table of WIP_REQUIREMENT_OPERATIONS.segment11%type index by binary_integer;
2621: type t_segment12 is table of WIP_REQUIREMENT_OPERATIONS.segment12%type index by binary_integer;
2622: type t_segment13 is table of WIP_REQUIREMENT_OPERATIONS.segment13%type index by binary_integer;

Line 2619: type t_segment10 is table of WIP_REQUIREMENT_OPERATIONS.segment10%type index by binary_integer;

2615: type t_segment6 is table of WIP_REQUIREMENT_OPERATIONS.segment6%type index by binary_integer;
2616: type t_segment7 is table of WIP_REQUIREMENT_OPERATIONS.segment7%type index by binary_integer;
2617: type t_segment8 is table of WIP_REQUIREMENT_OPERATIONS.segment8%type index by binary_integer;
2618: type t_segment9 is table of WIP_REQUIREMENT_OPERATIONS.segment9%type index by binary_integer;
2619: type t_segment10 is table of WIP_REQUIREMENT_OPERATIONS.segment10%type index by binary_integer;
2620: type t_segment11 is table of WIP_REQUIREMENT_OPERATIONS.segment11%type index by binary_integer;
2621: type t_segment12 is table of WIP_REQUIREMENT_OPERATIONS.segment12%type index by binary_integer;
2622: type t_segment13 is table of WIP_REQUIREMENT_OPERATIONS.segment13%type index by binary_integer;
2623: type t_segment14 is table of WIP_REQUIREMENT_OPERATIONS.segment14%type index by binary_integer;

Line 2620: type t_segment11 is table of WIP_REQUIREMENT_OPERATIONS.segment11%type index by binary_integer;

2616: type t_segment7 is table of WIP_REQUIREMENT_OPERATIONS.segment7%type index by binary_integer;
2617: type t_segment8 is table of WIP_REQUIREMENT_OPERATIONS.segment8%type index by binary_integer;
2618: type t_segment9 is table of WIP_REQUIREMENT_OPERATIONS.segment9%type index by binary_integer;
2619: type t_segment10 is table of WIP_REQUIREMENT_OPERATIONS.segment10%type index by binary_integer;
2620: type t_segment11 is table of WIP_REQUIREMENT_OPERATIONS.segment11%type index by binary_integer;
2621: type t_segment12 is table of WIP_REQUIREMENT_OPERATIONS.segment12%type index by binary_integer;
2622: type t_segment13 is table of WIP_REQUIREMENT_OPERATIONS.segment13%type index by binary_integer;
2623: type t_segment14 is table of WIP_REQUIREMENT_OPERATIONS.segment14%type index by binary_integer;
2624: type t_segment15 is table of WIP_REQUIREMENT_OPERATIONS.segment15%type index by binary_integer;

Line 2621: type t_segment12 is table of WIP_REQUIREMENT_OPERATIONS.segment12%type index by binary_integer;

2617: type t_segment8 is table of WIP_REQUIREMENT_OPERATIONS.segment8%type index by binary_integer;
2618: type t_segment9 is table of WIP_REQUIREMENT_OPERATIONS.segment9%type index by binary_integer;
2619: type t_segment10 is table of WIP_REQUIREMENT_OPERATIONS.segment10%type index by binary_integer;
2620: type t_segment11 is table of WIP_REQUIREMENT_OPERATIONS.segment11%type index by binary_integer;
2621: type t_segment12 is table of WIP_REQUIREMENT_OPERATIONS.segment12%type index by binary_integer;
2622: type t_segment13 is table of WIP_REQUIREMENT_OPERATIONS.segment13%type index by binary_integer;
2623: type t_segment14 is table of WIP_REQUIREMENT_OPERATIONS.segment14%type index by binary_integer;
2624: type t_segment15 is table of WIP_REQUIREMENT_OPERATIONS.segment15%type index by binary_integer;
2625: type t_segment16 is table of WIP_REQUIREMENT_OPERATIONS.segment16%type index by binary_integer;

Line 2622: type t_segment13 is table of WIP_REQUIREMENT_OPERATIONS.segment13%type index by binary_integer;

2618: type t_segment9 is table of WIP_REQUIREMENT_OPERATIONS.segment9%type index by binary_integer;
2619: type t_segment10 is table of WIP_REQUIREMENT_OPERATIONS.segment10%type index by binary_integer;
2620: type t_segment11 is table of WIP_REQUIREMENT_OPERATIONS.segment11%type index by binary_integer;
2621: type t_segment12 is table of WIP_REQUIREMENT_OPERATIONS.segment12%type index by binary_integer;
2622: type t_segment13 is table of WIP_REQUIREMENT_OPERATIONS.segment13%type index by binary_integer;
2623: type t_segment14 is table of WIP_REQUIREMENT_OPERATIONS.segment14%type index by binary_integer;
2624: type t_segment15 is table of WIP_REQUIREMENT_OPERATIONS.segment15%type index by binary_integer;
2625: type t_segment16 is table of WIP_REQUIREMENT_OPERATIONS.segment16%type index by binary_integer;
2626: type t_segment17 is table of WIP_REQUIREMENT_OPERATIONS.segment17%type index by binary_integer;

Line 2623: type t_segment14 is table of WIP_REQUIREMENT_OPERATIONS.segment14%type index by binary_integer;

2619: type t_segment10 is table of WIP_REQUIREMENT_OPERATIONS.segment10%type index by binary_integer;
2620: type t_segment11 is table of WIP_REQUIREMENT_OPERATIONS.segment11%type index by binary_integer;
2621: type t_segment12 is table of WIP_REQUIREMENT_OPERATIONS.segment12%type index by binary_integer;
2622: type t_segment13 is table of WIP_REQUIREMENT_OPERATIONS.segment13%type index by binary_integer;
2623: type t_segment14 is table of WIP_REQUIREMENT_OPERATIONS.segment14%type index by binary_integer;
2624: type t_segment15 is table of WIP_REQUIREMENT_OPERATIONS.segment15%type index by binary_integer;
2625: type t_segment16 is table of WIP_REQUIREMENT_OPERATIONS.segment16%type index by binary_integer;
2626: type t_segment17 is table of WIP_REQUIREMENT_OPERATIONS.segment17%type index by binary_integer;
2627: type t_segment18 is table of WIP_REQUIREMENT_OPERATIONS.segment18%type index by binary_integer;

Line 2624: type t_segment15 is table of WIP_REQUIREMENT_OPERATIONS.segment15%type index by binary_integer;

2620: type t_segment11 is table of WIP_REQUIREMENT_OPERATIONS.segment11%type index by binary_integer;
2621: type t_segment12 is table of WIP_REQUIREMENT_OPERATIONS.segment12%type index by binary_integer;
2622: type t_segment13 is table of WIP_REQUIREMENT_OPERATIONS.segment13%type index by binary_integer;
2623: type t_segment14 is table of WIP_REQUIREMENT_OPERATIONS.segment14%type index by binary_integer;
2624: type t_segment15 is table of WIP_REQUIREMENT_OPERATIONS.segment15%type index by binary_integer;
2625: type t_segment16 is table of WIP_REQUIREMENT_OPERATIONS.segment16%type index by binary_integer;
2626: type t_segment17 is table of WIP_REQUIREMENT_OPERATIONS.segment17%type index by binary_integer;
2627: type t_segment18 is table of WIP_REQUIREMENT_OPERATIONS.segment18%type index by binary_integer;
2628: type t_segment19 is table of WIP_REQUIREMENT_OPERATIONS.segment19%type index by binary_integer;

Line 2625: type t_segment16 is table of WIP_REQUIREMENT_OPERATIONS.segment16%type index by binary_integer;

2621: type t_segment12 is table of WIP_REQUIREMENT_OPERATIONS.segment12%type index by binary_integer;
2622: type t_segment13 is table of WIP_REQUIREMENT_OPERATIONS.segment13%type index by binary_integer;
2623: type t_segment14 is table of WIP_REQUIREMENT_OPERATIONS.segment14%type index by binary_integer;
2624: type t_segment15 is table of WIP_REQUIREMENT_OPERATIONS.segment15%type index by binary_integer;
2625: type t_segment16 is table of WIP_REQUIREMENT_OPERATIONS.segment16%type index by binary_integer;
2626: type t_segment17 is table of WIP_REQUIREMENT_OPERATIONS.segment17%type index by binary_integer;
2627: type t_segment18 is table of WIP_REQUIREMENT_OPERATIONS.segment18%type index by binary_integer;
2628: type t_segment19 is table of WIP_REQUIREMENT_OPERATIONS.segment19%type index by binary_integer;
2629: type t_segment20 is table of WIP_REQUIREMENT_OPERATIONS.segment20%type index by binary_integer;

Line 2626: type t_segment17 is table of WIP_REQUIREMENT_OPERATIONS.segment17%type index by binary_integer;

2622: type t_segment13 is table of WIP_REQUIREMENT_OPERATIONS.segment13%type index by binary_integer;
2623: type t_segment14 is table of WIP_REQUIREMENT_OPERATIONS.segment14%type index by binary_integer;
2624: type t_segment15 is table of WIP_REQUIREMENT_OPERATIONS.segment15%type index by binary_integer;
2625: type t_segment16 is table of WIP_REQUIREMENT_OPERATIONS.segment16%type index by binary_integer;
2626: type t_segment17 is table of WIP_REQUIREMENT_OPERATIONS.segment17%type index by binary_integer;
2627: type t_segment18 is table of WIP_REQUIREMENT_OPERATIONS.segment18%type index by binary_integer;
2628: type t_segment19 is table of WIP_REQUIREMENT_OPERATIONS.segment19%type index by binary_integer;
2629: type t_segment20 is table of WIP_REQUIREMENT_OPERATIONS.segment20%type index by binary_integer;
2630: type t_department_id is table of WIP_REQUIREMENT_OPERATIONS.department_id%type index by binary_integer;

Line 2627: type t_segment18 is table of WIP_REQUIREMENT_OPERATIONS.segment18%type index by binary_integer;

2623: type t_segment14 is table of WIP_REQUIREMENT_OPERATIONS.segment14%type index by binary_integer;
2624: type t_segment15 is table of WIP_REQUIREMENT_OPERATIONS.segment15%type index by binary_integer;
2625: type t_segment16 is table of WIP_REQUIREMENT_OPERATIONS.segment16%type index by binary_integer;
2626: type t_segment17 is table of WIP_REQUIREMENT_OPERATIONS.segment17%type index by binary_integer;
2627: type t_segment18 is table of WIP_REQUIREMENT_OPERATIONS.segment18%type index by binary_integer;
2628: type t_segment19 is table of WIP_REQUIREMENT_OPERATIONS.segment19%type index by binary_integer;
2629: type t_segment20 is table of WIP_REQUIREMENT_OPERATIONS.segment20%type index by binary_integer;
2630: type t_department_id is table of WIP_REQUIREMENT_OPERATIONS.department_id%type index by binary_integer;
2631:

Line 2628: type t_segment19 is table of WIP_REQUIREMENT_OPERATIONS.segment19%type index by binary_integer;

2624: type t_segment15 is table of WIP_REQUIREMENT_OPERATIONS.segment15%type index by binary_integer;
2625: type t_segment16 is table of WIP_REQUIREMENT_OPERATIONS.segment16%type index by binary_integer;
2626: type t_segment17 is table of WIP_REQUIREMENT_OPERATIONS.segment17%type index by binary_integer;
2627: type t_segment18 is table of WIP_REQUIREMENT_OPERATIONS.segment18%type index by binary_integer;
2628: type t_segment19 is table of WIP_REQUIREMENT_OPERATIONS.segment19%type index by binary_integer;
2629: type t_segment20 is table of WIP_REQUIREMENT_OPERATIONS.segment20%type index by binary_integer;
2630: type t_department_id is table of WIP_REQUIREMENT_OPERATIONS.department_id%type index by binary_integer;
2631:
2632: v_inventory_item_id t_inventory_item_id;

Line 2629: type t_segment20 is table of WIP_REQUIREMENT_OPERATIONS.segment20%type index by binary_integer;

2625: type t_segment16 is table of WIP_REQUIREMENT_OPERATIONS.segment16%type index by binary_integer;
2626: type t_segment17 is table of WIP_REQUIREMENT_OPERATIONS.segment17%type index by binary_integer;
2627: type t_segment18 is table of WIP_REQUIREMENT_OPERATIONS.segment18%type index by binary_integer;
2628: type t_segment19 is table of WIP_REQUIREMENT_OPERATIONS.segment19%type index by binary_integer;
2629: type t_segment20 is table of WIP_REQUIREMENT_OPERATIONS.segment20%type index by binary_integer;
2630: type t_department_id is table of WIP_REQUIREMENT_OPERATIONS.department_id%type index by binary_integer;
2631:
2632: v_inventory_item_id t_inventory_item_id;
2633: v_organization_id t_organization_id;

Line 2630: type t_department_id is table of WIP_REQUIREMENT_OPERATIONS.department_id%type index by binary_integer;

2626: type t_segment17 is table of WIP_REQUIREMENT_OPERATIONS.segment17%type index by binary_integer;
2627: type t_segment18 is table of WIP_REQUIREMENT_OPERATIONS.segment18%type index by binary_integer;
2628: type t_segment19 is table of WIP_REQUIREMENT_OPERATIONS.segment19%type index by binary_integer;
2629: type t_segment20 is table of WIP_REQUIREMENT_OPERATIONS.segment20%type index by binary_integer;
2630: type t_department_id is table of WIP_REQUIREMENT_OPERATIONS.department_id%type index by binary_integer;
2631:
2632: v_inventory_item_id t_inventory_item_id;
2633: v_organization_id t_organization_id;
2634: v_wip_entity_id t_wip_entity_id;

Line 2881: INSERT INTO WIP_REQUIREMENT_OPERATIONS

2877:
2878: l_stmt_num := 70;
2879: FORALL i in (l_no_of_rows + 1)..(j-1)
2880: --move enh changed released quantity to start_qty*qpa on 21 Oct 03
2881: INSERT INTO WIP_REQUIREMENT_OPERATIONS
2882: (inventory_item_id,
2883: organization_id,
2884: wip_entity_id,
2885: operation_seq_num,

Line 3007: INSERT INTO WIP_REQUIREMENT_OPERATIONS

3003: , v_component_yield_factor(i));
3004: END;
3005: ELSE
3006:
3007: INSERT INTO WIP_REQUIREMENT_OPERATIONS
3008: (inventory_item_id,
3009: organization_id,
3010: wip_entity_id,
3011: operation_seq_num,