1 PACKAGE PON_EMD_VALIDATION_PKG AUTHID CURRENT_USER AS
2 /* $Header: PONEMDVS.pls 120.4 2010/12/01 04:20:49 puppulur ship $ */
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| PONEMDVS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| PL/SQL spec for package: PON_EMD_VALIDATION_PKG |
13 --| |
14 --| PROCEDURE LIST |
15 --| PROCEDURE validate_credit_card_num |
16 --| |
17 --| |
18 --| HISTORY |
19 --| 01/15/2009 Allen Yang Created
20 --| 04/01/2009 Lion Li Add new PROCEDURE getReceiptInfoOfTrx |
21 --+======================================================================*/
22 -- Declare global variable for package name
23 g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),
24 'N');
25 g_pkg_name CONSTANT VARCHAR2(50) := 'PON_EMD_VALIDATION_PKG';
26 g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.' || g_pkg_name || '.';
27
28 -- Declare global constants
29 GV_TRUE CONSTANT VARCHAR2(1) := 'T';
30
31 -- Constant for invalid credit card number
32 G_RC_INVALID_CCNUMBER CONSTANT VARCHAR2(50) := 'INVALID_CARD_NUMBER';
33
34 --==========================================================================
35 -- PROCEDURE NAME:
36 --
37 -- validate_credit_card_num Public
38 --
39 -- DESCRIPTION:
40 --
41 -- This procedure is to to validate if the credit card number is valid
42 --
43 -- PARAMETERS:
44 -- In: p_api_version API Version
45 -- p_init_msg_list Whether to initialize message list
46 -- p_card_number Credit Card Number
47 --
48 -- Out: x_return_status Returned flag to show if CCNumber is valid
49 --
50 --
51 -- DESIGN REFERENCES:
52 -- EMD_TECHNICAL_DESIGN_ALLEN.doc
53 --
54 -- CHANGE HISTORY:
55 --
56 -- 15-Jan-2009 Allen Yang created
57
58 PROCEDURE validate_credit_card_num(p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2,
60 p_card_number IN VARCHAR2,
61 x_return_status OUT NOCOPY VARCHAR2);
62 --==========================================================================
63 -- PROCEDURE NAME:
64 --
65 -- getReceiptInfoOfTrx Public
66 --
67 -- DESCRIPTION:
68 --
69 -- This procedure is to to get the receipt information of transaction
70 --
71 -- PARAMETERS:
72 -- In: p_trx_id Transaction id
73 -- p_trx_number Transaction number
74 -- p_org_id Org id
75 --
76 -- Out: x_return_status Returned flag to show if has receipt information of this transaction
77 -- x_receipt_num Returned receipt number of this transacton
78 -- x_cash_receipt_id Returned cash receipt id of this transacton
79 -- x_receivable_app_id Returned receivable app id of this transaction
80 -- x_receipt_status Returned receipt status of this transaction
81 -- DESIGN REFERENCES:
82 -- EMD_TECHNICAL_DESIGN_ALLEN.doc
83 --
84 -- CHANGE HISTORY:
85 --
86 -- 01-Apr-2009 Lion Li created
87
88 PROCEDURE getReceiptInfoOfTrx(p_trx_id IN NUMBER,
89 p_trx_number IN VARCHAR2,
90 p_org_id IN NUMBER,
91 x_receipt_num OUT NOCOPY VARCHAR2,
92 x_cash_receipt_id OUT NOCOPY NUMBER,
93 x_receivable_app_id OUT NOCOPY NUMBER,
94 x_receipt_status OUT NOCOPY VARCHAR2,
95 x_receipt_status_code OUT NOCOPY VARCHAR2,
96 x_return_status OUT NOCOPY VARCHAR2);
97
98 PROCEDURE ADD_EMD_BIDDING_PARTY
99 (
100 L_AUCTION_HEADER_ID IN NUMBER,
101 L_LIST_ID IN NUMBER,
102 L_SEQUENCE IN NUMBER,
103 L_TRADING_PARTNER_ID IN NUMBER,
104 L_TRADING_PARTNER_NAME IN VARCHAR2,
105 L_VENDOR_SITE_ID IN NUMBER
106 );
107
108 FUNCTION get_user_name(P_USER_ID IN NUMBER ) RETURN VARCHAR2;
109
110 END PON_EMD_VALIDATION_PKG;
111