eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_SCS_PVT dependencies on OKC_SUBCLASSES_TL

Line 42: DELETE FROM OKC_SUBCLASSES_TL T

38: -- PROCEDURE add_language
39: ---------------------------------------------------------------------------
40: PROCEDURE add_language IS
41: BEGIN
42: DELETE FROM OKC_SUBCLASSES_TL T
43: WHERE NOT EXISTS (
44: SELECT NULL
45: FROM OKC_SUBCLASSES_B B
46: WHERE B.CODE = T.CODE

Line 49: UPDATE OKC_SUBCLASSES_TL T SET (

45: FROM OKC_SUBCLASSES_B B
46: WHERE B.CODE = T.CODE
47: );
48:
49: UPDATE OKC_SUBCLASSES_TL T SET (
50: MEANING,
51: DESCRIPTION) = (SELECT
52: B.MEANING,
53: B.DESCRIPTION

Line 54: FROM OKC_SUBCLASSES_TL B

50: MEANING,
51: DESCRIPTION) = (SELECT
52: B.MEANING,
53: B.DESCRIPTION
54: FROM OKC_SUBCLASSES_TL B
55: WHERE B.CODE = T.CODE
56: AND B.LANGUAGE = T.SOURCE_LANG)
57: WHERE (
58: T.CODE,

Line 63: FROM OKC_SUBCLASSES_TL SUBB, OKC_SUBCLASSES_TL SUBT

59: T.LANGUAGE)
60: IN (SELECT
61: SUBT.CODE,
62: SUBT.LANGUAGE
63: FROM OKC_SUBCLASSES_TL SUBB, OKC_SUBCLASSES_TL SUBT
64: WHERE SUBB.CODE = SUBT.CODE
65: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
66: AND (SUBB.MEANING <> SUBT.MEANING
67: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 72: INSERT INTO OKC_SUBCLASSES_TL (

68: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
69: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
70: ));
71:
72: INSERT INTO OKC_SUBCLASSES_TL (
73: CODE,
74: LANGUAGE,
75: SOURCE_LANG,
76: SFWT_FLAG,

Line 96: FROM OKC_SUBCLASSES_TL B, FND_LANGUAGES L

92: B.CREATION_DATE,
93: B.LAST_UPDATED_BY,
94: B.LAST_UPDATE_DATE,
95: B.LAST_UPDATE_LOGIN
96: FROM OKC_SUBCLASSES_TL B, FND_LANGUAGES L
97: WHERE L.INSTALLED_FLAG IN ('I', 'B')
98: AND B.LANGUAGE = USERENV('LANG')
99: AND NOT EXISTS(
100: SELECT NULL

Line 101: FROM OKC_SUBCLASSES_TL T

97: WHERE L.INSTALLED_FLAG IN ('I', 'B')
98: AND B.LANGUAGE = USERENV('LANG')
99: AND NOT EXISTS(
100: SELECT NULL
101: FROM OKC_SUBCLASSES_TL T
102: WHERE T.CODE = B.CODE
103: AND T.LANGUAGE = L.LANGUAGE_CODE
104: );
105:

Line 163: -- FUNCTION get_rec for: OKC_SUBCLASSES_TL

159: BEGIN
160: RETURN(get_rec(p_scs_rec, l_row_notfound));
161: END get_rec;
162: ---------------------------------------------------------------------------
163: -- FUNCTION get_rec for: OKC_SUBCLASSES_TL
164: ---------------------------------------------------------------------------
165: FUNCTION get_rec (
166: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
167: x_no_data_found OUT NOCOPY BOOLEAN

Line 166: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,

162: ---------------------------------------------------------------------------
163: -- FUNCTION get_rec for: OKC_SUBCLASSES_TL
164: ---------------------------------------------------------------------------
165: FUNCTION get_rec (
166: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
167: x_no_data_found OUT NOCOPY BOOLEAN
168: ) RETURN okc_subclasses_tl_rec_type IS
169: CURSOR scs_pktl_csr (p_code IN VARCHAR2,
170: p_language IN VARCHAR2) IS

Line 168: ) RETURN okc_subclasses_tl_rec_type IS

164: ---------------------------------------------------------------------------
165: FUNCTION get_rec (
166: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
167: x_no_data_found OUT NOCOPY BOOLEAN
168: ) RETURN okc_subclasses_tl_rec_type IS
169: CURSOR scs_pktl_csr (p_code IN VARCHAR2,
170: p_language IN VARCHAR2) IS
171: SELECT
172: CODE,

Line 183: FROM Okc_Subclasses_Tl

179: CREATION_DATE,
180: LAST_UPDATED_BY,
181: LAST_UPDATE_DATE,
182: LAST_UPDATE_LOGIN
183: FROM Okc_Subclasses_Tl
184: WHERE okc_subclasses_tl.code = p_code
185: AND okc_subclasses_tl.language = p_language;
186: l_scs_pktl scs_pktl_csr%ROWTYPE;
187: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

Line 184: WHERE okc_subclasses_tl.code = p_code

180: LAST_UPDATED_BY,
181: LAST_UPDATE_DATE,
182: LAST_UPDATE_LOGIN
183: FROM Okc_Subclasses_Tl
184: WHERE okc_subclasses_tl.code = p_code
185: AND okc_subclasses_tl.language = p_language;
186: l_scs_pktl scs_pktl_csr%ROWTYPE;
187: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
188: BEGIN

Line 185: AND okc_subclasses_tl.language = p_language;

181: LAST_UPDATE_DATE,
182: LAST_UPDATE_LOGIN
183: FROM Okc_Subclasses_Tl
184: WHERE okc_subclasses_tl.code = p_code
185: AND okc_subclasses_tl.language = p_language;
186: l_scs_pktl scs_pktl_csr%ROWTYPE;
187: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
188: BEGIN
189: x_no_data_found := TRUE;

Line 187: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

183: FROM Okc_Subclasses_Tl
184: WHERE okc_subclasses_tl.code = p_code
185: AND okc_subclasses_tl.language = p_language;
186: l_scs_pktl scs_pktl_csr%ROWTYPE;
187: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
188: BEGIN
189: x_no_data_found := TRUE;
190: -- Get current database values
191: OPEN scs_pktl_csr (p_okc_subclasses_tl_rec.code,

Line 191: OPEN scs_pktl_csr (p_okc_subclasses_tl_rec.code,

187: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
188: BEGIN
189: x_no_data_found := TRUE;
190: -- Get current database values
191: OPEN scs_pktl_csr (p_okc_subclasses_tl_rec.code,
192: p_okc_subclasses_tl_rec.language);
193: FETCH scs_pktl_csr INTO
194: l_okc_subclasses_tl_rec.CODE,
195: l_okc_subclasses_tl_rec.LANGUAGE,

Line 192: p_okc_subclasses_tl_rec.language);

188: BEGIN
189: x_no_data_found := TRUE;
190: -- Get current database values
191: OPEN scs_pktl_csr (p_okc_subclasses_tl_rec.code,
192: p_okc_subclasses_tl_rec.language);
193: FETCH scs_pktl_csr INTO
194: l_okc_subclasses_tl_rec.CODE,
195: l_okc_subclasses_tl_rec.LANGUAGE,
196: l_okc_subclasses_tl_rec.SOURCE_LANG,

Line 194: l_okc_subclasses_tl_rec.CODE,

190: -- Get current database values
191: OPEN scs_pktl_csr (p_okc_subclasses_tl_rec.code,
192: p_okc_subclasses_tl_rec.language);
193: FETCH scs_pktl_csr INTO
194: l_okc_subclasses_tl_rec.CODE,
195: l_okc_subclasses_tl_rec.LANGUAGE,
196: l_okc_subclasses_tl_rec.SOURCE_LANG,
197: l_okc_subclasses_tl_rec.SFWT_FLAG,
198: l_okc_subclasses_tl_rec.MEANING,

Line 195: l_okc_subclasses_tl_rec.LANGUAGE,

191: OPEN scs_pktl_csr (p_okc_subclasses_tl_rec.code,
192: p_okc_subclasses_tl_rec.language);
193: FETCH scs_pktl_csr INTO
194: l_okc_subclasses_tl_rec.CODE,
195: l_okc_subclasses_tl_rec.LANGUAGE,
196: l_okc_subclasses_tl_rec.SOURCE_LANG,
197: l_okc_subclasses_tl_rec.SFWT_FLAG,
198: l_okc_subclasses_tl_rec.MEANING,
199: l_okc_subclasses_tl_rec.DESCRIPTION,

Line 196: l_okc_subclasses_tl_rec.SOURCE_LANG,

192: p_okc_subclasses_tl_rec.language);
193: FETCH scs_pktl_csr INTO
194: l_okc_subclasses_tl_rec.CODE,
195: l_okc_subclasses_tl_rec.LANGUAGE,
196: l_okc_subclasses_tl_rec.SOURCE_LANG,
197: l_okc_subclasses_tl_rec.SFWT_FLAG,
198: l_okc_subclasses_tl_rec.MEANING,
199: l_okc_subclasses_tl_rec.DESCRIPTION,
200: l_okc_subclasses_tl_rec.CREATED_BY,

Line 197: l_okc_subclasses_tl_rec.SFWT_FLAG,

193: FETCH scs_pktl_csr INTO
194: l_okc_subclasses_tl_rec.CODE,
195: l_okc_subclasses_tl_rec.LANGUAGE,
196: l_okc_subclasses_tl_rec.SOURCE_LANG,
197: l_okc_subclasses_tl_rec.SFWT_FLAG,
198: l_okc_subclasses_tl_rec.MEANING,
199: l_okc_subclasses_tl_rec.DESCRIPTION,
200: l_okc_subclasses_tl_rec.CREATED_BY,
201: l_okc_subclasses_tl_rec.CREATION_DATE,

Line 198: l_okc_subclasses_tl_rec.MEANING,

194: l_okc_subclasses_tl_rec.CODE,
195: l_okc_subclasses_tl_rec.LANGUAGE,
196: l_okc_subclasses_tl_rec.SOURCE_LANG,
197: l_okc_subclasses_tl_rec.SFWT_FLAG,
198: l_okc_subclasses_tl_rec.MEANING,
199: l_okc_subclasses_tl_rec.DESCRIPTION,
200: l_okc_subclasses_tl_rec.CREATED_BY,
201: l_okc_subclasses_tl_rec.CREATION_DATE,
202: l_okc_subclasses_tl_rec.LAST_UPDATED_BY,

Line 199: l_okc_subclasses_tl_rec.DESCRIPTION,

195: l_okc_subclasses_tl_rec.LANGUAGE,
196: l_okc_subclasses_tl_rec.SOURCE_LANG,
197: l_okc_subclasses_tl_rec.SFWT_FLAG,
198: l_okc_subclasses_tl_rec.MEANING,
199: l_okc_subclasses_tl_rec.DESCRIPTION,
200: l_okc_subclasses_tl_rec.CREATED_BY,
201: l_okc_subclasses_tl_rec.CREATION_DATE,
202: l_okc_subclasses_tl_rec.LAST_UPDATED_BY,
203: l_okc_subclasses_tl_rec.LAST_UPDATE_DATE,

Line 200: l_okc_subclasses_tl_rec.CREATED_BY,

196: l_okc_subclasses_tl_rec.SOURCE_LANG,
197: l_okc_subclasses_tl_rec.SFWT_FLAG,
198: l_okc_subclasses_tl_rec.MEANING,
199: l_okc_subclasses_tl_rec.DESCRIPTION,
200: l_okc_subclasses_tl_rec.CREATED_BY,
201: l_okc_subclasses_tl_rec.CREATION_DATE,
202: l_okc_subclasses_tl_rec.LAST_UPDATED_BY,
203: l_okc_subclasses_tl_rec.LAST_UPDATE_DATE,
204: l_okc_subclasses_tl_rec.LAST_UPDATE_LOGIN;

Line 201: l_okc_subclasses_tl_rec.CREATION_DATE,

197: l_okc_subclasses_tl_rec.SFWT_FLAG,
198: l_okc_subclasses_tl_rec.MEANING,
199: l_okc_subclasses_tl_rec.DESCRIPTION,
200: l_okc_subclasses_tl_rec.CREATED_BY,
201: l_okc_subclasses_tl_rec.CREATION_DATE,
202: l_okc_subclasses_tl_rec.LAST_UPDATED_BY,
203: l_okc_subclasses_tl_rec.LAST_UPDATE_DATE,
204: l_okc_subclasses_tl_rec.LAST_UPDATE_LOGIN;
205: x_no_data_found := scs_pktl_csr%NOTFOUND;

Line 202: l_okc_subclasses_tl_rec.LAST_UPDATED_BY,

198: l_okc_subclasses_tl_rec.MEANING,
199: l_okc_subclasses_tl_rec.DESCRIPTION,
200: l_okc_subclasses_tl_rec.CREATED_BY,
201: l_okc_subclasses_tl_rec.CREATION_DATE,
202: l_okc_subclasses_tl_rec.LAST_UPDATED_BY,
203: l_okc_subclasses_tl_rec.LAST_UPDATE_DATE,
204: l_okc_subclasses_tl_rec.LAST_UPDATE_LOGIN;
205: x_no_data_found := scs_pktl_csr%NOTFOUND;
206: CLOSE scs_pktl_csr;

Line 203: l_okc_subclasses_tl_rec.LAST_UPDATE_DATE,

199: l_okc_subclasses_tl_rec.DESCRIPTION,
200: l_okc_subclasses_tl_rec.CREATED_BY,
201: l_okc_subclasses_tl_rec.CREATION_DATE,
202: l_okc_subclasses_tl_rec.LAST_UPDATED_BY,
203: l_okc_subclasses_tl_rec.LAST_UPDATE_DATE,
204: l_okc_subclasses_tl_rec.LAST_UPDATE_LOGIN;
205: x_no_data_found := scs_pktl_csr%NOTFOUND;
206: CLOSE scs_pktl_csr;
207: RETURN(l_okc_subclasses_tl_rec);

Line 204: l_okc_subclasses_tl_rec.LAST_UPDATE_LOGIN;

200: l_okc_subclasses_tl_rec.CREATED_BY,
201: l_okc_subclasses_tl_rec.CREATION_DATE,
202: l_okc_subclasses_tl_rec.LAST_UPDATED_BY,
203: l_okc_subclasses_tl_rec.LAST_UPDATE_DATE,
204: l_okc_subclasses_tl_rec.LAST_UPDATE_LOGIN;
205: x_no_data_found := scs_pktl_csr%NOTFOUND;
206: CLOSE scs_pktl_csr;
207: RETURN(l_okc_subclasses_tl_rec);
208: END get_rec;

Line 207: RETURN(l_okc_subclasses_tl_rec);

203: l_okc_subclasses_tl_rec.LAST_UPDATE_DATE,
204: l_okc_subclasses_tl_rec.LAST_UPDATE_LOGIN;
205: x_no_data_found := scs_pktl_csr%NOTFOUND;
206: CLOSE scs_pktl_csr;
207: RETURN(l_okc_subclasses_tl_rec);
208: END get_rec;
209:
210: FUNCTION get_rec (
211: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type

Line 211: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type

207: RETURN(l_okc_subclasses_tl_rec);
208: END get_rec;
209:
210: FUNCTION get_rec (
211: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type
212: ) RETURN okc_subclasses_tl_rec_type IS
213: l_row_notfound BOOLEAN := TRUE;
214: BEGIN
215: RETURN(get_rec(p_okc_subclasses_tl_rec, l_row_notfound));

Line 212: ) RETURN okc_subclasses_tl_rec_type IS

208: END get_rec;
209:
210: FUNCTION get_rec (
211: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type
212: ) RETURN okc_subclasses_tl_rec_type IS
213: l_row_notfound BOOLEAN := TRUE;
214: BEGIN
215: RETURN(get_rec(p_okc_subclasses_tl_rec, l_row_notfound));
216: END get_rec;

Line 215: RETURN(get_rec(p_okc_subclasses_tl_rec, l_row_notfound));

211: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type
212: ) RETURN okc_subclasses_tl_rec_type IS
213: l_row_notfound BOOLEAN := TRUE;
214: BEGIN
215: RETURN(get_rec(p_okc_subclasses_tl_rec, l_row_notfound));
216: END get_rec;
217: ---------------------------------------------------------------------------
218: -- FUNCTION get_rec for: OKC_SUBCLASSES_V
219: ---------------------------------------------------------------------------

Line 796: p_to OUT NOCOPY okc_subclasses_tl_rec_type

792: p_to.access_level := p_from.access_level;
793: END migrate;
794: PROCEDURE migrate (
795: p_from IN scsv_rec_type,
796: p_to OUT NOCOPY okc_subclasses_tl_rec_type
797: ) IS
798: BEGIN
799: p_to.code := p_from.code;
800: p_to.sfwt_flag := p_from.sfwt_flag;

Line 810: p_from IN okc_subclasses_tl_rec_type,

806: p_to.last_update_date := p_from.last_update_date;
807: p_to.last_update_login := p_from.last_update_login;
808: END migrate;
809: PROCEDURE migrate (
810: p_from IN okc_subclasses_tl_rec_type,
811: p_to IN OUT NOCOPY scsv_rec_type
812: ) IS
813: BEGIN
814: p_to.code := p_from.code;

Line 844: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

840: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
841: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
842: l_scsv_rec scsv_rec_type := p_scsv_rec;
843: l_scs_rec scs_rec_type;
844: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
845: BEGIN
846: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
847: G_PKG_NAME,
848: p_init_msg_list,

Line 1084: -- insert_row for:OKC_SUBCLASSES_TL --

1080: '_PVT'
1081: );
1082: END insert_row;
1083: --------------------------------------
1084: -- insert_row for:OKC_SUBCLASSES_TL --
1085: --------------------------------------
1086: PROCEDURE insert_row(
1087: p_init_msg_list IN VARCHAR2,
1088: x_return_status OUT NOCOPY VARCHAR2,

Line 1091: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,

1087: p_init_msg_list IN VARCHAR2,
1088: x_return_status OUT NOCOPY VARCHAR2,
1089: x_msg_count OUT NOCOPY NUMBER,
1090: x_msg_data OUT NOCOPY VARCHAR2,
1091: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
1092: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type) IS
1093:
1094: l_api_version CONSTANT NUMBER := 1;
1095: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1092: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type) IS

1088: x_return_status OUT NOCOPY VARCHAR2,
1089: x_msg_count OUT NOCOPY NUMBER,
1090: x_msg_data OUT NOCOPY VARCHAR2,
1091: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
1092: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type) IS
1093:
1094: l_api_version CONSTANT NUMBER := 1;
1095: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1096: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1097: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type := p_okc_subclasses_tl_rec;

1093:
1094: l_api_version CONSTANT NUMBER := 1;
1095: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1096: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1097: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type := p_okc_subclasses_tl_rec;
1098: l_def_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
1099: CURSOR get_languages IS
1100: SELECT *
1101: FROM FND_LANGUAGES

Line 1098: l_def_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

1094: l_api_version CONSTANT NUMBER := 1;
1095: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1096: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1097: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type := p_okc_subclasses_tl_rec;
1098: l_def_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
1099: CURSOR get_languages IS
1100: SELECT *
1101: FROM FND_LANGUAGES
1102: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1104: -- Set_Attributes for:OKC_SUBCLASSES_TL --

1100: SELECT *
1101: FROM FND_LANGUAGES
1102: WHERE INSTALLED_FLAG IN ('I', 'B');
1103: ------------------------------------------
1104: -- Set_Attributes for:OKC_SUBCLASSES_TL --
1105: ------------------------------------------
1106: FUNCTION Set_Attributes (
1107: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
1108: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type

Line 1107: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,

1103: ------------------------------------------
1104: -- Set_Attributes for:OKC_SUBCLASSES_TL --
1105: ------------------------------------------
1106: FUNCTION Set_Attributes (
1107: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
1108: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
1109: ) RETURN VARCHAR2 IS
1110: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1111: BEGIN

Line 1108: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type

1104: -- Set_Attributes for:OKC_SUBCLASSES_TL --
1105: ------------------------------------------
1106: FUNCTION Set_Attributes (
1107: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
1108: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
1109: ) RETURN VARCHAR2 IS
1110: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1111: BEGIN
1112: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;

Line 1112: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;

1108: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
1109: ) RETURN VARCHAR2 IS
1110: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1111: BEGIN
1112: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;
1113: x_okc_subclasses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1114: x_okc_subclasses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1115: RETURN(l_return_status);
1116: END Set_Attributes;

