1 PACKAGE OKS_RENEW_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPRUTS.pls 120.3 2005/07/22 11:53:22 anjkumar noship $*/
3
4 SUBTYPE Rnrl_rec_type IS OKS_RENEW_UTIL_PVT.Rnrl_rec_type;
5
6 ---------------------------------------------------------------------------
7 -- GLOBAL MESSAGES
8 ---------------------------------------------------------------------------
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKS_RENEW_UTIL_UNEXP_ERR';
10 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLcode';
11 G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := OKC_API.G_REQUIRED_VALUE;
12 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLerrm';
13 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;
14 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
15 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16
17 ---------------------------------------------------------------------------
18 -- GLOBAL EXCEPTIONS
19 ---------------------------------------------------------------------------
20 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
21 ---------------------------------------------------------------------------
22 -- GLOBAL VARIABLES
23 ---------------------------------------------------------------------------
24 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKS_RENEW_UTIL_PUB';
25 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
26 G_OKS_APP_NAME CONSTANT VARCHAR2(3) := 'OKS'; --all new nessages should use this
27
28 G_RNRL_REC Rnrl_rec_type;
29
30 PROCEDURE GET_RENEW_RULES(p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 P_Chr_Id IN NUMBER,
36 P_PARTY_ID IN NUMBER,
37 P_ORG_ID IN NUMBER,
38 P_Date IN DATE DEFAULT SYSDATE,
39 P_RNRL_Rec IN RNRL_REC_TYPE,
40 X_RNRL_Rec OUT NOCOPY RNRL_REC_TYPE);
41
42 PROCEDURE UPDATE_RENEWAL_STATUS (p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 P_CHR_ID IN NUMBER,
48 P_RENEW_STATUS IN VARCHAR2,
49 P_CHR_STATUS IN VARCHAR2);
50
51 PROCEDURE Can_Update_Contract(p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2,
53 p_chr_id IN NUMBER,
54 x_can_update_yn OUT NOCOPY VARCHAR2,
55 x_can_submit_yn OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 x_return_status OUT NOCOPY VARCHAR2);
59
60 -- New API to get payment terms from Global defaults
61 -- ER 2532872
62 PROCEDURE get_payment_terms (
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2,
65 p_chr_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66 p_party_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
67 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
68 p_effective_date IN DATE DEFAULT SYSDATE,
69 x_pay_term_id1 OUT NOCOPY VARCHAR2,
70 x_pay_term_id2 OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 x_return_status OUT NOCOPY VARCHAR2);
74
75 PROCEDURE get_period_defaults(p_hdr_id IN NUMBER DEFAULT NULL,
76 p_org_id IN VARCHAR2 DEFAULT NULL,
77 x_period_type OUT NOCOPY VARCHAR2,
78 x_period_start OUT NOCOPY VARCHAR2,
79 x_price_uom OUT NOCOPY VARCHAR2,
80 x_return_status OUT NOCOPY VARCHAR2);
81
82 /* stripped down version of get_renew_rules, only gets the template set id and template lang */
83 PROCEDURE get_template_set(p_api_version IN NUMBER DEFAULT 1,
84 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85 p_chr_id IN NUMBER,
86 x_template_set_id OUT NOCOPY NUMBER,
87 x_template_lang OUT NOCOPY VARCHAR2,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2);
91
92 /* utility function to get template set id */
93 FUNCTION get_template_set_id(p_chr_id IN NUMBER
94 ) RETURN NUMBER;
95
96 /* utility function to get template set lang */
97 FUNCTION get_template_lang(p_chr_id IN NUMBER
98 ) RETURN VARCHAR2;
99
100 /*
101 Procedure evaluates the renewal rules setup in Contract or GCD to determine
102 the effective renewal type for a contract.
103
104 Parameters
105 p_chr_id : id of the contract whose renewal type needs to be determined, mandatory
106 p_amount : contract amount, optional, if not passed derived from p_chr_id
107 p_currency_code : contract currency, optional, if not passed derived from p_chr_id
108 p_rnrl_rec : record containing the effective renewal rules for the contract,
109 optional, if not populated, derived from p_chr_id
110 x_renewal_type : renewal type as determined
111 x_approval_type : approval type associated with the renewal type
112 x_threshold_used : Y|N indicating if GCD threshold where used to determine the renewal type
113 */
114 PROCEDURE GET_RENEWAL_TYPE
115 (
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_chr_id IN NUMBER,
122 p_amount IN NUMBER DEFAULT NULL,
123 p_currency_code IN VARCHAR2 DEFAULT NULL,
124 p_rnrl_rec IN rnrl_rec_type DEFAULT NULL,
125 x_renewal_type OUT NOCOPY VARCHAR2,
126 x_approval_type OUT NOCOPY VARCHAR2,
127 x_threshold_used OUT NOCOPY VARCHAR2
128 );
129
130 END OKS_RENEW_UTIL_PUB;