Advertisement
cgrunwald

Untitled

Jul 7th, 2012
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.65 KB | None | 0 0
  1. DECLARE
  2.     cursor c_qlpb IS
  3.              SELECT FROM_QTY,
  4.                          PRICE,
  5.                          USE,
  6.                          INITIAL_ORDER_FLAG
  7.                 FROM C3_QUOTE_LINE_PRICE_BREAKS
  8.                 WHERE QUOTE_LINE_ID = :P10_QUOTE_LINE_ID
  9.                 FOR UPDATE;
  10.    
  11.     v_qlpb c_qlpb%rowtype;
  12.    
  13. BEGIN
  14.  
  15.     OPEN c_qlpb;
  16.     fetch c_qlpb INTO v_qlpb;
  17.     close c_qlpb;
  18.  
  19.     FOR i IN 1..htmldb_application.g_f01.COUNT loop
  20.         UPDATE C3_QUOTE_LINE_PRICE_BREAKS
  21.             SET FROM_QTY = htmldb_application.g_f02(i),
  22.                 PRICE = htmldb_application.g_f03(i),
  23.                 USE = htmldb_application.g_f04(i),
  24.                 INITIAL_ORDER_FLAG = htmldb_application.g_f05(i),
  25.                 QUOTE_PRICE_BREAK_ID = htmldb_application.g_f01(i);
  26.     END loop;
  27.     commit;
  28.    
  29. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement