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_STS_PVT dependencies on OKC_STATUSES_TL

Line 42: DELETE FROM OKC_STATUSES_TL T

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

Line 49: UPDATE OKC_STATUSES_TL T SET (

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

Line 54: FROM OKC_STATUSES_TL B

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

Line 63: FROM OKC_STATUSES_TL SUBB, OKC_STATUSES_TL SUBT

59: T.LANGUAGE)
60: IN (SELECT
61: SUBT.CODE,
62: SUBT.LANGUAGE
63: FROM OKC_STATUSES_TL SUBB, OKC_STATUSES_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_STATUSES_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_STATUSES_TL (
73: CODE,
74: LANGUAGE,
75: SOURCE_LANG,
76: SFWT_FLAG,

Line 96: FROM OKC_STATUSES_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_STATUSES_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_STATUSES_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_STATUSES_TL T
102: WHERE T.CODE = B.CODE
103: AND T.LANGUAGE = L.LANGUAGE_CODE
104: );
105:

Line 161: -- FUNCTION get_rec for: OKC_STATUSES_TL

157: BEGIN
158: RETURN(get_rec(p_sts_rec, l_row_notfound));
159: END get_rec;
160: ---------------------------------------------------------------------------
161: -- FUNCTION get_rec for: OKC_STATUSES_TL
162: ---------------------------------------------------------------------------
163: FUNCTION get_rec (
164: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
165: x_no_data_found OUT NOCOPY BOOLEAN

Line 164: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,

160: ---------------------------------------------------------------------------
161: -- FUNCTION get_rec for: OKC_STATUSES_TL
162: ---------------------------------------------------------------------------
163: FUNCTION get_rec (
164: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
165: x_no_data_found OUT NOCOPY BOOLEAN
166: ) RETURN okc_statuses_tl_rec_type IS
167: CURSOR sts_pktl_csr (p_code IN VARCHAR2,
168: p_language IN VARCHAR2) IS

Line 166: ) RETURN okc_statuses_tl_rec_type IS

162: ---------------------------------------------------------------------------
163: FUNCTION get_rec (
164: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
165: x_no_data_found OUT NOCOPY BOOLEAN
166: ) RETURN okc_statuses_tl_rec_type IS
167: CURSOR sts_pktl_csr (p_code IN VARCHAR2,
168: p_language IN VARCHAR2) IS
169: SELECT
170: CODE,

Line 181: FROM Okc_Statuses_Tl

177: CREATION_DATE,
178: LAST_UPDATED_BY,
179: LAST_UPDATE_DATE,
180: LAST_UPDATE_LOGIN
181: FROM Okc_Statuses_Tl
182: WHERE okc_statuses_tl.code = p_code
183: AND okc_statuses_tl.language = p_language;
184: l_sts_pktl sts_pktl_csr%ROWTYPE;
185: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;

Line 182: WHERE okc_statuses_tl.code = p_code

178: LAST_UPDATED_BY,
179: LAST_UPDATE_DATE,
180: LAST_UPDATE_LOGIN
181: FROM Okc_Statuses_Tl
182: WHERE okc_statuses_tl.code = p_code
183: AND okc_statuses_tl.language = p_language;
184: l_sts_pktl sts_pktl_csr%ROWTYPE;
185: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
186: BEGIN

Line 183: AND okc_statuses_tl.language = p_language;

179: LAST_UPDATE_DATE,
180: LAST_UPDATE_LOGIN
181: FROM Okc_Statuses_Tl
182: WHERE okc_statuses_tl.code = p_code
183: AND okc_statuses_tl.language = p_language;
184: l_sts_pktl sts_pktl_csr%ROWTYPE;
185: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
186: BEGIN
187: x_no_data_found := TRUE;

Line 185: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;

181: FROM Okc_Statuses_Tl
182: WHERE okc_statuses_tl.code = p_code
183: AND okc_statuses_tl.language = p_language;
184: l_sts_pktl sts_pktl_csr%ROWTYPE;
185: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
186: BEGIN
187: x_no_data_found := TRUE;
188: -- Get current database values
189: OPEN sts_pktl_csr (p_okc_statuses_tl_rec.code,

Line 189: OPEN sts_pktl_csr (p_okc_statuses_tl_rec.code,

185: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
186: BEGIN
187: x_no_data_found := TRUE;
188: -- Get current database values
189: OPEN sts_pktl_csr (p_okc_statuses_tl_rec.code,
190: p_okc_statuses_tl_rec.language);
191: FETCH sts_pktl_csr INTO
192: l_okc_statuses_tl_rec.CODE,
193: l_okc_statuses_tl_rec.LANGUAGE,

Line 190: p_okc_statuses_tl_rec.language);

186: BEGIN
187: x_no_data_found := TRUE;
188: -- Get current database values
189: OPEN sts_pktl_csr (p_okc_statuses_tl_rec.code,
190: p_okc_statuses_tl_rec.language);
191: FETCH sts_pktl_csr INTO
192: l_okc_statuses_tl_rec.CODE,
193: l_okc_statuses_tl_rec.LANGUAGE,
194: l_okc_statuses_tl_rec.SOURCE_LANG,

Line 192: l_okc_statuses_tl_rec.CODE,

188: -- Get current database values
189: OPEN sts_pktl_csr (p_okc_statuses_tl_rec.code,
190: p_okc_statuses_tl_rec.language);
191: FETCH sts_pktl_csr INTO
192: l_okc_statuses_tl_rec.CODE,
193: l_okc_statuses_tl_rec.LANGUAGE,
194: l_okc_statuses_tl_rec.SOURCE_LANG,
195: l_okc_statuses_tl_rec.SFWT_FLAG,
196: l_okc_statuses_tl_rec.MEANING,

Line 193: l_okc_statuses_tl_rec.LANGUAGE,

189: OPEN sts_pktl_csr (p_okc_statuses_tl_rec.code,
190: p_okc_statuses_tl_rec.language);
191: FETCH sts_pktl_csr INTO
192: l_okc_statuses_tl_rec.CODE,
193: l_okc_statuses_tl_rec.LANGUAGE,
194: l_okc_statuses_tl_rec.SOURCE_LANG,
195: l_okc_statuses_tl_rec.SFWT_FLAG,
196: l_okc_statuses_tl_rec.MEANING,
197: l_okc_statuses_tl_rec.DESCRIPTION,

Line 194: l_okc_statuses_tl_rec.SOURCE_LANG,

190: p_okc_statuses_tl_rec.language);
191: FETCH sts_pktl_csr INTO
192: l_okc_statuses_tl_rec.CODE,
193: l_okc_statuses_tl_rec.LANGUAGE,
194: l_okc_statuses_tl_rec.SOURCE_LANG,
195: l_okc_statuses_tl_rec.SFWT_FLAG,
196: l_okc_statuses_tl_rec.MEANING,
197: l_okc_statuses_tl_rec.DESCRIPTION,
198: l_okc_statuses_tl_rec.CREATED_BY,

Line 195: l_okc_statuses_tl_rec.SFWT_FLAG,

191: FETCH sts_pktl_csr INTO
192: l_okc_statuses_tl_rec.CODE,
193: l_okc_statuses_tl_rec.LANGUAGE,
194: l_okc_statuses_tl_rec.SOURCE_LANG,
195: l_okc_statuses_tl_rec.SFWT_FLAG,
196: l_okc_statuses_tl_rec.MEANING,
197: l_okc_statuses_tl_rec.DESCRIPTION,
198: l_okc_statuses_tl_rec.CREATED_BY,
199: l_okc_statuses_tl_rec.CREATION_DATE,

Line 196: l_okc_statuses_tl_rec.MEANING,

192: l_okc_statuses_tl_rec.CODE,
193: l_okc_statuses_tl_rec.LANGUAGE,
194: l_okc_statuses_tl_rec.SOURCE_LANG,
195: l_okc_statuses_tl_rec.SFWT_FLAG,
196: l_okc_statuses_tl_rec.MEANING,
197: l_okc_statuses_tl_rec.DESCRIPTION,
198: l_okc_statuses_tl_rec.CREATED_BY,
199: l_okc_statuses_tl_rec.CREATION_DATE,
200: l_okc_statuses_tl_rec.LAST_UPDATED_BY,

Line 197: l_okc_statuses_tl_rec.DESCRIPTION,

193: l_okc_statuses_tl_rec.LANGUAGE,
194: l_okc_statuses_tl_rec.SOURCE_LANG,
195: l_okc_statuses_tl_rec.SFWT_FLAG,
196: l_okc_statuses_tl_rec.MEANING,
197: l_okc_statuses_tl_rec.DESCRIPTION,
198: l_okc_statuses_tl_rec.CREATED_BY,
199: l_okc_statuses_tl_rec.CREATION_DATE,
200: l_okc_statuses_tl_rec.LAST_UPDATED_BY,
201: l_okc_statuses_tl_rec.LAST_UPDATE_DATE,

Line 198: l_okc_statuses_tl_rec.CREATED_BY,

194: l_okc_statuses_tl_rec.SOURCE_LANG,
195: l_okc_statuses_tl_rec.SFWT_FLAG,
196: l_okc_statuses_tl_rec.MEANING,
197: l_okc_statuses_tl_rec.DESCRIPTION,
198: l_okc_statuses_tl_rec.CREATED_BY,
199: l_okc_statuses_tl_rec.CREATION_DATE,
200: l_okc_statuses_tl_rec.LAST_UPDATED_BY,
201: l_okc_statuses_tl_rec.LAST_UPDATE_DATE,
202: l_okc_statuses_tl_rec.LAST_UPDATE_LOGIN;

Line 199: l_okc_statuses_tl_rec.CREATION_DATE,

195: l_okc_statuses_tl_rec.SFWT_FLAG,
196: l_okc_statuses_tl_rec.MEANING,
197: l_okc_statuses_tl_rec.DESCRIPTION,
198: l_okc_statuses_tl_rec.CREATED_BY,
199: l_okc_statuses_tl_rec.CREATION_DATE,
200: l_okc_statuses_tl_rec.LAST_UPDATED_BY,
201: l_okc_statuses_tl_rec.LAST_UPDATE_DATE,
202: l_okc_statuses_tl_rec.LAST_UPDATE_LOGIN;
203: x_no_data_found := sts_pktl_csr%NOTFOUND;

Line 200: l_okc_statuses_tl_rec.LAST_UPDATED_BY,

196: l_okc_statuses_tl_rec.MEANING,
197: l_okc_statuses_tl_rec.DESCRIPTION,
198: l_okc_statuses_tl_rec.CREATED_BY,
199: l_okc_statuses_tl_rec.CREATION_DATE,
200: l_okc_statuses_tl_rec.LAST_UPDATED_BY,
201: l_okc_statuses_tl_rec.LAST_UPDATE_DATE,
202: l_okc_statuses_tl_rec.LAST_UPDATE_LOGIN;
203: x_no_data_found := sts_pktl_csr%NOTFOUND;
204: CLOSE sts_pktl_csr;

Line 201: l_okc_statuses_tl_rec.LAST_UPDATE_DATE,

197: l_okc_statuses_tl_rec.DESCRIPTION,
198: l_okc_statuses_tl_rec.CREATED_BY,
199: l_okc_statuses_tl_rec.CREATION_DATE,
200: l_okc_statuses_tl_rec.LAST_UPDATED_BY,
201: l_okc_statuses_tl_rec.LAST_UPDATE_DATE,
202: l_okc_statuses_tl_rec.LAST_UPDATE_LOGIN;
203: x_no_data_found := sts_pktl_csr%NOTFOUND;
204: CLOSE sts_pktl_csr;
205: RETURN(l_okc_statuses_tl_rec);

Line 202: l_okc_statuses_tl_rec.LAST_UPDATE_LOGIN;

198: l_okc_statuses_tl_rec.CREATED_BY,
199: l_okc_statuses_tl_rec.CREATION_DATE,
200: l_okc_statuses_tl_rec.LAST_UPDATED_BY,
201: l_okc_statuses_tl_rec.LAST_UPDATE_DATE,
202: l_okc_statuses_tl_rec.LAST_UPDATE_LOGIN;
203: x_no_data_found := sts_pktl_csr%NOTFOUND;
204: CLOSE sts_pktl_csr;
205: RETURN(l_okc_statuses_tl_rec);
206: END get_rec;

Line 205: RETURN(l_okc_statuses_tl_rec);

201: l_okc_statuses_tl_rec.LAST_UPDATE_DATE,
202: l_okc_statuses_tl_rec.LAST_UPDATE_LOGIN;
203: x_no_data_found := sts_pktl_csr%NOTFOUND;
204: CLOSE sts_pktl_csr;
205: RETURN(l_okc_statuses_tl_rec);
206: END get_rec;
207:
208: FUNCTION get_rec (
209: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type

Line 209: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type

205: RETURN(l_okc_statuses_tl_rec);
206: END get_rec;
207:
208: FUNCTION get_rec (
209: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type
210: ) RETURN okc_statuses_tl_rec_type IS
211: l_row_notfound BOOLEAN := TRUE;
212: BEGIN
213: RETURN(get_rec(p_okc_statuses_tl_rec, l_row_notfound));

Line 210: ) RETURN okc_statuses_tl_rec_type IS

206: END get_rec;
207:
208: FUNCTION get_rec (
209: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type
210: ) RETURN okc_statuses_tl_rec_type IS
211: l_row_notfound BOOLEAN := TRUE;
212: BEGIN
213: RETURN(get_rec(p_okc_statuses_tl_rec, l_row_notfound));
214: END get_rec;

Line 213: RETURN(get_rec(p_okc_statuses_tl_rec, l_row_notfound));

209: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type
210: ) RETURN okc_statuses_tl_rec_type IS
211: l_row_notfound BOOLEAN := TRUE;
212: BEGIN
213: RETURN(get_rec(p_okc_statuses_tl_rec, l_row_notfound));
214: END get_rec;
215: ---------------------------------------------------------------------------
216: -- FUNCTION get_rec for: OKC_STATUSES_V
217: ---------------------------------------------------------------------------

Line 804: p_to OUT NOCOPY okc_statuses_tl_rec_type

800: p_to.last_update_login := p_from.last_update_login;
801: END migrate;
802: PROCEDURE migrate (
803: p_from IN stsv_rec_type,
804: p_to OUT NOCOPY okc_statuses_tl_rec_type
805: ) IS
806: BEGIN
807: p_to.code := p_from.code;
808: p_to.sfwt_flag := p_from.sfwt_flag;

Line 818: p_from IN okc_statuses_tl_rec_type,

814: p_to.last_update_date := p_from.last_update_date;
815: p_to.last_update_login := p_from.last_update_login;
816: END migrate;
817: PROCEDURE migrate (
818: p_from IN okc_statuses_tl_rec_type,
819: p_to IN OUT NOCOPY stsv_rec_type
820: ) IS
821: BEGIN
822: p_to.code := p_from.code;

Line 852: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;

848: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
849: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
850: l_stsv_rec stsv_rec_type := p_stsv_rec;
851: l_sts_rec sts_rec_type;
852: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
853: BEGIN
854: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
855: G_PKG_NAME,
856: p_init_msg_list,

Line 1089: -- insert_row for:OKC_STATUSES_TL --

1085: '_PVT'
1086: );
1087: END insert_row;
1088: ------------------------------------
1089: -- insert_row for:OKC_STATUSES_TL --
1090: ------------------------------------
1091: PROCEDURE insert_row(
1092: p_init_msg_list IN VARCHAR2,
1093: x_return_status OUT NOCOPY VARCHAR2,

Line 1096: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,

1092: p_init_msg_list IN VARCHAR2,
1093: x_return_status OUT NOCOPY VARCHAR2,
1094: x_msg_count OUT NOCOPY NUMBER,
1095: x_msg_data OUT NOCOPY VARCHAR2,
1096: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
1097: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type) IS
1098:
1099: l_api_version CONSTANT NUMBER := 1;
1100: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1097: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type) IS

1093: x_return_status OUT NOCOPY VARCHAR2,
1094: x_msg_count OUT NOCOPY NUMBER,
1095: x_msg_data OUT NOCOPY VARCHAR2,
1096: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
1097: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type) IS
1098:
1099: l_api_version CONSTANT NUMBER := 1;
1100: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1101: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1102: l_okc_statuses_tl_rec okc_statuses_tl_rec_type := p_okc_statuses_tl_rec;

1098:
1099: l_api_version CONSTANT NUMBER := 1;
1100: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1101: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1102: l_okc_statuses_tl_rec okc_statuses_tl_rec_type := p_okc_statuses_tl_rec;
1103: l_def_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1104: CURSOR get_languages IS
1105: SELECT *
1106: FROM FND_LANGUAGES

Line 1103: l_def_okc_statuses_tl_rec okc_statuses_tl_rec_type;

1099: l_api_version CONSTANT NUMBER := 1;
1100: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1101: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1102: l_okc_statuses_tl_rec okc_statuses_tl_rec_type := p_okc_statuses_tl_rec;
1103: l_def_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1104: CURSOR get_languages IS
1105: SELECT *
1106: FROM FND_LANGUAGES
1107: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1109: -- Set_Attributes for:OKC_STATUSES_TL --

1105: SELECT *
1106: FROM FND_LANGUAGES
1107: WHERE INSTALLED_FLAG IN ('I', 'B');
1108: ----------------------------------------
1109: -- Set_Attributes for:OKC_STATUSES_TL --
1110: ----------------------------------------
1111: FUNCTION Set_Attributes (
1112: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
1113: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type

Line 1112: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,

1108: ----------------------------------------
1109: -- Set_Attributes for:OKC_STATUSES_TL --
1110: ----------------------------------------
1111: FUNCTION Set_Attributes (
1112: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
1113: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
1114: ) RETURN VARCHAR2 IS
1115: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1116: BEGIN

Line 1113: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type

1109: -- Set_Attributes for:OKC_STATUSES_TL --
1110: ----------------------------------------
1111: FUNCTION Set_Attributes (
1112: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
1113: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
1114: ) RETURN VARCHAR2 IS
1115: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1116: BEGIN
1117: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;

Line 1117: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;

1113: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
1114: ) RETURN VARCHAR2 IS
1115: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1116: BEGIN
1117: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;
1118: x_okc_statuses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1119: x_okc_statuses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1120: RETURN(l_return_status);
1121: END Set_Attributes;

Line 1118: x_okc_statuses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

1114: ) RETURN VARCHAR2 IS
1115: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1116: BEGIN
1117: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;
1118: x_okc_statuses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1119: x_okc_statuses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1120: RETURN(l_return_status);
1121: END Set_Attributes;
1122: BEGIN

Line 1119: x_okc_statuses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

1115: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1116: BEGIN
1117: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;
1118: x_okc_statuses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1119: x_okc_statuses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1120: RETURN(l_return_status);
1121: END Set_Attributes;
1122: BEGIN
1123: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1134: p_okc_statuses_tl_rec, -- IN

1130: RAISE OKC_API.G_EXCEPTION_ERROR;
1131: END IF;
1132: --- Setting item attributes
1133: l_return_status := Set_Attributes(
1134: p_okc_statuses_tl_rec, -- IN
1135: l_okc_statuses_tl_rec); -- OUT
1136: --- If any errors happen abort API
1137: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1138: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1135: l_okc_statuses_tl_rec); -- OUT

1131: END IF;
1132: --- Setting item attributes
1133: l_return_status := Set_Attributes(
1134: p_okc_statuses_tl_rec, -- IN
1135: l_okc_statuses_tl_rec); -- OUT
1136: --- If any errors happen abort API
1137: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1138: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1139: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1143: l_okc_statuses_tl_rec.language := l_lang_rec.language_code;

1139: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1140: RAISE OKC_API.G_EXCEPTION_ERROR;
1141: END IF;
1142: FOR l_lang_rec IN get_languages LOOP
1143: l_okc_statuses_tl_rec.language := l_lang_rec.language_code;
1144: INSERT INTO OKC_STATUSES_TL(
1145: code,
1146: language,
1147: source_lang,

Line 1144: INSERT INTO OKC_STATUSES_TL(

1140: RAISE OKC_API.G_EXCEPTION_ERROR;
1141: END IF;
1142: FOR l_lang_rec IN get_languages LOOP
1143: l_okc_statuses_tl_rec.language := l_lang_rec.language_code;
1144: INSERT INTO OKC_STATUSES_TL(
1145: code,
1146: language,
1147: source_lang,
1148: sfwt_flag,

Line 1157: l_okc_statuses_tl_rec.code,

1153: last_updated_by,
1154: last_update_date,
1155: last_update_login)
1156: VALUES (
1157: l_okc_statuses_tl_rec.code,
1158: l_okc_statuses_tl_rec.language,
1159: l_okc_statuses_tl_rec.source_lang,
1160: l_okc_statuses_tl_rec.sfwt_flag,
1161: l_okc_statuses_tl_rec.meaning,

Line 1158: l_okc_statuses_tl_rec.language,

1154: last_update_date,
1155: last_update_login)
1156: VALUES (
1157: l_okc_statuses_tl_rec.code,
1158: l_okc_statuses_tl_rec.language,
1159: l_okc_statuses_tl_rec.source_lang,
1160: l_okc_statuses_tl_rec.sfwt_flag,
1161: l_okc_statuses_tl_rec.meaning,
1162: l_okc_statuses_tl_rec.description,

Line 1159: l_okc_statuses_tl_rec.source_lang,

1155: last_update_login)
1156: VALUES (
1157: l_okc_statuses_tl_rec.code,
1158: l_okc_statuses_tl_rec.language,
1159: l_okc_statuses_tl_rec.source_lang,
1160: l_okc_statuses_tl_rec.sfwt_flag,
1161: l_okc_statuses_tl_rec.meaning,
1162: l_okc_statuses_tl_rec.description,
1163: l_okc_statuses_tl_rec.created_by,

Line 1160: l_okc_statuses_tl_rec.sfwt_flag,

1156: VALUES (
1157: l_okc_statuses_tl_rec.code,
1158: l_okc_statuses_tl_rec.language,
1159: l_okc_statuses_tl_rec.source_lang,
1160: l_okc_statuses_tl_rec.sfwt_flag,
1161: l_okc_statuses_tl_rec.meaning,
1162: l_okc_statuses_tl_rec.description,
1163: l_okc_statuses_tl_rec.created_by,
1164: l_okc_statuses_tl_rec.creation_date,

Line 1161: l_okc_statuses_tl_rec.meaning,

1157: l_okc_statuses_tl_rec.code,
1158: l_okc_statuses_tl_rec.language,
1159: l_okc_statuses_tl_rec.source_lang,
1160: l_okc_statuses_tl_rec.sfwt_flag,
1161: l_okc_statuses_tl_rec.meaning,
1162: l_okc_statuses_tl_rec.description,
1163: l_okc_statuses_tl_rec.created_by,
1164: l_okc_statuses_tl_rec.creation_date,
1165: l_okc_statuses_tl_rec.last_updated_by,

Line 1162: l_okc_statuses_tl_rec.description,

1158: l_okc_statuses_tl_rec.language,
1159: l_okc_statuses_tl_rec.source_lang,
1160: l_okc_statuses_tl_rec.sfwt_flag,
1161: l_okc_statuses_tl_rec.meaning,
1162: l_okc_statuses_tl_rec.description,
1163: l_okc_statuses_tl_rec.created_by,
1164: l_okc_statuses_tl_rec.creation_date,
1165: l_okc_statuses_tl_rec.last_updated_by,
1166: l_okc_statuses_tl_rec.last_update_date,

Line 1163: l_okc_statuses_tl_rec.created_by,

1159: l_okc_statuses_tl_rec.source_lang,
1160: l_okc_statuses_tl_rec.sfwt_flag,
1161: l_okc_statuses_tl_rec.meaning,
1162: l_okc_statuses_tl_rec.description,
1163: l_okc_statuses_tl_rec.created_by,
1164: l_okc_statuses_tl_rec.creation_date,
1165: l_okc_statuses_tl_rec.last_updated_by,
1166: l_okc_statuses_tl_rec.last_update_date,
1167: l_okc_statuses_tl_rec.last_update_login);

Line 1164: l_okc_statuses_tl_rec.creation_date,

1160: l_okc_statuses_tl_rec.sfwt_flag,
1161: l_okc_statuses_tl_rec.meaning,
1162: l_okc_statuses_tl_rec.description,
1163: l_okc_statuses_tl_rec.created_by,
1164: l_okc_statuses_tl_rec.creation_date,
1165: l_okc_statuses_tl_rec.last_updated_by,
1166: l_okc_statuses_tl_rec.last_update_date,
1167: l_okc_statuses_tl_rec.last_update_login);
1168: END LOOP;

Line 1165: l_okc_statuses_tl_rec.last_updated_by,

1161: l_okc_statuses_tl_rec.meaning,
1162: l_okc_statuses_tl_rec.description,
1163: l_okc_statuses_tl_rec.created_by,
1164: l_okc_statuses_tl_rec.creation_date,
1165: l_okc_statuses_tl_rec.last_updated_by,
1166: l_okc_statuses_tl_rec.last_update_date,
1167: l_okc_statuses_tl_rec.last_update_login);
1168: END LOOP;
1169: -- Set OUT values

Line 1166: l_okc_statuses_tl_rec.last_update_date,

1162: l_okc_statuses_tl_rec.description,
1163: l_okc_statuses_tl_rec.created_by,
1164: l_okc_statuses_tl_rec.creation_date,
1165: l_okc_statuses_tl_rec.last_updated_by,
1166: l_okc_statuses_tl_rec.last_update_date,
1167: l_okc_statuses_tl_rec.last_update_login);
1168: END LOOP;
1169: -- Set OUT values
1170: x_okc_statuses_tl_rec := l_okc_statuses_tl_rec;

