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_TAV_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: /* FUNCTION get_rec (
175: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
176: x_no_data_found OUT NOCOPY BOOLEAN

Line 175: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

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

Line 177: ) RETURN okc_timevalues_tl_rec_type IS

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

Line 194: FROM Okc_Timevalues_Tl

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

Line 195: WHERE okc_timevalues_tl.id = p_id

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

Line 196: AND okc_timevalues_tl.language = p_language;

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

Line 198: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

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

Line 202: OPEN tve_pktl_csr (p_okc_timevalues_tl_rec.id,

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

Line 203: p_okc_timevalues_tl_rec.language);

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

Line 205: l_okc_timevalues_tl_rec.ID,

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

Line 206: l_okc_timevalues_tl_rec.LANGUAGE,

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

Line 207: l_okc_timevalues_tl_rec.SOURCE_LANG,

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

Line 208: l_okc_timevalues_tl_rec.SFWT_FLAG,

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

Line 209: l_okc_timevalues_tl_rec.DESCRIPTION,

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

Line 210: l_okc_timevalues_tl_rec.SHORT_DESCRIPTION,

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

Line 211: l_okc_timevalues_tl_rec.COMMENTS,

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

Line 212: l_okc_timevalues_tl_rec.NAME,

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

Line 213: l_okc_timevalues_tl_rec.CREATED_BY,

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

Line 214: l_okc_timevalues_tl_rec.CREATION_DATE,

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

Line 215: l_okc_timevalues_tl_rec.LAST_UPDATED_BY,

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

Line 216: l_okc_timevalues_tl_rec.LAST_UPDATE_DATE,

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

Line 217: l_okc_timevalues_tl_rec.LAST_UPDATE_LOGIN;

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

Line 220: RETURN(l_okc_timevalues_tl_rec);

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

Line 224: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type

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

Line 225: ) RETURN okc_timevalues_tl_rec_type IS

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

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

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

Line 439: -- FUNCTION null_out_defaults for: OKC_TIMEVALUES_V --

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

Line 517: p_tve_tl_rec IN okc_timevalues_tl_rec_type

513: RETURN(l_tve_rec);
514: END null_out_defaults;
515:
516: /* FUNCTION null_out_defaults (
517: p_tve_tl_rec IN okc_timevalues_tl_rec_type
518: ) RETURN okc_timevalues_tl_rec_type IS
519: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
520: BEGIN
521: IF (l_tve_tl_rec.name = OKC_API.G_MISS_CHAR) THEN

Line 518: ) RETURN okc_timevalues_tl_rec_type IS

514: END null_out_defaults;
515:
516: /* FUNCTION null_out_defaults (
517: p_tve_tl_rec IN okc_timevalues_tl_rec_type
518: ) RETURN okc_timevalues_tl_rec_type IS
519: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
520: BEGIN
521: IF (l_tve_tl_rec.name = OKC_API.G_MISS_CHAR) THEN
522: l_tve_tl_rec.name := NULL;

Line 519: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;

515:
516: /* FUNCTION null_out_defaults (
517: p_tve_tl_rec IN okc_timevalues_tl_rec_type
518: ) RETURN okc_timevalues_tl_rec_type IS
519: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
520: BEGIN
521: IF (l_tve_tl_rec.name = OKC_API.G_MISS_CHAR) THEN
522: l_tve_tl_rec.name := NULL;
523: END IF;

Line 580: FROM Okc_Timevalues

576: item_not_found_error EXCEPTION;
577: l_row_notfound BOOLEAN := TRUE;
578: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
579: SELECT '1'
580: FROM Okc_Timevalues
581: WHERE id = p_id;
582: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
583: BEGIN
584: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 620: FROM Okc_Timevalues

616: item_not_found_error EXCEPTION;
617: l_row_notfound BOOLEAN := TRUE;
618: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
619: SELECT '1'
620: FROM Okc_Timevalues
621: WHERE id = p_id
622: and tve_type in ('ISE','IGS');
623: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
624: BEGIN

Line 1004: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type

1000: END migrate;
1001: /*
1002: PROCEDURE migrate (
1003: p_from IN tavv_rec_type,
1004: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
1005: ) IS
1006: l_tve_tl_type okc_timevalues_tl_rec_type;
1007: BEGIN
1008: p_to.id := p_from.id;

Line 1006: l_tve_tl_type okc_timevalues_tl_rec_type;

1002: PROCEDURE migrate (
1003: p_from IN tavv_rec_type,
1004: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
1005: ) IS
1006: l_tve_tl_type okc_timevalues_tl_rec_type;
1007: BEGIN
1008: p_to.id := p_from.id;
1009: p_to.sfwt_flag := p_from.sfwt_flag;
1010: p_to.description := p_from.description;

Line 1024: p_from IN okc_timevalues_tl_rec_type,

1020: l_tve_tl_type := null_out_defaults(p_to);
1021: p_to := l_tve_tl_type;
1022: END migrate;
1023: PROCEDURE migrate (
1024: p_from IN okc_timevalues_tl_rec_type,
1025: p_to IN OUT NOCOPY tavv_rec_type
1026: ) IS
1027: BEGIN
1028: p_to.id := p_from.id;

Line 1059: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1055: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1056: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1057: l_tavv_rec tavv_rec_type := p_tavv_rec;
1058: l_tve_rec tve_rec_type;
1059: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1060: BEGIN
1061: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1062: G_PKG_NAME,
1063: p_init_msg_list,

Line 1188: -- insert_row for:OKC_TIMEVALUES_B --

1184: ---------------------------------------------------------------------------
1185: -- PROCEDURE insert_row
1186: ---------------------------------------------------------------------------
1187: -------------------------------------
1188: -- insert_row for:OKC_TIMEVALUES_B --
1189: -------------------------------------
1190: PROCEDURE insert_row(
1191: p_init_msg_list IN VARCHAR2,
1192: x_return_status OUT NOCOPY VARCHAR2,

Line 1204: -- Set_Attributes for:OKC_TIMEVALUES_B --

1200: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1201: l_tve_rec tve_rec_type := p_tve_rec;
1202: l_def_tve_rec tve_rec_type;
1203: -----------------------------------------
1204: -- Set_Attributes for:OKC_TIMEVALUES_B --
1205: -----------------------------------------
1206: FUNCTION Set_Attributes (
1207: p_tve_rec IN tve_rec_type,
1208: x_tve_rec OUT NOCOPY tve_rec_type

Line 1235: INSERT INTO OKC_TIMEVALUES(

1231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1233: RAISE OKC_API.G_EXCEPTION_ERROR;
1234: END IF;
1235: INSERT INTO OKC_TIMEVALUES(
1236: id,
1237: spn_id,
1238: tve_id_offset,
1239: uom_code,

Line 1377: -- insert_row for:OKC_TIMEVALUES_TL --

1373: '_PVT'
1374: );
1375: END insert_row;
1376: --------------------------------------
1377: -- insert_row for:OKC_TIMEVALUES_TL --
1378: --------------------------------------
1379: /* PROCEDURE insert_row(
1380: p_init_msg_list IN VARCHAR2,
1381: x_return_status OUT NOCOPY VARCHAR2,

Line 1384: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1380: p_init_msg_list IN VARCHAR2,
1381: x_return_status OUT NOCOPY VARCHAR2,
1382: x_msg_count OUT NOCOPY NUMBER,
1383: x_msg_data OUT NOCOPY VARCHAR2,
1384: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1385: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1386:
1387: l_api_version CONSTANT NUMBER := 1;
1388: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1385: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

1381: x_return_status OUT NOCOPY VARCHAR2,
1382: x_msg_count OUT NOCOPY NUMBER,
1383: x_msg_data OUT NOCOPY VARCHAR2,
1384: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1385: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1386:
1387: l_api_version CONSTANT NUMBER := 1;
1388: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1390: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

1386:
1387: l_api_version CONSTANT NUMBER := 1;
1388: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1390: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1391: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1392: CURSOR get_languages IS
1393: SELECT *
1394: FROM FND_LANGUAGES

Line 1391: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1387: l_api_version CONSTANT NUMBER := 1;
1388: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1390: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1391: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1392: CURSOR get_languages IS
1393: SELECT *
1394: FROM FND_LANGUAGES
1395: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1397: -- Set_Attributes for:OKC_TIMEVALUES_TL --

1393: SELECT *
1394: FROM FND_LANGUAGES
1395: WHERE INSTALLED_FLAG IN ('I', 'B');
1396: ------------------------------------------
1397: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1398: ------------------------------------------
1399: FUNCTION Set_Attributes (
1400: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1401: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 1400: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1396: ------------------------------------------
1397: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1398: ------------------------------------------
1399: FUNCTION Set_Attributes (
1400: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1401: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1402: ) RETURN VARCHAR2 IS
1403: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1404: BEGIN

Line 1401: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

1397: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1398: ------------------------------------------
1399: FUNCTION Set_Attributes (
1400: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1401: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1402: ) RETURN VARCHAR2 IS
1403: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1404: BEGIN
1405: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 1405: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

1401: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1402: ) RETURN VARCHAR2 IS
1403: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1404: BEGIN
1405: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1406: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1407: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1408: RETURN(l_return_status);
1409: END Set_Attributes;

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

1402: ) RETURN VARCHAR2 IS
1403: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1404: BEGIN
1405: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1406: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1407: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1408: RETURN(l_return_status);
1409: END Set_Attributes;
1410: BEGIN

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

1403: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1404: BEGIN
1405: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1406: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1407: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1408: RETURN(l_return_status);
1409: END Set_Attributes;
1410: BEGIN
1411: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1422: p_okc_timevalues_tl_rec, -- IN

1418: RAISE OKC_API.G_EXCEPTION_ERROR;
1419: END IF;
1420: --- Setting item attributes
1421: l_return_status := Set_Attributes(
1422: p_okc_timevalues_tl_rec, -- IN
1423: l_okc_timevalues_tl_rec); -- OUT
1424: --- If any errors happen abort API
1425: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1423: l_okc_timevalues_tl_rec); -- OUT

1419: END IF;
1420: --- Setting item attributes
1421: l_return_status := Set_Attributes(
1422: p_okc_timevalues_tl_rec, -- IN
1423: l_okc_timevalues_tl_rec); -- OUT
1424: --- If any errors happen abort API
1425: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1427: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

1427: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1428: RAISE OKC_API.G_EXCEPTION_ERROR;
1429: END IF;
1430: FOR l_lang_rec IN get_languages LOOP
1431: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1432: INSERT INTO OKC_TIMEVALUES_TL(
1433: id,
1434: language,
1435: source_lang,

Line 1432: INSERT INTO OKC_TIMEVALUES_TL(

1428: RAISE OKC_API.G_EXCEPTION_ERROR;
1429: END IF;
1430: FOR l_lang_rec IN get_languages LOOP
1431: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1432: INSERT INTO OKC_TIMEVALUES_TL(
1433: id,
1434: language,
1435: source_lang,
1436: sfwt_flag,

Line 1447: l_okc_timevalues_tl_rec.id,

1443: last_updated_by,
1444: last_update_date,
1445: last_update_login)
1446: VALUES (
1447: l_okc_timevalues_tl_rec.id,
1448: l_okc_timevalues_tl_rec.language,
1449: l_okc_timevalues_tl_rec.source_lang,
1450: l_okc_timevalues_tl_rec.sfwt_flag,
1451: l_okc_timevalues_tl_rec.description,

Line 1448: l_okc_timevalues_tl_rec.language,

1444: last_update_date,
1445: last_update_login)
1446: VALUES (
1447: l_okc_timevalues_tl_rec.id,
1448: l_okc_timevalues_tl_rec.language,
1449: l_okc_timevalues_tl_rec.source_lang,
1450: l_okc_timevalues_tl_rec.sfwt_flag,
1451: l_okc_timevalues_tl_rec.description,
1452: l_okc_timevalues_tl_rec.short_description,

Line 1449: l_okc_timevalues_tl_rec.source_lang,

1445: last_update_login)
1446: VALUES (
1447: l_okc_timevalues_tl_rec.id,
1448: l_okc_timevalues_tl_rec.language,
1449: l_okc_timevalues_tl_rec.source_lang,
1450: l_okc_timevalues_tl_rec.sfwt_flag,
1451: l_okc_timevalues_tl_rec.description,
1452: l_okc_timevalues_tl_rec.short_description,
1453: l_okc_timevalues_tl_rec.comments,

Line 1450: l_okc_timevalues_tl_rec.sfwt_flag,

1446: VALUES (
1447: l_okc_timevalues_tl_rec.id,
1448: l_okc_timevalues_tl_rec.language,
1449: l_okc_timevalues_tl_rec.source_lang,
1450: l_okc_timevalues_tl_rec.sfwt_flag,
1451: l_okc_timevalues_tl_rec.description,
1452: l_okc_timevalues_tl_rec.short_description,
1453: l_okc_timevalues_tl_rec.comments,
1454: l_okc_timevalues_tl_rec.name,

Line 1451: l_okc_timevalues_tl_rec.description,

1447: l_okc_timevalues_tl_rec.id,
1448: l_okc_timevalues_tl_rec.language,
1449: l_okc_timevalues_tl_rec.source_lang,
1450: l_okc_timevalues_tl_rec.sfwt_flag,
1451: l_okc_timevalues_tl_rec.description,
1452: l_okc_timevalues_tl_rec.short_description,
1453: l_okc_timevalues_tl_rec.comments,
1454: l_okc_timevalues_tl_rec.name,
1455: l_okc_timevalues_tl_rec.created_by,

Line 1452: l_okc_timevalues_tl_rec.short_description,

1448: l_okc_timevalues_tl_rec.language,
1449: l_okc_timevalues_tl_rec.source_lang,
1450: l_okc_timevalues_tl_rec.sfwt_flag,
1451: l_okc_timevalues_tl_rec.description,
1452: l_okc_timevalues_tl_rec.short_description,
1453: l_okc_timevalues_tl_rec.comments,
1454: l_okc_timevalues_tl_rec.name,
1455: l_okc_timevalues_tl_rec.created_by,
1456: l_okc_timevalues_tl_rec.creation_date,

Line 1453: l_okc_timevalues_tl_rec.comments,

1449: l_okc_timevalues_tl_rec.source_lang,
1450: l_okc_timevalues_tl_rec.sfwt_flag,
1451: l_okc_timevalues_tl_rec.description,
1452: l_okc_timevalues_tl_rec.short_description,
1453: l_okc_timevalues_tl_rec.comments,
1454: l_okc_timevalues_tl_rec.name,
1455: l_okc_timevalues_tl_rec.created_by,
1456: l_okc_timevalues_tl_rec.creation_date,
1457: l_okc_timevalues_tl_rec.last_updated_by,

Line 1454: l_okc_timevalues_tl_rec.name,

1450: l_okc_timevalues_tl_rec.sfwt_flag,
1451: l_okc_timevalues_tl_rec.description,
1452: l_okc_timevalues_tl_rec.short_description,
1453: l_okc_timevalues_tl_rec.comments,
1454: l_okc_timevalues_tl_rec.name,
1455: l_okc_timevalues_tl_rec.created_by,
1456: l_okc_timevalues_tl_rec.creation_date,
1457: l_okc_timevalues_tl_rec.last_updated_by,
1458: l_okc_timevalues_tl_rec.last_update_date,

Line 1455: l_okc_timevalues_tl_rec.created_by,

1451: l_okc_timevalues_tl_rec.description,
1452: l_okc_timevalues_tl_rec.short_description,
1453: l_okc_timevalues_tl_rec.comments,
1454: l_okc_timevalues_tl_rec.name,
1455: l_okc_timevalues_tl_rec.created_by,
1456: l_okc_timevalues_tl_rec.creation_date,
1457: l_okc_timevalues_tl_rec.last_updated_by,
1458: l_okc_timevalues_tl_rec.last_update_date,
1459: l_okc_timevalues_tl_rec.last_update_login);

Line 1456: l_okc_timevalues_tl_rec.creation_date,

1452: l_okc_timevalues_tl_rec.short_description,
1453: l_okc_timevalues_tl_rec.comments,
1454: l_okc_timevalues_tl_rec.name,
1455: l_okc_timevalues_tl_rec.created_by,
1456: l_okc_timevalues_tl_rec.creation_date,
1457: l_okc_timevalues_tl_rec.last_updated_by,
1458: l_okc_timevalues_tl_rec.last_update_date,
1459: l_okc_timevalues_tl_rec.last_update_login);
1460: END LOOP;

Line 1457: l_okc_timevalues_tl_rec.last_updated_by,

1453: l_okc_timevalues_tl_rec.comments,
1454: l_okc_timevalues_tl_rec.name,
1455: l_okc_timevalues_tl_rec.created_by,
1456: l_okc_timevalues_tl_rec.creation_date,
1457: l_okc_timevalues_tl_rec.last_updated_by,
1458: l_okc_timevalues_tl_rec.last_update_date,
1459: l_okc_timevalues_tl_rec.last_update_login);
1460: END LOOP;
1461: -- Set OUT values

Line 1458: l_okc_timevalues_tl_rec.last_update_date,

1454: l_okc_timevalues_tl_rec.name,
1455: l_okc_timevalues_tl_rec.created_by,
1456: l_okc_timevalues_tl_rec.creation_date,
1457: l_okc_timevalues_tl_rec.last_updated_by,
1458: l_okc_timevalues_tl_rec.last_update_date,
1459: l_okc_timevalues_tl_rec.last_update_login);
1460: END LOOP;
1461: -- Set OUT values
1462: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

Line 1459: l_okc_timevalues_tl_rec.last_update_login);

1455: l_okc_timevalues_tl_rec.created_by,
1456: l_okc_timevalues_tl_rec.creation_date,
1457: l_okc_timevalues_tl_rec.last_updated_by,
1458: l_okc_timevalues_tl_rec.last_update_date,
1459: l_okc_timevalues_tl_rec.last_update_login);
1460: END LOOP;
1461: -- Set OUT values
1462: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1463: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1462: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

1458: l_okc_timevalues_tl_rec.last_update_date,
1459: l_okc_timevalues_tl_rec.last_update_login);
1460: END LOOP;
1461: -- Set OUT values
1462: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1463: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1464: EXCEPTION
1465: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1466: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1516: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1512: l_tavv_rec tavv_rec_type;
1513: l_def_tavv_rec tavv_rec_type;
1514: l_tve_rec tve_rec_type;
1515: lx_tve_rec tve_rec_type;
1516: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1517: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1518: -------------------------------
1519: -- FUNCTION fill_who_columns --
1520: -------------------------------

Line 1517: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1513: l_def_tavv_rec tavv_rec_type;
1514: l_tve_rec tve_rec_type;
1515: lx_tve_rec tve_rec_type;
1516: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1517: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1518: -------------------------------
1519: -- FUNCTION fill_who_columns --
1520: -------------------------------
1521: FUNCTION fill_who_columns (

Line 1592: --Bug 3122962 migrate(l_def_tavv_rec, l_okc_timevalues_tl_rec);

1588: --------------------------------------
1589: -- Move VIEW record to "Child" records
1590: --------------------------------------
1591: migrate(l_def_tavv_rec, l_tve_rec);
1592: --Bug 3122962 migrate(l_def_tavv_rec, l_okc_timevalues_tl_rec);
1593: --------------------------------------------
1594: -- Call the INSERT_ROW for each child record
1595: --------------------------------------------
1596: insert_row(

Line 1615: l_okc_timevalues_tl_rec,

1611: p_init_msg_list,
1612: x_return_status,
1613: x_msg_count,
1614: x_msg_data,
1615: l_okc_timevalues_tl_rec,
1616: lx_okc_timevalues_tl_rec
1617: );
1618: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1619: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1616: lx_okc_timevalues_tl_rec

1612: x_return_status,
1613: x_msg_count,
1614: x_msg_data,
1615: l_okc_timevalues_tl_rec,
1616: lx_okc_timevalues_tl_rec
1617: );
1618: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1619: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1620: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1623: migrate(lx_okc_timevalues_tl_rec, l_def_tavv_rec);

1619: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1620: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1621: RAISE OKC_API.G_EXCEPTION_ERROR;
1622: END IF;
1623: migrate(lx_okc_timevalues_tl_rec, l_def_tavv_rec);
1624: */
1625: -- Set OUT values
1626: x_tavv_rec := l_def_tavv_rec;
1627: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1730: -- lock_row for:OKC_TIMEVALUES_B --

