Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- cursor c_qlpb IS
- SELECT FROM_QTY,
- PRICE,
- USE,
- INITIAL_ORDER_FLAG
- FROM C3_QUOTE_LINE_PRICE_BREAKS
- WHERE QUOTE_LINE_ID = :P10_QUOTE_LINE_ID
- FOR UPDATE;
- v_qlpb c_qlpb%rowtype;
- BEGIN
- OPEN c_qlpb;
- fetch c_qlpb INTO v_qlpb;
- close c_qlpb;
- FOR i IN 1..htmldb_application.g_f01.COUNT loop
- UPDATE C3_QUOTE_LINE_PRICE_BREAKS
- SET FROM_QTY = htmldb_application.g_f02(i),
- PRICE = htmldb_application.g_f03(i),
- USE = htmldb_application.g_f04(i),
- INITIAL_ORDER_FLAG = htmldb_application.g_f05(i),
- QUOTE_PRICE_BREAK_ID = htmldb_application.g_f01(i);
- END loop;
- commit;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement