[Home] [Help]
PACKAGE: APPS.OKL_LRE_PVT
Source
1 PACKAGE OKL_LRE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSLRES.pls 120.0.12020000.2 2012/08/07 12:18:39 vsgandhi ship $ */
3
4 --------------------
5 -- PACKAGE CONSTANTS
6 --------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_LRE_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 lre_rec_type IS RECORD (
34 id okl_line_relationships_b.id%TYPE
35 ,object_version_number okl_line_relationships_b.object_version_number%TYPE
36 ,attribute_category okl_line_relationships_b.attribute_category%TYPE
37 ,attribute1 okl_line_relationships_b.attribute1%TYPE
38 ,attribute2 okl_line_relationships_b.attribute2%TYPE
39 ,attribute3 okl_line_relationships_b.attribute3%TYPE
40 ,attribute4 okl_line_relationships_b.attribute4%TYPE
41 ,attribute5 okl_line_relationships_b.attribute5%TYPE
42 ,attribute6 okl_line_relationships_b.attribute6%TYPE
43 ,attribute7 okl_line_relationships_b.attribute7%TYPE
44 ,attribute8 okl_line_relationships_b.attribute8%TYPE
45 ,attribute9 okl_line_relationships_b.attribute9%TYPE
46 ,attribute10 okl_line_relationships_b.attribute10%TYPE
47 ,attribute11 okl_line_relationships_b.attribute11%TYPE
48 ,attribute12 okl_line_relationships_b.attribute12%TYPE
49 ,attribute13 okl_line_relationships_b.attribute13%TYPE
50 ,attribute14 okl_line_relationships_b.attribute14%TYPE
51 ,attribute15 okl_line_relationships_b.attribute15%TYPE
52 ,source_line_type okl_line_relationships_b.source_line_type%TYPE
53 ,source_line_id okl_line_relationships_b.source_line_id%TYPE
54 ,related_line_type okl_line_relationships_b.related_line_type%TYPE
55 ,related_line_id okl_line_relationships_b.related_line_id%TYPE
56 ,amount okl_line_relationships_b.amount%TYPE
57 --Added by jjuneja
58 ,origination_income okl_line_relationships_b.origination_income%TYPE
59 --End of addition by jjuneja
60
61 );
62
63 -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
64 TYPE lretl_rec_type IS RECORD (
65 id okl_line_relationships_tl.id%TYPE
66 ,short_description okl_line_relationships_tl.short_description%TYPE
67 ,description okl_line_relationships_tl.description%TYPE
68 ,comments okl_line_relationships_tl.comments%TYPE
69 );
70
71 -- view record structure
72 TYPE lrev_rec_type IS RECORD (
73 id okl_line_relationships_b.id%TYPE
74 ,object_version_number okl_line_relationships_b.object_version_number%TYPE
75 ,attribute_category okl_line_relationships_b.attribute_category%TYPE
76 ,attribute1 okl_line_relationships_b.attribute1%TYPE
77 ,attribute2 okl_line_relationships_b.attribute2%TYPE
78 ,attribute3 okl_line_relationships_b.attribute3%TYPE
79 ,attribute4 okl_line_relationships_b.attribute4%TYPE
80 ,attribute5 okl_line_relationships_b.attribute5%TYPE
81 ,attribute6 okl_line_relationships_b.attribute6%TYPE
82 ,attribute7 okl_line_relationships_b.attribute7%TYPE
83 ,attribute8 okl_line_relationships_b.attribute8%TYPE
84 ,attribute9 okl_line_relationships_b.attribute9%TYPE
85 ,attribute10 okl_line_relationships_b.attribute10%TYPE
86 ,attribute11 okl_line_relationships_b.attribute11%TYPE
87 ,attribute12 okl_line_relationships_b.attribute12%TYPE
88 ,attribute13 okl_line_relationships_b.attribute13%TYPE
89 ,attribute14 okl_line_relationships_b.attribute14%TYPE
90 ,attribute15 okl_line_relationships_b.attribute15%TYPE
91 ,source_line_type okl_line_relationships_b.source_line_type%TYPE
92 ,source_line_id okl_line_relationships_b.source_line_id%TYPE
93 ,related_line_type okl_line_relationships_b.related_line_type%TYPE
94 ,related_line_id okl_line_relationships_b.related_line_id%TYPE
95 ,amount okl_line_relationships_b.amount%TYPE
96 ,short_description okl_line_relationships_tl.short_description%TYPE
97 ,description okl_line_relationships_tl.description%TYPE
98 ,comments okl_line_relationships_tl.comments%TYPE
99 --added by jjuneja
100 ,origination_income okl_line_relationships_b.origination_income%TYPE
101 --end of addition by jjuenja
102
103 );
104
105 TYPE lrev_tbl_type IS TABLE OF lrev_rec_type INDEX BY BINARY_INTEGER;
106
107 ----------------
108 -- PROGRAM UNITS
109 ----------------
110 PROCEDURE add_language;
111
112 PROCEDURE insert_row(
113 p_api_version IN NUMBER
114 ,p_init_msg_list IN VARCHAR2
115 ,x_return_status OUT NOCOPY VARCHAR2
116 ,x_msg_count OUT NOCOPY NUMBER
117 ,x_msg_data OUT NOCOPY VARCHAR2
118 ,p_lrev_tbl IN lrev_tbl_type
119 ,x_lrev_tbl OUT NOCOPY lrev_tbl_type);
120
121 PROCEDURE update_row(
122 p_api_version IN NUMBER
123 ,p_init_msg_list IN VARCHAR2
124 ,x_return_status OUT NOCOPY VARCHAR2
125 ,x_msg_count OUT NOCOPY NUMBER
126 ,x_msg_data OUT NOCOPY VARCHAR2
127 ,p_lrev_tbl IN lrev_tbl_type
128 ,x_lrev_tbl OUT NOCOPY lrev_tbl_type);
129
130 PROCEDURE delete_row(
131 p_api_version IN NUMBER
132 ,p_init_msg_list IN VARCHAR2
133 ,x_return_status OUT NOCOPY VARCHAR2
134 ,x_msg_count OUT NOCOPY NUMBER
135 ,x_msg_data OUT NOCOPY VARCHAR2
136 ,p_lrev_tbl IN lrev_tbl_type);
137
138 PROCEDURE insert_row(
139 p_api_version IN NUMBER
140 ,p_init_msg_list IN VARCHAR2
141 ,x_return_status OUT NOCOPY VARCHAR2
142 ,x_msg_count OUT NOCOPY NUMBER
143 ,x_msg_data OUT NOCOPY VARCHAR2
144 ,p_lrev_rec IN lrev_rec_type
145 ,x_lrev_rec OUT NOCOPY lrev_rec_type);
146
147 PROCEDURE update_row(
148 p_api_version IN NUMBER
149 ,p_init_msg_list IN VARCHAR2
150 ,x_return_status OUT NOCOPY VARCHAR2
151 ,x_msg_count OUT NOCOPY NUMBER
152 ,x_msg_data OUT NOCOPY VARCHAR2
153 ,p_lrev_rec IN lrev_rec_type
154 ,x_lrev_rec OUT NOCOPY lrev_rec_type);
155
156 PROCEDURE delete_row(
157 p_api_version IN NUMBER
158 ,p_init_msg_list IN VARCHAR2
159 ,x_return_status OUT NOCOPY VARCHAR2
160 ,x_msg_count OUT NOCOPY NUMBER
161 ,x_msg_data OUT NOCOPY VARCHAR2
162 ,p_lrev_rec IN lrev_rec_type);
163
164 END OKL_LRE_PVT;