Line 1113: x_okc_subclasses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

1109: ) RETURN VARCHAR2 IS
1110: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1111: BEGIN
1112: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;
1113: x_okc_subclasses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1114: x_okc_subclasses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1115: RETURN(l_return_status);
1116: END Set_Attributes;
1117: BEGIN

Line 1114: x_okc_subclasses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

1110: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1111: BEGIN
1112: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;
1113: x_okc_subclasses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1114: x_okc_subclasses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1115: RETURN(l_return_status);
1116: END Set_Attributes;
1117: BEGIN
1118: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1129: p_okc_subclasses_tl_rec, -- IN

1125: RAISE OKC_API.G_EXCEPTION_ERROR;
1126: END IF;
1127: --- Setting item attributes
1128: l_return_status := Set_Attributes(
1129: p_okc_subclasses_tl_rec, -- IN
1130: l_okc_subclasses_tl_rec); -- OUT
1131: --- If any errors happen abort API
1132: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1130: l_okc_subclasses_tl_rec); -- OUT

1126: END IF;
1127: --- Setting item attributes
1128: l_return_status := Set_Attributes(
1129: p_okc_subclasses_tl_rec, -- IN
1130: l_okc_subclasses_tl_rec); -- OUT
1131: --- If any errors happen abort API
1132: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1138: l_okc_subclasses_tl_rec.language := l_lang_rec.language_code;

1134: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1135: RAISE OKC_API.G_EXCEPTION_ERROR;
1136: END IF;
1137: FOR l_lang_rec IN get_languages LOOP
1138: l_okc_subclasses_tl_rec.language := l_lang_rec.language_code;
1139: INSERT INTO OKC_SUBCLASSES_TL(
1140: code,
1141: language,
1142: source_lang,

Line 1139: INSERT INTO OKC_SUBCLASSES_TL(

1135: RAISE OKC_API.G_EXCEPTION_ERROR;
1136: END IF;
1137: FOR l_lang_rec IN get_languages LOOP
1138: l_okc_subclasses_tl_rec.language := l_lang_rec.language_code;
1139: INSERT INTO OKC_SUBCLASSES_TL(
1140: code,
1141: language,
1142: source_lang,
1143: sfwt_flag,

Line 1152: l_okc_subclasses_tl_rec.code,

1148: last_updated_by,
1149: last_update_date,
1150: last_update_login)
1151: VALUES (
1152: l_okc_subclasses_tl_rec.code,
1153: l_okc_subclasses_tl_rec.language,
1154: l_okc_subclasses_tl_rec.source_lang,
1155: l_okc_subclasses_tl_rec.sfwt_flag,
1156: l_okc_subclasses_tl_rec.meaning,

Line 1153: l_okc_subclasses_tl_rec.language,

1149: last_update_date,
1150: last_update_login)
1151: VALUES (
1152: l_okc_subclasses_tl_rec.code,
1153: l_okc_subclasses_tl_rec.language,
1154: l_okc_subclasses_tl_rec.source_lang,
1155: l_okc_subclasses_tl_rec.sfwt_flag,
1156: l_okc_subclasses_tl_rec.meaning,
1157: l_okc_subclasses_tl_rec.description,

Line 1154: l_okc_subclasses_tl_rec.source_lang,

1150: last_update_login)
1151: VALUES (
1152: l_okc_subclasses_tl_rec.code,
1153: l_okc_subclasses_tl_rec.language,
1154: l_okc_subclasses_tl_rec.source_lang,
1155: l_okc_subclasses_tl_rec.sfwt_flag,
1156: l_okc_subclasses_tl_rec.meaning,
1157: l_okc_subclasses_tl_rec.description,
1158: l_okc_subclasses_tl_rec.created_by,

Line 1155: l_okc_subclasses_tl_rec.sfwt_flag,

1151: VALUES (
1152: l_okc_subclasses_tl_rec.code,
1153: l_okc_subclasses_tl_rec.language,
1154: l_okc_subclasses_tl_rec.source_lang,
1155: l_okc_subclasses_tl_rec.sfwt_flag,
1156: l_okc_subclasses_tl_rec.meaning,
1157: l_okc_subclasses_tl_rec.description,
1158: l_okc_subclasses_tl_rec.created_by,
1159: l_okc_subclasses_tl_rec.creation_date,

Line 1156: l_okc_subclasses_tl_rec.meaning,

1152: l_okc_subclasses_tl_rec.code,
1153: l_okc_subclasses_tl_rec.language,
1154: l_okc_subclasses_tl_rec.source_lang,
1155: l_okc_subclasses_tl_rec.sfwt_flag,
1156: l_okc_subclasses_tl_rec.meaning,
1157: l_okc_subclasses_tl_rec.description,
1158: l_okc_subclasses_tl_rec.created_by,
1159: l_okc_subclasses_tl_rec.creation_date,
1160: l_okc_subclasses_tl_rec.last_updated_by,

Line 1157: l_okc_subclasses_tl_rec.description,

1153: l_okc_subclasses_tl_rec.language,
1154: l_okc_subclasses_tl_rec.source_lang,
1155: l_okc_subclasses_tl_rec.sfwt_flag,
1156: l_okc_subclasses_tl_rec.meaning,
1157: l_okc_subclasses_tl_rec.description,
1158: l_okc_subclasses_tl_rec.created_by,
1159: l_okc_subclasses_tl_rec.creation_date,
1160: l_okc_subclasses_tl_rec.last_updated_by,
1161: l_okc_subclasses_tl_rec.last_update_date,

Line 1158: l_okc_subclasses_tl_rec.created_by,

1154: l_okc_subclasses_tl_rec.source_lang,
1155: l_okc_subclasses_tl_rec.sfwt_flag,
1156: l_okc_subclasses_tl_rec.meaning,
1157: l_okc_subclasses_tl_rec.description,
1158: l_okc_subclasses_tl_rec.created_by,
1159: l_okc_subclasses_tl_rec.creation_date,
1160: l_okc_subclasses_tl_rec.last_updated_by,
1161: l_okc_subclasses_tl_rec.last_update_date,
1162: l_okc_subclasses_tl_rec.last_update_login);

Line 1159: l_okc_subclasses_tl_rec.creation_date,

1155: l_okc_subclasses_tl_rec.sfwt_flag,
1156: l_okc_subclasses_tl_rec.meaning,
1157: l_okc_subclasses_tl_rec.description,
1158: l_okc_subclasses_tl_rec.created_by,
1159: l_okc_subclasses_tl_rec.creation_date,
1160: l_okc_subclasses_tl_rec.last_updated_by,
1161: l_okc_subclasses_tl_rec.last_update_date,
1162: l_okc_subclasses_tl_rec.last_update_login);
1163: END LOOP;

Line 1160: l_okc_subclasses_tl_rec.last_updated_by,

1156: l_okc_subclasses_tl_rec.meaning,
1157: l_okc_subclasses_tl_rec.description,
1158: l_okc_subclasses_tl_rec.created_by,
1159: l_okc_subclasses_tl_rec.creation_date,
1160: l_okc_subclasses_tl_rec.last_updated_by,
1161: l_okc_subclasses_tl_rec.last_update_date,
1162: l_okc_subclasses_tl_rec.last_update_login);
1163: END LOOP;
1164: -- Set OUT values

Line 1161: l_okc_subclasses_tl_rec.last_update_date,

1157: l_okc_subclasses_tl_rec.description,
1158: l_okc_subclasses_tl_rec.created_by,
1159: l_okc_subclasses_tl_rec.creation_date,
1160: l_okc_subclasses_tl_rec.last_updated_by,
1161: l_okc_subclasses_tl_rec.last_update_date,
1162: l_okc_subclasses_tl_rec.last_update_login);
1163: END LOOP;
1164: -- Set OUT values
1165: x_okc_subclasses_tl_rec := l_okc_subclasses_tl_rec;

