89: ADSL.attribute13,
90: ADSL.attribute14,
91: ADSL.attribute15,
92: ADSL.type_1099
93: FROM AP_Distribution_Set_Lines ADSL,
94: GL_Code_combinations GL
95: WHERE distribution_set_id = X_invoice_lines_rec.Distribution_Set_id
96: AND GL.code_combination_id = ADSL.dist_code_combination_id
97: ORDER BY distribution_set_line_number;
101: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
102: user_id NUMBER;
103: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
104: l_dset_line_ccid
105: AP_DISTRIBUTION_SET_LINES.DIST_CODE_COMBINATION_ID%TYPE;
106: l_dset_dist_line_num
107: AP_DISTRIBUTION_SET_LINES.DISTRIBUTION_SET_LINE_NUMBER%TYPE;
108: l_dset_line_description AP_DISTRIBUTION_SET_LINES.DESCRIPTION%TYPE;
109: l_dset_line_type_1099 AP_DISTRIBUTION_SET_LINES.TYPE_1099%TYPE;
103: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
104: l_dset_line_ccid
105: AP_DISTRIBUTION_SET_LINES.DIST_CODE_COMBINATION_ID%TYPE;
106: l_dset_dist_line_num
107: AP_DISTRIBUTION_SET_LINES.DISTRIBUTION_SET_LINE_NUMBER%TYPE;
108: l_dset_line_description AP_DISTRIBUTION_SET_LINES.DESCRIPTION%TYPE;
109: l_dset_line_type_1099 AP_DISTRIBUTION_SET_LINES.TYPE_1099%TYPE;
110: l_dset_line_project_id AP_DISTRIBUTION_SET_LINES.PROJECT_ID%TYPE;
111: l_dset_line_task_id AP_DISTRIBUTION_SET_LINES.TASK_ID%TYPE;
104: l_dset_line_ccid
105: AP_DISTRIBUTION_SET_LINES.DIST_CODE_COMBINATION_ID%TYPE;
106: l_dset_dist_line_num
107: AP_DISTRIBUTION_SET_LINES.DISTRIBUTION_SET_LINE_NUMBER%TYPE;
108: l_dset_line_description AP_DISTRIBUTION_SET_LINES.DESCRIPTION%TYPE;
109: l_dset_line_type_1099 AP_DISTRIBUTION_SET_LINES.TYPE_1099%TYPE;
110: l_dset_line_project_id AP_DISTRIBUTION_SET_LINES.PROJECT_ID%TYPE;
111: l_dset_line_task_id AP_DISTRIBUTION_SET_LINES.TASK_ID%TYPE;
112: l_dset_line_expenditure_type AP_DISTRIBUTION_SET_LINES.EXPENDITURE_TYPE%TYPE;
105: AP_DISTRIBUTION_SET_LINES.DIST_CODE_COMBINATION_ID%TYPE;
106: l_dset_dist_line_num
107: AP_DISTRIBUTION_SET_LINES.DISTRIBUTION_SET_LINE_NUMBER%TYPE;
108: l_dset_line_description AP_DISTRIBUTION_SET_LINES.DESCRIPTION%TYPE;
109: l_dset_line_type_1099 AP_DISTRIBUTION_SET_LINES.TYPE_1099%TYPE;
110: l_dset_line_project_id AP_DISTRIBUTION_SET_LINES.PROJECT_ID%TYPE;
111: l_dset_line_task_id AP_DISTRIBUTION_SET_LINES.TASK_ID%TYPE;
112: l_dset_line_expenditure_type AP_DISTRIBUTION_SET_LINES.EXPENDITURE_TYPE%TYPE;
113: l_dset_line_expenditure_org_id
106: l_dset_dist_line_num
107: AP_DISTRIBUTION_SET_LINES.DISTRIBUTION_SET_LINE_NUMBER%TYPE;
108: l_dset_line_description AP_DISTRIBUTION_SET_LINES.DESCRIPTION%TYPE;
109: l_dset_line_type_1099 AP_DISTRIBUTION_SET_LINES.TYPE_1099%TYPE;
110: l_dset_line_project_id AP_DISTRIBUTION_SET_LINES.PROJECT_ID%TYPE;
111: l_dset_line_task_id AP_DISTRIBUTION_SET_LINES.TASK_ID%TYPE;
112: l_dset_line_expenditure_type AP_DISTRIBUTION_SET_LINES.EXPENDITURE_TYPE%TYPE;
113: l_dset_line_expenditure_org_id
114: AP_DISTRIBUTION_SET_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
107: AP_DISTRIBUTION_SET_LINES.DISTRIBUTION_SET_LINE_NUMBER%TYPE;
108: l_dset_line_description AP_DISTRIBUTION_SET_LINES.DESCRIPTION%TYPE;
109: l_dset_line_type_1099 AP_DISTRIBUTION_SET_LINES.TYPE_1099%TYPE;
110: l_dset_line_project_id AP_DISTRIBUTION_SET_LINES.PROJECT_ID%TYPE;
111: l_dset_line_task_id AP_DISTRIBUTION_SET_LINES.TASK_ID%TYPE;
112: l_dset_line_expenditure_type AP_DISTRIBUTION_SET_LINES.EXPENDITURE_TYPE%TYPE;
113: l_dset_line_expenditure_org_id
114: AP_DISTRIBUTION_SET_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
115: l_dset_line_proj_acct_context
108: l_dset_line_description AP_DISTRIBUTION_SET_LINES.DESCRIPTION%TYPE;
109: l_dset_line_type_1099 AP_DISTRIBUTION_SET_LINES.TYPE_1099%TYPE;
110: l_dset_line_project_id AP_DISTRIBUTION_SET_LINES.PROJECT_ID%TYPE;
111: l_dset_line_task_id AP_DISTRIBUTION_SET_LINES.TASK_ID%TYPE;
112: l_dset_line_expenditure_type AP_DISTRIBUTION_SET_LINES.EXPENDITURE_TYPE%TYPE;
113: l_dset_line_expenditure_org_id
114: AP_DISTRIBUTION_SET_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
115: l_dset_line_proj_acct_context
116: AP_DISTRIBUTION_SET_LINES.PROJECT_ACCOUNTING_CONTEXT%TYPE;
110: l_dset_line_project_id AP_DISTRIBUTION_SET_LINES.PROJECT_ID%TYPE;
111: l_dset_line_task_id AP_DISTRIBUTION_SET_LINES.TASK_ID%TYPE;
112: l_dset_line_expenditure_type AP_DISTRIBUTION_SET_LINES.EXPENDITURE_TYPE%TYPE;
113: l_dset_line_expenditure_org_id
114: AP_DISTRIBUTION_SET_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
115: l_dset_line_proj_acct_context
116: AP_DISTRIBUTION_SET_LINES.PROJECT_ACCOUNTING_CONTEXT%TYPE;
117: l_dset_line_award_id AP_DISTRIBUTION_SET_LINES.AWARD_ID%TYPE;
118: l_award_id AP_DISTRIBUTION_SET_LINES.AWARD_ID%TYPE;
112: l_dset_line_expenditure_type AP_DISTRIBUTION_SET_LINES.EXPENDITURE_TYPE%TYPE;
113: l_dset_line_expenditure_org_id
114: AP_DISTRIBUTION_SET_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
115: l_dset_line_proj_acct_context
116: AP_DISTRIBUTION_SET_LINES.PROJECT_ACCOUNTING_CONTEXT%TYPE;
117: l_dset_line_award_id AP_DISTRIBUTION_SET_LINES.AWARD_ID%TYPE;
118: l_award_id AP_DISTRIBUTION_SET_LINES.AWARD_ID%TYPE;
119: l_dset_line_percent_dist
120: AP_DISTRIBUTION_SET_LINES.PERCENT_DISTRIBUTION%TYPE;
113: l_dset_line_expenditure_org_id
114: AP_DISTRIBUTION_SET_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
115: l_dset_line_proj_acct_context
116: AP_DISTRIBUTION_SET_LINES.PROJECT_ACCOUNTING_CONTEXT%TYPE;
117: l_dset_line_award_id AP_DISTRIBUTION_SET_LINES.AWARD_ID%TYPE;
118: l_award_id AP_DISTRIBUTION_SET_LINES.AWARD_ID%TYPE;
119: l_dset_line_percent_dist
120: AP_DISTRIBUTION_SET_LINES.PERCENT_DISTRIBUTION%TYPE;
121: l_dset_line_attribute_category
114: AP_DISTRIBUTION_SET_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
115: l_dset_line_proj_acct_context
116: AP_DISTRIBUTION_SET_LINES.PROJECT_ACCOUNTING_CONTEXT%TYPE;
117: l_dset_line_award_id AP_DISTRIBUTION_SET_LINES.AWARD_ID%TYPE;
118: l_award_id AP_DISTRIBUTION_SET_LINES.AWARD_ID%TYPE;
119: l_dset_line_percent_dist
120: AP_DISTRIBUTION_SET_LINES.PERCENT_DISTRIBUTION%TYPE;
121: l_dset_line_attribute_category
122: AP_DISTRIBUTION_SET_LINES.ATTRIBUTE_CATEGORY%TYPE;
116: AP_DISTRIBUTION_SET_LINES.PROJECT_ACCOUNTING_CONTEXT%TYPE;
117: l_dset_line_award_id AP_DISTRIBUTION_SET_LINES.AWARD_ID%TYPE;
118: l_award_id AP_DISTRIBUTION_SET_LINES.AWARD_ID%TYPE;
119: l_dset_line_percent_dist
120: AP_DISTRIBUTION_SET_LINES.PERCENT_DISTRIBUTION%TYPE;
121: l_dset_line_attribute_category
122: AP_DISTRIBUTION_SET_LINES.ATTRIBUTE_CATEGORY%TYPE;
123: l_dset_line_attribute1 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE1%TYPE;
124: l_dset_line_attribute2 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE2%TYPE;
118: l_award_id AP_DISTRIBUTION_SET_LINES.AWARD_ID%TYPE;
119: l_dset_line_percent_dist
120: AP_DISTRIBUTION_SET_LINES.PERCENT_DISTRIBUTION%TYPE;
121: l_dset_line_attribute_category
122: AP_DISTRIBUTION_SET_LINES.ATTRIBUTE_CATEGORY%TYPE;
123: l_dset_line_attribute1 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE1%TYPE;
124: l_dset_line_attribute2 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE2%TYPE;
125: l_dset_line_attribute3 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE3%TYPE;
126: l_dset_line_attribute4 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE4%TYPE;
119: l_dset_line_percent_dist
120: AP_DISTRIBUTION_SET_LINES.PERCENT_DISTRIBUTION%TYPE;
121: l_dset_line_attribute_category
122: AP_DISTRIBUTION_SET_LINES.ATTRIBUTE_CATEGORY%TYPE;
123: l_dset_line_attribute1 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE1%TYPE;
124: l_dset_line_attribute2 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE2%TYPE;
125: l_dset_line_attribute3 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE3%TYPE;
126: l_dset_line_attribute4 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE4%TYPE;
127: l_dset_line_attribute5 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE5%TYPE;
120: AP_DISTRIBUTION_SET_LINES.PERCENT_DISTRIBUTION%TYPE;
121: l_dset_line_attribute_category
122: AP_DISTRIBUTION_SET_LINES.ATTRIBUTE_CATEGORY%TYPE;
123: l_dset_line_attribute1 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE1%TYPE;
124: l_dset_line_attribute2 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE2%TYPE;
125: l_dset_line_attribute3 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE3%TYPE;
126: l_dset_line_attribute4 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE4%TYPE;
127: l_dset_line_attribute5 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE5%TYPE;
128: l_dset_line_attribute6 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE6%TYPE;
121: l_dset_line_attribute_category
122: AP_DISTRIBUTION_SET_LINES.ATTRIBUTE_CATEGORY%TYPE;
123: l_dset_line_attribute1 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE1%TYPE;
124: l_dset_line_attribute2 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE2%TYPE;
125: l_dset_line_attribute3 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE3%TYPE;
126: l_dset_line_attribute4 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE4%TYPE;
127: l_dset_line_attribute5 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE5%TYPE;
128: l_dset_line_attribute6 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE6%TYPE;
129: l_dset_line_attribute7 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE7%TYPE;
122: AP_DISTRIBUTION_SET_LINES.ATTRIBUTE_CATEGORY%TYPE;
123: l_dset_line_attribute1 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE1%TYPE;
124: l_dset_line_attribute2 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE2%TYPE;
125: l_dset_line_attribute3 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE3%TYPE;
126: l_dset_line_attribute4 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE4%TYPE;
127: l_dset_line_attribute5 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE5%TYPE;
128: l_dset_line_attribute6 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE6%TYPE;
129: l_dset_line_attribute7 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE7%TYPE;
130: l_dset_line_attribute8 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE8%TYPE;
123: l_dset_line_attribute1 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE1%TYPE;
124: l_dset_line_attribute2 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE2%TYPE;
125: l_dset_line_attribute3 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE3%TYPE;
126: l_dset_line_attribute4 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE4%TYPE;
127: l_dset_line_attribute5 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE5%TYPE;
128: l_dset_line_attribute6 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE6%TYPE;
129: l_dset_line_attribute7 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE7%TYPE;
130: l_dset_line_attribute8 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE8%TYPE;
131: l_dset_line_attribute9 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE9%TYPE;
124: l_dset_line_attribute2 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE2%TYPE;
125: l_dset_line_attribute3 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE3%TYPE;
126: l_dset_line_attribute4 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE4%TYPE;
127: l_dset_line_attribute5 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE5%TYPE;
128: l_dset_line_attribute6 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE6%TYPE;
129: l_dset_line_attribute7 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE7%TYPE;
130: l_dset_line_attribute8 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE8%TYPE;
131: l_dset_line_attribute9 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE9%TYPE;
132: l_dset_line_attribute10 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE10%TYPE;
125: l_dset_line_attribute3 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE3%TYPE;
126: l_dset_line_attribute4 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE4%TYPE;
127: l_dset_line_attribute5 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE5%TYPE;
128: l_dset_line_attribute6 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE6%TYPE;
129: l_dset_line_attribute7 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE7%TYPE;
130: l_dset_line_attribute8 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE8%TYPE;
131: l_dset_line_attribute9 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE9%TYPE;
132: l_dset_line_attribute10 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE10%TYPE;
133: l_dset_line_attribute11 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE11%TYPE;
126: l_dset_line_attribute4 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE4%TYPE;
127: l_dset_line_attribute5 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE5%TYPE;
128: l_dset_line_attribute6 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE6%TYPE;
129: l_dset_line_attribute7 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE7%TYPE;
130: l_dset_line_attribute8 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE8%TYPE;
131: l_dset_line_attribute9 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE9%TYPE;
132: l_dset_line_attribute10 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE10%TYPE;
133: l_dset_line_attribute11 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE11%TYPE;
134: l_dset_line_attribute12 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE12%TYPE;
127: l_dset_line_attribute5 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE5%TYPE;
128: l_dset_line_attribute6 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE6%TYPE;
129: l_dset_line_attribute7 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE7%TYPE;
130: l_dset_line_attribute8 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE8%TYPE;
131: l_dset_line_attribute9 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE9%TYPE;
132: l_dset_line_attribute10 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE10%TYPE;
133: l_dset_line_attribute11 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE11%TYPE;
134: l_dset_line_attribute12 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE12%TYPE;
135: l_dset_line_attribute13 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE13%TYPE;
128: l_dset_line_attribute6 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE6%TYPE;
129: l_dset_line_attribute7 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE7%TYPE;
130: l_dset_line_attribute8 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE8%TYPE;
131: l_dset_line_attribute9 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE9%TYPE;
132: l_dset_line_attribute10 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE10%TYPE;
133: l_dset_line_attribute11 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE11%TYPE;
134: l_dset_line_attribute12 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE12%TYPE;
135: l_dset_line_attribute13 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE13%TYPE;
136: l_dset_line_attribute14 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE14%TYPE;
129: l_dset_line_attribute7 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE7%TYPE;
130: l_dset_line_attribute8 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE8%TYPE;
131: l_dset_line_attribute9 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE9%TYPE;
132: l_dset_line_attribute10 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE10%TYPE;
133: l_dset_line_attribute11 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE11%TYPE;
134: l_dset_line_attribute12 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE12%TYPE;
135: l_dset_line_attribute13 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE13%TYPE;
136: l_dset_line_attribute14 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE14%TYPE;
137: l_dset_line_attribute15 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE15%TYPE;
130: l_dset_line_attribute8 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE8%TYPE;
131: l_dset_line_attribute9 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE9%TYPE;
132: l_dset_line_attribute10 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE10%TYPE;
133: l_dset_line_attribute11 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE11%TYPE;
134: l_dset_line_attribute12 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE12%TYPE;
135: l_dset_line_attribute13 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE13%TYPE;
136: l_dset_line_attribute14 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE14%TYPE;
137: l_dset_line_attribute15 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE15%TYPE;
138: l_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
131: l_dset_line_attribute9 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE9%TYPE;
132: l_dset_line_attribute10 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE10%TYPE;
133: l_dset_line_attribute11 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE11%TYPE;
134: l_dset_line_attribute12 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE12%TYPE;
135: l_dset_line_attribute13 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE13%TYPE;
136: l_dset_line_attribute14 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE14%TYPE;
137: l_dset_line_attribute15 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE15%TYPE;
138: l_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
139: l_dist_base_amount AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE;
132: l_dset_line_attribute10 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE10%TYPE;
133: l_dset_line_attribute11 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE11%TYPE;
134: l_dset_line_attribute12 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE12%TYPE;
135: l_dset_line_attribute13 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE13%TYPE;
136: l_dset_line_attribute14 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE14%TYPE;
137: l_dset_line_attribute15 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE15%TYPE;
138: l_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
139: l_dist_base_amount AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE;
140: l_dist_set_percent_number NUMBER;
133: l_dset_line_attribute11 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE11%TYPE;
134: l_dset_line_attribute12 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE12%TYPE;
135: l_dset_line_attribute13 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE13%TYPE;
136: l_dset_line_attribute14 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE14%TYPE;
137: l_dset_line_attribute15 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE15%TYPE;
138: l_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
139: l_dist_base_amount AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE;
140: l_dist_set_percent_number NUMBER;
141: l_running_total_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;