914: l_Revision_Tbl EGO_Item_PUB.Item_Revision_Tbl_Type;
915: l_item_created_tbl EGO_ITEM_PUB.Item_Tbl_Type;
916: l_approval_status VARCHAR2(30);
917: l_template_applied BOOLEAN := FALSE;
918: l_obj_version_num mtl_system_items_b.object_version_number%TYPE;
919:
920: CURSOR c_get_obj_version_num(cp_inventory_item_id IN NUMBER
921: ,cp_organization_id IN NUMBER ) IS
922: SELECT object_version_number
919:
920: CURSOR c_get_obj_version_num(cp_inventory_item_id IN NUMBER
921: ,cp_organization_id IN NUMBER ) IS
922: SELECT object_version_number
923: FROM mtl_system_items_b
924: WHERE inventory_item_id = cp_inventory_item_id
925: AND organization_id = cp_organization_id;
926:
927: -- Bug 9852661
1824: ,x_Item_Tbl IN OUT NOCOPY EGO_Item_PUB.Item_Tbl_Type
1825: ,x_return_status OUT NOCOPY VARCHAR2) IS
1826:
1827: l_Segment_Rec INV_ITEM_API.Item_rec_type;
1828: l_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
1829: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
1830: l_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
1831: l_catalog MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE;
1832: l_error_status VARCHAR2(500) := NULL;
1825: ,x_return_status OUT NOCOPY VARCHAR2) IS
1826:
1827: l_Segment_Rec INV_ITEM_API.Item_rec_type;
1828: l_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
1829: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
1830: l_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
1831: l_catalog MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE;
1832: l_error_status VARCHAR2(500) := NULL;
1833: l_null_char VARCHAR2(1) := NULL;
1826:
1827: l_Segment_Rec INV_ITEM_API.Item_rec_type;
1828: l_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
1829: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
1830: l_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
1831: l_catalog MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE;
1832: l_error_status VARCHAR2(500) := NULL;
1833: l_null_char VARCHAR2(1) := NULL;
1834:
1827: l_Segment_Rec INV_ITEM_API.Item_rec_type;
1828: l_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
1829: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
1830: l_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
1831: l_catalog MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE;
1832: l_error_status VARCHAR2(500) := NULL;
1833: l_null_char VARCHAR2(1) := NULL;
1834:
1835: BEGIN
1975: ,P_Item_Catalog_Group_Id => l_catalog);
1976:
1977: IF l_Item_Id IS NULL THEN
1978:
1979: UPDATE mtl_system_items_b
1980: SET segment1 = l_Segment_Rec.segment1
1981: ,segment2 = l_Segment_Rec.segment2
1982: ,segment3 = l_Segment_Rec.segment3
1983: ,segment4 = l_Segment_Rec.segment4
2194: ,p_commit IN VARCHAR2 DEFAULT G_FALSE)
2195: IS
2196: l_eng_item_flag VARCHAR2(10);
2197: l_msg_data VARCHAR2(2000);
2198: old_approval_status MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE;
2199: l_event_return_status VARCHAR2(1);
2200: BEGIN
2201: --get old Approval Status, needed for Raising event.
2202: SELECT APPROVAL_STATUS INTO old_approval_status
2199: l_event_return_status VARCHAR2(1);
2200: BEGIN
2201: --get old Approval Status, needed for Raising event.
2202: SELECT APPROVAL_STATUS INTO old_approval_status
2203: FROM MTL_SYSTEM_ITEMS_B
2204: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2205: AND ORGANIZATION_ID = p_organization_id;
2206:
2207: UPDATE MTL_SYSTEM_ITEMS_B
2203: FROM MTL_SYSTEM_ITEMS_B
2204: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2205: AND ORGANIZATION_ID = p_organization_id;
2206:
2207: UPDATE MTL_SYSTEM_ITEMS_B
2208: SET APPROVAL_STATUS = p_approval_status
2209: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2210: AND ORGANIZATION_ID = p_organization_id
2211: RETURNING ENG_ITEM_FLAG INTO l_eng_item_flag;
2251: -- R12-C: Since Items can now have multiple NIRs, we will store the latest
2252: --NIR that cause the approval status change for an item in MSIB.
2253: IF NVL(p_approval_status,'0') <> NVL(OLD_APPROVAL_STATUS,'0')
2254: AND p_nir_id IS NOT NULL THEN
2255: UPDATE MTL_SYSTEM_ITEMS_B
2256: SET LAST_SUBMITTED_NIR_ID = p_nir_id
2257: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2258: AND ORGANIZATION_ID = p_organization_id;
2259: END IF;
2291:
2292: CURSOR c_copy_item_info (cp_inventory_item_id IN NUMBER
2293: ,cp_organization_id IN NUMBER ) IS
2294: SELECT *
2295: FROM mtl_system_items_b
2296: WHERE inventory_item_id = cp_inventory_item_id
2297: AND organization_id = cp_organization_id;
2298:
2299: l_orig_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;
2295: FROM mtl_system_items_b
2296: WHERE inventory_item_id = cp_inventory_item_id
2297: AND organization_id = cp_organization_id;
2298:
2299: l_orig_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;
2300:
2301: BEGIN
2302:
2303: OPEN c_copy_item_info (cp_inventory_item_id => p_inventory_item_id
2707: WHERE NVL(a.status_control_code, 3) <> 1
2708: AND a.control_level IN (1, 2)
2709: AND a.attribute_group_id_gui IS NOT NULL
2710: AND a.attribute_name NOT IN
2711: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2712: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2713: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2714: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2715: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2708: AND a.control_level IN (1, 2)
2709: AND a.attribute_group_id_gui IS NOT NULL
2710: AND a.attribute_name NOT IN
2711: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2712: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2713: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2714: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2715: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2716: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2709: AND a.attribute_group_id_gui IS NOT NULL
2710: AND a.attribute_name NOT IN
2711: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2712: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2713: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2714: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2715: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2716: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2717: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2710: AND a.attribute_name NOT IN
2711: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2712: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2713: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2714: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2715: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2716: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2717: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2718: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2711: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2712: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2713: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2714: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2715: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2716: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2717: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2718: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2719: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2712: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2713: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2714: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2715: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2716: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2717: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2718: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2719: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2720: 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET')
2713: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2714: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2715: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2716: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2717: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2718: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2719: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2720: 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET')
2721: );
2714: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2715: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2716: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2717: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2718: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2719: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2720: 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET')
2721: );
2722:
2715: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2716: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2717: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2718: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2719: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2720: 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET')
2721: );
2722:
2723: -- Attributes that can be applied only through the Org Specific templates.
2716: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2717: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2718: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2719: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2720: 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET')
2721: );
2722:
2723: -- Attributes that can be applied only through the Org Specific templates.
2724:
2733: WHERE NVL(a.status_control_code, 3) <> 1
2734: AND a.control_level IN (1, 2)
2735: AND a.attribute_group_id_gui IS NOT NULL
2736: AND a.attribute_name IN
2737: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2738: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2739: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2740: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2741: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2734: AND a.control_level IN (1, 2)
2735: AND a.attribute_group_id_gui IS NOT NULL
2736: AND a.attribute_name IN
2737: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2738: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2739: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2740: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2741: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2742: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2735: AND a.attribute_group_id_gui IS NOT NULL
2736: AND a.attribute_name IN
2737: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2738: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2739: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2740: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2741: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2742: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2743: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2736: AND a.attribute_name IN
2737: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2738: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2739: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2740: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2741: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2742: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2743: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2744: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2737: ('MTL_SYSTEM_ITEMS.BASE_ITEM_ID',
2738: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2739: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2740: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2741: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2742: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2743: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2744: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2745: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2738: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID',
2739: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2740: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2741: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2742: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2743: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2744: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2745: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2746: 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET')
2739: 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY',
2740: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2741: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2742: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2743: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2744: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2745: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2746: 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET')
2747: );
2740: 'MTL_SYSTEM_ITEMS.BASE_WARRANTY_SERVICE_ID',
2741: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2742: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2743: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2744: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2745: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2746: 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET')
2747: );
2748:
2741: 'MTL_SYSTEM_ITEMS.PLANNER_CODE',
2742: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2743: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2744: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2745: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2746: 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET')
2747: );
2748:
2749: CURSOR c_get_global_flex_fields (cp_template_id IN NUMBER) IS
2742: 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT',
2743: 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT',
2744: 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT',
2745: 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT',
2746: 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET')
2747: );
2748:
2749: CURSOR c_get_global_flex_fields (cp_template_id IN NUMBER) IS
2750: SELECT GLOBAL_ATTRIBUTE_CATEGORY,
2802: ------------------------------------
2803: -- Set item record attribute values
2804: ------------------------------------
2805: FOR cr IN c_get_template_attributes (cp_template_id => p_template_id) LOOP
2806: IF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_EARLY_DAYS' THEN
2807: x_item_table(p_tab_index).ACCEPTABLE_EARLY_DAYS := cr.ATTRIBUTE_VALUE;
2808: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_RATE_DECREASE' THEN
2809: x_item_table(p_tab_index).ACCEPTABLE_RATE_DECREASE := cr.ATTRIBUTE_VALUE;
2810: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_RATE_INCREASE' THEN
2804: ------------------------------------
2805: FOR cr IN c_get_template_attributes (cp_template_id => p_template_id) LOOP
2806: IF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_EARLY_DAYS' THEN
2807: x_item_table(p_tab_index).ACCEPTABLE_EARLY_DAYS := cr.ATTRIBUTE_VALUE;
2808: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_RATE_DECREASE' THEN
2809: x_item_table(p_tab_index).ACCEPTABLE_RATE_DECREASE := cr.ATTRIBUTE_VALUE;
2810: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_RATE_INCREASE' THEN
2811: x_item_table(p_tab_index).ACCEPTABLE_RATE_INCREASE := cr.ATTRIBUTE_VALUE;
2812: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCOUNTING_RULE_ID' THEN
2806: IF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_EARLY_DAYS' THEN
2807: x_item_table(p_tab_index).ACCEPTABLE_EARLY_DAYS := cr.ATTRIBUTE_VALUE;
2808: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_RATE_DECREASE' THEN
2809: x_item_table(p_tab_index).ACCEPTABLE_RATE_DECREASE := cr.ATTRIBUTE_VALUE;
2810: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_RATE_INCREASE' THEN
2811: x_item_table(p_tab_index).ACCEPTABLE_RATE_INCREASE := cr.ATTRIBUTE_VALUE;
2812: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCOUNTING_RULE_ID' THEN
2813: x_item_table(p_tab_index).ACCOUNTING_RULE_ID := cr.ATTRIBUTE_VALUE;
2814: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOWED_UNITS_LOOKUP_CODE' THEN
2808: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_RATE_DECREASE' THEN
2809: x_item_table(p_tab_index).ACCEPTABLE_RATE_DECREASE := cr.ATTRIBUTE_VALUE;
2810: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_RATE_INCREASE' THEN
2811: x_item_table(p_tab_index).ACCEPTABLE_RATE_INCREASE := cr.ATTRIBUTE_VALUE;
2812: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCOUNTING_RULE_ID' THEN
2813: x_item_table(p_tab_index).ACCOUNTING_RULE_ID := cr.ATTRIBUTE_VALUE;
2814: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOWED_UNITS_LOOKUP_CODE' THEN
2815: x_item_table(p_tab_index).ALLOWED_UNITS_LOOKUP_CODE := cr.ATTRIBUTE_VALUE;
2816: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_EXPRESS_DELIVERY_FLAG' THEN
2810: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCEPTABLE_RATE_INCREASE' THEN
2811: x_item_table(p_tab_index).ACCEPTABLE_RATE_INCREASE := cr.ATTRIBUTE_VALUE;
2812: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCOUNTING_RULE_ID' THEN
2813: x_item_table(p_tab_index).ACCOUNTING_RULE_ID := cr.ATTRIBUTE_VALUE;
2814: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOWED_UNITS_LOOKUP_CODE' THEN
2815: x_item_table(p_tab_index).ALLOWED_UNITS_LOOKUP_CODE := cr.ATTRIBUTE_VALUE;
2816: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_EXPRESS_DELIVERY_FLAG' THEN
2817: x_item_table(p_tab_index).ALLOW_EXPRESS_DELIVERY_FLAG := cr.ATTRIBUTE_VALUE;
2818: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_ITEM_DESC_UPDATE_FLAG' THEN
2812: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ACCOUNTING_RULE_ID' THEN
2813: x_item_table(p_tab_index).ACCOUNTING_RULE_ID := cr.ATTRIBUTE_VALUE;
2814: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOWED_UNITS_LOOKUP_CODE' THEN
2815: x_item_table(p_tab_index).ALLOWED_UNITS_LOOKUP_CODE := cr.ATTRIBUTE_VALUE;
2816: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_EXPRESS_DELIVERY_FLAG' THEN
2817: x_item_table(p_tab_index).ALLOW_EXPRESS_DELIVERY_FLAG := cr.ATTRIBUTE_VALUE;
2818: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_ITEM_DESC_UPDATE_FLAG' THEN
2819: x_item_table(p_tab_index).ALLOW_ITEM_DESC_UPDATE_FLAG := cr.ATTRIBUTE_VALUE;
2820: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG' THEN
2814: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOWED_UNITS_LOOKUP_CODE' THEN
2815: x_item_table(p_tab_index).ALLOWED_UNITS_LOOKUP_CODE := cr.ATTRIBUTE_VALUE;
2816: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_EXPRESS_DELIVERY_FLAG' THEN
2817: x_item_table(p_tab_index).ALLOW_EXPRESS_DELIVERY_FLAG := cr.ATTRIBUTE_VALUE;
2818: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_ITEM_DESC_UPDATE_FLAG' THEN
2819: x_item_table(p_tab_index).ALLOW_ITEM_DESC_UPDATE_FLAG := cr.ATTRIBUTE_VALUE;
2820: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG' THEN
2821: x_item_table(p_tab_index).ALLOW_SUBSTITUTE_RECEIPTS_FLAG := cr.ATTRIBUTE_VALUE;
2822: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_UNORDERED_RECEIPTS_FLAG' THEN
2816: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_EXPRESS_DELIVERY_FLAG' THEN
2817: x_item_table(p_tab_index).ALLOW_EXPRESS_DELIVERY_FLAG := cr.ATTRIBUTE_VALUE;
2818: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_ITEM_DESC_UPDATE_FLAG' THEN
2819: x_item_table(p_tab_index).ALLOW_ITEM_DESC_UPDATE_FLAG := cr.ATTRIBUTE_VALUE;
2820: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG' THEN
2821: x_item_table(p_tab_index).ALLOW_SUBSTITUTE_RECEIPTS_FLAG := cr.ATTRIBUTE_VALUE;
2822: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_UNORDERED_RECEIPTS_FLAG' THEN
2823: x_item_table(p_tab_index).ALLOW_UNORDERED_RECEIPTS_FLAG := cr.ATTRIBUTE_VALUE;
2824: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CATEGORY_ID' THEN
2818: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_ITEM_DESC_UPDATE_FLAG' THEN
2819: x_item_table(p_tab_index).ALLOW_ITEM_DESC_UPDATE_FLAG := cr.ATTRIBUTE_VALUE;
2820: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG' THEN
2821: x_item_table(p_tab_index).ALLOW_SUBSTITUTE_RECEIPTS_FLAG := cr.ATTRIBUTE_VALUE;
2822: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_UNORDERED_RECEIPTS_FLAG' THEN
2823: x_item_table(p_tab_index).ALLOW_UNORDERED_RECEIPTS_FLAG := cr.ATTRIBUTE_VALUE;
2824: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CATEGORY_ID' THEN
2825: x_item_table(p_tab_index).ASSET_CATEGORY_ID := cr.ATTRIBUTE_VALUE;
2826: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_COMPONENTS_FLAG' THEN
2820: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG' THEN
2821: x_item_table(p_tab_index).ALLOW_SUBSTITUTE_RECEIPTS_FLAG := cr.ATTRIBUTE_VALUE;
2822: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_UNORDERED_RECEIPTS_FLAG' THEN
2823: x_item_table(p_tab_index).ALLOW_UNORDERED_RECEIPTS_FLAG := cr.ATTRIBUTE_VALUE;
2824: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CATEGORY_ID' THEN
2825: x_item_table(p_tab_index).ASSET_CATEGORY_ID := cr.ATTRIBUTE_VALUE;
2826: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_COMPONENTS_FLAG' THEN
2827: x_item_table(p_tab_index).ATP_COMPONENTS_FLAG := cr.ATTRIBUTE_VALUE;
2828: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_FLAG' THEN
2822: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ALLOW_UNORDERED_RECEIPTS_FLAG' THEN
2823: x_item_table(p_tab_index).ALLOW_UNORDERED_RECEIPTS_FLAG := cr.ATTRIBUTE_VALUE;
2824: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CATEGORY_ID' THEN
2825: x_item_table(p_tab_index).ASSET_CATEGORY_ID := cr.ATTRIBUTE_VALUE;
2826: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_COMPONENTS_FLAG' THEN
2827: x_item_table(p_tab_index).ATP_COMPONENTS_FLAG := cr.ATTRIBUTE_VALUE;
2828: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_FLAG' THEN
2829: x_item_table(p_tab_index).ATP_FLAG := cr.ATTRIBUTE_VALUE;
2830: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_RULE_ID' THEN
2824: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CATEGORY_ID' THEN
2825: x_item_table(p_tab_index).ASSET_CATEGORY_ID := cr.ATTRIBUTE_VALUE;
2826: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_COMPONENTS_FLAG' THEN
2827: x_item_table(p_tab_index).ATP_COMPONENTS_FLAG := cr.ATTRIBUTE_VALUE;
2828: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_FLAG' THEN
2829: x_item_table(p_tab_index).ATP_FLAG := cr.ATTRIBUTE_VALUE;
2830: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_RULE_ID' THEN
2831: x_item_table(p_tab_index).ATP_RULE_ID := cr.ATTRIBUTE_VALUE;
2832: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' THEN
2826: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_COMPONENTS_FLAG' THEN
2827: x_item_table(p_tab_index).ATP_COMPONENTS_FLAG := cr.ATTRIBUTE_VALUE;
2828: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_FLAG' THEN
2829: x_item_table(p_tab_index).ATP_FLAG := cr.ATTRIBUTE_VALUE;
2830: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_RULE_ID' THEN
2831: x_item_table(p_tab_index).ATP_RULE_ID := cr.ATTRIBUTE_VALUE;
2832: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' THEN
2833: x_item_table(p_tab_index).AUTO_LOT_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2834: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' THEN
2828: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_FLAG' THEN
2829: x_item_table(p_tab_index).ATP_FLAG := cr.ATTRIBUTE_VALUE;
2830: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_RULE_ID' THEN
2831: x_item_table(p_tab_index).ATP_RULE_ID := cr.ATTRIBUTE_VALUE;
2832: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' THEN
2833: x_item_table(p_tab_index).AUTO_LOT_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2834: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' THEN
2835: x_item_table(p_tab_index).AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
2836: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' THEN
2830: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATP_RULE_ID' THEN
2831: x_item_table(p_tab_index).ATP_RULE_ID := cr.ATTRIBUTE_VALUE;
2832: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' THEN
2833: x_item_table(p_tab_index).AUTO_LOT_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2834: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' THEN
2835: x_item_table(p_tab_index).AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
2836: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' THEN
2837: x_item_table(p_tab_index).AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2838: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
2832: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX' THEN
2833: x_item_table(p_tab_index).AUTO_LOT_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2834: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' THEN
2835: x_item_table(p_tab_index).AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
2836: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' THEN
2837: x_item_table(p_tab_index).AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2838: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
2839: x_item_table(p_tab_index).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2840: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2834: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_REDUCE_MPS' THEN
2835: x_item_table(p_tab_index).AUTO_REDUCE_MPS := cr.ATTRIBUTE_VALUE;
2836: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' THEN
2837: x_item_table(p_tab_index).AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2838: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
2839: x_item_table(p_tab_index).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2840: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2841: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2842: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
2836: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_SERIAL_ALPHA_PREFIX' THEN
2837: x_item_table(p_tab_index).AUTO_SERIAL_ALPHA_PREFIX := cr.ATTRIBUTE_VALUE;
2838: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
2839: x_item_table(p_tab_index).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2840: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2841: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2842: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
2843: x_item_table(p_tab_index).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
2844: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN
2838: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
2839: x_item_table(p_tab_index).BOM_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2840: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2841: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2842: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
2843: x_item_table(p_tab_index).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
2844: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN
2845: x_item_table(p_tab_index).BUYER_ID := cr.ATTRIBUTE_VALUE;
2846: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' THEN
2840: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE' THEN
2841: x_item_table(p_tab_index).BOM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2842: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
2843: x_item_table(p_tab_index).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
2844: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN
2845: x_item_table(p_tab_index).BUYER_ID := cr.ATTRIBUTE_VALUE;
2846: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' THEN
2847: x_item_table(p_tab_index).CARRYING_COST := cr.ATTRIBUTE_VALUE;
2848: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' THEN
2842: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
2843: x_item_table(p_tab_index).BUILD_IN_WIP_FLAG := cr.ATTRIBUTE_VALUE;
2844: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN
2845: x_item_table(p_tab_index).BUYER_ID := cr.ATTRIBUTE_VALUE;
2846: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' THEN
2847: x_item_table(p_tab_index).CARRYING_COST := cr.ATTRIBUTE_VALUE;
2848: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' THEN
2849: x_item_table(p_tab_index).COLLATERAL_FLAG := cr.ATTRIBUTE_VALUE;
2850: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' THEN
2844: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BUYER_ID' THEN
2845: x_item_table(p_tab_index).BUYER_ID := cr.ATTRIBUTE_VALUE;
2846: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' THEN
2847: x_item_table(p_tab_index).CARRYING_COST := cr.ATTRIBUTE_VALUE;
2848: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' THEN
2849: x_item_table(p_tab_index).COLLATERAL_FLAG := cr.ATTRIBUTE_VALUE;
2850: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' THEN
2851: x_item_table(p_tab_index).COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2852: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG' THEN--3911562
2846: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CARRYING_COST' THEN
2847: x_item_table(p_tab_index).CARRYING_COST := cr.ATTRIBUTE_VALUE;
2848: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' THEN
2849: x_item_table(p_tab_index).COLLATERAL_FLAG := cr.ATTRIBUTE_VALUE;
2850: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' THEN
2851: x_item_table(p_tab_index).COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2852: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG' THEN--3911562
2853: x_item_table(p_tab_index).auto_created_config_flag := cr.ATTRIBUTE_VALUE;
2854: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COVERAGE_SCHEDULE_ID' THEN
2848: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COLLATERAL_FLAG' THEN
2849: x_item_table(p_tab_index).COLLATERAL_FLAG := cr.ATTRIBUTE_VALUE;
2850: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' THEN
2851: x_item_table(p_tab_index).COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2852: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG' THEN--3911562
2853: x_item_table(p_tab_index).auto_created_config_flag := cr.ATTRIBUTE_VALUE;
2854: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COVERAGE_SCHEDULE_ID' THEN
2855: x_item_table(p_tab_index).COVERAGE_SCHEDULE_ID := cr.ATTRIBUTE_VALUE;
2856: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUMULATIVE_TOTAL_LEAD_TIME' THEN
2850: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG' THEN
2851: x_item_table(p_tab_index).COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2852: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG' THEN--3911562
2853: x_item_table(p_tab_index).auto_created_config_flag := cr.ATTRIBUTE_VALUE;
2854: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COVERAGE_SCHEDULE_ID' THEN
2855: x_item_table(p_tab_index).COVERAGE_SCHEDULE_ID := cr.ATTRIBUTE_VALUE;
2856: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUMULATIVE_TOTAL_LEAD_TIME' THEN
2857: x_item_table(p_tab_index).CUMULATIVE_TOTAL_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2858: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUM_MANUFACTURING_LEAD_TIME' THEN
2852: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG' THEN--3911562
2853: x_item_table(p_tab_index).auto_created_config_flag := cr.ATTRIBUTE_VALUE;
2854: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COVERAGE_SCHEDULE_ID' THEN
2855: x_item_table(p_tab_index).COVERAGE_SCHEDULE_ID := cr.ATTRIBUTE_VALUE;
2856: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUMULATIVE_TOTAL_LEAD_TIME' THEN
2857: x_item_table(p_tab_index).CUMULATIVE_TOTAL_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2858: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUM_MANUFACTURING_LEAD_TIME' THEN
2859: x_item_table(p_tab_index).CUM_MANUFACTURING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2860: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
2854: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COVERAGE_SCHEDULE_ID' THEN
2855: x_item_table(p_tab_index).COVERAGE_SCHEDULE_ID := cr.ATTRIBUTE_VALUE;
2856: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUMULATIVE_TOTAL_LEAD_TIME' THEN
2857: x_item_table(p_tab_index).CUMULATIVE_TOTAL_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2858: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUM_MANUFACTURING_LEAD_TIME' THEN
2859: x_item_table(p_tab_index).CUM_MANUFACTURING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2860: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
2861: x_item_table(p_tab_index).CUSTOMER_ORDER_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2862: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_FLAG' THEN
2856: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUMULATIVE_TOTAL_LEAD_TIME' THEN
2857: x_item_table(p_tab_index).CUMULATIVE_TOTAL_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2858: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUM_MANUFACTURING_LEAD_TIME' THEN
2859: x_item_table(p_tab_index).CUM_MANUFACTURING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2860: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
2861: x_item_table(p_tab_index).CUSTOMER_ORDER_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2862: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_FLAG' THEN
2863: x_item_table(p_tab_index).CUSTOMER_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
2864: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CYCLE_COUNT_ENABLED_FLAG' THEN
2858: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUM_MANUFACTURING_LEAD_TIME' THEN
2859: x_item_table(p_tab_index).CUM_MANUFACTURING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2860: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
2861: x_item_table(p_tab_index).CUSTOMER_ORDER_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2862: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_FLAG' THEN
2863: x_item_table(p_tab_index).CUSTOMER_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
2864: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CYCLE_COUNT_ENABLED_FLAG' THEN
2865: x_item_table(p_tab_index).CYCLE_COUNT_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2866: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_EARLY_RECEIPT_ALLOWED' THEN
2860: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
2861: x_item_table(p_tab_index).CUSTOMER_ORDER_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2862: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_FLAG' THEN
2863: x_item_table(p_tab_index).CUSTOMER_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
2864: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CYCLE_COUNT_ENABLED_FLAG' THEN
2865: x_item_table(p_tab_index).CYCLE_COUNT_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2866: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_EARLY_RECEIPT_ALLOWED' THEN
2867: x_item_table(p_tab_index).DAYS_EARLY_RECEIPT_ALLOWED := cr.ATTRIBUTE_VALUE;
2868: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_LATE_RECEIPT_ALLOWED' THEN
2862: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_FLAG' THEN
2863: x_item_table(p_tab_index).CUSTOMER_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
2864: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CYCLE_COUNT_ENABLED_FLAG' THEN
2865: x_item_table(p_tab_index).CYCLE_COUNT_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2866: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_EARLY_RECEIPT_ALLOWED' THEN
2867: x_item_table(p_tab_index).DAYS_EARLY_RECEIPT_ALLOWED := cr.ATTRIBUTE_VALUE;
2868: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_LATE_RECEIPT_ALLOWED' THEN
2869: x_item_table(p_tab_index).DAYS_LATE_RECEIPT_ALLOWED := cr.ATTRIBUTE_VALUE;
2870: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_INCLUDE_IN_ROLLUP_FLAG' THEN
2864: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CYCLE_COUNT_ENABLED_FLAG' THEN
2865: x_item_table(p_tab_index).CYCLE_COUNT_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2866: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_EARLY_RECEIPT_ALLOWED' THEN
2867: x_item_table(p_tab_index).DAYS_EARLY_RECEIPT_ALLOWED := cr.ATTRIBUTE_VALUE;
2868: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_LATE_RECEIPT_ALLOWED' THEN
2869: x_item_table(p_tab_index).DAYS_LATE_RECEIPT_ALLOWED := cr.ATTRIBUTE_VALUE;
2870: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_INCLUDE_IN_ROLLUP_FLAG' THEN
2871: x_item_table(p_tab_index).DEFAULT_INCLUDE_IN_ROLLUP_FLAG := cr.ATTRIBUTE_VALUE;
2872: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SHIPPING_ORG' THEN
2866: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_EARLY_RECEIPT_ALLOWED' THEN
2867: x_item_table(p_tab_index).DAYS_EARLY_RECEIPT_ALLOWED := cr.ATTRIBUTE_VALUE;
2868: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_LATE_RECEIPT_ALLOWED' THEN
2869: x_item_table(p_tab_index).DAYS_LATE_RECEIPT_ALLOWED := cr.ATTRIBUTE_VALUE;
2870: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_INCLUDE_IN_ROLLUP_FLAG' THEN
2871: x_item_table(p_tab_index).DEFAULT_INCLUDE_IN_ROLLUP_FLAG := cr.ATTRIBUTE_VALUE;
2872: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SHIPPING_ORG' THEN
2873: x_item_table(p_tab_index).DEFAULT_SHIPPING_ORG := cr.ATTRIBUTE_VALUE;
2874: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEMAND_TIME_FENCE_CODE' THEN
2868: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_LATE_RECEIPT_ALLOWED' THEN
2869: x_item_table(p_tab_index).DAYS_LATE_RECEIPT_ALLOWED := cr.ATTRIBUTE_VALUE;
2870: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_INCLUDE_IN_ROLLUP_FLAG' THEN
2871: x_item_table(p_tab_index).DEFAULT_INCLUDE_IN_ROLLUP_FLAG := cr.ATTRIBUTE_VALUE;
2872: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SHIPPING_ORG' THEN
2873: x_item_table(p_tab_index).DEFAULT_SHIPPING_ORG := cr.ATTRIBUTE_VALUE;
2874: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEMAND_TIME_FENCE_CODE' THEN
2875: x_item_table(p_tab_index).DEMAND_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
2876: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEMAND_TIME_FENCE_DAYS' THEN
2870: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_INCLUDE_IN_ROLLUP_FLAG' THEN
2871: x_item_table(p_tab_index).DEFAULT_INCLUDE_IN_ROLLUP_FLAG := cr.ATTRIBUTE_VALUE;
2872: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SHIPPING_ORG' THEN
2873: x_item_table(p_tab_index).DEFAULT_SHIPPING_ORG := cr.ATTRIBUTE_VALUE;
2874: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEMAND_TIME_FENCE_CODE' THEN
2875: x_item_table(p_tab_index).DEMAND_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
2876: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEMAND_TIME_FENCE_DAYS' THEN
2877: x_item_table(p_tab_index).DEMAND_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
2878: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.END_ASSEMBLY_PEGGING_FLAG' THEN
2872: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SHIPPING_ORG' THEN
2873: x_item_table(p_tab_index).DEFAULT_SHIPPING_ORG := cr.ATTRIBUTE_VALUE;
2874: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEMAND_TIME_FENCE_CODE' THEN
2875: x_item_table(p_tab_index).DEMAND_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
2876: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEMAND_TIME_FENCE_DAYS' THEN
2877: x_item_table(p_tab_index).DEMAND_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
2878: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.END_ASSEMBLY_PEGGING_FLAG' THEN
2879: x_item_table(p_tab_index).END_ASSEMBLY_PEGGING_FLAG := cr.ATTRIBUTE_VALUE;
2880: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENFORCE_SHIP_TO_LOCATION_CODE' THEN
2874: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEMAND_TIME_FENCE_CODE' THEN
2875: x_item_table(p_tab_index).DEMAND_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
2876: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEMAND_TIME_FENCE_DAYS' THEN
2877: x_item_table(p_tab_index).DEMAND_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
2878: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.END_ASSEMBLY_PEGGING_FLAG' THEN
2879: x_item_table(p_tab_index).END_ASSEMBLY_PEGGING_FLAG := cr.ATTRIBUTE_VALUE;
2880: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENFORCE_SHIP_TO_LOCATION_CODE' THEN
2881: x_item_table(p_tab_index).ENFORCE_SHIP_TO_LOCATION_CODE := cr.ATTRIBUTE_VALUE;
2882: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' THEN
2876: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEMAND_TIME_FENCE_DAYS' THEN
2877: x_item_table(p_tab_index).DEMAND_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
2878: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.END_ASSEMBLY_PEGGING_FLAG' THEN
2879: x_item_table(p_tab_index).END_ASSEMBLY_PEGGING_FLAG := cr.ATTRIBUTE_VALUE;
2880: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENFORCE_SHIP_TO_LOCATION_CODE' THEN
2881: x_item_table(p_tab_index).ENFORCE_SHIP_TO_LOCATION_CODE := cr.ATTRIBUTE_VALUE;
2882: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' THEN
2883: x_item_table(p_tab_index).EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;
2884: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_DAYS_SUPPLY' THEN
2878: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.END_ASSEMBLY_PEGGING_FLAG' THEN
2879: x_item_table(p_tab_index).END_ASSEMBLY_PEGGING_FLAG := cr.ATTRIBUTE_VALUE;
2880: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENFORCE_SHIP_TO_LOCATION_CODE' THEN
2881: x_item_table(p_tab_index).ENFORCE_SHIP_TO_LOCATION_CODE := cr.ATTRIBUTE_VALUE;
2882: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' THEN
2883: x_item_table(p_tab_index).EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;
2884: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_DAYS_SUPPLY' THEN
2885: x_item_table(p_tab_index).FIXED_DAYS_SUPPLY := cr.ATTRIBUTE_VALUE;
2886: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_LEAD_TIME' THEN
2880: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENFORCE_SHIP_TO_LOCATION_CODE' THEN
2881: x_item_table(p_tab_index).ENFORCE_SHIP_TO_LOCATION_CODE := cr.ATTRIBUTE_VALUE;
2882: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' THEN
2883: x_item_table(p_tab_index).EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;
2884: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_DAYS_SUPPLY' THEN
2885: x_item_table(p_tab_index).FIXED_DAYS_SUPPLY := cr.ATTRIBUTE_VALUE;
2886: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_LEAD_TIME' THEN
2887: x_item_table(p_tab_index).FIXED_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2888: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_LOT_MULTIPLIER' THEN
2882: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' THEN
2883: x_item_table(p_tab_index).EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;
2884: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_DAYS_SUPPLY' THEN
2885: x_item_table(p_tab_index).FIXED_DAYS_SUPPLY := cr.ATTRIBUTE_VALUE;
2886: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_LEAD_TIME' THEN
2887: x_item_table(p_tab_index).FIXED_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2888: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_LOT_MULTIPLIER' THEN
2889: x_item_table(p_tab_index).FIXED_LOT_MULTIPLIER := cr.ATTRIBUTE_VALUE;
2890: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_ORDER_QUANTITY' THEN
2884: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_DAYS_SUPPLY' THEN
2885: x_item_table(p_tab_index).FIXED_DAYS_SUPPLY := cr.ATTRIBUTE_VALUE;
2886: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_LEAD_TIME' THEN
2887: x_item_table(p_tab_index).FIXED_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2888: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_LOT_MULTIPLIER' THEN
2889: x_item_table(p_tab_index).FIXED_LOT_MULTIPLIER := cr.ATTRIBUTE_VALUE;
2890: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_ORDER_QUANTITY' THEN
2891: x_item_table(p_tab_index).FIXED_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2892: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FULL_LEAD_TIME' THEN
2886: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_LEAD_TIME' THEN
2887: x_item_table(p_tab_index).FIXED_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2888: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_LOT_MULTIPLIER' THEN
2889: x_item_table(p_tab_index).FIXED_LOT_MULTIPLIER := cr.ATTRIBUTE_VALUE;
2890: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_ORDER_QUANTITY' THEN
2891: x_item_table(p_tab_index).FIXED_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2892: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FULL_LEAD_TIME' THEN
2893: x_item_table(p_tab_index).FULL_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2894: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HAZARD_CLASS_ID' THEN
2888: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_LOT_MULTIPLIER' THEN
2889: x_item_table(p_tab_index).FIXED_LOT_MULTIPLIER := cr.ATTRIBUTE_VALUE;
2890: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_ORDER_QUANTITY' THEN
2891: x_item_table(p_tab_index).FIXED_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2892: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FULL_LEAD_TIME' THEN
2893: x_item_table(p_tab_index).FULL_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2894: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HAZARD_CLASS_ID' THEN
2895: x_item_table(p_tab_index).HAZARD_CLASS_ID := cr.ATTRIBUTE_VALUE;
2896: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INSPECTION_REQUIRED_FLAG' THEN
2890: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FIXED_ORDER_QUANTITY' THEN
2891: x_item_table(p_tab_index).FIXED_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2892: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FULL_LEAD_TIME' THEN
2893: x_item_table(p_tab_index).FULL_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2894: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HAZARD_CLASS_ID' THEN
2895: x_item_table(p_tab_index).HAZARD_CLASS_ID := cr.ATTRIBUTE_VALUE;
2896: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INSPECTION_REQUIRED_FLAG' THEN
2897: x_item_table(p_tab_index).INSPECTION_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
2898: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
2892: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FULL_LEAD_TIME' THEN
2893: x_item_table(p_tab_index).FULL_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2894: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HAZARD_CLASS_ID' THEN
2895: x_item_table(p_tab_index).HAZARD_CLASS_ID := cr.ATTRIBUTE_VALUE;
2896: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INSPECTION_REQUIRED_FLAG' THEN
2897: x_item_table(p_tab_index).INSPECTION_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
2898: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
2899: x_item_table(p_tab_index).INTERNAL_ORDER_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2900: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_FLAG' THEN
2894: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HAZARD_CLASS_ID' THEN
2895: x_item_table(p_tab_index).HAZARD_CLASS_ID := cr.ATTRIBUTE_VALUE;
2896: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INSPECTION_REQUIRED_FLAG' THEN
2897: x_item_table(p_tab_index).INSPECTION_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
2898: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
2899: x_item_table(p_tab_index).INTERNAL_ORDER_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2900: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_FLAG' THEN
2901: x_item_table(p_tab_index).INTERNAL_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
2902: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG' THEN
2896: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INSPECTION_REQUIRED_FLAG' THEN
2897: x_item_table(p_tab_index).INSPECTION_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
2898: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
2899: x_item_table(p_tab_index).INTERNAL_ORDER_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2900: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_FLAG' THEN
2901: x_item_table(p_tab_index).INTERNAL_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
2902: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG' THEN
2903: x_item_table(p_tab_index).INVENTORY_ASSET_FLAG := cr.ATTRIBUTE_VALUE;
2904: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_FLAG' THEN
2898: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN
2899: x_item_table(p_tab_index).INTERNAL_ORDER_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2900: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_FLAG' THEN
2901: x_item_table(p_tab_index).INTERNAL_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
2902: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG' THEN
2903: x_item_table(p_tab_index).INVENTORY_ASSET_FLAG := cr.ATTRIBUTE_VALUE;
2904: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_FLAG' THEN
2905: x_item_table(p_tab_index).INVENTORY_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2906: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE' THEN
2900: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_FLAG' THEN
2901: x_item_table(p_tab_index).INTERNAL_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
2902: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG' THEN
2903: x_item_table(p_tab_index).INVENTORY_ASSET_FLAG := cr.ATTRIBUTE_VALUE;
2904: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_FLAG' THEN
2905: x_item_table(p_tab_index).INVENTORY_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2906: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE' THEN
2907: x_item_table(p_tab_index).INVENTORY_ITEM_STATUS_CODE := cr.ATTRIBUTE_VALUE;
2908: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_PLANNING_CODE' THEN
2902: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG' THEN
2903: x_item_table(p_tab_index).INVENTORY_ASSET_FLAG := cr.ATTRIBUTE_VALUE;
2904: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_FLAG' THEN
2905: x_item_table(p_tab_index).INVENTORY_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2906: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE' THEN
2907: x_item_table(p_tab_index).INVENTORY_ITEM_STATUS_CODE := cr.ATTRIBUTE_VALUE;
2908: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_PLANNING_CODE' THEN
2909: x_item_table(p_tab_index).INVENTORY_PLANNING_CODE := cr.ATTRIBUTE_VALUE;
2910: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG' THEN
2904: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_FLAG' THEN
2905: x_item_table(p_tab_index).INVENTORY_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2906: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE' THEN
2907: x_item_table(p_tab_index).INVENTORY_ITEM_STATUS_CODE := cr.ATTRIBUTE_VALUE;
2908: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_PLANNING_CODE' THEN
2909: x_item_table(p_tab_index).INVENTORY_PLANNING_CODE := cr.ATTRIBUTE_VALUE;
2910: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG' THEN
2911: x_item_table(p_tab_index).INVOICEABLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2912: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICE_CLOSE_TOLERANCE' THEN
2906: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE' THEN
2907: x_item_table(p_tab_index).INVENTORY_ITEM_STATUS_CODE := cr.ATTRIBUTE_VALUE;
2908: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_PLANNING_CODE' THEN
2909: x_item_table(p_tab_index).INVENTORY_PLANNING_CODE := cr.ATTRIBUTE_VALUE;
2910: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG' THEN
2911: x_item_table(p_tab_index).INVOICEABLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2912: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICE_CLOSE_TOLERANCE' THEN
2913: x_item_table(p_tab_index).INVOICE_CLOSE_TOLERANCE := cr.ATTRIBUTE_VALUE;
2914: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
2908: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_PLANNING_CODE' THEN
2909: x_item_table(p_tab_index).INVENTORY_PLANNING_CODE := cr.ATTRIBUTE_VALUE;
2910: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG' THEN
2911: x_item_table(p_tab_index).INVOICEABLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2912: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICE_CLOSE_TOLERANCE' THEN
2913: x_item_table(p_tab_index).INVOICE_CLOSE_TOLERANCE := cr.ATTRIBUTE_VALUE;
2914: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
2915: x_item_table(p_tab_index).INVOICE_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2916: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICING_RULE_ID' THEN
2910: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICEABLE_ITEM_FLAG' THEN
2911: x_item_table(p_tab_index).INVOICEABLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2912: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICE_CLOSE_TOLERANCE' THEN
2913: x_item_table(p_tab_index).INVOICE_CLOSE_TOLERANCE := cr.ATTRIBUTE_VALUE;
2914: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
2915: x_item_table(p_tab_index).INVOICE_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2916: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICING_RULE_ID' THEN
2917: x_item_table(p_tab_index).INVOICING_RULE_ID := cr.ATTRIBUTE_VALUE;
2918: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ITEM_TYPE' THEN
2912: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICE_CLOSE_TOLERANCE' THEN
2913: x_item_table(p_tab_index).INVOICE_CLOSE_TOLERANCE := cr.ATTRIBUTE_VALUE;
2914: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
2915: x_item_table(p_tab_index).INVOICE_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2916: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICING_RULE_ID' THEN
2917: x_item_table(p_tab_index).INVOICING_RULE_ID := cr.ATTRIBUTE_VALUE;
2918: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ITEM_TYPE' THEN
2919: x_item_table(p_tab_index).ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2920: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LEAD_TIME_LOT_SIZE' THEN
2914: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
2915: x_item_table(p_tab_index).INVOICE_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2916: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICING_RULE_ID' THEN
2917: x_item_table(p_tab_index).INVOICING_RULE_ID := cr.ATTRIBUTE_VALUE;
2918: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ITEM_TYPE' THEN
2919: x_item_table(p_tab_index).ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2920: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LEAD_TIME_LOT_SIZE' THEN
2921: x_item_table(p_tab_index).LEAD_TIME_LOT_SIZE := cr.ATTRIBUTE_VALUE;
2922: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT' THEN
2916: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVOICING_RULE_ID' THEN
2917: x_item_table(p_tab_index).INVOICING_RULE_ID := cr.ATTRIBUTE_VALUE;
2918: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ITEM_TYPE' THEN
2919: x_item_table(p_tab_index).ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2920: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LEAD_TIME_LOT_SIZE' THEN
2921: x_item_table(p_tab_index).LEAD_TIME_LOT_SIZE := cr.ATTRIBUTE_VALUE;
2922: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT' THEN
2923: x_item_table(p_tab_index).LIST_PRICE_PER_UNIT := cr.ATTRIBUTE_VALUE;
2924: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE' THEN
2918: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ITEM_TYPE' THEN
2919: x_item_table(p_tab_index).ITEM_TYPE := cr.ATTRIBUTE_VALUE;
2920: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LEAD_TIME_LOT_SIZE' THEN
2921: x_item_table(p_tab_index).LEAD_TIME_LOT_SIZE := cr.ATTRIBUTE_VALUE;
2922: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT' THEN
2923: x_item_table(p_tab_index).LIST_PRICE_PER_UNIT := cr.ATTRIBUTE_VALUE;
2924: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE' THEN
2925: x_item_table(p_tab_index).LOCATION_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
2926: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE' THEN
2920: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LEAD_TIME_LOT_SIZE' THEN
2921: x_item_table(p_tab_index).LEAD_TIME_LOT_SIZE := cr.ATTRIBUTE_VALUE;
2922: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT' THEN
2923: x_item_table(p_tab_index).LIST_PRICE_PER_UNIT := cr.ATTRIBUTE_VALUE;
2924: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE' THEN
2925: x_item_table(p_tab_index).LOCATION_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
2926: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE' THEN
2927: x_item_table(p_tab_index).LOT_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
2928: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MARKET_PRICE' THEN
2922: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT' THEN
2923: x_item_table(p_tab_index).LIST_PRICE_PER_UNIT := cr.ATTRIBUTE_VALUE;
2924: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE' THEN
2925: x_item_table(p_tab_index).LOCATION_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
2926: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE' THEN
2927: x_item_table(p_tab_index).LOT_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
2928: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MARKET_PRICE' THEN
2929: x_item_table(p_tab_index).MARKET_PRICE := cr.ATTRIBUTE_VALUE;
2930: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATERIAL_BILLABLE_FLAG' THEN
2924: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE' THEN
2925: x_item_table(p_tab_index).LOCATION_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
2926: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE' THEN
2927: x_item_table(p_tab_index).LOT_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
2928: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MARKET_PRICE' THEN
2929: x_item_table(p_tab_index).MARKET_PRICE := cr.ATTRIBUTE_VALUE;
2930: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATERIAL_BILLABLE_FLAG' THEN
2931: x_item_table(p_tab_index).MATERIAL_BILLABLE_FLAG := cr.ATTRIBUTE_VALUE;
2932: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAXIMUM_ORDER_QUANTITY' THEN
2926: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE' THEN
2927: x_item_table(p_tab_index).LOT_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
2928: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MARKET_PRICE' THEN
2929: x_item_table(p_tab_index).MARKET_PRICE := cr.ATTRIBUTE_VALUE;
2930: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATERIAL_BILLABLE_FLAG' THEN
2931: x_item_table(p_tab_index).MATERIAL_BILLABLE_FLAG := cr.ATTRIBUTE_VALUE;
2932: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAXIMUM_ORDER_QUANTITY' THEN
2933: x_item_table(p_tab_index).MAXIMUM_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2934: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAX_MINMAX_QUANTITY' THEN
2928: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MARKET_PRICE' THEN
2929: x_item_table(p_tab_index).MARKET_PRICE := cr.ATTRIBUTE_VALUE;
2930: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATERIAL_BILLABLE_FLAG' THEN
2931: x_item_table(p_tab_index).MATERIAL_BILLABLE_FLAG := cr.ATTRIBUTE_VALUE;
2932: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAXIMUM_ORDER_QUANTITY' THEN
2933: x_item_table(p_tab_index).MAXIMUM_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2934: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAX_MINMAX_QUANTITY' THEN
2935: x_item_table(p_tab_index).MAX_MINMAX_QUANTITY := cr.ATTRIBUTE_VALUE;
2936: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_ORDER_QUANTITY' THEN
2930: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATERIAL_BILLABLE_FLAG' THEN
2931: x_item_table(p_tab_index).MATERIAL_BILLABLE_FLAG := cr.ATTRIBUTE_VALUE;
2932: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAXIMUM_ORDER_QUANTITY' THEN
2933: x_item_table(p_tab_index).MAXIMUM_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2934: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAX_MINMAX_QUANTITY' THEN
2935: x_item_table(p_tab_index).MAX_MINMAX_QUANTITY := cr.ATTRIBUTE_VALUE;
2936: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_ORDER_QUANTITY' THEN
2937: x_item_table(p_tab_index).MINIMUM_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2938: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MIN_MINMAX_QUANTITY' THEN
2932: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAXIMUM_ORDER_QUANTITY' THEN
2933: x_item_table(p_tab_index).MAXIMUM_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2934: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAX_MINMAX_QUANTITY' THEN
2935: x_item_table(p_tab_index).MAX_MINMAX_QUANTITY := cr.ATTRIBUTE_VALUE;
2936: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_ORDER_QUANTITY' THEN
2937: x_item_table(p_tab_index).MINIMUM_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2938: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MIN_MINMAX_QUANTITY' THEN
2939: x_item_table(p_tab_index).MIN_MINMAX_QUANTITY := cr.ATTRIBUTE_VALUE;
2940: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_CALCULATE_ATP_FLAG' THEN
2934: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAX_MINMAX_QUANTITY' THEN
2935: x_item_table(p_tab_index).MAX_MINMAX_QUANTITY := cr.ATTRIBUTE_VALUE;
2936: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_ORDER_QUANTITY' THEN
2937: x_item_table(p_tab_index).MINIMUM_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2938: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MIN_MINMAX_QUANTITY' THEN
2939: x_item_table(p_tab_index).MIN_MINMAX_QUANTITY := cr.ATTRIBUTE_VALUE;
2940: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_CALCULATE_ATP_FLAG' THEN
2941: x_item_table(p_tab_index).MRP_CALCULATE_ATP_FLAG := cr.ATTRIBUTE_VALUE;
2942: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_PLANNING_CODE' THEN
2936: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_ORDER_QUANTITY' THEN
2937: x_item_table(p_tab_index).MINIMUM_ORDER_QUANTITY := cr.ATTRIBUTE_VALUE;
2938: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MIN_MINMAX_QUANTITY' THEN
2939: x_item_table(p_tab_index).MIN_MINMAX_QUANTITY := cr.ATTRIBUTE_VALUE;
2940: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_CALCULATE_ATP_FLAG' THEN
2941: x_item_table(p_tab_index).MRP_CALCULATE_ATP_FLAG := cr.ATTRIBUTE_VALUE;
2942: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_PLANNING_CODE' THEN
2943: x_item_table(p_tab_index).MRP_PLANNING_CODE := cr.ATTRIBUTE_VALUE;
2944: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_SAFETY_STOCK_CODE' THEN
2938: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MIN_MINMAX_QUANTITY' THEN
2939: x_item_table(p_tab_index).MIN_MINMAX_QUANTITY := cr.ATTRIBUTE_VALUE;
2940: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_CALCULATE_ATP_FLAG' THEN
2941: x_item_table(p_tab_index).MRP_CALCULATE_ATP_FLAG := cr.ATTRIBUTE_VALUE;
2942: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_PLANNING_CODE' THEN
2943: x_item_table(p_tab_index).MRP_PLANNING_CODE := cr.ATTRIBUTE_VALUE;
2944: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_SAFETY_STOCK_CODE' THEN
2945: x_item_table(p_tab_index).MRP_SAFETY_STOCK_CODE := cr.ATTRIBUTE_VALUE;
2946: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_SAFETY_STOCK_PERCENT' THEN
2940: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_CALCULATE_ATP_FLAG' THEN
2941: x_item_table(p_tab_index).MRP_CALCULATE_ATP_FLAG := cr.ATTRIBUTE_VALUE;
2942: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_PLANNING_CODE' THEN
2943: x_item_table(p_tab_index).MRP_PLANNING_CODE := cr.ATTRIBUTE_VALUE;
2944: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_SAFETY_STOCK_CODE' THEN
2945: x_item_table(p_tab_index).MRP_SAFETY_STOCK_CODE := cr.ATTRIBUTE_VALUE;
2946: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_SAFETY_STOCK_PERCENT' THEN
2947: x_item_table(p_tab_index).MRP_SAFETY_STOCK_PERCENT := cr.ATTRIBUTE_VALUE;
2948: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
2942: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_PLANNING_CODE' THEN
2943: x_item_table(p_tab_index).MRP_PLANNING_CODE := cr.ATTRIBUTE_VALUE;
2944: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_SAFETY_STOCK_CODE' THEN
2945: x_item_table(p_tab_index).MRP_SAFETY_STOCK_CODE := cr.ATTRIBUTE_VALUE;
2946: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_SAFETY_STOCK_PERCENT' THEN
2947: x_item_table(p_tab_index).MRP_SAFETY_STOCK_PERCENT := cr.ATTRIBUTE_VALUE;
2948: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
2949: x_item_table(p_tab_index).MTL_TRANSACTIONS_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2950: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MUST_USE_APPROVED_VENDOR_FLAG' THEN
2944: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_SAFETY_STOCK_CODE' THEN
2945: x_item_table(p_tab_index).MRP_SAFETY_STOCK_CODE := cr.ATTRIBUTE_VALUE;
2946: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_SAFETY_STOCK_PERCENT' THEN
2947: x_item_table(p_tab_index).MRP_SAFETY_STOCK_PERCENT := cr.ATTRIBUTE_VALUE;
2948: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
2949: x_item_table(p_tab_index).MTL_TRANSACTIONS_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2950: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MUST_USE_APPROVED_VENDOR_FLAG' THEN
2951: x_item_table(p_tab_index).MUST_USE_APPROVED_VENDOR_FLAG := cr.ATTRIBUTE_VALUE;
2952: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.NEGATIVE_MEASUREMENT_ERROR' THEN
2946: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MRP_SAFETY_STOCK_PERCENT' THEN
2947: x_item_table(p_tab_index).MRP_SAFETY_STOCK_PERCENT := cr.ATTRIBUTE_VALUE;
2948: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
2949: x_item_table(p_tab_index).MTL_TRANSACTIONS_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2950: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MUST_USE_APPROVED_VENDOR_FLAG' THEN
2951: x_item_table(p_tab_index).MUST_USE_APPROVED_VENDOR_FLAG := cr.ATTRIBUTE_VALUE;
2952: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.NEGATIVE_MEASUREMENT_ERROR' THEN
2953: x_item_table(p_tab_index).NEGATIVE_MEASUREMENT_ERROR := cr.ATTRIBUTE_VALUE;
2954: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDER_COST' THEN
2948: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
2949: x_item_table(p_tab_index).MTL_TRANSACTIONS_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2950: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MUST_USE_APPROVED_VENDOR_FLAG' THEN
2951: x_item_table(p_tab_index).MUST_USE_APPROVED_VENDOR_FLAG := cr.ATTRIBUTE_VALUE;
2952: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.NEGATIVE_MEASUREMENT_ERROR' THEN
2953: x_item_table(p_tab_index).NEGATIVE_MEASUREMENT_ERROR := cr.ATTRIBUTE_VALUE;
2954: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDER_COST' THEN
2955: x_item_table(p_tab_index).ORDER_COST := cr.ATTRIBUTE_VALUE;
2956: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG' THEN
2950: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MUST_USE_APPROVED_VENDOR_FLAG' THEN
2951: x_item_table(p_tab_index).MUST_USE_APPROVED_VENDOR_FLAG := cr.ATTRIBUTE_VALUE;
2952: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.NEGATIVE_MEASUREMENT_ERROR' THEN
2953: x_item_table(p_tab_index).NEGATIVE_MEASUREMENT_ERROR := cr.ATTRIBUTE_VALUE;
2954: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDER_COST' THEN
2955: x_item_table(p_tab_index).ORDER_COST := cr.ATTRIBUTE_VALUE;
2956: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG' THEN
2957: x_item_table(p_tab_index).OUTSIDE_OPERATION_FLAG := cr.ATTRIBUTE_VALUE;
2958: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_UOM_TYPE' THEN
2952: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.NEGATIVE_MEASUREMENT_ERROR' THEN
2953: x_item_table(p_tab_index).NEGATIVE_MEASUREMENT_ERROR := cr.ATTRIBUTE_VALUE;
2954: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDER_COST' THEN
2955: x_item_table(p_tab_index).ORDER_COST := cr.ATTRIBUTE_VALUE;
2956: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG' THEN
2957: x_item_table(p_tab_index).OUTSIDE_OPERATION_FLAG := cr.ATTRIBUTE_VALUE;
2958: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_UOM_TYPE' THEN
2959: x_item_table(p_tab_index).OUTSIDE_OPERATION_UOM_TYPE := cr.ATTRIBUTE_VALUE;
2960: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERRUN_PERCENTAGE' THEN
2954: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDER_COST' THEN
2955: x_item_table(p_tab_index).ORDER_COST := cr.ATTRIBUTE_VALUE;
2956: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG' THEN
2957: x_item_table(p_tab_index).OUTSIDE_OPERATION_FLAG := cr.ATTRIBUTE_VALUE;
2958: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_UOM_TYPE' THEN
2959: x_item_table(p_tab_index).OUTSIDE_OPERATION_UOM_TYPE := cr.ATTRIBUTE_VALUE;
2960: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERRUN_PERCENTAGE' THEN
2961: x_item_table(p_tab_index).OVERRUN_PERCENTAGE := cr.ATTRIBUTE_VALUE;
2962: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PAYMENT_TERMS_ID' THEN
2956: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG' THEN
2957: x_item_table(p_tab_index).OUTSIDE_OPERATION_FLAG := cr.ATTRIBUTE_VALUE;
2958: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_UOM_TYPE' THEN
2959: x_item_table(p_tab_index).OUTSIDE_OPERATION_UOM_TYPE := cr.ATTRIBUTE_VALUE;
2960: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERRUN_PERCENTAGE' THEN
2961: x_item_table(p_tab_index).OVERRUN_PERCENTAGE := cr.ATTRIBUTE_VALUE;
2962: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PAYMENT_TERMS_ID' THEN
2963: x_item_table(p_tab_index).PAYMENT_TERMS_ID := cr.ATTRIBUTE_VALUE;
2964: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PICKING_RULE_ID' THEN
2958: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_UOM_TYPE' THEN
2959: x_item_table(p_tab_index).OUTSIDE_OPERATION_UOM_TYPE := cr.ATTRIBUTE_VALUE;
2960: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERRUN_PERCENTAGE' THEN
2961: x_item_table(p_tab_index).OVERRUN_PERCENTAGE := cr.ATTRIBUTE_VALUE;
2962: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PAYMENT_TERMS_ID' THEN
2963: x_item_table(p_tab_index).PAYMENT_TERMS_ID := cr.ATTRIBUTE_VALUE;
2964: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PICKING_RULE_ID' THEN
2965: x_item_table(p_tab_index).PICKING_RULE_ID := cr.ATTRIBUTE_VALUE;
2966: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PICK_COMPONENTS_FLAG' THEN
2960: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERRUN_PERCENTAGE' THEN
2961: x_item_table(p_tab_index).OVERRUN_PERCENTAGE := cr.ATTRIBUTE_VALUE;
2962: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PAYMENT_TERMS_ID' THEN
2963: x_item_table(p_tab_index).PAYMENT_TERMS_ID := cr.ATTRIBUTE_VALUE;
2964: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PICKING_RULE_ID' THEN
2965: x_item_table(p_tab_index).PICKING_RULE_ID := cr.ATTRIBUTE_VALUE;
2966: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PICK_COMPONENTS_FLAG' THEN
2967: x_item_table(p_tab_index).PICK_COMPONENTS_FLAG := cr.ATTRIBUTE_VALUE;
2968: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_MAKE_BUY_CODE' THEN
2962: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PAYMENT_TERMS_ID' THEN
2963: x_item_table(p_tab_index).PAYMENT_TERMS_ID := cr.ATTRIBUTE_VALUE;
2964: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PICKING_RULE_ID' THEN
2965: x_item_table(p_tab_index).PICKING_RULE_ID := cr.ATTRIBUTE_VALUE;
2966: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PICK_COMPONENTS_FLAG' THEN
2967: x_item_table(p_tab_index).PICK_COMPONENTS_FLAG := cr.ATTRIBUTE_VALUE;
2968: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_MAKE_BUY_CODE' THEN
2969: x_item_table(p_tab_index).PLANNING_MAKE_BUY_CODE := cr.ATTRIBUTE_VALUE;
2970: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_TIME_FENCE_CODE' THEN
2964: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PICKING_RULE_ID' THEN
2965: x_item_table(p_tab_index).PICKING_RULE_ID := cr.ATTRIBUTE_VALUE;
2966: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PICK_COMPONENTS_FLAG' THEN
2967: x_item_table(p_tab_index).PICK_COMPONENTS_FLAG := cr.ATTRIBUTE_VALUE;
2968: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_MAKE_BUY_CODE' THEN
2969: x_item_table(p_tab_index).PLANNING_MAKE_BUY_CODE := cr.ATTRIBUTE_VALUE;
2970: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_TIME_FENCE_CODE' THEN
2971: x_item_table(p_tab_index).PLANNING_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
2972: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_TIME_FENCE_DAYS' THEN
2966: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PICK_COMPONENTS_FLAG' THEN
2967: x_item_table(p_tab_index).PICK_COMPONENTS_FLAG := cr.ATTRIBUTE_VALUE;
2968: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_MAKE_BUY_CODE' THEN
2969: x_item_table(p_tab_index).PLANNING_MAKE_BUY_CODE := cr.ATTRIBUTE_VALUE;
2970: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_TIME_FENCE_CODE' THEN
2971: x_item_table(p_tab_index).PLANNING_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
2972: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_TIME_FENCE_DAYS' THEN
2973: x_item_table(p_tab_index).PLANNING_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
2974: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.POSITIVE_MEASUREMENT_ERROR' THEN
2968: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_MAKE_BUY_CODE' THEN
2969: x_item_table(p_tab_index).PLANNING_MAKE_BUY_CODE := cr.ATTRIBUTE_VALUE;
2970: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_TIME_FENCE_CODE' THEN
2971: x_item_table(p_tab_index).PLANNING_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
2972: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_TIME_FENCE_DAYS' THEN
2973: x_item_table(p_tab_index).PLANNING_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
2974: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.POSITIVE_MEASUREMENT_ERROR' THEN
2975: x_item_table(p_tab_index).POSITIVE_MEASUREMENT_ERROR := cr.ATTRIBUTE_VALUE;
2976: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.POSTPROCESSING_LEAD_TIME' THEN
2970: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_TIME_FENCE_CODE' THEN
2971: x_item_table(p_tab_index).PLANNING_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
2972: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_TIME_FENCE_DAYS' THEN
2973: x_item_table(p_tab_index).PLANNING_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
2974: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.POSITIVE_MEASUREMENT_ERROR' THEN
2975: x_item_table(p_tab_index).POSITIVE_MEASUREMENT_ERROR := cr.ATTRIBUTE_VALUE;
2976: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.POSTPROCESSING_LEAD_TIME' THEN
2977: x_item_table(p_tab_index).POSTPROCESSING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2978: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PREPROCESSING_LEAD_TIME' THEN
2972: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_TIME_FENCE_DAYS' THEN
2973: x_item_table(p_tab_index).PLANNING_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
2974: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.POSITIVE_MEASUREMENT_ERROR' THEN
2975: x_item_table(p_tab_index).POSITIVE_MEASUREMENT_ERROR := cr.ATTRIBUTE_VALUE;
2976: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.POSTPROCESSING_LEAD_TIME' THEN
2977: x_item_table(p_tab_index).POSTPROCESSING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2978: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PREPROCESSING_LEAD_TIME' THEN
2979: x_item_table(p_tab_index).PREPROCESSING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2980: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PRICE_TOLERANCE_PERCENT' THEN
2974: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.POSITIVE_MEASUREMENT_ERROR' THEN
2975: x_item_table(p_tab_index).POSITIVE_MEASUREMENT_ERROR := cr.ATTRIBUTE_VALUE;
2976: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.POSTPROCESSING_LEAD_TIME' THEN
2977: x_item_table(p_tab_index).POSTPROCESSING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2978: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PREPROCESSING_LEAD_TIME' THEN
2979: x_item_table(p_tab_index).PREPROCESSING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2980: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PRICE_TOLERANCE_PERCENT' THEN
2981: x_item_table(p_tab_index).PRICE_TOLERANCE_PERCENT := cr.ATTRIBUTE_VALUE;
2982: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
2976: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.POSTPROCESSING_LEAD_TIME' THEN
2977: x_item_table(p_tab_index).POSTPROCESSING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2978: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PREPROCESSING_LEAD_TIME' THEN
2979: x_item_table(p_tab_index).PREPROCESSING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2980: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PRICE_TOLERANCE_PERCENT' THEN
2981: x_item_table(p_tab_index).PRICE_TOLERANCE_PERCENT := cr.ATTRIBUTE_VALUE;
2982: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
2983: x_item_table(p_tab_index).PURCHASING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2984: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_ITEM_FLAG' THEN
2978: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PREPROCESSING_LEAD_TIME' THEN
2979: x_item_table(p_tab_index).PREPROCESSING_LEAD_TIME := cr.ATTRIBUTE_VALUE;
2980: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PRICE_TOLERANCE_PERCENT' THEN
2981: x_item_table(p_tab_index).PRICE_TOLERANCE_PERCENT := cr.ATTRIBUTE_VALUE;
2982: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
2983: x_item_table(p_tab_index).PURCHASING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2984: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_ITEM_FLAG' THEN
2985: x_item_table(p_tab_index).PURCHASING_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2986: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.QTY_RCV_EXCEPTION_CODE' THEN
2980: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PRICE_TOLERANCE_PERCENT' THEN
2981: x_item_table(p_tab_index).PRICE_TOLERANCE_PERCENT := cr.ATTRIBUTE_VALUE;
2982: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
2983: x_item_table(p_tab_index).PURCHASING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2984: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_ITEM_FLAG' THEN
2985: x_item_table(p_tab_index).PURCHASING_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2986: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.QTY_RCV_EXCEPTION_CODE' THEN
2987: x_item_table(p_tab_index).QTY_RCV_EXCEPTION_CODE := cr.ATTRIBUTE_VALUE;
2988: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.QTY_RCV_TOLERANCE' THEN
2982: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
2983: x_item_table(p_tab_index).PURCHASING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
2984: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_ITEM_FLAG' THEN
2985: x_item_table(p_tab_index).PURCHASING_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2986: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.QTY_RCV_EXCEPTION_CODE' THEN
2987: x_item_table(p_tab_index).QTY_RCV_EXCEPTION_CODE := cr.ATTRIBUTE_VALUE;
2988: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.QTY_RCV_TOLERANCE' THEN
2989: x_item_table(p_tab_index).QTY_RCV_TOLERANCE := cr.ATTRIBUTE_VALUE;
2990: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIPT_DAYS_EXCEPTION_CODE' THEN
2984: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_ITEM_FLAG' THEN
2985: x_item_table(p_tab_index).PURCHASING_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
2986: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.QTY_RCV_EXCEPTION_CODE' THEN
2987: x_item_table(p_tab_index).QTY_RCV_EXCEPTION_CODE := cr.ATTRIBUTE_VALUE;
2988: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.QTY_RCV_TOLERANCE' THEN
2989: x_item_table(p_tab_index).QTY_RCV_TOLERANCE := cr.ATTRIBUTE_VALUE;
2990: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIPT_DAYS_EXCEPTION_CODE' THEN
2991: x_item_table(p_tab_index).RECEIPT_DAYS_EXCEPTION_CODE := cr.ATTRIBUTE_VALUE;
2992: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIPT_REQUIRED_FLAG' THEN
2986: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.QTY_RCV_EXCEPTION_CODE' THEN
2987: x_item_table(p_tab_index).QTY_RCV_EXCEPTION_CODE := cr.ATTRIBUTE_VALUE;
2988: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.QTY_RCV_TOLERANCE' THEN
2989: x_item_table(p_tab_index).QTY_RCV_TOLERANCE := cr.ATTRIBUTE_VALUE;
2990: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIPT_DAYS_EXCEPTION_CODE' THEN
2991: x_item_table(p_tab_index).RECEIPT_DAYS_EXCEPTION_CODE := cr.ATTRIBUTE_VALUE;
2992: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIPT_REQUIRED_FLAG' THEN
2993: x_item_table(p_tab_index).RECEIPT_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
2994: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIVE_CLOSE_TOLERANCE' THEN
2988: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.QTY_RCV_TOLERANCE' THEN
2989: x_item_table(p_tab_index).QTY_RCV_TOLERANCE := cr.ATTRIBUTE_VALUE;
2990: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIPT_DAYS_EXCEPTION_CODE' THEN
2991: x_item_table(p_tab_index).RECEIPT_DAYS_EXCEPTION_CODE := cr.ATTRIBUTE_VALUE;
2992: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIPT_REQUIRED_FLAG' THEN
2993: x_item_table(p_tab_index).RECEIPT_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
2994: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIVE_CLOSE_TOLERANCE' THEN
2995: x_item_table(p_tab_index).RECEIVE_CLOSE_TOLERANCE := cr.ATTRIBUTE_VALUE;
2996: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIVING_ROUTING_ID' THEN
2990: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIPT_DAYS_EXCEPTION_CODE' THEN
2991: x_item_table(p_tab_index).RECEIPT_DAYS_EXCEPTION_CODE := cr.ATTRIBUTE_VALUE;
2992: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIPT_REQUIRED_FLAG' THEN
2993: x_item_table(p_tab_index).RECEIPT_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
2994: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIVE_CLOSE_TOLERANCE' THEN
2995: x_item_table(p_tab_index).RECEIVE_CLOSE_TOLERANCE := cr.ATTRIBUTE_VALUE;
2996: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIVING_ROUTING_ID' THEN
2997: x_item_table(p_tab_index).RECEIVING_ROUTING_ID := cr.ATTRIBUTE_VALUE;
2998: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPETITIVE_PLANNING_FLAG' THEN
2992: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIPT_REQUIRED_FLAG' THEN
2993: x_item_table(p_tab_index).RECEIPT_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
2994: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIVE_CLOSE_TOLERANCE' THEN
2995: x_item_table(p_tab_index).RECEIVE_CLOSE_TOLERANCE := cr.ATTRIBUTE_VALUE;
2996: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIVING_ROUTING_ID' THEN
2997: x_item_table(p_tab_index).RECEIVING_ROUTING_ID := cr.ATTRIBUTE_VALUE;
2998: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPETITIVE_PLANNING_FLAG' THEN
2999: x_item_table(p_tab_index).REPETITIVE_PLANNING_FLAG := cr.ATTRIBUTE_VALUE;
3000: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG' THEN
2994: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIVE_CLOSE_TOLERANCE' THEN
2995: x_item_table(p_tab_index).RECEIVE_CLOSE_TOLERANCE := cr.ATTRIBUTE_VALUE;
2996: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIVING_ROUTING_ID' THEN
2997: x_item_table(p_tab_index).RECEIVING_ROUTING_ID := cr.ATTRIBUTE_VALUE;
2998: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPETITIVE_PLANNING_FLAG' THEN
2999: x_item_table(p_tab_index).REPETITIVE_PLANNING_FLAG := cr.ATTRIBUTE_VALUE;
3000: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG' THEN
3001: x_item_table(p_tab_index).REPLENISH_TO_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
3002: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESERVABLE_TYPE' THEN
2996: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECEIVING_ROUTING_ID' THEN
2997: x_item_table(p_tab_index).RECEIVING_ROUTING_ID := cr.ATTRIBUTE_VALUE;
2998: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPETITIVE_PLANNING_FLAG' THEN
2999: x_item_table(p_tab_index).REPETITIVE_PLANNING_FLAG := cr.ATTRIBUTE_VALUE;
3000: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG' THEN
3001: x_item_table(p_tab_index).REPLENISH_TO_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
3002: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESERVABLE_TYPE' THEN
3003: x_item_table(p_tab_index).RESERVABLE_TYPE := cr.ATTRIBUTE_VALUE;
3004: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESTRICT_LOCATORS_CODE' THEN
2998: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPETITIVE_PLANNING_FLAG' THEN
2999: x_item_table(p_tab_index).REPETITIVE_PLANNING_FLAG := cr.ATTRIBUTE_VALUE;
3000: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG' THEN
3001: x_item_table(p_tab_index).REPLENISH_TO_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
3002: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESERVABLE_TYPE' THEN
3003: x_item_table(p_tab_index).RESERVABLE_TYPE := cr.ATTRIBUTE_VALUE;
3004: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESTRICT_LOCATORS_CODE' THEN
3005: x_item_table(p_tab_index).RESTRICT_LOCATORS_CODE := cr.ATTRIBUTE_VALUE;
3006: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE' THEN
3000: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG' THEN
3001: x_item_table(p_tab_index).REPLENISH_TO_ORDER_FLAG := cr.ATTRIBUTE_VALUE;
3002: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESERVABLE_TYPE' THEN
3003: x_item_table(p_tab_index).RESERVABLE_TYPE := cr.ATTRIBUTE_VALUE;
3004: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESTRICT_LOCATORS_CODE' THEN
3005: x_item_table(p_tab_index).RESTRICT_LOCATORS_CODE := cr.ATTRIBUTE_VALUE;
3006: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE' THEN
3007: x_item_table(p_tab_index).RESTRICT_SUBINVENTORIES_CODE := cr.ATTRIBUTE_VALUE;
3008: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETURNABLE_FLAG' THEN
3002: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESERVABLE_TYPE' THEN
3003: x_item_table(p_tab_index).RESERVABLE_TYPE := cr.ATTRIBUTE_VALUE;
3004: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESTRICT_LOCATORS_CODE' THEN
3005: x_item_table(p_tab_index).RESTRICT_LOCATORS_CODE := cr.ATTRIBUTE_VALUE;
3006: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE' THEN
3007: x_item_table(p_tab_index).RESTRICT_SUBINVENTORIES_CODE := cr.ATTRIBUTE_VALUE;
3008: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETURNABLE_FLAG' THEN
3009: x_item_table(p_tab_index).RETURNABLE_FLAG := cr.ATTRIBUTE_VALUE;
3010: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETURN_INSPECTION_REQUIREMENT' THEN
3004: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESTRICT_LOCATORS_CODE' THEN
3005: x_item_table(p_tab_index).RESTRICT_LOCATORS_CODE := cr.ATTRIBUTE_VALUE;
3006: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE' THEN
3007: x_item_table(p_tab_index).RESTRICT_SUBINVENTORIES_CODE := cr.ATTRIBUTE_VALUE;
3008: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETURNABLE_FLAG' THEN
3009: x_item_table(p_tab_index).RETURNABLE_FLAG := cr.ATTRIBUTE_VALUE;
3010: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETURN_INSPECTION_REQUIREMENT' THEN
3011: x_item_table(p_tab_index).RETURN_INSPECTION_REQUIREMENT := cr.ATTRIBUTE_VALUE;
3012: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE' THEN
3006: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE' THEN
3007: x_item_table(p_tab_index).RESTRICT_SUBINVENTORIES_CODE := cr.ATTRIBUTE_VALUE;
3008: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETURNABLE_FLAG' THEN
3009: x_item_table(p_tab_index).RETURNABLE_FLAG := cr.ATTRIBUTE_VALUE;
3010: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETURN_INSPECTION_REQUIREMENT' THEN
3011: x_item_table(p_tab_index).RETURN_INSPECTION_REQUIREMENT := cr.ATTRIBUTE_VALUE;
3012: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE' THEN
3013: x_item_table(p_tab_index).REVISION_QTY_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
3014: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RFQ_REQUIRED_FLAG' THEN
3008: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETURNABLE_FLAG' THEN
3009: x_item_table(p_tab_index).RETURNABLE_FLAG := cr.ATTRIBUTE_VALUE;
3010: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETURN_INSPECTION_REQUIREMENT' THEN
3011: x_item_table(p_tab_index).RETURN_INSPECTION_REQUIREMENT := cr.ATTRIBUTE_VALUE;
3012: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE' THEN
3013: x_item_table(p_tab_index).REVISION_QTY_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
3014: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RFQ_REQUIRED_FLAG' THEN
3015: x_item_table(p_tab_index).RFQ_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
3016: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ROUNDING_CONTROL_TYPE' THEN
3010: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETURN_INSPECTION_REQUIREMENT' THEN
3011: x_item_table(p_tab_index).RETURN_INSPECTION_REQUIREMENT := cr.ATTRIBUTE_VALUE;
3012: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE' THEN
3013: x_item_table(p_tab_index).REVISION_QTY_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
3014: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RFQ_REQUIRED_FLAG' THEN
3015: x_item_table(p_tab_index).RFQ_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
3016: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ROUNDING_CONTROL_TYPE' THEN
3017: x_item_table(p_tab_index).ROUNDING_CONTROL_TYPE := cr.ATTRIBUTE_VALUE;
3018: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ROUNDING_FACTOR' THEN
3012: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE' THEN
3013: x_item_table(p_tab_index).REVISION_QTY_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
3014: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RFQ_REQUIRED_FLAG' THEN
3015: x_item_table(p_tab_index).RFQ_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
3016: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ROUNDING_CONTROL_TYPE' THEN
3017: x_item_table(p_tab_index).ROUNDING_CONTROL_TYPE := cr.ATTRIBUTE_VALUE;
3018: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ROUNDING_FACTOR' THEN
3019: x_item_table(p_tab_index).ROUNDING_FACTOR := cr.ATTRIBUTE_VALUE;
3020: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SAFETY_STOCK_BUCKET_DAYS' THEN
3014: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RFQ_REQUIRED_FLAG' THEN
3015: x_item_table(p_tab_index).RFQ_REQUIRED_FLAG := cr.ATTRIBUTE_VALUE;
3016: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ROUNDING_CONTROL_TYPE' THEN
3017: x_item_table(p_tab_index).ROUNDING_CONTROL_TYPE := cr.ATTRIBUTE_VALUE;
3018: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ROUNDING_FACTOR' THEN
3019: x_item_table(p_tab_index).ROUNDING_FACTOR := cr.ATTRIBUTE_VALUE;
3020: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SAFETY_STOCK_BUCKET_DAYS' THEN
3021: x_item_table(p_tab_index).SAFETY_STOCK_BUCKET_DAYS := cr.ATTRIBUTE_VALUE;
3022: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE' THEN
3016: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ROUNDING_CONTROL_TYPE' THEN
3017: x_item_table(p_tab_index).ROUNDING_CONTROL_TYPE := cr.ATTRIBUTE_VALUE;
3018: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ROUNDING_FACTOR' THEN
3019: x_item_table(p_tab_index).ROUNDING_FACTOR := cr.ATTRIBUTE_VALUE;
3020: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SAFETY_STOCK_BUCKET_DAYS' THEN
3021: x_item_table(p_tab_index).SAFETY_STOCK_BUCKET_DAYS := cr.ATTRIBUTE_VALUE;
3022: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE' THEN
3023: x_item_table(p_tab_index).SERIAL_NUMBER_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
3024: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICEABLE_PRODUCT_FLAG' THEN
3018: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ROUNDING_FACTOR' THEN
3019: x_item_table(p_tab_index).ROUNDING_FACTOR := cr.ATTRIBUTE_VALUE;
3020: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SAFETY_STOCK_BUCKET_DAYS' THEN
3021: x_item_table(p_tab_index).SAFETY_STOCK_BUCKET_DAYS := cr.ATTRIBUTE_VALUE;
3022: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE' THEN
3023: x_item_table(p_tab_index).SERIAL_NUMBER_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
3024: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICEABLE_PRODUCT_FLAG' THEN
3025: x_item_table(p_tab_index).SERVICEABLE_PRODUCT_FLAG := cr.ATTRIBUTE_VALUE;
3026: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_DURATION' THEN
3020: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SAFETY_STOCK_BUCKET_DAYS' THEN
3021: x_item_table(p_tab_index).SAFETY_STOCK_BUCKET_DAYS := cr.ATTRIBUTE_VALUE;
3022: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE' THEN
3023: x_item_table(p_tab_index).SERIAL_NUMBER_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
3024: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICEABLE_PRODUCT_FLAG' THEN
3025: x_item_table(p_tab_index).SERVICEABLE_PRODUCT_FLAG := cr.ATTRIBUTE_VALUE;
3026: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_DURATION' THEN
3027: x_item_table(p_tab_index).SERVICE_DURATION := cr.ATTRIBUTE_VALUE;
3028: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_DURATION_PERIOD_CODE' THEN
3022: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE' THEN
3023: x_item_table(p_tab_index).SERIAL_NUMBER_CONTROL_CODE := cr.ATTRIBUTE_VALUE;
3024: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICEABLE_PRODUCT_FLAG' THEN
3025: x_item_table(p_tab_index).SERVICEABLE_PRODUCT_FLAG := cr.ATTRIBUTE_VALUE;
3026: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_DURATION' THEN
3027: x_item_table(p_tab_index).SERVICE_DURATION := cr.ATTRIBUTE_VALUE;
3028: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_DURATION_PERIOD_CODE' THEN
3029: x_item_table(p_tab_index).SERVICE_DURATION_PERIOD_CODE := cr.ATTRIBUTE_VALUE;
3030: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_STARTING_DELAY' THEN
3024: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICEABLE_PRODUCT_FLAG' THEN
3025: x_item_table(p_tab_index).SERVICEABLE_PRODUCT_FLAG := cr.ATTRIBUTE_VALUE;
3026: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_DURATION' THEN
3027: x_item_table(p_tab_index).SERVICE_DURATION := cr.ATTRIBUTE_VALUE;
3028: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_DURATION_PERIOD_CODE' THEN
3029: x_item_table(p_tab_index).SERVICE_DURATION_PERIOD_CODE := cr.ATTRIBUTE_VALUE;
3030: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_STARTING_DELAY' THEN
3031: x_item_table(p_tab_index).SERVICE_STARTING_DELAY := cr.ATTRIBUTE_VALUE;
3032: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHELF_LIFE_CODE' THEN
3026: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_DURATION' THEN
3027: x_item_table(p_tab_index).SERVICE_DURATION := cr.ATTRIBUTE_VALUE;
3028: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_DURATION_PERIOD_CODE' THEN
3029: x_item_table(p_tab_index).SERVICE_DURATION_PERIOD_CODE := cr.ATTRIBUTE_VALUE;
3030: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_STARTING_DELAY' THEN
3031: x_item_table(p_tab_index).SERVICE_STARTING_DELAY := cr.ATTRIBUTE_VALUE;
3032: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHELF_LIFE_CODE' THEN
3033: x_item_table(p_tab_index).SHELF_LIFE_CODE := cr.ATTRIBUTE_VALUE;
3034: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS' THEN
3028: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_DURATION_PERIOD_CODE' THEN
3029: x_item_table(p_tab_index).SERVICE_DURATION_PERIOD_CODE := cr.ATTRIBUTE_VALUE;
3030: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_STARTING_DELAY' THEN
3031: x_item_table(p_tab_index).SERVICE_STARTING_DELAY := cr.ATTRIBUTE_VALUE;
3032: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHELF_LIFE_CODE' THEN
3033: x_item_table(p_tab_index).SHELF_LIFE_CODE := cr.ATTRIBUTE_VALUE;
3034: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS' THEN
3035: x_item_table(p_tab_index).SHELF_LIFE_DAYS := cr.ATTRIBUTE_VALUE;
3036: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG' THEN
3030: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERVICE_STARTING_DELAY' THEN
3031: x_item_table(p_tab_index).SERVICE_STARTING_DELAY := cr.ATTRIBUTE_VALUE;
3032: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHELF_LIFE_CODE' THEN
3033: x_item_table(p_tab_index).SHELF_LIFE_CODE := cr.ATTRIBUTE_VALUE;
3034: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS' THEN
3035: x_item_table(p_tab_index).SHELF_LIFE_DAYS := cr.ATTRIBUTE_VALUE;
3036: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG' THEN
3037: x_item_table(p_tab_index).SHIPPABLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3038: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHIP_MODEL_COMPLETE_FLAG' THEN
3032: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHELF_LIFE_CODE' THEN
3033: x_item_table(p_tab_index).SHELF_LIFE_CODE := cr.ATTRIBUTE_VALUE;
3034: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS' THEN
3035: x_item_table(p_tab_index).SHELF_LIFE_DAYS := cr.ATTRIBUTE_VALUE;
3036: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG' THEN
3037: x_item_table(p_tab_index).SHIPPABLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3038: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHIP_MODEL_COMPLETE_FLAG' THEN
3039: x_item_table(p_tab_index).SHIP_MODEL_COMPLETE_FLAG := cr.ATTRIBUTE_VALUE;
3040: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHRINKAGE_RATE' THEN
3034: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHELF_LIFE_DAYS' THEN
3035: x_item_table(p_tab_index).SHELF_LIFE_DAYS := cr.ATTRIBUTE_VALUE;
3036: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG' THEN
3037: x_item_table(p_tab_index).SHIPPABLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3038: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHIP_MODEL_COMPLETE_FLAG' THEN
3039: x_item_table(p_tab_index).SHIP_MODEL_COMPLETE_FLAG := cr.ATTRIBUTE_VALUE;
3040: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHRINKAGE_RATE' THEN
3041: x_item_table(p_tab_index).SHRINKAGE_RATE := cr.ATTRIBUTE_VALUE;
3042: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_ORGANIZATION_ID' THEN
3036: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHIPPABLE_ITEM_FLAG' THEN
3037: x_item_table(p_tab_index).SHIPPABLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3038: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHIP_MODEL_COMPLETE_FLAG' THEN
3039: x_item_table(p_tab_index).SHIP_MODEL_COMPLETE_FLAG := cr.ATTRIBUTE_VALUE;
3040: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHRINKAGE_RATE' THEN
3041: x_item_table(p_tab_index).SHRINKAGE_RATE := cr.ATTRIBUTE_VALUE;
3042: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_ORGANIZATION_ID' THEN
3043: x_item_table(p_tab_index).SOURCE_ORGANIZATION_ID := cr.ATTRIBUTE_VALUE;
3044: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_SUBINVENTORY' THEN
3038: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHIP_MODEL_COMPLETE_FLAG' THEN
3039: x_item_table(p_tab_index).SHIP_MODEL_COMPLETE_FLAG := cr.ATTRIBUTE_VALUE;
3040: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHRINKAGE_RATE' THEN
3041: x_item_table(p_tab_index).SHRINKAGE_RATE := cr.ATTRIBUTE_VALUE;
3042: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_ORGANIZATION_ID' THEN
3043: x_item_table(p_tab_index).SOURCE_ORGANIZATION_ID := cr.ATTRIBUTE_VALUE;
3044: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_SUBINVENTORY' THEN
3045: x_item_table(p_tab_index).SOURCE_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3046: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_TYPE' THEN
3040: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SHRINKAGE_RATE' THEN
3041: x_item_table(p_tab_index).SHRINKAGE_RATE := cr.ATTRIBUTE_VALUE;
3042: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_ORGANIZATION_ID' THEN
3043: x_item_table(p_tab_index).SOURCE_ORGANIZATION_ID := cr.ATTRIBUTE_VALUE;
3044: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_SUBINVENTORY' THEN
3045: x_item_table(p_tab_index).SOURCE_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3046: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_TYPE' THEN
3047: x_item_table(p_tab_index).SOURCE_TYPE := cr.ATTRIBUTE_VALUE;
3048: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SO_TRANSACTIONS_FLAG' THEN
3042: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_ORGANIZATION_ID' THEN
3043: x_item_table(p_tab_index).SOURCE_ORGANIZATION_ID := cr.ATTRIBUTE_VALUE;
3044: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_SUBINVENTORY' THEN
3045: x_item_table(p_tab_index).SOURCE_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3046: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_TYPE' THEN
3047: x_item_table(p_tab_index).SOURCE_TYPE := cr.ATTRIBUTE_VALUE;
3048: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SO_TRANSACTIONS_FLAG' THEN
3049: x_item_table(p_tab_index).SO_TRANSACTIONS_FLAG := cr.ATTRIBUTE_VALUE;
3050: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER' THEN
3044: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_SUBINVENTORY' THEN
3045: x_item_table(p_tab_index).SOURCE_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3046: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_TYPE' THEN
3047: x_item_table(p_tab_index).SOURCE_TYPE := cr.ATTRIBUTE_VALUE;
3048: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SO_TRANSACTIONS_FLAG' THEN
3049: x_item_table(p_tab_index).SO_TRANSACTIONS_FLAG := cr.ATTRIBUTE_VALUE;
3050: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER' THEN
3051: x_item_table(p_tab_index).START_AUTO_LOT_NUMBER := cr.ATTRIBUTE_VALUE;
3052: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.START_AUTO_SERIAL_NUMBER' THEN
3046: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SOURCE_TYPE' THEN
3047: x_item_table(p_tab_index).SOURCE_TYPE := cr.ATTRIBUTE_VALUE;
3048: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SO_TRANSACTIONS_FLAG' THEN
3049: x_item_table(p_tab_index).SO_TRANSACTIONS_FLAG := cr.ATTRIBUTE_VALUE;
3050: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER' THEN
3051: x_item_table(p_tab_index).START_AUTO_LOT_NUMBER := cr.ATTRIBUTE_VALUE;
3052: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.START_AUTO_SERIAL_NUMBER' THEN
3053: x_item_table(p_tab_index).START_AUTO_SERIAL_NUMBER := cr.ATTRIBUTE_VALUE;
3054: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.STD_LOT_SIZE' THEN
3048: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SO_TRANSACTIONS_FLAG' THEN
3049: x_item_table(p_tab_index).SO_TRANSACTIONS_FLAG := cr.ATTRIBUTE_VALUE;
3050: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER' THEN
3051: x_item_table(p_tab_index).START_AUTO_LOT_NUMBER := cr.ATTRIBUTE_VALUE;
3052: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.START_AUTO_SERIAL_NUMBER' THEN
3053: x_item_table(p_tab_index).START_AUTO_SERIAL_NUMBER := cr.ATTRIBUTE_VALUE;
3054: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.STD_LOT_SIZE' THEN
3055: x_item_table(p_tab_index).STD_LOT_SIZE := cr.ATTRIBUTE_VALUE;
3056: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
3050: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER' THEN
3051: x_item_table(p_tab_index).START_AUTO_LOT_NUMBER := cr.ATTRIBUTE_VALUE;
3052: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.START_AUTO_SERIAL_NUMBER' THEN
3053: x_item_table(p_tab_index).START_AUTO_SERIAL_NUMBER := cr.ATTRIBUTE_VALUE;
3054: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.STD_LOT_SIZE' THEN
3055: x_item_table(p_tab_index).STD_LOT_SIZE := cr.ATTRIBUTE_VALUE;
3056: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
3057: x_item_table(p_tab_index).STOCK_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3058: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TAXABLE_FLAG' THEN
3052: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.START_AUTO_SERIAL_NUMBER' THEN
3053: x_item_table(p_tab_index).START_AUTO_SERIAL_NUMBER := cr.ATTRIBUTE_VALUE;
3054: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.STD_LOT_SIZE' THEN
3055: x_item_table(p_tab_index).STD_LOT_SIZE := cr.ATTRIBUTE_VALUE;
3056: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
3057: x_item_table(p_tab_index).STOCK_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3058: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TAXABLE_FLAG' THEN
3059: x_item_table(p_tab_index).TAXABLE_FLAG := cr.ATTRIBUTE_VALUE;
3060: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_TAX_CODE' THEN
3054: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.STD_LOT_SIZE' THEN
3055: x_item_table(p_tab_index).STD_LOT_SIZE := cr.ATTRIBUTE_VALUE;
3056: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
3057: x_item_table(p_tab_index).STOCK_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3058: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TAXABLE_FLAG' THEN
3059: x_item_table(p_tab_index).TAXABLE_FLAG := cr.ATTRIBUTE_VALUE;
3060: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_TAX_CODE' THEN
3061: x_item_table(p_tab_index).PURCHASING_TAX_CODE := cr.ATTRIBUTE_VALUE;
3062: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TAX_CODE' THEN
3056: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
3057: x_item_table(p_tab_index).STOCK_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3058: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TAXABLE_FLAG' THEN
3059: x_item_table(p_tab_index).TAXABLE_FLAG := cr.ATTRIBUTE_VALUE;
3060: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_TAX_CODE' THEN
3061: x_item_table(p_tab_index).PURCHASING_TAX_CODE := cr.ATTRIBUTE_VALUE;
3062: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TAX_CODE' THEN
3063: x_item_table(p_tab_index).TAX_CODE := cr.ATTRIBUTE_VALUE;
3064: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_OF_ISSUE' THEN
3058: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TAXABLE_FLAG' THEN
3059: x_item_table(p_tab_index).TAXABLE_FLAG := cr.ATTRIBUTE_VALUE;
3060: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_TAX_CODE' THEN
3061: x_item_table(p_tab_index).PURCHASING_TAX_CODE := cr.ATTRIBUTE_VALUE;
3062: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TAX_CODE' THEN
3063: x_item_table(p_tab_index).TAX_CODE := cr.ATTRIBUTE_VALUE;
3064: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_OF_ISSUE' THEN
3065: x_item_table(p_tab_index).UNIT_OF_ISSUE := cr.ATTRIBUTE_VALUE;
3066: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_VOLUME' THEN
3060: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PURCHASING_TAX_CODE' THEN
3061: x_item_table(p_tab_index).PURCHASING_TAX_CODE := cr.ATTRIBUTE_VALUE;
3062: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TAX_CODE' THEN
3063: x_item_table(p_tab_index).TAX_CODE := cr.ATTRIBUTE_VALUE;
3064: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_OF_ISSUE' THEN
3065: x_item_table(p_tab_index).UNIT_OF_ISSUE := cr.ATTRIBUTE_VALUE;
3066: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_VOLUME' THEN
3067: x_item_table(p_tab_index).UNIT_VOLUME := cr.ATTRIBUTE_VALUE;
3068: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WEIGHT' THEN
3062: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TAX_CODE' THEN
3063: x_item_table(p_tab_index).TAX_CODE := cr.ATTRIBUTE_VALUE;
3064: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_OF_ISSUE' THEN
3065: x_item_table(p_tab_index).UNIT_OF_ISSUE := cr.ATTRIBUTE_VALUE;
3066: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_VOLUME' THEN
3067: x_item_table(p_tab_index).UNIT_VOLUME := cr.ATTRIBUTE_VALUE;
3068: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WEIGHT' THEN
3069: x_item_table(p_tab_index).UNIT_WEIGHT := cr.ATTRIBUTE_VALUE;
3070: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UN_NUMBER_ID' THEN
3064: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_OF_ISSUE' THEN
3065: x_item_table(p_tab_index).UNIT_OF_ISSUE := cr.ATTRIBUTE_VALUE;
3066: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_VOLUME' THEN
3067: x_item_table(p_tab_index).UNIT_VOLUME := cr.ATTRIBUTE_VALUE;
3068: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WEIGHT' THEN
3069: x_item_table(p_tab_index).UNIT_WEIGHT := cr.ATTRIBUTE_VALUE;
3070: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UN_NUMBER_ID' THEN
3071: x_item_table(p_tab_index).UN_NUMBER_ID := cr.ATTRIBUTE_VALUE;
3072: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VARIABLE_LEAD_TIME' THEN
3066: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_VOLUME' THEN
3067: x_item_table(p_tab_index).UNIT_VOLUME := cr.ATTRIBUTE_VALUE;
3068: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WEIGHT' THEN
3069: x_item_table(p_tab_index).UNIT_WEIGHT := cr.ATTRIBUTE_VALUE;
3070: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UN_NUMBER_ID' THEN
3071: x_item_table(p_tab_index).UN_NUMBER_ID := cr.ATTRIBUTE_VALUE;
3072: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VARIABLE_LEAD_TIME' THEN
3073: x_item_table(p_tab_index).VARIABLE_LEAD_TIME := cr.ATTRIBUTE_VALUE;
3074: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE' THEN
3068: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WEIGHT' THEN
3069: x_item_table(p_tab_index).UNIT_WEIGHT := cr.ATTRIBUTE_VALUE;
3070: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UN_NUMBER_ID' THEN
3071: x_item_table(p_tab_index).UN_NUMBER_ID := cr.ATTRIBUTE_VALUE;
3072: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VARIABLE_LEAD_TIME' THEN
3073: x_item_table(p_tab_index).VARIABLE_LEAD_TIME := cr.ATTRIBUTE_VALUE;
3074: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE' THEN
3075: x_item_table(p_tab_index).VOLUME_UOM_CODE := cr.ATTRIBUTE_VALUE;
3076: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE' THEN
3070: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UN_NUMBER_ID' THEN
3071: x_item_table(p_tab_index).UN_NUMBER_ID := cr.ATTRIBUTE_VALUE;
3072: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VARIABLE_LEAD_TIME' THEN
3073: x_item_table(p_tab_index).VARIABLE_LEAD_TIME := cr.ATTRIBUTE_VALUE;
3074: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE' THEN
3075: x_item_table(p_tab_index).VOLUME_UOM_CODE := cr.ATTRIBUTE_VALUE;
3076: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE' THEN
3077: x_item_table(p_tab_index).WEIGHT_UOM_CODE := cr.ATTRIBUTE_VALUE;
3078: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_TYPE' THEN
3072: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VARIABLE_LEAD_TIME' THEN
3073: x_item_table(p_tab_index).VARIABLE_LEAD_TIME := cr.ATTRIBUTE_VALUE;
3074: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE' THEN
3075: x_item_table(p_tab_index).VOLUME_UOM_CODE := cr.ATTRIBUTE_VALUE;
3076: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE' THEN
3077: x_item_table(p_tab_index).WEIGHT_UOM_CODE := cr.ATTRIBUTE_VALUE;
3078: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_TYPE' THEN
3079: x_item_table(p_tab_index).WIP_SUPPLY_TYPE := cr.ATTRIBUTE_VALUE;
3080: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATO_FORECAST_CONTROL' THEN
3074: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE' THEN
3075: x_item_table(p_tab_index).VOLUME_UOM_CODE := cr.ATTRIBUTE_VALUE;
3076: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE' THEN
3077: x_item_table(p_tab_index).WEIGHT_UOM_CODE := cr.ATTRIBUTE_VALUE;
3078: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_TYPE' THEN
3079: x_item_table(p_tab_index).WIP_SUPPLY_TYPE := cr.ATTRIBUTE_VALUE;
3080: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATO_FORECAST_CONTROL' THEN
3081: x_item_table(p_tab_index).ATO_FORECAST_CONTROL := cr.ATTRIBUTE_VALUE;
3082: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DESCRIPTION' THEN
3076: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE' THEN
3077: x_item_table(p_tab_index).WEIGHT_UOM_CODE := cr.ATTRIBUTE_VALUE;
3078: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_TYPE' THEN
3079: x_item_table(p_tab_index).WIP_SUPPLY_TYPE := cr.ATTRIBUTE_VALUE;
3080: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATO_FORECAST_CONTROL' THEN
3081: x_item_table(p_tab_index).ATO_FORECAST_CONTROL := cr.ATTRIBUTE_VALUE;
3082: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DESCRIPTION' THEN
3083: x_item_table(p_tab_index).DESCRIPTION := cr.ATTRIBUTE_VALUE;
3084: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RELEASE_TIME_FENCE_CODE' THEN
3078: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_TYPE' THEN
3079: x_item_table(p_tab_index).WIP_SUPPLY_TYPE := cr.ATTRIBUTE_VALUE;
3080: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATO_FORECAST_CONTROL' THEN
3081: x_item_table(p_tab_index).ATO_FORECAST_CONTROL := cr.ATTRIBUTE_VALUE;
3082: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DESCRIPTION' THEN
3083: x_item_table(p_tab_index).DESCRIPTION := cr.ATTRIBUTE_VALUE;
3084: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RELEASE_TIME_FENCE_CODE' THEN
3085: x_item_table(p_tab_index).RELEASE_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
3086: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RELEASE_TIME_FENCE_DAYS' THEN
3080: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ATO_FORECAST_CONTROL' THEN
3081: x_item_table(p_tab_index).ATO_FORECAST_CONTROL := cr.ATTRIBUTE_VALUE;
3082: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DESCRIPTION' THEN
3083: x_item_table(p_tab_index).DESCRIPTION := cr.ATTRIBUTE_VALUE;
3084: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RELEASE_TIME_FENCE_CODE' THEN
3085: x_item_table(p_tab_index).RELEASE_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
3086: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RELEASE_TIME_FENCE_DAYS' THEN
3087: x_item_table(p_tab_index).RELEASE_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
3088: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTAINER_ITEM_FLAG' THEN
3082: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DESCRIPTION' THEN
3083: x_item_table(p_tab_index).DESCRIPTION := cr.ATTRIBUTE_VALUE;
3084: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RELEASE_TIME_FENCE_CODE' THEN
3085: x_item_table(p_tab_index).RELEASE_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
3086: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RELEASE_TIME_FENCE_DAYS' THEN
3087: x_item_table(p_tab_index).RELEASE_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
3088: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTAINER_ITEM_FLAG' THEN
3089: x_item_table(p_tab_index).CONTAINER_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3090: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTAINER_TYPE_CODE' THEN
3084: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RELEASE_TIME_FENCE_CODE' THEN
3085: x_item_table(p_tab_index).RELEASE_TIME_FENCE_CODE := cr.ATTRIBUTE_VALUE;
3086: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RELEASE_TIME_FENCE_DAYS' THEN
3087: x_item_table(p_tab_index).RELEASE_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
3088: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTAINER_ITEM_FLAG' THEN
3089: x_item_table(p_tab_index).CONTAINER_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3090: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTAINER_TYPE_CODE' THEN
3091: x_item_table(p_tab_index).CONTAINER_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3092: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_VOLUME' THEN
3086: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RELEASE_TIME_FENCE_DAYS' THEN
3087: x_item_table(p_tab_index).RELEASE_TIME_FENCE_DAYS := cr.ATTRIBUTE_VALUE;
3088: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTAINER_ITEM_FLAG' THEN
3089: x_item_table(p_tab_index).CONTAINER_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3090: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTAINER_TYPE_CODE' THEN
3091: x_item_table(p_tab_index).CONTAINER_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3092: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_VOLUME' THEN
3093: x_item_table(p_tab_index).INTERNAL_VOLUME := cr.ATTRIBUTE_VALUE;
3094: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAXIMUM_LOAD_WEIGHT' THEN
3088: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTAINER_ITEM_FLAG' THEN
3089: x_item_table(p_tab_index).CONTAINER_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3090: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTAINER_TYPE_CODE' THEN
3091: x_item_table(p_tab_index).CONTAINER_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3092: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_VOLUME' THEN
3093: x_item_table(p_tab_index).INTERNAL_VOLUME := cr.ATTRIBUTE_VALUE;
3094: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAXIMUM_LOAD_WEIGHT' THEN
3095: x_item_table(p_tab_index).MAXIMUM_LOAD_WEIGHT := cr.ATTRIBUTE_VALUE;
3096: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_FILL_PERCENT' THEN
3090: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTAINER_TYPE_CODE' THEN
3091: x_item_table(p_tab_index).CONTAINER_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3092: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_VOLUME' THEN
3093: x_item_table(p_tab_index).INTERNAL_VOLUME := cr.ATTRIBUTE_VALUE;
3094: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAXIMUM_LOAD_WEIGHT' THEN
3095: x_item_table(p_tab_index).MAXIMUM_LOAD_WEIGHT := cr.ATTRIBUTE_VALUE;
3096: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_FILL_PERCENT' THEN
3097: x_item_table(p_tab_index).MINIMUM_FILL_PERCENT := cr.ATTRIBUTE_VALUE;
3098: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VEHICLE_ITEM_FLAG' THEN
3092: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INTERNAL_VOLUME' THEN
3093: x_item_table(p_tab_index).INTERNAL_VOLUME := cr.ATTRIBUTE_VALUE;
3094: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAXIMUM_LOAD_WEIGHT' THEN
3095: x_item_table(p_tab_index).MAXIMUM_LOAD_WEIGHT := cr.ATTRIBUTE_VALUE;
3096: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_FILL_PERCENT' THEN
3097: x_item_table(p_tab_index).MINIMUM_FILL_PERCENT := cr.ATTRIBUTE_VALUE;
3098: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VEHICLE_ITEM_FLAG' THEN
3099: x_item_table(p_tab_index).VEHICLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3100: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHECK_SHORTAGES_FLAG' THEN
3094: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MAXIMUM_LOAD_WEIGHT' THEN
3095: x_item_table(p_tab_index).MAXIMUM_LOAD_WEIGHT := cr.ATTRIBUTE_VALUE;
3096: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_FILL_PERCENT' THEN
3097: x_item_table(p_tab_index).MINIMUM_FILL_PERCENT := cr.ATTRIBUTE_VALUE;
3098: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VEHICLE_ITEM_FLAG' THEN
3099: x_item_table(p_tab_index).VEHICLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3100: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHECK_SHORTAGES_FLAG' THEN
3101: x_item_table(p_tab_index).CHECK_SHORTAGES_FLAG := cr.ATTRIBUTE_VALUE;
3102: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EFFECTIVITY_CONTROL' THEN
3096: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_FILL_PERCENT' THEN
3097: x_item_table(p_tab_index).MINIMUM_FILL_PERCENT := cr.ATTRIBUTE_VALUE;
3098: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VEHICLE_ITEM_FLAG' THEN
3099: x_item_table(p_tab_index).VEHICLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3100: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHECK_SHORTAGES_FLAG' THEN
3101: x_item_table(p_tab_index).CHECK_SHORTAGES_FLAG := cr.ATTRIBUTE_VALUE;
3102: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EFFECTIVITY_CONTROL' THEN
3103: x_item_table(p_tab_index).EFFECTIVITY_CONTROL := cr.ATTRIBUTE_VALUE;
3104: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_TYPE' THEN
3098: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VEHICLE_ITEM_FLAG' THEN
3099: x_item_table(p_tab_index).VEHICLE_ITEM_FLAG := cr.ATTRIBUTE_VALUE;
3100: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHECK_SHORTAGES_FLAG' THEN
3101: x_item_table(p_tab_index).CHECK_SHORTAGES_FLAG := cr.ATTRIBUTE_VALUE;
3102: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EFFECTIVITY_CONTROL' THEN
3103: x_item_table(p_tab_index).EFFECTIVITY_CONTROL := cr.ATTRIBUTE_VALUE;
3104: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_TYPE' THEN
3105: x_item_table(p_tab_index).OVERCOMPLETION_TOLERANCE_TYPE := cr.ATTRIBUTE_VALUE;
3106: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_VALUE' THEN
3100: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHECK_SHORTAGES_FLAG' THEN
3101: x_item_table(p_tab_index).CHECK_SHORTAGES_FLAG := cr.ATTRIBUTE_VALUE;
3102: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EFFECTIVITY_CONTROL' THEN
3103: x_item_table(p_tab_index).EFFECTIVITY_CONTROL := cr.ATTRIBUTE_VALUE;
3104: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_TYPE' THEN
3105: x_item_table(p_tab_index).OVERCOMPLETION_TOLERANCE_TYPE := cr.ATTRIBUTE_VALUE;
3106: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_VALUE' THEN
3107: x_item_table(p_tab_index).OVERCOMPLETION_TOLERANCE_VALUE := cr.ATTRIBUTE_VALUE;
3108: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVER_SHIPMENT_TOLERANCE' THEN
3102: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EFFECTIVITY_CONTROL' THEN
3103: x_item_table(p_tab_index).EFFECTIVITY_CONTROL := cr.ATTRIBUTE_VALUE;
3104: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_TYPE' THEN
3105: x_item_table(p_tab_index).OVERCOMPLETION_TOLERANCE_TYPE := cr.ATTRIBUTE_VALUE;
3106: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_VALUE' THEN
3107: x_item_table(p_tab_index).OVERCOMPLETION_TOLERANCE_VALUE := cr.ATTRIBUTE_VALUE;
3108: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVER_SHIPMENT_TOLERANCE' THEN
3109: x_item_table(p_tab_index).OVER_SHIPMENT_TOLERANCE := cr.ATTRIBUTE_VALUE;
3110: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNDER_SHIPMENT_TOLERANCE' THEN
3104: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_TYPE' THEN
3105: x_item_table(p_tab_index).OVERCOMPLETION_TOLERANCE_TYPE := cr.ATTRIBUTE_VALUE;
3106: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_VALUE' THEN
3107: x_item_table(p_tab_index).OVERCOMPLETION_TOLERANCE_VALUE := cr.ATTRIBUTE_VALUE;
3108: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVER_SHIPMENT_TOLERANCE' THEN
3109: x_item_table(p_tab_index).OVER_SHIPMENT_TOLERANCE := cr.ATTRIBUTE_VALUE;
3110: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNDER_SHIPMENT_TOLERANCE' THEN
3111: x_item_table(p_tab_index).UNDER_SHIPMENT_TOLERANCE := cr.ATTRIBUTE_VALUE;
3112: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVER_RETURN_TOLERANCE' THEN
3106: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_VALUE' THEN
3107: x_item_table(p_tab_index).OVERCOMPLETION_TOLERANCE_VALUE := cr.ATTRIBUTE_VALUE;
3108: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVER_SHIPMENT_TOLERANCE' THEN
3109: x_item_table(p_tab_index).OVER_SHIPMENT_TOLERANCE := cr.ATTRIBUTE_VALUE;
3110: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNDER_SHIPMENT_TOLERANCE' THEN
3111: x_item_table(p_tab_index).UNDER_SHIPMENT_TOLERANCE := cr.ATTRIBUTE_VALUE;
3112: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVER_RETURN_TOLERANCE' THEN
3113: x_item_table(p_tab_index).OVER_RETURN_TOLERANCE := cr.ATTRIBUTE_VALUE;
3114: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNDER_RETURN_TOLERANCE' THEN
3108: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVER_SHIPMENT_TOLERANCE' THEN
3109: x_item_table(p_tab_index).OVER_SHIPMENT_TOLERANCE := cr.ATTRIBUTE_VALUE;
3110: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNDER_SHIPMENT_TOLERANCE' THEN
3111: x_item_table(p_tab_index).UNDER_SHIPMENT_TOLERANCE := cr.ATTRIBUTE_VALUE;
3112: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVER_RETURN_TOLERANCE' THEN
3113: x_item_table(p_tab_index).OVER_RETURN_TOLERANCE := cr.ATTRIBUTE_VALUE;
3114: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNDER_RETURN_TOLERANCE' THEN
3115: x_item_table(p_tab_index).UNDER_RETURN_TOLERANCE := cr.ATTRIBUTE_VALUE;
3116: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EQUIPMENT_TYPE' THEN
3110: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNDER_SHIPMENT_TOLERANCE' THEN
3111: x_item_table(p_tab_index).UNDER_SHIPMENT_TOLERANCE := cr.ATTRIBUTE_VALUE;
3112: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVER_RETURN_TOLERANCE' THEN
3113: x_item_table(p_tab_index).OVER_RETURN_TOLERANCE := cr.ATTRIBUTE_VALUE;
3114: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNDER_RETURN_TOLERANCE' THEN
3115: x_item_table(p_tab_index).UNDER_RETURN_TOLERANCE := cr.ATTRIBUTE_VALUE;
3116: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EQUIPMENT_TYPE' THEN
3117: x_item_table(p_tab_index).EQUIPMENT_TYPE := cr.ATTRIBUTE_VALUE;
3118: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECOVERED_PART_DISP_CODE' THEN
3112: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OVER_RETURN_TOLERANCE' THEN
3113: x_item_table(p_tab_index).OVER_RETURN_TOLERANCE := cr.ATTRIBUTE_VALUE;
3114: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNDER_RETURN_TOLERANCE' THEN
3115: x_item_table(p_tab_index).UNDER_RETURN_TOLERANCE := cr.ATTRIBUTE_VALUE;
3116: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EQUIPMENT_TYPE' THEN
3117: x_item_table(p_tab_index).EQUIPMENT_TYPE := cr.ATTRIBUTE_VALUE;
3118: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECOVERED_PART_DISP_CODE' THEN
3119: x_item_table(p_tab_index).RECOVERED_PART_DISP_CODE := cr.ATTRIBUTE_VALUE;
3120: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFECT_TRACKING_ON_FLAG' THEN
3114: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNDER_RETURN_TOLERANCE' THEN
3115: x_item_table(p_tab_index).UNDER_RETURN_TOLERANCE := cr.ATTRIBUTE_VALUE;
3116: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EQUIPMENT_TYPE' THEN
3117: x_item_table(p_tab_index).EQUIPMENT_TYPE := cr.ATTRIBUTE_VALUE;
3118: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECOVERED_PART_DISP_CODE' THEN
3119: x_item_table(p_tab_index).RECOVERED_PART_DISP_CODE := cr.ATTRIBUTE_VALUE;
3120: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFECT_TRACKING_ON_FLAG' THEN
3121: x_item_table(p_tab_index).DEFECT_TRACKING_ON_FLAG := cr.ATTRIBUTE_VALUE;
3122: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EVENT_FLAG' THEN
3116: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EQUIPMENT_TYPE' THEN
3117: x_item_table(p_tab_index).EQUIPMENT_TYPE := cr.ATTRIBUTE_VALUE;
3118: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECOVERED_PART_DISP_CODE' THEN
3119: x_item_table(p_tab_index).RECOVERED_PART_DISP_CODE := cr.ATTRIBUTE_VALUE;
3120: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFECT_TRACKING_ON_FLAG' THEN
3121: x_item_table(p_tab_index).DEFECT_TRACKING_ON_FLAG := cr.ATTRIBUTE_VALUE;
3122: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EVENT_FLAG' THEN
3123: x_item_table(p_tab_index).EVENT_FLAG := cr.ATTRIBUTE_VALUE;
3124: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ELECTRONIC_FLAG' THEN
3118: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECOVERED_PART_DISP_CODE' THEN
3119: x_item_table(p_tab_index).RECOVERED_PART_DISP_CODE := cr.ATTRIBUTE_VALUE;
3120: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFECT_TRACKING_ON_FLAG' THEN
3121: x_item_table(p_tab_index).DEFECT_TRACKING_ON_FLAG := cr.ATTRIBUTE_VALUE;
3122: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EVENT_FLAG' THEN
3123: x_item_table(p_tab_index).EVENT_FLAG := cr.ATTRIBUTE_VALUE;
3124: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ELECTRONIC_FLAG' THEN
3125: x_item_table(p_tab_index).ELECTRONIC_FLAG := cr.ATTRIBUTE_VALUE;
3126: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DOWNLOADABLE_FLAG' THEN
3120: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFECT_TRACKING_ON_FLAG' THEN
3121: x_item_table(p_tab_index).DEFECT_TRACKING_ON_FLAG := cr.ATTRIBUTE_VALUE;
3122: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EVENT_FLAG' THEN
3123: x_item_table(p_tab_index).EVENT_FLAG := cr.ATTRIBUTE_VALUE;
3124: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ELECTRONIC_FLAG' THEN
3125: x_item_table(p_tab_index).ELECTRONIC_FLAG := cr.ATTRIBUTE_VALUE;
3126: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DOWNLOADABLE_FLAG' THEN
3127: x_item_table(p_tab_index).DOWNLOADABLE_FLAG := cr.ATTRIBUTE_VALUE;
3128: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VOL_DISCOUNT_EXEMPT_FLAG' THEN
3122: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EVENT_FLAG' THEN
3123: x_item_table(p_tab_index).EVENT_FLAG := cr.ATTRIBUTE_VALUE;
3124: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ELECTRONIC_FLAG' THEN
3125: x_item_table(p_tab_index).ELECTRONIC_FLAG := cr.ATTRIBUTE_VALUE;
3126: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DOWNLOADABLE_FLAG' THEN
3127: x_item_table(p_tab_index).DOWNLOADABLE_FLAG := cr.ATTRIBUTE_VALUE;
3128: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VOL_DISCOUNT_EXEMPT_FLAG' THEN
3129: x_item_table(p_tab_index).VOL_DISCOUNT_EXEMPT_FLAG := cr.ATTRIBUTE_VALUE;
3130: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COUPON_EXEMPT_FLAG' THEN
3124: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ELECTRONIC_FLAG' THEN
3125: x_item_table(p_tab_index).ELECTRONIC_FLAG := cr.ATTRIBUTE_VALUE;
3126: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DOWNLOADABLE_FLAG' THEN
3127: x_item_table(p_tab_index).DOWNLOADABLE_FLAG := cr.ATTRIBUTE_VALUE;
3128: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VOL_DISCOUNT_EXEMPT_FLAG' THEN
3129: x_item_table(p_tab_index).VOL_DISCOUNT_EXEMPT_FLAG := cr.ATTRIBUTE_VALUE;
3130: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COUPON_EXEMPT_FLAG' THEN
3131: x_item_table(p_tab_index).COUPON_EXEMPT_FLAG := cr.ATTRIBUTE_VALUE;
3132: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG' THEN
3126: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DOWNLOADABLE_FLAG' THEN
3127: x_item_table(p_tab_index).DOWNLOADABLE_FLAG := cr.ATTRIBUTE_VALUE;
3128: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VOL_DISCOUNT_EXEMPT_FLAG' THEN
3129: x_item_table(p_tab_index).VOL_DISCOUNT_EXEMPT_FLAG := cr.ATTRIBUTE_VALUE;
3130: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COUPON_EXEMPT_FLAG' THEN
3131: x_item_table(p_tab_index).COUPON_EXEMPT_FLAG := cr.ATTRIBUTE_VALUE;
3132: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG' THEN
3133: x_item_table(p_tab_index).COMMS_NL_TRACKABLE_FLAG := cr.ATTRIBUTE_VALUE;
3134: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CREATION_CODE' THEN
3128: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VOL_DISCOUNT_EXEMPT_FLAG' THEN
3129: x_item_table(p_tab_index).VOL_DISCOUNT_EXEMPT_FLAG := cr.ATTRIBUTE_VALUE;
3130: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COUPON_EXEMPT_FLAG' THEN
3131: x_item_table(p_tab_index).COUPON_EXEMPT_FLAG := cr.ATTRIBUTE_VALUE;
3132: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG' THEN
3133: x_item_table(p_tab_index).COMMS_NL_TRACKABLE_FLAG := cr.ATTRIBUTE_VALUE;
3134: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CREATION_CODE' THEN
3135: x_item_table(p_tab_index).ASSET_CREATION_CODE := cr.ATTRIBUTE_VALUE;
3136: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' THEN
3130: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COUPON_EXEMPT_FLAG' THEN
3131: x_item_table(p_tab_index).COUPON_EXEMPT_FLAG := cr.ATTRIBUTE_VALUE;
3132: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG' THEN
3133: x_item_table(p_tab_index).COMMS_NL_TRACKABLE_FLAG := cr.ATTRIBUTE_VALUE;
3134: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CREATION_CODE' THEN
3135: x_item_table(p_tab_index).ASSET_CREATION_CODE := cr.ATTRIBUTE_VALUE;
3136: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' THEN
3137: x_item_table(p_tab_index).COMMS_ACTIVATION_REQD_FLAG := cr.ATTRIBUTE_VALUE;
3138: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' THEN
3132: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG' THEN
3133: x_item_table(p_tab_index).COMMS_NL_TRACKABLE_FLAG := cr.ATTRIBUTE_VALUE;
3134: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CREATION_CODE' THEN
3135: x_item_table(p_tab_index).ASSET_CREATION_CODE := cr.ATTRIBUTE_VALUE;
3136: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' THEN
3137: x_item_table(p_tab_index).COMMS_ACTIVATION_REQD_FLAG := cr.ATTRIBUTE_VALUE;
3138: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' THEN
3139: x_item_table(p_tab_index).ORDERABLE_ON_WEB_FLAG := cr.ATTRIBUTE_VALUE;
3140: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' THEN
3134: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASSET_CREATION_CODE' THEN
3135: x_item_table(p_tab_index).ASSET_CREATION_CODE := cr.ATTRIBUTE_VALUE;
3136: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' THEN
3137: x_item_table(p_tab_index).COMMS_ACTIVATION_REQD_FLAG := cr.ATTRIBUTE_VALUE;
3138: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' THEN
3139: x_item_table(p_tab_index).ORDERABLE_ON_WEB_FLAG := cr.ATTRIBUTE_VALUE;
3140: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' THEN
3141: x_item_table(p_tab_index).BACK_ORDERABLE_FLAG := cr.ATTRIBUTE_VALUE;
3142: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' THEN
3136: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COMMS_ACTIVATION_REQD_FLAG' THEN
3137: x_item_table(p_tab_index).COMMS_ACTIVATION_REQD_FLAG := cr.ATTRIBUTE_VALUE;
3138: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' THEN
3139: x_item_table(p_tab_index).ORDERABLE_ON_WEB_FLAG := cr.ATTRIBUTE_VALUE;
3140: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' THEN
3141: x_item_table(p_tab_index).BACK_ORDERABLE_FLAG := cr.ATTRIBUTE_VALUE;
3142: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' THEN
3143: x_item_table(p_tab_index).WEB_STATUS := cr.ATTRIBUTE_VALUE;
3144: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' THEN
3138: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ORDERABLE_ON_WEB_FLAG' THEN
3139: x_item_table(p_tab_index).ORDERABLE_ON_WEB_FLAG := cr.ATTRIBUTE_VALUE;
3140: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' THEN
3141: x_item_table(p_tab_index).BACK_ORDERABLE_FLAG := cr.ATTRIBUTE_VALUE;
3142: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' THEN
3143: x_item_table(p_tab_index).WEB_STATUS := cr.ATTRIBUTE_VALUE;
3144: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' THEN
3145: x_item_table(p_tab_index).INDIVISIBLE_FLAG := cr.ATTRIBUTE_VALUE;
3146: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' THEN
3140: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BACK_ORDERABLE_FLAG' THEN
3141: x_item_table(p_tab_index).BACK_ORDERABLE_FLAG := cr.ATTRIBUTE_VALUE;
3142: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' THEN
3143: x_item_table(p_tab_index).WEB_STATUS := cr.ATTRIBUTE_VALUE;
3144: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' THEN
3145: x_item_table(p_tab_index).INDIVISIBLE_FLAG := cr.ATTRIBUTE_VALUE;
3146: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' THEN
3147: x_item_table(p_tab_index).DIMENSION_UOM_CODE := cr.ATTRIBUTE_VALUE;
3148: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' THEN
3142: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WEB_STATUS' THEN
3143: x_item_table(p_tab_index).WEB_STATUS := cr.ATTRIBUTE_VALUE;
3144: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' THEN
3145: x_item_table(p_tab_index).INDIVISIBLE_FLAG := cr.ATTRIBUTE_VALUE;
3146: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' THEN
3147: x_item_table(p_tab_index).DIMENSION_UOM_CODE := cr.ATTRIBUTE_VALUE;
3148: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' THEN
3149: x_item_table(p_tab_index).UNIT_LENGTH := cr.ATTRIBUTE_VALUE;
3150: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' THEN
3144: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INDIVISIBLE_FLAG' THEN
3145: x_item_table(p_tab_index).INDIVISIBLE_FLAG := cr.ATTRIBUTE_VALUE;
3146: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' THEN
3147: x_item_table(p_tab_index).DIMENSION_UOM_CODE := cr.ATTRIBUTE_VALUE;
3148: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' THEN
3149: x_item_table(p_tab_index).UNIT_LENGTH := cr.ATTRIBUTE_VALUE;
3150: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' THEN
3151: x_item_table(p_tab_index).UNIT_WIDTH := cr.ATTRIBUTE_VALUE;
3152: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' THEN
3146: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE' THEN
3147: x_item_table(p_tab_index).DIMENSION_UOM_CODE := cr.ATTRIBUTE_VALUE;
3148: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' THEN
3149: x_item_table(p_tab_index).UNIT_LENGTH := cr.ATTRIBUTE_VALUE;
3150: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' THEN
3151: x_item_table(p_tab_index).UNIT_WIDTH := cr.ATTRIBUTE_VALUE;
3152: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' THEN
3153: x_item_table(p_tab_index).UNIT_HEIGHT := cr.ATTRIBUTE_VALUE;
3154: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' THEN
3148: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_LENGTH' THEN
3149: x_item_table(p_tab_index).UNIT_LENGTH := cr.ATTRIBUTE_VALUE;
3150: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' THEN
3151: x_item_table(p_tab_index).UNIT_WIDTH := cr.ATTRIBUTE_VALUE;
3152: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' THEN
3153: x_item_table(p_tab_index).UNIT_HEIGHT := cr.ATTRIBUTE_VALUE;
3154: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' THEN
3155: x_item_table(p_tab_index).BULK_PICKED_FLAG := cr.ATTRIBUTE_VALUE;
3156: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' THEN
3150: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_WIDTH' THEN
3151: x_item_table(p_tab_index).UNIT_WIDTH := cr.ATTRIBUTE_VALUE;
3152: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' THEN
3153: x_item_table(p_tab_index).UNIT_HEIGHT := cr.ATTRIBUTE_VALUE;
3154: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' THEN
3155: x_item_table(p_tab_index).BULK_PICKED_FLAG := cr.ATTRIBUTE_VALUE;
3156: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' THEN
3157: x_item_table(p_tab_index).LOT_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
3158: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' THEN
3152: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.UNIT_HEIGHT' THEN
3153: x_item_table(p_tab_index).UNIT_HEIGHT := cr.ATTRIBUTE_VALUE;
3154: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' THEN
3155: x_item_table(p_tab_index).BULK_PICKED_FLAG := cr.ATTRIBUTE_VALUE;
3156: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' THEN
3157: x_item_table(p_tab_index).LOT_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
3158: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' THEN
3159: x_item_table(p_tab_index).DEFAULT_LOT_STATUS_ID := cr.ATTRIBUTE_VALUE;
3160: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_STATUS_ENABLED' THEN
3154: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BULK_PICKED_FLAG' THEN
3155: x_item_table(p_tab_index).BULK_PICKED_FLAG := cr.ATTRIBUTE_VALUE;
3156: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' THEN
3157: x_item_table(p_tab_index).LOT_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
3158: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' THEN
3159: x_item_table(p_tab_index).DEFAULT_LOT_STATUS_ID := cr.ATTRIBUTE_VALUE;
3160: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_STATUS_ENABLED' THEN
3161: x_item_table(p_tab_index).SERIAL_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
3162: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SERIAL_STATUS_ID' THEN
3156: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED' THEN
3157: x_item_table(p_tab_index).LOT_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
3158: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' THEN
3159: x_item_table(p_tab_index).DEFAULT_LOT_STATUS_ID := cr.ATTRIBUTE_VALUE;
3160: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_STATUS_ENABLED' THEN
3161: x_item_table(p_tab_index).SERIAL_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
3162: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SERIAL_STATUS_ID' THEN
3163: x_item_table(p_tab_index).DEFAULT_SERIAL_STATUS_ID := cr.ATTRIBUTE_VALUE;
3164: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_SPLIT_ENABLED' THEN
3158: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID' THEN
3159: x_item_table(p_tab_index).DEFAULT_LOT_STATUS_ID := cr.ATTRIBUTE_VALUE;
3160: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_STATUS_ENABLED' THEN
3161: x_item_table(p_tab_index).SERIAL_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
3162: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SERIAL_STATUS_ID' THEN
3163: x_item_table(p_tab_index).DEFAULT_SERIAL_STATUS_ID := cr.ATTRIBUTE_VALUE;
3164: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_SPLIT_ENABLED' THEN
3165: x_item_table(p_tab_index).LOT_SPLIT_ENABLED := cr.ATTRIBUTE_VALUE;
3166: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_MERGE_ENABLED' THEN
3160: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERIAL_STATUS_ENABLED' THEN
3161: x_item_table(p_tab_index).SERIAL_STATUS_ENABLED := cr.ATTRIBUTE_VALUE;
3162: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SERIAL_STATUS_ID' THEN
3163: x_item_table(p_tab_index).DEFAULT_SERIAL_STATUS_ID := cr.ATTRIBUTE_VALUE;
3164: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_SPLIT_ENABLED' THEN
3165: x_item_table(p_tab_index).LOT_SPLIT_ENABLED := cr.ATTRIBUTE_VALUE;
3166: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_MERGE_ENABLED' THEN
3167: x_item_table(p_tab_index).LOT_MERGE_ENABLED := cr.ATTRIBUTE_VALUE;
3168: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_CARRY_PENALTY' THEN
3162: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SERIAL_STATUS_ID' THEN
3163: x_item_table(p_tab_index).DEFAULT_SERIAL_STATUS_ID := cr.ATTRIBUTE_VALUE;
3164: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_SPLIT_ENABLED' THEN
3165: x_item_table(p_tab_index).LOT_SPLIT_ENABLED := cr.ATTRIBUTE_VALUE;
3166: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_MERGE_ENABLED' THEN
3167: x_item_table(p_tab_index).LOT_MERGE_ENABLED := cr.ATTRIBUTE_VALUE;
3168: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_CARRY_PENALTY' THEN
3169: x_item_table(p_tab_index).INVENTORY_CARRY_PENALTY := cr.ATTRIBUTE_VALUE;
3170: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OPERATION_SLACK_PENALTY' THEN
3164: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_SPLIT_ENABLED' THEN
3165: x_item_table(p_tab_index).LOT_SPLIT_ENABLED := cr.ATTRIBUTE_VALUE;
3166: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_MERGE_ENABLED' THEN
3167: x_item_table(p_tab_index).LOT_MERGE_ENABLED := cr.ATTRIBUTE_VALUE;
3168: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_CARRY_PENALTY' THEN
3169: x_item_table(p_tab_index).INVENTORY_CARRY_PENALTY := cr.ATTRIBUTE_VALUE;
3170: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OPERATION_SLACK_PENALTY' THEN
3171: x_item_table(p_tab_index).OPERATION_SLACK_PENALTY := cr.ATTRIBUTE_VALUE;
3172: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FINANCING_ALLOWED_FLAG' THEN
3166: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_MERGE_ENABLED' THEN
3167: x_item_table(p_tab_index).LOT_MERGE_ENABLED := cr.ATTRIBUTE_VALUE;
3168: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_CARRY_PENALTY' THEN
3169: x_item_table(p_tab_index).INVENTORY_CARRY_PENALTY := cr.ATTRIBUTE_VALUE;
3170: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OPERATION_SLACK_PENALTY' THEN
3171: x_item_table(p_tab_index).OPERATION_SLACK_PENALTY := cr.ATTRIBUTE_VALUE;
3172: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FINANCING_ALLOWED_FLAG' THEN
3173: x_item_table(p_tab_index).FINANCING_ALLOWED_FLAG := cr.ATTRIBUTE_VALUE;
3174: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE' THEN
3168: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_CARRY_PENALTY' THEN
3169: x_item_table(p_tab_index).INVENTORY_CARRY_PENALTY := cr.ATTRIBUTE_VALUE;
3170: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OPERATION_SLACK_PENALTY' THEN
3171: x_item_table(p_tab_index).OPERATION_SLACK_PENALTY := cr.ATTRIBUTE_VALUE;
3172: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FINANCING_ALLOWED_FLAG' THEN
3173: x_item_table(p_tab_index).FINANCING_ALLOWED_FLAG := cr.ATTRIBUTE_VALUE;
3174: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE' THEN
3175: x_item_table(p_tab_index).PRIMARY_UOM_CODE := cr.ATTRIBUTE_VALUE;
3176: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE' THEN
3170: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OPERATION_SLACK_PENALTY' THEN
3171: x_item_table(p_tab_index).OPERATION_SLACK_PENALTY := cr.ATTRIBUTE_VALUE;
3172: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FINANCING_ALLOWED_FLAG' THEN
3173: x_item_table(p_tab_index).FINANCING_ALLOWED_FLAG := cr.ATTRIBUTE_VALUE;
3174: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE' THEN
3175: x_item_table(p_tab_index).PRIMARY_UOM_CODE := cr.ATTRIBUTE_VALUE;
3176: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE' THEN
3177: x_item_table(p_tab_index).EAM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
3178: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_TYPE_CODE' THEN
3172: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FINANCING_ALLOWED_FLAG' THEN
3173: x_item_table(p_tab_index).FINANCING_ALLOWED_FLAG := cr.ATTRIBUTE_VALUE;
3174: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE' THEN
3175: x_item_table(p_tab_index).PRIMARY_UOM_CODE := cr.ATTRIBUTE_VALUE;
3176: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE' THEN
3177: x_item_table(p_tab_index).EAM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
3178: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_TYPE_CODE' THEN
3179: x_item_table(p_tab_index).EAM_ACTIVITY_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3180: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_CAUSE_CODE' THEN
3174: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE' THEN
3175: x_item_table(p_tab_index).PRIMARY_UOM_CODE := cr.ATTRIBUTE_VALUE;
3176: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE' THEN
3177: x_item_table(p_tab_index).EAM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
3178: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_TYPE_CODE' THEN
3179: x_item_table(p_tab_index).EAM_ACTIVITY_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3180: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_CAUSE_CODE' THEN
3181: x_item_table(p_tab_index).EAM_ACTIVITY_CAUSE_CODE := cr.ATTRIBUTE_VALUE;
3182: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACT_NOTIFICATION_FLAG' THEN
3176: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ITEM_TYPE' THEN
3177: x_item_table(p_tab_index).EAM_ITEM_TYPE := cr.ATTRIBUTE_VALUE;
3178: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_TYPE_CODE' THEN
3179: x_item_table(p_tab_index).EAM_ACTIVITY_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3180: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_CAUSE_CODE' THEN
3181: x_item_table(p_tab_index).EAM_ACTIVITY_CAUSE_CODE := cr.ATTRIBUTE_VALUE;
3182: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACT_NOTIFICATION_FLAG' THEN
3183: x_item_table(p_tab_index).EAM_ACT_NOTIFICATION_FLAG := cr.ATTRIBUTE_VALUE;
3184: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACT_SHUTDOWN_STATUS' THEN
3178: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_TYPE_CODE' THEN
3179: x_item_table(p_tab_index).EAM_ACTIVITY_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3180: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_CAUSE_CODE' THEN
3181: x_item_table(p_tab_index).EAM_ACTIVITY_CAUSE_CODE := cr.ATTRIBUTE_VALUE;
3182: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACT_NOTIFICATION_FLAG' THEN
3183: x_item_table(p_tab_index).EAM_ACT_NOTIFICATION_FLAG := cr.ATTRIBUTE_VALUE;
3184: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACT_SHUTDOWN_STATUS' THEN
3185: x_item_table(p_tab_index).EAM_ACT_SHUTDOWN_STATUS := cr.ATTRIBUTE_VALUE;
3186: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_CONTROL' THEN
3180: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_CAUSE_CODE' THEN
3181: x_item_table(p_tab_index).EAM_ACTIVITY_CAUSE_CODE := cr.ATTRIBUTE_VALUE;
3182: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACT_NOTIFICATION_FLAG' THEN
3183: x_item_table(p_tab_index).EAM_ACT_NOTIFICATION_FLAG := cr.ATTRIBUTE_VALUE;
3184: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACT_SHUTDOWN_STATUS' THEN
3185: x_item_table(p_tab_index).EAM_ACT_SHUTDOWN_STATUS := cr.ATTRIBUTE_VALUE;
3186: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_CONTROL' THEN
3187: x_item_table(p_tab_index).DUAL_UOM_CONTROL := cr.ATTRIBUTE_VALUE;
3188: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE' THEN
3182: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACT_NOTIFICATION_FLAG' THEN
3183: x_item_table(p_tab_index).EAM_ACT_NOTIFICATION_FLAG := cr.ATTRIBUTE_VALUE;
3184: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACT_SHUTDOWN_STATUS' THEN
3185: x_item_table(p_tab_index).EAM_ACT_SHUTDOWN_STATUS := cr.ATTRIBUTE_VALUE;
3186: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_CONTROL' THEN
3187: x_item_table(p_tab_index).DUAL_UOM_CONTROL := cr.ATTRIBUTE_VALUE;
3188: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE' THEN
3189: x_item_table(p_tab_index).SECONDARY_UOM_CODE := cr.ATTRIBUTE_VALUE;
3190: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH' THEN
3184: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACT_SHUTDOWN_STATUS' THEN
3185: x_item_table(p_tab_index).EAM_ACT_SHUTDOWN_STATUS := cr.ATTRIBUTE_VALUE;
3186: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_CONTROL' THEN
3187: x_item_table(p_tab_index).DUAL_UOM_CONTROL := cr.ATTRIBUTE_VALUE;
3188: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE' THEN
3189: x_item_table(p_tab_index).SECONDARY_UOM_CODE := cr.ATTRIBUTE_VALUE;
3190: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH' THEN
3191: x_item_table(p_tab_index).DUAL_UOM_DEVIATION_HIGH := cr.ATTRIBUTE_VALUE;
3192: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW' THEN
3186: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_CONTROL' THEN
3187: x_item_table(p_tab_index).DUAL_UOM_CONTROL := cr.ATTRIBUTE_VALUE;
3188: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE' THEN
3189: x_item_table(p_tab_index).SECONDARY_UOM_CODE := cr.ATTRIBUTE_VALUE;
3190: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH' THEN
3191: x_item_table(p_tab_index).DUAL_UOM_DEVIATION_HIGH := cr.ATTRIBUTE_VALUE;
3192: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW' THEN
3193: x_item_table(p_tab_index).DUAL_UOM_DEVIATION_LOW := cr.ATTRIBUTE_VALUE;
3194: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTRACT_ITEM_TYPE_CODE' THEN
3188: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE' THEN
3189: x_item_table(p_tab_index).SECONDARY_UOM_CODE := cr.ATTRIBUTE_VALUE;
3190: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH' THEN
3191: x_item_table(p_tab_index).DUAL_UOM_DEVIATION_HIGH := cr.ATTRIBUTE_VALUE;
3192: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW' THEN
3193: x_item_table(p_tab_index).DUAL_UOM_DEVIATION_LOW := cr.ATTRIBUTE_VALUE;
3194: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTRACT_ITEM_TYPE_CODE' THEN
3195: x_item_table(p_tab_index).CONTRACT_ITEM_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3196: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBSCRIPTION_DEPEND_FLAG' THEN
3190: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH' THEN
3191: x_item_table(p_tab_index).DUAL_UOM_DEVIATION_HIGH := cr.ATTRIBUTE_VALUE;
3192: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW' THEN
3193: x_item_table(p_tab_index).DUAL_UOM_DEVIATION_LOW := cr.ATTRIBUTE_VALUE;
3194: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTRACT_ITEM_TYPE_CODE' THEN
3195: x_item_table(p_tab_index).CONTRACT_ITEM_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3196: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBSCRIPTION_DEPEND_FLAG' THEN
3197: x_item_table(p_tab_index).SUBSCRIPTION_DEPEND_FLAG := cr.ATTRIBUTE_VALUE;
3198: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_REQ_ENABLED_CODE' THEN
3192: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW' THEN
3193: x_item_table(p_tab_index).DUAL_UOM_DEVIATION_LOW := cr.ATTRIBUTE_VALUE;
3194: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTRACT_ITEM_TYPE_CODE' THEN
3195: x_item_table(p_tab_index).CONTRACT_ITEM_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3196: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBSCRIPTION_DEPEND_FLAG' THEN
3197: x_item_table(p_tab_index).SUBSCRIPTION_DEPEND_FLAG := cr.ATTRIBUTE_VALUE;
3198: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_REQ_ENABLED_CODE' THEN
3199: x_item_table(p_tab_index).SERV_REQ_ENABLED_CODE := cr.ATTRIBUTE_VALUE;
3200: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_BILLING_ENABLED_FLAG' THEN
3194: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTRACT_ITEM_TYPE_CODE' THEN
3195: x_item_table(p_tab_index).CONTRACT_ITEM_TYPE_CODE := cr.ATTRIBUTE_VALUE;
3196: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBSCRIPTION_DEPEND_FLAG' THEN
3197: x_item_table(p_tab_index).SUBSCRIPTION_DEPEND_FLAG := cr.ATTRIBUTE_VALUE;
3198: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_REQ_ENABLED_CODE' THEN
3199: x_item_table(p_tab_index).SERV_REQ_ENABLED_CODE := cr.ATTRIBUTE_VALUE;
3200: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_BILLING_ENABLED_FLAG' THEN
3201: x_item_table(p_tab_index).SERV_BILLING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3202: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_IMPORTANCE_LEVEL' THEN
3196: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBSCRIPTION_DEPEND_FLAG' THEN
3197: x_item_table(p_tab_index).SUBSCRIPTION_DEPEND_FLAG := cr.ATTRIBUTE_VALUE;
3198: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_REQ_ENABLED_CODE' THEN
3199: x_item_table(p_tab_index).SERV_REQ_ENABLED_CODE := cr.ATTRIBUTE_VALUE;
3200: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_BILLING_ENABLED_FLAG' THEN
3201: x_item_table(p_tab_index).SERV_BILLING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3202: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_IMPORTANCE_LEVEL' THEN
3203: x_item_table(p_tab_index).SERV_IMPORTANCE_LEVEL := cr.ATTRIBUTE_VALUE;
3204: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNED_INV_POINT_FLAG' THEN
3198: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_REQ_ENABLED_CODE' THEN
3199: x_item_table(p_tab_index).SERV_REQ_ENABLED_CODE := cr.ATTRIBUTE_VALUE;
3200: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_BILLING_ENABLED_FLAG' THEN
3201: x_item_table(p_tab_index).SERV_BILLING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3202: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_IMPORTANCE_LEVEL' THEN
3203: x_item_table(p_tab_index).SERV_IMPORTANCE_LEVEL := cr.ATTRIBUTE_VALUE;
3204: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNED_INV_POINT_FLAG' THEN
3205: x_item_table(p_tab_index).PLANNED_INV_POINT_FLAG := cr.ATTRIBUTE_VALUE;
3206: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_TRANSLATE_ENABLED' THEN
3200: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_BILLING_ENABLED_FLAG' THEN
3201: x_item_table(p_tab_index).SERV_BILLING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3202: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_IMPORTANCE_LEVEL' THEN
3203: x_item_table(p_tab_index).SERV_IMPORTANCE_LEVEL := cr.ATTRIBUTE_VALUE;
3204: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNED_INV_POINT_FLAG' THEN
3205: x_item_table(p_tab_index).PLANNED_INV_POINT_FLAG := cr.ATTRIBUTE_VALUE;
3206: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_TRANSLATE_ENABLED' THEN
3207: x_item_table(p_tab_index).LOT_TRANSLATE_ENABLED := cr.ATTRIBUTE_VALUE;
3208: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SO_SOURCE_TYPE' THEN
3202: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SERV_IMPORTANCE_LEVEL' THEN
3203: x_item_table(p_tab_index).SERV_IMPORTANCE_LEVEL := cr.ATTRIBUTE_VALUE;
3204: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNED_INV_POINT_FLAG' THEN
3205: x_item_table(p_tab_index).PLANNED_INV_POINT_FLAG := cr.ATTRIBUTE_VALUE;
3206: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_TRANSLATE_ENABLED' THEN
3207: x_item_table(p_tab_index).LOT_TRANSLATE_ENABLED := cr.ATTRIBUTE_VALUE;
3208: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SO_SOURCE_TYPE' THEN
3209: x_item_table(p_tab_index).DEFAULT_SO_SOURCE_TYPE := cr.ATTRIBUTE_VALUE;
3210: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CREATE_SUPPLY_FLAG' THEN
3204: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNED_INV_POINT_FLAG' THEN
3205: x_item_table(p_tab_index).PLANNED_INV_POINT_FLAG := cr.ATTRIBUTE_VALUE;
3206: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_TRANSLATE_ENABLED' THEN
3207: x_item_table(p_tab_index).LOT_TRANSLATE_ENABLED := cr.ATTRIBUTE_VALUE;
3208: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SO_SOURCE_TYPE' THEN
3209: x_item_table(p_tab_index).DEFAULT_SO_SOURCE_TYPE := cr.ATTRIBUTE_VALUE;
3210: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CREATE_SUPPLY_FLAG' THEN
3211: x_item_table(p_tab_index).CREATE_SUPPLY_FLAG := cr.ATTRIBUTE_VALUE;
3212: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBSTITUTION_WINDOW_CODE' THEN
3206: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_TRANSLATE_ENABLED' THEN
3207: x_item_table(p_tab_index).LOT_TRANSLATE_ENABLED := cr.ATTRIBUTE_VALUE;
3208: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SO_SOURCE_TYPE' THEN
3209: x_item_table(p_tab_index).DEFAULT_SO_SOURCE_TYPE := cr.ATTRIBUTE_VALUE;
3210: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CREATE_SUPPLY_FLAG' THEN
3211: x_item_table(p_tab_index).CREATE_SUPPLY_FLAG := cr.ATTRIBUTE_VALUE;
3212: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBSTITUTION_WINDOW_CODE' THEN
3213: x_item_table(p_tab_index).SUBSTITUTION_WINDOW_CODE := cr.ATTRIBUTE_VALUE;
3214: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_SUBSTITUTION_ENABLED' THEN
3208: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_SO_SOURCE_TYPE' THEN
3209: x_item_table(p_tab_index).DEFAULT_SO_SOURCE_TYPE := cr.ATTRIBUTE_VALUE;
3210: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CREATE_SUPPLY_FLAG' THEN
3211: x_item_table(p_tab_index).CREATE_SUPPLY_FLAG := cr.ATTRIBUTE_VALUE;
3212: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBSTITUTION_WINDOW_CODE' THEN
3213: x_item_table(p_tab_index).SUBSTITUTION_WINDOW_CODE := cr.ATTRIBUTE_VALUE;
3214: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_SUBSTITUTION_ENABLED' THEN
3215: x_item_table(p_tab_index).LOT_SUBSTITUTION_ENABLED := cr.ATTRIBUTE_VALUE;
3216: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_LICENSE_QUANTITY' THEN
3210: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CREATE_SUPPLY_FLAG' THEN
3211: x_item_table(p_tab_index).CREATE_SUPPLY_FLAG := cr.ATTRIBUTE_VALUE;
3212: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBSTITUTION_WINDOW_CODE' THEN
3213: x_item_table(p_tab_index).SUBSTITUTION_WINDOW_CODE := cr.ATTRIBUTE_VALUE;
3214: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_SUBSTITUTION_ENABLED' THEN
3215: x_item_table(p_tab_index).LOT_SUBSTITUTION_ENABLED := cr.ATTRIBUTE_VALUE;
3216: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_LICENSE_QUANTITY' THEN
3217: x_item_table(p_tab_index).MINIMUM_LICENSE_QUANTITY := cr.ATTRIBUTE_VALUE;
3218: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_SOURCE_CODE' THEN
3212: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBSTITUTION_WINDOW_CODE' THEN
3213: x_item_table(p_tab_index).SUBSTITUTION_WINDOW_CODE := cr.ATTRIBUTE_VALUE;
3214: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_SUBSTITUTION_ENABLED' THEN
3215: x_item_table(p_tab_index).LOT_SUBSTITUTION_ENABLED := cr.ATTRIBUTE_VALUE;
3216: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_LICENSE_QUANTITY' THEN
3217: x_item_table(p_tab_index).MINIMUM_LICENSE_QUANTITY := cr.ATTRIBUTE_VALUE;
3218: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_SOURCE_CODE' THEN
3219: x_item_table(p_tab_index).EAM_ACTIVITY_SOURCE_CODE := cr.ATTRIBUTE_VALUE;
3220: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.IB_ITEM_INSTANCE_CLASS' THEN
3214: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_SUBSTITUTION_ENABLED' THEN
3215: x_item_table(p_tab_index).LOT_SUBSTITUTION_ENABLED := cr.ATTRIBUTE_VALUE;
3216: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_LICENSE_QUANTITY' THEN
3217: x_item_table(p_tab_index).MINIMUM_LICENSE_QUANTITY := cr.ATTRIBUTE_VALUE;
3218: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_SOURCE_CODE' THEN
3219: x_item_table(p_tab_index).EAM_ACTIVITY_SOURCE_CODE := cr.ATTRIBUTE_VALUE;
3220: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.IB_ITEM_INSTANCE_CLASS' THEN
3221: x_item_table(p_tab_index).IB_ITEM_INSTANCE_CLASS := cr.ATTRIBUTE_VALUE;
3222: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_MODEL_TYPE' THEN
3216: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MINIMUM_LICENSE_QUANTITY' THEN
3217: x_item_table(p_tab_index).MINIMUM_LICENSE_QUANTITY := cr.ATTRIBUTE_VALUE;
3218: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_SOURCE_CODE' THEN
3219: x_item_table(p_tab_index).EAM_ACTIVITY_SOURCE_CODE := cr.ATTRIBUTE_VALUE;
3220: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.IB_ITEM_INSTANCE_CLASS' THEN
3221: x_item_table(p_tab_index).IB_ITEM_INSTANCE_CLASS := cr.ATTRIBUTE_VALUE;
3222: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_MODEL_TYPE' THEN
3223: x_item_table(p_tab_index).CONFIG_MODEL_TYPE := cr.ATTRIBUTE_VALUE;
3224: --Start: 26 new attributes
3218: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_SOURCE_CODE' THEN
3219: x_item_table(p_tab_index).EAM_ACTIVITY_SOURCE_CODE := cr.ATTRIBUTE_VALUE;
3220: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.IB_ITEM_INSTANCE_CLASS' THEN
3221: x_item_table(p_tab_index).IB_ITEM_INSTANCE_CLASS := cr.ATTRIBUTE_VALUE;
3222: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_MODEL_TYPE' THEN
3223: x_item_table(p_tab_index).CONFIG_MODEL_TYPE := cr.ATTRIBUTE_VALUE;
3224: --Start: 26 new attributes
3225: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND' THEN
3226: x_item_table(p_tab_index).tracking_quantity_ind := cr.ATTRIBUTE_VALUE;
3221: x_item_table(p_tab_index).IB_ITEM_INSTANCE_CLASS := cr.ATTRIBUTE_VALUE;
3222: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_MODEL_TYPE' THEN
3223: x_item_table(p_tab_index).CONFIG_MODEL_TYPE := cr.ATTRIBUTE_VALUE;
3224: --Start: 26 new attributes
3225: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND' THEN
3226: x_item_table(p_tab_index).tracking_quantity_ind := cr.ATTRIBUTE_VALUE;
3227: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE' THEN
3228: x_item_table(p_tab_index).ont_pricing_qty_source := cr.ATTRIBUTE_VALUE;
3229: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND' THEN
3223: x_item_table(p_tab_index).CONFIG_MODEL_TYPE := cr.ATTRIBUTE_VALUE;
3224: --Start: 26 new attributes
3225: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND' THEN
3226: x_item_table(p_tab_index).tracking_quantity_ind := cr.ATTRIBUTE_VALUE;
3227: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE' THEN
3228: x_item_table(p_tab_index).ont_pricing_qty_source := cr.ATTRIBUTE_VALUE;
3229: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND' THEN
3230: x_item_table(p_tab_index).secondary_default_ind := cr.ATTRIBUTE_VALUE;
3231: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OPTION_SPECIFIC_SOURCED' THEN
3225: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND' THEN
3226: x_item_table(p_tab_index).tracking_quantity_ind := cr.ATTRIBUTE_VALUE;
3227: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE' THEN
3228: x_item_table(p_tab_index).ont_pricing_qty_source := cr.ATTRIBUTE_VALUE;
3229: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND' THEN
3230: x_item_table(p_tab_index).secondary_default_ind := cr.ATTRIBUTE_VALUE;
3231: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OPTION_SPECIFIC_SOURCED' THEN
3232: x_item_table(p_tab_index).option_specific_sourced := cr.ATTRIBUTE_VALUE;
3233: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MINIMUM_UNITS' THEN
3227: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE' THEN
3228: x_item_table(p_tab_index).ont_pricing_qty_source := cr.ATTRIBUTE_VALUE;
3229: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND' THEN
3230: x_item_table(p_tab_index).secondary_default_ind := cr.ATTRIBUTE_VALUE;
3231: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OPTION_SPECIFIC_SOURCED' THEN
3232: x_item_table(p_tab_index).option_specific_sourced := cr.ATTRIBUTE_VALUE;
3233: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MINIMUM_UNITS' THEN
3234: x_item_table(p_tab_index).vmi_minimum_units := cr.ATTRIBUTE_VALUE;
3235: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MINIMUM_DAYS' THEN
3229: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND' THEN
3230: x_item_table(p_tab_index).secondary_default_ind := cr.ATTRIBUTE_VALUE;
3231: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OPTION_SPECIFIC_SOURCED' THEN
3232: x_item_table(p_tab_index).option_specific_sourced := cr.ATTRIBUTE_VALUE;
3233: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MINIMUM_UNITS' THEN
3234: x_item_table(p_tab_index).vmi_minimum_units := cr.ATTRIBUTE_VALUE;
3235: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MINIMUM_DAYS' THEN
3236: x_item_table(p_tab_index).vmi_minimum_days := cr.ATTRIBUTE_VALUE;
3237: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MAXIMUM_UNITS' THEN
3231: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OPTION_SPECIFIC_SOURCED' THEN
3232: x_item_table(p_tab_index).option_specific_sourced := cr.ATTRIBUTE_VALUE;
3233: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MINIMUM_UNITS' THEN
3234: x_item_table(p_tab_index).vmi_minimum_units := cr.ATTRIBUTE_VALUE;
3235: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MINIMUM_DAYS' THEN
3236: x_item_table(p_tab_index).vmi_minimum_days := cr.ATTRIBUTE_VALUE;
3237: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MAXIMUM_UNITS' THEN
3238: x_item_table(p_tab_index).vmi_maximum_units := cr.ATTRIBUTE_VALUE;
3239: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MAXIMUM_DAYS' THEN
3233: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MINIMUM_UNITS' THEN
3234: x_item_table(p_tab_index).vmi_minimum_units := cr.ATTRIBUTE_VALUE;
3235: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MINIMUM_DAYS' THEN
3236: x_item_table(p_tab_index).vmi_minimum_days := cr.ATTRIBUTE_VALUE;
3237: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MAXIMUM_UNITS' THEN
3238: x_item_table(p_tab_index).vmi_maximum_units := cr.ATTRIBUTE_VALUE;
3239: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MAXIMUM_DAYS' THEN
3240: x_item_table(p_tab_index).vmi_maximum_days := cr.ATTRIBUTE_VALUE;
3241: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_FIXED_ORDER_QUANTITY' THEN
3235: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MINIMUM_DAYS' THEN
3236: x_item_table(p_tab_index).vmi_minimum_days := cr.ATTRIBUTE_VALUE;
3237: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MAXIMUM_UNITS' THEN
3238: x_item_table(p_tab_index).vmi_maximum_units := cr.ATTRIBUTE_VALUE;
3239: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MAXIMUM_DAYS' THEN
3240: x_item_table(p_tab_index).vmi_maximum_days := cr.ATTRIBUTE_VALUE;
3241: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_FIXED_ORDER_QUANTITY' THEN
3242: x_item_table(p_tab_index).vmi_fixed_order_quantity := cr.ATTRIBUTE_VALUE;
3243: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SO_AUTHORIZATION_FLAG' THEN
3237: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MAXIMUM_UNITS' THEN
3238: x_item_table(p_tab_index).vmi_maximum_units := cr.ATTRIBUTE_VALUE;
3239: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MAXIMUM_DAYS' THEN
3240: x_item_table(p_tab_index).vmi_maximum_days := cr.ATTRIBUTE_VALUE;
3241: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_FIXED_ORDER_QUANTITY' THEN
3242: x_item_table(p_tab_index).vmi_fixed_order_quantity := cr.ATTRIBUTE_VALUE;
3243: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SO_AUTHORIZATION_FLAG' THEN
3244: x_item_table(p_tab_index).so_authorization_flag := cr.ATTRIBUTE_VALUE;
3245: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONSIGNED_FLAG' THEN
3239: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_MAXIMUM_DAYS' THEN
3240: x_item_table(p_tab_index).vmi_maximum_days := cr.ATTRIBUTE_VALUE;
3241: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_FIXED_ORDER_QUANTITY' THEN
3242: x_item_table(p_tab_index).vmi_fixed_order_quantity := cr.ATTRIBUTE_VALUE;
3243: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SO_AUTHORIZATION_FLAG' THEN
3244: x_item_table(p_tab_index).so_authorization_flag := cr.ATTRIBUTE_VALUE;
3245: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONSIGNED_FLAG' THEN
3246: x_item_table(p_tab_index).consigned_flag := cr.ATTRIBUTE_VALUE;
3247: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASN_AUTOEXPIRE_FLAG' THEN
3241: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_FIXED_ORDER_QUANTITY' THEN
3242: x_item_table(p_tab_index).vmi_fixed_order_quantity := cr.ATTRIBUTE_VALUE;
3243: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SO_AUTHORIZATION_FLAG' THEN
3244: x_item_table(p_tab_index).so_authorization_flag := cr.ATTRIBUTE_VALUE;
3245: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONSIGNED_FLAG' THEN
3246: x_item_table(p_tab_index).consigned_flag := cr.ATTRIBUTE_VALUE;
3247: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASN_AUTOEXPIRE_FLAG' THEN
3248: x_item_table(p_tab_index).asn_autoexpire_flag := cr.ATTRIBUTE_VALUE;
3249: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_FORECAST_TYPE' THEN
3243: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SO_AUTHORIZATION_FLAG' THEN
3244: x_item_table(p_tab_index).so_authorization_flag := cr.ATTRIBUTE_VALUE;
3245: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONSIGNED_FLAG' THEN
3246: x_item_table(p_tab_index).consigned_flag := cr.ATTRIBUTE_VALUE;
3247: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASN_AUTOEXPIRE_FLAG' THEN
3248: x_item_table(p_tab_index).asn_autoexpire_flag := cr.ATTRIBUTE_VALUE;
3249: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_FORECAST_TYPE' THEN
3250: x_item_table(p_tab_index).vmi_forecast_type := cr.ATTRIBUTE_VALUE;
3251: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FORECAST_HORIZON' THEN
3245: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONSIGNED_FLAG' THEN
3246: x_item_table(p_tab_index).consigned_flag := cr.ATTRIBUTE_VALUE;
3247: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASN_AUTOEXPIRE_FLAG' THEN
3248: x_item_table(p_tab_index).asn_autoexpire_flag := cr.ATTRIBUTE_VALUE;
3249: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_FORECAST_TYPE' THEN
3250: x_item_table(p_tab_index).vmi_forecast_type := cr.ATTRIBUTE_VALUE;
3251: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FORECAST_HORIZON' THEN
3252: x_item_table(p_tab_index).forecast_horizon := cr.ATTRIBUTE_VALUE;
3253: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXCLUDE_FROM_BUDGET_FLAG' THEN
3247: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ASN_AUTOEXPIRE_FLAG' THEN
3248: x_item_table(p_tab_index).asn_autoexpire_flag := cr.ATTRIBUTE_VALUE;
3249: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_FORECAST_TYPE' THEN
3250: x_item_table(p_tab_index).vmi_forecast_type := cr.ATTRIBUTE_VALUE;
3251: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FORECAST_HORIZON' THEN
3252: x_item_table(p_tab_index).forecast_horizon := cr.ATTRIBUTE_VALUE;
3253: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXCLUDE_FROM_BUDGET_FLAG' THEN
3254: x_item_table(p_tab_index).exclude_from_budget_flag := cr.ATTRIBUTE_VALUE;
3255: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_TGT_INV_SUPPLY' THEN
3249: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.VMI_FORECAST_TYPE' THEN
3250: x_item_table(p_tab_index).vmi_forecast_type := cr.ATTRIBUTE_VALUE;
3251: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FORECAST_HORIZON' THEN
3252: x_item_table(p_tab_index).forecast_horizon := cr.ATTRIBUTE_VALUE;
3253: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXCLUDE_FROM_BUDGET_FLAG' THEN
3254: x_item_table(p_tab_index).exclude_from_budget_flag := cr.ATTRIBUTE_VALUE;
3255: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_TGT_INV_SUPPLY' THEN
3256: x_item_table(p_tab_index).days_tgt_inv_supply := cr.ATTRIBUTE_VALUE;
3257: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_TGT_INV_WINDOW' THEN
3251: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.FORECAST_HORIZON' THEN
3252: x_item_table(p_tab_index).forecast_horizon := cr.ATTRIBUTE_VALUE;
3253: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXCLUDE_FROM_BUDGET_FLAG' THEN
3254: x_item_table(p_tab_index).exclude_from_budget_flag := cr.ATTRIBUTE_VALUE;
3255: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_TGT_INV_SUPPLY' THEN
3256: x_item_table(p_tab_index).days_tgt_inv_supply := cr.ATTRIBUTE_VALUE;
3257: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_TGT_INV_WINDOW' THEN
3258: x_item_table(p_tab_index).days_tgt_inv_window := cr.ATTRIBUTE_VALUE;
3259: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_MAX_INV_SUPPLY' THEN
3253: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXCLUDE_FROM_BUDGET_FLAG' THEN
3254: x_item_table(p_tab_index).exclude_from_budget_flag := cr.ATTRIBUTE_VALUE;
3255: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_TGT_INV_SUPPLY' THEN
3256: x_item_table(p_tab_index).days_tgt_inv_supply := cr.ATTRIBUTE_VALUE;
3257: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_TGT_INV_WINDOW' THEN
3258: x_item_table(p_tab_index).days_tgt_inv_window := cr.ATTRIBUTE_VALUE;
3259: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_MAX_INV_SUPPLY' THEN
3260: x_item_table(p_tab_index).days_max_inv_supply := cr.ATTRIBUTE_VALUE;
3261: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_MAX_INV_WINDOW' THEN
3255: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_TGT_INV_SUPPLY' THEN
3256: x_item_table(p_tab_index).days_tgt_inv_supply := cr.ATTRIBUTE_VALUE;
3257: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_TGT_INV_WINDOW' THEN
3258: x_item_table(p_tab_index).days_tgt_inv_window := cr.ATTRIBUTE_VALUE;
3259: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_MAX_INV_SUPPLY' THEN
3260: x_item_table(p_tab_index).days_max_inv_supply := cr.ATTRIBUTE_VALUE;
3261: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_MAX_INV_WINDOW' THEN
3262: x_item_table(p_tab_index).days_max_inv_window := cr.ATTRIBUTE_VALUE;
3263: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DRP_PLANNED_FLAG' THEN
3257: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_TGT_INV_WINDOW' THEN
3258: x_item_table(p_tab_index).days_tgt_inv_window := cr.ATTRIBUTE_VALUE;
3259: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_MAX_INV_SUPPLY' THEN
3260: x_item_table(p_tab_index).days_max_inv_supply := cr.ATTRIBUTE_VALUE;
3261: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_MAX_INV_WINDOW' THEN
3262: x_item_table(p_tab_index).days_max_inv_window := cr.ATTRIBUTE_VALUE;
3263: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DRP_PLANNED_FLAG' THEN
3264: x_item_table(p_tab_index).drp_planned_flag := cr.ATTRIBUTE_VALUE;
3265: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CRITICAL_COMPONENT_FLAG' THEN
3259: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_MAX_INV_SUPPLY' THEN
3260: x_item_table(p_tab_index).days_max_inv_supply := cr.ATTRIBUTE_VALUE;
3261: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_MAX_INV_WINDOW' THEN
3262: x_item_table(p_tab_index).days_max_inv_window := cr.ATTRIBUTE_VALUE;
3263: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DRP_PLANNED_FLAG' THEN
3264: x_item_table(p_tab_index).drp_planned_flag := cr.ATTRIBUTE_VALUE;
3265: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CRITICAL_COMPONENT_FLAG' THEN
3266: x_item_table(p_tab_index).critical_component_flag := cr.ATTRIBUTE_VALUE;
3267: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTINOUS_TRANSFER' THEN
3261: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DAYS_MAX_INV_WINDOW' THEN
3262: x_item_table(p_tab_index).days_max_inv_window := cr.ATTRIBUTE_VALUE;
3263: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DRP_PLANNED_FLAG' THEN
3264: x_item_table(p_tab_index).drp_planned_flag := cr.ATTRIBUTE_VALUE;
3265: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CRITICAL_COMPONENT_FLAG' THEN
3266: x_item_table(p_tab_index).critical_component_flag := cr.ATTRIBUTE_VALUE;
3267: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTINOUS_TRANSFER' THEN
3268: x_item_table(p_tab_index).continous_transfer := cr.ATTRIBUTE_VALUE;
3269: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONVERGENCE' THEN
3263: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DRP_PLANNED_FLAG' THEN
3264: x_item_table(p_tab_index).drp_planned_flag := cr.ATTRIBUTE_VALUE;
3265: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CRITICAL_COMPONENT_FLAG' THEN
3266: x_item_table(p_tab_index).critical_component_flag := cr.ATTRIBUTE_VALUE;
3267: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTINOUS_TRANSFER' THEN
3268: x_item_table(p_tab_index).continous_transfer := cr.ATTRIBUTE_VALUE;
3269: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONVERGENCE' THEN
3270: x_item_table(p_tab_index).convergence := cr.ATTRIBUTE_VALUE;
3271: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIVERGENCE' THEN
3265: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CRITICAL_COMPONENT_FLAG' THEN
3266: x_item_table(p_tab_index).critical_component_flag := cr.ATTRIBUTE_VALUE;
3267: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTINOUS_TRANSFER' THEN
3268: x_item_table(p_tab_index).continous_transfer := cr.ATTRIBUTE_VALUE;
3269: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONVERGENCE' THEN
3270: x_item_table(p_tab_index).convergence := cr.ATTRIBUTE_VALUE;
3271: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIVERGENCE' THEN
3272: x_item_table(p_tab_index).divergence := cr.ATTRIBUTE_VALUE;
3273: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_ORGS' THEN
3267: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONTINOUS_TRANSFER' THEN
3268: x_item_table(p_tab_index).continous_transfer := cr.ATTRIBUTE_VALUE;
3269: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONVERGENCE' THEN
3270: x_item_table(p_tab_index).convergence := cr.ATTRIBUTE_VALUE;
3271: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIVERGENCE' THEN
3272: x_item_table(p_tab_index).divergence := cr.ATTRIBUTE_VALUE;
3273: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_ORGS' THEN
3274: x_item_table(p_tab_index).config_orgs := cr.ATTRIBUTE_VALUE;
3275: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_MATCH' THEN
3269: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONVERGENCE' THEN
3270: x_item_table(p_tab_index).convergence := cr.ATTRIBUTE_VALUE;
3271: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIVERGENCE' THEN
3272: x_item_table(p_tab_index).divergence := cr.ATTRIBUTE_VALUE;
3273: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_ORGS' THEN
3274: x_item_table(p_tab_index).config_orgs := cr.ATTRIBUTE_VALUE;
3275: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_MATCH' THEN
3276: x_item_table(p_tab_index).config_match := cr.ATTRIBUTE_VALUE;
3277: --End: 26 new attributes
3271: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DIVERGENCE' THEN
3272: x_item_table(p_tab_index).divergence := cr.ATTRIBUTE_VALUE;
3273: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_ORGS' THEN
3274: x_item_table(p_tab_index).config_orgs := cr.ATTRIBUTE_VALUE;
3275: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_MATCH' THEN
3276: x_item_table(p_tab_index).config_match := cr.ATTRIBUTE_VALUE;
3277: --End: 26 new attributes
3278: /* R12 Enhancement */
3279: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CAS_NUMBER' THEN
3275: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CONFIG_MATCH' THEN
3276: x_item_table(p_tab_index).config_match := cr.ATTRIBUTE_VALUE;
3277: --End: 26 new attributes
3278: /* R12 Enhancement */
3279: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CAS_NUMBER' THEN
3280: x_item_table(p_tab_index).CAS_NUMBER := cr.ATTRIBUTE_VALUE;
3281: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG' THEN
3282: x_item_table(p_tab_index).CHILD_LOT_FLAG := cr.ATTRIBUTE_VALUE;
3283: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX' THEN
3277: --End: 26 new attributes
3278: /* R12 Enhancement */
3279: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CAS_NUMBER' THEN
3280: x_item_table(p_tab_index).CAS_NUMBER := cr.ATTRIBUTE_VALUE;
3281: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG' THEN
3282: x_item_table(p_tab_index).CHILD_LOT_FLAG := cr.ATTRIBUTE_VALUE;
3283: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX' THEN
3284: x_item_table(p_tab_index).CHILD_LOT_PREFIX := cr.ATTRIBUTE_VALUE;
3285: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER' THEN
3279: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CAS_NUMBER' THEN
3280: x_item_table(p_tab_index).CAS_NUMBER := cr.ATTRIBUTE_VALUE;
3281: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG' THEN
3282: x_item_table(p_tab_index).CHILD_LOT_FLAG := cr.ATTRIBUTE_VALUE;
3283: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX' THEN
3284: x_item_table(p_tab_index).CHILD_LOT_PREFIX := cr.ATTRIBUTE_VALUE;
3285: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER' THEN
3286: x_item_table(p_tab_index).CHILD_LOT_STARTING_NUMBER := cr.ATTRIBUTE_VALUE;
3287: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG' THEN
3281: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG' THEN
3282: x_item_table(p_tab_index).CHILD_LOT_FLAG := cr.ATTRIBUTE_VALUE;
3283: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX' THEN
3284: x_item_table(p_tab_index).CHILD_LOT_PREFIX := cr.ATTRIBUTE_VALUE;
3285: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER' THEN
3286: x_item_table(p_tab_index).CHILD_LOT_STARTING_NUMBER := cr.ATTRIBUTE_VALUE;
3287: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG' THEN
3288: x_item_table(p_tab_index).CHILD_LOT_VALIDATION_FLAG := cr.ATTRIBUTE_VALUE;
3289: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COPY_LOT_ATTRIBUTE_FLAG' THEN
3283: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX' THEN
3284: x_item_table(p_tab_index).CHILD_LOT_PREFIX := cr.ATTRIBUTE_VALUE;
3285: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER' THEN
3286: x_item_table(p_tab_index).CHILD_LOT_STARTING_NUMBER := cr.ATTRIBUTE_VALUE;
3287: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG' THEN
3288: x_item_table(p_tab_index).CHILD_LOT_VALIDATION_FLAG := cr.ATTRIBUTE_VALUE;
3289: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COPY_LOT_ATTRIBUTE_FLAG' THEN
3290: x_item_table(p_tab_index).COPY_LOT_ATTRIBUTE_FLAG := cr.ATTRIBUTE_VALUE;
3291: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_GRADE ' THEN
3285: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER' THEN
3286: x_item_table(p_tab_index).CHILD_LOT_STARTING_NUMBER := cr.ATTRIBUTE_VALUE;
3287: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG' THEN
3288: x_item_table(p_tab_index).CHILD_LOT_VALIDATION_FLAG := cr.ATTRIBUTE_VALUE;
3289: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COPY_LOT_ATTRIBUTE_FLAG' THEN
3290: x_item_table(p_tab_index).COPY_LOT_ATTRIBUTE_FLAG := cr.ATTRIBUTE_VALUE;
3291: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_GRADE ' THEN
3292: x_item_table(p_tab_index).DEFAULT_GRADE := cr.ATTRIBUTE_VALUE;
3293: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPIRATION_ACTION_CODE' THEN
3287: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG' THEN
3288: x_item_table(p_tab_index).CHILD_LOT_VALIDATION_FLAG := cr.ATTRIBUTE_VALUE;
3289: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COPY_LOT_ATTRIBUTE_FLAG' THEN
3290: x_item_table(p_tab_index).COPY_LOT_ATTRIBUTE_FLAG := cr.ATTRIBUTE_VALUE;
3291: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_GRADE ' THEN
3292: x_item_table(p_tab_index).DEFAULT_GRADE := cr.ATTRIBUTE_VALUE;
3293: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPIRATION_ACTION_CODE' THEN
3294: x_item_table(p_tab_index).EXPIRATION_ACTION_CODE := cr.ATTRIBUTE_VALUE;
3295: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPIRATION_ACTION_INTERVAL' THEN
3289: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COPY_LOT_ATTRIBUTE_FLAG' THEN
3290: x_item_table(p_tab_index).COPY_LOT_ATTRIBUTE_FLAG := cr.ATTRIBUTE_VALUE;
3291: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_GRADE ' THEN
3292: x_item_table(p_tab_index).DEFAULT_GRADE := cr.ATTRIBUTE_VALUE;
3293: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPIRATION_ACTION_CODE' THEN
3294: x_item_table(p_tab_index).EXPIRATION_ACTION_CODE := cr.ATTRIBUTE_VALUE;
3295: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPIRATION_ACTION_INTERVAL' THEN
3296: x_item_table(p_tab_index).EXPIRATION_ACTION_INTERVAL := cr.ATTRIBUTE_VALUE;
3297: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG ' THEN
3291: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DEFAULT_GRADE ' THEN
3292: x_item_table(p_tab_index).DEFAULT_GRADE := cr.ATTRIBUTE_VALUE;
3293: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPIRATION_ACTION_CODE' THEN
3294: x_item_table(p_tab_index).EXPIRATION_ACTION_CODE := cr.ATTRIBUTE_VALUE;
3295: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPIRATION_ACTION_INTERVAL' THEN
3296: x_item_table(p_tab_index).EXPIRATION_ACTION_INTERVAL := cr.ATTRIBUTE_VALUE;
3297: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG ' THEN
3298: x_item_table(p_tab_index).GRADE_CONTROL_FLAG := cr.ATTRIBUTE_VALUE;
3299: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HAZARDOUS_MATERIAL_FLAG' THEN
3293: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPIRATION_ACTION_CODE' THEN
3294: x_item_table(p_tab_index).EXPIRATION_ACTION_CODE := cr.ATTRIBUTE_VALUE;
3295: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPIRATION_ACTION_INTERVAL' THEN
3296: x_item_table(p_tab_index).EXPIRATION_ACTION_INTERVAL := cr.ATTRIBUTE_VALUE;
3297: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG ' THEN
3298: x_item_table(p_tab_index).GRADE_CONTROL_FLAG := cr.ATTRIBUTE_VALUE;
3299: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HAZARDOUS_MATERIAL_FLAG' THEN
3300: x_item_table(p_tab_index).HAZARDOUS_MATERIAL_FLAG := cr.ATTRIBUTE_VALUE;
3301: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' THEN
3295: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPIRATION_ACTION_INTERVAL' THEN
3296: x_item_table(p_tab_index).EXPIRATION_ACTION_INTERVAL := cr.ATTRIBUTE_VALUE;
3297: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG ' THEN
3298: x_item_table(p_tab_index).GRADE_CONTROL_FLAG := cr.ATTRIBUTE_VALUE;
3299: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HAZARDOUS_MATERIAL_FLAG' THEN
3300: x_item_table(p_tab_index).HAZARDOUS_MATERIAL_FLAG := cr.ATTRIBUTE_VALUE;
3301: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' THEN
3302: x_item_table(p_tab_index).HOLD_DAYS := cr.ATTRIBUTE_VALUE;
3303: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_DIVISIBLE_FLAG' THEN
3297: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG ' THEN
3298: x_item_table(p_tab_index).GRADE_CONTROL_FLAG := cr.ATTRIBUTE_VALUE;
3299: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HAZARDOUS_MATERIAL_FLAG' THEN
3300: x_item_table(p_tab_index).HAZARDOUS_MATERIAL_FLAG := cr.ATTRIBUTE_VALUE;
3301: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' THEN
3302: x_item_table(p_tab_index).HOLD_DAYS := cr.ATTRIBUTE_VALUE;
3303: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_DIVISIBLE_FLAG' THEN
3304: x_item_table(p_tab_index).LOT_DIVISIBLE_FLAG := cr.ATTRIBUTE_VALUE;
3305: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATURITY_DAYS' THEN
3299: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HAZARDOUS_MATERIAL_FLAG' THEN
3300: x_item_table(p_tab_index).HAZARDOUS_MATERIAL_FLAG := cr.ATTRIBUTE_VALUE;
3301: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' THEN
3302: x_item_table(p_tab_index).HOLD_DAYS := cr.ATTRIBUTE_VALUE;
3303: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_DIVISIBLE_FLAG' THEN
3304: x_item_table(p_tab_index).LOT_DIVISIBLE_FLAG := cr.ATTRIBUTE_VALUE;
3305: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATURITY_DAYS' THEN
3306: x_item_table(p_tab_index).MATURITY_DAYS := cr.ATTRIBUTE_VALUE;
3307: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG' THEN
3301: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.HOLD_DAYS' THEN
3302: x_item_table(p_tab_index).HOLD_DAYS := cr.ATTRIBUTE_VALUE;
3303: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_DIVISIBLE_FLAG' THEN
3304: x_item_table(p_tab_index).LOT_DIVISIBLE_FLAG := cr.ATTRIBUTE_VALUE;
3305: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATURITY_DAYS' THEN
3306: x_item_table(p_tab_index).MATURITY_DAYS := cr.ATTRIBUTE_VALUE;
3307: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG' THEN
3308: x_item_table(p_tab_index).PARENT_CHILD_GENERATION_FLAG := cr.ATTRIBUTE_VALUE;
3309: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_COSTING_ENABLED_FLAG' THEN
3303: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.LOT_DIVISIBLE_FLAG' THEN
3304: x_item_table(p_tab_index).LOT_DIVISIBLE_FLAG := cr.ATTRIBUTE_VALUE;
3305: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATURITY_DAYS' THEN
3306: x_item_table(p_tab_index).MATURITY_DAYS := cr.ATTRIBUTE_VALUE;
3307: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG' THEN
3308: x_item_table(p_tab_index).PARENT_CHILD_GENERATION_FLAG := cr.ATTRIBUTE_VALUE;
3309: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_COSTING_ENABLED_FLAG' THEN
3310: x_item_table(p_tab_index).PROCESS_COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3311: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' THEN
3305: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.MATURITY_DAYS' THEN
3306: x_item_table(p_tab_index).MATURITY_DAYS := cr.ATTRIBUTE_VALUE;
3307: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG' THEN
3308: x_item_table(p_tab_index).PARENT_CHILD_GENERATION_FLAG := cr.ATTRIBUTE_VALUE;
3309: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_COSTING_ENABLED_FLAG' THEN
3310: x_item_table(p_tab_index).PROCESS_COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3311: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' THEN
3312: x_item_table(p_tab_index).PROCESS_EXECUTION_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3313: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_QUALITY_ENABLED_FLAG' THEN
3307: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG' THEN
3308: x_item_table(p_tab_index).PARENT_CHILD_GENERATION_FLAG := cr.ATTRIBUTE_VALUE;
3309: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_COSTING_ENABLED_FLAG' THEN
3310: x_item_table(p_tab_index).PROCESS_COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3311: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' THEN
3312: x_item_table(p_tab_index).PROCESS_EXECUTION_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3313: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_QUALITY_ENABLED_FLAG' THEN
3314: x_item_table(p_tab_index).PROCESS_QUALITY_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3315: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_LOCATOR_ID' THEN
3309: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_COSTING_ENABLED_FLAG' THEN
3310: x_item_table(p_tab_index).PROCESS_COSTING_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3311: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' THEN
3312: x_item_table(p_tab_index).PROCESS_EXECUTION_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3313: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_QUALITY_ENABLED_FLAG' THEN
3314: x_item_table(p_tab_index).PROCESS_QUALITY_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3315: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_LOCATOR_ID' THEN
3316: x_item_table(p_tab_index).PROCESS_SUPPLY_LOCATOR_ID := cr.ATTRIBUTE_VALUE;
3317: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_SUBINVENTORY' THEN
3311: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG' THEN
3312: x_item_table(p_tab_index).PROCESS_EXECUTION_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3313: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_QUALITY_ENABLED_FLAG' THEN
3314: x_item_table(p_tab_index).PROCESS_QUALITY_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3315: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_LOCATOR_ID' THEN
3316: x_item_table(p_tab_index).PROCESS_SUPPLY_LOCATOR_ID := cr.ATTRIBUTE_VALUE;
3317: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_SUBINVENTORY' THEN
3318: x_item_table(p_tab_index).PROCESS_SUPPLY_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3319: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_LOCATOR_ID' THEN
3313: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_QUALITY_ENABLED_FLAG' THEN
3314: x_item_table(p_tab_index).PROCESS_QUALITY_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3315: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_LOCATOR_ID' THEN
3316: x_item_table(p_tab_index).PROCESS_SUPPLY_LOCATOR_ID := cr.ATTRIBUTE_VALUE;
3317: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_SUBINVENTORY' THEN
3318: x_item_table(p_tab_index).PROCESS_SUPPLY_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3319: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_LOCATOR_ID' THEN
3320: x_item_table(p_tab_index).PROCESS_YIELD_LOCATOR_ID := cr.ATTRIBUTE_VALUE;
3321: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_SUBINVENTORY' THEN
3315: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_LOCATOR_ID' THEN
3316: x_item_table(p_tab_index).PROCESS_SUPPLY_LOCATOR_ID := cr.ATTRIBUTE_VALUE;
3317: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_SUBINVENTORY' THEN
3318: x_item_table(p_tab_index).PROCESS_SUPPLY_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3319: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_LOCATOR_ID' THEN
3320: x_item_table(p_tab_index).PROCESS_YIELD_LOCATOR_ID := cr.ATTRIBUTE_VALUE;
3321: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_SUBINVENTORY' THEN
3322: x_item_table(p_tab_index).PROCESS_YIELD_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3323: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG ' THEN
3317: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_SUBINVENTORY' THEN
3318: x_item_table(p_tab_index).PROCESS_SUPPLY_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3319: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_LOCATOR_ID' THEN
3320: x_item_table(p_tab_index).PROCESS_YIELD_LOCATOR_ID := cr.ATTRIBUTE_VALUE;
3321: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_SUBINVENTORY' THEN
3322: x_item_table(p_tab_index).PROCESS_YIELD_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3323: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG ' THEN
3324: x_item_table(p_tab_index).RECIPE_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3325: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETEST_INTERVAL' THEN
3319: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_LOCATOR_ID' THEN
3320: x_item_table(p_tab_index).PROCESS_YIELD_LOCATOR_ID := cr.ATTRIBUTE_VALUE;
3321: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_SUBINVENTORY' THEN
3322: x_item_table(p_tab_index).PROCESS_YIELD_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3323: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG ' THEN
3324: x_item_table(p_tab_index).RECIPE_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3325: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETEST_INTERVAL' THEN
3326: x_item_table(p_tab_index).RETEST_INTERVAL := cr.ATTRIBUTE_VALUE;
3327: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHARGE_PERIODICITY_CODE ' THEN
3321: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_SUBINVENTORY' THEN
3322: x_item_table(p_tab_index).PROCESS_YIELD_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3323: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG ' THEN
3324: x_item_table(p_tab_index).RECIPE_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3325: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETEST_INTERVAL' THEN
3326: x_item_table(p_tab_index).RETEST_INTERVAL := cr.ATTRIBUTE_VALUE;
3327: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHARGE_PERIODICITY_CODE ' THEN
3328: x_item_table(p_tab_index).CHARGE_PERIODICITY_CODE := cr.ATTRIBUTE_VALUE;
3329: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_LEADTIME' THEN
3323: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG ' THEN
3324: x_item_table(p_tab_index).RECIPE_ENABLED_FLAG := cr.ATTRIBUTE_VALUE;
3325: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETEST_INTERVAL' THEN
3326: x_item_table(p_tab_index).RETEST_INTERVAL := cr.ATTRIBUTE_VALUE;
3327: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHARGE_PERIODICITY_CODE ' THEN
3328: x_item_table(p_tab_index).CHARGE_PERIODICITY_CODE := cr.ATTRIBUTE_VALUE;
3329: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_LEADTIME' THEN
3330: x_item_table(p_tab_index).REPAIR_LEADTIME := cr.ATTRIBUTE_VALUE;
3331: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_YIELD' THEN
3325: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.RETEST_INTERVAL' THEN
3326: x_item_table(p_tab_index).RETEST_INTERVAL := cr.ATTRIBUTE_VALUE;
3327: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHARGE_PERIODICITY_CODE ' THEN
3328: x_item_table(p_tab_index).CHARGE_PERIODICITY_CODE := cr.ATTRIBUTE_VALUE;
3329: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_LEADTIME' THEN
3330: x_item_table(p_tab_index).REPAIR_LEADTIME := cr.ATTRIBUTE_VALUE;
3331: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_YIELD' THEN
3332: x_item_table(p_tab_index).REPAIR_YIELD := cr.ATTRIBUTE_VALUE;
3333: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PREPOSITION_POINT ' THEN
3327: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.CHARGE_PERIODICITY_CODE ' THEN
3328: x_item_table(p_tab_index).CHARGE_PERIODICITY_CODE := cr.ATTRIBUTE_VALUE;
3329: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_LEADTIME' THEN
3330: x_item_table(p_tab_index).REPAIR_LEADTIME := cr.ATTRIBUTE_VALUE;
3331: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_YIELD' THEN
3332: x_item_table(p_tab_index).REPAIR_YIELD := cr.ATTRIBUTE_VALUE;
3333: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PREPOSITION_POINT ' THEN
3334: x_item_table(p_tab_index).PREPOSITION_POINT := cr.ATTRIBUTE_VALUE;
3335: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_PROGRAM' THEN
3329: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_LEADTIME' THEN
3330: x_item_table(p_tab_index).REPAIR_LEADTIME := cr.ATTRIBUTE_VALUE;
3331: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_YIELD' THEN
3332: x_item_table(p_tab_index).REPAIR_YIELD := cr.ATTRIBUTE_VALUE;
3333: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PREPOSITION_POINT ' THEN
3334: x_item_table(p_tab_index).PREPOSITION_POINT := cr.ATTRIBUTE_VALUE;
3335: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_PROGRAM' THEN
3336: x_item_table(p_tab_index).REPAIR_PROGRAM := cr.ATTRIBUTE_VALUE;
3337: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBCONTRACTING_COMPONENT' THEN
3331: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_YIELD' THEN
3332: x_item_table(p_tab_index).REPAIR_YIELD := cr.ATTRIBUTE_VALUE;
3333: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PREPOSITION_POINT ' THEN
3334: x_item_table(p_tab_index).PREPOSITION_POINT := cr.ATTRIBUTE_VALUE;
3335: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_PROGRAM' THEN
3336: x_item_table(p_tab_index).REPAIR_PROGRAM := cr.ATTRIBUTE_VALUE;
3337: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBCONTRACTING_COMPONENT' THEN
3338: x_item_table(p_tab_index).SUBCONTRACTING_COMPONENT := cr.ATTRIBUTE_VALUE;
3339: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSOURCED_ASSEMBLY' THEN
3333: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PREPOSITION_POINT ' THEN
3334: x_item_table(p_tab_index).PREPOSITION_POINT := cr.ATTRIBUTE_VALUE;
3335: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_PROGRAM' THEN
3336: x_item_table(p_tab_index).REPAIR_PROGRAM := cr.ATTRIBUTE_VALUE;
3337: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBCONTRACTING_COMPONENT' THEN
3338: x_item_table(p_tab_index).SUBCONTRACTING_COMPONENT := cr.ATTRIBUTE_VALUE;
3339: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSOURCED_ASSEMBLY' THEN
3340: x_item_table(p_tab_index).OUTSOURCED_ASSEMBLY := cr.ATTRIBUTE_VALUE;
3341:
3335: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.REPAIR_PROGRAM' THEN
3336: x_item_table(p_tab_index).REPAIR_PROGRAM := cr.ATTRIBUTE_VALUE;
3337: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SUBCONTRACTING_COMPONENT' THEN
3338: x_item_table(p_tab_index).SUBCONTRACTING_COMPONENT := cr.ATTRIBUTE_VALUE;
3339: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.OUTSOURCED_ASSEMBLY' THEN
3340: x_item_table(p_tab_index).OUTSOURCED_ASSEMBLY := cr.ATTRIBUTE_VALUE;
3341:
3342: END IF; -- cr.ATTRIBUTE_NAME
3343: END LOOP; -- cursor c_get_template_attributes
3344:
3345: IF ( (l_org_id is NOT NULL) AND (l_org_id = p_organization_id) ) THEN
3346: FOR cr IN c_get_org_template_attributes (cp_template_id => p_template_id) LOOP
3347:
3348: IF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' THEN
3349: x_item_table(p_tab_index).BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;
3350: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' THEN
3351: x_item_table(p_tab_index).COST_OF_SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
3352: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' THEN
3346: FOR cr IN c_get_org_template_attributes (cp_template_id => p_template_id) LOOP
3347:
3348: IF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' THEN
3349: x_item_table(p_tab_index).BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;
3350: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' THEN
3351: x_item_table(p_tab_index).COST_OF_SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
3352: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' THEN
3353: x_item_table(p_tab_index).ENCUMBRANCE_ACCOUNT := cr.ATTRIBUTE_VALUE;
3354: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' THEN
3348: IF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID' THEN
3349: x_item_table(p_tab_index).BASE_ITEM_ID := cr.ATTRIBUTE_VALUE;
3350: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' THEN
3351: x_item_table(p_tab_index).COST_OF_SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
3352: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' THEN
3353: x_item_table(p_tab_index).ENCUMBRANCE_ACCOUNT := cr.ATTRIBUTE_VALUE;
3354: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' THEN
3355: x_item_table(p_tab_index).EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;
3356: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNER_CODE' THEN
3350: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT' THEN
3351: x_item_table(p_tab_index).COST_OF_SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
3352: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' THEN
3353: x_item_table(p_tab_index).ENCUMBRANCE_ACCOUNT := cr.ATTRIBUTE_VALUE;
3354: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' THEN
3355: x_item_table(p_tab_index).EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;
3356: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNER_CODE' THEN
3357: x_item_table(p_tab_index).PLANNER_CODE := cr.ATTRIBUTE_VALUE;
3358: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET' THEN
3352: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT' THEN
3353: x_item_table(p_tab_index).ENCUMBRANCE_ACCOUNT := cr.ATTRIBUTE_VALUE;
3354: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' THEN
3355: x_item_table(p_tab_index).EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;
3356: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNER_CODE' THEN
3357: x_item_table(p_tab_index).PLANNER_CODE := cr.ATTRIBUTE_VALUE;
3358: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET' THEN
3359: x_item_table(p_tab_index).PLANNING_EXCEPTION_SET := cr.ATTRIBUTE_VALUE;
3360: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT' THEN
3354: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT' THEN
3355: x_item_table(p_tab_index).EXPENSE_ACCOUNT := cr.ATTRIBUTE_VALUE;
3356: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNER_CODE' THEN
3357: x_item_table(p_tab_index).PLANNER_CODE := cr.ATTRIBUTE_VALUE;
3358: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET' THEN
3359: x_item_table(p_tab_index).PLANNING_EXCEPTION_SET := cr.ATTRIBUTE_VALUE;
3360: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT' THEN
3361: x_item_table(p_tab_index).SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
3362: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID' THEN
3356: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNER_CODE' THEN
3357: x_item_table(p_tab_index).PLANNER_CODE := cr.ATTRIBUTE_VALUE;
3358: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET' THEN
3359: x_item_table(p_tab_index).PLANNING_EXCEPTION_SET := cr.ATTRIBUTE_VALUE;
3360: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT' THEN
3361: x_item_table(p_tab_index).SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
3362: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID' THEN
3363: x_item_table(p_tab_index).WIP_SUPPLY_LOCATOR_ID := cr.ATTRIBUTE_VALUE;
3364: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY' THEN
3358: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.PLANNING_EXCEPTION_SET' THEN
3359: x_item_table(p_tab_index).PLANNING_EXCEPTION_SET := cr.ATTRIBUTE_VALUE;
3360: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT' THEN
3361: x_item_table(p_tab_index).SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
3362: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID' THEN
3363: x_item_table(p_tab_index).WIP_SUPPLY_LOCATOR_ID := cr.ATTRIBUTE_VALUE;
3364: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY' THEN
3365: x_item_table(p_tab_index).WIP_SUPPLY_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3366: END IF;
3360: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT' THEN
3361: x_item_table(p_tab_index).SALES_ACCOUNT := cr.ATTRIBUTE_VALUE;
3362: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID' THEN
3363: x_item_table(p_tab_index).WIP_SUPPLY_LOCATOR_ID := cr.ATTRIBUTE_VALUE;
3364: ELSIF cr.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_SUBINVENTORY' THEN
3365: x_item_table(p_tab_index).WIP_SUPPLY_SUBINVENTORY := cr.ATTRIBUTE_VALUE;
3366: END IF;
3367: END LOOP; -- cursor c_get_org_template_attributes
3368: END IF; -- cursor c_get_org_template_attributes
3535: END IF;
3536: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3537: X_MSG_COUNT := 0;
3538:
3539: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3540: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3541: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3542:
3543: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3539: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3540: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3541: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3542:
3543: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3544: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3545: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3546:
3547: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS
3543: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3544: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3545: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3546:
3547: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS
3548: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3549: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3550:
3551: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID
3591: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3592: X_MSG_COUNT OUT NOCOPY NUMBER) IS
3593:
3594: /*CURSOR ego_item_assigned_org_csr (
3595: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3596: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3597: IS
3598: SELECT ORGANIZATION_ID
3599: FROM MTL_SYSTEM_ITEMS_VL
3592: X_MSG_COUNT OUT NOCOPY NUMBER) IS
3593:
3594: /*CURSOR ego_item_assigned_org_csr (
3595: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3596: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3597: IS
3598: SELECT ORGANIZATION_ID
3599: FROM MTL_SYSTEM_ITEMS_VL
3600: WHERE INVENTORY_ITEM_ID = v_inventory_item_id
3595: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3596: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3597: IS
3598: SELECT ORGANIZATION_ID
3599: FROM MTL_SYSTEM_ITEMS_VL
3600: WHERE INVENTORY_ITEM_ID = v_inventory_item_id
3601: AND ORGANIZATION_ID <> v_master_organization_id;
3602: */
3603: /*Added for bug 7660662*/
3601: AND ORGANIZATION_ID <> v_master_organization_id;
3602: */
3603: /*Added for bug 7660662*/
3604: CURSOR ego_item_all_assigned_org_csr (
3605: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3606: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3607: IS
3608: SELECT ORGANIZATION_ID
3609: FROM MTL_SYSTEM_ITEMS_VL msi
3602: */
3603: /*Added for bug 7660662*/
3604: CURSOR ego_item_all_assigned_org_csr (
3605: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3606: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3607: IS
3608: SELECT ORGANIZATION_ID
3609: FROM MTL_SYSTEM_ITEMS_VL msi
3610: WHERE msi.INVENTORY_ITEM_ID = v_inventory_item_id
3605: v_inventory_item_id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
3606: v_master_organization_id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
3607: IS
3608: SELECT ORGANIZATION_ID
3609: FROM MTL_SYSTEM_ITEMS_VL msi
3610: WHERE msi.INVENTORY_ITEM_ID = v_inventory_item_id
3611: and exists (select 1 from mtl_parameters
3612: where organization_id=msi.organization_id
3613: and master_organization_id=v_master_organization_id);
3647:
3648: --IF (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID) THEN
3649: /*Changes for bug 7659489. Even when ICC is not associated to an item changes to Item status should be inserted into MTL_PENDING_ITEM_STATUSES
3650: so that the history of changes is properly logged*/
3651: L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
3652: IF (P_CATALOG_GROUP_ID IS NULL) THEN
3653: FOR rec IN ego_item_all_assigned_org_csr(v_inventory_item_id=> P_INVENTORY_ITEM_ID,v_master_organization_id => L_MASTER_ORGANIZATION_ID) LOOP
3654:
3655: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL
3651: L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
3652: IF (P_CATALOG_GROUP_ID IS NULL) THEN
3653: FOR rec IN ego_item_all_assigned_org_csr(v_inventory_item_id=> P_INVENTORY_ITEM_ID,v_master_organization_id => L_MASTER_ORGANIZATION_ID) LOOP
3654:
3655: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL
3656: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3657: AND ORGANIZATION_ID = rec.organization_id;
3658:
3659: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL
3655: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = NULL
3656: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3657: AND ORGANIZATION_ID = rec.organization_id;
3658:
3659: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = NULL
3660: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3661: AND ORGANIZATION_ID = rec.organization_id;
3662:
3663: /*Added for bug 7659489*/
3721: P_ITEM_STATUS);
3722: END IF;
3723: /*End of bug 7659489*/
3724: ELSE
3725: /*L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');*/ /*Commented for bug 7659489*/
3726:
3727: /*IF Master control then insert for all the organizations with Pending status as 'N'*/
3728: IF ((L_CONTROL_LEVEL = 1) AND (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID))
3729: THEN
3728: IF ((L_CONTROL_LEVEL = 1) AND (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID))
3729: THEN
3730: FOR rec IN ego_item_all_assigned_org_csr(v_inventory_item_id=> P_INVENTORY_ITEM_ID,v_master_organization_id => L_MASTER_ORGANIZATION_ID) LOOP
3731:
3732: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3733: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3734: AND ORGANIZATION_ID = rec.organization_id;
3735:
3736: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3732: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3733: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3734: AND ORGANIZATION_ID = rec.organization_id;
3735:
3736: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3737: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3738: AND ORGANIZATION_ID = rec.organization_id;
3739:
3740: if(L_UPDATE_STATUS_HIS_IND) then
3768: END LOOP;
3769: /*If Org controlled then insert only for the specific organization with pending status as 'N'*/
3770: ELSIF (L_CONTROL_LEVEL = 2) THEN
3771: -- Org Control
3772: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3773: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3774: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3775:
3776: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3772: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3773: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3774: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3775:
3776: UPDATE MTL_SYSTEM_ITEMS_B SET CURRENT_PHASE_ID = P_CURRENT_PHASE_ID
3777: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3778: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3779:
3780: if(L_UPDATE_STATUS_HIS_IND) then
3926: START WITH b.item_catalog_group_id = p_catalog_group_id;
3927:
3928: IF l_cat_count = 0 THEN
3929: SELECT COUNT(1) into l_total_count
3930: FROM mtl_system_items_b a
3931: WHERE a.organization_id = p_organization_id;
3932: ELSE
3933: SELECT COUNT(1) into l_total_count FROM mtl_system_items_b a
3934: WHERE a.organization_id = p_organization_id
3929: SELECT COUNT(1) into l_total_count
3930: FROM mtl_system_items_b a
3931: WHERE a.organization_id = p_organization_id;
3932: ELSE
3933: SELECT COUNT(1) into l_total_count FROM mtl_system_items_b a
3934: WHERE a.organization_id = p_organization_id
3935: AND item_catalog_group_id in (SELECT item_catalog_group_id
3936: FROM mtl_item_catalog_groups_b b
3937: CONNECT BY PRIOR item_catalog_group_id = parent_catalog_group_id
4154: -- ENG exists
4155: -- check for policy control
4156: l_dynamic_sql :=
4157: ' SELECT item_catalog_group_id, lifecycle_id, current_phase_id' ||
4158: ' FROM mtl_system_items_b ' ||
4159: ' WHERE inventory_item_id = :1' ||
4160: ' AND organization_id = :2';
4161: EXECUTE IMMEDIATE l_dynamic_sql
4162: INTO l_catalog_category_id, l_lifecycle_id, l_current_phase_id
4625: BEGIN
4626: IF p_inventory_item_id IS NULL THEN
4627: IF p_item_number IS NOT NULL THEN
4628: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4629: FROM MTL_SYSTEM_ITEMS_B_KFV
4630: WHERE ORGANIZATION_ID = l_organization_id
4631: AND CONCATENATED_SEGMENTS = p_item_number;
4632: ELSE
4633: RAISE INVALID_ITEM;
4633: RAISE INVALID_ITEM;
4634: END IF;
4635: ELSE
4636: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4637: FROM MTL_SYSTEM_ITEMS_B_KFV
4638: WHERE ORGANIZATION_ID = l_organization_id
4639: AND INVENTORY_ITEM_ID = p_inventory_item_id;
4640: END IF;
4641: