1 PACKAGE AP_WEB_CREDIT_CARD_PKG AS
2 /* $Header: apwccrds.pls 120.6 2006/10/12 23:46:47 skoukunt 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 ) return number;
18
19 /* Introduced in R12 */
20 function get_card_id(p_card_number IN VARCHAR2,
21 p_card_program_id IN VARCHAR2 DEFAULT NULL,
22 p_party_id IN NUMBER DEFAULT NULL,
23 p_request_id IN VARCHAR2 DEFAULT NULL
24 ) return number;
25
26 /* Returns card_reference_id (IBY_CREDITCARD.instrid) */
27 FUNCTION get_card_reference_id(p_document_payable_id IN NUMBER) return NUMBER;
28
29 END AP_WEB_CREDIT_CARD_PKG;