APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_CREDIT_CARD_TRXNS_ALL

Line 1726: FROM AP_CREDIT_CARD_TRXNS_ALL cct

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

Line 1754: UPDATE AP_CREDIT_CARD_TRXNS_ALL

1750:
1751: OPEN trx_c(expense_line_rec.credit_card_trx_id);
1752: FETCH trx_c into trx_rec;
1753:
1754: UPDATE AP_CREDIT_CARD_TRXNS_ALL
1755: SET expensed_amount = total_rec.total_amount
1756: WHERE CURRENT OF trx_c;
1757:
1758: CLOSE trx_c;

Line 1762: UPDATE AP_CREDIT_CARD_TRXNS_ALL

1758: CLOSE trx_c;
1759:
1760: 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.
1761:
1762: UPDATE AP_CREDIT_CARD_TRXNS_ALL
1763: SET category = 'PERSONAL'
1764: WHERE trx_id = expense_line_rec.credit_card_trx_id;
1765:
1766: END IF;