APPS.GMLCOPPR dependencies on OP_CHRG_BRK

Line 756: CURSOR Cur_chrg_brk ( V_old_charge_id OP_CHRG_BRK.CHARGE_ID%TYPE) IS

752: SELECT *
753: FROM op_chrg_mst
754: WHERE charge_id = p_old_charge_id;
755:
756: CURSOR Cur_chrg_brk ( V_old_charge_id OP_CHRG_BRK.CHARGE_ID%TYPE) IS
757: SELECT *
758: FROM op_chrg_brk
759: WHERE charge_id = V_old_charge_id;
760:

Line 758: FROM op_chrg_brk

754: WHERE charge_id = p_old_charge_id;
755:
756: CURSOR Cur_chrg_brk ( V_old_charge_id OP_CHRG_BRK.CHARGE_ID%TYPE) IS
757: SELECT *
758: FROM op_chrg_brk
759: WHERE charge_id = V_old_charge_id;
760:
761: /* Composites */
762: V_chrg_mst Cur_chrg_mst%ROWTYPE ;

Line 769: X_chrgbreak_id OP_CHRG_BRK.CHRGBREAK_ID%TYPE;

765: X_charge_id OP_CHRG_MST.CHARGE_ID%TYPE;
766: X_base_rate OP_CHRG_MST.BASE_RATE%TYPE;
767: X_base_amount OP_CHRG_MST.BASE_AMOUNT%TYPE;
768: X_base_per_unit OP_CHRG_MST.BASE_PER_UNIT%TYPE;
769: X_chrgbreak_id OP_CHRG_BRK.CHRGBREAK_ID%TYPE;
770: X_chrg_mst_text_code OP_CHRG_MST.TEXT_CODE%TYPE ;
771: X_breakpoint_price OP_CHRG_BRK.BREAKPOINT_PRICE%TYPE;
772:
773: /* Variable that decides if sign of the charge amounts/rates needs to be changed because of */

Line 771: X_breakpoint_price OP_CHRG_BRK.BREAKPOINT_PRICE%TYPE;

767: X_base_amount OP_CHRG_MST.BASE_AMOUNT%TYPE;
768: X_base_per_unit OP_CHRG_MST.BASE_PER_UNIT%TYPE;
769: X_chrgbreak_id OP_CHRG_BRK.CHRGBREAK_ID%TYPE;
770: X_chrg_mst_text_code OP_CHRG_MST.TEXT_CODE%TYPE ;
771: X_breakpoint_price OP_CHRG_BRK.BREAKPOINT_PRICE%TYPE;
772:
773: /* Variable that decides if sign of the charge amounts/rates needs to be changed because of */
774: /* change in type of charge. */
775: X_change_sign VARCHAR(1) DEFAULT 'N';

Line 960: /* Now insert corresponding break rows into OP_CHRG_BRK */

956: v_chrg_mst.attribute29 , v_chrg_mst.attribute30 ,
957: v_chrg_mst.attribute_category
958: FROM DUAL ;
959:
960: /* Now insert corresponding break rows into OP_CHRG_BRK */
961: FOR v_chrg_brk IN cur_chrg_brk(P_old_charge_id ) LOOP
962: X_chrgbreak_id := create_chargebreak_id;
963:
964: /* Calculate new break price based on the price change type and change. */

Line 980: INSERT INTO OP_CHRG_BRK

976: IF ( X_change_sign = 'Y' ) AND (X_breakpoint_price IS NOT NULL) AND (X_breakpoint_price <> 0 ) THEN
977: X_breakpoint_price := X_breakpoint_price * (-1);
978: END IF;
979:
980: INSERT INTO OP_CHRG_BRK
981: ( chrgbreak_id , charge_id ,
982: qty_breakpoint , value_breakpoint ,
983: breakpoint_factor , breakpoint_price ,
984: created_by , last_update_date ,