Line 1167: l_okc_statuses_tl_rec.last_update_login);

1163: l_okc_statuses_tl_rec.created_by,
1164: l_okc_statuses_tl_rec.creation_date,
1165: l_okc_statuses_tl_rec.last_updated_by,
1166: l_okc_statuses_tl_rec.last_update_date,
1167: l_okc_statuses_tl_rec.last_update_login);
1168: END LOOP;
1169: -- Set OUT values
1170: x_okc_statuses_tl_rec := l_okc_statuses_tl_rec;
1171: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1170: x_okc_statuses_tl_rec := l_okc_statuses_tl_rec;

1166: l_okc_statuses_tl_rec.last_update_date,
1167: l_okc_statuses_tl_rec.last_update_login);
1168: END LOOP;
1169: -- Set OUT values
1170: x_okc_statuses_tl_rec := l_okc_statuses_tl_rec;
1171: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1172: EXCEPTION
1173: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1174: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1223: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;

1219: l_stsv_rec stsv_rec_type;
1220: l_def_stsv_rec stsv_rec_type;
1221: l_sts_rec sts_rec_type;
1222: lx_sts_rec sts_rec_type;
1223: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1224: lx_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1225: -------------------------------
1226: -- FUNCTION fill_who_columns --
1227: -------------------------------

Line 1224: lx_okc_statuses_tl_rec okc_statuses_tl_rec_type;

1220: l_def_stsv_rec stsv_rec_type;
1221: l_sts_rec sts_rec_type;
1222: lx_sts_rec sts_rec_type;
1223: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1224: lx_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1225: -------------------------------
1226: -- FUNCTION fill_who_columns --
1227: -------------------------------
1228: FUNCTION fill_who_columns (

Line 1309: migrate(l_def_stsv_rec, l_okc_statuses_tl_rec);

1305: --------------------------------------
1306: -- Move VIEW record to "Child" records
1307: --------------------------------------
1308: migrate(l_def_stsv_rec, l_sts_rec);
1309: migrate(l_def_stsv_rec, l_okc_statuses_tl_rec);
1310: --------------------------------------------
1311: -- Call the INSERT_ROW for each child record
1312: --------------------------------------------
1313: insert_row(

Line 1332: l_okc_statuses_tl_rec,

1328: p_init_msg_list,
1329: x_return_status,
1330: x_msg_count,
1331: x_msg_data,
1332: l_okc_statuses_tl_rec,
1333: lx_okc_statuses_tl_rec
1334: );
1335: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1336: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1333: lx_okc_statuses_tl_rec

1329: x_return_status,
1330: x_msg_count,
1331: x_msg_data,
1332: l_okc_statuses_tl_rec,
1333: lx_okc_statuses_tl_rec
1334: );
1335: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1336: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1337: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1340: migrate(lx_okc_statuses_tl_rec, l_def_stsv_rec);

1336: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1337: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1338: RAISE OKC_API.G_EXCEPTION_ERROR;
1339: END IF;
1340: migrate(lx_okc_statuses_tl_rec, l_def_stsv_rec);
1341: -- Set OUT values
1342: x_stsv_rec := l_def_stsv_rec;
1343: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1344: EXCEPTION

Line 1553: -- lock_row for:OKC_STATUSES_TL --

1549: '_PVT'
1550: );
1551: END lock_row;
1552: ----------------------------------
1553: -- lock_row for:OKC_STATUSES_TL --
1554: ----------------------------------
1555: PROCEDURE lock_row(
1556: p_init_msg_list IN VARCHAR2,
1557: x_return_status OUT NOCOPY VARCHAR2,

Line 1560: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type) IS

1556: p_init_msg_list IN VARCHAR2,
1557: x_return_status OUT NOCOPY VARCHAR2,
1558: x_msg_count OUT NOCOPY NUMBER,
1559: x_msg_data OUT NOCOPY VARCHAR2,
1560: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type) IS
1561:
1562: E_Resource_Busy EXCEPTION;
1563: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1564: CURSOR lock_csr (p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type) IS

Line 1564: CURSOR lock_csr (p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type) IS

1560: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type) IS
1561:
1562: E_Resource_Busy EXCEPTION;
1563: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1564: CURSOR lock_csr (p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type) IS
1565: SELECT *
1566: FROM OKC_STATUSES_TL
1567: WHERE CODE = p_okc_statuses_tl_rec.code
1568: FOR UPDATE NOWAIT;

Line 1566: FROM OKC_STATUSES_TL

1562: E_Resource_Busy EXCEPTION;
1563: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1564: CURSOR lock_csr (p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type) IS
1565: SELECT *
1566: FROM OKC_STATUSES_TL
1567: WHERE CODE = p_okc_statuses_tl_rec.code
1568: FOR UPDATE NOWAIT;
1569:
1570: l_api_version CONSTANT NUMBER := 1;

Line 1567: WHERE CODE = p_okc_statuses_tl_rec.code

1563: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1564: CURSOR lock_csr (p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type) IS
1565: SELECT *
1566: FROM OKC_STATUSES_TL
1567: WHERE CODE = p_okc_statuses_tl_rec.code
1568: FOR UPDATE NOWAIT;
1569:
1570: l_api_version CONSTANT NUMBER := 1;
1571: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1587: OPEN lock_csr(p_okc_statuses_tl_rec);

1583: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1584: RAISE OKC_API.G_EXCEPTION_ERROR;
1585: END IF;
1586: BEGIN
1587: OPEN lock_csr(p_okc_statuses_tl_rec);
1588: FETCH lock_csr INTO l_lock_var;
1589: l_row_notfound := lock_csr%NOTFOUND;
1590: CLOSE lock_csr;
1591: EXCEPTION

Line 1652: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;

1648: l_api_version CONSTANT NUMBER := 1;
1649: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1650: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1651: l_sts_rec sts_rec_type;
1652: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1653: BEGIN
1654: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1655: G_PKG_NAME,
1656: p_init_msg_list,

Line 1670: migrate(p_stsv_rec, l_okc_statuses_tl_rec);

1666: --------------------------------------
1667: -- Move VIEW record to "Child" records
1668: --------------------------------------
1669: migrate(p_stsv_rec, l_sts_rec);
1670: migrate(p_stsv_rec, l_okc_statuses_tl_rec);
1671: --------------------------------------------
1672: -- Call the LOCK_ROW for each child record
1673: --------------------------------------------
1674: lock_row(

Line 1691: l_okc_statuses_tl_rec

1687: p_init_msg_list,
1688: x_return_status,
1689: x_msg_count,
1690: x_msg_data,
1691: l_okc_statuses_tl_rec
1692: );
1693: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1694: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1695: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1965: -- update_row for:OKC_STATUSES_TL --

1961: '_PVT'
1962: );
1963: END update_row;
1964: ------------------------------------
1965: -- update_row for:OKC_STATUSES_TL --
1966: ------------------------------------
1967: PROCEDURE update_row(
1968: p_init_msg_list IN VARCHAR2,
1969: x_return_status OUT NOCOPY VARCHAR2,

Line 1972: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,

1968: p_init_msg_list IN VARCHAR2,
1969: x_return_status OUT NOCOPY VARCHAR2,
1970: x_msg_count OUT NOCOPY NUMBER,
1971: x_msg_data OUT NOCOPY VARCHAR2,
1972: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
1973: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type) IS
1974:
1975: l_api_version CONSTANT NUMBER := 1;
1976: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 1973: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type) IS

1969: x_return_status OUT NOCOPY VARCHAR2,
1970: x_msg_count OUT NOCOPY NUMBER,
1971: x_msg_data OUT NOCOPY VARCHAR2,
1972: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
1973: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type) IS
1974:
1975: l_api_version CONSTANT NUMBER := 1;
1976: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
1977: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1978: l_okc_statuses_tl_rec okc_statuses_tl_rec_type := p_okc_statuses_tl_rec;

