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.

APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 504: from AP_EXPENSE_REPORT_LINES_ALL

500: p_audit_report OUT NOCOPY BOOLEAN) IS
501:
502: CURSOR receipt_cur IS
503: select min(start_expense_date) oldest_receipt_date
504: from AP_EXPENSE_REPORT_LINES_ALL
505: where report_header_id = p_report_header_id;
506:
507: receipt_rec receipt_cur%ROWTYPE;
508:

Line 554: from AP_EXPENSE_REPORT_LINES_ALL

550: p_audit_report OUT NOCOPY BOOLEAN) IS
551:
552: CURSOR receipt_cur IS
553: select count(1) required_count
554: from AP_EXPENSE_REPORT_LINES_ALL
555: where report_header_id = p_report_header_id
556: and NVL(receipt_required_flag,'N') = 'Y';
557:
558: receipt_rec receipt_cur%ROWTYPE;

Line 602: from AP_EXPENSE_REPORT_LINES_ALL aerl

598: p_audit_report OUT NOCOPY BOOLEAN) IS
599:
600: CURSOR line_cur IS
601: select count(aerl.report_header_id) required_count
602: from AP_EXPENSE_REPORT_LINES_ALL aerl
603: where aerl.report_header_id = p_report_header_id
604: and ( NVL(aerl.justification_required_flag,'N') = 'Y'
605: OR (
606: NVL(aerl.justification_required_flag,'N') = 'V'

Line 848: from ap_expense_report_lines_all aerl

844: p_audit_report OUT NOCOPY BOOLEAN) IS
845:
846: CURSOR debit_cur IS
847: select count(1) debit_line_count
848: from ap_expense_report_lines_all aerl
849: where aerl.report_header_id = p_report_header_id
850: and amount > 0;
851:
852: debit_rec debit_cur%ROWTYPE;

Line 1025: from ap_expense_report_lines_all aerl

1021: p_audit_report OUT NOCOPY BOOLEAN) IS
1022:
1023: CURSOR cc_cur IS
1024: select count(1) non_cc_line_count
1025: from ap_expense_report_lines_all aerl
1026: where aerl.report_header_id = p_report_header_id
1027: and ( CREDIT_CARD_TRX_ID is null
1028: OR ( CREDIT_CARD_TRX_ID is not null
1029: AND NVL(receipt_required_flag,'N') = 'Y'

Line 1035: from ap_expense_report_lines_all aerl

1031: );
1032:
1033: CURSOR pdm_cur IS
1034: select count(1) non_pdm_line_count
1035: from ap_expense_report_lines_all aerl
1036: where aerl.report_header_id = p_report_header_id
1037: and NVL(aerl.category_code,'NONE') not in ('PER_DIEM','MILEAGE');
1038:
1039: CURSOR rr_cur IS

Line 1041: from ap_expense_report_lines_all aerl

1037: and NVL(aerl.category_code,'NONE') not in ('PER_DIEM','MILEAGE');
1038:
1039: CURSOR rr_cur IS
1040: select count(1) rr_line_count
1041: from ap_expense_report_lines_all aerl
1042: where aerl.report_header_id = p_report_header_id
1043: and nvl(aerl.receipt_required_flag, 'N') = 'Y';
1044:
1045: pdm_rec pdm_cur%ROWTYPE;

Line 1166: from AP_EXPENSE_REPORT_LINES_ALL aerl

1162: and aerh.report_submitted_date > add_months(sysdate,-1)
1163: and ( aerh.source in ('WebExpense', 'SelfService')
1164: or aerh.report_header_id = p_report_header_id)
1165: and exists(select 'Y'
1166: from AP_EXPENSE_REPORT_LINES_ALL aerl
1167: where aerh.report_header_id = aerl.report_header_id);
1168:
1169:
1170: list_rec list_cur%ROWTYPE;

Line 1657: FROM AP_EXPENSE_REPORT_LINES_ALL AERL

1653: PROCEDURE process_audit_actions(p_report_header_id IN NUMBER) IS
1654:
1655: CURSOR report_lines_c IS
1656: SELECT AERL.*
1657: FROM AP_EXPENSE_REPORT_LINES_ALL AERL
1658: WHERE REPORT_HEADER_ID = p_report_header_id
1659: AND (itemization_parent_id is null OR itemization_parent_id <> -1)
1660: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
1661:

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

1718: | Date Author Description of Changes
1719: | 21-Jul-2003 J Rautiainen Created
1720: |
1721: *=======================================================================*/
1722: PROCEDURE update_cc_transaction(expense_line_rec IN AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE) IS
1723:
1724: CURSOR trx_c(p_trx_id IN NUMBER) IS
1725: SELECT cct.*
1726: FROM AP_CREDIT_CARD_TRXNS_ALL cct

Line 1732: FROM AP_EXPENSE_REPORT_LINES_ALL

1728: FOR UPDATE OF TRX_ID NOWAIT;
1729:
1730: CURSOR total_c(p_report_header_id IN NUMBER, p_trx_id IN NUMBER, p_personal_expense_id IN NUMBER) IS
1731: SELECT sum(amount) total_amount
1732: FROM AP_EXPENSE_REPORT_LINES_ALL
1733: WHERE report_header_id = p_report_header_id
1734: AND web_parameter_id <> p_personal_expense_id
1735: AND credit_card_trx_id = p_trx_id
1736: AND (itemization_parent_id is null OR itemization_parent_id <> -1);

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

1792: | Date Author Description of Changes
1793: | 21-Jul-2003 J Rautiainen Created
1794: |
1795: *=======================================================================*/
1796: PROCEDURE process_shortpays(expense_line_rec IN AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE) IS
1797: BEGIN
1798: IF (expense_line_rec.report_header_id IS NOT NULL
1799: AND expense_line_rec.itemization_parent_id IS NOT NULL) THEN
1800:

Line 1809: UPDATE AP_EXPENSE_REPORT_LINES_ALL

1805: * itemization is shortpaid. So the query has OR statement which will deal with
1806: * cash and CC lines separately. For cash the itemized lines are shortpaid, for
1807: * CC transactions all lines belonging to the same transactions are shortpaid
1808: */
1809: UPDATE AP_EXPENSE_REPORT_LINES_ALL
1810: SET policy_shortpay_flag = DECODE(expense_line_rec.policy_shortpay_flag,
1811: 'Y','Y',
1812: policy_shortpay_flag),
1813: receipt_verified_flag = DECODE(NVL(expense_line_rec.receipt_verified_flag,'N'),

Line 1860: FROM ap_expense_report_lines_all

1856: sum(daily_amount
1857: * NVL((end_expense_date - start_expense_date)+1,1)
1858: * NVL(receipt_conversion_rate,1)) total_daily_amount,
1859: currency_code
1860: FROM ap_expense_report_lines_all
1861: WHERE report_header_id = p_report_header_id
1862: AND currency_code <> NVL(receipt_currency_code,currency_code)
1863: AND web_parameter_id <> p_personal_expense_id
1864: AND web_parameter_id <> p_rounding_expense_id

Line 1871: FROM AP_EXPENSE_REPORT_LINES_ALL AERL

1867: GROUP BY itemization_parent_id, credit_card_trx_id, currency_code;
1868:
1869: CURSOR rounding_line_c(p_itemization_parent_id IN NUMBER, p_trx_id IN NUMBER, p_rounding_expense_id IN NUMBER) IS
1870: SELECT AERL.*
1871: FROM AP_EXPENSE_REPORT_LINES_ALL AERL
1872: WHERE REPORT_HEADER_ID = p_report_header_id
1873: AND WEB_PARAMETER_ID = p_rounding_expense_id
1874: AND ITEMIZATION_PARENT_ID = p_itemization_parent_id
1875: AND ( (p_trx_id IS NULL AND credit_card_trx_id is NULL)

Line 1883: FROM AP_EXPENSE_REPORT_LINES_ALL AERL

1879: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
1880:
1881: CURSOR lines_c(p_itemization_parent_id IN NUMBER, p_trx_id IN NUMBER, p_personal_expense_id IN NUMBER) IS
1882: SELECT AERL.*
1883: FROM AP_EXPENSE_REPORT_LINES_ALL AERL
1884: WHERE REPORT_HEADER_ID = p_report_header_id
1885: AND WEB_PARAMETER_ID <> p_personal_expense_id
1886: AND ITEMIZATION_PARENT_ID = p_itemization_parent_id
1887: AND ( (p_trx_id IS NULL AND credit_card_trx_id is NULL)

Line 1909: new_report_line_rec AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE;

1905:
1906: rounding_line_rec rounding_line_c%ROWTYPE;
1907: rounding_expense_rec rounding_expense_c%ROWTYPE;
1908: lines_rec lines_c%ROWTYPE;
1909: new_report_line_rec AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE;
1910: distribution_rec distribution_c%ROWTYPE;
1911: l_exp_line_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
1912:
1913: ln_total_amount NUMBER;

Line 1954: UPDATE AP_EXPENSE_REPORT_LINES_ALL

1950: FETCH rounding_line_c into rounding_line_rec;
1951:
1952: IF rounding_line_c%FOUND THEN
1953:
1954: UPDATE AP_EXPENSE_REPORT_LINES_ALL
1955: SET amount = ln_rounding_amount
1956: WHERE CURRENT OF rounding_line_c;
1957:
1958: CLOSE rounding_line_c;

Line 2025: DELETE AP_EXPENSE_REPORT_LINES_ALL

2021: OPEN rounding_line_c(totals_rec.itemization_parent_id, totals_rec.credit_card_trx_id, ln_rounding_expense_id);
2022: FETCH rounding_line_c into rounding_line_rec;
2023:
2024: IF rounding_line_c%FOUND THEN
2025: DELETE AP_EXPENSE_REPORT_LINES_ALL
2026: WHERE CURRENT OF rounding_line_c;
2027: END IF;
2028: CLOSE rounding_line_c;
2029:

Line 2074: FROM AP_EXPENSE_REPORT_LINES_ALL

2070: line_count NUMBER(15);
2071: BEGIN
2072:
2073: SELECT COUNT(REPORT_LINE_ID) into line_count
2074: FROM AP_EXPENSE_REPORT_LINES_ALL
2075: WHERE REPORT_HEADER_ID = p_report_header_id;
2076:
2077: IF line_count = 0 THEN
2078: RETURN TRUE;