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_ISE_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: ---------------------------------------------------------------------------
232: -- FUNCTION get_rec for: OKC_TIME_IA_STARTEND_V

Line 458: -- FUNCTION null_out_defaults for: OKC_TIMEVALUES_V --

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

Line 538: p_tve_tl_rec IN okc_timevalues_tl_rec_type

534: RETURN(l_tve_rec);
535: END null_out_defaults;
536:
537: /* FUNCTION null_out_defaults (
538: p_tve_tl_rec IN okc_timevalues_tl_rec_type
539: ) RETURN okc_timevalues_tl_rec_type IS
540: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
541: BEGIN
542: IF (l_tve_tl_rec.name = OKC_API.G_MISS_CHAR) THEN

Line 539: ) RETURN okc_timevalues_tl_rec_type IS

535: END null_out_defaults;
536:
537: /* FUNCTION null_out_defaults (
538: p_tve_tl_rec IN okc_timevalues_tl_rec_type
539: ) RETURN okc_timevalues_tl_rec_type IS
540: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
541: BEGIN
542: IF (l_tve_tl_rec.name = OKC_API.G_MISS_CHAR) THEN
543: l_tve_tl_rec.name := NULL;

Line 540: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;

536:
537: /* FUNCTION null_out_defaults (
538: p_tve_tl_rec IN okc_timevalues_tl_rec_type
539: ) RETURN okc_timevalues_tl_rec_type IS
540: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;
541: BEGIN
542: IF (l_tve_tl_rec.name = OKC_API.G_MISS_CHAR) THEN
543: l_tve_tl_rec.name := NULL;
544: END IF;

Line 665: FROM Okc_Timevalues

661: item_not_found_error EXCEPTION;
662: l_row_notfound BOOLEAN := TRUE;
663: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
664: SELECT '1'
665: FROM Okc_Timevalues
666: WHERE id = p_id
667: AND tve_type in ('TAL', 'TAV');
668: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
669: BEGIN

Line 710: FROM Okc_Timevalues

706: item_not_found_error EXCEPTION;
707: l_row_notfound BOOLEAN := TRUE;
708: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
709: SELECT '1'
710: FROM Okc_Timevalues
711: WHERE id = p_id
712: AND tve_type in ('TAL', 'TAV');
713: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
714: BEGIN

Line 751: FROM Okc_Timevalues

747: item_not_found_error EXCEPTION;
748: l_row_notfound BOOLEAN := TRUE;
749: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
750: SELECT '1'
751: FROM Okc_Timevalues
752: WHERE id = p_id
753: and tve_type in ('ISE','IGS');
754: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
755: BEGIN

Line 1236: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type

1232: END migrate;
1233: --Bug 3122962
1234: /* PROCEDURE migrate (
1235: p_from IN isev_rec_type,
1236: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
1237: ) IS
1238: l_tve_tl_type okc_timevalues_tl_rec_type;
1239: BEGIN
1240: p_to.id := p_from.id;

Line 1238: l_tve_tl_type okc_timevalues_tl_rec_type;

1234: /* PROCEDURE migrate (
1235: p_from IN isev_rec_type,
1236: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
1237: ) IS
1238: l_tve_tl_type okc_timevalues_tl_rec_type;
1239: BEGIN
1240: p_to.id := p_from.id;
1241: p_to.sfwt_flag := p_from.sfwt_flag;
1242: p_to.description := p_from.description;

Line 1256: p_from IN okc_timevalues_tl_rec_type,

1252: l_tve_tl_type := null_out_defaults(p_to);
1253: p_to := l_tve_tl_type;
1254: END migrate;
1255: PROCEDURE migrate (
1256: p_from IN okc_timevalues_tl_rec_type,
1257: p_to IN OUT NOCOPY isev_rec_type
1258: ) IS
1259: BEGIN
1260: p_to.id := p_from.id;

Line 1291: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1287: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1288: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1289: l_isev_rec isev_rec_type := p_isev_rec;
1290: l_tve_rec tve_rec_type;
1291: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1292: BEGIN
1293: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1294: G_PKG_NAME,
1295: p_init_msg_list,

Line 1420: -- insert_row for:OKC_TIMEVALUES_B --

1416: ---------------------------------------------------------------------------
1417: -- PROCEDURE insert_row
1418: ---------------------------------------------------------------------------
1419: -------------------------------------
1420: -- insert_row for:OKC_TIMEVALUES_B --
1421: -------------------------------------
1422: PROCEDURE insert_row(
1423: p_init_msg_list IN VARCHAR2 ,
1424: x_return_status OUT NOCOPY VARCHAR2,

Line 1436: -- Set_Attributes for:OKC_TIMEVALUES_B --

1432: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1433: l_tve_rec tve_rec_type := p_tve_rec;
1434: l_def_tve_rec tve_rec_type;
1435: -----------------------------------------
1436: -- Set_Attributes for:OKC_TIMEVALUES_B --
1437: -----------------------------------------
1438: FUNCTION Set_Attributes (
1439: p_tve_rec IN tve_rec_type,
1440: x_tve_rec OUT NOCOPY tve_rec_type

Line 1467: INSERT INTO OKC_TIMEVALUES(

1463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1465: RAISE OKC_API.G_EXCEPTION_ERROR;
1466: END IF;
1467: INSERT INTO OKC_TIMEVALUES(
1468: id,
1469: spn_id,
1470: tve_id_offset,
1471: uom_code,

Line 1609: -- insert_row for:OKC_TIMEVALUES_TL --

1605: '_PVT'
1606: );
1607: END insert_row;
1608: --------------------------------------
1609: -- insert_row for:OKC_TIMEVALUES_TL --
1610: --------------------------------------
1611: /* PROCEDURE insert_row(
1612: p_init_msg_list IN VARCHAR2 ,
1613: x_return_status OUT NOCOPY VARCHAR2,

Line 1616: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1612: p_init_msg_list IN VARCHAR2 ,
1613: x_return_status OUT NOCOPY VARCHAR2,
1614: x_msg_count OUT NOCOPY NUMBER,
1615: x_msg_data OUT NOCOPY VARCHAR2,
1616: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1617: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1618:
1619: l_api_version CONSTANT NUMBER := 1;
1620: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1617: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

1613: x_return_status OUT NOCOPY VARCHAR2,
1614: x_msg_count OUT NOCOPY NUMBER,
1615: x_msg_data OUT NOCOPY VARCHAR2,
1616: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1617: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1618:
1619: l_api_version CONSTANT NUMBER := 1;
1620: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1621: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1622: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

1618:
1619: l_api_version CONSTANT NUMBER := 1;
1620: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1621: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1622: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1623: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1624: CURSOR get_languages IS
1625: SELECT *
1626: FROM FND_LANGUAGES

Line 1623: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1619: l_api_version CONSTANT NUMBER := 1;
1620: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1621: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1622: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1623: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1624: CURSOR get_languages IS
1625: SELECT *
1626: FROM FND_LANGUAGES
1627: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1629: -- Set_Attributes for:OKC_TIMEVALUES_TL --

1625: SELECT *
1626: FROM FND_LANGUAGES
1627: WHERE INSTALLED_FLAG IN ('I', 'B');
1628: ------------------------------------------
1629: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1630: ------------------------------------------
1631: FUNCTION Set_Attributes (
1632: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1633: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 1632: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1628: ------------------------------------------
1629: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1630: ------------------------------------------
1631: FUNCTION Set_Attributes (
1632: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1633: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1634: ) RETURN VARCHAR2 IS
1635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1636: BEGIN

Line 1633: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

1629: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1630: ------------------------------------------
1631: FUNCTION Set_Attributes (
1632: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1633: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1634: ) RETURN VARCHAR2 IS
1635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1636: BEGIN
1637: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 1637: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

1633: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1634: ) RETURN VARCHAR2 IS
1635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1636: BEGIN
1637: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1638: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1639: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1640: RETURN(l_return_status);
1641: END Set_Attributes;

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

1634: ) RETURN VARCHAR2 IS
1635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1636: BEGIN
1637: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1638: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1639: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1640: RETURN(l_return_status);
1641: END Set_Attributes;
1642: BEGIN

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

1635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1636: BEGIN
1637: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1638: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1639: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1640: RETURN(l_return_status);
1641: END Set_Attributes;
1642: BEGIN
1643: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1654: p_okc_timevalues_tl_rec, -- IN

1650: RAISE OKC_API.G_EXCEPTION_ERROR;
1651: END IF;
1652: --- Setting item attributes
1653: l_return_status := Set_Attributes(
1654: p_okc_timevalues_tl_rec, -- IN
1655: l_okc_timevalues_tl_rec); -- OUT
1656: --- If any errors happen abort API
1657: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1658: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1655: l_okc_timevalues_tl_rec); -- OUT

1651: END IF;
1652: --- Setting item attributes
1653: l_return_status := Set_Attributes(
1654: p_okc_timevalues_tl_rec, -- IN
1655: l_okc_timevalues_tl_rec); -- OUT
1656: --- If any errors happen abort API
1657: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1658: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1659: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

1659: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1660: RAISE OKC_API.G_EXCEPTION_ERROR;
1661: END IF;
1662: FOR l_lang_rec IN get_languages LOOP
1663: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1664: INSERT INTO OKC_TIMEVALUES_TL(
1665: id,
1666: language,
1667: source_lang,

Line 1664: INSERT INTO OKC_TIMEVALUES_TL(

1660: RAISE OKC_API.G_EXCEPTION_ERROR;
1661: END IF;
1662: FOR l_lang_rec IN get_languages LOOP
1663: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1664: INSERT INTO OKC_TIMEVALUES_TL(
1665: id,
1666: language,
1667: source_lang,
1668: sfwt_flag,

Line 1679: l_okc_timevalues_tl_rec.id,

1675: last_updated_by,
1676: last_update_date,
1677: last_update_login)
1678: VALUES (
1679: l_okc_timevalues_tl_rec.id,
1680: l_okc_timevalues_tl_rec.language,
1681: l_okc_timevalues_tl_rec.source_lang,
1682: l_okc_timevalues_tl_rec.sfwt_flag,
1683: l_okc_timevalues_tl_rec.description,

Line 1680: l_okc_timevalues_tl_rec.language,

1676: last_update_date,
1677: last_update_login)
1678: VALUES (
1679: l_okc_timevalues_tl_rec.id,
1680: l_okc_timevalues_tl_rec.language,
1681: l_okc_timevalues_tl_rec.source_lang,
1682: l_okc_timevalues_tl_rec.sfwt_flag,
1683: l_okc_timevalues_tl_rec.description,
1684: l_okc_timevalues_tl_rec.short_description,

Line 1681: l_okc_timevalues_tl_rec.source_lang,

1677: last_update_login)
1678: VALUES (
1679: l_okc_timevalues_tl_rec.id,
1680: l_okc_timevalues_tl_rec.language,
1681: l_okc_timevalues_tl_rec.source_lang,
1682: l_okc_timevalues_tl_rec.sfwt_flag,
1683: l_okc_timevalues_tl_rec.description,
1684: l_okc_timevalues_tl_rec.short_description,
1685: l_okc_timevalues_tl_rec.comments,

Line 1682: l_okc_timevalues_tl_rec.sfwt_flag,

1678: VALUES (
1679: l_okc_timevalues_tl_rec.id,
1680: l_okc_timevalues_tl_rec.language,
1681: l_okc_timevalues_tl_rec.source_lang,
1682: l_okc_timevalues_tl_rec.sfwt_flag,
1683: l_okc_timevalues_tl_rec.description,
1684: l_okc_timevalues_tl_rec.short_description,
1685: l_okc_timevalues_tl_rec.comments,
1686: l_okc_timevalues_tl_rec.name,

Line 1683: l_okc_timevalues_tl_rec.description,

1679: l_okc_timevalues_tl_rec.id,
1680: l_okc_timevalues_tl_rec.language,
1681: l_okc_timevalues_tl_rec.source_lang,
1682: l_okc_timevalues_tl_rec.sfwt_flag,
1683: l_okc_timevalues_tl_rec.description,
1684: l_okc_timevalues_tl_rec.short_description,
1685: l_okc_timevalues_tl_rec.comments,
1686: l_okc_timevalues_tl_rec.name,
1687: l_okc_timevalues_tl_rec.created_by,

Line 1684: l_okc_timevalues_tl_rec.short_description,

1680: l_okc_timevalues_tl_rec.language,
1681: l_okc_timevalues_tl_rec.source_lang,
1682: l_okc_timevalues_tl_rec.sfwt_flag,
1683: l_okc_timevalues_tl_rec.description,
1684: l_okc_timevalues_tl_rec.short_description,
1685: l_okc_timevalues_tl_rec.comments,
1686: l_okc_timevalues_tl_rec.name,
1687: l_okc_timevalues_tl_rec.created_by,
1688: l_okc_timevalues_tl_rec.creation_date,

Line 1685: l_okc_timevalues_tl_rec.comments,

1681: l_okc_timevalues_tl_rec.source_lang,
1682: l_okc_timevalues_tl_rec.sfwt_flag,
1683: l_okc_timevalues_tl_rec.description,
1684: l_okc_timevalues_tl_rec.short_description,
1685: l_okc_timevalues_tl_rec.comments,
1686: l_okc_timevalues_tl_rec.name,
1687: l_okc_timevalues_tl_rec.created_by,
1688: l_okc_timevalues_tl_rec.creation_date,
1689: l_okc_timevalues_tl_rec.last_updated_by,

Line 1686: l_okc_timevalues_tl_rec.name,

1682: l_okc_timevalues_tl_rec.sfwt_flag,
1683: l_okc_timevalues_tl_rec.description,
1684: l_okc_timevalues_tl_rec.short_description,
1685: l_okc_timevalues_tl_rec.comments,
1686: l_okc_timevalues_tl_rec.name,
1687: l_okc_timevalues_tl_rec.created_by,
1688: l_okc_timevalues_tl_rec.creation_date,
1689: l_okc_timevalues_tl_rec.last_updated_by,
1690: l_okc_timevalues_tl_rec.last_update_date,

Line 1687: l_okc_timevalues_tl_rec.created_by,

1683: l_okc_timevalues_tl_rec.description,
1684: l_okc_timevalues_tl_rec.short_description,
1685: l_okc_timevalues_tl_rec.comments,
1686: l_okc_timevalues_tl_rec.name,
1687: l_okc_timevalues_tl_rec.created_by,
1688: l_okc_timevalues_tl_rec.creation_date,
1689: l_okc_timevalues_tl_rec.last_updated_by,
1690: l_okc_timevalues_tl_rec.last_update_date,
1691: l_okc_timevalues_tl_rec.last_update_login);

Line 1688: l_okc_timevalues_tl_rec.creation_date,

1684: l_okc_timevalues_tl_rec.short_description,
1685: l_okc_timevalues_tl_rec.comments,
1686: l_okc_timevalues_tl_rec.name,
1687: l_okc_timevalues_tl_rec.created_by,
1688: l_okc_timevalues_tl_rec.creation_date,
1689: l_okc_timevalues_tl_rec.last_updated_by,
1690: l_okc_timevalues_tl_rec.last_update_date,
1691: l_okc_timevalues_tl_rec.last_update_login);
1692: END LOOP;

Line 1689: l_okc_timevalues_tl_rec.last_updated_by,

1685: l_okc_timevalues_tl_rec.comments,
1686: l_okc_timevalues_tl_rec.name,
1687: l_okc_timevalues_tl_rec.created_by,
1688: l_okc_timevalues_tl_rec.creation_date,
1689: l_okc_timevalues_tl_rec.last_updated_by,
1690: l_okc_timevalues_tl_rec.last_update_date,
1691: l_okc_timevalues_tl_rec.last_update_login);
1692: END LOOP;
1693: -- Set OUT values

Line 1690: l_okc_timevalues_tl_rec.last_update_date,

1686: l_okc_timevalues_tl_rec.name,
1687: l_okc_timevalues_tl_rec.created_by,
1688: l_okc_timevalues_tl_rec.creation_date,
1689: l_okc_timevalues_tl_rec.last_updated_by,
1690: l_okc_timevalues_tl_rec.last_update_date,
1691: l_okc_timevalues_tl_rec.last_update_login);
1692: END LOOP;
1693: -- Set OUT values
1694: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

Line 1691: l_okc_timevalues_tl_rec.last_update_login);

1687: l_okc_timevalues_tl_rec.created_by,
1688: l_okc_timevalues_tl_rec.creation_date,
1689: l_okc_timevalues_tl_rec.last_updated_by,
1690: l_okc_timevalues_tl_rec.last_update_date,
1691: l_okc_timevalues_tl_rec.last_update_login);
1692: END LOOP;
1693: -- Set OUT values
1694: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1695: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1694: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

1690: l_okc_timevalues_tl_rec.last_update_date,
1691: l_okc_timevalues_tl_rec.last_update_login);
1692: END LOOP;
1693: -- Set OUT values
1694: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1695: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1696: EXCEPTION
1697: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1698: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1747: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1743: l_isev_rec isev_rec_type;
1744: l_def_isev_rec isev_rec_type;
1745: l_tve_rec tve_rec_type;
1746: lx_tve_rec tve_rec_type;
1747: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1748: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1749: -------------------------------
1750: -- FUNCTION fill_who_columns --
1751: -------------------------------

Line 1748: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1744: l_def_isev_rec isev_rec_type;
1745: l_tve_rec tve_rec_type;
1746: lx_tve_rec tve_rec_type;
1747: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1748: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1749: -------------------------------
1750: -- FUNCTION fill_who_columns --
1751: -------------------------------
1752: FUNCTION fill_who_columns (

Line 1823: --Bug 3122962 migrate(l_def_isev_rec, l_okc_timevalues_tl_rec);

1819: --------------------------------------
1820: -- Move VIEW record to "Child" records
1821: --------------------------------------
1822: migrate(l_def_isev_rec, l_tve_rec);
1823: --Bug 3122962 migrate(l_def_isev_rec, l_okc_timevalues_tl_rec);
1824: --------------------------------------------
1825: -- Call the INSERT_ROW for each child record
1826: --------------------------------------------
1827: insert_row(

Line 1846: l_okc_timevalues_tl_rec,

1842: p_init_msg_list,
1843: x_return_status,
1844: x_msg_count,
1845: x_msg_data,
1846: l_okc_timevalues_tl_rec,
1847: lx_okc_timevalues_tl_rec
1848: );
1849: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1850: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1847: lx_okc_timevalues_tl_rec

1843: x_return_status,
1844: x_msg_count,
1845: x_msg_data,
1846: l_okc_timevalues_tl_rec,
1847: lx_okc_timevalues_tl_rec
1848: );
1849: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1850: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1851: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1854: migrate(lx_okc_timevalues_tl_rec, l_def_isev_rec);

1850: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1851: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1852: RAISE OKC_API.G_EXCEPTION_ERROR;
1853: END IF;
1854: migrate(lx_okc_timevalues_tl_rec, l_def_isev_rec);
1855: */
1856: -- Set OUT values
1857: x_isev_rec := l_def_isev_rec;
1858: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1961: -- lock_row for:OKC_TIMEVALUES_B --

