47: /* Bug 8713737 Added r_invoice_attribute_rec for passing attribute columns
48: to PA APIs */
49:
50: TYPE r_invoice_attribute_rec IS RECORD (
51: attribute_category ap_invoices_all.attribute_category%TYPE,
52: attribute1 ap_invoices_all.attribute1%TYPE,
53: attribute2 ap_invoices_all.attribute2%TYPE,
54: attribute3 ap_invoices_all.attribute3%TYPE,
55: attribute4 ap_invoices_all.attribute4%TYPE,
48: to PA APIs */
49:
50: TYPE r_invoice_attribute_rec IS RECORD (
51: attribute_category ap_invoices_all.attribute_category%TYPE,
52: attribute1 ap_invoices_all.attribute1%TYPE,
53: attribute2 ap_invoices_all.attribute2%TYPE,
54: attribute3 ap_invoices_all.attribute3%TYPE,
55: attribute4 ap_invoices_all.attribute4%TYPE,
56: attribute5 ap_invoices_all.attribute5%TYPE,
49:
50: TYPE r_invoice_attribute_rec IS RECORD (
51: attribute_category ap_invoices_all.attribute_category%TYPE,
52: attribute1 ap_invoices_all.attribute1%TYPE,
53: attribute2 ap_invoices_all.attribute2%TYPE,
54: attribute3 ap_invoices_all.attribute3%TYPE,
55: attribute4 ap_invoices_all.attribute4%TYPE,
56: attribute5 ap_invoices_all.attribute5%TYPE,
57: attribute6 ap_invoices_all.attribute6%TYPE,
50: TYPE r_invoice_attribute_rec IS RECORD (
51: attribute_category ap_invoices_all.attribute_category%TYPE,
52: attribute1 ap_invoices_all.attribute1%TYPE,
53: attribute2 ap_invoices_all.attribute2%TYPE,
54: attribute3 ap_invoices_all.attribute3%TYPE,
55: attribute4 ap_invoices_all.attribute4%TYPE,
56: attribute5 ap_invoices_all.attribute5%TYPE,
57: attribute6 ap_invoices_all.attribute6%TYPE,
58: attribute7 ap_invoices_all.attribute7%TYPE,
51: attribute_category ap_invoices_all.attribute_category%TYPE,
52: attribute1 ap_invoices_all.attribute1%TYPE,
53: attribute2 ap_invoices_all.attribute2%TYPE,
54: attribute3 ap_invoices_all.attribute3%TYPE,
55: attribute4 ap_invoices_all.attribute4%TYPE,
56: attribute5 ap_invoices_all.attribute5%TYPE,
57: attribute6 ap_invoices_all.attribute6%TYPE,
58: attribute7 ap_invoices_all.attribute7%TYPE,
59: attribute8 ap_invoices_all.attribute8%TYPE,
52: attribute1 ap_invoices_all.attribute1%TYPE,
53: attribute2 ap_invoices_all.attribute2%TYPE,
54: attribute3 ap_invoices_all.attribute3%TYPE,
55: attribute4 ap_invoices_all.attribute4%TYPE,
56: attribute5 ap_invoices_all.attribute5%TYPE,
57: attribute6 ap_invoices_all.attribute6%TYPE,
58: attribute7 ap_invoices_all.attribute7%TYPE,
59: attribute8 ap_invoices_all.attribute8%TYPE,
60: attribute9 ap_invoices_all.attribute9%TYPE,
53: attribute2 ap_invoices_all.attribute2%TYPE,
54: attribute3 ap_invoices_all.attribute3%TYPE,
55: attribute4 ap_invoices_all.attribute4%TYPE,
56: attribute5 ap_invoices_all.attribute5%TYPE,
57: attribute6 ap_invoices_all.attribute6%TYPE,
58: attribute7 ap_invoices_all.attribute7%TYPE,
59: attribute8 ap_invoices_all.attribute8%TYPE,
60: attribute9 ap_invoices_all.attribute9%TYPE,
61: attribute10 ap_invoices_all.attribute10%TYPE,
54: attribute3 ap_invoices_all.attribute3%TYPE,
55: attribute4 ap_invoices_all.attribute4%TYPE,
56: attribute5 ap_invoices_all.attribute5%TYPE,
57: attribute6 ap_invoices_all.attribute6%TYPE,
58: attribute7 ap_invoices_all.attribute7%TYPE,
59: attribute8 ap_invoices_all.attribute8%TYPE,
60: attribute9 ap_invoices_all.attribute9%TYPE,
61: attribute10 ap_invoices_all.attribute10%TYPE,
62: attribute11 ap_invoices_all.attribute11%TYPE,
55: attribute4 ap_invoices_all.attribute4%TYPE,
56: attribute5 ap_invoices_all.attribute5%TYPE,
57: attribute6 ap_invoices_all.attribute6%TYPE,
58: attribute7 ap_invoices_all.attribute7%TYPE,
59: attribute8 ap_invoices_all.attribute8%TYPE,
60: attribute9 ap_invoices_all.attribute9%TYPE,
61: attribute10 ap_invoices_all.attribute10%TYPE,
62: attribute11 ap_invoices_all.attribute11%TYPE,
63: attribute12 ap_invoices_all.attribute12%TYPE,
56: attribute5 ap_invoices_all.attribute5%TYPE,
57: attribute6 ap_invoices_all.attribute6%TYPE,
58: attribute7 ap_invoices_all.attribute7%TYPE,
59: attribute8 ap_invoices_all.attribute8%TYPE,
60: attribute9 ap_invoices_all.attribute9%TYPE,
61: attribute10 ap_invoices_all.attribute10%TYPE,
62: attribute11 ap_invoices_all.attribute11%TYPE,
63: attribute12 ap_invoices_all.attribute12%TYPE,
64: attribute13 ap_invoices_all.attribute13%TYPE,
57: attribute6 ap_invoices_all.attribute6%TYPE,
58: attribute7 ap_invoices_all.attribute7%TYPE,
59: attribute8 ap_invoices_all.attribute8%TYPE,
60: attribute9 ap_invoices_all.attribute9%TYPE,
61: attribute10 ap_invoices_all.attribute10%TYPE,
62: attribute11 ap_invoices_all.attribute11%TYPE,
63: attribute12 ap_invoices_all.attribute12%TYPE,
64: attribute13 ap_invoices_all.attribute13%TYPE,
65: attribute14 ap_invoices_all.attribute14%TYPE,
58: attribute7 ap_invoices_all.attribute7%TYPE,
59: attribute8 ap_invoices_all.attribute8%TYPE,
60: attribute9 ap_invoices_all.attribute9%TYPE,
61: attribute10 ap_invoices_all.attribute10%TYPE,
62: attribute11 ap_invoices_all.attribute11%TYPE,
63: attribute12 ap_invoices_all.attribute12%TYPE,
64: attribute13 ap_invoices_all.attribute13%TYPE,
65: attribute14 ap_invoices_all.attribute14%TYPE,
66: attribute15 ap_invoices_all.attribute15%TYPE,
59: attribute8 ap_invoices_all.attribute8%TYPE,
60: attribute9 ap_invoices_all.attribute9%TYPE,
61: attribute10 ap_invoices_all.attribute10%TYPE,
62: attribute11 ap_invoices_all.attribute11%TYPE,
63: attribute12 ap_invoices_all.attribute12%TYPE,
64: attribute13 ap_invoices_all.attribute13%TYPE,
65: attribute14 ap_invoices_all.attribute14%TYPE,
66: attribute15 ap_invoices_all.attribute15%TYPE,
67: line_attribute_category ap_invoice_lines_all.attribute_category%TYPE,
60: attribute9 ap_invoices_all.attribute9%TYPE,
61: attribute10 ap_invoices_all.attribute10%TYPE,
62: attribute11 ap_invoices_all.attribute11%TYPE,
63: attribute12 ap_invoices_all.attribute12%TYPE,
64: attribute13 ap_invoices_all.attribute13%TYPE,
65: attribute14 ap_invoices_all.attribute14%TYPE,
66: attribute15 ap_invoices_all.attribute15%TYPE,
67: line_attribute_category ap_invoice_lines_all.attribute_category%TYPE,
68: line_attribute1 ap_invoice_lines_all.attribute1%TYPE,
61: attribute10 ap_invoices_all.attribute10%TYPE,
62: attribute11 ap_invoices_all.attribute11%TYPE,
63: attribute12 ap_invoices_all.attribute12%TYPE,
64: attribute13 ap_invoices_all.attribute13%TYPE,
65: attribute14 ap_invoices_all.attribute14%TYPE,
66: attribute15 ap_invoices_all.attribute15%TYPE,
67: line_attribute_category ap_invoice_lines_all.attribute_category%TYPE,
68: line_attribute1 ap_invoice_lines_all.attribute1%TYPE,
69: line_attribute2 ap_invoice_lines_all.attribute2%TYPE,
62: attribute11 ap_invoices_all.attribute11%TYPE,
63: attribute12 ap_invoices_all.attribute12%TYPE,
64: attribute13 ap_invoices_all.attribute13%TYPE,
65: attribute14 ap_invoices_all.attribute14%TYPE,
66: attribute15 ap_invoices_all.attribute15%TYPE,
67: line_attribute_category ap_invoice_lines_all.attribute_category%TYPE,
68: line_attribute1 ap_invoice_lines_all.attribute1%TYPE,
69: line_attribute2 ap_invoice_lines_all.attribute2%TYPE,
70: line_attribute3 ap_invoice_lines_all.attribute3%TYPE,
438:
439: --Start 8691645
440:
441: FUNCTION get_ccr_reg_status(p_vendor_site_id IN
442: AP_INVOICES.VENDOR_SITE_ID%TYPE)
443: return VARCHAR2;
444:
445: --End 8691645
446: