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_CYL_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 97: FROM Okc_Timevalues

93: name,
94: description,
95: short_description,
96: comments
97: FROM Okc_Timevalues
98: WHERE okc_timevalues.id = p_id;
99: l_tve_pk tve_pk_csr%ROWTYPE;
100: l_tve_rec tve_rec_type;
101: BEGIN

Line 98: WHERE okc_timevalues.id = p_id;

94: description,
95: short_description,
96: comments
97: FROM Okc_Timevalues
98: WHERE okc_timevalues.id = p_id;
99: l_tve_pk tve_pk_csr%ROWTYPE;
100: l_tve_rec tve_rec_type;
101: BEGIN
102: x_no_data_found := TRUE;

Line 171: -- FUNCTION get_rec for: OKC_TIMEVALUES_TL

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

Line 176: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

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

Line 178: ) RETURN okc_timevalues_tl_rec_type IS

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

Line 195: FROM Okc_Timevalues_Tl

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

Line 196: WHERE okc_timevalues_tl.id = p_id

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

Line 197: AND okc_timevalues_tl.language = p_language;

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

Line 199: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

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

Line 203: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,

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

Line 204: p_okc_timevalues_tl_rec.language);

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

Line 206: l_okc_timevalues_tl_rec.ID,

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

Line 207: l_okc_timevalues_tl_rec.LANGUAGE,

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

Line 208: l_okc_timevalues_tl_rec.SOURCE_LANG,

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

Line 209: l_okc_timevalues_tl_rec.SFWT_FLAG,

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

Line 210: l_okc_timevalues_tl_rec.DESCRIPTION,

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

Line 211: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,

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

Line 212: l_okc_timevalues_tl_rec.COMMENTS,

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

Line 213: l_okc_timevalues_tl_rec.NAME,

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

Line 214: l_okc_timevalues_tl_rec.CREATED_BY,

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

Line 215: l_okc_timevalues_tl_rec.CREATION_DATE,

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

Line 216: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,

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

Line 217: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,

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

Line 218: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;

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

Line 221: RETURN(l_okc_timevalues_tl_rec);

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

Line 225: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type

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

Line 226: ) RETURN okc_timevalues_tl_rec_type IS

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

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

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

Line 440: -- FUNCTION null_out_defaults for: OKC_TIMEVALUES_V --

436: END null_out_defaults;
437:
438: --**** Change from TAPI Code---follow till end of change---------------
439: ------------------------------------------------------
440: -- FUNCTION null_out_defaults for: OKC_TIMEVALUES_V --
441: ------------------------------------------------------
442: -- 1. Added null_out_defaults to overcome number initialization
443: -- problem while populating optional columns for supertypes from a subtype
444: -- 2. Moved all column validations (including FK) to Validate_column

Line 528: p_tve_tl_rec IN okc_timevalues_tl_rec_type

524: RETURN(l_tve_rec);
525: END null_out_defaults;
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: RETURN(l_tve_tl_rec);

Line 529: ) RETURN okc_timevalues_tl_rec_type IS

525: END null_out_defaults;
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: RETURN(l_tve_tl_rec);
533: END null_out_defaults;

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: RETURN(l_tve_tl_rec);
533: END null_out_defaults;
534: */

Line 653: FROM Okc_Timevalues

649: item_not_found_error EXCEPTION;
650: l_row_notfound BOOLEAN := TRUE;
651: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
652: SELECT '1'
653: FROM Okc_Timevalues
654: WHERE id = p_id
655: and tve_type in ('ISE','IGS');
656: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
657: BEGIN

Line 968: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type

