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_TAL_PVT dependencies on OKC_TIMEVALUES

Line 38: -- FUNCTION get_rec for: OKC_TIMEVALUES_B

34: null;
35: END api_copy;
36:
37: ---------------------------------------------------------------------------
38: -- FUNCTION get_rec for: OKC_TIMEVALUES_B
39: ---------------------------------------------------------------------------
40: FUNCTION get_rec (
41: p_tve_rec IN tve_rec_type,
42: x_no_data_found OUT NOCOPY BOOLEAN

Line 98: FROM Okc_Timevalues

94: ATTRIBUTE12,
95: ATTRIBUTE13,
96: ATTRIBUTE14,
97: ATTRIBUTE15
98: FROM Okc_Timevalues
99: WHERE okc_timevalues.id = p_id;
100: l_tve_pk tve_pk_csr%ROWTYPE;
101: l_tve_rec tve_rec_type;
102: BEGIN

Line 99: WHERE okc_timevalues.id = p_id;

95: ATTRIBUTE13,
96: ATTRIBUTE14,
97: ATTRIBUTE15
98: FROM Okc_Timevalues
99: WHERE okc_timevalues.id = p_id;
100: l_tve_pk tve_pk_csr%ROWTYPE;
101: l_tve_rec tve_rec_type;
102: BEGIN
103: x_no_data_found := TRUE;

Line 172: -- FUNCTION get_rec for: OKC_TIMEVALUES_TL

168: BEGIN
169: RETURN(get_rec(p_tve_rec, l_row_notfound));
170: END get_rec;
171: ---------------------------------------------------------------------------
172: -- FUNCTION get_rec for: OKC_TIMEVALUES_TL
173: ---------------------------------------------------------------------------
174: --Bug 3122962
175: /*
176: FUNCTION get_rec (

Line 177: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

173: ---------------------------------------------------------------------------
174: --Bug 3122962
175: /*
176: FUNCTION get_rec (
177: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
178: x_no_data_found OUT NOCOPY BOOLEAN
179: ) RETURN okc_timevalues_tl_rec_type IS
180: CURSOR tve_pktl_csr (p_id IN NUMBER,
181: p_language IN VARCHAR2) IS

Line 179: ) RETURN okc_timevalues_tl_rec_type IS

175: /*
176: FUNCTION get_rec (
177: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
178: x_no_data_found OUT NOCOPY BOOLEAN
179: ) RETURN okc_timevalues_tl_rec_type IS
180: CURSOR tve_pktl_csr (p_id IN NUMBER,
181: p_language IN VARCHAR2) IS
182: SELECT
183: ID,

Line 196: FROM Okc_Timevalues_Tl

192: CREATION_DATE,
193: LAST_UPDATED_BY,
194: LAST_UPDATE_DATE,
195: LAST_UPDATE_LOGIN
196: FROM Okc_Timevalues_Tl
197: WHERE okc_timevalues_tl.id = p_id
198: AND okc_timevalues_tl.language = p_language;
199: l_tve_pktl tve_pktl_csr%ROWTYPE;
200: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

Line 197: WHERE okc_timevalues_tl.id = p_id

193: LAST_UPDATED_BY,
194: LAST_UPDATE_DATE,
195: LAST_UPDATE_LOGIN
196: FROM Okc_Timevalues_Tl
197: WHERE okc_timevalues_tl.id = p_id
198: AND okc_timevalues_tl.language = p_language;
199: l_tve_pktl tve_pktl_csr%ROWTYPE;
200: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
201: BEGIN

Line 198: AND okc_timevalues_tl.language = p_language;

194: LAST_UPDATE_DATE,
195: LAST_UPDATE_LOGIN
196: FROM Okc_Timevalues_Tl
197: WHERE okc_timevalues_tl.id = p_id
198: AND okc_timevalues_tl.language = p_language;
199: l_tve_pktl tve_pktl_csr%ROWTYPE;
200: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
201: BEGIN
202: x_no_data_found := TRUE;

Line 200: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

196: FROM Okc_Timevalues_Tl
197: WHERE okc_timevalues_tl.id = p_id
198: AND okc_timevalues_tl.language = p_language;
199: l_tve_pktl tve_pktl_csr%ROWTYPE;
200: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
201: BEGIN
202: x_no_data_found := TRUE;
203: -- Get current database values
204: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,

Line 204: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,

200: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
201: BEGIN
202: x_no_data_found := TRUE;
203: -- Get current database values
204: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,
205: p_okc_timevalues_tl_rec.language);
206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,

Line 205: p_okc_timevalues_tl_rec.language);

201: BEGIN
202: x_no_data_found := TRUE;
203: -- Get current database values
204: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,
205: p_okc_timevalues_tl_rec.language);
206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,

Line 207: l_okc_timevalues_tl_rec.ID,

203: -- Get current database values
204: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,
205: p_okc_timevalues_tl_rec.language);
206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,

Line 208: l_okc_timevalues_tl_rec.LANGUAGE,

204: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,
205: p_okc_timevalues_tl_rec.language);
206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,

Line 209: l_okc_timevalues_tl_rec.SOURCE_LANG,

205: p_okc_timevalues_tl_rec.language);
206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,

Line 210: l_okc_timevalues_tl_rec.SFWT_FLAG,

206: FETCH tve_pktl_csr INTO
207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,

Line 211: l_okc_timevalues_tl_rec.DESCRIPTION,

207: l_okc_timevalues_tl_rec.ID,
208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,

Line 212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,

208: l_okc_timevalues_tl_rec.LANGUAGE,
209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,

Line 213: l_okc_timevalues_tl_rec.COMMENTS,

209: l_okc_timevalues_tl_rec.SOURCE_LANG,
210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,

Line 214: l_okc_timevalues_tl_rec.NAME,

210: l_okc_timevalues_tl_rec.SFWT_FLAG,
211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,

Line 215: l_okc_timevalues_tl_rec.CREATED_BY,

211: l_okc_timevalues_tl_rec.DESCRIPTION,
212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;

Line 216: l_okc_timevalues_tl_rec.CREATION_DATE,

212: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,
213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;
220: x_no_data_found := tve_pktl_csr%NOTFOUND;

Line 217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,

213: l_okc_timevalues_tl_rec.COMMENTS,
214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;
220: x_no_data_found := tve_pktl_csr%NOTFOUND;
221: CLOSE tve_pktl_csr;

Line 218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,

214: l_okc_timevalues_tl_rec.NAME,
215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;
220: x_no_data_found := tve_pktl_csr%NOTFOUND;
221: CLOSE tve_pktl_csr;
222: RETURN(l_okc_timevalues_tl_rec);

Line 219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;

215: l_okc_timevalues_tl_rec.CREATED_BY,
216: l_okc_timevalues_tl_rec.CREATION_DATE,
217: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,
218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;
220: x_no_data_found := tve_pktl_csr%NOTFOUND;
221: CLOSE tve_pktl_csr;
222: RETURN(l_okc_timevalues_tl_rec);
223: END get_rec;

Line 222: RETURN(l_okc_timevalues_tl_rec);

218: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,
219: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;
220: x_no_data_found := tve_pktl_csr%NOTFOUND;
221: CLOSE tve_pktl_csr;
222: RETURN(l_okc_timevalues_tl_rec);
223: END get_rec;
224:
225: FUNCTION get_rec (
226: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type

Line 226: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type

222: RETURN(l_okc_timevalues_tl_rec);
223: END get_rec;
224:
225: FUNCTION get_rec (
226: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type
227: ) RETURN okc_timevalues_tl_rec_type IS
228: l_row_notfound BOOLEAN := TRUE;
229: BEGIN
230: RETURN(get_rec(p_okc_timevalues_tl_rec, l_row_notfound));

Line 227: ) RETURN okc_timevalues_tl_rec_type IS

223: END get_rec;
224:
225: FUNCTION get_rec (
226: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type
227: ) RETURN okc_timevalues_tl_rec_type IS
228: l_row_notfound BOOLEAN := TRUE;
229: BEGIN
230: RETURN(get_rec(p_okc_timevalues_tl_rec, l_row_notfound));
231: END get_rec;

Line 230: RETURN(get_rec(p_okc_timevalues_tl_rec, l_row_notfound));

226: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type
227: ) RETURN okc_timevalues_tl_rec_type IS
228: l_row_notfound BOOLEAN := TRUE;
229: BEGIN
230: RETURN(get_rec(p_okc_timevalues_tl_rec, l_row_notfound));
231: END get_rec;
232: */
233: ---------------------------------------------------------------------------
234: -- FUNCTION get_rec for: OKC_TIME_TPA_RELATIVE_V

Line 457: -- FUNCTION null_out_defaults for: OKC_TIMEVALUES_V --

453: END null_out_defaults;
454:
455: --**** Change from TAPI Code---follow till end of change---------------
456: ------------------------------------------------------
457: -- FUNCTION null_out_defaults for: OKC_TIMEVALUES_V --
458: ------------------------------------------------------
459: -- 1. Added null_out_defaults to overcome number initialization
460: -- problem while populating optional columns for supertypes from a subtype
461: -- 2. Moved all column validations (including FK) to Validate_column

Line 528: p_tve_tl_rec IN okc_timevalues_tl_rec_type

524: END null_out_defaults;
525: --Bug 3122962
526: /*
527: FUNCTION null_out_defaults (
528: p_tve_tl_rec IN okc_timevalues_tl_rec_type
529: ) RETURN okc_timevalues_tl_rec_type IS
530: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
531: BEGIN
532: IF (l_tve_tl_rec.name = OKC_API.G_MISS_CHAR) THEN

Line 529: ) RETURN okc_timevalues_tl_rec_type IS

525: --Bug 3122962
526: /*
527: FUNCTION null_out_defaults (
528: p_tve_tl_rec IN okc_timevalues_tl_rec_type
529: ) RETURN okc_timevalues_tl_rec_type IS
530: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
531: BEGIN
532: IF (l_tve_tl_rec.name = OKC_API.G_MISS_CHAR) THEN
533: l_tve_tl_rec.name := NULL;

Line 530: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;

526: /*
527: FUNCTION null_out_defaults (
528: p_tve_tl_rec IN okc_timevalues_tl_rec_type
529: ) RETURN okc_timevalues_tl_rec_type IS
530: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
531: BEGIN
532: IF (l_tve_tl_rec.name = OKC_API.G_MISS_CHAR) THEN
533: l_tve_tl_rec.name := NULL;
534: END IF;

Line 720: FROM Okc_Timevalues

716: item_not_found_error EXCEPTION;
717: l_row_notfound BOOLEAN := TRUE;
718: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
719: SELECT '1'
720: FROM Okc_Timevalues
721: WHERE id = p_id;
722: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
723: BEGIN
724: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 764: FROM Okc_Timevalues

760: item_not_found_error EXCEPTION;
761: l_row_notfound BOOLEAN := TRUE;
762: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
763: SELECT '1'
764: FROM Okc_Timevalues
765: WHERE id = p_id
766: and tve_type in ('ISE','IGS');
767: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
768: BEGIN

Line 1173: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type

1169: --Bug 3122962
1170: /*
1171: PROCEDURE migrate (
1172: p_from IN talv_rec_type,
1173: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
1174: ) IS
1175: l_tve_tl_type okc_timevalues_tl_rec_type;
1176: BEGIN
1177: p_to.id := p_from.id;

Line 1175: l_tve_tl_type okc_timevalues_tl_rec_type;

1171: PROCEDURE migrate (
1172: p_from IN talv_rec_type,
1173: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
1174: ) IS
1175: l_tve_tl_type okc_timevalues_tl_rec_type;
1176: BEGIN
1177: p_to.id := p_from.id;
1178: p_to.sfwt_flag := p_from.sfwt_flag;
1179: p_to.description := p_from.description;

Line 1193: p_from IN okc_timevalues_tl_rec_type,

1189: l_tve_tl_type := null_out_defaults(p_to);
1190: p_to := l_tve_tl_type;
1191: END migrate;
1192: PROCEDURE migrate (
1193: p_from IN okc_timevalues_tl_rec_type,
1194: p_to IN OUT NOCOPY talv_rec_type
1195: ) IS
1196: BEGIN
1197: p_to.id := p_from.id;

Line 1228: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1224: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1225: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1226: l_talv_rec talv_rec_type := p_talv_rec;
1227: l_tve_rec tve_rec_type;
1228: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1229: BEGIN
1230: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1231: G_PKG_NAME,
1232: p_init_msg_list,

Line 1357: -- insert_row for:OKC_TIMEVALUES_B --

1353: ---------------------------------------------------------------------------
1354: -- PROCEDURE insert_row
1355: ---------------------------------------------------------------------------
1356: -------------------------------------
1357: -- insert_row for:OKC_TIMEVALUES_B --
1358: -------------------------------------
1359: PROCEDURE insert_row(
1360: p_init_msg_list IN VARCHAR2,
1361: x_return_status OUT NOCOPY VARCHAR2,

Line 1373: -- Set_Attributes for:OKC_TIMEVALUES_B --

1369: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1370: l_tve_rec tve_rec_type := p_tve_rec;
1371: l_def_tve_rec tve_rec_type;
1372: -----------------------------------------
1373: -- Set_Attributes for:OKC_TIMEVALUES_B --
1374: -----------------------------------------
1375: FUNCTION Set_Attributes (
1376: p_tve_rec IN tve_rec_type,
1377: x_tve_rec OUT NOCOPY tve_rec_type

Line 1404: INSERT INTO OKC_TIMEVALUES(

1400: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1401: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_ERROR;
1403: END IF;
1404: INSERT INTO OKC_TIMEVALUES(
1405: id,
1406: spn_id,
1407: tve_id_offset,
1408: dnz_chr_id,

Line 1546: -- insert_row for:OKC_TIMEVALUES_TL --

1542: '_PVT'
1543: );
1544: END insert_row;
1545: --------------------------------------
1546: -- insert_row for:OKC_TIMEVALUES_TL --
1547: --------------------------------------
1548: /*
1549: PROCEDURE insert_row(
1550: p_init_msg_list IN VARCHAR2,

Line 1554: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1550: p_init_msg_list IN VARCHAR2,
1551: x_return_status OUT NOCOPY VARCHAR2,
1552: x_msg_count OUT NOCOPY NUMBER,
1553: x_msg_data OUT NOCOPY VARCHAR2,
1554: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1555: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1556:
1557: l_api_version CONSTANT NUMBER := 1;
1558: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1555: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

1551: x_return_status OUT NOCOPY VARCHAR2,
1552: x_msg_count OUT NOCOPY NUMBER,
1553: x_msg_data OUT NOCOPY VARCHAR2,
1554: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1555: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1556:
1557: l_api_version CONSTANT NUMBER := 1;
1558: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1559: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1560: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

1556:
1557: l_api_version CONSTANT NUMBER := 1;
1558: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1559: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1560: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1561: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1562: CURSOR get_languages IS
1563: SELECT *
1564: FROM FND_LANGUAGES

Line 1561: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1557: l_api_version CONSTANT NUMBER := 1;
1558: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1559: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1560: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1561: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1562: CURSOR get_languages IS
1563: SELECT *
1564: FROM FND_LANGUAGES
1565: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1567: -- Set_Attributes for:OKC_TIMEVALUES_TL --

1563: SELECT *
1564: FROM FND_LANGUAGES
1565: WHERE INSTALLED_FLAG IN ('I', 'B');
1566: ------------------------------------------
1567: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1568: ------------------------------------------
1569: FUNCTION Set_Attributes (
1570: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1571: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 1570: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1566: ------------------------------------------
1567: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1568: ------------------------------------------
1569: FUNCTION Set_Attributes (
1570: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1571: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1572: ) RETURN VARCHAR2 IS
1573: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1574: BEGIN

Line 1571: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

1567: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1568: ------------------------------------------
1569: FUNCTION Set_Attributes (
1570: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1571: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1572: ) RETURN VARCHAR2 IS
1573: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1574: BEGIN
1575: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 1575: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

1571: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1572: ) RETURN VARCHAR2 IS
1573: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1574: BEGIN
1575: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1576: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1577: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1578: RETURN(l_return_status);
1579: END Set_Attributes;

Line 1576: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

1572: ) RETURN VARCHAR2 IS
1573: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1574: BEGIN
1575: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1576: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1577: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1578: RETURN(l_return_status);
1579: END Set_Attributes;
1580: BEGIN

Line 1577: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

1573: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1574: BEGIN
1575: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1576: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1577: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1578: RETURN(l_return_status);
1579: END Set_Attributes;
1580: BEGIN
1581: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1592: p_okc_timevalues_tl_rec, -- IN

1588: RAISE OKC_API.G_EXCEPTION_ERROR;
1589: END IF;
1590: --- Setting item attributes
1591: l_return_status := Set_Attributes(
1592: p_okc_timevalues_tl_rec, -- IN
1593: l_okc_timevalues_tl_rec); -- OUT
1594: --- If any errors happen abort API
1595: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1596: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1593: l_okc_timevalues_tl_rec); -- OUT

1589: END IF;
1590: --- Setting item attributes
1591: l_return_status := Set_Attributes(
1592: p_okc_timevalues_tl_rec, -- IN
1593: l_okc_timevalues_tl_rec); -- OUT
1594: --- If any errors happen abort API
1595: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1596: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1597: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1601: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;

1597: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1598: RAISE OKC_API.G_EXCEPTION_ERROR;
1599: END IF;
1600: FOR l_lang_rec IN get_languages LOOP
1601: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1602: INSERT INTO OKC_TIMEVALUES_TL(
1603: id,
1604: language,
1605: source_lang,

Line 1602: INSERT INTO OKC_TIMEVALUES_TL(

1598: RAISE OKC_API.G_EXCEPTION_ERROR;
1599: END IF;
1600: FOR l_lang_rec IN get_languages LOOP
1601: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1602: INSERT INTO OKC_TIMEVALUES_TL(
1603: id,
1604: language,
1605: source_lang,
1606: sfwt_flag,

Line 1617: l_okc_timevalues_tl_rec.id,

1613: last_updated_by,
1614: last_update_date,
1615: last_update_login)
1616: VALUES (
1617: l_okc_timevalues_tl_rec.id,
1618: l_okc_timevalues_tl_rec.language,
1619: l_okc_timevalues_tl_rec.source_lang,
1620: l_okc_timevalues_tl_rec.sfwt_flag,
1621: l_okc_timevalues_tl_rec.description,

Line 1618: l_okc_timevalues_tl_rec.language,

1614: last_update_date,
1615: last_update_login)
1616: VALUES (
1617: l_okc_timevalues_tl_rec.id,
1618: l_okc_timevalues_tl_rec.language,
1619: l_okc_timevalues_tl_rec.source_lang,
1620: l_okc_timevalues_tl_rec.sfwt_flag,
1621: l_okc_timevalues_tl_rec.description,
1622: l_okc_timevalues_tl_rec.short_description,

Line 1619: l_okc_timevalues_tl_rec.source_lang,

1615: last_update_login)
1616: VALUES (
1617: l_okc_timevalues_tl_rec.id,
1618: l_okc_timevalues_tl_rec.language,
1619: l_okc_timevalues_tl_rec.source_lang,
1620: l_okc_timevalues_tl_rec.sfwt_flag,
1621: l_okc_timevalues_tl_rec.description,
1622: l_okc_timevalues_tl_rec.short_description,
1623: l_okc_timevalues_tl_rec.comments,

Line 1620: l_okc_timevalues_tl_rec.sfwt_flag,

1616: VALUES (
1617: l_okc_timevalues_tl_rec.id,
1618: l_okc_timevalues_tl_rec.language,
1619: l_okc_timevalues_tl_rec.source_lang,
1620: l_okc_timevalues_tl_rec.sfwt_flag,
1621: l_okc_timevalues_tl_rec.description,
1622: l_okc_timevalues_tl_rec.short_description,
1623: l_okc_timevalues_tl_rec.comments,
1624: l_okc_timevalues_tl_rec.name,

Line 1621: l_okc_timevalues_tl_rec.description,

1617: l_okc_timevalues_tl_rec.id,
1618: l_okc_timevalues_tl_rec.language,
1619: l_okc_timevalues_tl_rec.source_lang,
1620: l_okc_timevalues_tl_rec.sfwt_flag,
1621: l_okc_timevalues_tl_rec.description,
1622: l_okc_timevalues_tl_rec.short_description,
1623: l_okc_timevalues_tl_rec.comments,
1624: l_okc_timevalues_tl_rec.name,
1625: l_okc_timevalues_tl_rec.created_by,

Line 1622: l_okc_timevalues_tl_rec.short_description,

1618: l_okc_timevalues_tl_rec.language,
1619: l_okc_timevalues_tl_rec.source_lang,
1620: l_okc_timevalues_tl_rec.sfwt_flag,
1621: l_okc_timevalues_tl_rec.description,
1622: l_okc_timevalues_tl_rec.short_description,
1623: l_okc_timevalues_tl_rec.comments,
1624: l_okc_timevalues_tl_rec.name,
1625: l_okc_timevalues_tl_rec.created_by,
1626: l_okc_timevalues_tl_rec.creation_date,

Line 1623: l_okc_timevalues_tl_rec.comments,

1619: l_okc_timevalues_tl_rec.source_lang,
1620: l_okc_timevalues_tl_rec.sfwt_flag,
1621: l_okc_timevalues_tl_rec.description,
1622: l_okc_timevalues_tl_rec.short_description,
1623: l_okc_timevalues_tl_rec.comments,
1624: l_okc_timevalues_tl_rec.name,
1625: l_okc_timevalues_tl_rec.created_by,
1626: l_okc_timevalues_tl_rec.creation_date,
1627: l_okc_timevalues_tl_rec.last_updated_by,

Line 1624: l_okc_timevalues_tl_rec.name,

1620: l_okc_timevalues_tl_rec.sfwt_flag,
1621: l_okc_timevalues_tl_rec.description,
1622: l_okc_timevalues_tl_rec.short_description,
1623: l_okc_timevalues_tl_rec.comments,
1624: l_okc_timevalues_tl_rec.name,
1625: l_okc_timevalues_tl_rec.created_by,
1626: l_okc_timevalues_tl_rec.creation_date,
1627: l_okc_timevalues_tl_rec.last_updated_by,
1628: l_okc_timevalues_tl_rec.last_update_date,

Line 1625: l_okc_timevalues_tl_rec.created_by,

1621: l_okc_timevalues_tl_rec.description,
1622: l_okc_timevalues_tl_rec.short_description,
1623: l_okc_timevalues_tl_rec.comments,
1624: l_okc_timevalues_tl_rec.name,
1625: l_okc_timevalues_tl_rec.created_by,
1626: l_okc_timevalues_tl_rec.creation_date,
1627: l_okc_timevalues_tl_rec.last_updated_by,
1628: l_okc_timevalues_tl_rec.last_update_date,
1629: l_okc_timevalues_tl_rec.last_update_login);

Line 1626: l_okc_timevalues_tl_rec.creation_date,

1622: l_okc_timevalues_tl_rec.short_description,
1623: l_okc_timevalues_tl_rec.comments,
1624: l_okc_timevalues_tl_rec.name,
1625: l_okc_timevalues_tl_rec.created_by,
1626: l_okc_timevalues_tl_rec.creation_date,
1627: l_okc_timevalues_tl_rec.last_updated_by,
1628: l_okc_timevalues_tl_rec.last_update_date,
1629: l_okc_timevalues_tl_rec.last_update_login);
1630: END LOOP;

Line 1627: l_okc_timevalues_tl_rec.last_updated_by,

1623: l_okc_timevalues_tl_rec.comments,
1624: l_okc_timevalues_tl_rec.name,
1625: l_okc_timevalues_tl_rec.created_by,
1626: l_okc_timevalues_tl_rec.creation_date,
1627: l_okc_timevalues_tl_rec.last_updated_by,
1628: l_okc_timevalues_tl_rec.last_update_date,
1629: l_okc_timevalues_tl_rec.last_update_login);
1630: END LOOP;
1631: -- Set OUT values

Line 1628: l_okc_timevalues_tl_rec.last_update_date,

1624: l_okc_timevalues_tl_rec.name,
1625: l_okc_timevalues_tl_rec.created_by,
1626: l_okc_timevalues_tl_rec.creation_date,
1627: l_okc_timevalues_tl_rec.last_updated_by,
1628: l_okc_timevalues_tl_rec.last_update_date,
1629: l_okc_timevalues_tl_rec.last_update_login);
1630: END LOOP;
1631: -- Set OUT values
1632: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

Line 1629: l_okc_timevalues_tl_rec.last_update_login);

1625: l_okc_timevalues_tl_rec.created_by,
1626: l_okc_timevalues_tl_rec.creation_date,
1627: l_okc_timevalues_tl_rec.last_updated_by,
1628: l_okc_timevalues_tl_rec.last_update_date,
1629: l_okc_timevalues_tl_rec.last_update_login);
1630: END LOOP;
1631: -- Set OUT values
1632: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1633: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1632: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

1628: l_okc_timevalues_tl_rec.last_update_date,
1629: l_okc_timevalues_tl_rec.last_update_login);
1630: END LOOP;
1631: -- Set OUT values
1632: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1633: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1634: EXCEPTION
1635: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1636: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1686: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1682: l_talv_rec talv_rec_type;
1683: l_def_talv_rec talv_rec_type;
1684: l_tve_rec tve_rec_type;
1685: lx_tve_rec tve_rec_type;
1686: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1687: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1688: -------------------------------
1689: -- FUNCTION fill_who_columns --
1690: -------------------------------

Line 1687: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1683: l_def_talv_rec talv_rec_type;
1684: l_tve_rec tve_rec_type;
1685: lx_tve_rec tve_rec_type;
1686: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1687: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1688: -------------------------------
1689: -- FUNCTION fill_who_columns --
1690: -------------------------------
1691: FUNCTION fill_who_columns (

Line 1764: --Bug 3122962 migrate(l_def_talv_rec, l_okc_timevalues_tl_rec);

1760: --------------------------------------
1761: -- Move VIEW record to "Child" records
1762: --------------------------------------
1763: migrate(l_def_talv_rec, l_tve_rec);
1764: --Bug 3122962 migrate(l_def_talv_rec, l_okc_timevalues_tl_rec);
1765: --------------------------------------------
1766: -- Call the INSERT_ROW for each child record
1767: --------------------------------------------
1768: insert_row(

Line 1788: l_okc_timevalues_tl_rec,

1784: p_init_msg_list,
1785: x_return_status,
1786: x_msg_count,
1787: x_msg_data,
1788: l_okc_timevalues_tl_rec,
1789: lx_okc_timevalues_tl_rec
1790: );
1791: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1792: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1789: lx_okc_timevalues_tl_rec

1785: x_return_status,
1786: x_msg_count,
1787: x_msg_data,
1788: l_okc_timevalues_tl_rec,
1789: lx_okc_timevalues_tl_rec
1790: );
1791: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1792: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1793: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1796: migrate(lx_okc_timevalues_tl_rec, l_def_talv_rec);

1792: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1793: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1794: RAISE OKC_API.G_EXCEPTION_ERROR;
1795: END IF;
1796: migrate(lx_okc_timevalues_tl_rec, l_def_talv_rec);
1797: */
1798: -- Set OUT values
1799: x_talv_rec := l_def_talv_rec;
1800: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1903: -- lock_row for:OKC_TIMEVALUES_B --

1899: ---------------------------------------------------------------------------
1900: -- PROCEDURE lock_row
1901: ---------------------------------------------------------------------------
1902: -----------------------------------
1903: -- lock_row for:OKC_TIMEVALUES_B --
1904: -----------------------------------
1905: PROCEDURE lock_row(
1906: p_init_msg_list IN VARCHAR2,
1907: x_return_status OUT NOCOPY VARCHAR2,

Line 1916: FROM OKC_TIMEVALUES

1912: E_Resource_Busy EXCEPTION;
1913: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1914: CURSOR lock_csr (p_tve_rec IN tve_rec_type) IS
1915: SELECT OBJECT_VERSION_NUMBER
1916: FROM OKC_TIMEVALUES
1917: WHERE ID = p_tve_rec.id
1918: AND OBJECT_VERSION_NUMBER = p_tve_rec.object_version_number
1919: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1920:

Line 1923: FROM OKC_TIMEVALUES

1919: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1920:
1921: CURSOR lchk_csr (p_tve_rec IN tve_rec_type) IS
1922: SELECT OBJECT_VERSION_NUMBER
1923: FROM OKC_TIMEVALUES
1924: WHERE ID = p_tve_rec.id;
1925: l_api_version CONSTANT NUMBER := 1;
1926: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1927: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1928: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1924: WHERE ID = p_tve_rec.id;
1925: l_api_version CONSTANT NUMBER := 1;
1926: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1927: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1928: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1929: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1930: l_row_notfound BOOLEAN := FALSE;
1931: lc_row_notfound BOOLEAN := FALSE;
1932: BEGIN

Line 1929: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1925: l_api_version CONSTANT NUMBER := 1;
1926: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1927: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1928: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1929: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1930: l_row_notfound BOOLEAN := FALSE;
1931: lc_row_notfound BOOLEAN := FALSE;
1932: BEGIN
1933: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2009: -- lock_row for:OKC_TIMEVALUES_TL --

2005: '_PVT'
2006: );
2007: END lock_row;
2008: ------------------------------------
2009: -- lock_row for:OKC_TIMEVALUES_TL --
2010: ------------------------------------
2011: /*
2012: PROCEDURE lock_row(
2013: p_init_msg_list IN VARCHAR2,

Line 2017: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

2013: p_init_msg_list IN VARCHAR2,
2014: x_return_status OUT NOCOPY VARCHAR2,
2015: x_msg_count OUT NOCOPY NUMBER,
2016: x_msg_data OUT NOCOPY VARCHAR2,
2017: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2018:
2019: E_Resource_Busy EXCEPTION;
2020: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2021: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

Line 2021: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

2017: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2018:
2019: E_Resource_Busy EXCEPTION;
2020: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2021: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2022: SELECT id
2023: FROM OKC_TIMEVALUES_TL
2024: WHERE ID = p_okc_timevalues_tl_rec.id
2025: FOR UPDATE NOWAIT;

Line 2023: FROM OKC_TIMEVALUES_TL

2019: E_Resource_Busy EXCEPTION;
2020: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2021: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2022: SELECT id
2023: FROM OKC_TIMEVALUES_TL
2024: WHERE ID = p_okc_timevalues_tl_rec.id
2025: FOR UPDATE NOWAIT;
2026:
2027: l_api_version CONSTANT NUMBER := 1;

Line 2024: WHERE ID = p_okc_timevalues_tl_rec.id

2020: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2021: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2022: SELECT id
2023: FROM OKC_TIMEVALUES_TL
2024: WHERE ID = p_okc_timevalues_tl_rec.id
2025: FOR UPDATE NOWAIT;
2026:
2027: l_api_version CONSTANT NUMBER := 1;
2028: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2044: OPEN lock_csr(p_okc_timevalues_tl_rec);

2040: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2041: RAISE OKC_API.G_EXCEPTION_ERROR;
2042: END IF;
2043: BEGIN
2044: OPEN lock_csr(p_okc_timevalues_tl_rec);
2045: FETCH lock_csr INTO l_lock_var;
2046: l_row_notfound := lock_csr%NOTFOUND;
2047: CLOSE lock_csr;
2048: EXCEPTION

Line 2110: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2106: l_api_version CONSTANT NUMBER := 1;
2107: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2108: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2109: l_tve_rec tve_rec_type;
2110: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2111: BEGIN
2112: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2113: G_PKG_NAME,
2114: p_init_msg_list,

Line 2128: --Bug 3122962 migrate(p_talv_rec, l_okc_timevalues_tl_rec);

2124: --------------------------------------
2125: -- Move VIEW record to "Child" records
2126: --------------------------------------
2127: migrate(p_talv_rec, l_tve_rec);
2128: --Bug 3122962 migrate(p_talv_rec, l_okc_timevalues_tl_rec);
2129: --------------------------------------------
2130: -- Call the LOCK_ROW for each child record
2131: --------------------------------------------
2132: lock_row(

Line 2149: l_okc_timevalues_tl_rec

2145: p_init_msg_list,
2146: x_return_status,
2147: x_msg_count,
2148: x_msg_data,
2149: l_okc_timevalues_tl_rec
2150: );
2151: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2152: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2153: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2258: -- update_row for:OKC_TIMEVALUES_B --

2254: ---------------------------------------------------------------------------
2255: -- PROCEDURE update_row
2256: ---------------------------------------------------------------------------
2257: -------------------------------------
2258: -- update_row for:OKC_TIMEVALUES_B --
2259: -------------------------------------
2260: PROCEDURE update_row(
2261: p_init_msg_list IN VARCHAR2,
2262: x_return_status OUT NOCOPY VARCHAR2,

Line 2496: -- Set_Attributes for:OKC_TIMEVALUES_B --

2492:
2493: RETURN(l_return_status);
2494: END populate_new_record;
2495: -----------------------------------------
2496: -- Set_Attributes for:OKC_TIMEVALUES_B --
2497: -----------------------------------------
2498: FUNCTION Set_Attributes (
2499: p_tve_rec IN tve_rec_type,
2500: x_tve_rec OUT NOCOPY tve_rec_type

Line 2533: UPDATE OKC_TIMEVALUES

2529: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2530: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2531: RAISE OKC_API.G_EXCEPTION_ERROR;
2532: END IF;
2533: UPDATE OKC_TIMEVALUES
2534: SET SPN_ID = l_def_tve_rec.spn_id,
2535: TVE_ID_OFFSET = l_def_tve_rec.tve_id_offset,
2536: DNZ_CHR_ID = l_def_tve_rec.dnz_chr_id,
2537: TZE_ID = l_def_tve_rec.tze_id,

Line 2621: -- update_row for:OKC_TIMEVALUES_TL --

2617: '_PVT'
2618: );
2619: END update_row;
2620: --------------------------------------
2621: -- update_row for:OKC_TIMEVALUES_TL --
2622: --------------------------------------
2623: /*
2624: PROCEDURE update_row(
2625: p_init_msg_list IN VARCHAR2,

Line 2629: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2625: p_init_msg_list IN VARCHAR2,
2626: x_return_status OUT NOCOPY VARCHAR2,
2627: x_msg_count OUT NOCOPY NUMBER,
2628: x_msg_data OUT NOCOPY VARCHAR2,
2629: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2630: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2631:
2632: l_api_version CONSTANT NUMBER := 1;
2633: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2630: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

2626: x_return_status OUT NOCOPY VARCHAR2,
2627: x_msg_count OUT NOCOPY NUMBER,
2628: x_msg_data OUT NOCOPY VARCHAR2,
2629: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2630: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2631:
2632: l_api_version CONSTANT NUMBER := 1;
2633: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2634: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2635: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

2631:
2632: l_api_version CONSTANT NUMBER := 1;
2633: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2634: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2635: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2636: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2637: l_row_notfound BOOLEAN := TRUE;
2638: ----------------------------------
2639: -- FUNCTION populate_new_record --

Line 2636: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2632: l_api_version CONSTANT NUMBER := 1;
2633: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2634: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2635: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2636: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2637: l_row_notfound BOOLEAN := TRUE;
2638: ----------------------------------
2639: -- FUNCTION populate_new_record --
2640: ----------------------------------

Line 2642: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2638: ----------------------------------
2639: -- FUNCTION populate_new_record --
2640: ----------------------------------
2641: FUNCTION populate_new_record (
2642: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2643: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2644: ) RETURN VARCHAR2 IS
2645: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2646: l_row_notfound BOOLEAN := TRUE;

Line 2643: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2639: -- FUNCTION populate_new_record --
2640: ----------------------------------
2641: FUNCTION populate_new_record (
2642: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2643: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2644: ) RETURN VARCHAR2 IS
2645: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2646: l_row_notfound BOOLEAN := TRUE;
2647: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2645: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2641: FUNCTION populate_new_record (
2642: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2643: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2644: ) RETURN VARCHAR2 IS
2645: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2646: l_row_notfound BOOLEAN := TRUE;
2647: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2648: BEGIN
2649: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2649: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2645: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2646: l_row_notfound BOOLEAN := TRUE;
2647: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2648: BEGIN
2649: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2650: -- Get current database values
2651: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2652: IF (l_row_notfound) THEN
2653: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2651: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);

2647: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2648: BEGIN
2649: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2650: -- Get current database values
2651: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2652: IF (l_row_notfound) THEN
2653: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2654: END IF;
2655: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)

Line 2655: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)

2651: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2652: IF (l_row_notfound) THEN
2653: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2654: END IF;
2655: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2656: THEN
2657: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2658: END IF;
2659: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2657: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;

2653: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2654: END IF;
2655: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2656: THEN
2657: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2658: END IF;
2659: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2660: THEN
2661: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;

Line 2659: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)

2655: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2656: THEN
2657: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2658: END IF;
2659: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2660: THEN
2661: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2662: END IF;
2663: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2661: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;

2657: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2658: END IF;
2659: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2660: THEN
2661: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2662: END IF;
2663: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2664: THEN
2665: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;

Line 2663: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2659: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2660: THEN
2661: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2662: END IF;
2663: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2664: THEN
2665: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2666: END IF;
2667: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2665: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;

2661: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2662: END IF;
2663: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2664: THEN
2665: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2666: END IF;
2667: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;

Line 2667: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2663: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2664: THEN
2665: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2666: END IF;
2667: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2670: END IF;
2671: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 2669: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;

2665: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2666: END IF;
2667: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2670: END IF;
2671: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;

Line 2671: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)

2667: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2670: END IF;
2671: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2674: END IF;
2675: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)

Line 2673: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;

2669: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2670: END IF;
2671: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2674: END IF;
2675: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2676: THEN
2677: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;

Line 2675: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)

2671: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2674: END IF;
2675: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2676: THEN
2677: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2678: END IF;
2679: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)

Line 2677: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;

2673: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2674: END IF;
2675: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2676: THEN
2677: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2678: END IF;
2679: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2680: THEN
2681: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;

Line 2679: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)

2675: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2676: THEN
2677: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2678: END IF;
2679: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2680: THEN
2681: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2682: END IF;
2683: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)

Line 2681: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;

2677: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2678: END IF;
2679: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2680: THEN
2681: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2682: END IF;
2683: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2684: THEN
2685: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;

Line 2683: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)

2679: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2680: THEN
2681: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2682: END IF;
2683: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2684: THEN
2685: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2686: END IF;
2687: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2685: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;

2681: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2682: END IF;
2683: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2684: THEN
2685: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2686: END IF;
2687: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2688: THEN
2689: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;

Line 2687: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)

2683: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2684: THEN
2685: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2686: END IF;
2687: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2688: THEN
2689: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2690: END IF;
2691: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2689: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;

2685: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2686: END IF;
2687: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2688: THEN
2689: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2690: END IF;
2691: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2692: THEN
2693: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;

Line 2691: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2687: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2688: THEN
2689: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2690: END IF;
2691: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2692: THEN
2693: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2694: END IF;
2695: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2693: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;

2689: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2690: END IF;
2691: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2692: THEN
2693: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2694: END IF;
2695: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2696: THEN
2697: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;

Line 2695: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2691: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2692: THEN
2693: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2694: END IF;
2695: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2696: THEN
2697: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2698: END IF;
2699: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2697: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;

2693: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2694: END IF;
2695: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2696: THEN
2697: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2698: END IF;
2699: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2700: THEN
2701: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;

Line 2699: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2695: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2696: THEN
2697: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2698: END IF;
2699: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2700: THEN
2701: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2702: END IF;
2703: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2701: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;

2697: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2698: END IF;
2699: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2700: THEN
2701: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2702: END IF;
2703: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2704: THEN
2705: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;

Line 2703: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2699: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2700: THEN
2701: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2702: END IF;
2703: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2704: THEN
2705: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2706: END IF;
2707: RETURN(l_return_status);

Line 2705: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;

2701: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2702: END IF;
2703: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2704: THEN
2705: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2706: END IF;
2707: RETURN(l_return_status);
2708: END populate_new_record;
2709: ------------------------------------------

Line 2710: -- Set_Attributes for:OKC_TIMEVALUES_TL --

2706: END IF;
2707: RETURN(l_return_status);
2708: END populate_new_record;
2709: ------------------------------------------
2710: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2711: ------------------------------------------
2712: FUNCTION Set_Attributes (
2713: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2714: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 2713: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2709: ------------------------------------------
2710: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2711: ------------------------------------------
2712: FUNCTION Set_Attributes (
2713: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2714: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2715: ) RETURN VARCHAR2 IS
2716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2717: BEGIN

Line 2714: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2710: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2711: ------------------------------------------
2712: FUNCTION Set_Attributes (
2713: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2714: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2715: ) RETURN VARCHAR2 IS
2716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2717: BEGIN
2718: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2718: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2714: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2715: ) RETURN VARCHAR2 IS
2716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2717: BEGIN
2718: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2719: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2720: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2721: RETURN(l_return_status);
2722: END Set_Attributes;

Line 2719: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2715: ) RETURN VARCHAR2 IS
2716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2717: BEGIN
2718: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2719: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2720: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2721: RETURN(l_return_status);
2722: END Set_Attributes;
2723: BEGIN

Line 2720: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

2716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2717: BEGIN
2718: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2719: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2720: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2721: RETURN(l_return_status);
2722: END Set_Attributes;
2723: BEGIN
2724: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2735: p_okc_timevalues_tl_rec, -- IN

2731: RAISE OKC_API.G_EXCEPTION_ERROR;
2732: END IF;
2733: --- Setting item attributes
2734: l_return_status := Set_Attributes(
2735: p_okc_timevalues_tl_rec, -- IN
2736: l_okc_timevalues_tl_rec); -- OUT
2737: --- If any errors happen abort API
2738: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2739: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2736: l_okc_timevalues_tl_rec); -- OUT

2732: END IF;
2733: --- Setting item attributes
2734: l_return_status := Set_Attributes(
2735: p_okc_timevalues_tl_rec, -- IN
2736: l_okc_timevalues_tl_rec); -- OUT
2737: --- If any errors happen abort API
2738: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2739: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2740: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2743: l_return_status := populate_new_record(l_okc_timevalues_tl_rec, l_def_okc_timevalues_tl_rec);

2739: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2740: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2741: RAISE OKC_API.G_EXCEPTION_ERROR;
2742: END IF;
2743: l_return_status := populate_new_record(l_okc_timevalues_tl_rec, l_def_okc_timevalues_tl_rec);
2744: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2745: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2746: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2747: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2749: UPDATE OKC_TIMEVALUES_TL

2745: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2746: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2747: RAISE OKC_API.G_EXCEPTION_ERROR;
2748: END IF;
2749: UPDATE OKC_TIMEVALUES_TL
2750: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2751: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2752: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2753: NAME = l_def_okc_timevalues_tl_rec.name,

Line 2750: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,

2746: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2747: RAISE OKC_API.G_EXCEPTION_ERROR;
2748: END IF;
2749: UPDATE OKC_TIMEVALUES_TL
2750: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2751: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2752: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2753: NAME = l_def_okc_timevalues_tl_rec.name,
2754: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

Line 2751: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,

2747: RAISE OKC_API.G_EXCEPTION_ERROR;
2748: END IF;
2749: UPDATE OKC_TIMEVALUES_TL
2750: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2751: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2752: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2753: NAME = l_def_okc_timevalues_tl_rec.name,
2754: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2755: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

Line 2752: COMMENTS = l_def_okc_timevalues_tl_rec.comments,

2748: END IF;
2749: UPDATE OKC_TIMEVALUES_TL
2750: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2751: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2752: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2753: NAME = l_def_okc_timevalues_tl_rec.name,
2754: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2755: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2756: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

Line 2753: NAME = l_def_okc_timevalues_tl_rec.name,

2749: UPDATE OKC_TIMEVALUES_TL
2750: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2751: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2752: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2753: NAME = l_def_okc_timevalues_tl_rec.name,
2754: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2755: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2756: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2757: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

Line 2754: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

2750: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2751: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2752: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2753: NAME = l_def_okc_timevalues_tl_rec.name,
2754: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2755: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2756: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2757: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2758: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

Line 2755: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

2751: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2752: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2753: NAME = l_def_okc_timevalues_tl_rec.name,
2754: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2755: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2756: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2757: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2758: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2759: WHERE ID = l_def_okc_timevalues_tl_rec.id

Line 2756: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

2752: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2753: NAME = l_def_okc_timevalues_tl_rec.name,
2754: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2755: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2756: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2757: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2758: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2759: WHERE ID = l_def_okc_timevalues_tl_rec.id
2760: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);

Line 2757: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

2753: NAME = l_def_okc_timevalues_tl_rec.name,
2754: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2755: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2756: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2757: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2758: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2759: WHERE ID = l_def_okc_timevalues_tl_rec.id
2760: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2761:

Line 2758: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

2754: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2755: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2756: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2757: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2758: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2759: WHERE ID = l_def_okc_timevalues_tl_rec.id
2760: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2761:
2762: UPDATE OKC_TIMEVALUES_TL

Line 2759: WHERE ID = l_def_okc_timevalues_tl_rec.id

2755: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2756: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2757: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2758: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2759: WHERE ID = l_def_okc_timevalues_tl_rec.id
2760: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2761:
2762: UPDATE OKC_TIMEVALUES_TL
2763: SET SFWT_FLAG = 'Y'

Line 2762: UPDATE OKC_TIMEVALUES_TL

2758: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2759: WHERE ID = l_def_okc_timevalues_tl_rec.id
2760: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2761:
2762: UPDATE OKC_TIMEVALUES_TL
2763: SET SFWT_FLAG = 'Y'
2764: WHERE ID = l_def_okc_timevalues_tl_rec.id
2765: AND SOURCE_LANG <> USERENV('LANG');
2766: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;

Line 2764: WHERE ID = l_def_okc_timevalues_tl_rec.id

2760: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2761:
2762: UPDATE OKC_TIMEVALUES_TL
2763: SET SFWT_FLAG = 'Y'
2764: WHERE ID = l_def_okc_timevalues_tl_rec.id
2765: AND SOURCE_LANG <> USERENV('LANG');
2766: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2767: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2768: EXCEPTION

Line 2766: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;

2762: UPDATE OKC_TIMEVALUES_TL
2763: SET SFWT_FLAG = 'Y'
2764: WHERE ID = l_def_okc_timevalues_tl_rec.id
2765: AND SOURCE_LANG <> USERENV('LANG');
2766: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2767: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2768: EXCEPTION
2769: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2770: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2818: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2814: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2815: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2816: l_talv_rec talv_rec_type := p_talv_rec;
2817: l_def_talv_rec talv_rec_type;
2818: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2819: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2820: l_tve_rec tve_rec_type;
2821: lx_tve_rec tve_rec_type;
2822: -------------------------------

Line 2819: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2815: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2816: l_talv_rec talv_rec_type := p_talv_rec;
2817: l_def_talv_rec talv_rec_type;
2818: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2819: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2820: l_tve_rec tve_rec_type;
2821: lx_tve_rec tve_rec_type;
2822: -------------------------------
2823: -- FUNCTION fill_who_columns --

Line 3064: --Bug 3122962 migrate(l_def_talv_rec, l_okc_timevalues_tl_rec);

3060:
3061: --------------------------------------
3062: -- Move VIEW record to "Child" records
3063: --------------------------------------
3064: --Bug 3122962 migrate(l_def_talv_rec, l_okc_timevalues_tl_rec);
3065: migrate(l_def_talv_rec, l_tve_rec);
3066: --------------------------------------------
3067: -- Call the UPDATE_ROW for each child record
3068: --------------------------------------------

Line 3074: l_okc_timevalues_tl_rec,

3070: p_init_msg_list,
3071: x_return_status,
3072: x_msg_count,
3073: x_msg_data,
3074: l_okc_timevalues_tl_rec,
3075: lx_okc_timevalues_tl_rec
3076: );
3077: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3078: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3075: lx_okc_timevalues_tl_rec

3071: x_return_status,
3072: x_msg_count,
3073: x_msg_data,
3074: l_okc_timevalues_tl_rec,
3075: lx_okc_timevalues_tl_rec
3076: );
3077: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3078: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3079: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3082: migrate(lx_okc_timevalues_tl_rec, l_def_talv_rec);

3078: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3079: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3080: RAISE OKC_API.G_EXCEPTION_ERROR;
3081: END IF;
3082: migrate(lx_okc_timevalues_tl_rec, l_def_talv_rec);
3083: */
3084: update_row(
3085: p_init_msg_list,
3086: x_return_status,

Line 3202: -- delete_row for:OKC_TIMEVALUES_B --

3198: ---------------------------------------------------------------------------
3199: -- PROCEDURE delete_row
3200: ---------------------------------------------------------------------------
3201: -------------------------------------
3202: -- delete_row for:OKC_TIMEVALUES_B --
3203: -------------------------------------
3204: PROCEDURE delete_row(
3205: p_init_msg_list IN VARCHAR2,
3206: x_return_status OUT NOCOPY VARCHAR2,

Line 3226: DELETE FROM OKC_TIMEVALUES

3222: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3223: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3224: RAISE OKC_API.G_EXCEPTION_ERROR;
3225: END IF;
3226: DELETE FROM OKC_TIMEVALUES
3227: WHERE ID = l_tve_rec.id;
3228:
3229: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3230: EXCEPTION

Line 3263: -- delete_row for:OKC_TIMEVALUES_TL --

3259: '_PVT'
3260: );
3261: END delete_row;
3262: --------------------------------------
3263: -- delete_row for:OKC_TIMEVALUES_TL --
3264: --------------------------------------
3265: /* PROCEDURE delete_row(
3266: p_init_msg_list IN VARCHAR2,
3267: x_return_status OUT NOCOPY VARCHAR2,

Line 3270: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

3266: p_init_msg_list IN VARCHAR2,
3267: x_return_status OUT NOCOPY VARCHAR2,
3268: x_msg_count OUT NOCOPY NUMBER,
3269: x_msg_data OUT NOCOPY VARCHAR2,
3270: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
3271:
3272: l_api_version CONSTANT NUMBER := 1;
3273: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3274: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3275: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;

3271:
3272: l_api_version CONSTANT NUMBER := 1;
3273: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3274: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3275: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3276: l_row_notfound BOOLEAN := TRUE;
3277: ------------------------------------------
3278: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3279: ------------------------------------------

Line 3278: -- Set_Attributes for:OKC_TIMEVALUES_TL --

3274: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3275: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3276: l_row_notfound BOOLEAN := TRUE;
3277: ------------------------------------------
3278: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3279: ------------------------------------------
3280: FUNCTION Set_Attributes (
3281: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3282: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 3281: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

3277: ------------------------------------------
3278: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3279: ------------------------------------------
3280: FUNCTION Set_Attributes (
3281: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3282: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3283: ) RETURN VARCHAR2 IS
3284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3285: BEGIN

Line 3282: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

3278: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3279: ------------------------------------------
3280: FUNCTION Set_Attributes (
3281: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3282: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3283: ) RETURN VARCHAR2 IS
3284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3285: BEGIN
3286: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 3286: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

3282: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3283: ) RETURN VARCHAR2 IS
3284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3285: BEGIN
3286: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3287: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3288: RETURN(l_return_status);
3289: END Set_Attributes;
3290: BEGIN

Line 3287: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

3283: ) RETURN VARCHAR2 IS
3284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3285: BEGIN
3286: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3287: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3288: RETURN(l_return_status);
3289: END Set_Attributes;
3290: BEGIN
3291: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3302: p_okc_timevalues_tl_rec, -- IN

3298: RAISE OKC_API.G_EXCEPTION_ERROR;
3299: END IF;
3300: --- Setting item attributes
3301: l_return_status := Set_Attributes(
3302: p_okc_timevalues_tl_rec, -- IN
3303: l_okc_timevalues_tl_rec); -- OUT
3304: --- If any errors happen abort API
3305: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3306: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3303: l_okc_timevalues_tl_rec); -- OUT

3299: END IF;
3300: --- Setting item attributes
3301: l_return_status := Set_Attributes(
3302: p_okc_timevalues_tl_rec, -- IN
3303: l_okc_timevalues_tl_rec); -- OUT
3304: --- If any errors happen abort API
3305: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3306: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3307: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3310: DELETE FROM OKC_TIMEVALUES_TL

3306: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3307: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3308: RAISE OKC_API.G_EXCEPTION_ERROR;
3309: END IF;
3310: DELETE FROM OKC_TIMEVALUES_TL
3311: WHERE ID = l_okc_timevalues_tl_rec.id;
3312:
3313: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3314: EXCEPTION

Line 3311: WHERE ID = l_okc_timevalues_tl_rec.id;

3307: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3308: RAISE OKC_API.G_EXCEPTION_ERROR;
3309: END IF;
3310: DELETE FROM OKC_TIMEVALUES_TL
3311: WHERE ID = l_okc_timevalues_tl_rec.id;
3312:
3313: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3314: EXCEPTION
3315: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3362: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

3358: l_api_version CONSTANT NUMBER := 1;
3359: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3360: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3361: l_talv_rec talv_rec_type := p_talv_rec;
3362: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
3363: l_tve_rec tve_rec_type;
3364: BEGIN
3365: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3366: G_PKG_NAME,

Line 3380: --Bug 3122962 migrate(l_talv_rec, l_okc_timevalues_tl_rec);

3376: END IF;
3377: --------------------------------------
3378: -- Move VIEW record to "Child" records
3379: --------------------------------------
3380: --Bug 3122962 migrate(l_talv_rec, l_okc_timevalues_tl_rec);
3381: migrate(l_talv_rec, l_tve_rec);
3382: --------------------------------------------
3383: -- Call the DELETE_ROW for each child record
3384: --------------------------------------------

Line 3390: l_okc_timevalues_tl_rec

3386: p_init_msg_list,
3387: x_return_status,
3388: x_msg_count,
3389: x_msg_data,
3390: l_okc_timevalues_tl_rec
3391: );
3392: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3393: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3394: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN