DBA Data[Home] [Help]

PACKAGE: APPS.AP_WEB_CREDIT_CARD_PKG

Source


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;