19: */
20:
21: -- bug 7137702 : new variables for caching purpose
22: g_item_status_code mtl_item_status.inventory_item_status_code%TYPE;
23: g_attribute_names dbms_sql.varchar2s;
24: g_attribute_values dbms_sql.varchar2s;
25: g_status_control_codes dbms_sql.number_table;
26: g_control_levels dbms_sql.number_table;
27: -- end bug 7137702
20:
21: -- bug 7137702 : new variables for caching purpose
22: g_item_status_code mtl_item_status.inventory_item_status_code%TYPE;
23: g_attribute_names dbms_sql.varchar2s;
24: g_attribute_values dbms_sql.varchar2s;
25: g_status_control_codes dbms_sql.number_table;
26: g_control_levels dbms_sql.number_table;
27: -- end bug 7137702
28:
21: -- bug 7137702 : new variables for caching purpose
22: g_item_status_code mtl_item_status.inventory_item_status_code%TYPE;
23: g_attribute_names dbms_sql.varchar2s;
24: g_attribute_values dbms_sql.varchar2s;
25: g_status_control_codes dbms_sql.number_table;
26: g_control_levels dbms_sql.number_table;
27: -- end bug 7137702
28:
29: FUNCTION assign_status_attributes(
22: g_item_status_code mtl_item_status.inventory_item_status_code%TYPE;
23: g_attribute_names dbms_sql.varchar2s;
24: g_attribute_values dbms_sql.varchar2s;
25: g_status_control_codes dbms_sql.number_table;
26: g_control_levels dbms_sql.number_table;
27: -- end bug 7137702
28:
29: FUNCTION assign_status_attributes(
30: item_id number,