APPS.INV_LOT_SERIAL_UPGRADE dependencies on INV_LOT_SEL_ATTR

Line 37: l_attribute_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

33:
34: l_lot_count NUMBER;
35: l_upgrade_count NUMBER;
36: l_context_code VARCHAR2(30);
37: l_attribute_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
38: l_null_attribute inv_lot_sel_attr.lot_sel_attributes_tbl_type;
39: l_attribute_default_count NUMBER := 0;
40: l_update_count NUMBER := 0;
41: l_return_status VARCHAR2(10);

Line 38: l_null_attribute inv_lot_sel_attr.lot_sel_attributes_tbl_type;

34: l_lot_count NUMBER;
35: l_upgrade_count NUMBER;
36: l_context_code VARCHAR2(30);
37: l_attribute_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
38: l_null_attribute inv_lot_sel_attr.lot_sel_attributes_tbl_type;
39: l_attribute_default_count NUMBER := 0;
40: l_update_count NUMBER := 0;
41: l_return_status VARCHAR2(10);
42: l_msg_count NUMBER := 0;

Line 68: INV_LOT_SEL_ATTR.GET_CONTEXT_CODE(

64: -- Step 1. Get the context code for the lot
65: -- we only need to run this for every org/item, not every lot
66: IF((v_lot.inventory_item_id <> l_previous_item_id) OR
67: (v_lot.organization_id <> l_previous_org_id)) THEN
68: INV_LOT_SEL_ATTR.GET_CONTEXT_CODE(
69: context_value => l_context_code
70: , org_id => v_lot.organization_id
71: , item_id => v_lot.inventory_item_id
72: , flex_name => LOT_FLEX_NAME);

Line 81: INV_LOT_SEL_ATTR.GET_DEFAULT(

77: IF l_context_code IS NOT NULL THEN
78: l_lot_count := l_lot_count + 1;
79:
80: -- Step 2. Get the default attribute for this lot
81: INV_LOT_SEL_ATTR.GET_DEFAULT(
82: x_attributes_default => l_attribute_default
83: , x_attributes_default_count => l_attribute_default_count
84: , x_return_status => l_return_status
85: , x_msg_count => l_msg_count

Line 162: l_attribute_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

158:
159: l_serial_count NUMBER;
160: l_upgrade_count NUMBER;
161: l_context_code VARCHAR2(30);
162: l_attribute_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
163: l_null_attribute inv_lot_sel_attr.lot_sel_attributes_tbl_type;
164: l_attribute_default_count NUMBER := 0;
165: l_update_count NUMBER := 0;
166: l_return_status VARCHAR2(10);

Line 163: l_null_attribute inv_lot_sel_attr.lot_sel_attributes_tbl_type;

159: l_serial_count NUMBER;
160: l_upgrade_count NUMBER;
161: l_context_code VARCHAR2(30);
162: l_attribute_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
163: l_null_attribute inv_lot_sel_attr.lot_sel_attributes_tbl_type;
164: l_attribute_default_count NUMBER := 0;
165: l_update_count NUMBER := 0;
166: l_return_status VARCHAR2(10);
167: l_msg_count NUMBER := 0;

Line 192: INV_LOT_SEL_ATTR.GET_CONTEXT_CODE(

188: -- Step 1. Get the context code for the serial
189: -- we only need to run this for every org/item, not every serial
190: IF((v_serial.inventory_item_id <> l_previous_item_id) OR
191: (v_serial.current_organization_id <> l_previous_org_id)) THEN
192: INV_LOT_SEL_ATTR.GET_CONTEXT_CODE(
193: context_value => l_context_code
194: , org_id => v_serial.current_organization_id
195: , item_id => v_serial.inventory_item_id
196: , flex_name => SERIAL_FLEX_NAME);

Line 205: INV_LOT_SEL_ATTR.GET_DEFAULT(

201:
202: IF l_context_code IS NOT NULL THEN
203: l_serial_count := l_serial_count + 1;
204: -- Step 2. Get the default attribute for this serial
205: INV_LOT_SEL_ATTR.GET_DEFAULT(
206: x_attributes_default => l_attribute_default
207: , x_attributes_default_count => l_attribute_default_count
208: , x_return_status => l_return_status
209: , x_msg_count => l_msg_count

Line 286: , p_attributes IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

282: , p_organization_id IN NUMBER
283: , p_inventory_item_id IN NUMBER
284: , p_lot_serial_number IN VARCHAR2
285: , p_attribute_category IN VARCHAR2
286: , p_attributes IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
287: )IS
288:
289: l_update_cur INTEGER;
290: l_update_stmt VARCHAR2(1000);