1 PACKAGE AP_CREDIT_CARD_INVOICE_PKG AS
2 /* $Header: apwcciis.pls 120.5 2005/06/16 07:46:43 nammishr ship $ */
3 PROCEDURE createCreditCardInvoice(
4 errbuf OUT NOCOPY VARCHAR2,
5 retcode OUT NOCOPY NUMBER,
6 p_cardProgramID IN NUMBER,
7 p_startDate IN DATE DEFAULT NULL,
8 p_endDate IN DATE DEFAULT NULL,
9 p_invoiceId OUT NOCOPY NUMBER);
10
11 /*
12 Purpose:
13 To reverse expense credit card receitps that are prepaid by company. Specifically, this
14 procedure does:
15 1. Create negative lines in the ap_invoice_distributions tables for prepaid
16 business credit card lines
17 2. Update the amout and base_amount of the corresponding invoice in AP_INVOICES.
18 Input:
19 p_invoiceId : invoice id
20 p_expReportHeaderId : expense report header id
21 p_glDate : GL date
22 p_periodName : period name
23 Output:
24 None
25 Input Output:
26 None
27 Date:
28 3/28/00
29 */
30 PROCEDURE createCCardReversals(p_invoiceId IN NUMBER,
31 p_expReportHeaderId IN NUMBER,
32 p_glDate IN DATE,
33 p_periodName IN VARCHAR2);
34
35 FUNCTION createCreditCardReversals(p_invoiceId IN NUMBER,
36 p_expReportHeaderId IN NUMBER,
37 p_gl_date IN DATE,
38 p_invoiceTotal IN NUMBER) RETURN NUMBER;
39
40 END AP_CREDIT_CARD_INVOICE_PKG;