[Home] [Help]
3:
4:
5: /**
6: * The foll procedure has to update msc_sup_dem_entries with the
7: * updated values from the msc_hz_ui_lines table.
8: * The proc has to do the foll.
9: * - using the query id - select the rows that have the quantities updated
10: * (where qty_bucket(X) <> old_qty(X) )
11: * - for each of the delta values - select the corresponding
813: v_old_qty16,v_old_qty17,v_old_qty18,v_old_qty19,v_old_qty20,v_old_qty21,v_old_qty22,
814: v_old_qty23,v_old_qty24,v_old_qty25,v_old_qty26,v_old_qty27,v_old_qty28,v_old_qty29,
815: v_old_qty30,v_old_qty31,v_old_qty32,v_old_qty33,v_old_qty34,v_old_qty35,v_old_qty36,
816: v_pub_site_id
817: FROM msc_hz_ui_lines
818: WHERE query_id = arg_query_id
819: AND editable_flag = 0
820: AND ( ((nvl(qty_bucket1,0) - nvl(old_qty1,0)) <> 0 AND qty_bucket1 is not null) OR ((nvl(qty_bucket2,0) - nvl(old_qty2,0)) <> 0 AND qty_bucket2 is not null) OR
821: ((nvl(qty_bucket3,0) - nvl(old_qty3,0)) <> 0 AND qty_bucket3 is not null) OR ((nvl(qty_bucket4,0) - nvl(old_qty4,0)) <> 0 AND qty_bucket4 is not null) OR