DBA Data[Home] [Help]

APPS.INVPULI4 dependencies on DBMS_SQL

Line 23: g_attribute_names dbms_sql.varchar2s;

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

Line 24: g_attribute_values dbms_sql.varchar2s;

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:

Line 25: g_status_control_codes dbms_sql.number_table;

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(

Line 26: g_control_levels dbms_sql.number_table;

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,