1 PACKAGE ar_custom_contract_api AS
2 /* $Header: ARXRMCCS.pls 120.2 2005/10/30 03:59:48 appldev noship $ */
3
4
5 /*========================================================================
6 | PUBLIC FUNCTION implemented_third_party
7 |
8 | DESCRIPTION
9 | This is the function to determine if theird party contract system
10 | has been implented and you wish to use feed this data to the
11 | Revenue Mangement Engine.
12 |
13 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
14 | Revenue Managment Engine.
15 |
16 | MODIFICATION HISTORY
17 | Date Author Description of Changes
18 | 07-MAR-2003 Obaidur Rashid Created
19 |
20 *=======================================================================*/
21
22 FUNCTION implemented_third_party
23 RETURN BOOLEAN;
24
25
26 /*========================================================================
27 | PUBLIC PROCEDURE retrieve_contract
28 |
29 | DESCRIPTION
30 | If you have a third party contract solution, and you want to
31 | retrieve data from that system and integrate with Oracle's
32 | revenue management solution, you must write code in this routine
33 | populate the OUT parameters appropriately so that Revenue Management
34 | Engine can take these into consideration.
35 |
36 | CALLED FROM PROCEDURES/FUNCTIONS
37 | Called by Revenue Management Engine.
38 |
39 | PARAMETERS
40 | p_customer_trx_id IN NUMBER Invoice ID
41 | p_customer_trx_line_id IN NUMBER Invoice Line ID
42 | p_sales_order IN NUMBER Sales Order Number (NOT ID)
43 | p_sales_order_line_id IN VARCHAR2 Sales Order Line ID
44 |
45 | NOTES
46 |
47 | MODIFICATION HISTORY
48 | Date Author Description of Changes
49 | DD-MON-YYYY Obaidur Rashid Created
50 |
51 *=======================================================================*/
52
53 PROCEDURE retrieve_contract_info (
54 p_customer_trx_id IN NUMBER,
55 p_customer_trx_line_id IN NUMBER,
56 p_sales_order IN NUMBER,
57 p_sales_order_line_id IN VARCHAR2,
58 p_transaction_date IN DATE,
59 x_contract_id OUT NOCOPY VARCHAR2,
60 x_contract_line_id OUT NOCOPY VARCHAR2,
61 x_acceptance_clause OUT NOCOPY VARCHAR2,
62 x_acceptance_expiry OUT NOCOPY DATE,
63 x_refund_clause OUT NOCOPY VARCHAR2,
64 x_refund_expiry OUT NOCOPY DATE,
65 x_cancellation_clause OUT NOCOPY VARCHAR2,
66 x_cancellation_expiry OUT NOCOPY DATE,
67 x_forfeiture_clause OUT NOCOPY VARCHAR2,
68 x_forfeiture_expiry OUT NOCOPY DATE,
69 x_fiscal_funding_clause OUT NOCOPY VARCHAR2,
70 x_fiscal_expiry OUT NOCOPY DATE);
71
72 END ar_custom_contract_api;