4250: l_incentive NUMBER := 0;
4251: l_total_incentive NUMBER := 0;
4252: l_total_current_amount NUMBER := 0;
4253:
4254: l_bid_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4255: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4256: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4257: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4258: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4251: l_total_incentive NUMBER := 0;
4252: l_total_current_amount NUMBER := 0;
4253:
4254: l_bid_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4255: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4256: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4257: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4258: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4259: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4252: l_total_current_amount NUMBER := 0;
4253:
4254: l_bid_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4255: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4256: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4257: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4258: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4259: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4260: l_current_rebate_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4253:
4254: l_bid_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4255: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4256: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4257: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4258: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4259: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4260: l_current_rebate_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4261:
4254: l_bid_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4255: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4256: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4257: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4258: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4259: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4260: l_current_rebate_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4261:
4262: BEGIN
4255: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4256: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4257: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4258: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4259: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4260: l_current_rebate_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4261:
4262: BEGIN
4263:
4256: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4257: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4258: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4259: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4260: l_current_rebate_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
4261:
4262: BEGIN
4263:
4264: SELECT