2: /* $Header: apwdflxs.pls 120.18.12010000.3 2009/01/23 07:18:47 stalasil ship $ */
3:
4: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
5: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
6: SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;
7:
8: -- Constants
9: C_CustValidResMsgTypeNone CONSTANT VARCHAR(20) := NULL;
10: C_CustValidResMsgTypeError CONSTANT VARCHAR(20) := 'ERROR';
38: amt_due_employee NUMBER,
39: amt_due_ccCompany NUMBER, -- project accounting
40: default_currency_code VARCHAR2(15),
41: default_exchange_rate_type VARCHAR2(30),
42: attribute_category ap_expense_report_headers_all.attribute_category%type,
43: attribute1 ap_expense_report_headers_all.attribute1%type,
44: attribute2 ap_expense_report_headers_all.attribute2%type,
45: attribute3 ap_expense_report_headers_all.attribute3%type,
46: attribute4 ap_expense_report_headers_all.attribute4%type,
39: amt_due_ccCompany NUMBER, -- project accounting
40: default_currency_code VARCHAR2(15),
41: default_exchange_rate_type VARCHAR2(30),
42: attribute_category ap_expense_report_headers_all.attribute_category%type,
43: attribute1 ap_expense_report_headers_all.attribute1%type,
44: attribute2 ap_expense_report_headers_all.attribute2%type,
45: attribute3 ap_expense_report_headers_all.attribute3%type,
46: attribute4 ap_expense_report_headers_all.attribute4%type,
47: attribute5 ap_expense_report_headers_all.attribute5%type,
40: default_currency_code VARCHAR2(15),
41: default_exchange_rate_type VARCHAR2(30),
42: attribute_category ap_expense_report_headers_all.attribute_category%type,
43: attribute1 ap_expense_report_headers_all.attribute1%type,
44: attribute2 ap_expense_report_headers_all.attribute2%type,
45: attribute3 ap_expense_report_headers_all.attribute3%type,
46: attribute4 ap_expense_report_headers_all.attribute4%type,
47: attribute5 ap_expense_report_headers_all.attribute5%type,
48: attribute6 ap_expense_report_headers_all.attribute6%type,
41: default_exchange_rate_type VARCHAR2(30),
42: attribute_category ap_expense_report_headers_all.attribute_category%type,
43: attribute1 ap_expense_report_headers_all.attribute1%type,
44: attribute2 ap_expense_report_headers_all.attribute2%type,
45: attribute3 ap_expense_report_headers_all.attribute3%type,
46: attribute4 ap_expense_report_headers_all.attribute4%type,
47: attribute5 ap_expense_report_headers_all.attribute5%type,
48: attribute6 ap_expense_report_headers_all.attribute6%type,
49: attribute7 ap_expense_report_headers_all.attribute7%type,
42: attribute_category ap_expense_report_headers_all.attribute_category%type,
43: attribute1 ap_expense_report_headers_all.attribute1%type,
44: attribute2 ap_expense_report_headers_all.attribute2%type,
45: attribute3 ap_expense_report_headers_all.attribute3%type,
46: attribute4 ap_expense_report_headers_all.attribute4%type,
47: attribute5 ap_expense_report_headers_all.attribute5%type,
48: attribute6 ap_expense_report_headers_all.attribute6%type,
49: attribute7 ap_expense_report_headers_all.attribute7%type,
50: attribute8 ap_expense_report_headers_all.attribute8%type,
43: attribute1 ap_expense_report_headers_all.attribute1%type,
44: attribute2 ap_expense_report_headers_all.attribute2%type,
45: attribute3 ap_expense_report_headers_all.attribute3%type,
46: attribute4 ap_expense_report_headers_all.attribute4%type,
47: attribute5 ap_expense_report_headers_all.attribute5%type,
48: attribute6 ap_expense_report_headers_all.attribute6%type,
49: attribute7 ap_expense_report_headers_all.attribute7%type,
50: attribute8 ap_expense_report_headers_all.attribute8%type,
51: attribute9 ap_expense_report_headers_all.attribute9%type,
44: attribute2 ap_expense_report_headers_all.attribute2%type,
45: attribute3 ap_expense_report_headers_all.attribute3%type,
46: attribute4 ap_expense_report_headers_all.attribute4%type,
47: attribute5 ap_expense_report_headers_all.attribute5%type,
48: attribute6 ap_expense_report_headers_all.attribute6%type,
49: attribute7 ap_expense_report_headers_all.attribute7%type,
50: attribute8 ap_expense_report_headers_all.attribute8%type,
51: attribute9 ap_expense_report_headers_all.attribute9%type,
52: attribute10 ap_expense_report_headers_all.attribute10%type,
45: attribute3 ap_expense_report_headers_all.attribute3%type,
46: attribute4 ap_expense_report_headers_all.attribute4%type,
47: attribute5 ap_expense_report_headers_all.attribute5%type,
48: attribute6 ap_expense_report_headers_all.attribute6%type,
49: attribute7 ap_expense_report_headers_all.attribute7%type,
50: attribute8 ap_expense_report_headers_all.attribute8%type,
51: attribute9 ap_expense_report_headers_all.attribute9%type,
52: attribute10 ap_expense_report_headers_all.attribute10%type,
53: attribute11 ap_expense_report_headers_all.attribute11%type,
46: attribute4 ap_expense_report_headers_all.attribute4%type,
47: attribute5 ap_expense_report_headers_all.attribute5%type,
48: attribute6 ap_expense_report_headers_all.attribute6%type,
49: attribute7 ap_expense_report_headers_all.attribute7%type,
50: attribute8 ap_expense_report_headers_all.attribute8%type,
51: attribute9 ap_expense_report_headers_all.attribute9%type,
52: attribute10 ap_expense_report_headers_all.attribute10%type,
53: attribute11 ap_expense_report_headers_all.attribute11%type,
54: attribute12 ap_expense_report_headers_all.attribute12%type,
47: attribute5 ap_expense_report_headers_all.attribute5%type,
48: attribute6 ap_expense_report_headers_all.attribute6%type,
49: attribute7 ap_expense_report_headers_all.attribute7%type,
50: attribute8 ap_expense_report_headers_all.attribute8%type,
51: attribute9 ap_expense_report_headers_all.attribute9%type,
52: attribute10 ap_expense_report_headers_all.attribute10%type,
53: attribute11 ap_expense_report_headers_all.attribute11%type,
54: attribute12 ap_expense_report_headers_all.attribute12%type,
55: attribute13 ap_expense_report_headers_all.attribute13%type,
48: attribute6 ap_expense_report_headers_all.attribute6%type,
49: attribute7 ap_expense_report_headers_all.attribute7%type,
50: attribute8 ap_expense_report_headers_all.attribute8%type,
51: attribute9 ap_expense_report_headers_all.attribute9%type,
52: attribute10 ap_expense_report_headers_all.attribute10%type,
53: attribute11 ap_expense_report_headers_all.attribute11%type,
54: attribute12 ap_expense_report_headers_all.attribute12%type,
55: attribute13 ap_expense_report_headers_all.attribute13%type,
56: attribute14 ap_expense_report_headers_all.attribute14%type,
49: attribute7 ap_expense_report_headers_all.attribute7%type,
50: attribute8 ap_expense_report_headers_all.attribute8%type,
51: attribute9 ap_expense_report_headers_all.attribute9%type,
52: attribute10 ap_expense_report_headers_all.attribute10%type,
53: attribute11 ap_expense_report_headers_all.attribute11%type,
54: attribute12 ap_expense_report_headers_all.attribute12%type,
55: attribute13 ap_expense_report_headers_all.attribute13%type,
56: attribute14 ap_expense_report_headers_all.attribute14%type,
57: attribute15 ap_expense_report_headers_all.attribute15%type
50: attribute8 ap_expense_report_headers_all.attribute8%type,
51: attribute9 ap_expense_report_headers_all.attribute9%type,
52: attribute10 ap_expense_report_headers_all.attribute10%type,
53: attribute11 ap_expense_report_headers_all.attribute11%type,
54: attribute12 ap_expense_report_headers_all.attribute12%type,
55: attribute13 ap_expense_report_headers_all.attribute13%type,
56: attribute14 ap_expense_report_headers_all.attribute14%type,
57: attribute15 ap_expense_report_headers_all.attribute15%type
58: );
51: attribute9 ap_expense_report_headers_all.attribute9%type,
52: attribute10 ap_expense_report_headers_all.attribute10%type,
53: attribute11 ap_expense_report_headers_all.attribute11%type,
54: attribute12 ap_expense_report_headers_all.attribute12%type,
55: attribute13 ap_expense_report_headers_all.attribute13%type,
56: attribute14 ap_expense_report_headers_all.attribute14%type,
57: attribute15 ap_expense_report_headers_all.attribute15%type
58: );
59:
52: attribute10 ap_expense_report_headers_all.attribute10%type,
53: attribute11 ap_expense_report_headers_all.attribute11%type,
54: attribute12 ap_expense_report_headers_all.attribute12%type,
55: attribute13 ap_expense_report_headers_all.attribute13%type,
56: attribute14 ap_expense_report_headers_all.attribute14%type,
57: attribute15 ap_expense_report_headers_all.attribute15%type
58: );
59:
60: TYPE ExpReportLineRec IS RECORD (
53: attribute11 ap_expense_report_headers_all.attribute11%type,
54: attribute12 ap_expense_report_headers_all.attribute12%type,
55: attribute13 ap_expense_report_headers_all.attribute13%type,
56: attribute14 ap_expense_report_headers_all.attribute14%type,
57: attribute15 ap_expense_report_headers_all.attribute15%type
58: );
59:
60: TYPE ExpReportLineRec IS RECORD (
61: receipt_index NUMBER, -- index of receipt starting from 1