5466: l_incentive NUMBER := 0;
5467: l_total_incentive NUMBER := 0;
5468: l_total_current_amount NUMBER := 0;
5469:
5470: l_bid_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5471: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5472: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5473: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5474: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5467: l_total_incentive NUMBER := 0;
5468: l_total_current_amount NUMBER := 0;
5469:
5470: l_bid_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5471: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5472: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5473: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5474: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5475: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5468: l_total_current_amount NUMBER := 0;
5469:
5470: l_bid_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5471: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5472: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5473: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5474: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5475: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5476: l_current_rebate_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5469:
5470: l_bid_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5471: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5472: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5473: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5474: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5475: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5476: l_current_rebate_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5477:
5470: l_bid_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5471: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5472: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5473: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5474: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5475: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5476: l_current_rebate_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5477:
5478: BEGIN
5471: l_award_total_sum_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5472: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5473: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5474: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5475: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5476: l_current_rebate_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5477:
5478: BEGIN
5479:
5472: l_savings_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5473: l_current_amount_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5474: l_current_total_spend_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5475: l_fixed_incentive_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5476: l_current_rebate_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5477:
5478: BEGIN
5479:
5480: SELECT