APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_CREDIT_CARD_TRXNS_ALL

Line 1843: FROM AP_CREDIT_CARD_TRXNS_ALL cct

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
1844: WHERE cct.trx_id = p_trx_id
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

Line 1871: UPDATE AP_CREDIT_CARD_TRXNS_ALL

1867:
1868: OPEN trx_c(expense_line_rec.credit_card_trx_id);
1869: FETCH trx_c into trx_rec;
1870:
1871: UPDATE AP_CREDIT_CARD_TRXNS_ALL
1872: SET expensed_amount = total_rec.total_amount
1873: WHERE CURRENT OF trx_c;
1874:
1875: CLOSE trx_c;

Line 1879: UPDATE AP_CREDIT_CARD_TRXNS_ALL

1875: CLOSE trx_c;
1876:
1877: IF (total_rec.total_amount=0) THEN -- Bug 6628290 (sodash) when the Expensed Amount is zero, set the category as personal for the Credit Card Trxn.
1878:
1879: UPDATE AP_CREDIT_CARD_TRXNS_ALL
1880: SET category = 'PERSONAL'
1881: WHERE trx_id = expense_line_rec.credit_card_trx_id;
1882:
1883: END IF;