[Home] [Help]
PACKAGE: APPS.IEX_PAYMENTS_PUB
Source
1 PACKAGE IEX_PAYMENTS_PUB as
2 /* $Header: iexpypys.pls 120.5.12010000.2 2008/08/29 13:52:24 gnramasa ship $ */
3
4 TYPE ATTRIBUTE_REC_TYPE IS RECORD
5 (
6 ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT NULL,
7 ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL,
8 ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL,
9 ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL,
10 ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL,
11 ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL,
12 ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL,
13 ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL,
14 ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL,
15 ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL,
16 ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL,
17 ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL,
18 ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL,
19 ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL,
20 ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL,
21 ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL
22 );
23
24 TYPE BANKACCTINSTR_REC_TYPE IS RECORD
25 (
26 FINAME VARCHAR2(80),
27 BANK_ID VARCHAR2(25),
28 BRANCH_ID VARCHAR2(30),
29 BANKACCT_TYPE VARCHAR2(80),
30 BANKACCT_NUM VARCHAR2(80),
31 BANKACCT_HOLDERNAME VARCHAR2(80)
32 );
33
34 TYPE CREDITCARDINSTR_REC_TYPE IS RECORD
35 (
36 FINAME VARCHAR2(80),
37 CC_TYPE VARCHAR2(80),
38 CC_NUM VARCHAR2(80),
39 CC_EXPDATE DATE,
40 CC_HOLDERNAME VARCHAR2(80)
41 );
42
43 TYPE PMTINSTR_REC_TYPE IS RECORD
44 (
45 USE_INSTRUMENT VARCHAR2(5),
46 CREDITCARDINSTR CREDITCARDINSTR_REC_TYPE,
47 BANKACCTINSTR BANKACCTINSTR_REC_TYPE
48 );
49
50 TYPE PMT_REC_TYPE IS RECORD
51 (
52 PAYMENT_TARGET VARCHAR2(30), /*(valid[ values: ACCOUNTS, INVOICES, CNSLD, CONTRACTS)*/
53 TOTAL_AMOUNT NUMBER,
54 CURRENCY_CODE VARCHAR2(80),
55 EXCHANGE_RATE_TYPE VARCHAR2(30),
56 EXCHANGE_DATE DATE,
57 PAYEE_ID VARCHAR2(80),
58 PAYER_PARTY_REL_ID NUMBER,
59 PAYER_PARTY_ORG_ID NUMBER,
60 PAYER_PARTY_PER_ID NUMBER,
61 NOTE VARCHAR2(2000),
62 CAMPAIGN_SCHED_ID NUMBER,
63 RESOURCE_ID NUMBER,
64 ATTRIBUTES ATTRIBUTE_REC_TYPE,
65 CUST_ACCOUNT_ID NUMBER, --Added for bug 6717279 25-Aug-2008 gnramasa
66 CUST_SITE_USE_ID NUMBER --Added for bug 6717279 25-Aug-2008 gnramasa
67 );
68
69 TYPE PMTDTL_REC_TYPE IS RECORD
70 (
71 CUST_ACCOUNT_ID NUMBER, -- required, used with all payment targets
72 CUST_SITE_USE_ID NUMBER, -- used only for paying on INVOICES and ACCOUNTS
73 PAYMENT_SCHEDULE_ID NUMBER, -- used only for paying on INVOICES
74 CNSLD_INVOICE_ID NUMBER, -- used only for paying on CNSLD
75 CONTRACT_ID NUMBER, -- used only for paying on CONTRACTS
76 AMOUNT NUMBER, -- required, used with all payment targets
77 TRX_TO_CR_RATE NUMBER := 1,-- used only for paying on INVOICES and ACCOUNTS
78 -- Begin -- varangan --Bug4528444 -- for payments uptake
79 TRX_EXTN_ID NUMBER,
80 CURRENCY_CODE VARCHAR2(80)
81 -- End -- varangan --Bug4528444 -- for payments uptake
82 );
83 TYPE PMTDTLS_TBL_TYPE IS TABLE OF PMTDTL_REC_TYPE INDEX BY BINARY_INTEGER;
84
85 TYPE PMTRESP_REC_TYPE IS RECORD
86 (
87 PAYMENT_ID NUMBER,
88 NOTE_ID NUMBER,
89 TRXN_ID NUMBER,
90 TRXN_TYPE NUMBER,
91 TRXN_DATE DATE,
92 AUTHCODE VARCHAR2(80),
93 INSTRUMENT_ID NUMBER,
94 INSTRUMENT_TYPE VARCHAR2(10),
95 PAYEE_ID VARCHAR2(100),
96 TANGIBLE_ID VARCHAR2(100)
97 );
98
99 PROCEDURE CREATE_PAYMENT(
100 P_API_VERSION IN NUMBER,
101 P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
102 P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
103 P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
104 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
105 X_MSG_COUNT OUT NOCOPY NUMBER,
106 X_MSG_DATA OUT NOCOPY VARCHAR2,
107 P_PMT_REC IN IEX_PAYMENTS_PUB.PMT_REC_TYPE,
108 P_PMTDTLS_TBL IN IEX_PAYMENTS_PUB.PMTDTLS_TBL_TYPE,
109 P_PMTINSTR_REC IN IEX_PAYMENTS_PUB.PMTINSTR_REC_TYPE,
110 P_PMT_METHOD IN NUMBER, -- Included by varangan for profile bug#4558547
111 X_PMTRESP_REC OUT NOCOPY IEX_PAYMENTS_PUB.PMTRESP_REC_TYPE
112 );
113
114 PROCEDURE GET_PAYER_INFO(P_PAYER_PARTY_REL_ID IN NUMBER,
115 P_PAYER_PARTY_ORG_ID IN NUMBER,
116 P_PAYER_PARTY_PER_ID IN NUMBER,
117 X_NOTE_PAYER_TYPE OUT NOCOPY VARCHAR2,
118 X_NOTE_PAYER_NUM_ID OUT NOCOPY NUMBER,
119 X_PAYER_NUM_ID OUT NOCOPY NUMBER,
120 X_PAYER_ID OUT NOCOPY VARCHAR2,
121 X_PAYER_NAME OUT NOCOPY VARCHAR2) ;
122 -- Begin -- varangan --Bug4528444 -- for payments uptake
123
124 l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
125 -- End -- varangan --Bug4528444 -- for payments uptake
126
127 END;