Line 1162: l_okc_subclasses_tl_rec.last_update_login);

1158: l_okc_subclasses_tl_rec.created_by,
1159: l_okc_subclasses_tl_rec.creation_date,
1160: l_okc_subclasses_tl_rec.last_updated_by,
1161: l_okc_subclasses_tl_rec.last_update_date,
1162: l_okc_subclasses_tl_rec.last_update_login);
1163: END LOOP;
1164: -- Set OUT values
1165: x_okc_subclasses_tl_rec := l_okc_subclasses_tl_rec;
1166: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1165: x_okc_subclasses_tl_rec := l_okc_subclasses_tl_rec;

1161: l_okc_subclasses_tl_rec.last_update_date,
1162: l_okc_subclasses_tl_rec.last_update_login);
1163: END LOOP;
1164: -- Set OUT values
1165: x_okc_subclasses_tl_rec := l_okc_subclasses_tl_rec;
1166: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1167: EXCEPTION
1168: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1169: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1218: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

1214: l_scsv_rec scsv_rec_type;
1215: l_def_scsv_rec scsv_rec_type;
1216: l_scs_rec scs_rec_type;
1217: lx_scs_rec scs_rec_type;
1218: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
1219: lx_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
1220: -------------------------------
1221: -- FUNCTION fill_who_columns --
1222: -------------------------------

Line 1219: lx_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

1215: l_def_scsv_rec scsv_rec_type;
1216: l_scs_rec scs_rec_type;
1217: lx_scs_rec scs_rec_type;
1218: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
1219: lx_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
1220: -------------------------------
1221: -- FUNCTION fill_who_columns --
1222: -------------------------------
1223: FUNCTION fill_who_columns (

Line 1391: migrate(l_def_scsv_rec, l_okc_subclasses_tl_rec);

1387: --------------------------------------
1388: -- Move VIEW record to "Child" records
1389: --------------------------------------
1390: migrate(l_def_scsv_rec, l_scs_rec);
1391: migrate(l_def_scsv_rec, l_okc_subclasses_tl_rec);
1392: --------------------------------------------
1393: -- Call the INSERT_ROW for each child record
1394: --------------------------------------------
1395: insert_row(

Line 1414: l_okc_subclasses_tl_rec,

1410: p_init_msg_list,
1411: x_return_status,
1412: x_msg_count,
1413: x_msg_data,
1414: l_okc_subclasses_tl_rec,
1415: lx_okc_subclasses_tl_rec
1416: );
1417: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1418: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1415: lx_okc_subclasses_tl_rec

1411: x_return_status,
1412: x_msg_count,
1413: x_msg_data,
1414: l_okc_subclasses_tl_rec,
1415: lx_okc_subclasses_tl_rec
1416: );
1417: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1418: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1419: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1422: migrate(lx_okc_subclasses_tl_rec, l_def_scsv_rec);

1418: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1419: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1420: RAISE OKC_API.G_EXCEPTION_ERROR;
1421: END IF;
1422: migrate(lx_okc_subclasses_tl_rec, l_def_scsv_rec);
1423: -- Set OUT values
1424: x_scsv_rec := l_def_scsv_rec;
1425: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1426: EXCEPTION

Line 1635: -- lock_row for:OKC_SUBCLASSES_TL --

1631: '_PVT'
1632: );
1633: END lock_row;
1634: ------------------------------------
1635: -- lock_row for:OKC_SUBCLASSES_TL --
1636: ------------------------------------
1637: PROCEDURE lock_row(
1638: p_init_msg_list IN VARCHAR2,
1639: x_return_status OUT NOCOPY VARCHAR2,

Line 1642: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type) IS

1638: p_init_msg_list IN VARCHAR2,
1639: x_return_status OUT NOCOPY VARCHAR2,
1640: x_msg_count OUT NOCOPY NUMBER,
1641: x_msg_data OUT NOCOPY VARCHAR2,
1642: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type) IS
1643:
1644: E_Resource_Busy EXCEPTION;
1645: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1646: CURSOR lock_csr (p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type) IS

Line 1646: CURSOR lock_csr (p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type) IS

1642: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type) IS
1643:
1644: E_Resource_Busy EXCEPTION;
1645: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1646: CURSOR lock_csr (p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type) IS
1647: SELECT *
1648: FROM OKC_SUBCLASSES_TL
1649: WHERE CODE = p_okc_subclasses_tl_rec.code
1650: FOR UPDATE NOWAIT;

Line 1648: FROM OKC_SUBCLASSES_TL

1644: E_Resource_Busy EXCEPTION;
1645: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1646: CURSOR lock_csr (p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type) IS
1647: SELECT *
1648: FROM OKC_SUBCLASSES_TL
1649: WHERE CODE = p_okc_subclasses_tl_rec.code
1650: FOR UPDATE NOWAIT;
1651:
1652: l_api_version CONSTANT NUMBER := 1;

Line 1649: WHERE CODE = p_okc_subclasses_tl_rec.code

1645: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1646: CURSOR lock_csr (p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type) IS
1647: SELECT *
1648: FROM OKC_SUBCLASSES_TL
1649: WHERE CODE = p_okc_subclasses_tl_rec.code
1650: FOR UPDATE NOWAIT;
1651:
1652: l_api_version CONSTANT NUMBER := 1;
1653: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1669: OPEN lock_csr(p_okc_subclasses_tl_rec);

1665: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1666: RAISE OKC_API.G_EXCEPTION_ERROR;
1667: END IF;
1668: BEGIN
1669: OPEN lock_csr(p_okc_subclasses_tl_rec);
1670: FETCH lock_csr INTO l_lock_var;
1671: l_row_notfound := lock_csr%NOTFOUND;
1672: CLOSE lock_csr;
1673: EXCEPTION

Line 1734: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

1730: l_api_version CONSTANT NUMBER := 1;
1731: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1732: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1733: l_scs_rec scs_rec_type;
1734: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
1735: BEGIN
1736: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1737: G_PKG_NAME,
1738: p_init_msg_list,

Line 1752: migrate(p_scsv_rec, l_okc_subclasses_tl_rec);

1748: --------------------------------------
1749: -- Move VIEW record to "Child" records
1750: --------------------------------------
1751: migrate(p_scsv_rec, l_scs_rec);
1752: migrate(p_scsv_rec, l_okc_subclasses_tl_rec);
1753: --------------------------------------------
1754: -- Call the LOCK_ROW for each child record
1755: --------------------------------------------
1756: lock_row(

Line 1773: l_okc_subclasses_tl_rec

1769: p_init_msg_list,
1770: x_return_status,
1771: x_msg_count,
1772: x_msg_data,
1773: l_okc_subclasses_tl_rec
1774: );
1775: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1777: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2053: -- update_row for:OKC_SUBCLASSES_TL --

2049: '_PVT'
2050: );
2051: END update_row;
2052: --------------------------------------
2053: -- update_row for:OKC_SUBCLASSES_TL --
2054: --------------------------------------
2055: PROCEDURE update_row(
2056: p_init_msg_list IN VARCHAR2,
2057: x_return_status OUT NOCOPY VARCHAR2,

Line 2060: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,

2056: p_init_msg_list IN VARCHAR2,
2057: x_return_status OUT NOCOPY VARCHAR2,
2058: x_msg_count OUT NOCOPY NUMBER,
2059: x_msg_data OUT NOCOPY VARCHAR2,
2060: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
2061: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type) IS
2062:
2063: l_api_version CONSTANT NUMBER := 1;
2064: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2061: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type) IS

2057: x_return_status OUT NOCOPY VARCHAR2,
2058: x_msg_count OUT NOCOPY NUMBER,
2059: x_msg_data OUT NOCOPY VARCHAR2,
2060: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
2061: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type) IS
2062:
2063: l_api_version CONSTANT NUMBER := 1;
2064: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2065: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2066: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type := p_okc_subclasses_tl_rec;

