DBA Data[Home] [Help]

PACKAGE: APPS.AP_WEB_CREDIT_CARD_PKG

Source


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;