1 PACKAGE OKS_CUSTOMER_ACCEPTANCE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSVCUSS.pls 120.6.12000000.1 2007/01/16 22:16:17 appldev ship $ */
3
4 FUNCTION get_contract_amount
5 (
6 p_chr_id IN NUMBER
7 ) RETURN VARCHAR2;
8
9 FUNCTION get_contract_subtotal
10 (
11 p_chr_id IN NUMBER
12 ) RETURN VARCHAR2;
13
14 FUNCTION get_contract_tax
15 (
16 p_chr_id IN NUMBER
17 ) RETURN VARCHAR2;
18
19 FUNCTION get_contract_accept_clause
20 (
21 p_chr_id IN NUMBER
22 ) RETURN VARCHAR2;
23
24 FUNCTION get_contract_decline_clause
25 (
26 p_chr_id IN NUMBER
27 ) RETURN VARCHAR2;
28
29 FUNCTION get_contract_vendor
30 (
31 p_chr_id IN NUMBER
32 ) RETURN VARCHAR2;
33
34 FUNCTION get_contract_customer
35 (
36 p_chr_id IN NUMBER
37 ) RETURN VARCHAR2;
38
39 FUNCTION get_contract_party
40 (
41 p_chr_id IN NUMBER
42 ) RETURN NUMBER;
43
44 FUNCTION get_contract_organization
45 (
46 p_chr_id IN NUMBER
47 ) RETURN NUMBER;
48
49 FUNCTION get_contract_salesrep_email
50 (
51 p_chr_id IN NUMBER
52 ) RETURN VARCHAR2;
53
54 FUNCTION get_contract_cust_account_id
55 (
56 p_chr_id IN NUMBER
57 ) RETURN NUMBER;
58
59 FUNCTION get_req_ass_email_subject
60 (
61 p_chr_id IN NUMBER
62 ) RETURN VARCHAR2;
63
64 FUNCTION duration_unit_and_period
65 (
66 p_start_date IN DATE,
67 p_end_date IN DATE
68 ) RETURN VARCHAR2;
69
70 FUNCTION get_credit_card_dtls
71 (
72 p_trxn_extension_id IN NUMBER
73 ) RETURN VARCHAR2;
74
75 FUNCTION get_credit_card_cvv2
76 (
77 p_trxn_extension_id IN NUMBER
78 ) RETURN VARCHAR2;
79
80 FUNCTION get_contract_currency_tip
81 (
82 p_chr_id IN NUMBER
83 ) RETURN VARCHAR2;
84
85 PROCEDURE decline_contract
86 (
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2,
89 p_chr_id IN NUMBER,
90 p_reason_code IN VARCHAR2,
91 p_decline_reason IN VARCHAR2,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER
95 );
96
97 PROCEDURE accept_contract
98 (
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2,
101 p_chr_id IN NUMBER,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER
105 );
106
107 PROCEDURE update_payment_details
108 (
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2,
111 p_chr_id IN NUMBER,
112 p_payment_type IN VARCHAR2,
113 p_payment_details IN VARCHAR2,
114 p_party_id IN NUMBER,
115 p_cust_account_id IN NUMBER,
116 p_card_number IN VARCHAR2 DEFAULT NULL,
117 p_expiration_month IN VARCHAR2 DEFAULT NULL,
118 p_expiration_year IN VARCHAR2 DEFAULT NULL,
119 p_cvv_code IN VARCHAR2 DEFAULT NULL,
120 p_instr_assignment_id IN NUMBER DEFAULT NULL,
121 p_old_txn_entension_id IN NUMBER DEFAULT NULL,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER
125 );
126
127 PROCEDURE send_email
128 (
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2,
131 p_chr_id IN NUMBER,
132 p_send_to IN VARCHAR2,
133 p_cc_to IN VARCHAR2,
134 p_subject IN VARCHAR2,
135 p_text IN VARCHAR2,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER
139 );
140
141 PROCEDURE get_valid_payments
142 (
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2,
145 p_chr_id IN NUMBER,
146 x_valid_payments OUT NOCOPY VARCHAR2,
147 x_default_payment OUT NOCOPY VARCHAR2,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER
151 );
152
153 PROCEDURE process_credit_card
154 (
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2,
157 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158 p_order_id IN NUMBER,
159 p_party_id IN NUMBER,
160 p_cust_account_id IN NUMBER,
161 p_card_number IN VARCHAR2 DEFAULT NULL,
162 p_expiration_date IN DATE DEFAULT NULL,
163 p_billing_address_id IN NUMBER DEFAULT NULL,
164 p_cvv_code IN VARCHAR2 DEFAULT NULL,
165 p_instr_assignment_id IN NUMBER DEFAULT NULL,
166 p_old_txn_entension_id IN NUMBER DEFAULT NULL,
167 x_new_txn_entension_id OUT NOCOPY NUMBER,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER
171 );
172
173 PROCEDURE get_contract_salesrep_details
174 (
175 p_chr_id IN NUMBER,
176 x_salesrep_email OUT NOCOPY VARCHAR2,
177 x_salesrep_username OUT NOCOPY VARCHAR2,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER
181 );
182
183 PROCEDURE delete_transaction_extension
184 (
185 p_chr_id IN NUMBER,
186 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER
190 );
191
192 END OKS_CUSTOMER_ACCEPTANCE_PVT;