964: END migrate;
965: /*
966: PROCEDURE migrate (
967: p_from IN cylv_rec_type,
968: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
969: ) IS
970: l_tve_tl_type okc_timevalues_tl_rec_type;
971: BEGIN
972: p_to.id := p_from.id;

Line 970: l_tve_tl_type okc_timevalues_tl_rec_type;

966: PROCEDURE migrate (
967: p_from IN cylv_rec_type,
968: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
969: ) IS
970: l_tve_tl_type okc_timevalues_tl_rec_type;
971: BEGIN
972: p_to.id := p_from.id;
973: p_to.sfwt_flag := p_from.sfwt_flag;
974: p_to.description := p_from.description;

Line 989: p_from IN okc_timevalues_tl_rec_type,

985: l_tve_tl_type := null_out_defaults(p_to);
986: p_to := l_tve_tl_type;
987: END migrate;
988: PROCEDURE migrate (
989: p_from IN okc_timevalues_tl_rec_type,
990: p_to IN OUT NOCOPY cylv_rec_type
991: ) IS
992: BEGIN
993: p_to.id := p_from.id;

Line 1025: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1021: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1022: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1023: l_cylv_rec cylv_rec_type := p_cylv_rec;
1024: l_tve_rec tve_rec_type;
1025: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1026: BEGIN
1027: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1028: G_PKG_NAME,
1029: p_init_msg_list,

Line 1154: -- insert_row for:OKC_TIMEVALUES_B --

1150: ---------------------------------------------------------------------------
1151: -- PROCEDURE insert_row
1152: ---------------------------------------------------------------------------
1153: -------------------------------------
1154: -- insert_row for:OKC_TIMEVALUES_B --
1155: -------------------------------------
1156: PROCEDURE insert_row(
1157: p_init_msg_list IN VARCHAR2 ,
1158: x_return_status OUT NOCOPY VARCHAR2,

Line 1170: -- Set_Attributes for:OKC_TIMEVALUES_B --

1166: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1167: l_tve_rec tve_rec_type := p_tve_rec;
1168: l_def_tve_rec tve_rec_type;
1169: -----------------------------------------
1170: -- Set_Attributes for:OKC_TIMEVALUES_B --
1171: -----------------------------------------
1172: FUNCTION Set_Attributes (
1173: p_tve_rec IN tve_rec_type,
1174: x_tve_rec OUT NOCOPY tve_rec_type

Line 1201: INSERT INTO OKC_TIMEVALUES(

1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;
1201: INSERT INTO OKC_TIMEVALUES(
1202: id,
1203: spn_id,
1204: tve_id_offset,
1205: uom_code,

Line 1343: -- insert_row for:OKC_TIMEVALUES_TL --

1339: '_PVT'
1340: );
1341: END insert_row;
1342: --------------------------------------
1343: -- insert_row for:OKC_TIMEVALUES_TL --
1344: --------------------------------------
1345: --Bug 3122962
1346: /* PROCEDURE insert_row(
1347: p_init_msg_list IN VARCHAR2 ,

Line 1351: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1347: p_init_msg_list IN VARCHAR2 ,
1348: x_return_status OUT NOCOPY VARCHAR2,
1349: x_msg_count OUT NOCOPY NUMBER,
1350: x_msg_data OUT NOCOPY VARCHAR2,
1351: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1352: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1353:
1354: l_api_version CONSTANT NUMBER := 1;
1355: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1352: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

1348: x_return_status OUT NOCOPY VARCHAR2,
1349: x_msg_count OUT NOCOPY NUMBER,
1350: x_msg_data OUT NOCOPY VARCHAR2,
1351: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1352: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1353:
1354: l_api_version CONSTANT NUMBER := 1;
1355: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1356: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1357: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

1353:
1354: l_api_version CONSTANT NUMBER := 1;
1355: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1356: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1357: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1358: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1359: CURSOR get_languages IS
1360: SELECT *
1361: FROM FND_LANGUAGES

Line 1358: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1354: l_api_version CONSTANT NUMBER := 1;
1355: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1356: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1357: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1358: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1359: CURSOR get_languages IS
1360: SELECT *
1361: FROM FND_LANGUAGES
1362: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1364: -- Set_Attributes for:OKC_TIMEVALUES_TL --

1360: SELECT *
1361: FROM FND_LANGUAGES
1362: WHERE INSTALLED_FLAG IN ('I', 'B');
1363: ------------------------------------------
1364: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1365: ------------------------------------------
1366: FUNCTION Set_Attributes (
1367: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1368: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 1367: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1363: ------------------------------------------
1364: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1365: ------------------------------------------
1366: FUNCTION Set_Attributes (
1367: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1368: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1369: ) RETURN VARCHAR2 IS
1370: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1371: BEGIN

Line 1368: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

1364: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1365: ------------------------------------------
1366: FUNCTION Set_Attributes (
1367: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1368: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1369: ) RETURN VARCHAR2 IS
1370: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1371: BEGIN
1372: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 1372: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

1368: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1369: ) RETURN VARCHAR2 IS
1370: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1371: BEGIN
1372: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1373: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1374: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1375: RETURN(l_return_status);
1376: END Set_Attributes;

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

1369: ) RETURN VARCHAR2 IS
1370: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1371: BEGIN
1372: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1373: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1374: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1375: RETURN(l_return_status);
1376: END Set_Attributes;
1377: BEGIN

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

1370: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1371: BEGIN
1372: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1373: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1374: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1375: RETURN(l_return_status);
1376: END Set_Attributes;
1377: BEGIN
1378: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1389: p_okc_timevalues_tl_rec, -- IN

1385: RAISE OKC_API.G_EXCEPTION_ERROR;
1386: END IF;
1387: --- Setting item attributes
1388: l_return_status := Set_Attributes(
1389: p_okc_timevalues_tl_rec, -- IN
1390: l_okc_timevalues_tl_rec); -- OUT
1391: --- If any errors happen abort API
1392: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1393: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1390: l_okc_timevalues_tl_rec); -- OUT

1386: END IF;
1387: --- Setting item attributes
1388: l_return_status := Set_Attributes(
1389: p_okc_timevalues_tl_rec, -- IN
1390: l_okc_timevalues_tl_rec); -- OUT
1391: --- If any errors happen abort API
1392: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1393: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1394: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

1394: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1395: RAISE OKC_API.G_EXCEPTION_ERROR;
1396: END IF;
1397: FOR l_lang_rec IN get_languages LOOP
1398: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1399: INSERT INTO OKC_TIMEVALUES_TL(
1400: id,
1401: language,
1402: source_lang,

Line 1399: INSERT INTO OKC_TIMEVALUES_TL(

1395: RAISE OKC_API.G_EXCEPTION_ERROR;
1396: END IF;
1397: FOR l_lang_rec IN get_languages LOOP
1398: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1399: INSERT INTO OKC_TIMEVALUES_TL(
1400: id,
1401: language,
1402: source_lang,
1403: sfwt_flag,

Line 1414: l_okc_timevalues_tl_rec.id,

1410: last_updated_by,
1411: last_update_date,
1412: last_update_login)
1413: VALUES (
1414: l_okc_timevalues_tl_rec.id,
1415: l_okc_timevalues_tl_rec.language,
1416: l_okc_timevalues_tl_rec.source_lang,
1417: l_okc_timevalues_tl_rec.sfwt_flag,
1418: l_okc_timevalues_tl_rec.description,

Line 1415: l_okc_timevalues_tl_rec.language,

1411: last_update_date,
1412: last_update_login)
1413: VALUES (
1414: l_okc_timevalues_tl_rec.id,
1415: l_okc_timevalues_tl_rec.language,
1416: l_okc_timevalues_tl_rec.source_lang,
1417: l_okc_timevalues_tl_rec.sfwt_flag,
1418: l_okc_timevalues_tl_rec.description,
1419: l_okc_timevalues_tl_rec.short_description,

Line 1416: l_okc_timevalues_tl_rec.source_lang,

1412: last_update_login)
1413: VALUES (
1414: l_okc_timevalues_tl_rec.id,
1415: l_okc_timevalues_tl_rec.language,
1416: l_okc_timevalues_tl_rec.source_lang,
1417: l_okc_timevalues_tl_rec.sfwt_flag,
1418: l_okc_timevalues_tl_rec.description,
1419: l_okc_timevalues_tl_rec.short_description,
1420: l_okc_timevalues_tl_rec.comments,

Line 1417: l_okc_timevalues_tl_rec.sfwt_flag,

1413: VALUES (
1414: l_okc_timevalues_tl_rec.id,
1415: l_okc_timevalues_tl_rec.language,
1416: l_okc_timevalues_tl_rec.source_lang,
1417: l_okc_timevalues_tl_rec.sfwt_flag,
1418: l_okc_timevalues_tl_rec.description,
1419: l_okc_timevalues_tl_rec.short_description,
1420: l_okc_timevalues_tl_rec.comments,
1421: l_okc_timevalues_tl_rec.name,

Line 1418: l_okc_timevalues_tl_rec.description,

1414: l_okc_timevalues_tl_rec.id,
1415: l_okc_timevalues_tl_rec.language,
1416: l_okc_timevalues_tl_rec.source_lang,
1417: l_okc_timevalues_tl_rec.sfwt_flag,
1418: l_okc_timevalues_tl_rec.description,
1419: l_okc_timevalues_tl_rec.short_description,
1420: l_okc_timevalues_tl_rec.comments,
1421: l_okc_timevalues_tl_rec.name,
1422: l_okc_timevalues_tl_rec.created_by,

Line 1419: l_okc_timevalues_tl_rec.short_description,

1415: l_okc_timevalues_tl_rec.language,
1416: l_okc_timevalues_tl_rec.source_lang,
1417: l_okc_timevalues_tl_rec.sfwt_flag,
1418: l_okc_timevalues_tl_rec.description,
1419: l_okc_timevalues_tl_rec.short_description,
1420: l_okc_timevalues_tl_rec.comments,
1421: l_okc_timevalues_tl_rec.name,
1422: l_okc_timevalues_tl_rec.created_by,
1423: l_okc_timevalues_tl_rec.creation_date,

Line 1420: l_okc_timevalues_tl_rec.comments,

1416: l_okc_timevalues_tl_rec.source_lang,
1417: l_okc_timevalues_tl_rec.sfwt_flag,
1418: l_okc_timevalues_tl_rec.description,
1419: l_okc_timevalues_tl_rec.short_description,
1420: l_okc_timevalues_tl_rec.comments,
1421: l_okc_timevalues_tl_rec.name,
1422: l_okc_timevalues_tl_rec.created_by,
1423: l_okc_timevalues_tl_rec.creation_date,
1424: l_okc_timevalues_tl_rec.last_updated_by,

Line 1421: l_okc_timevalues_tl_rec.name,

1417: l_okc_timevalues_tl_rec.sfwt_flag,
1418: l_okc_timevalues_tl_rec.description,
1419: l_okc_timevalues_tl_rec.short_description,
1420: l_okc_timevalues_tl_rec.comments,
1421: l_okc_timevalues_tl_rec.name,
1422: l_okc_timevalues_tl_rec.created_by,
1423: l_okc_timevalues_tl_rec.creation_date,
1424: l_okc_timevalues_tl_rec.last_updated_by,
1425: l_okc_timevalues_tl_rec.last_update_date,

Line 1422: l_okc_timevalues_tl_rec.created_by,

1418: l_okc_timevalues_tl_rec.description,
1419: l_okc_timevalues_tl_rec.short_description,
1420: l_okc_timevalues_tl_rec.comments,
1421: l_okc_timevalues_tl_rec.name,
1422: l_okc_timevalues_tl_rec.created_by,
1423: l_okc_timevalues_tl_rec.creation_date,
1424: l_okc_timevalues_tl_rec.last_updated_by,
1425: l_okc_timevalues_tl_rec.last_update_date,
1426: l_okc_timevalues_tl_rec.last_update_login);

Line 1423: l_okc_timevalues_tl_rec.creation_date,

1419: l_okc_timevalues_tl_rec.short_description,
1420: l_okc_timevalues_tl_rec.comments,
1421: l_okc_timevalues_tl_rec.name,
1422: l_okc_timevalues_tl_rec.created_by,
1423: l_okc_timevalues_tl_rec.creation_date,
1424: l_okc_timevalues_tl_rec.last_updated_by,
1425: l_okc_timevalues_tl_rec.last_update_date,
1426: l_okc_timevalues_tl_rec.last_update_login);
1427: END LOOP;

Line 1424: l_okc_timevalues_tl_rec.last_updated_by,

1420: l_okc_timevalues_tl_rec.comments,
1421: l_okc_timevalues_tl_rec.name,
1422: l_okc_timevalues_tl_rec.created_by,
1423: l_okc_timevalues_tl_rec.creation_date,
1424: l_okc_timevalues_tl_rec.last_updated_by,
1425: l_okc_timevalues_tl_rec.last_update_date,
1426: l_okc_timevalues_tl_rec.last_update_login);
1427: END LOOP;
1428: -- Set OUT values

Line 1425: l_okc_timevalues_tl_rec.last_update_date,

1421: l_okc_timevalues_tl_rec.name,
1422: l_okc_timevalues_tl_rec.created_by,
1423: l_okc_timevalues_tl_rec.creation_date,
1424: l_okc_timevalues_tl_rec.last_updated_by,
1425: l_okc_timevalues_tl_rec.last_update_date,
1426: l_okc_timevalues_tl_rec.last_update_login);
1427: END LOOP;
1428: -- Set OUT values
1429: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

Line 1426: l_okc_timevalues_tl_rec.last_update_login);

1422: l_okc_timevalues_tl_rec.created_by,
1423: l_okc_timevalues_tl_rec.creation_date,
1424: l_okc_timevalues_tl_rec.last_updated_by,
1425: l_okc_timevalues_tl_rec.last_update_date,
1426: l_okc_timevalues_tl_rec.last_update_login);
1427: END LOOP;
1428: -- Set OUT values
1429: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1430: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1429: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

1425: l_okc_timevalues_tl_rec.last_update_date,
1426: l_okc_timevalues_tl_rec.last_update_login);
1427: END LOOP;
1428: -- Set OUT values
1429: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1430: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1431: EXCEPTION
1432: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1433: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1483: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1479: l_cylv_rec cylv_rec_type;
1480: l_def_cylv_rec cylv_rec_type;
1481: l_tve_rec tve_rec_type;
1482: lx_tve_rec tve_rec_type;
1483: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1484: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1485: -------------------------------
1486: -- FUNCTION fill_who_columns --
1487: -------------------------------

Line 1484: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1480: l_def_cylv_rec cylv_rec_type;
1481: l_tve_rec tve_rec_type;
1482: lx_tve_rec tve_rec_type;
1483: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1484: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1485: -------------------------------
1486: -- FUNCTION fill_who_columns --
1487: -------------------------------
1488: FUNCTION fill_who_columns (

Line 1562: --Bug 3122962 migrate(l_def_cylv_rec, l_okc_timevalues_tl_rec);

1558: --------------------------------------
1559: -- Move VIEW record to "Child" records
1560: --------------------------------------
1561: migrate(l_def_cylv_rec, l_tve_rec);
1562: --Bug 3122962 migrate(l_def_cylv_rec, l_okc_timevalues_tl_rec);
1563: --------------------------------------------
1564: -- Call the INSERT_ROW for each child record
1565: --------------------------------------------
1566: insert_row(

Line 1587: l_okc_timevalues_tl_rec,

1583: p_init_msg_list,
1584: x_return_status,
1585: x_msg_count,
1586: x_msg_data,
1587: l_okc_timevalues_tl_rec,
1588: lx_okc_timevalues_tl_rec
1589: );
1590: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1588: lx_okc_timevalues_tl_rec

1584: x_return_status,
1585: x_msg_count,
1586: x_msg_data,
1587: l_okc_timevalues_tl_rec,
1588: lx_okc_timevalues_tl_rec
1589: );
1590: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1595: migrate(lx_okc_timevalues_tl_rec, l_def_cylv_rec);

1591: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1593: RAISE OKC_API.G_EXCEPTION_ERROR;
1594: END IF;
1595: migrate(lx_okc_timevalues_tl_rec, l_def_cylv_rec);
1596: */
1597: -- Set OUT values
1598: x_cylv_rec := l_def_cylv_rec;
1599: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1702: -- lock_row for:OKC_TIMEVALUES_B --

