18758: l_running_total_pa_qty NUMBER := 0;
18759: l_max_pa_quantity NUMBER := 0;
18760: l_max_i_pa_qty BINARY_INTEGER := 0;
18761: l_first_pa_qty BOOLEAN := TRUE;
18762: l_award_set_id AP_DISTRIBUTION_SET_LINES.award_id%TYPE;
18763: l_award_id AP_DISTRIBUTION_SET_LINES.award_id%TYPE;
18764: l_msg_application VARCHAR2(25);
18765: l_msg_type VARCHAR2(25);
18766: l_msg_token1 VARCHAR2(30);
18759: l_max_pa_quantity NUMBER := 0;
18760: l_max_i_pa_qty BINARY_INTEGER := 0;
18761: l_first_pa_qty BOOLEAN := TRUE;
18762: l_award_set_id AP_DISTRIBUTION_SET_LINES.award_id%TYPE;
18763: l_award_id AP_DISTRIBUTION_SET_LINES.award_id%TYPE;
18764: l_msg_application VARCHAR2(25);
18765: l_msg_type VARCHAR2(25);
18766: l_msg_token1 VARCHAR2(30);
18767: l_msg_token2 VARCHAR2(30);
18807: DSL.org_id,
18808: DSL.award_id,
18809: 0, -- amount
18810: 0 -- base_amount
18811: FROM ap_distribution_set_lines DSL
18812: WHERE DSL.distribution_set_id = l_dist_set_id
18813: ORDER BY distribution_set_line_number;
18814:
18815: l_sys_link_function varchar2(2); ---bugfix:5725904