1974:
1975: l_api_version CONSTANT NUMBER := 1;
1976: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
1977: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1978: l_okc_statuses_tl_rec okc_statuses_tl_rec_type := p_okc_statuses_tl_rec;
1979: l_def_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1980: l_row_notfound BOOLEAN := TRUE;
1981: ----------------------------------
1982: -- FUNCTION populate_new_record --

Line 1979: l_def_okc_statuses_tl_rec okc_statuses_tl_rec_type;

1975: l_api_version CONSTANT NUMBER := 1;
1976: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
1977: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1978: l_okc_statuses_tl_rec okc_statuses_tl_rec_type := p_okc_statuses_tl_rec;
1979: l_def_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1980: l_row_notfound BOOLEAN := TRUE;
1981: ----------------------------------
1982: -- FUNCTION populate_new_record --
1983: ----------------------------------

Line 1985: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,

1981: ----------------------------------
1982: -- FUNCTION populate_new_record --
1983: ----------------------------------
1984: FUNCTION populate_new_record (
1985: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
1986: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
1987: ) RETURN VARCHAR2 IS
1988: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1989: l_row_notfound BOOLEAN := TRUE;

Line 1986: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type

1982: -- FUNCTION populate_new_record --
1983: ----------------------------------
1984: FUNCTION populate_new_record (
1985: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
1986: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
1987: ) RETURN VARCHAR2 IS
1988: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1989: l_row_notfound BOOLEAN := TRUE;
1990: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1988: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;

1984: FUNCTION populate_new_record (
1985: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
1986: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
1987: ) RETURN VARCHAR2 IS
1988: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1989: l_row_notfound BOOLEAN := TRUE;
1990: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1991: BEGIN
1992: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;

Line 1992: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;

1988: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
1989: l_row_notfound BOOLEAN := TRUE;
1990: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1991: BEGIN
1992: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;
1993: -- Get current database values
1994: l_okc_statuses_tl_rec := get_rec(p_okc_statuses_tl_rec, l_row_notfound);
1995: IF (l_row_notfound) THEN
1996: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1994: l_okc_statuses_tl_rec := get_rec(p_okc_statuses_tl_rec, l_row_notfound);

1990: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1991: BEGIN
1992: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;
1993: -- Get current database values
1994: l_okc_statuses_tl_rec := get_rec(p_okc_statuses_tl_rec, l_row_notfound);
1995: IF (l_row_notfound) THEN
1996: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1997: END IF;
1998: IF (x_okc_statuses_tl_rec.code = OKC_API.G_MISS_CHAR)

Line 1998: IF (x_okc_statuses_tl_rec.code = OKC_API.G_MISS_CHAR)