2062:
2063: l_api_version CONSTANT NUMBER := 1;
2064: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2065: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2066: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type := p_okc_subclasses_tl_rec;
2067: l_def_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
2068: l_row_notfound BOOLEAN := TRUE;
2069: ----------------------------------
2070: -- FUNCTION populate_new_record --

Line 2067: l_def_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

2063: l_api_version CONSTANT NUMBER := 1;
2064: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2065: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2066: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type := p_okc_subclasses_tl_rec;
2067: l_def_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
2068: l_row_notfound BOOLEAN := TRUE;
2069: ----------------------------------
2070: -- FUNCTION populate_new_record --
2071: ----------------------------------

Line 2073: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,

2069: ----------------------------------
2070: -- FUNCTION populate_new_record --
2071: ----------------------------------
2072: FUNCTION populate_new_record (
2073: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
2074: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
2075: ) RETURN VARCHAR2 IS
2076: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
2077: l_row_notfound BOOLEAN := TRUE;

Line 2074: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type

2070: -- FUNCTION populate_new_record --
2071: ----------------------------------
2072: FUNCTION populate_new_record (
2073: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
2074: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
2075: ) RETURN VARCHAR2 IS
2076: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
2077: l_row_notfound BOOLEAN := TRUE;
2078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2076: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

2072: FUNCTION populate_new_record (
2073: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
2074: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
2075: ) RETURN VARCHAR2 IS
2076: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
2077: l_row_notfound BOOLEAN := TRUE;
2078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2079: BEGIN
2080: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;

Line 2080: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;

2076: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
2077: l_row_notfound BOOLEAN := TRUE;
2078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2079: BEGIN
2080: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;
2081: -- Get current database values
2082: l_okc_subclasses_tl_rec := get_rec(p_okc_subclasses_tl_rec, l_row_notfound);
2083: IF (l_row_notfound) THEN
2084: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2082: l_okc_subclasses_tl_rec := get_rec(p_okc_subclasses_tl_rec, l_row_notfound);

2078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2079: BEGIN
2080: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;
2081: -- Get current database values
2082: l_okc_subclasses_tl_rec := get_rec(p_okc_subclasses_tl_rec, l_row_notfound);
2083: IF (l_row_notfound) THEN
2084: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2085: END IF;
2086: IF (x_okc_subclasses_tl_rec.code = OKC_API.G_MISS_CHAR)

Line 2086: IF (x_okc_subclasses_tl_rec.code = OKC_API.G_MISS_CHAR)

