eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 564: from AP_EXPENSE_REPORT_LINES_ALL

560: p_audit_report OUT NOCOPY BOOLEAN) IS
561:
562: CURSOR receipt_cur IS
563: select min(start_expense_date) oldest_receipt_date
564: from AP_EXPENSE_REPORT_LINES_ALL
565: where report_header_id = p_report_header_id;
566:
567: receipt_rec receipt_cur%ROWTYPE;
568:

Line 614: from AP_EXPENSE_REPORT_LINES_ALL

610: p_audit_report OUT NOCOPY BOOLEAN) IS
611:
612: CURSOR receipt_cur IS
613: select count(1) required_count
614: from AP_EXPENSE_REPORT_LINES_ALL
615: where report_header_id = p_report_header_id
616: and (NVL(receipt_required_flag,'N') = 'Y'
617: OR NVL(image_receipt_required_flag,'N') = 'Y');
618:

Line 663: from AP_EXPENSE_REPORT_LINES_ALL aerl

659: p_audit_report OUT NOCOPY BOOLEAN) IS
660:
661: CURSOR line_cur IS
662: select count(aerl.report_header_id) required_count
663: from AP_EXPENSE_REPORT_LINES_ALL aerl
664: where aerl.report_header_id = p_report_header_id
665: and (( NVL(aerl.justification_required_flag,'N') = 'Y'
666: OR (
667: NVL(aerl.justification_required_flag,'N') = 'V'

Line 927: from ap_expense_report_lines_all aerl

923: p_audit_report OUT NOCOPY BOOLEAN) IS
924:
925: CURSOR debit_cur IS
926: select count(1) debit_line_count
927: from ap_expense_report_lines_all aerl
928: where aerl.report_header_id = p_report_header_id
929: and amount > 0;
930:
931: debit_rec debit_cur%ROWTYPE;

Line 1105: from ap_expense_report_lines_all aerl

1101: p_audit_report OUT NOCOPY BOOLEAN) IS
1102:
1103: CURSOR cc_cur IS
1104: select count(1) non_cc_line_count
1105: from ap_expense_report_lines_all aerl
1106: where aerl.report_header_id = p_report_header_id
1107: and ( CREDIT_CARD_TRX_ID is null
1108: OR ( CREDIT_CARD_TRX_ID is not null
1109: AND (NVL(receipt_required_flag,'N') = 'Y' OR NVL(image_receipt_required_flag,'N') = 'Y')

Line 1115: from ap_expense_report_lines_all aerl

1111: );
1112:
1113: CURSOR pdm_cur IS
1114: select count(1) non_pdm_line_count
1115: from ap_expense_report_lines_all aerl
1116: where aerl.report_header_id = p_report_header_id
1117: and NVL(aerl.category_code,'NONE') not in ('PER_DIEM','MILEAGE');
1118:
1119: CURSOR rr_cur IS

Line 1121: from ap_expense_report_lines_all aerl

1117: and NVL(aerl.category_code,'NONE') not in ('PER_DIEM','MILEAGE');
1118:
1119: CURSOR rr_cur IS
1120: select count(1) rr_line_count
1121: from ap_expense_report_lines_all aerl
1122: where aerl.report_header_id = p_report_header_id
1123: and (nvl(aerl.receipt_required_flag, 'N') = 'Y' OR nvl(aerl.image_receipt_required_flag, 'N') = 'Y');
1124:
1125: pdm_rec pdm_cur%ROWTYPE;

Line 1270: from AP_EXPENSE_REPORT_LINES_ALL aerl

1266: and aerh.report_submitted_date > add_months(sysdate,-1)
1267: and ( aerh.source in ('WebExpense', 'SelfService')
1268: or aerh.report_header_id = p_report_header_id)
1269: and exists(select 'Y'
1270: from AP_EXPENSE_REPORT_LINES_ALL aerl
1271: where aerh.report_header_id = aerl.report_header_id);
1272:
1273:
1274: list_rec list_cur%ROWTYPE;

Line 1774: FROM AP_EXPENSE_REPORT_LINES_ALL AERL

1770: PROCEDURE process_audit_actions(p_report_header_id IN NUMBER) IS
1771:
1772: CURSOR report_lines_c IS
1773: SELECT AERL.*
1774: FROM AP_EXPENSE_REPORT_LINES_ALL AERL
1775: WHERE REPORT_HEADER_ID = p_report_header_id
1776: AND (itemization_parent_id is null OR itemization_parent_id <> -1)
1777: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
1778:

Line 1839: PROCEDURE update_cc_transaction(expense_line_rec IN AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE) IS

1835: | Date Author Description of Changes
1836: | 21-Jul-2003 J Rautiainen Created
1837: |
1838: *=======================================================================*/
1839: PROCEDURE update_cc_transaction(expense_line_rec IN AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE) IS
1840:
1841: CURSOR trx_c(p_trx_id IN NUMBER) IS
1842: SELECT cct.*
1843: FROM AP_CREDIT_CARD_TRXNS_ALL cct

Line 1849: FROM AP_EXPENSE_REPORT_LINES_ALL

1845: FOR UPDATE OF TRX_ID NOWAIT;
1846:
1847: CURSOR total_c(p_report_header_id IN NUMBER, p_trx_id IN NUMBER, p_personal_expense_id IN NUMBER) IS
1848: SELECT sum(amount) total_amount
1849: FROM AP_EXPENSE_REPORT_LINES_ALL
1850: WHERE report_header_id = p_report_header_id
1851: AND web_parameter_id <> p_personal_expense_id
1852: AND credit_card_trx_id = p_trx_id
1853: AND (itemization_parent_id is null OR itemization_parent_id <> -1);

Line 1913: PROCEDURE process_shortpays(expense_line_rec IN AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE) IS

1909: | Date Author Description of Changes
1910: | 21-Jul-2003 J Rautiainen Created
1911: |
1912: *=======================================================================*/
1913: PROCEDURE process_shortpays(expense_line_rec IN AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE) IS
1914: BEGIN
1915: IF (expense_line_rec.report_header_id IS NOT NULL
1916: AND expense_line_rec.itemization_parent_id IS NOT NULL) THEN
1917:

Line 1926: UPDATE AP_EXPENSE_REPORT_LINES_ALL

1922: * itemization is shortpaid. So the query has OR statement which will deal with
1923: * cash and CC lines separately. For cash the itemized lines are shortpaid, for
1924: * CC transactions all lines belonging to the same transactions are shortpaid
1925: */
1926: UPDATE AP_EXPENSE_REPORT_LINES_ALL
1927: SET policy_shortpay_flag = DECODE(expense_line_rec.policy_shortpay_flag,
1928: 'Y','Y',
1929: policy_shortpay_flag),
1930: receipt_verified_flag = DECODE(NVL(expense_line_rec.receipt_verified_flag,'N'),

Line 1977: FROM ap_expense_report_lines_all

1973: sum(daily_amount
1974: * NVL((end_expense_date - start_expense_date)+1,1)
1975: * NVL(receipt_conversion_rate,1)) total_daily_amount,
1976: currency_code
1977: FROM ap_expense_report_lines_all
1978: WHERE report_header_id = p_report_header_id
1979: AND currency_code <> NVL(receipt_currency_code,currency_code)
1980: AND web_parameter_id <> p_personal_expense_id
1981: AND web_parameter_id <> p_rounding_expense_id

Line 1988: FROM AP_EXPENSE_REPORT_LINES_ALL AERL

1984: GROUP BY itemization_parent_id, credit_card_trx_id, currency_code;
1985:
1986: CURSOR rounding_line_c(p_itemization_parent_id IN NUMBER, p_trx_id IN NUMBER, p_rounding_expense_id IN NUMBER) IS
1987: SELECT AERL.*
1988: FROM AP_EXPENSE_REPORT_LINES_ALL AERL
1989: WHERE REPORT_HEADER_ID = p_report_header_id
1990: AND WEB_PARAMETER_ID = p_rounding_expense_id
1991: AND ITEMIZATION_PARENT_ID = p_itemization_parent_id
1992: AND ( (p_trx_id IS NULL AND credit_card_trx_id is NULL)

Line 2000: FROM AP_EXPENSE_REPORT_LINES_ALL AERL

1996: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
1997:
1998: CURSOR lines_c(p_itemization_parent_id IN NUMBER, p_trx_id IN NUMBER, p_personal_expense_id IN NUMBER) IS
1999: SELECT AERL.*
2000: FROM AP_EXPENSE_REPORT_LINES_ALL AERL
2001: WHERE REPORT_HEADER_ID = p_report_header_id
2002: AND WEB_PARAMETER_ID <> p_personal_expense_id
2003: AND ITEMIZATION_PARENT_ID = p_itemization_parent_id
2004: AND ( (p_trx_id IS NULL AND credit_card_trx_id is NULL)

Line 2026: new_report_line_rec AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE;

2022:
2023: rounding_line_rec rounding_line_c%ROWTYPE;
2024: rounding_expense_rec rounding_expense_c%ROWTYPE;
2025: lines_rec lines_c%ROWTYPE;
2026: new_report_line_rec AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE;
2027: distribution_rec distribution_c%ROWTYPE;
2028: l_exp_line_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
2029:
2030: ln_total_amount NUMBER;

Line 2071: UPDATE AP_EXPENSE_REPORT_LINES_ALL

2067: FETCH rounding_line_c into rounding_line_rec;
2068:
2069: IF rounding_line_c%FOUND THEN
2070:
2071: UPDATE AP_EXPENSE_REPORT_LINES_ALL
2072: SET amount = ln_rounding_amount
2073: WHERE CURRENT OF rounding_line_c;
2074:
2075: CLOSE rounding_line_c;

Line 2142: DELETE AP_EXPENSE_REPORT_LINES_ALL

2138: OPEN rounding_line_c(totals_rec.itemization_parent_id, totals_rec.credit_card_trx_id, ln_rounding_expense_id);
2139: FETCH rounding_line_c into rounding_line_rec;
2140:
2141: IF rounding_line_c%FOUND THEN
2142: DELETE AP_EXPENSE_REPORT_LINES_ALL
2143: WHERE CURRENT OF rounding_line_c;
2144: END IF;
2145: CLOSE rounding_line_c;
2146:

Line 2191: FROM AP_EXPENSE_REPORT_LINES_ALL

2187: line_count NUMBER(15);
2188: BEGIN
2189:
2190: SELECT COUNT(REPORT_LINE_ID) into line_count
2191: FROM AP_EXPENSE_REPORT_LINES_ALL
2192: WHERE REPORT_HEADER_ID = p_report_header_id;
2193:
2194: IF line_count = 0 THEN
2195: RETURN TRUE;

Line 2208: FROM AP_EXPENSE_REPORT_LINES_ALL

2204: l_img_receipt_count NUMBER;
2205: BEGIN
2206:
2207: SELECT COUNT(1) into l_img_receipt_count
2208: FROM AP_EXPENSE_REPORT_LINES_ALL
2209: WHERE REPORT_HEADER_ID = p_report_header_id
2210: AND NVL(IMAGE_RECEIPT_REQUIRED_FLAG, 'N') = 'Y';
2211:
2212: SELECT COUNT(1) into l_receipt_count

Line 2213: FROM AP_EXPENSE_REPORT_LINES_ALL

2209: WHERE REPORT_HEADER_ID = p_report_header_id
2210: AND NVL(IMAGE_RECEIPT_REQUIRED_FLAG, 'N') = 'Y';
2211:
2212: SELECT COUNT(1) into l_receipt_count
2213: FROM AP_EXPENSE_REPORT_LINES_ALL
2214: WHERE REPORT_HEADER_ID = p_report_header_id
2215: AND NVL(RECEIPT_REQUIRED_FLAG, 'N') = 'Y';
2216:
2217: IF l_img_receipt_count > 0 THEN

Line 2227: from ap_expense_report_lines_all aerl

2223:
2224: PROCEDURE process_random_audit(p_report_header_id IN NUMBER, p_audit_code OUT NOCOPY VARCHAR2) IS
2225: CURSOR rr_cur IS
2226: select count(1) rr_line_count
2227: from ap_expense_report_lines_all aerl
2228: where aerl.report_header_id = p_report_header_id
2229: and (nvl(aerl.receipt_required_flag, 'N') = 'Y' OR nvl(aerl.image_receipt_required_flag, 'N') = 'Y');
2230:
2231: rr_rec rr_cur%ROWTYPE;