DBA Data[Home] [Help]

APPS.BOM_IMPORT_PUB dependencies on BOM_ATTR_DIFF_TABLE_TYPE

Line 2144: ) RETURN Bom_Attr_Diff_Table_Type

2140: , p_op_seq_num NUMBER
2141: , p_item_id NUMBER
2142: , p_org_id NUMBER
2143: , p_intf_uniq_id NUMBER
2144: ) RETURN Bom_Attr_Diff_Table_Type
2145: IS
2146: TYPE tab_typ IS TABLE OF VARCHAR2(3200);
2147: TYPE num_type IS TABLE OF NUMBER;
2148:

Line 2155: l_attr_diff Bom_Attr_Diff_Table_Type := Bom_Attr_Diff_Table_Type();

2151: l_attr_sql1 VARCHAR2(10000);
2152: l_pdh_query VARCHAR2(1000);
2153: l_src_query VARCHAR2(1000);
2154: l_where_clause VARCHAR2(1000);
2155: l_attr_diff Bom_Attr_Diff_Table_Type := Bom_Attr_Diff_Table_Type();
2156: l_temp_table num_type;
2157: l_name_table tab_typ;
2158:
2159: l_eff_date_intf DATE;