1994: l_okc_statuses_tl_rec := get_rec(p_okc_statuses_tl_rec, l_row_notfound);
1995: IF (l_row_notfound) THEN
1996: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1997: END IF;
1998: IF (x_okc_statuses_tl_rec.code = OKC_API.G_MISS_CHAR)
1999: THEN
2000: x_okc_statuses_tl_rec.code := l_okc_statuses_tl_rec.code;
2001: END IF;
2002: IF (x_okc_statuses_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2000: x_okc_statuses_tl_rec.code := l_okc_statuses_tl_rec.code;

1996: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1997: END IF;
1998: IF (x_okc_statuses_tl_rec.code = OKC_API.G_MISS_CHAR)
1999: THEN
2000: x_okc_statuses_tl_rec.code := l_okc_statuses_tl_rec.code;
2001: END IF;
2002: IF (x_okc_statuses_tl_rec.language = OKC_API.G_MISS_CHAR)
2003: THEN
2004: x_okc_statuses_tl_rec.language := l_okc_statuses_tl_rec.language;

Line 2002: IF (x_okc_statuses_tl_rec.language = OKC_API.G_MISS_CHAR)

1998: IF (x_okc_statuses_tl_rec.code = OKC_API.G_MISS_CHAR)
1999: THEN
2000: x_okc_statuses_tl_rec.code := l_okc_statuses_tl_rec.code;
2001: END IF;
2002: IF (x_okc_statuses_tl_rec.language = OKC_API.G_MISS_CHAR)
2003: THEN
2004: x_okc_statuses_tl_rec.language := l_okc_statuses_tl_rec.language;
2005: END IF;
2006: IF (x_okc_statuses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2004: x_okc_statuses_tl_rec.language := l_okc_statuses_tl_rec.language;

2000: x_okc_statuses_tl_rec.code := l_okc_statuses_tl_rec.code;
2001: END IF;
2002: IF (x_okc_statuses_tl_rec.language = OKC_API.G_MISS_CHAR)
2003: THEN
2004: x_okc_statuses_tl_rec.language := l_okc_statuses_tl_rec.language;
2005: END IF;
2006: IF (x_okc_statuses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2007: THEN
2008: x_okc_statuses_tl_rec.source_lang := l_okc_statuses_tl_rec.source_lang;

Line 2006: IF (x_okc_statuses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2002: IF (x_okc_statuses_tl_rec.language = OKC_API.G_MISS_CHAR)
2003: THEN
2004: x_okc_statuses_tl_rec.language := l_okc_statuses_tl_rec.language;
2005: END IF;
2006: IF (x_okc_statuses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2007: THEN
2008: x_okc_statuses_tl_rec.source_lang := l_okc_statuses_tl_rec.source_lang;
2009: END IF;
2010: IF (x_okc_statuses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2008: x_okc_statuses_tl_rec.source_lang := l_okc_statuses_tl_rec.source_lang;

2004: x_okc_statuses_tl_rec.language := l_okc_statuses_tl_rec.language;
2005: END IF;
2006: IF (x_okc_statuses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2007: THEN
2008: x_okc_statuses_tl_rec.source_lang := l_okc_statuses_tl_rec.source_lang;
2009: END IF;
2010: IF (x_okc_statuses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2011: THEN
2012: x_okc_statuses_tl_rec.sfwt_flag := l_okc_statuses_tl_rec.sfwt_flag;

Line 2010: IF (x_okc_statuses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2006: IF (x_okc_statuses_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2007: THEN
2008: x_okc_statuses_tl_rec.source_lang := l_okc_statuses_tl_rec.source_lang;
2009: END IF;
2010: IF (x_okc_statuses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2011: THEN
2012: x_okc_statuses_tl_rec.sfwt_flag := l_okc_statuses_tl_rec.sfwt_flag;
2013: END IF;
2014: IF (x_okc_statuses_tl_rec.meaning = OKC_API.G_MISS_CHAR)

Line 2012: x_okc_statuses_tl_rec.sfwt_flag := l_okc_statuses_tl_rec.sfwt_flag;

2008: x_okc_statuses_tl_rec.source_lang := l_okc_statuses_tl_rec.source_lang;
2009: END IF;
2010: IF (x_okc_statuses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2011: THEN
2012: x_okc_statuses_tl_rec.sfwt_flag := l_okc_statuses_tl_rec.sfwt_flag;
2013: END IF;
2014: IF (x_okc_statuses_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2015: THEN
2016: x_okc_statuses_tl_rec.meaning := l_okc_statuses_tl_rec.meaning;

Line 2014: IF (x_okc_statuses_tl_rec.meaning = OKC_API.G_MISS_CHAR)

2010: IF (x_okc_statuses_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2011: THEN
2012: x_okc_statuses_tl_rec.sfwt_flag := l_okc_statuses_tl_rec.sfwt_flag;
2013: END IF;
2014: IF (x_okc_statuses_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2015: THEN
2016: x_okc_statuses_tl_rec.meaning := l_okc_statuses_tl_rec.meaning;
2017: END IF;
2018: IF (x_okc_statuses_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 2016: x_okc_statuses_tl_rec.meaning := l_okc_statuses_tl_rec.meaning;

2012: x_okc_statuses_tl_rec.sfwt_flag := l_okc_statuses_tl_rec.sfwt_flag;
2013: END IF;
2014: IF (x_okc_statuses_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2015: THEN
2016: x_okc_statuses_tl_rec.meaning := l_okc_statuses_tl_rec.meaning;
2017: END IF;
2018: IF (x_okc_statuses_tl_rec.description = OKC_API.G_MISS_CHAR)
2019: THEN
2020: x_okc_statuses_tl_rec.description := l_okc_statuses_tl_rec.description;

Line 2018: IF (x_okc_statuses_tl_rec.description = OKC_API.G_MISS_CHAR)

2014: IF (x_okc_statuses_tl_rec.meaning = OKC_API.G_MISS_CHAR)
2015: THEN
2016: x_okc_statuses_tl_rec.meaning := l_okc_statuses_tl_rec.meaning;
2017: END IF;
2018: IF (x_okc_statuses_tl_rec.description = OKC_API.G_MISS_CHAR)
2019: THEN
2020: x_okc_statuses_tl_rec.description := l_okc_statuses_tl_rec.description;
2021: END IF;
2022: IF (x_okc_statuses_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2020: x_okc_statuses_tl_rec.description := l_okc_statuses_tl_rec.description;

2016: x_okc_statuses_tl_rec.meaning := l_okc_statuses_tl_rec.meaning;
2017: END IF;
2018: IF (x_okc_statuses_tl_rec.description = OKC_API.G_MISS_CHAR)
2019: THEN
2020: x_okc_statuses_tl_rec.description := l_okc_statuses_tl_rec.description;
2021: END IF;
2022: IF (x_okc_statuses_tl_rec.created_by = OKC_API.G_MISS_NUM)
2023: THEN
2024: x_okc_statuses_tl_rec.created_by := l_okc_statuses_tl_rec.created_by;

Line 2022: IF (x_okc_statuses_tl_rec.created_by = OKC_API.G_MISS_NUM)

2018: IF (x_okc_statuses_tl_rec.description = OKC_API.G_MISS_CHAR)
2019: THEN
2020: x_okc_statuses_tl_rec.description := l_okc_statuses_tl_rec.description;
2021: END IF;
2022: IF (x_okc_statuses_tl_rec.created_by = OKC_API.G_MISS_NUM)
2023: THEN
2024: x_okc_statuses_tl_rec.created_by := l_okc_statuses_tl_rec.created_by;
2025: END IF;
2026: IF (x_okc_statuses_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2024: x_okc_statuses_tl_rec.created_by := l_okc_statuses_tl_rec.created_by;

2020: x_okc_statuses_tl_rec.description := l_okc_statuses_tl_rec.description;
2021: END IF;
2022: IF (x_okc_statuses_tl_rec.created_by = OKC_API.G_MISS_NUM)
2023: THEN
2024: x_okc_statuses_tl_rec.created_by := l_okc_statuses_tl_rec.created_by;
2025: END IF;
2026: IF (x_okc_statuses_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2027: THEN
2028: x_okc_statuses_tl_rec.creation_date := l_okc_statuses_tl_rec.creation_date;

Line 2026: IF (x_okc_statuses_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2022: IF (x_okc_statuses_tl_rec.created_by = OKC_API.G_MISS_NUM)
2023: THEN
2024: x_okc_statuses_tl_rec.created_by := l_okc_statuses_tl_rec.created_by;
2025: END IF;
2026: IF (x_okc_statuses_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2027: THEN
2028: x_okc_statuses_tl_rec.creation_date := l_okc_statuses_tl_rec.creation_date;
2029: END IF;
2030: IF (x_okc_statuses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2028: x_okc_statuses_tl_rec.creation_date := l_okc_statuses_tl_rec.creation_date;

2024: x_okc_statuses_tl_rec.created_by := l_okc_statuses_tl_rec.created_by;
2025: END IF;
2026: IF (x_okc_statuses_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2027: THEN
2028: x_okc_statuses_tl_rec.creation_date := l_okc_statuses_tl_rec.creation_date;
2029: END IF;
2030: IF (x_okc_statuses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2031: THEN
2032: x_okc_statuses_tl_rec.last_updated_by := l_okc_statuses_tl_rec.last_updated_by;

Line 2030: IF (x_okc_statuses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2026: IF (x_okc_statuses_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2027: THEN
2028: x_okc_statuses_tl_rec.creation_date := l_okc_statuses_tl_rec.creation_date;
2029: END IF;
2030: IF (x_okc_statuses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2031: THEN
2032: x_okc_statuses_tl_rec.last_updated_by := l_okc_statuses_tl_rec.last_updated_by;
2033: END IF;
2034: IF (x_okc_statuses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2032: x_okc_statuses_tl_rec.last_updated_by := l_okc_statuses_tl_rec.last_updated_by;

2028: x_okc_statuses_tl_rec.creation_date := l_okc_statuses_tl_rec.creation_date;
2029: END IF;
2030: IF (x_okc_statuses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2031: THEN
2032: x_okc_statuses_tl_rec.last_updated_by := l_okc_statuses_tl_rec.last_updated_by;
2033: END IF;
2034: IF (x_okc_statuses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2035: THEN
2036: x_okc_statuses_tl_rec.last_update_date := l_okc_statuses_tl_rec.last_update_date;

Line 2034: IF (x_okc_statuses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2030: IF (x_okc_statuses_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2031: THEN
2032: x_okc_statuses_tl_rec.last_updated_by := l_okc_statuses_tl_rec.last_updated_by;
2033: END IF;
2034: IF (x_okc_statuses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2035: THEN
2036: x_okc_statuses_tl_rec.last_update_date := l_okc_statuses_tl_rec.last_update_date;
2037: END IF;
2038: IF (x_okc_statuses_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2036: x_okc_statuses_tl_rec.last_update_date := l_okc_statuses_tl_rec.last_update_date;

2032: x_okc_statuses_tl_rec.last_updated_by := l_okc_statuses_tl_rec.last_updated_by;
2033: END IF;
2034: IF (x_okc_statuses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2035: THEN
2036: x_okc_statuses_tl_rec.last_update_date := l_okc_statuses_tl_rec.last_update_date;
2037: END IF;
2038: IF (x_okc_statuses_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2039: THEN
2040: x_okc_statuses_tl_rec.last_update_login := l_okc_statuses_tl_rec.last_update_login;

Line 2038: IF (x_okc_statuses_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2034: IF (x_okc_statuses_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2035: THEN
2036: x_okc_statuses_tl_rec.last_update_date := l_okc_statuses_tl_rec.last_update_date;
2037: END IF;
2038: IF (x_okc_statuses_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2039: THEN
2040: x_okc_statuses_tl_rec.last_update_login := l_okc_statuses_tl_rec.last_update_login;
2041: END IF;
2042: RETURN(l_return_status);

Line 2040: x_okc_statuses_tl_rec.last_update_login := l_okc_statuses_tl_rec.last_update_login;

2036: x_okc_statuses_tl_rec.last_update_date := l_okc_statuses_tl_rec.last_update_date;
2037: END IF;
2038: IF (x_okc_statuses_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2039: THEN
2040: x_okc_statuses_tl_rec.last_update_login := l_okc_statuses_tl_rec.last_update_login;
2041: END IF;
2042: RETURN(l_return_status);
2043: END populate_new_record;
2044: ----------------------------------------

Line 2045: -- Set_Attributes for:OKC_STATUSES_TL --

2041: END IF;
2042: RETURN(l_return_status);
2043: END populate_new_record;
2044: ----------------------------------------
2045: -- Set_Attributes for:OKC_STATUSES_TL --
2046: ----------------------------------------
2047: FUNCTION Set_Attributes (
2048: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
2049: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type

Line 2048: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,

2044: ----------------------------------------
2045: -- Set_Attributes for:OKC_STATUSES_TL --
2046: ----------------------------------------
2047: FUNCTION Set_Attributes (
2048: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
2049: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
2050: ) RETURN VARCHAR2 IS
2051: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2052: BEGIN

Line 2049: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type

2045: -- Set_Attributes for:OKC_STATUSES_TL --
2046: ----------------------------------------
2047: FUNCTION Set_Attributes (
2048: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
2049: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
2050: ) RETURN VARCHAR2 IS
2051: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2052: BEGIN
2053: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;

Line 2053: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;

2049: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
2050: ) RETURN VARCHAR2 IS
2051: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2052: BEGIN
2053: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;
2054: x_okc_statuses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2055: x_okc_statuses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2056: RETURN(l_return_status);
2057: END Set_Attributes;

Line 2054: x_okc_statuses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2050: ) RETURN VARCHAR2 IS
2051: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2052: BEGIN
2053: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;
2054: x_okc_statuses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2055: x_okc_statuses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2056: RETURN(l_return_status);
2057: END Set_Attributes;
2058: BEGIN

Line 2055: x_okc_statuses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

2051: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2052: BEGIN
2053: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;
2054: x_okc_statuses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2055: x_okc_statuses_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2056: RETURN(l_return_status);
2057: END Set_Attributes;
2058: BEGIN
2059: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2070: p_okc_statuses_tl_rec, -- IN

2066: RAISE OKC_API.G_EXCEPTION_ERROR;
2067: END IF;
2068: --- Setting item attributes
2069: l_return_status := Set_Attributes(
2070: p_okc_statuses_tl_rec, -- IN
2071: l_okc_statuses_tl_rec); -- OUT
2072: --- If any errors happen abort API
2073: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2074: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2071: l_okc_statuses_tl_rec); -- OUT

2067: END IF;
2068: --- Setting item attributes
2069: l_return_status := Set_Attributes(
2070: p_okc_statuses_tl_rec, -- IN
2071: l_okc_statuses_tl_rec); -- OUT
2072: --- If any errors happen abort API
2073: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2074: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2075: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2078: l_return_status := populate_new_record(l_okc_statuses_tl_rec, l_def_okc_statuses_tl_rec);

2074: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2075: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2076: RAISE OKC_API.G_EXCEPTION_ERROR;
2077: END IF;
2078: l_return_status := populate_new_record(l_okc_statuses_tl_rec, l_def_okc_statuses_tl_rec);
2079: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2080: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2081: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2082: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2084: UPDATE OKC_STATUSES_TL

2080: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2081: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2082: RAISE OKC_API.G_EXCEPTION_ERROR;
2083: END IF;
2084: UPDATE OKC_STATUSES_TL
2085: SET MEANING = l_def_okc_statuses_tl_rec.meaning,
2086: DESCRIPTION = l_def_okc_statuses_tl_rec.description,
2087: CREATED_BY = l_def_okc_statuses_tl_rec.created_by,
2088: CREATION_DATE = l_def_okc_statuses_tl_rec.creation_date,

Line 2085: SET MEANING = l_def_okc_statuses_tl_rec.meaning,

2081: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2082: RAISE OKC_API.G_EXCEPTION_ERROR;
2083: END IF;
2084: UPDATE OKC_STATUSES_TL
2085: SET MEANING = l_def_okc_statuses_tl_rec.meaning,
2086: DESCRIPTION = l_def_okc_statuses_tl_rec.description,
2087: CREATED_BY = l_def_okc_statuses_tl_rec.created_by,
2088: CREATION_DATE = l_def_okc_statuses_tl_rec.creation_date,
2089: LAST_UPDATED_BY = l_def_okc_statuses_tl_rec.last_updated_by,

Line 2086: DESCRIPTION = l_def_okc_statuses_tl_rec.description,

2082: RAISE OKC_API.G_EXCEPTION_ERROR;
2083: END IF;
2084: UPDATE OKC_STATUSES_TL
2085: SET MEANING = l_def_okc_statuses_tl_rec.meaning,
2086: DESCRIPTION = l_def_okc_statuses_tl_rec.description,
2087: CREATED_BY = l_def_okc_statuses_tl_rec.created_by,
2088: CREATION_DATE = l_def_okc_statuses_tl_rec.creation_date,
2089: LAST_UPDATED_BY = l_def_okc_statuses_tl_rec.last_updated_by,
2090: LAST_UPDATE_DATE = l_def_okc_statuses_tl_rec.last_update_date,

Line 2087: CREATED_BY = l_def_okc_statuses_tl_rec.created_by,

2083: END IF;
2084: UPDATE OKC_STATUSES_TL
2085: SET MEANING = l_def_okc_statuses_tl_rec.meaning,
2086: DESCRIPTION = l_def_okc_statuses_tl_rec.description,
2087: CREATED_BY = l_def_okc_statuses_tl_rec.created_by,
2088: CREATION_DATE = l_def_okc_statuses_tl_rec.creation_date,
2089: LAST_UPDATED_BY = l_def_okc_statuses_tl_rec.last_updated_by,
2090: LAST_UPDATE_DATE = l_def_okc_statuses_tl_rec.last_update_date,
2091: LAST_UPDATE_LOGIN = l_def_okc_statuses_tl_rec.last_update_login

Line 2088: CREATION_DATE = l_def_okc_statuses_tl_rec.creation_date,

2084: UPDATE OKC_STATUSES_TL
2085: SET MEANING = l_def_okc_statuses_tl_rec.meaning,
2086: DESCRIPTION = l_def_okc_statuses_tl_rec.description,
2087: CREATED_BY = l_def_okc_statuses_tl_rec.created_by,
2088: CREATION_DATE = l_def_okc_statuses_tl_rec.creation_date,
2089: LAST_UPDATED_BY = l_def_okc_statuses_tl_rec.last_updated_by,
2090: LAST_UPDATE_DATE = l_def_okc_statuses_tl_rec.last_update_date,
2091: LAST_UPDATE_LOGIN = l_def_okc_statuses_tl_rec.last_update_login
2092: WHERE CODE = l_def_okc_statuses_tl_rec.code

Line 2089: LAST_UPDATED_BY = l_def_okc_statuses_tl_rec.last_updated_by,

2085: SET MEANING = l_def_okc_statuses_tl_rec.meaning,
2086: DESCRIPTION = l_def_okc_statuses_tl_rec.description,
2087: CREATED_BY = l_def_okc_statuses_tl_rec.created_by,
2088: CREATION_DATE = l_def_okc_statuses_tl_rec.creation_date,
2089: LAST_UPDATED_BY = l_def_okc_statuses_tl_rec.last_updated_by,
2090: LAST_UPDATE_DATE = l_def_okc_statuses_tl_rec.last_update_date,
2091: LAST_UPDATE_LOGIN = l_def_okc_statuses_tl_rec.last_update_login
2092: WHERE CODE = l_def_okc_statuses_tl_rec.code
2093: AND SOURCE_LANG = USERENV('LANG');

Line 2090: LAST_UPDATE_DATE = l_def_okc_statuses_tl_rec.last_update_date,

2086: DESCRIPTION = l_def_okc_statuses_tl_rec.description,
2087: CREATED_BY = l_def_okc_statuses_tl_rec.created_by,
2088: CREATION_DATE = l_def_okc_statuses_tl_rec.creation_date,
2089: LAST_UPDATED_BY = l_def_okc_statuses_tl_rec.last_updated_by,
2090: LAST_UPDATE_DATE = l_def_okc_statuses_tl_rec.last_update_date,
2091: LAST_UPDATE_LOGIN = l_def_okc_statuses_tl_rec.last_update_login
2092: WHERE CODE = l_def_okc_statuses_tl_rec.code
2093: AND SOURCE_LANG = USERENV('LANG');
2094:

Line 2091: LAST_UPDATE_LOGIN = l_def_okc_statuses_tl_rec.last_update_login

2087: CREATED_BY = l_def_okc_statuses_tl_rec.created_by,
2088: CREATION_DATE = l_def_okc_statuses_tl_rec.creation_date,
2089: LAST_UPDATED_BY = l_def_okc_statuses_tl_rec.last_updated_by,
2090: LAST_UPDATE_DATE = l_def_okc_statuses_tl_rec.last_update_date,
2091: LAST_UPDATE_LOGIN = l_def_okc_statuses_tl_rec.last_update_login
2092: WHERE CODE = l_def_okc_statuses_tl_rec.code
2093: AND SOURCE_LANG = USERENV('LANG');
2094:
2095: UPDATE OKC_STATUSES_TL

Line 2092: WHERE CODE = l_def_okc_statuses_tl_rec.code

2088: CREATION_DATE = l_def_okc_statuses_tl_rec.creation_date,
2089: LAST_UPDATED_BY = l_def_okc_statuses_tl_rec.last_updated_by,
2090: LAST_UPDATE_DATE = l_def_okc_statuses_tl_rec.last_update_date,
2091: LAST_UPDATE_LOGIN = l_def_okc_statuses_tl_rec.last_update_login
2092: WHERE CODE = l_def_okc_statuses_tl_rec.code
2093: AND SOURCE_LANG = USERENV('LANG');
2094:
2095: UPDATE OKC_STATUSES_TL
2096: SET SFWT_FLAG = 'Y'

Line 2095: UPDATE OKC_STATUSES_TL

2091: LAST_UPDATE_LOGIN = l_def_okc_statuses_tl_rec.last_update_login
2092: WHERE CODE = l_def_okc_statuses_tl_rec.code
2093: AND SOURCE_LANG = USERENV('LANG');
2094:
2095: UPDATE OKC_STATUSES_TL
2096: SET SFWT_FLAG = 'Y'
2097: WHERE CODE = l_def_okc_statuses_tl_rec.code
2098: AND SOURCE_LANG <> USERENV('LANG');
2099:

Line 2097: WHERE CODE = l_def_okc_statuses_tl_rec.code

2093: AND SOURCE_LANG = USERENV('LANG');
2094:
2095: UPDATE OKC_STATUSES_TL
2096: SET SFWT_FLAG = 'Y'
2097: WHERE CODE = l_def_okc_statuses_tl_rec.code
2098: AND SOURCE_LANG <> USERENV('LANG');
2099:
2100: x_okc_statuses_tl_rec := l_def_okc_statuses_tl_rec;
2101: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2100: x_okc_statuses_tl_rec := l_def_okc_statuses_tl_rec;

2096: SET SFWT_FLAG = 'Y'
2097: WHERE CODE = l_def_okc_statuses_tl_rec.code
2098: AND SOURCE_LANG <> USERENV('LANG');
2099:
2100: x_okc_statuses_tl_rec := l_def_okc_statuses_tl_rec;
2101: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2102: EXCEPTION
2103: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2104: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2151: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;

2147: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2148: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2149: l_stsv_rec stsv_rec_type := p_stsv_rec;
2150: l_def_stsv_rec stsv_rec_type;
2151: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
2152: lx_okc_statuses_tl_rec okc_statuses_tl_rec_type;
2153: l_sts_rec sts_rec_type;
2154: lx_sts_rec sts_rec_type;
2155: -------------------------------

Line 2152: lx_okc_statuses_tl_rec okc_statuses_tl_rec_type;

2148: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2149: l_stsv_rec stsv_rec_type := p_stsv_rec;
2150: l_def_stsv_rec stsv_rec_type;
2151: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
2152: lx_okc_statuses_tl_rec okc_statuses_tl_rec_type;
2153: l_sts_rec sts_rec_type;
2154: lx_sts_rec sts_rec_type;
2155: -------------------------------
2156: -- FUNCTION fill_who_columns --

Line 2309: migrate(l_def_stsv_rec, l_okc_statuses_tl_rec);

2305: END IF;
2306: --------------------------------------
2307: -- Move VIEW record to "Child" records
2308: --------------------------------------
2309: migrate(l_def_stsv_rec, l_okc_statuses_tl_rec);
2310: migrate(l_def_stsv_rec, l_sts_rec);
2311: --------------------------------------------
2312: -- Call the UPDATE_ROW for each child record
2313: --------------------------------------------

Line 2319: l_okc_statuses_tl_rec,

2315: p_init_msg_list,
2316: x_return_status,
2317: x_msg_count,
2318: x_msg_data,
2319: l_okc_statuses_tl_rec,
2320: lx_okc_statuses_tl_rec
2321: );
2322: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2320: lx_okc_statuses_tl_rec

2316: x_return_status,
2317: x_msg_count,
2318: x_msg_data,
2319: l_okc_statuses_tl_rec,
2320: lx_okc_statuses_tl_rec
2321: );
2322: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2324: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2327: migrate(lx_okc_statuses_tl_rec, l_def_stsv_rec);

2323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2324: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2325: RAISE OKC_API.G_EXCEPTION_ERROR;
2326: END IF;
2327: migrate(lx_okc_statuses_tl_rec, l_def_stsv_rec);
2328: update_row(
2329: p_init_msg_list,
2330: x_return_status,
2331: x_msg_count,

Line 2508: -- delete_row for:OKC_STATUSES_TL --

2504: '_PVT'
2505: );
2506: END delete_row;
2507: ------------------------------------
2508: -- delete_row for:OKC_STATUSES_TL --
2509: ------------------------------------
2510: PROCEDURE delete_row(
2511: p_init_msg_list IN VARCHAR2,
2512: x_return_status OUT NOCOPY VARCHAR2,

Line 2515: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type) IS

2511: p_init_msg_list IN VARCHAR2,
2512: x_return_status OUT NOCOPY VARCHAR2,
2513: x_msg_count OUT NOCOPY NUMBER,
2514: x_msg_data OUT NOCOPY VARCHAR2,
2515: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type) IS
2516:
2517: l_api_version CONSTANT NUMBER := 1;
2518: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2520: l_okc_statuses_tl_rec okc_statuses_tl_rec_type:= p_okc_statuses_tl_rec;

2516:
2517: l_api_version CONSTANT NUMBER := 1;
2518: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2520: l_okc_statuses_tl_rec okc_statuses_tl_rec_type:= p_okc_statuses_tl_rec;
2521: l_row_notfound BOOLEAN := TRUE;
2522: ----------------------------------------
2523: -- Set_Attributes for:OKC_STATUSES_TL --
2524: ----------------------------------------

Line 2523: -- Set_Attributes for:OKC_STATUSES_TL --

2519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2520: l_okc_statuses_tl_rec okc_statuses_tl_rec_type:= p_okc_statuses_tl_rec;
2521: l_row_notfound BOOLEAN := TRUE;
2522: ----------------------------------------
2523: -- Set_Attributes for:OKC_STATUSES_TL --
2524: ----------------------------------------
2525: FUNCTION Set_Attributes (
2526: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
2527: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type

Line 2526: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,

2522: ----------------------------------------
2523: -- Set_Attributes for:OKC_STATUSES_TL --
2524: ----------------------------------------
2525: FUNCTION Set_Attributes (
2526: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
2527: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
2528: ) RETURN VARCHAR2 IS
2529: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2530: BEGIN

Line 2527: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type

2523: -- Set_Attributes for:OKC_STATUSES_TL --
2524: ----------------------------------------
2525: FUNCTION Set_Attributes (
2526: p_okc_statuses_tl_rec IN okc_statuses_tl_rec_type,
2527: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
2528: ) RETURN VARCHAR2 IS
2529: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2530: BEGIN
2531: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;

Line 2531: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;

2527: x_okc_statuses_tl_rec OUT NOCOPY okc_statuses_tl_rec_type
2528: ) RETURN VARCHAR2 IS
2529: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2530: BEGIN
2531: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;
2532: x_okc_statuses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2533: RETURN(l_return_status);
2534: END Set_Attributes;
2535: BEGIN

Line 2532: x_okc_statuses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2528: ) RETURN VARCHAR2 IS
2529: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2530: BEGIN
2531: x_okc_statuses_tl_rec := p_okc_statuses_tl_rec;
2532: x_okc_statuses_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2533: RETURN(l_return_status);
2534: END Set_Attributes;
2535: BEGIN
2536: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2547: p_okc_statuses_tl_rec, -- IN

2543: RAISE OKC_API.G_EXCEPTION_ERROR;
2544: END IF;
2545: --- Setting item attributes
2546: l_return_status := Set_Attributes(
2547: p_okc_statuses_tl_rec, -- IN
2548: l_okc_statuses_tl_rec); -- OUT
2549: --- If any errors happen abort API
2550: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2551: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2548: l_okc_statuses_tl_rec); -- OUT

2544: END IF;
2545: --- Setting item attributes
2546: l_return_status := Set_Attributes(
2547: p_okc_statuses_tl_rec, -- IN
2548: l_okc_statuses_tl_rec); -- OUT
2549: --- If any errors happen abort API
2550: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2551: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2552: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2555: DELETE FROM OKC_STATUSES_TL

2551: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2552: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2553: RAISE OKC_API.G_EXCEPTION_ERROR;
2554: END IF;
2555: DELETE FROM OKC_STATUSES_TL
2556: WHERE CODE = l_okc_statuses_tl_rec.code;
2557:
2558: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2559: EXCEPTION

Line 2556: WHERE CODE = l_okc_statuses_tl_rec.code;

2552: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2553: RAISE OKC_API.G_EXCEPTION_ERROR;
2554: END IF;
2555: DELETE FROM OKC_STATUSES_TL
2556: WHERE CODE = l_okc_statuses_tl_rec.code;
2557:
2558: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2559: EXCEPTION
2560: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2606: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;

2602: l_api_version CONSTANT NUMBER := 1;
2603: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2604: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2605: l_stsv_rec stsv_rec_type := p_stsv_rec;
2606: l_okc_statuses_tl_rec okc_statuses_tl_rec_type;
2607: l_sts_rec sts_rec_type;
2608: BEGIN
2609: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2610: G_PKG_NAME,

Line 2624: migrate(l_stsv_rec, l_okc_statuses_tl_rec);

2620: END IF;
2621: --------------------------------------
2622: -- Move VIEW record to "Child" records
2623: --------------------------------------
2624: migrate(l_stsv_rec, l_okc_statuses_tl_rec);
2625: migrate(l_stsv_rec, l_sts_rec);
2626: --------------------------------------------
2627: -- Call the DELETE_ROW for each child record
2628: --------------------------------------------

Line 2634: l_okc_statuses_tl_rec

2630: p_init_msg_list,
2631: x_return_status,
2632: x_msg_count,
2633: x_msg_data,
2634: l_okc_statuses_tl_rec
2635: );
2636: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2637: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2638: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN