[Home] [Help]
PACKAGE: APPS.OKL_LAT_PVT
Source
1 PACKAGE OKL_LAT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSLATS.pls 120.2 2006/04/13 10:45:39 pagarg noship $ */
3
4 --------------------
5 -- PACKAGE CONSTANTS
6 --------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_LAT_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(30) := OKL_API.G_APP_NAME;
9 G_API_VERSION CONSTANT NUMBER := 1;
10 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
11 G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
12 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
13 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
15 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
16 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17 G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
18 G_COL_ERROR CONSTANT VARCHAR2(30) := 'OKL_COL_ERROR';
19 G_OVN_ERROR CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR';
20 G_OVN_ERROR2 CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR2';
21 G_OVN_ERROR3 CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR3';
22 G_PKG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PKG_NAME';
23 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PROG_NAME';
24 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := 'COL_NAME';
25 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLCODE';
26 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLERRM';
27
28 ------------------
29 -- DATA STRUCTURES
30 ------------------
31
32 -- Do not include WHO columns in the base table record structure
33 TYPE lat_rec_type IS RECORD (
34 id okl_leaseapp_templates.id%TYPE
35 ,object_version_number okl_leaseapp_templates.object_version_number%TYPE
36 ,attribute_category okl_leaseapp_templates.attribute_category%TYPE
37 ,attribute1 okl_leaseapp_templates.attribute1%TYPE
38 ,attribute2 okl_leaseapp_templates.attribute2%TYPE
39 ,attribute3 okl_leaseapp_templates.attribute3%TYPE
40 ,attribute4 okl_leaseapp_templates.attribute4%TYPE
41 ,attribute5 okl_leaseapp_templates.attribute5%TYPE
42 ,attribute6 okl_leaseapp_templates.attribute6%TYPE
43 ,attribute7 okl_leaseapp_templates.attribute7%TYPE
44 ,attribute8 okl_leaseapp_templates.attribute8%TYPE
45 ,attribute9 okl_leaseapp_templates.attribute9%TYPE
46 ,attribute10 okl_leaseapp_templates.attribute10%TYPE
47 ,attribute11 okl_leaseapp_templates.attribute11%TYPE
48 ,attribute12 okl_leaseapp_templates.attribute12%TYPE
49 ,attribute13 okl_leaseapp_templates.attribute13%TYPE
50 ,attribute14 okl_leaseapp_templates.attribute14%TYPE
51 ,attribute15 okl_leaseapp_templates.attribute15%TYPE
52 ,org_id okl_leaseapp_templates.org_id%TYPE
53 ,name okl_leaseapp_templates.name%TYPE
54 ,template_status okl_leaseapp_templates.template_status%TYPE
55 ,credit_review_purpose okl_leaseapp_templates.credit_review_purpose%TYPE
56 ,cust_credit_classification okl_leaseapp_templates.cust_credit_classification%TYPE
57 ,industry_class okl_leaseapp_templates.industry_class%TYPE
58 ,industry_code okl_leaseapp_templates.industry_code%TYPE
59 ,valid_from okl_leaseapp_templates.valid_from%TYPE
60 ,valid_to okl_leaseapp_templates.valid_to%TYPE
61 );
62
63 -- view record structure
64 TYPE latv_rec_type IS RECORD (
65 id okl_leaseapp_templates.id%TYPE
66 ,object_version_number okl_leaseapp_templates.object_version_number%TYPE
67 ,attribute_category okl_leaseapp_templates.attribute_category%TYPE
68 ,attribute1 okl_leaseapp_templates.attribute1%TYPE
69 ,attribute2 okl_leaseapp_templates.attribute2%TYPE
70 ,attribute3 okl_leaseapp_templates.attribute3%TYPE
71 ,attribute4 okl_leaseapp_templates.attribute4%TYPE
72 ,attribute5 okl_leaseapp_templates.attribute5%TYPE
73 ,attribute6 okl_leaseapp_templates.attribute6%TYPE
74 ,attribute7 okl_leaseapp_templates.attribute7%TYPE
75 ,attribute8 okl_leaseapp_templates.attribute8%TYPE
76 ,attribute9 okl_leaseapp_templates.attribute9%TYPE
77 ,attribute10 okl_leaseapp_templates.attribute10%TYPE
78 ,attribute11 okl_leaseapp_templates.attribute11%TYPE
79 ,attribute12 okl_leaseapp_templates.attribute12%TYPE
80 ,attribute13 okl_leaseapp_templates.attribute13%TYPE
81 ,attribute14 okl_leaseapp_templates.attribute14%TYPE
82 ,attribute15 okl_leaseapp_templates.attribute15%TYPE
83 ,org_id okl_leaseapp_templates.org_id%TYPE
84 ,name okl_leaseapp_templates.name%TYPE
85 ,template_status okl_leaseapp_templates.template_status%TYPE
86 ,credit_review_purpose okl_leaseapp_templates.credit_review_purpose%TYPE
87 ,cust_credit_classification okl_leaseapp_templates.cust_credit_classification%TYPE
88 ,industry_class okl_leaseapp_templates.industry_class%TYPE
89 ,industry_code okl_leaseapp_templates.industry_code%TYPE
90 ,valid_from okl_leaseapp_templates.valid_from%TYPE
91 ,valid_to okl_leaseapp_templates.valid_to%TYPE
92 );
93
94 TYPE latv_tbl_type IS TABLE OF latv_rec_type INDEX BY BINARY_INTEGER;
95
96 ----------------
97 -- PROGRAM UNITS
98 ----------------
99
100 PROCEDURE insert_row(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_latv_tbl IN latv_tbl_type,
107 x_latv_tbl OUT NOCOPY latv_tbl_type);
108
109 PROCEDURE update_row(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_latv_tbl IN latv_tbl_type,
116 x_latv_tbl OUT NOCOPY latv_tbl_type);
117
118 PROCEDURE delete_row(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_latv_tbl IN latv_tbl_type);
125
126 PROCEDURE insert_row(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_latv_rec IN latv_rec_type,
133 x_latv_rec OUT NOCOPY latv_rec_type);
134
135 PROCEDURE update_row(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_latv_rec IN latv_rec_type,
142 x_latv_rec OUT NOCOPY latv_rec_type);
143
144 PROCEDURE delete_row(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_latv_rec IN latv_rec_type);
151
152 FUNCTION get_rec (
153 p_id IN NUMBER,
154 x_return_status OUT NOCOPY VARCHAR2)
155 RETURN latv_rec_type;
156
157 END OKL_LAT_PVT;