DBA Data[Home] [Help]

APPS.BOM_IMPORT_PUB dependencies on BOM_ATTR_DIFF_TABLE_TYPE

Line 2287: ) RETURN Bom_Attr_Diff_Table_Type

2283: , p_op_seq_num NUMBER
2284: , p_item_id NUMBER
2285: , p_org_id NUMBER
2286: , p_intf_uniq_id NUMBER
2287: ) RETURN Bom_Attr_Diff_Table_Type
2288: IS
2289: TYPE tab_typ IS TABLE OF VARCHAR2(3200);
2290: TYPE num_type IS TABLE OF NUMBER;
2291:

Line 2298: l_attr_diff Bom_Attr_Diff_Table_Type := Bom_Attr_Diff_Table_Type();

2294: l_attr_sql1 VARCHAR2(10000);
2295: l_pdh_query VARCHAR2(1000);
2296: l_src_query VARCHAR2(1000);
2297: l_where_clause VARCHAR2(1000);
2298: l_attr_diff Bom_Attr_Diff_Table_Type := Bom_Attr_Diff_Table_Type();
2299: l_temp_table num_type;
2300: l_name_table tab_typ;
2301:
2302: l_eff_date_intf DATE;