2082: l_okc_subclasses_tl_rec := get_rec(p_okc_subclasses_tl_rec, l_row_notfound);
2083: IF (l_row_notfound) THEN
2084: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2085: END IF;
2086: IF (x_okc_subclasses_tl_rec.code = OKC_API.G_MISS_CHAR)
2087: THEN
2088: x_okc_subclasses_tl_rec.code := l_okc_subclasses_tl_rec.code;
2089: END IF;
2090: IF (x_okc_subclasses_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2088: x_okc_subclasses_tl_rec.code := l_okc_subclasses_tl_rec.code;

2084: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2085: END IF;
2086: IF (x_okc_subclasses_tl_rec.code = OKC_API.G_MISS_CHAR)
2087: THEN
2088: x_okc_subclasses_tl_rec.code := l_okc_subclasses_tl_rec.code;
2089: END IF;
2090: IF (x_okc_subclasses_tl_rec.language = OKC_API.G_MISS_CHAR)
2091: THEN
2092: x_okc_subclasses_tl_rec.language := l_okc_subclasses_tl_rec.language;

Line 2090: IF (x_okc_subclasses_tl_rec.language = OKC_API.G_MISS_CHAR)

2086: IF (x_okc_subclasses_tl_rec.code = OKC_API.G_MISS_CHAR)
2087: THEN
2088: x_okc_subclasses_tl_rec.code := l_okc_subclasses_tl_rec.code;
2089: END IF;
2090: IF (x_okc_subclasses_tl_rec.language = OKC_API.G_MISS_CHAR)
2091: THEN
2092: x_okc_subclasses_tl_rec.language := l_okc_subclasses_tl_rec.language;
2093: END IF;
2094: IF (x_okc_subclasses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2092: x_okc_subclasses_tl_rec.language := l_okc_subclasses_tl_rec.language;

2088: x_okc_subclasses_tl_rec.code := l_okc_subclasses_tl_rec.code;
2089: END IF;
2090: IF (x_okc_subclasses_tl_rec.language = OKC_API.G_MISS_CHAR)
2091: THEN
2092: x_okc_subclasses_tl_rec.language := l_okc_subclasses_tl_rec.language;
2093: END IF;
2094: IF (x_okc_subclasses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2095: THEN
2096: x_okc_subclasses_tl_rec.source_lang := l_okc_subclasses_tl_rec.source_lang;

Line 2094: IF (x_okc_subclasses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2090: IF (x_okc_subclasses_tl_rec.language = OKC_API.G_MISS_CHAR)
2091: THEN
2092: x_okc_subclasses_tl_rec.language := l_okc_subclasses_tl_rec.language;
2093: END IF;
2094: IF (x_okc_subclasses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2095: THEN
2096: x_okc_subclasses_tl_rec.source_lang := l_okc_subclasses_tl_rec.source_lang;
2097: END IF;
2098: IF (x_okc_subclasses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2096: x_okc_subclasses_tl_rec.source_lang := l_okc_subclasses_tl_rec.source_lang;

2092: x_okc_subclasses_tl_rec.language := l_okc_subclasses_tl_rec.language;
2093: END IF;
2094: IF (x_okc_subclasses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2095: THEN
2096: x_okc_subclasses_tl_rec.source_lang := l_okc_subclasses_tl_rec.source_lang;
2097: END IF;
2098: IF (x_okc_subclasses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2099: THEN
2100: x_okc_subclasses_tl_rec.sfwt_flag := l_okc_subclasses_tl_rec.sfwt_flag;

Line 2098: IF (x_okc_subclasses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2094: IF (x_okc_subclasses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2095: THEN
2096: x_okc_subclasses_tl_rec.source_lang := l_okc_subclasses_tl_rec.source_lang;
2097: END IF;
2098: IF (x_okc_subclasses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2099: THEN
2100: x_okc_subclasses_tl_rec.sfwt_flag := l_okc_subclasses_tl_rec.sfwt_flag;
2101: END IF;
2102: IF (x_okc_subclasses_tl_rec.meaning = OKC_API.G_MISS_CHAR)

Line 2100: x_okc_subclasses_tl_rec.sfwt_flag := l_okc_subclasses_tl_rec.sfwt_flag;

2096: x_okc_subclasses_tl_rec.source_lang := l_okc_subclasses_tl_rec.source_lang;
2097: END IF;
2098: IF (x_okc_subclasses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2099: THEN
2100: x_okc_subclasses_tl_rec.sfwt_flag := l_okc_subclasses_tl_rec.sfwt_flag;
2101: END IF;
2102: IF (x_okc_subclasses_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2103: THEN
2104: x_okc_subclasses_tl_rec.meaning := l_okc_subclasses_tl_rec.meaning;

Line 2102: IF (x_okc_subclasses_tl_rec.meaning = OKC_API.G_MISS_CHAR)

2098: IF (x_okc_subclasses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2099: THEN
2100: x_okc_subclasses_tl_rec.sfwt_flag := l_okc_subclasses_tl_rec.sfwt_flag;
2101: END IF;
2102: IF (x_okc_subclasses_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2103: THEN
2104: x_okc_subclasses_tl_rec.meaning := l_okc_subclasses_tl_rec.meaning;
2105: END IF;
2106: IF (x_okc_subclasses_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 2104: x_okc_subclasses_tl_rec.meaning := l_okc_subclasses_tl_rec.meaning;

2100: x_okc_subclasses_tl_rec.sfwt_flag := l_okc_subclasses_tl_rec.sfwt_flag;
2101: END IF;
2102: IF (x_okc_subclasses_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2103: THEN
2104: x_okc_subclasses_tl_rec.meaning := l_okc_subclasses_tl_rec.meaning;
2105: END IF;
2106: IF (x_okc_subclasses_tl_rec.description = OKC_API.G_MISS_CHAR)
2107: THEN
2108: x_okc_subclasses_tl_rec.description := l_okc_subclasses_tl_rec.description;

Line 2106: IF (x_okc_subclasses_tl_rec.description = OKC_API.G_MISS_CHAR)

2102: IF (x_okc_subclasses_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2103: THEN
2104: x_okc_subclasses_tl_rec.meaning := l_okc_subclasses_tl_rec.meaning;
2105: END IF;
2106: IF (x_okc_subclasses_tl_rec.description = OKC_API.G_MISS_CHAR)
2107: THEN
2108: x_okc_subclasses_tl_rec.description := l_okc_subclasses_tl_rec.description;
2109: END IF;
2110: IF (x_okc_subclasses_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2108: x_okc_subclasses_tl_rec.description := l_okc_subclasses_tl_rec.description;

2104: x_okc_subclasses_tl_rec.meaning := l_okc_subclasses_tl_rec.meaning;
2105: END IF;
2106: IF (x_okc_subclasses_tl_rec.description = OKC_API.G_MISS_CHAR)
2107: THEN
2108: x_okc_subclasses_tl_rec.description := l_okc_subclasses_tl_rec.description;
2109: END IF;
2110: IF (x_okc_subclasses_tl_rec.created_by = OKC_API.G_MISS_NUM)
2111: THEN
2112: x_okc_subclasses_tl_rec.created_by := l_okc_subclasses_tl_rec.created_by;

Line 2110: IF (x_okc_subclasses_tl_rec.created_by = OKC_API.G_MISS_NUM)

2106: IF (x_okc_subclasses_tl_rec.description = OKC_API.G_MISS_CHAR)
2107: THEN
2108: x_okc_subclasses_tl_rec.description := l_okc_subclasses_tl_rec.description;
2109: END IF;
2110: IF (x_okc_subclasses_tl_rec.created_by = OKC_API.G_MISS_NUM)
2111: THEN
2112: x_okc_subclasses_tl_rec.created_by := l_okc_subclasses_tl_rec.created_by;
2113: END IF;
2114: IF (x_okc_subclasses_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2112: x_okc_subclasses_tl_rec.created_by := l_okc_subclasses_tl_rec.created_by;

2108: x_okc_subclasses_tl_rec.description := l_okc_subclasses_tl_rec.description;
2109: END IF;
2110: IF (x_okc_subclasses_tl_rec.created_by = OKC_API.G_MISS_NUM)
2111: THEN
2112: x_okc_subclasses_tl_rec.created_by := l_okc_subclasses_tl_rec.created_by;
2113: END IF;
2114: IF (x_okc_subclasses_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2115: THEN
2116: x_okc_subclasses_tl_rec.creation_date := l_okc_subclasses_tl_rec.creation_date;

Line 2114: IF (x_okc_subclasses_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2110: IF (x_okc_subclasses_tl_rec.created_by = OKC_API.G_MISS_NUM)
2111: THEN
2112: x_okc_subclasses_tl_rec.created_by := l_okc_subclasses_tl_rec.created_by;
2113: END IF;
2114: IF (x_okc_subclasses_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2115: THEN
2116: x_okc_subclasses_tl_rec.creation_date := l_okc_subclasses_tl_rec.creation_date;
2117: END IF;
2118: IF (x_okc_subclasses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2116: x_okc_subclasses_tl_rec.creation_date := l_okc_subclasses_tl_rec.creation_date;

2112: x_okc_subclasses_tl_rec.created_by := l_okc_subclasses_tl_rec.created_by;
2113: END IF;
2114: IF (x_okc_subclasses_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2115: THEN
2116: x_okc_subclasses_tl_rec.creation_date := l_okc_subclasses_tl_rec.creation_date;
2117: END IF;
2118: IF (x_okc_subclasses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2119: THEN
2120: x_okc_subclasses_tl_rec.last_updated_by := l_okc_subclasses_tl_rec.last_updated_by;

Line 2118: IF (x_okc_subclasses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2114: IF (x_okc_subclasses_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2115: THEN
2116: x_okc_subclasses_tl_rec.creation_date := l_okc_subclasses_tl_rec.creation_date;
2117: END IF;
2118: IF (x_okc_subclasses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2119: THEN
2120: x_okc_subclasses_tl_rec.last_updated_by := l_okc_subclasses_tl_rec.last_updated_by;
2121: END IF;
2122: IF (x_okc_subclasses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2120: x_okc_subclasses_tl_rec.last_updated_by := l_okc_subclasses_tl_rec.last_updated_by;

2116: x_okc_subclasses_tl_rec.creation_date := l_okc_subclasses_tl_rec.creation_date;
2117: END IF;
2118: IF (x_okc_subclasses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2119: THEN
2120: x_okc_subclasses_tl_rec.last_updated_by := l_okc_subclasses_tl_rec.last_updated_by;
2121: END IF;
2122: IF (x_okc_subclasses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2123: THEN
2124: x_okc_subclasses_tl_rec.last_update_date := l_okc_subclasses_tl_rec.last_update_date;

Line 2122: IF (x_okc_subclasses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2118: IF (x_okc_subclasses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2119: THEN
2120: x_okc_subclasses_tl_rec.last_updated_by := l_okc_subclasses_tl_rec.last_updated_by;
2121: END IF;
2122: IF (x_okc_subclasses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2123: THEN
2124: x_okc_subclasses_tl_rec.last_update_date := l_okc_subclasses_tl_rec.last_update_date;
2125: END IF;
2126: IF (x_okc_subclasses_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2124: x_okc_subclasses_tl_rec.last_update_date := l_okc_subclasses_tl_rec.last_update_date;

2120: x_okc_subclasses_tl_rec.last_updated_by := l_okc_subclasses_tl_rec.last_updated_by;
2121: END IF;
2122: IF (x_okc_subclasses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2123: THEN
2124: x_okc_subclasses_tl_rec.last_update_date := l_okc_subclasses_tl_rec.last_update_date;
2125: END IF;
2126: IF (x_okc_subclasses_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2127: THEN
2128: x_okc_subclasses_tl_rec.last_update_login := l_okc_subclasses_tl_rec.last_update_login;

Line 2126: IF (x_okc_subclasses_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2122: IF (x_okc_subclasses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2123: THEN
2124: x_okc_subclasses_tl_rec.last_update_date := l_okc_subclasses_tl_rec.last_update_date;
2125: END IF;
2126: IF (x_okc_subclasses_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2127: THEN
2128: x_okc_subclasses_tl_rec.last_update_login := l_okc_subclasses_tl_rec.last_update_login;
2129: END IF;
2130: RETURN(l_return_status);

Line 2128: x_okc_subclasses_tl_rec.last_update_login := l_okc_subclasses_tl_rec.last_update_login;

2124: x_okc_subclasses_tl_rec.last_update_date := l_okc_subclasses_tl_rec.last_update_date;
2125: END IF;
2126: IF (x_okc_subclasses_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2127: THEN
2128: x_okc_subclasses_tl_rec.last_update_login := l_okc_subclasses_tl_rec.last_update_login;
2129: END IF;
2130: RETURN(l_return_status);
2131: END populate_new_record;
2132: ------------------------------------------

Line 2133: -- Set_Attributes for:OKC_SUBCLASSES_TL --

2129: END IF;
2130: RETURN(l_return_status);
2131: END populate_new_record;
2132: ------------------------------------------
2133: -- Set_Attributes for:OKC_SUBCLASSES_TL --
2134: ------------------------------------------
2135: FUNCTION Set_Attributes (
2136: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
2137: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type

Line 2136: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,

2132: ------------------------------------------
2133: -- Set_Attributes for:OKC_SUBCLASSES_TL --
2134: ------------------------------------------
2135: FUNCTION Set_Attributes (
2136: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
2137: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
2138: ) RETURN VARCHAR2 IS
2139: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2140: BEGIN

Line 2137: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type

2133: -- Set_Attributes for:OKC_SUBCLASSES_TL --
2134: ------------------------------------------
2135: FUNCTION Set_Attributes (
2136: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
2137: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
2138: ) RETURN VARCHAR2 IS
2139: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2140: BEGIN
2141: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;

Line 2141: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;

2137: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
2138: ) RETURN VARCHAR2 IS
2139: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2140: BEGIN
2141: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;
2142: x_okc_subclasses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2143: x_okc_subclasses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2144: RETURN(l_return_status);
2145: END Set_Attributes;

Line 2142: x_okc_subclasses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2138: ) RETURN VARCHAR2 IS
2139: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2140: BEGIN
2141: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;
2142: x_okc_subclasses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2143: x_okc_subclasses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2144: RETURN(l_return_status);
2145: END Set_Attributes;
2146: BEGIN

Line 2143: x_okc_subclasses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

2139: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2140: BEGIN
2141: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;
2142: x_okc_subclasses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2143: x_okc_subclasses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2144: RETURN(l_return_status);
2145: END Set_Attributes;
2146: BEGIN
2147: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2158: p_okc_subclasses_tl_rec, -- IN

2154: RAISE OKC_API.G_EXCEPTION_ERROR;
2155: END IF;
2156: --- Setting item attributes
2157: l_return_status := Set_Attributes(
2158: p_okc_subclasses_tl_rec, -- IN
2159: l_okc_subclasses_tl_rec); -- OUT
2160: --- If any errors happen abort API
2161: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2162: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2159: l_okc_subclasses_tl_rec); -- OUT

2155: END IF;
2156: --- Setting item attributes
2157: l_return_status := Set_Attributes(
2158: p_okc_subclasses_tl_rec, -- IN
2159: l_okc_subclasses_tl_rec); -- OUT
2160: --- If any errors happen abort API
2161: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2162: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2163: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2166: l_return_status := populate_new_record(l_okc_subclasses_tl_rec, l_def_okc_subclasses_tl_rec);

2162: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2163: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2164: RAISE OKC_API.G_EXCEPTION_ERROR;
2165: END IF;
2166: l_return_status := populate_new_record(l_okc_subclasses_tl_rec, l_def_okc_subclasses_tl_rec);
2167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2170: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2172: UPDATE OKC_SUBCLASSES_TL

2168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2170: RAISE OKC_API.G_EXCEPTION_ERROR;
2171: END IF;
2172: UPDATE OKC_SUBCLASSES_TL
2173: SET MEANING = l_def_okc_subclasses_tl_rec.meaning,
2174: DESCRIPTION = l_def_okc_subclasses_tl_rec.description,
2175: CREATED_BY = l_def_okc_subclasses_tl_rec.created_by,
2176: CREATION_DATE = l_def_okc_subclasses_tl_rec.creation_date,

Line 2173: SET MEANING = l_def_okc_subclasses_tl_rec.meaning,

2169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2170: RAISE OKC_API.G_EXCEPTION_ERROR;
2171: END IF;
2172: UPDATE OKC_SUBCLASSES_TL
2173: SET MEANING = l_def_okc_subclasses_tl_rec.meaning,
2174: DESCRIPTION = l_def_okc_subclasses_tl_rec.description,
2175: CREATED_BY = l_def_okc_subclasses_tl_rec.created_by,
2176: CREATION_DATE = l_def_okc_subclasses_tl_rec.creation_date,
2177: LAST_UPDATED_BY = l_def_okc_subclasses_tl_rec.last_updated_by,

Line 2174: DESCRIPTION = l_def_okc_subclasses_tl_rec.description,

2170: RAISE OKC_API.G_EXCEPTION_ERROR;
2171: END IF;
2172: UPDATE OKC_SUBCLASSES_TL
2173: SET MEANING = l_def_okc_subclasses_tl_rec.meaning,
2174: DESCRIPTION = l_def_okc_subclasses_tl_rec.description,
2175: CREATED_BY = l_def_okc_subclasses_tl_rec.created_by,
2176: CREATION_DATE = l_def_okc_subclasses_tl_rec.creation_date,
2177: LAST_UPDATED_BY = l_def_okc_subclasses_tl_rec.last_updated_by,
2178: LAST_UPDATE_DATE = l_def_okc_subclasses_tl_rec.last_update_date,

Line 2175: CREATED_BY = l_def_okc_subclasses_tl_rec.created_by,

2171: END IF;
2172: UPDATE OKC_SUBCLASSES_TL
2173: SET MEANING = l_def_okc_subclasses_tl_rec.meaning,
2174: DESCRIPTION = l_def_okc_subclasses_tl_rec.description,
2175: CREATED_BY = l_def_okc_subclasses_tl_rec.created_by,
2176: CREATION_DATE = l_def_okc_subclasses_tl_rec.creation_date,
2177: LAST_UPDATED_BY = l_def_okc_subclasses_tl_rec.last_updated_by,
2178: LAST_UPDATE_DATE = l_def_okc_subclasses_tl_rec.last_update_date,
2179: LAST_UPDATE_LOGIN = l_def_okc_subclasses_tl_rec.last_update_login

Line 2176: CREATION_DATE = l_def_okc_subclasses_tl_rec.creation_date,

2172: UPDATE OKC_SUBCLASSES_TL
2173: SET MEANING = l_def_okc_subclasses_tl_rec.meaning,
2174: DESCRIPTION = l_def_okc_subclasses_tl_rec.description,
2175: CREATED_BY = l_def_okc_subclasses_tl_rec.created_by,
2176: CREATION_DATE = l_def_okc_subclasses_tl_rec.creation_date,
2177: LAST_UPDATED_BY = l_def_okc_subclasses_tl_rec.last_updated_by,
2178: LAST_UPDATE_DATE = l_def_okc_subclasses_tl_rec.last_update_date,
2179: LAST_UPDATE_LOGIN = l_def_okc_subclasses_tl_rec.last_update_login
2180: WHERE CODE = l_def_okc_subclasses_tl_rec.code

Line 2177: LAST_UPDATED_BY = l_def_okc_subclasses_tl_rec.last_updated_by,

2173: SET MEANING = l_def_okc_subclasses_tl_rec.meaning,
2174: DESCRIPTION = l_def_okc_subclasses_tl_rec.description,
2175: CREATED_BY = l_def_okc_subclasses_tl_rec.created_by,
2176: CREATION_DATE = l_def_okc_subclasses_tl_rec.creation_date,
2177: LAST_UPDATED_BY = l_def_okc_subclasses_tl_rec.last_updated_by,
2178: LAST_UPDATE_DATE = l_def_okc_subclasses_tl_rec.last_update_date,
2179: LAST_UPDATE_LOGIN = l_def_okc_subclasses_tl_rec.last_update_login
2180: WHERE CODE = l_def_okc_subclasses_tl_rec.code
2181: AND SOURCE_LANG = USERENV('LANG');

Line 2178: LAST_UPDATE_DATE = l_def_okc_subclasses_tl_rec.last_update_date,

2174: DESCRIPTION = l_def_okc_subclasses_tl_rec.description,
2175: CREATED_BY = l_def_okc_subclasses_tl_rec.created_by,
2176: CREATION_DATE = l_def_okc_subclasses_tl_rec.creation_date,
2177: LAST_UPDATED_BY = l_def_okc_subclasses_tl_rec.last_updated_by,
2178: LAST_UPDATE_DATE = l_def_okc_subclasses_tl_rec.last_update_date,
2179: LAST_UPDATE_LOGIN = l_def_okc_subclasses_tl_rec.last_update_login
2180: WHERE CODE = l_def_okc_subclasses_tl_rec.code
2181: AND SOURCE_LANG = USERENV('LANG');
2182:

Line 2179: LAST_UPDATE_LOGIN = l_def_okc_subclasses_tl_rec.last_update_login

2175: CREATED_BY = l_def_okc_subclasses_tl_rec.created_by,
2176: CREATION_DATE = l_def_okc_subclasses_tl_rec.creation_date,
2177: LAST_UPDATED_BY = l_def_okc_subclasses_tl_rec.last_updated_by,
2178: LAST_UPDATE_DATE = l_def_okc_subclasses_tl_rec.last_update_date,
2179: LAST_UPDATE_LOGIN = l_def_okc_subclasses_tl_rec.last_update_login
2180: WHERE CODE = l_def_okc_subclasses_tl_rec.code
2181: AND SOURCE_LANG = USERENV('LANG');
2182:
2183: UPDATE OKC_SUBCLASSES_TL

Line 2180: WHERE CODE = l_def_okc_subclasses_tl_rec.code

2176: CREATION_DATE = l_def_okc_subclasses_tl_rec.creation_date,
2177: LAST_UPDATED_BY = l_def_okc_subclasses_tl_rec.last_updated_by,
2178: LAST_UPDATE_DATE = l_def_okc_subclasses_tl_rec.last_update_date,
2179: LAST_UPDATE_LOGIN = l_def_okc_subclasses_tl_rec.last_update_login
2180: WHERE CODE = l_def_okc_subclasses_tl_rec.code
2181: AND SOURCE_LANG = USERENV('LANG');
2182:
2183: UPDATE OKC_SUBCLASSES_TL
2184: SET SFWT_FLAG = 'Y'

Line 2183: UPDATE OKC_SUBCLASSES_TL

2179: LAST_UPDATE_LOGIN = l_def_okc_subclasses_tl_rec.last_update_login
2180: WHERE CODE = l_def_okc_subclasses_tl_rec.code
2181: AND SOURCE_LANG = USERENV('LANG');
2182:
2183: UPDATE OKC_SUBCLASSES_TL
2184: SET SFWT_FLAG = 'Y'
2185: WHERE CODE = l_def_okc_subclasses_tl_rec.code
2186: AND SOURCE_LANG <> USERENV('LANG');
2187:

Line 2185: WHERE CODE = l_def_okc_subclasses_tl_rec.code

2181: AND SOURCE_LANG = USERENV('LANG');
2182:
2183: UPDATE OKC_SUBCLASSES_TL
2184: SET SFWT_FLAG = 'Y'
2185: WHERE CODE = l_def_okc_subclasses_tl_rec.code
2186: AND SOURCE_LANG <> USERENV('LANG');
2187:
2188: x_okc_subclasses_tl_rec := l_def_okc_subclasses_tl_rec;
2189: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2188: x_okc_subclasses_tl_rec := l_def_okc_subclasses_tl_rec;

2184: SET SFWT_FLAG = 'Y'
2185: WHERE CODE = l_def_okc_subclasses_tl_rec.code
2186: AND SOURCE_LANG <> USERENV('LANG');
2187:
2188: x_okc_subclasses_tl_rec := l_def_okc_subclasses_tl_rec;
2189: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2190: EXCEPTION
2191: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2192: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2239: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

2235: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2237: l_scsv_rec scsv_rec_type := p_scsv_rec;
2238: l_def_scsv_rec scsv_rec_type;
2239: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
2240: lx_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
2241: l_scs_rec scs_rec_type;
2242: lx_scs_rec scs_rec_type;
2243: --kjhamb

Line 2240: lx_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

2236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2237: l_scsv_rec scsv_rec_type := p_scsv_rec;
2238: l_def_scsv_rec scsv_rec_type;
2239: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
2240: lx_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
2241: l_scs_rec scs_rec_type;
2242: lx_scs_rec scs_rec_type;
2243: --kjhamb
2244: l_tl_scsv_rec scsv_rec_type;

Line 2400: migrate(l_def_scsv_rec, l_okc_subclasses_tl_rec);

2396:
2397: --------------------------------------
2398: -- Move VIEW record to "Child" records
2399: --------------------------------------
2400: migrate(l_def_scsv_rec, l_okc_subclasses_tl_rec);
2401: migrate(l_def_scsv_rec, l_scs_rec);
2402: --------------------------------------------
2403: -- Call the UPDATE_ROW for each child record
2404: --------------------------------------------

Line 2405: IF ((l_tl_scsv_rec.Meaning <> l_okc_subclasses_tl_rec.Meaning) OR

2401: migrate(l_def_scsv_rec, l_scs_rec);
2402: --------------------------------------------
2403: -- Call the UPDATE_ROW for each child record
2404: --------------------------------------------
2405: IF ((l_tl_scsv_rec.Meaning <> l_okc_subclasses_tl_rec.Meaning) OR
2406: (l_tl_scsv_rec.Description <> l_okc_subclasses_tl_rec.Description)) THEN
2407: update_row(
2408: p_init_msg_list,
2409: x_return_status,

Line 2406: (l_tl_scsv_rec.Description <> l_okc_subclasses_tl_rec.Description)) THEN

2402: --------------------------------------------
2403: -- Call the UPDATE_ROW for each child record
2404: --------------------------------------------
2405: IF ((l_tl_scsv_rec.Meaning <> l_okc_subclasses_tl_rec.Meaning) OR
2406: (l_tl_scsv_rec.Description <> l_okc_subclasses_tl_rec.Description)) THEN
2407: update_row(
2408: p_init_msg_list,
2409: x_return_status,
2410: x_msg_count,

Line 2412: l_okc_subclasses_tl_rec,

2408: p_init_msg_list,
2409: x_return_status,
2410: x_msg_count,
2411: x_msg_data,
2412: l_okc_subclasses_tl_rec,
2413: lx_okc_subclasses_tl_rec
2414: );
2415: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2416: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2413: lx_okc_subclasses_tl_rec

2409: x_return_status,
2410: x_msg_count,
2411: x_msg_data,
2412: l_okc_subclasses_tl_rec,
2413: lx_okc_subclasses_tl_rec
2414: );
2415: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2416: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2417: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2420: migrate(lx_okc_subclasses_tl_rec, l_def_scsv_rec);

2416: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2417: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2418: RAISE OKC_API.G_EXCEPTION_ERROR;
2419: END IF;
2420: migrate(lx_okc_subclasses_tl_rec, l_def_scsv_rec);
2421: else
2422: migrate(l_okc_subclasses_tl_rec, l_def_scsv_rec);
2423: end if;
2424: update_row(

Line 2422: migrate(l_okc_subclasses_tl_rec, l_def_scsv_rec);

2418: RAISE OKC_API.G_EXCEPTION_ERROR;
2419: END IF;
2420: migrate(lx_okc_subclasses_tl_rec, l_def_scsv_rec);
2421: else
2422: migrate(l_okc_subclasses_tl_rec, l_def_scsv_rec);
2423: end if;
2424: update_row(
2425: p_init_msg_list,
2426: x_return_status,

Line 2604: -- delete_row for:OKC_SUBCLASSES_TL --

2600: '_PVT'
2601: );
2602: END delete_row;
2603: --------------------------------------
2604: -- delete_row for:OKC_SUBCLASSES_TL --
2605: --------------------------------------
2606: PROCEDURE delete_row(
2607: p_init_msg_list IN VARCHAR2,
2608: x_return_status OUT NOCOPY VARCHAR2,

Line 2611: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type) IS

2607: p_init_msg_list IN VARCHAR2,
2608: x_return_status OUT NOCOPY VARCHAR2,
2609: x_msg_count OUT NOCOPY NUMBER,
2610: x_msg_data OUT NOCOPY VARCHAR2,
2611: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type) IS
2612:
2613: l_api_version CONSTANT NUMBER := 1;
2614: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2615: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2616: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type:= p_okc_subclasses_tl_rec;

2612:
2613: l_api_version CONSTANT NUMBER := 1;
2614: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2615: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2616: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type:= p_okc_subclasses_tl_rec;
2617: l_row_notfound BOOLEAN := TRUE;
2618: ------------------------------------------
2619: -- Set_Attributes for:OKC_SUBCLASSES_TL --
2620: ------------------------------------------

Line 2619: -- Set_Attributes for:OKC_SUBCLASSES_TL --

2615: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2616: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type:= p_okc_subclasses_tl_rec;
2617: l_row_notfound BOOLEAN := TRUE;
2618: ------------------------------------------
2619: -- Set_Attributes for:OKC_SUBCLASSES_TL --
2620: ------------------------------------------
2621: FUNCTION Set_Attributes (
2622: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
2623: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type

Line 2622: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,

2618: ------------------------------------------
2619: -- Set_Attributes for:OKC_SUBCLASSES_TL --
2620: ------------------------------------------
2621: FUNCTION Set_Attributes (
2622: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
2623: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
2624: ) RETURN VARCHAR2 IS
2625: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2626: BEGIN

Line 2623: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type

2619: -- Set_Attributes for:OKC_SUBCLASSES_TL --
2620: ------------------------------------------
2621: FUNCTION Set_Attributes (
2622: p_okc_subclasses_tl_rec IN okc_subclasses_tl_rec_type,
2623: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
2624: ) RETURN VARCHAR2 IS
2625: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2626: BEGIN
2627: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;

Line 2627: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;

2623: x_okc_subclasses_tl_rec OUT NOCOPY okc_subclasses_tl_rec_type
2624: ) RETURN VARCHAR2 IS
2625: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2626: BEGIN
2627: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;
2628: x_okc_subclasses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2629: RETURN(l_return_status);
2630: END Set_Attributes;
2631: BEGIN

Line 2628: x_okc_subclasses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2624: ) RETURN VARCHAR2 IS
2625: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2626: BEGIN
2627: x_okc_subclasses_tl_rec := p_okc_subclasses_tl_rec;
2628: x_okc_subclasses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2629: RETURN(l_return_status);
2630: END Set_Attributes;
2631: BEGIN
2632: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2643: p_okc_subclasses_tl_rec, -- IN

2639: RAISE OKC_API.G_EXCEPTION_ERROR;
2640: END IF;
2641: --- Setting item attributes
2642: l_return_status := Set_Attributes(
2643: p_okc_subclasses_tl_rec, -- IN
2644: l_okc_subclasses_tl_rec); -- OUT
2645: --- If any errors happen abort API
2646: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2647: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2644: l_okc_subclasses_tl_rec); -- OUT

2640: END IF;
2641: --- Setting item attributes
2642: l_return_status := Set_Attributes(
2643: p_okc_subclasses_tl_rec, -- IN
2644: l_okc_subclasses_tl_rec); -- OUT
2645: --- If any errors happen abort API
2646: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2647: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2648: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2651: DELETE FROM OKC_SUBCLASSES_TL

2647: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2648: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2649: RAISE OKC_API.G_EXCEPTION_ERROR;
2650: END IF;
2651: DELETE FROM OKC_SUBCLASSES_TL
2652: WHERE CODE = l_okc_subclasses_tl_rec.code;
2653:
2654: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2655: EXCEPTION

Line 2652: WHERE CODE = l_okc_subclasses_tl_rec.code;

2648: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2649: RAISE OKC_API.G_EXCEPTION_ERROR;
2650: END IF;
2651: DELETE FROM OKC_SUBCLASSES_TL
2652: WHERE CODE = l_okc_subclasses_tl_rec.code;
2653:
2654: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2655: EXCEPTION
2656: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2702: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;

2698: l_api_version CONSTANT NUMBER := 1;
2699: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2700: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2701: l_scsv_rec scsv_rec_type := p_scsv_rec;
2702: l_okc_subclasses_tl_rec okc_subclasses_tl_rec_type;
2703: l_scs_rec scs_rec_type;
2704: BEGIN
2705: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2706: G_PKG_NAME,

Line 2720: migrate(l_scsv_rec, l_okc_subclasses_tl_rec);

2716: END IF;
2717: --------------------------------------
2718: -- Move VIEW record to "Child" records
2719: --------------------------------------
2720: migrate(l_scsv_rec, l_okc_subclasses_tl_rec);
2721: migrate(l_scsv_rec, l_scs_rec);
2722: --------------------------------------------
2723: -- Call the DELETE_ROW for each child record
2724: --------------------------------------------

Line 2730: l_okc_subclasses_tl_rec

2726: p_init_msg_list,
2727: x_return_status,
2728: x_msg_count,
2729: x_msg_data,
2730: l_okc_subclasses_tl_rec
2731: );
2732: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2733: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2734: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN