DBA Data[Home] [Help]

APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_DISTRIBUTION_SETS

Line 2389: l_dist_set_description AP_DISTRIBUTION_SETS.DESCRIPTION%TYPE;

2385: l_inv_line_asset_category_id NUMBER;
2386: l_base_line_amount NUMBER;
2387: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
2388: l_dist_set_percent_number NUMBER := 0;
2389: l_dist_set_description AP_DISTRIBUTION_SETS.DESCRIPTION%TYPE;
2390: l_dist_set_attribute_category AP_DISTRIBUTION_SETS.ATTRIBUTE_CATEGORY%TYPE;
2391: l_dist_set_attribute1 AP_DISTRIBUTION_SETS.ATTRIBUTE1%TYPE;
2392: l_dist_set_attribute2 AP_DISTRIBUTION_SETS.ATTRIBUTE2%TYPE;
2393: l_dist_set_attribute3 AP_DISTRIBUTION_SETS.ATTRIBUTE3%TYPE;

Line 2390: l_dist_set_attribute_category AP_DISTRIBUTION_SETS.ATTRIBUTE_CATEGORY%TYPE;

2386: l_base_line_amount NUMBER;
2387: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
2388: l_dist_set_percent_number NUMBER := 0;
2389: l_dist_set_description AP_DISTRIBUTION_SETS.DESCRIPTION%TYPE;
2390: l_dist_set_attribute_category AP_DISTRIBUTION_SETS.ATTRIBUTE_CATEGORY%TYPE;
2391: l_dist_set_attribute1 AP_DISTRIBUTION_SETS.ATTRIBUTE1%TYPE;
2392: l_dist_set_attribute2 AP_DISTRIBUTION_SETS.ATTRIBUTE2%TYPE;
2393: l_dist_set_attribute3 AP_DISTRIBUTION_SETS.ATTRIBUTE3%TYPE;
2394: l_dist_set_attribute4 AP_DISTRIBUTION_SETS.ATTRIBUTE4%TYPE;

Line 2391: l_dist_set_attribute1 AP_DISTRIBUTION_SETS.ATTRIBUTE1%TYPE;

2387: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
2388: l_dist_set_percent_number NUMBER := 0;
2389: l_dist_set_description AP_DISTRIBUTION_SETS.DESCRIPTION%TYPE;
2390: l_dist_set_attribute_category AP_DISTRIBUTION_SETS.ATTRIBUTE_CATEGORY%TYPE;
2391: l_dist_set_attribute1 AP_DISTRIBUTION_SETS.ATTRIBUTE1%TYPE;
2392: l_dist_set_attribute2 AP_DISTRIBUTION_SETS.ATTRIBUTE2%TYPE;
2393: l_dist_set_attribute3 AP_DISTRIBUTION_SETS.ATTRIBUTE3%TYPE;
2394: l_dist_set_attribute4 AP_DISTRIBUTION_SETS.ATTRIBUTE4%TYPE;
2395: l_dist_set_attribute5 AP_DISTRIBUTION_SETS.ATTRIBUTE5%TYPE;

Line 2392: l_dist_set_attribute2 AP_DISTRIBUTION_SETS.ATTRIBUTE2%TYPE;

2388: l_dist_set_percent_number NUMBER := 0;
2389: l_dist_set_description AP_DISTRIBUTION_SETS.DESCRIPTION%TYPE;
2390: l_dist_set_attribute_category AP_DISTRIBUTION_SETS.ATTRIBUTE_CATEGORY%TYPE;
2391: l_dist_set_attribute1 AP_DISTRIBUTION_SETS.ATTRIBUTE1%TYPE;
2392: l_dist_set_attribute2 AP_DISTRIBUTION_SETS.ATTRIBUTE2%TYPE;
2393: l_dist_set_attribute3 AP_DISTRIBUTION_SETS.ATTRIBUTE3%TYPE;
2394: l_dist_set_attribute4 AP_DISTRIBUTION_SETS.ATTRIBUTE4%TYPE;
2395: l_dist_set_attribute5 AP_DISTRIBUTION_SETS.ATTRIBUTE5%TYPE;
2396: l_dist_set_attribute6 AP_DISTRIBUTION_SETS.ATTRIBUTE6%TYPE;

Line 2393: l_dist_set_attribute3 AP_DISTRIBUTION_SETS.ATTRIBUTE3%TYPE;

2389: l_dist_set_description AP_DISTRIBUTION_SETS.DESCRIPTION%TYPE;
2390: l_dist_set_attribute_category AP_DISTRIBUTION_SETS.ATTRIBUTE_CATEGORY%TYPE;
2391: l_dist_set_attribute1 AP_DISTRIBUTION_SETS.ATTRIBUTE1%TYPE;
2392: l_dist_set_attribute2 AP_DISTRIBUTION_SETS.ATTRIBUTE2%TYPE;
2393: l_dist_set_attribute3 AP_DISTRIBUTION_SETS.ATTRIBUTE3%TYPE;
2394: l_dist_set_attribute4 AP_DISTRIBUTION_SETS.ATTRIBUTE4%TYPE;
2395: l_dist_set_attribute5 AP_DISTRIBUTION_SETS.ATTRIBUTE5%TYPE;
2396: l_dist_set_attribute6 AP_DISTRIBUTION_SETS.ATTRIBUTE6%TYPE;
2397: l_dist_set_attribute7 AP_DISTRIBUTION_SETS.ATTRIBUTE7%TYPE;

Line 2394: l_dist_set_attribute4 AP_DISTRIBUTION_SETS.ATTRIBUTE4%TYPE;

2390: l_dist_set_attribute_category AP_DISTRIBUTION_SETS.ATTRIBUTE_CATEGORY%TYPE;
2391: l_dist_set_attribute1 AP_DISTRIBUTION_SETS.ATTRIBUTE1%TYPE;
2392: l_dist_set_attribute2 AP_DISTRIBUTION_SETS.ATTRIBUTE2%TYPE;
2393: l_dist_set_attribute3 AP_DISTRIBUTION_SETS.ATTRIBUTE3%TYPE;
2394: l_dist_set_attribute4 AP_DISTRIBUTION_SETS.ATTRIBUTE4%TYPE;
2395: l_dist_set_attribute5 AP_DISTRIBUTION_SETS.ATTRIBUTE5%TYPE;
2396: l_dist_set_attribute6 AP_DISTRIBUTION_SETS.ATTRIBUTE6%TYPE;
2397: l_dist_set_attribute7 AP_DISTRIBUTION_SETS.ATTRIBUTE7%TYPE;
2398: l_dist_set_attribute8 AP_DISTRIBUTION_SETS.ATTRIBUTE8%TYPE;

Line 2395: l_dist_set_attribute5 AP_DISTRIBUTION_SETS.ATTRIBUTE5%TYPE;

2391: l_dist_set_attribute1 AP_DISTRIBUTION_SETS.ATTRIBUTE1%TYPE;
2392: l_dist_set_attribute2 AP_DISTRIBUTION_SETS.ATTRIBUTE2%TYPE;
2393: l_dist_set_attribute3 AP_DISTRIBUTION_SETS.ATTRIBUTE3%TYPE;
2394: l_dist_set_attribute4 AP_DISTRIBUTION_SETS.ATTRIBUTE4%TYPE;
2395: l_dist_set_attribute5 AP_DISTRIBUTION_SETS.ATTRIBUTE5%TYPE;
2396: l_dist_set_attribute6 AP_DISTRIBUTION_SETS.ATTRIBUTE6%TYPE;
2397: l_dist_set_attribute7 AP_DISTRIBUTION_SETS.ATTRIBUTE7%TYPE;
2398: l_dist_set_attribute8 AP_DISTRIBUTION_SETS.ATTRIBUTE8%TYPE;
2399: l_dist_set_attribute9 AP_DISTRIBUTION_SETS.ATTRIBUTE9%TYPE;

Line 2396: l_dist_set_attribute6 AP_DISTRIBUTION_SETS.ATTRIBUTE6%TYPE;

2392: l_dist_set_attribute2 AP_DISTRIBUTION_SETS.ATTRIBUTE2%TYPE;
2393: l_dist_set_attribute3 AP_DISTRIBUTION_SETS.ATTRIBUTE3%TYPE;
2394: l_dist_set_attribute4 AP_DISTRIBUTION_SETS.ATTRIBUTE4%TYPE;
2395: l_dist_set_attribute5 AP_DISTRIBUTION_SETS.ATTRIBUTE5%TYPE;
2396: l_dist_set_attribute6 AP_DISTRIBUTION_SETS.ATTRIBUTE6%TYPE;
2397: l_dist_set_attribute7 AP_DISTRIBUTION_SETS.ATTRIBUTE7%TYPE;
2398: l_dist_set_attribute8 AP_DISTRIBUTION_SETS.ATTRIBUTE8%TYPE;
2399: l_dist_set_attribute9 AP_DISTRIBUTION_SETS.ATTRIBUTE9%TYPE;
2400: l_dist_set_attribute10 AP_DISTRIBUTION_SETS.ATTRIBUTE10%TYPE;

Line 2397: l_dist_set_attribute7 AP_DISTRIBUTION_SETS.ATTRIBUTE7%TYPE;

2393: l_dist_set_attribute3 AP_DISTRIBUTION_SETS.ATTRIBUTE3%TYPE;
2394: l_dist_set_attribute4 AP_DISTRIBUTION_SETS.ATTRIBUTE4%TYPE;
2395: l_dist_set_attribute5 AP_DISTRIBUTION_SETS.ATTRIBUTE5%TYPE;
2396: l_dist_set_attribute6 AP_DISTRIBUTION_SETS.ATTRIBUTE6%TYPE;
2397: l_dist_set_attribute7 AP_DISTRIBUTION_SETS.ATTRIBUTE7%TYPE;
2398: l_dist_set_attribute8 AP_DISTRIBUTION_SETS.ATTRIBUTE8%TYPE;
2399: l_dist_set_attribute9 AP_DISTRIBUTION_SETS.ATTRIBUTE9%TYPE;
2400: l_dist_set_attribute10 AP_DISTRIBUTION_SETS.ATTRIBUTE10%TYPE;
2401: l_dist_set_attribute11 AP_DISTRIBUTION_SETS.ATTRIBUTE11%TYPE;

Line 2398: l_dist_set_attribute8 AP_DISTRIBUTION_SETS.ATTRIBUTE8%TYPE;

2394: l_dist_set_attribute4 AP_DISTRIBUTION_SETS.ATTRIBUTE4%TYPE;
2395: l_dist_set_attribute5 AP_DISTRIBUTION_SETS.ATTRIBUTE5%TYPE;
2396: l_dist_set_attribute6 AP_DISTRIBUTION_SETS.ATTRIBUTE6%TYPE;
2397: l_dist_set_attribute7 AP_DISTRIBUTION_SETS.ATTRIBUTE7%TYPE;
2398: l_dist_set_attribute8 AP_DISTRIBUTION_SETS.ATTRIBUTE8%TYPE;
2399: l_dist_set_attribute9 AP_DISTRIBUTION_SETS.ATTRIBUTE9%TYPE;
2400: l_dist_set_attribute10 AP_DISTRIBUTION_SETS.ATTRIBUTE10%TYPE;
2401: l_dist_set_attribute11 AP_DISTRIBUTION_SETS.ATTRIBUTE11%TYPE;
2402: l_dist_set_attribute12 AP_DISTRIBUTION_SETS.ATTRIBUTE12%TYPE;

Line 2399: l_dist_set_attribute9 AP_DISTRIBUTION_SETS.ATTRIBUTE9%TYPE;

2395: l_dist_set_attribute5 AP_DISTRIBUTION_SETS.ATTRIBUTE5%TYPE;
2396: l_dist_set_attribute6 AP_DISTRIBUTION_SETS.ATTRIBUTE6%TYPE;
2397: l_dist_set_attribute7 AP_DISTRIBUTION_SETS.ATTRIBUTE7%TYPE;
2398: l_dist_set_attribute8 AP_DISTRIBUTION_SETS.ATTRIBUTE8%TYPE;
2399: l_dist_set_attribute9 AP_DISTRIBUTION_SETS.ATTRIBUTE9%TYPE;
2400: l_dist_set_attribute10 AP_DISTRIBUTION_SETS.ATTRIBUTE10%TYPE;
2401: l_dist_set_attribute11 AP_DISTRIBUTION_SETS.ATTRIBUTE11%TYPE;
2402: l_dist_set_attribute12 AP_DISTRIBUTION_SETS.ATTRIBUTE12%TYPE;
2403: l_dist_set_attribute13 AP_DISTRIBUTION_SETS.ATTRIBUTE13%TYPE;

Line 2400: l_dist_set_attribute10 AP_DISTRIBUTION_SETS.ATTRIBUTE10%TYPE;

2396: l_dist_set_attribute6 AP_DISTRIBUTION_SETS.ATTRIBUTE6%TYPE;
2397: l_dist_set_attribute7 AP_DISTRIBUTION_SETS.ATTRIBUTE7%TYPE;
2398: l_dist_set_attribute8 AP_DISTRIBUTION_SETS.ATTRIBUTE8%TYPE;
2399: l_dist_set_attribute9 AP_DISTRIBUTION_SETS.ATTRIBUTE9%TYPE;
2400: l_dist_set_attribute10 AP_DISTRIBUTION_SETS.ATTRIBUTE10%TYPE;
2401: l_dist_set_attribute11 AP_DISTRIBUTION_SETS.ATTRIBUTE11%TYPE;
2402: l_dist_set_attribute12 AP_DISTRIBUTION_SETS.ATTRIBUTE12%TYPE;
2403: l_dist_set_attribute13 AP_DISTRIBUTION_SETS.ATTRIBUTE13%TYPE;
2404: l_dist_set_attribute14 AP_DISTRIBUTION_SETS.ATTRIBUTE14%TYPE;

Line 2401: l_dist_set_attribute11 AP_DISTRIBUTION_SETS.ATTRIBUTE11%TYPE;

2397: l_dist_set_attribute7 AP_DISTRIBUTION_SETS.ATTRIBUTE7%TYPE;
2398: l_dist_set_attribute8 AP_DISTRIBUTION_SETS.ATTRIBUTE8%TYPE;
2399: l_dist_set_attribute9 AP_DISTRIBUTION_SETS.ATTRIBUTE9%TYPE;
2400: l_dist_set_attribute10 AP_DISTRIBUTION_SETS.ATTRIBUTE10%TYPE;
2401: l_dist_set_attribute11 AP_DISTRIBUTION_SETS.ATTRIBUTE11%TYPE;
2402: l_dist_set_attribute12 AP_DISTRIBUTION_SETS.ATTRIBUTE12%TYPE;
2403: l_dist_set_attribute13 AP_DISTRIBUTION_SETS.ATTRIBUTE13%TYPE;
2404: l_dist_set_attribute14 AP_DISTRIBUTION_SETS.ATTRIBUTE14%TYPE;
2405: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;

Line 2402: l_dist_set_attribute12 AP_DISTRIBUTION_SETS.ATTRIBUTE12%TYPE;

2398: l_dist_set_attribute8 AP_DISTRIBUTION_SETS.ATTRIBUTE8%TYPE;
2399: l_dist_set_attribute9 AP_DISTRIBUTION_SETS.ATTRIBUTE9%TYPE;
2400: l_dist_set_attribute10 AP_DISTRIBUTION_SETS.ATTRIBUTE10%TYPE;
2401: l_dist_set_attribute11 AP_DISTRIBUTION_SETS.ATTRIBUTE11%TYPE;
2402: l_dist_set_attribute12 AP_DISTRIBUTION_SETS.ATTRIBUTE12%TYPE;
2403: l_dist_set_attribute13 AP_DISTRIBUTION_SETS.ATTRIBUTE13%TYPE;
2404: l_dist_set_attribute14 AP_DISTRIBUTION_SETS.ATTRIBUTE14%TYPE;
2405: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;
2406: l_inactive_date DATE;

Line 2403: l_dist_set_attribute13 AP_DISTRIBUTION_SETS.ATTRIBUTE13%TYPE;

2399: l_dist_set_attribute9 AP_DISTRIBUTION_SETS.ATTRIBUTE9%TYPE;
2400: l_dist_set_attribute10 AP_DISTRIBUTION_SETS.ATTRIBUTE10%TYPE;
2401: l_dist_set_attribute11 AP_DISTRIBUTION_SETS.ATTRIBUTE11%TYPE;
2402: l_dist_set_attribute12 AP_DISTRIBUTION_SETS.ATTRIBUTE12%TYPE;
2403: l_dist_set_attribute13 AP_DISTRIBUTION_SETS.ATTRIBUTE13%TYPE;
2404: l_dist_set_attribute14 AP_DISTRIBUTION_SETS.ATTRIBUTE14%TYPE;
2405: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;
2406: l_inactive_date DATE;
2407:

Line 2404: l_dist_set_attribute14 AP_DISTRIBUTION_SETS.ATTRIBUTE14%TYPE;

2400: l_dist_set_attribute10 AP_DISTRIBUTION_SETS.ATTRIBUTE10%TYPE;
2401: l_dist_set_attribute11 AP_DISTRIBUTION_SETS.ATTRIBUTE11%TYPE;
2402: l_dist_set_attribute12 AP_DISTRIBUTION_SETS.ATTRIBUTE12%TYPE;
2403: l_dist_set_attribute13 AP_DISTRIBUTION_SETS.ATTRIBUTE13%TYPE;
2404: l_dist_set_attribute14 AP_DISTRIBUTION_SETS.ATTRIBUTE14%TYPE;
2405: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;
2406: l_inactive_date DATE;
2407:
2408: debug_info VARCHAR2(1000);

Line 2405: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;

2401: l_dist_set_attribute11 AP_DISTRIBUTION_SETS.ATTRIBUTE11%TYPE;
2402: l_dist_set_attribute12 AP_DISTRIBUTION_SETS.ATTRIBUTE12%TYPE;
2403: l_dist_set_attribute13 AP_DISTRIBUTION_SETS.ATTRIBUTE13%TYPE;
2404: l_dist_set_attribute14 AP_DISTRIBUTION_SETS.ATTRIBUTE14%TYPE;
2405: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;
2406: l_inactive_date DATE;
2407:
2408: debug_info VARCHAR2(1000);
2409: current_calling_sequence VARCHAR2(2000);

Line 2460: FROM ap_distribution_sets

2456: l_dist_set_attribute13,
2457: l_dist_set_attribute14,
2458: l_dist_set_attribute15,
2459: l_inactive_date
2460: FROM ap_distribution_sets
2461: WHERE distribution_set_id = p_distribution_set_id;
2462:
2463: IF (nvl(l_inactive_date, trunc(sysdate) + 1) <= trunc(sysdate)) THEN
2464: FND_MESSAGE.SET_NAME('SQLAP','AP_VEN_DIST_SET_INVALID');