[Home] [Help]
PACKAGE: APPS.OKL_LEASEAPP_TEMPLATE_PVT
Source
1 PACKAGE OKL_LEASEAPP_TEMPLATE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRLATS.pls 120.1 2005/11/23 11:17:32 viselvar noship $ */
3
4 SUBTYPE latv_rec_type IS OKL_LAT_PVT.latv_rec_type;
5 SUBTYPE lavv_rec_type IS OKL_LAV_PVT.lavv_rec_type;
6 TYPE error_msg_rec IS RECORD (
7 error_message VARCHAR2(2500) DEFAULT OKL_API.G_MISS_CHAR
8 ,error_type_code VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR
9 ,error_type_meaning VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR);
10 TYPE error_msgs_tbl_type IS TABLE OF error_msg_rec
11 INDEX BY BINARY_INTEGER;
12 ---------------------------------------------------------------------------
13 -- GLOBAL EXCEPTIONS
14 ---------------------------------------------------------------------------
15 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
16 ---------------------------------------------------------------------------
17 -- GLOBAL VARIABLES
18 ---------------------------------------------------------------------------
19 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LEASEAPP_TEMPLATE_PVT';
20 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
21 G_API_TYPE CONSTANT VARCHAR2(30) := '_PVT';
22 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
23 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
24 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
25 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
26 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
27 G_INIT_VERSION CONSTANT NUMBER := 1.0;
28 G_INIT_TMPLT_STATUS CONSTANT VARCHAR2(100) := 'NEW';
29 G_STATUS_ACTIVE CONSTANT VARCHAR2(30) := 'ACTIVE';
30 G_STATUS_UNDERREVISION CONSTANT VARCHAR2(30) := 'UNDEREVISION';
31 G_STATUS_SUBMITTEDFORAPPROVAL CONSTANT VARCHAR2(30) := 'SUBFORAPPROVED';
32 G_STATUS_INVALID CONSTANT VARCHAR2(30) := 'INVALID';
33 G_STATUS_REJECTED CONSTANT VARCHAR2(30) := 'REJECTED';
34 G_DEFAULT_MODE CONSTANT VARCHAR2(10) := 'DUPLICATE';
35 G_TYPE_ERROR CONSTANT VARCHAR2(12) := 'E';
36 G_TYPE_WARNING CONSTANT VARCHAR2(12) := 'W';
37 G_CP_SET_OUTCOME CONSTANT VARCHAR2(30) := 'CP_SET_OUTCOME';
38 G_TEMPLATE_NUMBER CONSTANT VARCHAR2(30) := 'TEMPLATE_NUMBER';
39 G_OKL_VAL_CHECKLIST_TEMPLATE CONSTANT VARCHAR2(30) := 'OKL_VAL_CHECKLIST_TEMPLATE';
40 G_OKL_VAL_CONTRACT_TEMPLATE CONSTANT VARCHAR2(30) := 'OKL_VAL_CONTRACT_TEMPLATE';
41
42 PROCEDURE create_leaseapp_template(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_latv_rec IN latv_rec_type,
49 x_latv_rec OUT NOCOPY latv_rec_type,
50 p_lavv_rec IN lavv_rec_type,
51 x_lavv_rec OUT NOCOPY lavv_rec_type);
52
53 PROCEDURE update_leaseapp_template(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_latv_rec IN latv_rec_type,
60 x_latv_rec OUT NOCOPY latv_rec_type,
61 p_lavv_rec IN lavv_rec_type,
62 x_lavv_rec OUT NOCOPY lavv_rec_type,
63 p_ident_flag IN VARCHAR2);
64
65 PROCEDURE version_duplicate_lseapp_tmpl(
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_latv_rec IN latv_rec_type,
72 x_latv_rec OUT NOCOPY latv_rec_type,
73 p_lavv_rec IN lavv_rec_type,
74 x_lavv_rec OUT NOCOPY lavv_rec_type,
75 p_mode IN VARCHAR2);
76
77 PROCEDURE validate_lease_app_template(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_latv_rec IN latv_rec_type,
84 x_latv_rec OUT NOCOPY latv_rec_type,
85 p_lavv_rec IN lavv_rec_type,
86 x_lavv_rec OUT NOCOPY lavv_rec_type,
87 p_during_upd_flag IN VARCHAR2,
88 x_error_msgs_tbl OUT NOCOPY error_msgs_tbl_type);
89
90 PROCEDURE max_valid_from_date(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_latv_rec IN latv_rec_type,
97 x_latv_rec OUT NOCOPY latv_rec_type);
98
99 -- Bug#4741121 - smadhava - Added - Start
100 -- Start of comments
101 --
102 -- Procedure Name : activate_lat
103 -- Description : Procedure to change the status of LAT once the workflow is approved
104 -- Business Rules : The LAT version and header statuses are moved to ACTIVE.
105 -- Parameters :
106 -- Version : 1.0
107 -- End of comments
108
109 PROCEDURE activate_lat (p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_lat_version_id IN NUMBER);
115 -- Bug#4741121 - smadhava - Added - End
116 END OKL_LEASEAPP_TEMPLATE_PVT;