DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 37: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

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:

Line 38: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

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

Line 39: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE

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

Line 47: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

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:

Line 48: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

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

Line 49: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE

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

Line 57: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

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:

Line 58: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

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

Line 59: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE

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

Line 67: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

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: )

Line 69: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

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:

Line 70: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE

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

Line 166: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

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:

Line 167: p_inventory_org_id IN MTL_SYSTEM_ITEMS.organization_id%TYPE,

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