1726: ---------------------------------------------------------------------------
1727: -- PROCEDURE lock_row
1728: ---------------------------------------------------------------------------
1729: -----------------------------------
1730: -- lock_row for:OKC_TIMEVALUES_B --
1731: -----------------------------------
1732: PROCEDURE lock_row(
1733: p_init_msg_list IN VARCHAR2,
1734: x_return_status OUT NOCOPY VARCHAR2,

Line 1743: FROM OKC_TIMEVALUES

1739: E_Resource_Busy EXCEPTION;
1740: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1741: CURSOR lock_csr (p_tve_rec IN tve_rec_type) IS
1742: SELECT OBJECT_VERSION_NUMBER
1743: FROM OKC_TIMEVALUES
1744: WHERE ID = p_tve_rec.id
1745: AND OBJECT_VERSION_NUMBER = p_tve_rec.object_version_number
1746: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1747:

Line 1750: FROM OKC_TIMEVALUES

1746: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1747:
1748: CURSOR lchk_csr (p_tve_rec IN tve_rec_type) IS
1749: SELECT OBJECT_VERSION_NUMBER
1750: FROM OKC_TIMEVALUES
1751: WHERE ID = p_tve_rec.id;
1752: l_api_version CONSTANT NUMBER := 1;
1753: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1754: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1755: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1751: WHERE ID = p_tve_rec.id;
1752: l_api_version CONSTANT NUMBER := 1;
1753: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1754: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1755: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1756: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1757: l_row_notfound BOOLEAN := FALSE;
1758: lc_row_notfound BOOLEAN := FALSE;
1759: BEGIN

Line 1756: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1752: l_api_version CONSTANT NUMBER := 1;
1753: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1754: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1755: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1756: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1757: l_row_notfound BOOLEAN := FALSE;
1758: lc_row_notfound BOOLEAN := FALSE;
1759: BEGIN
1760: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1836: -- lock_row for:OKC_TIMEVALUES_TL --

1832: '_PVT'
1833: );
1834: END lock_row;
1835: ------------------------------------
1836: -- lock_row for:OKC_TIMEVALUES_TL --
1837: ------------------------------------
1838: /* PROCEDURE lock_row(
1839: p_init_msg_list IN VARCHAR2,
1840: x_return_status OUT NOCOPY VARCHAR2,

Line 1843: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

1839: p_init_msg_list IN VARCHAR2,
1840: x_return_status OUT NOCOPY VARCHAR2,
1841: x_msg_count OUT NOCOPY NUMBER,
1842: x_msg_data OUT NOCOPY VARCHAR2,
1843: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1844:
1845: E_Resource_Busy EXCEPTION;
1846: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1847: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

Line 1847: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

1843: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1844:
1845: E_Resource_Busy EXCEPTION;
1846: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1847: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1848: SELECT id
1849: FROM OKC_TIMEVALUES_TL
1850: WHERE ID = p_okc_timevalues_tl_rec.id
1851: FOR UPDATE NOWAIT;

Line 1849: FROM OKC_TIMEVALUES_TL

1845: E_Resource_Busy EXCEPTION;
1846: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1847: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1848: SELECT id
1849: FROM OKC_TIMEVALUES_TL
1850: WHERE ID = p_okc_timevalues_tl_rec.id
1851: FOR UPDATE NOWAIT;
1852:
1853: l_api_version CONSTANT NUMBER := 1;

Line 1850: WHERE ID = p_okc_timevalues_tl_rec.id

1846: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1847: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1848: SELECT id
1849: FROM OKC_TIMEVALUES_TL
1850: WHERE ID = p_okc_timevalues_tl_rec.id
1851: FOR UPDATE NOWAIT;
1852:
1853: l_api_version CONSTANT NUMBER := 1;
1854: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1870: OPEN lock_csr(p_okc_timevalues_tl_rec);

1866: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1867: RAISE OKC_API.G_EXCEPTION_ERROR;
1868: END IF;
1869: BEGIN
1870: OPEN lock_csr(p_okc_timevalues_tl_rec);
1871: FETCH lock_csr INTO l_lock_var;
1872: l_row_notfound := lock_csr%NOTFOUND;
1873: CLOSE lock_csr;
1874: EXCEPTION

Line 1936: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1932: l_api_version CONSTANT NUMBER := 1;
1933: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1934: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1935: l_tve_rec tve_rec_type;
1936: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1937: BEGIN
1938: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1939: G_PKG_NAME,
1940: p_init_msg_list,

Line 1954: --Bug 3122962 migrate(p_tavv_rec, l_okc_timevalues_tl_rec);

1950: --------------------------------------
1951: -- Move VIEW record to "Child" records
1952: --------------------------------------
1953: migrate(p_tavv_rec, l_tve_rec);
1954: --Bug 3122962 migrate(p_tavv_rec, l_okc_timevalues_tl_rec);
1955: --------------------------------------------
1956: -- Call the LOCK_ROW for each child record
1957: --------------------------------------------
1958: lock_row(

Line 1975: l_okc_timevalues_tl_rec

1971: p_init_msg_list,
1972: x_return_status,
1973: x_msg_count,
1974: x_msg_data,
1975: l_okc_timevalues_tl_rec
1976: );
1977: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1979: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2084: -- update_row for:OKC_TIMEVALUES_B --

2080: ---------------------------------------------------------------------------
2081: -- PROCEDURE update_row
2082: ---------------------------------------------------------------------------
2083: -------------------------------------
2084: -- update_row for:OKC_TIMEVALUES_B --
2085: -------------------------------------
2086: PROCEDURE update_row(
2087: p_init_msg_list IN VARCHAR2,
2088: x_return_status OUT NOCOPY VARCHAR2,

Line 2322: -- Set_Attributes for:OKC_TIMEVALUES_B --

2318:
2319: RETURN(l_return_status);
2320: END populate_new_record;
2321: -----------------------------------------
2322: -- Set_Attributes for:OKC_TIMEVALUES_B --
2323: -----------------------------------------
2324: FUNCTION Set_Attributes (
2325: p_tve_rec IN tve_rec_type,
2326: x_tve_rec OUT NOCOPY tve_rec_type

Line 2359: UPDATE OKC_TIMEVALUES

2355: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2356: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2357: RAISE OKC_API.G_EXCEPTION_ERROR;
2358: END IF;
2359: UPDATE OKC_TIMEVALUES
2360: SET SPN_ID = l_def_tve_rec.spn_id,
2361: TVE_ID_OFFSET = l_def_tve_rec.tve_id_offset,
2362: uom_code = l_def_tve_rec.uom_code,
2363: TVE_ID_GENERATED_BY = l_def_tve_rec.tve_id_generated_by,

Line 2447: -- update_row for:OKC_TIMEVALUES_TL --

2443: '_PVT'
2444: );
2445: END update_row;
2446: --------------------------------------
2447: -- update_row for:OKC_TIMEVALUES_TL --
2448: --------------------------------------
2449: /* PROCEDURE update_row(
2450: p_init_msg_list IN VARCHAR2,
2451: x_return_status OUT NOCOPY VARCHAR2,

Line 2454: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2450: p_init_msg_list IN VARCHAR2,
2451: x_return_status OUT NOCOPY VARCHAR2,
2452: x_msg_count OUT NOCOPY NUMBER,
2453: x_msg_data OUT NOCOPY VARCHAR2,
2454: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2455: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2456:
2457: l_api_version CONSTANT NUMBER := 1;
2458: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2455: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

2451: x_return_status OUT NOCOPY VARCHAR2,
2452: x_msg_count OUT NOCOPY NUMBER,
2453: x_msg_data OUT NOCOPY VARCHAR2,
2454: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2455: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2456:
2457: l_api_version CONSTANT NUMBER := 1;
2458: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2459: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2460: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

2456:
2457: l_api_version CONSTANT NUMBER := 1;
2458: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2459: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2460: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2461: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2462: l_row_notfound BOOLEAN := TRUE;
2463: ----------------------------------
2464: -- FUNCTION populate_new_record --

Line 2461: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2457: l_api_version CONSTANT NUMBER := 1;
2458: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2459: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2460: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2461: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2462: l_row_notfound BOOLEAN := TRUE;
2463: ----------------------------------
2464: -- FUNCTION populate_new_record --
2465: ----------------------------------

Line 2467: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2463: ----------------------------------
2464: -- FUNCTION populate_new_record --
2465: ----------------------------------
2466: FUNCTION populate_new_record (
2467: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2468: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2469: ) RETURN VARCHAR2 IS
2470: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2471: l_row_notfound BOOLEAN := TRUE;

Line 2468: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2464: -- FUNCTION populate_new_record --
2465: ----------------------------------
2466: FUNCTION populate_new_record (
2467: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2468: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2469: ) RETURN VARCHAR2 IS
2470: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2471: l_row_notfound BOOLEAN := TRUE;
2472: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2470: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2466: FUNCTION populate_new_record (
2467: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2468: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2469: ) RETURN VARCHAR2 IS
2470: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2471: l_row_notfound BOOLEAN := TRUE;
2472: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2473: BEGIN
2474: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2474: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2470: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2471: l_row_notfound BOOLEAN := TRUE;
2472: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2473: BEGIN
2474: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2475: -- Get current database values
2476: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2477: IF (l_row_notfound) THEN
2478: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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

2472: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2473: BEGIN
2474: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2475: -- Get current database values
2476: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2477: IF (l_row_notfound) THEN
2478: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2479: END IF;
2480: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)

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

2476: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2477: IF (l_row_notfound) THEN
2478: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2479: END IF;
2480: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2481: THEN
2482: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2483: END IF;
2484: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)

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

2478: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2479: END IF;
2480: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2481: THEN
2482: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2483: END IF;
2484: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2485: THEN
2486: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;

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

2480: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2481: THEN
2482: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2483: END IF;
2484: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2485: THEN
2486: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2487: END IF;
2488: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

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

2482: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2483: END IF;
2484: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2485: THEN
2486: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2487: END IF;
2488: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2489: THEN
2490: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;

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

2484: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2485: THEN
2486: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2487: END IF;
2488: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2489: THEN
2490: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2491: END IF;
2492: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

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

2486: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2487: END IF;
2488: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2489: THEN
2490: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2491: END IF;
2492: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2493: THEN
2494: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;

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

2488: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2489: THEN
2490: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2491: END IF;
2492: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2493: THEN
2494: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2495: END IF;
2496: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)

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

2490: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2491: END IF;
2492: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2493: THEN
2494: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2495: END IF;
2496: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2497: THEN
2498: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;

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

2492: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2493: THEN
2494: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2495: END IF;
2496: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2497: THEN
2498: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2499: END IF;
2500: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)

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

2494: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2495: END IF;
2496: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2497: THEN
2498: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2499: END IF;
2500: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2501: THEN
2502: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;

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

2496: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2497: THEN
2498: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2499: END IF;
2500: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2501: THEN
2502: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2503: END IF;
2504: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)

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

2498: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2499: END IF;
2500: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2501: THEN
2502: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2503: END IF;
2504: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2505: THEN
2506: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;

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

2500: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2501: THEN
2502: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2503: END IF;
2504: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2505: THEN
2506: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2507: END IF;
2508: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)

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

2502: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2503: END IF;
2504: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2505: THEN
2506: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2507: END IF;
2508: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2509: THEN
2510: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;

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

2504: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2505: THEN
2506: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2507: END IF;
2508: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2509: THEN
2510: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2511: END IF;
2512: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)

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

2506: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2507: END IF;
2508: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2509: THEN
2510: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2511: END IF;
2512: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2513: THEN
2514: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;

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

2508: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2509: THEN
2510: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2511: END IF;
2512: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2513: THEN
2514: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2515: END IF;
2516: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)

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

2510: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2511: END IF;
2512: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2513: THEN
2514: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2515: END IF;
2516: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2517: THEN
2518: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;

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

2512: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2513: THEN
2514: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2515: END IF;
2516: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2517: THEN
2518: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2519: END IF;
2520: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

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

2514: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2515: END IF;
2516: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2517: THEN
2518: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2519: END IF;
2520: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2521: THEN
2522: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;

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

2516: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2517: THEN
2518: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2519: END IF;
2520: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2521: THEN
2522: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2523: END IF;
2524: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

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

2518: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2519: END IF;
2520: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2521: THEN
2522: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2523: END IF;
2524: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2525: THEN
2526: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;

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

2520: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2521: THEN
2522: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2523: END IF;
2524: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2525: THEN
2526: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2527: END IF;
2528: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

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

2522: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2523: END IF;
2524: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2525: THEN
2526: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2527: END IF;
2528: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2529: THEN
2530: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;

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

2524: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2525: THEN
2526: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2527: END IF;
2528: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2529: THEN
2530: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2531: END IF;
2532: RETURN(l_return_status);

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

2526: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2527: END IF;
2528: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2529: THEN
2530: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2531: END IF;
2532: RETURN(l_return_status);
2533: END populate_new_record;
2534: ------------------------------------------

Line 2535: -- Set_Attributes for:OKC_TIMEVALUES_TL --

2531: END IF;
2532: RETURN(l_return_status);
2533: END populate_new_record;
2534: ------------------------------------------
2535: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2536: ------------------------------------------
2537: FUNCTION Set_Attributes (
2538: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2539: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 2538: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2534: ------------------------------------------
2535: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2536: ------------------------------------------
2537: FUNCTION Set_Attributes (
2538: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2539: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2540: ) RETURN VARCHAR2 IS
2541: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2542: BEGIN

Line 2539: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2535: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2536: ------------------------------------------
2537: FUNCTION Set_Attributes (
2538: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2539: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2540: ) RETURN VARCHAR2 IS
2541: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2542: BEGIN
2543: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2543: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2539: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2540: ) RETURN VARCHAR2 IS
2541: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2542: BEGIN
2543: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2544: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2545: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2546: RETURN(l_return_status);
2547: END Set_Attributes;

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

2540: ) RETURN VARCHAR2 IS
2541: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2542: BEGIN
2543: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2544: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2545: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2546: RETURN(l_return_status);
2547: END Set_Attributes;
2548: BEGIN

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

2541: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2542: BEGIN
2543: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2544: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2545: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2546: RETURN(l_return_status);
2547: END Set_Attributes;
2548: BEGIN
2549: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2560: p_okc_timevalues_tl_rec, -- IN

2556: RAISE OKC_API.G_EXCEPTION_ERROR;
2557: END IF;
2558: --- Setting item attributes
2559: l_return_status := Set_Attributes(
2560: p_okc_timevalues_tl_rec, -- IN
2561: l_okc_timevalues_tl_rec); -- OUT
2562: --- If any errors happen abort API
2563: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2564: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2561: l_okc_timevalues_tl_rec); -- OUT

2557: END IF;
2558: --- Setting item attributes
2559: l_return_status := Set_Attributes(
2560: p_okc_timevalues_tl_rec, -- IN
2561: l_okc_timevalues_tl_rec); -- OUT
2562: --- If any errors happen abort API
2563: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2564: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2565: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

2564: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2565: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2566: RAISE OKC_API.G_EXCEPTION_ERROR;
2567: END IF;
2568: l_return_status := populate_new_record(l_okc_timevalues_tl_rec, l_def_okc_timevalues_tl_rec);
2569: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2571: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2572: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2574: UPDATE OKC_TIMEVALUES_TL

2570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2571: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2572: RAISE OKC_API.G_EXCEPTION_ERROR;
2573: END IF;
2574: UPDATE OKC_TIMEVALUES_TL
2575: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2576: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2577: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2578: NAME = l_def_okc_timevalues_tl_rec.name,

Line 2575: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,

2571: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2572: RAISE OKC_API.G_EXCEPTION_ERROR;
2573: END IF;
2574: UPDATE OKC_TIMEVALUES_TL
2575: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2576: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2577: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2578: NAME = l_def_okc_timevalues_tl_rec.name,
2579: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

Line 2576: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,

2572: RAISE OKC_API.G_EXCEPTION_ERROR;
2573: END IF;
2574: UPDATE OKC_TIMEVALUES_TL
2575: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2576: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2577: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2578: NAME = l_def_okc_timevalues_tl_rec.name,
2579: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2580: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

Line 2577: COMMENTS = l_def_okc_timevalues_tl_rec.comments,

2573: END IF;
2574: UPDATE OKC_TIMEVALUES_TL
2575: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2576: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2577: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2578: NAME = l_def_okc_timevalues_tl_rec.name,
2579: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2580: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2581: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

Line 2578: NAME = l_def_okc_timevalues_tl_rec.name,

2574: UPDATE OKC_TIMEVALUES_TL
2575: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2576: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2577: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2578: NAME = l_def_okc_timevalues_tl_rec.name,
2579: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2580: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2581: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2582: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

Line 2579: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

2575: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2576: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2577: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2578: NAME = l_def_okc_timevalues_tl_rec.name,
2579: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2580: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2581: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2582: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2583: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

Line 2580: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

2576: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2577: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2578: NAME = l_def_okc_timevalues_tl_rec.name,
2579: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2580: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2581: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2582: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2583: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2584: WHERE ID = l_def_okc_timevalues_tl_rec.id

Line 2581: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

2577: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2578: NAME = l_def_okc_timevalues_tl_rec.name,
2579: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2580: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2581: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2582: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2583: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2584: WHERE ID = l_def_okc_timevalues_tl_rec.id
2585: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);

Line 2582: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

2578: NAME = l_def_okc_timevalues_tl_rec.name,
2579: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2580: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2581: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2582: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2583: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2584: WHERE ID = l_def_okc_timevalues_tl_rec.id
2585: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2586:

Line 2583: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

2579: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2580: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2581: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2582: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2583: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2584: WHERE ID = l_def_okc_timevalues_tl_rec.id
2585: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2586:
2587: UPDATE OKC_TIMEVALUES_TL

Line 2584: WHERE ID = l_def_okc_timevalues_tl_rec.id

2580: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2581: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2582: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2583: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2584: WHERE ID = l_def_okc_timevalues_tl_rec.id
2585: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2586:
2587: UPDATE OKC_TIMEVALUES_TL
2588: SET SFWT_FLAG = 'Y'

Line 2587: UPDATE OKC_TIMEVALUES_TL

2583: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2584: WHERE ID = l_def_okc_timevalues_tl_rec.id
2585: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2586:
2587: UPDATE OKC_TIMEVALUES_TL
2588: SET SFWT_FLAG = 'Y'
2589: WHERE ID = l_def_okc_timevalues_tl_rec.id
2590: AND SOURCE_LANG <> USERENV('LANG');
2591:

Line 2589: WHERE ID = l_def_okc_timevalues_tl_rec.id

2585: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2586:
2587: UPDATE OKC_TIMEVALUES_TL
2588: SET SFWT_FLAG = 'Y'
2589: WHERE ID = l_def_okc_timevalues_tl_rec.id
2590: AND SOURCE_LANG <> USERENV('LANG');
2591:
2592: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2593: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2592: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;

2588: SET SFWT_FLAG = 'Y'
2589: WHERE ID = l_def_okc_timevalues_tl_rec.id
2590: AND SOURCE_LANG <> USERENV('LANG');
2591:
2592: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2593: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2594: EXCEPTION
2595: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2596: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2644: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2640: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2641: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2642: l_tavv_rec tavv_rec_type := p_tavv_rec;
2643: l_def_tavv_rec tavv_rec_type;
2644: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2645: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2646: l_tve_rec tve_rec_type;
2647: lx_tve_rec tve_rec_type;
2648: -------------------------------

Line 2645: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2641: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2642: l_tavv_rec tavv_rec_type := p_tavv_rec;
2643: l_def_tavv_rec tavv_rec_type;
2644: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2645: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2646: l_tve_rec tve_rec_type;
2647: lx_tve_rec tve_rec_type;
2648: -------------------------------
2649: -- FUNCTION fill_who_columns --

Line 2877: --Bug 3122962 migrate(l_def_tavv_rec, l_okc_timevalues_tl_rec);

2873:
2874: --------------------------------------
2875: -- Move VIEW record to "Child" records
2876: --------------------------------------
2877: --Bug 3122962 migrate(l_def_tavv_rec, l_okc_timevalues_tl_rec);
2878: migrate(l_def_tavv_rec, l_tve_rec);
2879: --------------------------------------------
2880: -- Call the UPDATE_ROW for each child record
2881: --------------------------------------------

Line 2887: l_okc_timevalues_tl_rec,

2883: p_init_msg_list,
2884: x_return_status,
2885: x_msg_count,
2886: x_msg_data,
2887: l_okc_timevalues_tl_rec,
2888: lx_okc_timevalues_tl_rec
2889: );
2890: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2891: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2888: lx_okc_timevalues_tl_rec

2884: x_return_status,
2885: x_msg_count,
2886: x_msg_data,
2887: l_okc_timevalues_tl_rec,
2888: lx_okc_timevalues_tl_rec
2889: );
2890: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2891: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2892: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2895: migrate(lx_okc_timevalues_tl_rec, l_def_tavv_rec);

2891: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2892: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2893: RAISE OKC_API.G_EXCEPTION_ERROR;
2894: END IF;
2895: migrate(lx_okc_timevalues_tl_rec, l_def_tavv_rec);
2896: */
2897: update_row(
2898: p_init_msg_list,
2899: x_return_status,

Line 3015: -- delete_row for:OKC_TIMEVALUES_B --

3011: ---------------------------------------------------------------------------
3012: -- PROCEDURE delete_row
3013: ---------------------------------------------------------------------------
3014: -------------------------------------
3015: -- delete_row for:OKC_TIMEVALUES_B --
3016: -------------------------------------
3017: PROCEDURE delete_row(
3018: p_init_msg_list IN VARCHAR2,
3019: x_return_status OUT NOCOPY VARCHAR2,

Line 3039: DELETE FROM OKC_TIMEVALUES

3035: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3036: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3037: RAISE OKC_API.G_EXCEPTION_ERROR;
3038: END IF;
3039: DELETE FROM OKC_TIMEVALUES
3040: WHERE ID = l_tve_rec.id;
3041:
3042: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3043: EXCEPTION

Line 3076: -- delete_row for:OKC_TIMEVALUES_TL --

3072: '_PVT'
3073: );
3074: END delete_row;
3075: --------------------------------------
3076: -- delete_row for:OKC_TIMEVALUES_TL --
3077: --------------------------------------
3078: /* PROCEDURE delete_row(
3079: p_init_msg_list IN VARCHAR2,
3080: x_return_status OUT NOCOPY VARCHAR2,

Line 3083: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

3079: p_init_msg_list IN VARCHAR2,
3080: x_return_status OUT NOCOPY VARCHAR2,
3081: x_msg_count OUT NOCOPY NUMBER,
3082: x_msg_data OUT NOCOPY VARCHAR2,
3083: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
3084:
3085: l_api_version CONSTANT NUMBER := 1;
3086: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3087: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3088: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;

3084:
3085: l_api_version CONSTANT NUMBER := 1;
3086: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3087: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3088: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3089: l_row_notfound BOOLEAN := TRUE;
3090: ------------------------------------------
3091: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3092: ------------------------------------------

Line 3091: -- Set_Attributes for:OKC_TIMEVALUES_TL --

3087: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3088: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3089: l_row_notfound BOOLEAN := TRUE;
3090: ------------------------------------------
3091: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3092: ------------------------------------------
3093: FUNCTION Set_Attributes (
3094: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3095: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 3094: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

3090: ------------------------------------------
3091: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3092: ------------------------------------------
3093: FUNCTION Set_Attributes (
3094: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3095: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3096: ) RETURN VARCHAR2 IS
3097: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3098: BEGIN

Line 3095: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

3091: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3092: ------------------------------------------
3093: FUNCTION Set_Attributes (
3094: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3095: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3096: ) RETURN VARCHAR2 IS
3097: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3098: BEGIN
3099: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 3099: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

3095: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3096: ) RETURN VARCHAR2 IS
3097: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3098: BEGIN
3099: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3100: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3101: RETURN(l_return_status);
3102: END Set_Attributes;
3103: BEGIN

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

3096: ) RETURN VARCHAR2 IS
3097: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3098: BEGIN
3099: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3100: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3101: RETURN(l_return_status);
3102: END Set_Attributes;
3103: BEGIN
3104: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3115: p_okc_timevalues_tl_rec, -- IN

3111: RAISE OKC_API.G_EXCEPTION_ERROR;
3112: END IF;
3113: --- Setting item attributes
3114: l_return_status := Set_Attributes(
3115: p_okc_timevalues_tl_rec, -- IN
3116: l_okc_timevalues_tl_rec); -- OUT
3117: --- If any errors happen abort API
3118: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3119: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3116: l_okc_timevalues_tl_rec); -- OUT

3112: END IF;
3113: --- Setting item attributes
3114: l_return_status := Set_Attributes(
3115: p_okc_timevalues_tl_rec, -- IN
3116: l_okc_timevalues_tl_rec); -- OUT
3117: --- If any errors happen abort API
3118: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3119: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3120: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3123: DELETE FROM OKC_TIMEVALUES_TL

3119: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3120: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3121: RAISE OKC_API.G_EXCEPTION_ERROR;
3122: END IF;
3123: DELETE FROM OKC_TIMEVALUES_TL
3124: WHERE ID = l_okc_timevalues_tl_rec.id;
3125:
3126: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3127: EXCEPTION

Line 3124: WHERE ID = l_okc_timevalues_tl_rec.id;

3120: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3121: RAISE OKC_API.G_EXCEPTION_ERROR;
3122: END IF;
3123: DELETE FROM OKC_TIMEVALUES_TL
3124: WHERE ID = l_okc_timevalues_tl_rec.id;
3125:
3126: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3127: EXCEPTION
3128: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3175: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

3171: l_api_version CONSTANT NUMBER := 1;
3172: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3173: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3174: l_tavv_rec tavv_rec_type := p_tavv_rec;
3175: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
3176: l_tve_rec tve_rec_type;
3177: BEGIN
3178: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3179: G_PKG_NAME,

Line 3193: --Bug 3122962 migrate(l_tavv_rec, l_okc_timevalues_tl_rec);

3189: END IF;
3190: --------------------------------------
3191: -- Move VIEW record to "Child" records
3192: --------------------------------------
3193: --Bug 3122962 migrate(l_tavv_rec, l_okc_timevalues_tl_rec);
3194: migrate(l_tavv_rec, l_tve_rec);
3195: --------------------------------------------
3196: -- Call the DELETE_ROW for each child record
3197: --------------------------------------------

Line 3203: l_okc_timevalues_tl_rec

3199: p_init_msg_list,
3200: x_return_status,
3201: x_msg_count,
3202: x_msg_data,
3203: l_okc_timevalues_tl_rec
3204: );
3205: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3207: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3332: INSERT INTO okc_timevalues_h

3328:
3329: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3330:
3331: BEGIN
3332: INSERT INTO okc_timevalues_h
3333: (
3334: major_version,
3335: id,
3336: spn_id,

Line 3442: FROM okc_timevalues

3438: attribute12,
3439: attribute13,
3440: attribute14,
3441: attribute15
3442: FROM okc_timevalues
3443: WHERE dnz_chr_id = p_chr_id;
3444:
3445: -------------------------------
3446: -- Versioning TL Table

Line 3450: INSERT INTO okc_timevalues_tlh

3446: -- Versioning TL Table
3447: -------------------------------
3448: --Bug 3122962
3449: /*
3450: INSERT INTO okc_timevalues_tlh
3451: (
3452: major_version,
3453: id,
3454: language,

Line 3482: FROM okc_timevalues_tl

3478: creation_date,
3479: last_updated_by,
3480: last_update_date,
3481: last_update_login
3482: FROM okc_timevalues_tl
3483: WHERE id in (SELECT id
3484: FROM okc_timevalues_b
3485: WHERE dnz_chr_id = p_chr_id);
3486: */

Line 3484: FROM okc_timevalues_b

3480: last_update_date,
3481: last_update_login
3482: FROM okc_timevalues_tl
3483: WHERE id in (SELECT id
3484: FROM okc_timevalues_b
3485: WHERE dnz_chr_id = p_chr_id);
3486: */
3487: RETURN l_return_status;
3488: EXCEPTION

Line 3518: INSERT INTO okc_timevalues_tl

3514:
3515: BEGIN
3516: --Bug 3122962
3517: /*
3518: INSERT INTO okc_timevalues_tl
3519: (
3520: id,
3521: language,
3522: source_lang,

Line 3548: FROM okc_timevalues_tlh

3544: creation_date,
3545: last_updated_by,
3546: last_update_date,
3547: last_update_login
3548: FROM okc_timevalues_tlh
3549: WHERE id in (SELECT id
3550: FROM okc_timevalues_bh
3551: WHERE dnz_chr_id = p_chr_id)
3552: AND major_version = p_major_version;

Line 3550: FROM okc_timevalues_bh

3546: last_update_date,
3547: last_update_login
3548: FROM okc_timevalues_tlh
3549: WHERE id in (SELECT id
3550: FROM okc_timevalues_bh
3551: WHERE dnz_chr_id = p_chr_id)
3552: AND major_version = p_major_version;
3553: */
3554: -----------------------------------------

Line 3558: INSERT INTO okc_timevalues

3554: -----------------------------------------
3555: -- Restoring Base Table
3556: -----------------------------------------
3557:
3558: INSERT INTO okc_timevalues
3559: (
3560: id,
3561: spn_id,
3562: tve_id_offset,

Line 3666: FROM okc_timevalues_h

3662: attribute12,
3663: attribute13,
3664: attribute14,
3665: attribute15
3666: FROM okc_timevalues_h
3667: WHERE dnz_chr_id = p_chr_id
3668: AND major_version = p_major_version;
3669:
3670: RETURN l_return_status;