[Home] [Help]
PACKAGE: APPS.OKL_CONTRACT_STATUS_PUB
Source
1 Package OKL_CONTRACT_STATUS_PUB AUTHID CURRENT_USER as
2 /* $Header: OKLPSTKS.pls 120.4 2008/02/29 10:52:57 nikshah ship $ */
3 /*#
4 * Contract Status API allows users to get the status of a
5 * lease contract.
6 * @rep:scope public
7 * @rep:product OKL
8 * @rep:displayname Get Contract Status API
9 * @rep:category BUSINESS_ENTITY OKL_CONTRACT_LIFECYCLE
10 * @rep:lifecycle active
11 * @rep:compatibility S
12 */
13
14
15 -- Global variables for user hooks
16 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_STATUS_PUB';
17 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
18
19 -- Global error messages
20 G_CANNOT_GENSTRMS CONSTANT VARCHAR2(200) := 'OKL_LLA_CTGEN_STRMS';
21 G_STRMS_IN_PROGRESS CONSTANT VARCHAR2(200) := 'OKL_LLA_STRMS_PRGRS';
22 G_GENSTRMS_REQ_FAILED CONSTANT VARCHAR2(200) := 'OKL_LLA_STRMS_REQ_FLD';
23 G_NO_ACTV_TMPCONTRACT CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_ACTV_TMPCONTRACT';
24 G_CANNOT_GENJRNL CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_CTGEN_JRNLS';
25 G_NOT_APPROVED CONSTANT VARCHAR2(200) := 'OKL_LLA_NOT_APPROVED';
26 G_NOT_COMPLETE CONSTANT VARCHAR2(200) := 'OKL_LLA_NOT_COMPLETE';
27 G_NOT_VALIDATE CONSTANT VARCHAR2(200) := 'OKL_LLA_NOT_VALIDATE';
28
29 -- Contract actions
30 G_K_NEW CONSTANT VARCHAR2(60) := 'NEW';
31 G_K_EDIT CONSTANT VARCHAR2(60) := 'EDIT';
32 G_K_QACHECK CONSTANT VARCHAR2(60) := 'QA_CHECK';
33 G_K_STRMGEN CONSTANT VARCHAR2(60) := 'STRMGEN';
34 G_K_JOURNAL CONSTANT VARCHAR2(60) := 'JOURNAL';
35 G_K_SUBMIT4APPRVL CONSTANT VARCHAR2(60) := 'SUBMIT_FOR_APPROVAL';
36 G_K_APPROVAL CONSTANT VARCHAR2(60) := 'APPROVAL';
37 G_K_ACTIVATE CONSTANT VARCHAR2(60) := 'ACTIVATE';
38
39 G_K_NOT_ALLOWED CONSTANT VARCHAR2(100) := 'G_K_NOT_ALLOWED';
40
41 /*#
42 * Get contract status.
43 * @param p_api_version API version
44 * @param p_init_msg_list Initialize message stack
45 * @param x_return_status Return status from the API
46 * @param x_msg_count Message count if error messages are encountered
47 * @param x_msg_data Error message data
48 * @param x_isAllowed True or False indicates whether event is allowed
49 * @param x_PassStatus Passed status
50 * @param x_FailStatus Failed status
51 * @param p_event Event name
52 * @param p_chr_id Contract identifier
53 * @rep:displayname Get Contract Status
54 * @rep:scope public
55 * @rep:lifecycle active
56 */
57 Procedure get_contract_status(
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 x_isAllowed OUT NOCOPY BOOLEAN,
64 x_PassStatus OUT NOCOPY VARCHAR2,
65 x_FailStatus OUT NOCOPY VARCHAR2,
66 p_event IN VARCHAR2,
67 p_chr_id IN VARCHAR2);
68
69 Procedure update_contract_status(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_khr_status IN VARCHAR2,
76 p_chr_id IN VARCHAR2);
77
78 Procedure cascade_lease_status
79 (p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_chr_id IN NUMBER);
85
86 Procedure cascade_lease_status_edit
87 (p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_chr_id IN NUMBER);
93 End OKL_CONTRACT_STATUS_PUB;