1957: ---------------------------------------------------------------------------
1958: -- PROCEDURE lock_row
1959: ---------------------------------------------------------------------------
1960: -----------------------------------
1961: -- lock_row for:OKC_TIMEVALUES_B --
1962: -----------------------------------
1963: PROCEDURE lock_row(
1964: p_init_msg_list IN VARCHAR2 ,
1965: x_return_status OUT NOCOPY VARCHAR2,

Line 1974: FROM OKC_TIMEVALUES

1970: E_Resource_Busy EXCEPTION;
1971: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1972: CURSOR lock_csr (p_tve_rec IN tve_rec_type) IS
1973: SELECT OBJECT_VERSION_NUMBER
1974: FROM OKC_TIMEVALUES
1975: WHERE ID = p_tve_rec.id
1976: AND OBJECT_VERSION_NUMBER = p_tve_rec.object_version_number
1977: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1978:

Line 1981: FROM OKC_TIMEVALUES

1977: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1978:
1979: CURSOR lchk_csr (p_tve_rec IN tve_rec_type) IS
1980: SELECT OBJECT_VERSION_NUMBER
1981: FROM OKC_TIMEVALUES
1982: WHERE ID = p_tve_rec.id;
1983: l_api_version CONSTANT NUMBER := 1;
1984: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1985: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1986: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1982: WHERE ID = p_tve_rec.id;
1983: l_api_version CONSTANT NUMBER := 1;
1984: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1985: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1986: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1987: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1988: l_row_notfound BOOLEAN := FALSE;
1989: lc_row_notfound BOOLEAN := FALSE;
1990: BEGIN

Line 1987: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1983: l_api_version CONSTANT NUMBER := 1;
1984: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1985: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1986: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1987: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1988: l_row_notfound BOOLEAN := FALSE;
1989: lc_row_notfound BOOLEAN := FALSE;
1990: BEGIN
1991: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2067: -- lock_row for:OKC_TIMEVALUES_TL --

2063: '_PVT'
2064: );
2065: END lock_row;
2066: ------------------------------------
2067: -- lock_row for:OKC_TIMEVALUES_TL --
2068: ------------------------------------
2069: /* PROCEDURE lock_row(
2070: p_init_msg_list IN VARCHAR2 ,
2071: x_return_status OUT NOCOPY VARCHAR2,

Line 2074: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

2070: p_init_msg_list IN VARCHAR2 ,
2071: x_return_status OUT NOCOPY VARCHAR2,
2072: x_msg_count OUT NOCOPY NUMBER,
2073: x_msg_data OUT NOCOPY VARCHAR2,
2074: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2075:
2076: E_Resource_Busy EXCEPTION;
2077: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2078: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

Line 2078: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

2074: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2075:
2076: E_Resource_Busy EXCEPTION;
2077: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2078: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2079: SELECT id
2080: FROM OKC_TIMEVALUES_TL
2081: WHERE ID = p_okc_timevalues_tl_rec.id
2082: FOR UPDATE NOWAIT;

Line 2080: FROM OKC_TIMEVALUES_TL

2076: E_Resource_Busy EXCEPTION;
2077: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2078: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2079: SELECT id
2080: FROM OKC_TIMEVALUES_TL
2081: WHERE ID = p_okc_timevalues_tl_rec.id
2082: FOR UPDATE NOWAIT;
2083:
2084: l_api_version CONSTANT NUMBER := 1;

Line 2081: WHERE ID = p_okc_timevalues_tl_rec.id

2077: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2078: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2079: SELECT id
2080: FROM OKC_TIMEVALUES_TL
2081: WHERE ID = p_okc_timevalues_tl_rec.id
2082: FOR UPDATE NOWAIT;
2083:
2084: l_api_version CONSTANT NUMBER := 1;
2085: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2101: OPEN lock_csr(p_okc_timevalues_tl_rec);

2097: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2098: RAISE OKC_API.G_EXCEPTION_ERROR;
2099: END IF;
2100: BEGIN
2101: OPEN lock_csr(p_okc_timevalues_tl_rec);
2102: FETCH lock_csr INTO l_lock_var;
2103: l_row_notfound := lock_csr%NOTFOUND;
2104: CLOSE lock_csr;
2105: EXCEPTION

Line 2167: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2163: l_api_version CONSTANT NUMBER := 1;
2164: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2165: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2166: l_tve_rec tve_rec_type;
2167: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2168: BEGIN
2169: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2170: G_PKG_NAME,
2171: p_init_msg_list,

Line 2185: --Bug 3122962 migrate(p_isev_rec, l_okc_timevalues_tl_rec);

2181: --------------------------------------
2182: -- Move VIEW record to "Child" records
2183: --------------------------------------
2184: migrate(p_isev_rec, l_tve_rec);
2185: --Bug 3122962 migrate(p_isev_rec, l_okc_timevalues_tl_rec);
2186: --------------------------------------------
2187: -- Call the LOCK_ROW for each child record
2188: --------------------------------------------
2189: lock_row(

Line 2206: l_okc_timevalues_tl_rec

2202: p_init_msg_list,
2203: x_return_status,
2204: x_msg_count,
2205: x_msg_data,
2206: l_okc_timevalues_tl_rec
2207: );
2208: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2209: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2210: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2315: -- update_row for:OKC_TIMEVALUES_B --

2311: ---------------------------------------------------------------------------
2312: -- PROCEDURE update_row
2313: ---------------------------------------------------------------------------
2314: -------------------------------------
2315: -- update_row for:OKC_TIMEVALUES_B --
2316: -------------------------------------
2317: PROCEDURE update_row(
2318: p_init_msg_list IN VARCHAR2 ,
2319: x_return_status OUT NOCOPY VARCHAR2,

Line 2553: -- Set_Attributes for:OKC_TIMEVALUES_B --

2549:
2550: RETURN(l_return_status);
2551: END populate_new_record;
2552: -----------------------------------------
2553: -- Set_Attributes for:OKC_TIMEVALUES_B --
2554: -----------------------------------------
2555: FUNCTION Set_Attributes (
2556: p_tve_rec IN tve_rec_type,
2557: x_tve_rec OUT NOCOPY tve_rec_type

Line 2590: UPDATE OKC_TIMEVALUES

2586: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2587: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2588: RAISE OKC_API.G_EXCEPTION_ERROR;
2589: END IF;
2590: UPDATE OKC_TIMEVALUES
2591: SET SPN_ID = l_def_tve_rec.spn_id,
2592: TVE_ID_OFFSET = l_def_tve_rec.tve_id_offset,
2593: uom_code = l_def_tve_rec.uom_code,
2594: CNH_ID = l_def_tve_rec.cnh_id,

Line 2678: -- update_row for:OKC_TIMEVALUES_TL --

2674: '_PVT'
2675: );
2676: END update_row;
2677: --------------------------------------
2678: -- update_row for:OKC_TIMEVALUES_TL --
2679: --------------------------------------
2680: /* PROCEDURE update_row(
2681: p_init_msg_list IN VARCHAR2 ,
2682: x_return_status OUT NOCOPY VARCHAR2,

Line 2685: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2681: p_init_msg_list IN VARCHAR2 ,
2682: x_return_status OUT NOCOPY VARCHAR2,
2683: x_msg_count OUT NOCOPY NUMBER,
2684: x_msg_data OUT NOCOPY VARCHAR2,
2685: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2686: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2687:
2688: l_api_version CONSTANT NUMBER := 1;
2689: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2686: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

2682: x_return_status OUT NOCOPY VARCHAR2,
2683: x_msg_count OUT NOCOPY NUMBER,
2684: x_msg_data OUT NOCOPY VARCHAR2,
2685: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2686: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2687:
2688: l_api_version CONSTANT NUMBER := 1;
2689: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2690: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2691: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

2687:
2688: l_api_version CONSTANT NUMBER := 1;
2689: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2690: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2691: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2692: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2693: l_row_notfound BOOLEAN := TRUE;
2694: ----------------------------------
2695: -- FUNCTION populate_new_record --

Line 2692: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2688: l_api_version CONSTANT NUMBER := 1;
2689: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2690: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2691: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2692: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2693: l_row_notfound BOOLEAN := TRUE;
2694: ----------------------------------
2695: -- FUNCTION populate_new_record --
2696: ----------------------------------

Line 2698: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2694: ----------------------------------
2695: -- FUNCTION populate_new_record --
2696: ----------------------------------
2697: FUNCTION populate_new_record (
2698: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2699: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2700: ) RETURN VARCHAR2 IS
2701: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2702: l_row_notfound BOOLEAN := TRUE;

Line 2699: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2695: -- FUNCTION populate_new_record --
2696: ----------------------------------
2697: FUNCTION populate_new_record (
2698: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2699: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2700: ) RETURN VARCHAR2 IS
2701: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2702: l_row_notfound BOOLEAN := TRUE;
2703: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2701: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2697: FUNCTION populate_new_record (
2698: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2699: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2700: ) RETURN VARCHAR2 IS
2701: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2702: l_row_notfound BOOLEAN := TRUE;
2703: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2704: BEGIN
2705: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2705: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2701: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2702: l_row_notfound BOOLEAN := TRUE;
2703: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2704: BEGIN
2705: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2706: -- Get current database values
2707: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2708: IF (l_row_notfound) THEN
2709: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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

2703: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2704: BEGIN
2705: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2706: -- Get current database values
2707: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2708: IF (l_row_notfound) THEN
2709: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2710: END IF;
2711: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)

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

2707: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2708: IF (l_row_notfound) THEN
2709: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2710: END IF;
2711: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2712: THEN
2713: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2714: END IF;
2715: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)

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

2709: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2710: END IF;
2711: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2712: THEN
2713: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2714: END IF;
2715: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2716: THEN
2717: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;

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

2711: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2712: THEN
2713: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2714: END IF;
2715: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2716: THEN
2717: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2718: END IF;
2719: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

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

2713: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2714: END IF;
2715: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2716: THEN
2717: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2718: END IF;
2719: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2720: THEN
2721: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;

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

2715: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2716: THEN
2717: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2718: END IF;
2719: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2720: THEN
2721: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2722: END IF;
2723: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

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

2717: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2718: END IF;
2719: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2720: THEN
2721: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2722: END IF;
2723: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2724: THEN
2725: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;

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

2719: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2720: THEN
2721: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2722: END IF;
2723: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2724: THEN
2725: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2726: END IF;
2727: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)

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

2721: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2722: END IF;
2723: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2724: THEN
2725: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2726: END IF;
2727: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2728: THEN
2729: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;

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

2723: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2724: THEN
2725: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2726: END IF;
2727: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2728: THEN
2729: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2730: END IF;
2731: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)

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

2725: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2726: END IF;
2727: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2728: THEN
2729: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2730: END IF;
2731: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2732: THEN
2733: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;

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

2727: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2728: THEN
2729: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2730: END IF;
2731: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2732: THEN
2733: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2734: END IF;
2735: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)

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

2729: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2730: END IF;
2731: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2732: THEN
2733: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2734: END IF;
2735: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2736: THEN
2737: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;

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

2731: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2732: THEN
2733: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2734: END IF;
2735: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2736: THEN
2737: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2738: END IF;
2739: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)

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

2733: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2734: END IF;
2735: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2736: THEN
2737: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2738: END IF;
2739: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2740: THEN
2741: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;

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

2735: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2736: THEN
2737: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2738: END IF;
2739: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2740: THEN
2741: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2742: END IF;
2743: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)

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

2737: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2738: END IF;
2739: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2740: THEN
2741: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2742: END IF;
2743: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2744: THEN
2745: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;

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

2739: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2740: THEN
2741: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2742: END IF;
2743: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2744: THEN
2745: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2746: END IF;
2747: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)

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

2741: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2742: END IF;
2743: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2744: THEN
2745: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2746: END IF;
2747: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2748: THEN
2749: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;

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

2743: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2744: THEN
2745: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2746: END IF;
2747: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2748: THEN
2749: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2750: END IF;
2751: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

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

2745: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2746: END IF;
2747: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2748: THEN
2749: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2750: END IF;
2751: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2752: THEN
2753: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;

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

2747: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2748: THEN
2749: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2750: END IF;
2751: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2752: THEN
2753: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2754: END IF;
2755: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

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

2749: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2750: END IF;
2751: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2752: THEN
2753: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2754: END IF;
2755: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2756: THEN
2757: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;

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

2751: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2752: THEN
2753: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2754: END IF;
2755: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2756: THEN
2757: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2758: END IF;
2759: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

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

2753: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2754: END IF;
2755: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2756: THEN
2757: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2758: END IF;
2759: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2760: THEN
2761: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;

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

2755: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2756: THEN
2757: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2758: END IF;
2759: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2760: THEN
2761: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2762: END IF;
2763: RETURN(l_return_status);

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

2757: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2758: END IF;
2759: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2760: THEN
2761: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2762: END IF;
2763: RETURN(l_return_status);
2764: END populate_new_record;
2765: ------------------------------------------

Line 2766: -- Set_Attributes for:OKC_TIMEVALUES_TL --

2762: END IF;
2763: RETURN(l_return_status);
2764: END populate_new_record;
2765: ------------------------------------------
2766: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2767: ------------------------------------------
2768: FUNCTION Set_Attributes (
2769: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2770: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 2769: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2765: ------------------------------------------
2766: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2767: ------------------------------------------
2768: FUNCTION Set_Attributes (
2769: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2770: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2771: ) RETURN VARCHAR2 IS
2772: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2773: BEGIN

Line 2770: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2766: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2767: ------------------------------------------
2768: FUNCTION Set_Attributes (
2769: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2770: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2771: ) RETURN VARCHAR2 IS
2772: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2773: BEGIN
2774: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2774: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2770: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2771: ) RETURN VARCHAR2 IS
2772: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2773: BEGIN
2774: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2775: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2776: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2777: RETURN(l_return_status);
2778: END Set_Attributes;

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

2771: ) RETURN VARCHAR2 IS
2772: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2773: BEGIN
2774: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2775: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2776: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2777: RETURN(l_return_status);
2778: END Set_Attributes;
2779: BEGIN

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

2772: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2773: BEGIN
2774: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2775: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2776: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2777: RETURN(l_return_status);
2778: END Set_Attributes;
2779: BEGIN
2780: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2791: p_okc_timevalues_tl_rec, -- IN

2787: RAISE OKC_API.G_EXCEPTION_ERROR;
2788: END IF;
2789: --- Setting item attributes
2790: l_return_status := Set_Attributes(
2791: p_okc_timevalues_tl_rec, -- IN
2792: l_okc_timevalues_tl_rec); -- OUT
2793: --- If any errors happen abort API
2794: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2792: l_okc_timevalues_tl_rec); -- OUT

2788: END IF;
2789: --- Setting item attributes
2790: l_return_status := Set_Attributes(
2791: p_okc_timevalues_tl_rec, -- IN
2792: l_okc_timevalues_tl_rec); -- OUT
2793: --- If any errors happen abort API
2794: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2797: RAISE OKC_API.G_EXCEPTION_ERROR;
2798: END IF;
2799: l_return_status := populate_new_record(l_okc_timevalues_tl_rec, l_def_okc_timevalues_tl_rec);
2800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2803: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2805: UPDATE OKC_TIMEVALUES_TL

2801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2803: RAISE OKC_API.G_EXCEPTION_ERROR;
2804: END IF;
2805: UPDATE OKC_TIMEVALUES_TL
2806: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2807: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2808: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2809: NAME = l_def_okc_timevalues_tl_rec.name,

Line 2806: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,

2802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2803: RAISE OKC_API.G_EXCEPTION_ERROR;
2804: END IF;
2805: UPDATE OKC_TIMEVALUES_TL
2806: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2807: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2808: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2809: NAME = l_def_okc_timevalues_tl_rec.name,
2810: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

Line 2807: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,

2803: RAISE OKC_API.G_EXCEPTION_ERROR;
2804: END IF;
2805: UPDATE OKC_TIMEVALUES_TL
2806: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2807: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2808: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2809: NAME = l_def_okc_timevalues_tl_rec.name,
2810: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2811: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

Line 2808: COMMENTS = l_def_okc_timevalues_tl_rec.comments,

2804: END IF;
2805: UPDATE OKC_TIMEVALUES_TL
2806: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2807: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2808: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2809: NAME = l_def_okc_timevalues_tl_rec.name,
2810: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2811: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2812: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

Line 2809: NAME = l_def_okc_timevalues_tl_rec.name,

2805: UPDATE OKC_TIMEVALUES_TL
2806: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2807: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2808: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2809: NAME = l_def_okc_timevalues_tl_rec.name,
2810: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2811: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2812: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2813: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

Line 2810: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

2806: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2807: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2808: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2809: NAME = l_def_okc_timevalues_tl_rec.name,
2810: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2811: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2812: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2813: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2814: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

Line 2811: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

2807: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2808: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2809: NAME = l_def_okc_timevalues_tl_rec.name,
2810: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2811: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2812: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2813: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2814: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2815: WHERE ID = l_def_okc_timevalues_tl_rec.id

Line 2812: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

2808: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2809: NAME = l_def_okc_timevalues_tl_rec.name,
2810: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2811: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2812: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2813: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2814: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2815: WHERE ID = l_def_okc_timevalues_tl_rec.id
2816: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);

Line 2813: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

2809: NAME = l_def_okc_timevalues_tl_rec.name,
2810: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2811: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2812: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2813: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2814: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2815: WHERE ID = l_def_okc_timevalues_tl_rec.id
2816: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2817:

Line 2814: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

2810: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2811: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2812: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2813: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2814: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2815: WHERE ID = l_def_okc_timevalues_tl_rec.id
2816: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2817:
2818: UPDATE OKC_TIMEVALUES_TL

Line 2815: WHERE ID = l_def_okc_timevalues_tl_rec.id

2811: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2812: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2813: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2814: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2815: WHERE ID = l_def_okc_timevalues_tl_rec.id
2816: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2817:
2818: UPDATE OKC_TIMEVALUES_TL
2819: SET SFWT_FLAG = 'Y'

Line 2818: UPDATE OKC_TIMEVALUES_TL

2814: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2815: WHERE ID = l_def_okc_timevalues_tl_rec.id
2816: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2817:
2818: UPDATE OKC_TIMEVALUES_TL
2819: SET SFWT_FLAG = 'Y'
2820: WHERE ID = l_def_okc_timevalues_tl_rec.id
2821: AND SOURCE_LANG <> USERENV('LANG');
2822: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;

Line 2820: WHERE ID = l_def_okc_timevalues_tl_rec.id

2816: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2817:
2818: UPDATE OKC_TIMEVALUES_TL
2819: SET SFWT_FLAG = 'Y'
2820: WHERE ID = l_def_okc_timevalues_tl_rec.id
2821: AND SOURCE_LANG <> USERENV('LANG');
2822: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2823: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2824: EXCEPTION

Line 2822: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;

2818: UPDATE OKC_TIMEVALUES_TL
2819: SET SFWT_FLAG = 'Y'
2820: WHERE ID = l_def_okc_timevalues_tl_rec.id
2821: AND SOURCE_LANG <> USERENV('LANG');
2822: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2823: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2824: EXCEPTION
2825: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2826: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2874: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2870: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2871: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2872: l_isev_rec isev_rec_type := p_isev_rec;
2873: l_def_isev_rec isev_rec_type;
2874: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2875: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2876: l_tve_rec tve_rec_type;
2877: lx_tve_rec tve_rec_type;
2878: -------------------------------

Line 2875: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2871: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2872: l_isev_rec isev_rec_type := p_isev_rec;
2873: l_def_isev_rec isev_rec_type;
2874: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2875: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2876: l_tve_rec tve_rec_type;
2877: lx_tve_rec tve_rec_type;
2878: -------------------------------
2879: -- FUNCTION fill_who_columns --

Line 3124: --Bug 3122962 migrate(l_def_isev_rec, l_okc_timevalues_tl_rec);

3120:
3121: --------------------------------------
3122: -- Move VIEW record to "Child" records
3123: --------------------------------------
3124: --Bug 3122962 migrate(l_def_isev_rec, l_okc_timevalues_tl_rec);
3125: migrate(l_def_isev_rec, l_tve_rec);
3126: --------------------------------------------
3127: -- Call the UPDATE_ROW for each child record
3128: --------------------------------------------

Line 3134: l_okc_timevalues_tl_rec,

3130: p_init_msg_list,
3131: x_return_status,
3132: x_msg_count,
3133: x_msg_data,
3134: l_okc_timevalues_tl_rec,
3135: lx_okc_timevalues_tl_rec
3136: );
3137: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3138: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3135: lx_okc_timevalues_tl_rec

3131: x_return_status,
3132: x_msg_count,
3133: x_msg_data,
3134: l_okc_timevalues_tl_rec,
3135: lx_okc_timevalues_tl_rec
3136: );
3137: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3138: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3139: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3142: migrate(lx_okc_timevalues_tl_rec, l_def_isev_rec);

3138: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3139: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3140: RAISE OKC_API.G_EXCEPTION_ERROR;
3141: END IF;
3142: migrate(lx_okc_timevalues_tl_rec, l_def_isev_rec);
3143: */
3144: update_row(
3145: p_init_msg_list,
3146: x_return_status,

Line 3262: -- delete_row for:OKC_TIMEVALUES_B --

3258: ---------------------------------------------------------------------------
3259: -- PROCEDURE delete_row
3260: ---------------------------------------------------------------------------
3261: -------------------------------------
3262: -- delete_row for:OKC_TIMEVALUES_B --
3263: -------------------------------------
3264: PROCEDURE delete_row(
3265: p_init_msg_list IN VARCHAR2 ,
3266: x_return_status OUT NOCOPY VARCHAR2,

Line 3286: DELETE FROM OKC_TIMEVALUES

3282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3283: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3284: RAISE OKC_API.G_EXCEPTION_ERROR;
3285: END IF;
3286: DELETE FROM OKC_TIMEVALUES
3287: WHERE ID = l_tve_rec.id;
3288:
3289: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3290: EXCEPTION

Line 3323: -- delete_row for:OKC_TIMEVALUES_TL --

3319: '_PVT'
3320: );
3321: END delete_row;
3322: --------------------------------------
3323: -- delete_row for:OKC_TIMEVALUES_TL --
3324: --------------------------------------
3325: /* PROCEDURE delete_row(
3326: p_init_msg_list IN VARCHAR2 ,
3327: x_return_status OUT NOCOPY VARCHAR2,

Line 3330: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

3326: p_init_msg_list IN VARCHAR2 ,
3327: x_return_status OUT NOCOPY VARCHAR2,
3328: x_msg_count OUT NOCOPY NUMBER,
3329: x_msg_data OUT NOCOPY VARCHAR2,
3330: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
3331:
3332: l_api_version CONSTANT NUMBER := 1;
3333: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3334: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3335: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;

3331:
3332: l_api_version CONSTANT NUMBER := 1;
3333: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3334: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3335: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3336: l_row_notfound BOOLEAN := TRUE;
3337: ------------------------------------------
3338: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3339: ------------------------------------------

Line 3338: -- Set_Attributes for:OKC_TIMEVALUES_TL --

3334: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3335: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3336: l_row_notfound BOOLEAN := TRUE;
3337: ------------------------------------------
3338: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3339: ------------------------------------------
3340: FUNCTION Set_Attributes (
3341: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3342: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 3341: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

3337: ------------------------------------------
3338: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3339: ------------------------------------------
3340: FUNCTION Set_Attributes (
3341: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3342: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3343: ) RETURN VARCHAR2 IS
3344: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3345: BEGIN

Line 3342: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

3338: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3339: ------------------------------------------
3340: FUNCTION Set_Attributes (
3341: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3342: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3343: ) RETURN VARCHAR2 IS
3344: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3345: BEGIN
3346: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 3346: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

3342: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3343: ) RETURN VARCHAR2 IS
3344: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3345: BEGIN
3346: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3347: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3348: RETURN(l_return_status);
3349: END Set_Attributes;
3350: BEGIN

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

3343: ) RETURN VARCHAR2 IS
3344: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3345: BEGIN
3346: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3347: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3348: RETURN(l_return_status);
3349: END Set_Attributes;
3350: BEGIN
3351: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3362: p_okc_timevalues_tl_rec, -- IN

3358: RAISE OKC_API.G_EXCEPTION_ERROR;
3359: END IF;
3360: --- Setting item attributes
3361: l_return_status := Set_Attributes(
3362: p_okc_timevalues_tl_rec, -- IN
3363: l_okc_timevalues_tl_rec); -- OUT
3364: --- If any errors happen abort API
3365: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3366: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3363: l_okc_timevalues_tl_rec); -- OUT

3359: END IF;
3360: --- Setting item attributes
3361: l_return_status := Set_Attributes(
3362: p_okc_timevalues_tl_rec, -- IN
3363: l_okc_timevalues_tl_rec); -- OUT
3364: --- If any errors happen abort API
3365: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3366: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3367: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3370: DELETE FROM OKC_TIMEVALUES_TL

3366: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3367: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3368: RAISE OKC_API.G_EXCEPTION_ERROR;
3369: END IF;
3370: DELETE FROM OKC_TIMEVALUES_TL
3371: WHERE ID = l_okc_timevalues_tl_rec.id;
3372:
3373: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3374: EXCEPTION

Line 3371: WHERE ID = l_okc_timevalues_tl_rec.id;

3367: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3368: RAISE OKC_API.G_EXCEPTION_ERROR;
3369: END IF;
3370: DELETE FROM OKC_TIMEVALUES_TL
3371: WHERE ID = l_okc_timevalues_tl_rec.id;
3372:
3373: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3374: EXCEPTION
3375: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3422: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

3418: l_api_version CONSTANT NUMBER := 1;
3419: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3420: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3421: l_isev_rec isev_rec_type := p_isev_rec;
3422: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
3423: l_tve_rec tve_rec_type;
3424: BEGIN
3425: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3426: G_PKG_NAME,

Line 3440: --Bug 3122962 migrate(l_isev_rec, l_okc_timevalues_tl_rec);

3436: END IF;
3437: --------------------------------------
3438: -- Move VIEW record to "Child" records
3439: --------------------------------------
3440: --Bug 3122962 migrate(l_isev_rec, l_okc_timevalues_tl_rec);
3441: migrate(l_isev_rec, l_tve_rec);
3442: --------------------------------------------
3443: -- Call the DELETE_ROW for each child record
3444: --------------------------------------------

Line 3451: l_okc_timevalues_tl_rec

3447: p_init_msg_list,
3448: x_return_status,
3449: x_msg_count,
3450: x_msg_data,
3451: l_okc_timevalues_tl_rec
3452: );
3453: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3455: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN