1 PACKAGE AP_WEB_CREDIT_CARD_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwccrds.pls 120.6.12010000.2 2009/08/04 13:11:51 meesubra ship $ */
3
4 /* Function introduced in OIE.J
5 It returns 'Y' if a transaction has level2 data
6 and expense tpye as 'HOTEL'. Ideally, we should
7 have a column in ap_credit_card_trxns_all table which
8 should get populated during loading the transaciotn if
9 level2 transaction is present.
10 */
11 FUNCTION HAS_DETAILED_TRXN (p_trx_id IN VARCHAR2)
12 RETURN VARCHAR2;
13
14 /* Introduced in R12 */
15 function create_iby_card(p_card_number IN VARCHAR2,
16 p_party_id IN NUMBER,
17 p_exp_date IN Date DEFAULT NULL
18 ) return number;
19
20 /* Introduced in R12 */
21 function get_card_id(p_card_number IN VARCHAR2,
22 p_card_program_id IN VARCHAR2 DEFAULT NULL,
23 p_party_id IN NUMBER DEFAULT NULL,
24 p_request_id IN VARCHAR2 DEFAULT NULL
25 ) return number;
26
27 /* Returns card_reference_id (IBY_CREDITCARD.instrid) */
28 FUNCTION get_card_reference_id(p_document_payable_id IN NUMBER) return NUMBER;
29
30 END AP_WEB_CREDIT_CARD_PKG;