1698: ---------------------------------------------------------------------------
1699: -- PROCEDURE lock_row
1700: ---------------------------------------------------------------------------
1701: -----------------------------------
1702: -- lock_row for:OKC_TIMEVALUES_B --
1703: -----------------------------------
1704: PROCEDURE lock_row(
1705: p_init_msg_list IN VARCHAR2 ,
1706: x_return_status OUT NOCOPY VARCHAR2,

Line 1716: FROM OKC_TIMEVALUES

1712: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1713: CURSOR lock_csr (p_tve_rec IN tve_rec_type) IS
1714: --Bug 3122962
1715: SELECT OBJECT_VERSION_NUMBER
1716: FROM OKC_TIMEVALUES
1717: WHERE ID = p_tve_rec.id
1718: AND OBJECT_VERSION_NUMBER = p_tve_rec.object_version_number
1719: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1720:

Line 1723: FROM OKC_TIMEVALUES

1719: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1720:
1721: CURSOR lchk_csr (p_tve_rec IN tve_rec_type) IS
1722: SELECT OBJECT_VERSION_NUMBER
1723: FROM OKC_TIMEVALUES
1724: WHERE ID = p_tve_rec.id;
1725: l_api_version CONSTANT NUMBER := 1;
1726: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1727: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1728: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1724: WHERE ID = p_tve_rec.id;
1725: l_api_version CONSTANT NUMBER := 1;
1726: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1727: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1728: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1729: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1730: l_row_notfound BOOLEAN := FALSE;
1731: lc_row_notfound BOOLEAN := FALSE;
1732: BEGIN

Line 1729: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1725: l_api_version CONSTANT NUMBER := 1;
1726: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1727: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1728: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1729: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1730: l_row_notfound BOOLEAN := FALSE;
1731: lc_row_notfound BOOLEAN := FALSE;
1732: BEGIN
1733: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1809: -- lock_row for:OKC_TIMEVALUES_TL --

1805: '_PVT'
1806: );
1807: END lock_row;
1808: ------------------------------------
1809: -- lock_row for:OKC_TIMEVALUES_TL --
1810: ------------------------------------
1811: --Bug 3122962
1812: /* PROCEDURE lock_row(
1813: p_init_msg_list IN VARCHAR2 ,

Line 1817: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

1813: p_init_msg_list IN VARCHAR2 ,
1814: x_return_status OUT NOCOPY VARCHAR2,
1815: x_msg_count OUT NOCOPY NUMBER,
1816: x_msg_data OUT NOCOPY VARCHAR2,
1817: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1818:
1819: E_Resource_Busy EXCEPTION;
1820: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1821: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

Line 1821: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

1817: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1818:
1819: E_Resource_Busy EXCEPTION;
1820: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1821: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1822: SELECT id
1823: FROM OKC_TIMEVALUES_TL
1824: WHERE ID = p_okc_timevalues_tl_rec.id
1825: FOR UPDATE NOWAIT;

Line 1823: FROM OKC_TIMEVALUES_TL

1819: E_Resource_Busy EXCEPTION;
1820: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1821: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1822: SELECT id
1823: FROM OKC_TIMEVALUES_TL
1824: WHERE ID = p_okc_timevalues_tl_rec.id
1825: FOR UPDATE NOWAIT;
1826:
1827: l_api_version CONSTANT NUMBER := 1;

Line 1824: WHERE ID = p_okc_timevalues_tl_rec.id

1820: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1821: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1822: SELECT id
1823: FROM OKC_TIMEVALUES_TL
1824: WHERE ID = p_okc_timevalues_tl_rec.id
1825: FOR UPDATE NOWAIT;
1826:
1827: l_api_version CONSTANT NUMBER := 1;
1828: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1844: OPEN lock_csr(p_okc_timevalues_tl_rec);

1840: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1841: RAISE OKC_API.G_EXCEPTION_ERROR;
1842: END IF;
1843: BEGIN
1844: OPEN lock_csr(p_okc_timevalues_tl_rec);
1845: FETCH lock_csr INTO l_lock_var;
1846: l_row_notfound := lock_csr%NOTFOUND;
1847: CLOSE lock_csr;
1848: EXCEPTION

Line 1909: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1905: l_api_version CONSTANT NUMBER := 1;
1906: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1907: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1908: l_tve_rec tve_rec_type;
1909: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1910: BEGIN
1911: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1912: G_PKG_NAME,
1913: p_init_msg_list,

Line 1927: --Bug 3122962 migrate(p_cylv_rec, l_okc_timevalues_tl_rec);

1923: --------------------------------------
1924: -- Move VIEW record to "Child" records
1925: --------------------------------------
1926: migrate(p_cylv_rec, l_tve_rec);
1927: --Bug 3122962 migrate(p_cylv_rec, l_okc_timevalues_tl_rec);
1928: --------------------------------------------
1929: -- Call the LOCK_ROW for each child record
1930: --------------------------------------------
1931: lock_row(

Line 1950: l_okc_timevalues_tl_rec

1946: p_init_msg_list,
1947: x_return_status,
1948: x_msg_count,
1949: x_msg_data,
1950: l_okc_timevalues_tl_rec
1951: );
1952: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1953: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1954: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2059: -- update_row for:OKC_TIMEVALUES_B --

2055: ---------------------------------------------------------------------------
2056: -- PROCEDURE update_row
2057: ---------------------------------------------------------------------------
2058: -------------------------------------
2059: -- update_row for:OKC_TIMEVALUES_B --
2060: -------------------------------------
2061: PROCEDURE update_row(
2062: p_init_msg_list IN VARCHAR2 ,
2063: x_return_status OUT NOCOPY VARCHAR2,

Line 2298: -- Set_Attributes for:OKC_TIMEVALUES_B --

2294:
2295: RETURN(l_return_status);
2296: END populate_new_record;
2297: -----------------------------------------
2298: -- Set_Attributes for:OKC_TIMEVALUES_B --
2299: -----------------------------------------
2300: FUNCTION Set_Attributes (
2301: p_tve_rec IN tve_rec_type,
2302: x_tve_rec OUT NOCOPY tve_rec_type

Line 2335: UPDATE OKC_TIMEVALUES

2331: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2332: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2333: RAISE OKC_API.G_EXCEPTION_ERROR;
2334: END IF;
2335: UPDATE OKC_TIMEVALUES
2336: SET SPN_ID = l_def_tve_rec.spn_id,
2337: TVE_ID_OFFSET = l_def_tve_rec.tve_id_offset,
2338: uom_code = l_def_tve_rec.uom_code,
2339: CNH_ID = l_def_tve_rec.cnh_id,

Line 2423: -- update_row for:OKC_TIMEVALUES_TL --

2419: '_PVT'
2420: );
2421: END update_row;
2422: --------------------------------------
2423: -- update_row for:OKC_TIMEVALUES_TL --
2424: --------------------------------------
2425: --Bug 3122962
2426: /*
2427: PROCEDURE update_row(

Line 2432: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2428: p_init_msg_list IN VARCHAR2 ,
2429: x_return_status OUT NOCOPY VARCHAR2,
2430: x_msg_count OUT NOCOPY NUMBER,
2431: x_msg_data OUT NOCOPY VARCHAR2,
2432: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2433: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2434:
2435: l_api_version CONSTANT NUMBER := 1;
2436: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2433: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

2429: x_return_status OUT NOCOPY VARCHAR2,
2430: x_msg_count OUT NOCOPY NUMBER,
2431: x_msg_data OUT NOCOPY VARCHAR2,
2432: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2433: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2434:
2435: l_api_version CONSTANT NUMBER := 1;
2436: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2437: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2438: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

2434:
2435: l_api_version CONSTANT NUMBER := 1;
2436: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2437: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2438: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2439: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2440: l_row_notfound BOOLEAN := TRUE;
2441: ----------------------------------
2442: -- FUNCTION populate_new_record --

Line 2439: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2435: l_api_version CONSTANT NUMBER := 1;
2436: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2437: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2438: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2439: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2440: l_row_notfound BOOLEAN := TRUE;
2441: ----------------------------------
2442: -- FUNCTION populate_new_record --
2443: ----------------------------------

Line 2445: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2441: ----------------------------------
2442: -- FUNCTION populate_new_record --
2443: ----------------------------------
2444: FUNCTION populate_new_record (
2445: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2446: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2447: ) RETURN VARCHAR2 IS
2448: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2449: l_row_notfound BOOLEAN := TRUE;

Line 2446: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2442: -- FUNCTION populate_new_record --
2443: ----------------------------------
2444: FUNCTION populate_new_record (
2445: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2446: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2447: ) RETURN VARCHAR2 IS
2448: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2449: l_row_notfound BOOLEAN := TRUE;
2450: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2448: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2444: FUNCTION populate_new_record (
2445: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2446: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2447: ) RETURN VARCHAR2 IS
2448: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2449: l_row_notfound BOOLEAN := TRUE;
2450: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2451: BEGIN
2452: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2452: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2448: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2449: l_row_notfound BOOLEAN := TRUE;
2450: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2451: BEGIN
2452: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2453: -- Get current database values
2454: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2455: IF (l_row_notfound) THEN
2456: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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

2450: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2451: BEGIN
2452: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2453: -- Get current database values
2454: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2455: IF (l_row_notfound) THEN
2456: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2457: END IF;
2458: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)

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

2454: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2455: IF (l_row_notfound) THEN
2456: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2457: END IF;
2458: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2459: THEN
2460: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2461: END IF;
2462: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)

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

2456: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2457: END IF;
2458: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2459: THEN
2460: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2461: END IF;
2462: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2463: THEN
2464: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;

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

2458: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2459: THEN
2460: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2461: END IF;
2462: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2463: THEN
2464: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2465: END IF;
2466: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

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

2460: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2461: END IF;
2462: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2463: THEN
2464: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2465: END IF;
2466: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2467: THEN
2468: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;

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

2462: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2463: THEN
2464: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2465: END IF;
2466: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2467: THEN
2468: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2469: END IF;
2470: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

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

2464: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2465: END IF;
2466: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2467: THEN
2468: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2469: END IF;
2470: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2471: THEN
2472: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;

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

2466: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2467: THEN
2468: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2469: END IF;
2470: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2471: THEN
2472: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2473: END IF;
2474: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)

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

2468: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2469: END IF;
2470: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2471: THEN
2472: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2473: END IF;
2474: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2475: THEN
2476: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;

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

2470: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2471: THEN
2472: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2473: END IF;
2474: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2475: THEN
2476: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2477: END IF;
2478: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)

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

2472: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2473: END IF;
2474: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2475: THEN
2476: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2477: END IF;
2478: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2479: THEN
2480: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;

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

2474: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2475: THEN
2476: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2477: END IF;
2478: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2479: THEN
2480: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2481: END IF;
2482: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)

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

2476: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2477: END IF;
2478: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2479: THEN
2480: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2481: END IF;
2482: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2483: THEN
2484: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;

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

2478: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2479: THEN
2480: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2481: END IF;
2482: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2483: THEN
2484: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2485: END IF;
2486: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)

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

2480: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2481: END IF;
2482: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2483: THEN
2484: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2485: END IF;
2486: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2487: THEN
2488: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;

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

2482: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2483: THEN
2484: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2485: END IF;
2486: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2487: THEN
2488: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2489: END IF;
2490: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)

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

2484: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2485: END IF;
2486: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2487: THEN
2488: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2489: END IF;
2490: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2491: THEN
2492: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;

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

2486: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2487: THEN
2488: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2489: END IF;
2490: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2491: THEN
2492: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2493: END IF;
2494: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)

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

2488: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2489: END IF;
2490: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2491: THEN
2492: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2493: END IF;
2494: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2495: THEN
2496: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;

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

2490: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2491: THEN
2492: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2493: END IF;
2494: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2495: THEN
2496: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2497: END IF;
2498: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

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

2492: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2493: END IF;
2494: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2495: THEN
2496: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2497: END IF;
2498: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2499: THEN
2500: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;

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

2494: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2495: THEN
2496: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2497: END IF;
2498: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2499: THEN
2500: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2501: END IF;
2502: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

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

2496: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2497: END IF;
2498: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2499: THEN
2500: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2501: END IF;
2502: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2503: THEN
2504: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;

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

2498: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2499: THEN
2500: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2501: END IF;
2502: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2503: THEN
2504: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2505: END IF;
2506: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

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

2500: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2501: END IF;
2502: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2503: THEN
2504: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2505: END IF;
2506: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2507: THEN
2508: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;

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

2502: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2503: THEN
2504: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2505: END IF;
2506: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2507: THEN
2508: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2509: END IF;
2510: RETURN(l_return_status);

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

2504: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2505: END IF;
2506: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2507: THEN
2508: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2509: END IF;
2510: RETURN(l_return_status);
2511: END populate_new_record;
2512: ------------------------------------------

Line 2513: -- Set_Attributes for:OKC_TIMEVALUES_TL --

2509: END IF;
2510: RETURN(l_return_status);
2511: END populate_new_record;
2512: ------------------------------------------
2513: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2514: ------------------------------------------
2515: FUNCTION Set_Attributes (
2516: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2517: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 2516: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2512: ------------------------------------------
2513: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2514: ------------------------------------------
2515: FUNCTION Set_Attributes (
2516: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2517: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2518: ) RETURN VARCHAR2 IS
2519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2520: BEGIN

Line 2517: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2513: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2514: ------------------------------------------
2515: FUNCTION Set_Attributes (
2516: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2517: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2518: ) RETURN VARCHAR2 IS
2519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2520: BEGIN
2521: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2521: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2517: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2518: ) RETURN VARCHAR2 IS
2519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2520: BEGIN
2521: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2522: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2523: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2524: RETURN(l_return_status);
2525: END Set_Attributes;

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

2518: ) RETURN VARCHAR2 IS
2519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2520: BEGIN
2521: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2522: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2523: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2524: RETURN(l_return_status);
2525: END Set_Attributes;
2526: BEGIN

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

2519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2520: BEGIN
2521: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2522: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2523: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2524: RETURN(l_return_status);
2525: END Set_Attributes;
2526: BEGIN
2527: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2538: p_okc_timevalues_tl_rec, -- IN

2534: RAISE OKC_API.G_EXCEPTION_ERROR;
2535: END IF;
2536: --- Setting item attributes
2537: l_return_status := Set_Attributes(
2538: p_okc_timevalues_tl_rec, -- IN
2539: l_okc_timevalues_tl_rec); -- OUT
2540: --- If any errors happen abort API
2541: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2542: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2539: l_okc_timevalues_tl_rec); -- OUT

2535: END IF;
2536: --- Setting item attributes
2537: l_return_status := Set_Attributes(
2538: p_okc_timevalues_tl_rec, -- IN
2539: l_okc_timevalues_tl_rec); -- OUT
2540: --- If any errors happen abort API
2541: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2542: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2543: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

2542: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2543: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2544: RAISE OKC_API.G_EXCEPTION_ERROR;
2545: END IF;
2546: l_return_status := populate_new_record(l_okc_timevalues_tl_rec, l_def_okc_timevalues_tl_rec);
2547: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2548: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2549: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2550: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2552: UPDATE OKC_TIMEVALUES_TL

2548: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2549: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2550: RAISE OKC_API.G_EXCEPTION_ERROR;
2551: END IF;
2552: UPDATE OKC_TIMEVALUES_TL
2553: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2554: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2555: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2556: NAME = l_def_okc_timevalues_tl_rec.name,

Line 2553: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,

2549: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2550: RAISE OKC_API.G_EXCEPTION_ERROR;
2551: END IF;
2552: UPDATE OKC_TIMEVALUES_TL
2553: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2554: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2555: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2556: NAME = l_def_okc_timevalues_tl_rec.name,
2557: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

Line 2554: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,

2550: RAISE OKC_API.G_EXCEPTION_ERROR;
2551: END IF;
2552: UPDATE OKC_TIMEVALUES_TL
2553: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2554: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2555: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2556: NAME = l_def_okc_timevalues_tl_rec.name,
2557: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2558: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

Line 2555: COMMENTS = l_def_okc_timevalues_tl_rec.comments,

2551: END IF;
2552: UPDATE OKC_TIMEVALUES_TL
2553: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2554: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2555: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2556: NAME = l_def_okc_timevalues_tl_rec.name,
2557: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2558: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2559: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

Line 2556: NAME = l_def_okc_timevalues_tl_rec.name,

2552: UPDATE OKC_TIMEVALUES_TL
2553: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2554: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2555: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2556: NAME = l_def_okc_timevalues_tl_rec.name,
2557: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2558: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2559: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2560: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

Line 2557: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

2553: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2554: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2555: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2556: NAME = l_def_okc_timevalues_tl_rec.name,
2557: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2558: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2559: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2560: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2561: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

Line 2558: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

2554: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2555: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2556: NAME = l_def_okc_timevalues_tl_rec.name,
2557: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2558: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2559: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2560: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2561: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2562: WHERE ID = l_def_okc_timevalues_tl_rec.id

Line 2559: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

2555: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2556: NAME = l_def_okc_timevalues_tl_rec.name,
2557: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2558: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2559: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2560: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2561: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2562: WHERE ID = l_def_okc_timevalues_tl_rec.id
2563: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);

Line 2560: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

2556: NAME = l_def_okc_timevalues_tl_rec.name,
2557: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2558: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2559: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2560: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2561: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2562: WHERE ID = l_def_okc_timevalues_tl_rec.id
2563: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2564:

Line 2561: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

2557: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2558: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2559: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2560: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2561: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2562: WHERE ID = l_def_okc_timevalues_tl_rec.id
2563: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2564:
2565: UPDATE OKC_TIMEVALUES_TL

Line 2562: WHERE ID = l_def_okc_timevalues_tl_rec.id

2558: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2559: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2560: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2561: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2562: WHERE ID = l_def_okc_timevalues_tl_rec.id
2563: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2564:
2565: UPDATE OKC_TIMEVALUES_TL
2566: SET SFWT_FLAG = 'Y'

Line 2565: UPDATE OKC_TIMEVALUES_TL

2561: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2562: WHERE ID = l_def_okc_timevalues_tl_rec.id
2563: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2564:
2565: UPDATE OKC_TIMEVALUES_TL
2566: SET SFWT_FLAG = 'Y'
2567: WHERE ID = l_def_okc_timevalues_tl_rec.id
2568: AND SOURCE_LANG <> USERENV('LANG');
2569: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;

Line 2567: WHERE ID = l_def_okc_timevalues_tl_rec.id

2563: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2564:
2565: UPDATE OKC_TIMEVALUES_TL
2566: SET SFWT_FLAG = 'Y'
2567: WHERE ID = l_def_okc_timevalues_tl_rec.id
2568: AND SOURCE_LANG <> USERENV('LANG');
2569: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2570: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2571: EXCEPTION

Line 2569: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;

2565: UPDATE OKC_TIMEVALUES_TL
2566: SET SFWT_FLAG = 'Y'
2567: WHERE ID = l_def_okc_timevalues_tl_rec.id
2568: AND SOURCE_LANG <> USERENV('LANG');
2569: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2570: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2571: EXCEPTION
2572: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2573: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2621: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2617: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2618: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2619: l_cylv_rec cylv_rec_type := p_cylv_rec;
2620: l_def_cylv_rec cylv_rec_type;
2621: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2622: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2623: l_tve_rec tve_rec_type;
2624: lx_tve_rec tve_rec_type;
2625: -------------------------------

Line 2622: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2618: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2619: l_cylv_rec cylv_rec_type := p_cylv_rec;
2620: l_def_cylv_rec cylv_rec_type;
2621: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2622: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2623: l_tve_rec tve_rec_type;
2624: lx_tve_rec tve_rec_type;
2625: -------------------------------
2626: -- FUNCTION fill_who_columns --

Line 2853: --Bug 3122962 migrate(l_def_cylv_rec, l_okc_timevalues_tl_rec);

2849:
2850: --------------------------------------
2851: -- Move VIEW record to "Child" records
2852: --------------------------------------
2853: --Bug 3122962 migrate(l_def_cylv_rec, l_okc_timevalues_tl_rec);
2854: migrate(l_def_cylv_rec, l_tve_rec);
2855: --------------------------------------------
2856: -- Call the UPDATE_ROW for each child record
2857: --------------------------------------------

Line 2863: l_okc_timevalues_tl_rec,

2859: p_init_msg_list,
2860: x_return_status,
2861: x_msg_count,
2862: x_msg_data,
2863: l_okc_timevalues_tl_rec,
2864: lx_okc_timevalues_tl_rec
2865: );
2866: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2864: lx_okc_timevalues_tl_rec

2860: x_return_status,
2861: x_msg_count,
2862: x_msg_data,
2863: l_okc_timevalues_tl_rec,
2864: lx_okc_timevalues_tl_rec
2865: );
2866: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2868: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2871: migrate(lx_okc_timevalues_tl_rec, l_def_cylv_rec);

2867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2868: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2869: RAISE OKC_API.G_EXCEPTION_ERROR;
2870: END IF;
2871: migrate(lx_okc_timevalues_tl_rec, l_def_cylv_rec);
2872: */
2873: update_row(
2874: p_init_msg_list,
2875: x_return_status,

Line 2991: -- delete_row for:OKC_TIMEVALUES_B --

2987: ---------------------------------------------------------------------------
2988: -- PROCEDURE delete_row
2989: ---------------------------------------------------------------------------
2990: -------------------------------------
2991: -- delete_row for:OKC_TIMEVALUES_B --
2992: -------------------------------------
2993: PROCEDURE delete_row(
2994: p_init_msg_list IN VARCHAR2 ,
2995: x_return_status OUT NOCOPY VARCHAR2,

Line 3016: DELETE FROM OKC_TIMEVALUES

3012: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3013: RAISE OKC_API.G_EXCEPTION_ERROR;
3014: END IF;
3015: --Bug 3122962
3016: DELETE FROM OKC_TIMEVALUES
3017: WHERE ID = l_tve_rec.id;
3018:
3019: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3020: EXCEPTION

Line 3053: -- delete_row for:OKC_TIMEVALUES_TL --

3049: '_PVT'
3050: );
3051: END delete_row;
3052: --------------------------------------
3053: -- delete_row for:OKC_TIMEVALUES_TL --
3054: --------------------------------------
3055: /* PROCEDURE delete_row(
3056: p_init_msg_list IN VARCHAR2 ,
3057: x_return_status OUT NOCOPY VARCHAR2,

Line 3060: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

3056: p_init_msg_list IN VARCHAR2 ,
3057: x_return_status OUT NOCOPY VARCHAR2,
3058: x_msg_count OUT NOCOPY NUMBER,
3059: x_msg_data OUT NOCOPY VARCHAR2,
3060: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
3061:
3062: l_api_version CONSTANT NUMBER := 1;
3063: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3064: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3065: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;

3061:
3062: l_api_version CONSTANT NUMBER := 1;
3063: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3064: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3065: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3066: l_row_notfound BOOLEAN := TRUE;
3067: ------------------------------------------
3068: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3069: ------------------------------------------

Line 3068: -- Set_Attributes for:OKC_TIMEVALUES_TL --

3064: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3065: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3066: l_row_notfound BOOLEAN := TRUE;
3067: ------------------------------------------
3068: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3069: ------------------------------------------
3070: FUNCTION Set_Attributes (
3071: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3072: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 3071: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

3067: ------------------------------------------
3068: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3069: ------------------------------------------
3070: FUNCTION Set_Attributes (
3071: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3072: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3073: ) RETURN VARCHAR2 IS
3074: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3075: BEGIN

Line 3072: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

3068: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3069: ------------------------------------------
3070: FUNCTION Set_Attributes (
3071: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3072: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3073: ) RETURN VARCHAR2 IS
3074: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3075: BEGIN
3076: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 3076: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

3072: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3073: ) RETURN VARCHAR2 IS
3074: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3075: BEGIN
3076: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3077: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3078: RETURN(l_return_status);
3079: END Set_Attributes;
3080: BEGIN

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

3073: ) RETURN VARCHAR2 IS
3074: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3075: BEGIN
3076: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3077: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3078: RETURN(l_return_status);
3079: END Set_Attributes;
3080: BEGIN
3081: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3092: p_okc_timevalues_tl_rec, -- IN

3088: RAISE OKC_API.G_EXCEPTION_ERROR;
3089: END IF;
3090: --- Setting item attributes
3091: l_return_status := Set_Attributes(
3092: p_okc_timevalues_tl_rec, -- IN
3093: l_okc_timevalues_tl_rec); -- OUT
3094: --- If any errors happen abort API
3095: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3096: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3093: l_okc_timevalues_tl_rec); -- OUT

3089: END IF;
3090: --- Setting item attributes
3091: l_return_status := Set_Attributes(
3092: p_okc_timevalues_tl_rec, -- IN
3093: l_okc_timevalues_tl_rec); -- OUT
3094: --- If any errors happen abort API
3095: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3096: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3097: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3100: DELETE FROM OKC_TIMEVALUES_TL

3096: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3097: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3098: RAISE OKC_API.G_EXCEPTION_ERROR;
3099: END IF;
3100: DELETE FROM OKC_TIMEVALUES_TL
3101: WHERE ID = l_okc_timevalues_tl_rec.id;
3102:
3103: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3104: EXCEPTION

Line 3101: WHERE ID = l_okc_timevalues_tl_rec.id;

3097: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3098: RAISE OKC_API.G_EXCEPTION_ERROR;
3099: END IF;
3100: DELETE FROM OKC_TIMEVALUES_TL
3101: WHERE ID = l_okc_timevalues_tl_rec.id;
3102:
3103: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3104: EXCEPTION
3105: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3152: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

3148: l_api_version CONSTANT NUMBER := 1;
3149: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3150: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3151: l_cylv_rec cylv_rec_type := p_cylv_rec;
3152: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
3153: l_tve_rec tve_rec_type;
3154: BEGIN
3155: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3156: G_PKG_NAME,

Line 3170: --Bug 3122962 migrate(l_cylv_rec, l_okc_timevalues_tl_rec);

3166: END IF;
3167: --------------------------------------
3168: -- Move VIEW record to "Child" records
3169: --------------------------------------
3170: --Bug 3122962 migrate(l_cylv_rec, l_okc_timevalues_tl_rec);
3171: migrate(l_cylv_rec, l_tve_rec);
3172: --------------------------------------------
3173: -- Call the DELETE_ROW for each child record
3174: --------------------------------------------

Line 3180: l_okc_timevalues_tl_rec

3176: p_init_msg_list,
3177: x_return_status,
3178: x_msg_count,
3179: x_msg_data,
3180: l_okc_timevalues_tl_rec
3181: );
3182: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3183: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3184: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN