33: PROCEDURE validate_adt_item
34: (
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
38: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
39: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
40: );
41:
34: (
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
38: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
39: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
40: );
41:
42: -- Procedure to validate Component Item
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
38: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
39: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
40: );
41:
42: -- Procedure to validate Component Item
43: PROCEDURE validate_item
43: PROCEDURE validate_item
44: (
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
48: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
49: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
50: );
51:
44: (
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
48: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
49: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
50: );
51:
52: -- Procedure to validate Service Item
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
48: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
49: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
50: );
51:
52: -- Procedure to validate Service Item
53: PROCEDURE validate_service_item
53: PROCEDURE validate_service_item
54: (
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
58: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
59: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
60: );
61:
54: (
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
58: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
59: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
60: );
61:
62: -- Procedure to validate effectivity Item
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
58: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
59: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
60: );
61:
62: -- Procedure to validate effectivity Item
63: PROCEDURE validate_effectivity_item
63: PROCEDURE validate_effectivity_item
64: (
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
68: p_org_code IN MTL_PARAMETERS.ORGANIZATION_CODE%TYPE,
69: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
70: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
71: )
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
68: p_org_code IN MTL_PARAMETERS.ORGANIZATION_CODE%TYPE,
69: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
70: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
71: )
72: ;
73:
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
68: p_org_code IN MTL_PARAMETERS.ORGANIZATION_CODE%TYPE,
69: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
70: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
71: )
72: ;
73:
74: -- Procedure to validate Accounting class
162: (
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_item_group_id IN AHL_ITEM_GROUPS_VL.item_group_id%TYPE,
166: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
167: p_inventory_org_id IN MTL_SYSTEM_ITEMS.organization_id%TYPE,
168: p_uom_code IN MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
169: );
170:
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_item_group_id IN AHL_ITEM_GROUPS_VL.item_group_id%TYPE,
166: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
167: p_inventory_org_id IN MTL_SYSTEM_ITEMS.organization_id%TYPE,
168: p_uom_code IN MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
169: );
170:
171: -- Procedure to validate Product Type and Zone association