DBA Data[Home] [Help]

PACKAGE: APPS.IBY_PCARD_RECOGNITION_PKG

Source


1 PACKAGE IBY_PCARD_RECOGNITION_PKG AUTHID CURRENT_USER AS
2 /* $Header: ibypcrcs.pls 115.4 2002/11/19 01:45:29 jleybovi noship $ */
3 
4 
5   /* Length of a credit card's bank identification number. */
6   C_BIN_LENGTH CONSTANT NUMBER := 9;
7 
8 
9   SUBTYPE PCARD_TYPEVAL IS VARCHAR2(1);
10 
11   /* Corporate purchase card subtype. */
12   C_SUBTYPE_CORPORATE CONSTANT PCARD_TYPEVAL := 'C';
13 
14   /* Purchase purchase card subtype. */
15   C_SUBTYPE_PURCHASE CONSTANT PCARD_TYPEVAL := 'P';
16 
17   /* Business purchase card subtype. */
18   C_SUBTYPE_BUSINESS CONSTANT PCARD_TYPEVAL := 'B';
19 
20   /* Fleet purchase card subtype. */
21   C_SUBTYPE_FLEET CONSTANT PCARD_TYPEVAL := 'F';
22 
23   /* Fleet purchase card subtype. */
24   C_SUBTYPE_GOVERNMENT CONSTANT PCARD_TYPEVAL := 'G';
25 
26   /* For credit card numbers which do not belong to purchase cards. */
27   C_SUBTYPE_NONPCARD CONSTANT PCARD_TYPEVAL := 'U';
28 
29 
30   /*
31    * USE: Gets the purchase card subtype associated with a given
32    *      credit card number.
33    *
34    * ARGS:
35    *    1.  the instrument number/credit card number; must consist
36    *	    entirely of digits (i.e. '4111-411...' is not allowed!)
37    *
38    * OUTS:
39    *    2.  the purchase card subtype associated with the given
40    *        number; will be value C_SUBTYPE_NONPCARD if the number
41    *        is not that of a purchase card.
42    *
43    */
44    PROCEDURE getPCardSubType
45 	(
46 	p_instr_number		IN	VARCHAR,
47 	p_card_subtype		OUT NOCOPY PCARD_TYPEVAL
48 	);
49 
50 
51 END IBY_PCARD_RECOGNITION_PKG;