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

Line 38: -- FUNCTION get_rec for: OKC_TIMEVALUES

34: null;
35: END api_copy;
36:
37: ---------------------------------------------------------------------------
38: -- FUNCTION get_rec for: OKC_TIMEVALUES
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_TPG_DELIMITED_V

Line 459: -- FUNCTION null_out_defaults for: OKC_TIMEVALUES_V --

455: END null_out_defaults;
456:
457: --**** Change from TAPI Code---follow till end of change---------------
458: ------------------------------------------------------
459: -- FUNCTION null_out_defaults for: OKC_TIMEVALUES_V --
460: ------------------------------------------------------
461: -- 1. Added null_out_defaults to overcome number initialization
462: -- problem while populating optional columns for supertypes from a subtype
463: -- 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 729: FROM Okc_Timevalues

725: item_not_found_error EXCEPTION;
726: l_row_notfound BOOLEAN := TRUE;
727: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
728: SELECT '1'
729: FROM Okc_Timevalues
730: WHERE id = p_id
731: and tve_type in ('ISE','IGS');
732: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
733: BEGIN

Line 1165: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type

1161: END migrate;
1162: /*
1163: PROCEDURE migrate (
1164: p_from IN tgdv_rec_type,
1165: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
1166: ) IS
1167: l_tve_tl_type okc_timevalues_tl_rec_type;
1168: BEGIN
1169: p_to.id := p_from.id;

Line 1167: l_tve_tl_type okc_timevalues_tl_rec_type;

1163: PROCEDURE migrate (
1164: p_from IN tgdv_rec_type,
1165: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
1166: ) IS
1167: l_tve_tl_type okc_timevalues_tl_rec_type;
1168: BEGIN
1169: p_to.id := p_from.id;
1170: p_to.sfwt_flag := p_from.sfwt_flag;
1171: p_to.description := p_from.description;

Line 1185: p_from IN okc_timevalues_tl_rec_type,

1181: l_tve_tl_type := null_out_defaults(p_to);
1182: p_to := l_tve_tl_type;
1183: END migrate;
1184: PROCEDURE migrate (
1185: p_from IN okc_timevalues_tl_rec_type,
1186: p_to IN OUT NOCOPY tgdv_rec_type
1187: ) IS
1188: BEGIN
1189: p_to.id := p_from.id;

Line 1220: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1216: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1217: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1218: l_tgdv_rec tgdv_rec_type := p_tgdv_rec;
1219: l_tve_rec tve_rec_type;
1220: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1221: BEGIN
1222: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1223: G_PKG_NAME,
1224: p_init_msg_list,

Line 1349: -- insert_row for:OKC_TIMEVALUES_B --

1345: ---------------------------------------------------------------------------
1346: -- PROCEDURE insert_row
1347: ---------------------------------------------------------------------------
1348: -------------------------------------
1349: -- insert_row for:OKC_TIMEVALUES_B --
1350: -------------------------------------
1351: PROCEDURE insert_row(
1352: p_init_msg_list IN VARCHAR2,
1353: x_return_status OUT NOCOPY VARCHAR2,

Line 1365: -- Set_Attributes for:OKC_TIMEVALUES_B --

1361: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1362: l_tve_rec tve_rec_type := p_tve_rec;
1363: l_def_tve_rec tve_rec_type;
1364: -----------------------------------------
1365: -- Set_Attributes for:OKC_TIMEVALUES_B --
1366: -----------------------------------------
1367: FUNCTION Set_Attributes (
1368: p_tve_rec IN tve_rec_type,
1369: x_tve_rec OUT NOCOPY tve_rec_type

Line 1396: INSERT INTO OKC_TIMEVALUES(

1392: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1393: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1394: RAISE OKC_API.G_EXCEPTION_ERROR;
1395: END IF;
1396: INSERT INTO OKC_TIMEVALUES(
1397: id,
1398: spn_id,
1399: tve_id_offset,
1400: uom_code,

Line 1538: -- insert_row for:OKC_TIMEVALUES_TL --

1534: '_PVT'
1535: );
1536: END insert_row;
1537: --------------------------------------
1538: -- insert_row for:OKC_TIMEVALUES_TL --
1539: --------------------------------------
1540: /* PROCEDURE insert_row(
1541: p_init_msg_list IN VARCHAR2,
1542: x_return_status OUT NOCOPY VARCHAR2,

Line 1545: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1541: p_init_msg_list IN VARCHAR2,
1542: x_return_status OUT NOCOPY VARCHAR2,
1543: x_msg_count OUT NOCOPY NUMBER,
1544: x_msg_data OUT NOCOPY VARCHAR2,
1545: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1546: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1547:
1548: l_api_version CONSTANT NUMBER := 1;
1549: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1546: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

1542: x_return_status OUT NOCOPY VARCHAR2,
1543: x_msg_count OUT NOCOPY NUMBER,
1544: x_msg_data OUT NOCOPY VARCHAR2,
1545: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1546: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1547:
1548: l_api_version CONSTANT NUMBER := 1;
1549: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1550: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1551: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

1547:
1548: l_api_version CONSTANT NUMBER := 1;
1549: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1550: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1551: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1552: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1553: CURSOR get_languages IS
1554: SELECT *
1555: FROM FND_LANGUAGES

Line 1552: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1548: l_api_version CONSTANT NUMBER := 1;
1549: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1550: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1551: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1552: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1553: CURSOR get_languages IS
1554: SELECT *
1555: FROM FND_LANGUAGES
1556: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1558: -- Set_Attributes for:OKC_TIMEVALUES_TL --

1554: SELECT *
1555: FROM FND_LANGUAGES
1556: WHERE INSTALLED_FLAG IN ('I', 'B');
1557: ------------------------------------------
1558: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1559: ------------------------------------------
1560: FUNCTION Set_Attributes (
1561: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1562: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 1561: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1557: ------------------------------------------
1558: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1559: ------------------------------------------
1560: FUNCTION Set_Attributes (
1561: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1562: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1563: ) RETURN VARCHAR2 IS
1564: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1565: BEGIN

Line 1562: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

1558: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1559: ------------------------------------------
1560: FUNCTION Set_Attributes (
1561: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1562: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1563: ) RETURN VARCHAR2 IS
1564: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1565: BEGIN
1566: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 1566: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

1562: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1563: ) RETURN VARCHAR2 IS
1564: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1565: BEGIN
1566: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1567: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1568: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1569: RETURN(l_return_status);
1570: END Set_Attributes;

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

1563: ) RETURN VARCHAR2 IS
1564: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1565: BEGIN
1566: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1567: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1568: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1569: RETURN(l_return_status);
1570: END Set_Attributes;
1571: BEGIN

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

1564: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1565: BEGIN
1566: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1567: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1568: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1569: RETURN(l_return_status);
1570: END Set_Attributes;
1571: BEGIN
1572: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1583: p_okc_timevalues_tl_rec, -- IN

1579: RAISE OKC_API.G_EXCEPTION_ERROR;
1580: END IF;
1581: --- Setting item attributes
1582: l_return_status := Set_Attributes(
1583: p_okc_timevalues_tl_rec, -- IN
1584: l_okc_timevalues_tl_rec); -- OUT
1585: --- If any errors happen abort API
1586: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1587: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1584: l_okc_timevalues_tl_rec); -- OUT

1580: END IF;
1581: --- Setting item attributes
1582: l_return_status := Set_Attributes(
1583: p_okc_timevalues_tl_rec, -- IN
1584: l_okc_timevalues_tl_rec); -- OUT
1585: --- If any errors happen abort API
1586: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1587: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1588: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

1588: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1589: RAISE OKC_API.G_EXCEPTION_ERROR;
1590: END IF;
1591: FOR l_lang_rec IN get_languages LOOP
1592: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1593: INSERT INTO OKC_TIMEVALUES_TL(
1594: id,
1595: language,
1596: source_lang,

Line 1593: INSERT INTO OKC_TIMEVALUES_TL(

1589: RAISE OKC_API.G_EXCEPTION_ERROR;
1590: END IF;
1591: FOR l_lang_rec IN get_languages LOOP
1592: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1593: INSERT INTO OKC_TIMEVALUES_TL(
1594: id,
1595: language,
1596: source_lang,
1597: sfwt_flag,

Line 1608: l_okc_timevalues_tl_rec.id,

1604: last_updated_by,
1605: last_update_date,
1606: last_update_login)
1607: VALUES (
1608: l_okc_timevalues_tl_rec.id,
1609: l_okc_timevalues_tl_rec.language,
1610: l_okc_timevalues_tl_rec.source_lang,
1611: l_okc_timevalues_tl_rec.sfwt_flag,
1612: l_okc_timevalues_tl_rec.description,

Line 1609: l_okc_timevalues_tl_rec.language,

1605: last_update_date,
1606: last_update_login)
1607: VALUES (
1608: l_okc_timevalues_tl_rec.id,
1609: l_okc_timevalues_tl_rec.language,
1610: l_okc_timevalues_tl_rec.source_lang,
1611: l_okc_timevalues_tl_rec.sfwt_flag,
1612: l_okc_timevalues_tl_rec.description,
1613: l_okc_timevalues_tl_rec.short_description,

Line 1610: l_okc_timevalues_tl_rec.source_lang,

1606: last_update_login)
1607: VALUES (
1608: l_okc_timevalues_tl_rec.id,
1609: l_okc_timevalues_tl_rec.language,
1610: l_okc_timevalues_tl_rec.source_lang,
1611: l_okc_timevalues_tl_rec.sfwt_flag,
1612: l_okc_timevalues_tl_rec.description,
1613: l_okc_timevalues_tl_rec.short_description,
1614: l_okc_timevalues_tl_rec.comments,

Line 1611: l_okc_timevalues_tl_rec.sfwt_flag,

1607: VALUES (
1608: l_okc_timevalues_tl_rec.id,
1609: l_okc_timevalues_tl_rec.language,
1610: l_okc_timevalues_tl_rec.source_lang,
1611: l_okc_timevalues_tl_rec.sfwt_flag,
1612: l_okc_timevalues_tl_rec.description,
1613: l_okc_timevalues_tl_rec.short_description,
1614: l_okc_timevalues_tl_rec.comments,
1615: l_okc_timevalues_tl_rec.name,

Line 1612: l_okc_timevalues_tl_rec.description,

1608: l_okc_timevalues_tl_rec.id,
1609: l_okc_timevalues_tl_rec.language,
1610: l_okc_timevalues_tl_rec.source_lang,
1611: l_okc_timevalues_tl_rec.sfwt_flag,
1612: l_okc_timevalues_tl_rec.description,
1613: l_okc_timevalues_tl_rec.short_description,
1614: l_okc_timevalues_tl_rec.comments,
1615: l_okc_timevalues_tl_rec.name,
1616: l_okc_timevalues_tl_rec.created_by,

Line 1613: l_okc_timevalues_tl_rec.short_description,

1609: l_okc_timevalues_tl_rec.language,
1610: l_okc_timevalues_tl_rec.source_lang,
1611: l_okc_timevalues_tl_rec.sfwt_flag,
1612: l_okc_timevalues_tl_rec.description,
1613: l_okc_timevalues_tl_rec.short_description,
1614: l_okc_timevalues_tl_rec.comments,
1615: l_okc_timevalues_tl_rec.name,
1616: l_okc_timevalues_tl_rec.created_by,
1617: l_okc_timevalues_tl_rec.creation_date,

Line 1614: l_okc_timevalues_tl_rec.comments,

1610: l_okc_timevalues_tl_rec.source_lang,
1611: l_okc_timevalues_tl_rec.sfwt_flag,
1612: l_okc_timevalues_tl_rec.description,
1613: l_okc_timevalues_tl_rec.short_description,
1614: l_okc_timevalues_tl_rec.comments,
1615: l_okc_timevalues_tl_rec.name,
1616: l_okc_timevalues_tl_rec.created_by,
1617: l_okc_timevalues_tl_rec.creation_date,
1618: l_okc_timevalues_tl_rec.last_updated_by,

Line 1615: l_okc_timevalues_tl_rec.name,

1611: l_okc_timevalues_tl_rec.sfwt_flag,
1612: l_okc_timevalues_tl_rec.description,
1613: l_okc_timevalues_tl_rec.short_description,
1614: l_okc_timevalues_tl_rec.comments,
1615: l_okc_timevalues_tl_rec.name,
1616: l_okc_timevalues_tl_rec.created_by,
1617: l_okc_timevalues_tl_rec.creation_date,
1618: l_okc_timevalues_tl_rec.last_updated_by,
1619: l_okc_timevalues_tl_rec.last_update_date,

Line 1616: l_okc_timevalues_tl_rec.created_by,

1612: l_okc_timevalues_tl_rec.description,
1613: l_okc_timevalues_tl_rec.short_description,
1614: l_okc_timevalues_tl_rec.comments,
1615: l_okc_timevalues_tl_rec.name,
1616: l_okc_timevalues_tl_rec.created_by,
1617: l_okc_timevalues_tl_rec.creation_date,
1618: l_okc_timevalues_tl_rec.last_updated_by,
1619: l_okc_timevalues_tl_rec.last_update_date,
1620: l_okc_timevalues_tl_rec.last_update_login);

Line 1617: l_okc_timevalues_tl_rec.creation_date,

1613: l_okc_timevalues_tl_rec.short_description,
1614: l_okc_timevalues_tl_rec.comments,
1615: l_okc_timevalues_tl_rec.name,
1616: l_okc_timevalues_tl_rec.created_by,
1617: l_okc_timevalues_tl_rec.creation_date,
1618: l_okc_timevalues_tl_rec.last_updated_by,
1619: l_okc_timevalues_tl_rec.last_update_date,
1620: l_okc_timevalues_tl_rec.last_update_login);
1621: END LOOP;

Line 1618: l_okc_timevalues_tl_rec.last_updated_by,

1614: l_okc_timevalues_tl_rec.comments,
1615: l_okc_timevalues_tl_rec.name,
1616: l_okc_timevalues_tl_rec.created_by,
1617: l_okc_timevalues_tl_rec.creation_date,
1618: l_okc_timevalues_tl_rec.last_updated_by,
1619: l_okc_timevalues_tl_rec.last_update_date,
1620: l_okc_timevalues_tl_rec.last_update_login);
1621: END LOOP;
1622: -- Set OUT values

Line 1619: l_okc_timevalues_tl_rec.last_update_date,

1615: l_okc_timevalues_tl_rec.name,
1616: l_okc_timevalues_tl_rec.created_by,
1617: l_okc_timevalues_tl_rec.creation_date,
1618: l_okc_timevalues_tl_rec.last_updated_by,
1619: l_okc_timevalues_tl_rec.last_update_date,
1620: l_okc_timevalues_tl_rec.last_update_login);
1621: END LOOP;
1622: -- Set OUT values
1623: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

Line 1620: l_okc_timevalues_tl_rec.last_update_login);

1616: l_okc_timevalues_tl_rec.created_by,
1617: l_okc_timevalues_tl_rec.creation_date,
1618: l_okc_timevalues_tl_rec.last_updated_by,
1619: l_okc_timevalues_tl_rec.last_update_date,
1620: l_okc_timevalues_tl_rec.last_update_login);
1621: END LOOP;
1622: -- Set OUT values
1623: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1624: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1623: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

1619: l_okc_timevalues_tl_rec.last_update_date,
1620: l_okc_timevalues_tl_rec.last_update_login);
1621: END LOOP;
1622: -- Set OUT values
1623: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1624: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1625: EXCEPTION
1626: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1627: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1677: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1673: l_tgdv_rec tgdv_rec_type;
1674: l_def_tgdv_rec tgdv_rec_type;
1675: l_tve_rec tve_rec_type;
1676: lx_tve_rec tve_rec_type;
1677: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1678: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1679: -------------------------------
1680: -- FUNCTION fill_who_columns --
1681: -------------------------------

Line 1678: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1674: l_def_tgdv_rec tgdv_rec_type;
1675: l_tve_rec tve_rec_type;
1676: lx_tve_rec tve_rec_type;
1677: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1678: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1679: -------------------------------
1680: -- FUNCTION fill_who_columns --
1681: -------------------------------
1682: FUNCTION fill_who_columns (

Line 1755: --Bug 3122962 migrate(l_def_tgdv_rec, l_okc_timevalues_tl_rec);

1751: --------------------------------------
1752: -- Move VIEW record to "Child" records
1753: --------------------------------------
1754: migrate(l_def_tgdv_rec, l_tve_rec);
1755: --Bug 3122962 migrate(l_def_tgdv_rec, l_okc_timevalues_tl_rec);
1756: --------------------------------------------
1757: -- Call the INSERT_ROW for each child record
1758: --------------------------------------------
1759: insert_row(

Line 1778: l_okc_timevalues_tl_rec,

1774: p_init_msg_list,
1775: x_return_status,
1776: x_msg_count,
1777: x_msg_data,
1778: l_okc_timevalues_tl_rec,
1779: lx_okc_timevalues_tl_rec
1780: );
1781: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1782: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1779: lx_okc_timevalues_tl_rec

1775: x_return_status,
1776: x_msg_count,
1777: x_msg_data,
1778: l_okc_timevalues_tl_rec,
1779: lx_okc_timevalues_tl_rec
1780: );
1781: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1782: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1783: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1786: migrate(lx_okc_timevalues_tl_rec, l_def_tgdv_rec);

1782: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1783: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_ERROR;
1785: END IF;
1786: migrate(lx_okc_timevalues_tl_rec, l_def_tgdv_rec);
1787: */
1788: -- Set OUT values
1789: x_tgdv_rec := l_def_tgdv_rec;
1790: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1893: -- lock_row for:OKC_TIMEVALUES_B --

1889: ---------------------------------------------------------------------------
1890: -- PROCEDURE lock_row
1891: ---------------------------------------------------------------------------
1892: -----------------------------------
1893: -- lock_row for:OKC_TIMEVALUES_B --
1894: -----------------------------------
1895: PROCEDURE lock_row(
1896: p_init_msg_list IN VARCHAR2,
1897: x_return_status OUT NOCOPY VARCHAR2,

Line 1906: FROM OKC_TIMEVALUES

1902: E_Resource_Busy EXCEPTION;
1903: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1904: CURSOR lock_csr (p_tve_rec IN tve_rec_type) IS
1905: SELECT OBJECT_VERSION_NUMBER
1906: FROM OKC_TIMEVALUES
1907: WHERE ID = p_tve_rec.id
1908: AND OBJECT_VERSION_NUMBER = p_tve_rec.object_version_number
1909: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1910:

Line 1913: FROM OKC_TIMEVALUES

1909: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1910:
1911: CURSOR lchk_csr (p_tve_rec IN tve_rec_type) IS
1912: SELECT OBJECT_VERSION_NUMBER
1913: FROM OKC_TIMEVALUES
1914: WHERE ID = p_tve_rec.id;
1915: l_api_version CONSTANT NUMBER := 1;
1916: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1918: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1914: WHERE ID = p_tve_rec.id;
1915: l_api_version CONSTANT NUMBER := 1;
1916: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1918: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1919: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1920: l_row_notfound BOOLEAN := FALSE;
1921: lc_row_notfound BOOLEAN := FALSE;
1922: BEGIN

Line 1919: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1915: l_api_version CONSTANT NUMBER := 1;
1916: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1918: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1919: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1920: l_row_notfound BOOLEAN := FALSE;
1921: lc_row_notfound BOOLEAN := FALSE;
1922: BEGIN
1923: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1999: -- lock_row for:OKC_TIMEVALUES_TL --

1995: '_PVT'
1996: );
1997: END lock_row;
1998: ------------------------------------
1999: -- lock_row for:OKC_TIMEVALUES_TL --
2000: ------------------------------------
2001: /* PROCEDURE lock_row(
2002: p_init_msg_list IN VARCHAR2,
2003: x_return_status OUT NOCOPY VARCHAR2,

Line 2006: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

2002: p_init_msg_list IN VARCHAR2,
2003: x_return_status OUT NOCOPY VARCHAR2,
2004: x_msg_count OUT NOCOPY NUMBER,
2005: x_msg_data OUT NOCOPY VARCHAR2,
2006: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2007:
2008: E_Resource_Busy EXCEPTION;
2009: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2010: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

Line 2010: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

2006: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2007:
2008: E_Resource_Busy EXCEPTION;
2009: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2010: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2011: SELECT id
2012: FROM OKC_TIMEVALUES_TL
2013: WHERE ID = p_okc_timevalues_tl_rec.id
2014: FOR UPDATE NOWAIT;

Line 2012: FROM OKC_TIMEVALUES_TL

2008: E_Resource_Busy EXCEPTION;
2009: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2010: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2011: SELECT id
2012: FROM OKC_TIMEVALUES_TL
2013: WHERE ID = p_okc_timevalues_tl_rec.id
2014: FOR UPDATE NOWAIT;
2015:
2016: l_api_version CONSTANT NUMBER := 1;

Line 2013: WHERE ID = p_okc_timevalues_tl_rec.id

2009: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2010: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
2011: SELECT id
2012: FROM OKC_TIMEVALUES_TL
2013: WHERE ID = p_okc_timevalues_tl_rec.id
2014: FOR UPDATE NOWAIT;
2015:
2016: l_api_version CONSTANT NUMBER := 1;
2017: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2033: OPEN lock_csr(p_okc_timevalues_tl_rec);

2029: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2030: RAISE OKC_API.G_EXCEPTION_ERROR;
2031: END IF;
2032: BEGIN
2033: OPEN lock_csr(p_okc_timevalues_tl_rec);
2034: FETCH lock_csr INTO l_lock_var;
2035: l_row_notfound := lock_csr%NOTFOUND;
2036: CLOSE lock_csr;
2037: EXCEPTION

Line 2099: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2095: l_api_version CONSTANT NUMBER := 1;
2096: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2097: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2098: l_tve_rec tve_rec_type;
2099: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2100: BEGIN
2101: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2102: G_PKG_NAME,
2103: p_init_msg_list,

Line 2117: --Bug 3122962 migrate(p_tgdv_rec, l_okc_timevalues_tl_rec);

2113: --------------------------------------
2114: -- Move VIEW record to "Child" records
2115: --------------------------------------
2116: migrate(p_tgdv_rec, l_tve_rec);
2117: --Bug 3122962 migrate(p_tgdv_rec, l_okc_timevalues_tl_rec);
2118: --------------------------------------------
2119: -- Call the LOCK_ROW for each child record
2120: --------------------------------------------
2121: lock_row(

Line 2138: l_okc_timevalues_tl_rec

2134: p_init_msg_list,
2135: x_return_status,
2136: x_msg_count,
2137: x_msg_data,
2138: l_okc_timevalues_tl_rec
2139: );
2140: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2247: -- update_row for:OKC_TIMEVALUES_B --

2243: ---------------------------------------------------------------------------
2244: -- PROCEDURE update_row
2245: ---------------------------------------------------------------------------
2246: -------------------------------------
2247: -- update_row for:OKC_TIMEVALUES_B --
2248: -------------------------------------
2249: PROCEDURE update_row(
2250: p_init_msg_list IN VARCHAR2,
2251: x_return_status OUT NOCOPY VARCHAR2,

Line 2485: -- Set_Attributes for:OKC_TIMEVALUES_B --

2481:
2482: RETURN(l_return_status);
2483: END populate_new_record;
2484: -----------------------------------------
2485: -- Set_Attributes for:OKC_TIMEVALUES_B --
2486: -----------------------------------------
2487: FUNCTION Set_Attributes (
2488: p_tve_rec IN tve_rec_type,
2489: x_tve_rec OUT NOCOPY tve_rec_type

Line 2522: UPDATE OKC_TIMEVALUES

2518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2520: RAISE OKC_API.G_EXCEPTION_ERROR;
2521: END IF;
2522: UPDATE OKC_TIMEVALUES
2523: SET SPN_ID = l_def_tve_rec.spn_id,
2524: TVE_ID_OFFSET = l_def_tve_rec.tve_id_offset,
2525: uom_code = l_def_tve_rec.uom_code,
2526: DNZ_CHR_ID = l_def_tve_rec.dnz_chr_id,

Line 2610: -- update_row for:OKC_TIMEVALUES_TL --

2606: '_PVT'
2607: );
2608: END update_row;
2609: --------------------------------------
2610: -- update_row for:OKC_TIMEVALUES_TL --
2611: --------------------------------------
2612: /* PROCEDURE update_row(
2613: p_init_msg_list IN VARCHAR2,
2614: x_return_status OUT NOCOPY VARCHAR2,

Line 2617: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2613: p_init_msg_list IN VARCHAR2,
2614: x_return_status OUT NOCOPY VARCHAR2,
2615: x_msg_count OUT NOCOPY NUMBER,
2616: x_msg_data OUT NOCOPY VARCHAR2,
2617: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2618: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2619:
2620: l_api_version CONSTANT NUMBER := 1;
2621: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2618: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

2614: x_return_status OUT NOCOPY VARCHAR2,
2615: x_msg_count OUT NOCOPY NUMBER,
2616: x_msg_data OUT NOCOPY VARCHAR2,
2617: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2618: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2619:
2620: l_api_version CONSTANT NUMBER := 1;
2621: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2622: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2623: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

2619:
2620: l_api_version CONSTANT NUMBER := 1;
2621: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2622: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2623: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2624: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2625: l_row_notfound BOOLEAN := TRUE;
2626: ----------------------------------
2627: -- FUNCTION populate_new_record --

Line 2624: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2620: l_api_version CONSTANT NUMBER := 1;
2621: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2622: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2623: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2624: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2625: l_row_notfound BOOLEAN := TRUE;
2626: ----------------------------------
2627: -- FUNCTION populate_new_record --
2628: ----------------------------------

Line 2630: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2626: ----------------------------------
2627: -- FUNCTION populate_new_record --
2628: ----------------------------------
2629: FUNCTION populate_new_record (
2630: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2631: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2632: ) RETURN VARCHAR2 IS
2633: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2634: l_row_notfound BOOLEAN := TRUE;

Line 2631: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2627: -- FUNCTION populate_new_record --
2628: ----------------------------------
2629: FUNCTION populate_new_record (
2630: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2631: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2632: ) RETURN VARCHAR2 IS
2633: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2634: l_row_notfound BOOLEAN := TRUE;
2635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2633: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2629: FUNCTION populate_new_record (
2630: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2631: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2632: ) RETURN VARCHAR2 IS
2633: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2634: l_row_notfound BOOLEAN := TRUE;
2635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2636: BEGIN
2637: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2637: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2633: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2634: l_row_notfound BOOLEAN := TRUE;
2635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2636: BEGIN
2637: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2638: -- Get current database values
2639: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2640: IF (l_row_notfound) THEN
2641: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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

2635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2636: BEGIN
2637: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2638: -- Get current database values
2639: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2640: IF (l_row_notfound) THEN
2641: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2642: END IF;
2643: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)

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

2639: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2640: IF (l_row_notfound) THEN
2641: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2642: END IF;
2643: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2644: THEN
2645: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2646: END IF;
2647: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)

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

2641: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2642: END IF;
2643: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2644: THEN
2645: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2646: END IF;
2647: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2648: THEN
2649: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;

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

2643: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2644: THEN
2645: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2646: END IF;
2647: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2648: THEN
2649: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2650: END IF;
2651: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

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

2645: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2646: END IF;
2647: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2648: THEN
2649: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2650: END IF;
2651: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2652: THEN
2653: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;

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

2647: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2648: THEN
2649: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2650: END IF;
2651: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2652: THEN
2653: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2654: END IF;
2655: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

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

2649: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2650: END IF;
2651: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2652: THEN
2653: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2654: END IF;
2655: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2656: THEN
2657: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;

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

2651: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2652: THEN
2653: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2654: END IF;
2655: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2656: THEN
2657: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2658: END IF;
2659: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)

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

2653: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2654: END IF;
2655: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2656: THEN
2657: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2658: END IF;
2659: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2660: THEN
2661: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;

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

2655: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2656: THEN
2657: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2658: END IF;
2659: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2660: THEN
2661: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2662: END IF;
2663: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)

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

2657: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2658: END IF;
2659: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2660: THEN
2661: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2662: END IF;
2663: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2664: THEN
2665: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;

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

2659: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2660: THEN
2661: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2662: END IF;
2663: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2664: THEN
2665: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2666: END IF;
2667: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)

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

2661: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2662: END IF;
2663: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2664: THEN
2665: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2666: END IF;
2667: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;

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

2663: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2664: THEN
2665: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2666: END IF;
2667: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2670: END IF;
2671: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)

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

2665: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2666: END IF;
2667: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2670: END IF;
2671: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;

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

2667: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2670: END IF;
2671: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2674: END IF;
2675: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)

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

2669: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2670: END IF;
2671: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2674: END IF;
2675: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2676: THEN
2677: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;

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

2671: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2674: END IF;
2675: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2676: THEN
2677: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2678: END IF;
2679: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)

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

2673: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2674: END IF;
2675: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2676: THEN
2677: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2678: END IF;
2679: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2680: THEN
2681: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;

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

2675: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2676: THEN
2677: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2678: END IF;
2679: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2680: THEN
2681: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2682: END IF;
2683: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

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

2677: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2678: END IF;
2679: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2680: THEN
2681: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2682: END IF;
2683: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2684: THEN
2685: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;

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

2679: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2680: THEN
2681: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2682: END IF;
2683: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2684: THEN
2685: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2686: END IF;
2687: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

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

2681: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2682: END IF;
2683: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2684: THEN
2685: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2686: END IF;
2687: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2688: THEN
2689: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;

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

2683: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2684: THEN
2685: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2686: END IF;
2687: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2688: THEN
2689: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2690: END IF;
2691: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

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

2685: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2686: END IF;
2687: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2688: THEN
2689: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2690: END IF;
2691: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2692: THEN
2693: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;

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

2687: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2688: THEN
2689: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2690: END IF;
2691: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2692: THEN
2693: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2694: END IF;
2695: RETURN(l_return_status);

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

2689: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2690: END IF;
2691: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2692: THEN
2693: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2694: END IF;
2695: RETURN(l_return_status);
2696: END populate_new_record;
2697: ------------------------------------------

Line 2698: -- Set_Attributes for:OKC_TIMEVALUES_TL --

2694: END IF;
2695: RETURN(l_return_status);
2696: END populate_new_record;
2697: ------------------------------------------
2698: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2699: ------------------------------------------
2700: FUNCTION Set_Attributes (
2701: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2702: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 2701: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2697: ------------------------------------------
2698: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2699: ------------------------------------------
2700: FUNCTION Set_Attributes (
2701: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2702: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2703: ) RETURN VARCHAR2 IS
2704: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2705: BEGIN

Line 2702: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2698: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2699: ------------------------------------------
2700: FUNCTION Set_Attributes (
2701: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2702: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2703: ) RETURN VARCHAR2 IS
2704: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2705: BEGIN
2706: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2706: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2702: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2703: ) RETURN VARCHAR2 IS
2704: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2705: BEGIN
2706: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2707: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2708: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2709: RETURN(l_return_status);
2710: END Set_Attributes;

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

2703: ) RETURN VARCHAR2 IS
2704: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2705: BEGIN
2706: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2707: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2708: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2709: RETURN(l_return_status);
2710: END Set_Attributes;
2711: BEGIN

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

2704: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2705: BEGIN
2706: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2707: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2708: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2709: RETURN(l_return_status);
2710: END Set_Attributes;
2711: BEGIN
2712: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2723: p_okc_timevalues_tl_rec, -- IN

2719: RAISE OKC_API.G_EXCEPTION_ERROR;
2720: END IF;
2721: --- Setting item attributes
2722: l_return_status := Set_Attributes(
2723: p_okc_timevalues_tl_rec, -- IN
2724: l_okc_timevalues_tl_rec); -- OUT
2725: --- If any errors happen abort API
2726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2724: l_okc_timevalues_tl_rec); -- OUT

2720: END IF;
2721: --- Setting item attributes
2722: l_return_status := Set_Attributes(
2723: p_okc_timevalues_tl_rec, -- IN
2724: l_okc_timevalues_tl_rec); -- OUT
2725: --- If any errors happen abort API
2726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

2727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2729: RAISE OKC_API.G_EXCEPTION_ERROR;
2730: END IF;
2731: l_return_status := populate_new_record(l_okc_timevalues_tl_rec, l_def_okc_timevalues_tl_rec);
2732: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2733: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2734: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2735: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2737: UPDATE OKC_TIMEVALUES_TL

2733: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2734: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2735: RAISE OKC_API.G_EXCEPTION_ERROR;
2736: END IF;
2737: UPDATE OKC_TIMEVALUES_TL
2738: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2739: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2740: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2741: NAME = l_def_okc_timevalues_tl_rec.name,

Line 2738: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,

2734: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2735: RAISE OKC_API.G_EXCEPTION_ERROR;
2736: END IF;
2737: UPDATE OKC_TIMEVALUES_TL
2738: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2739: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2740: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2741: NAME = l_def_okc_timevalues_tl_rec.name,
2742: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

Line 2739: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,

2735: RAISE OKC_API.G_EXCEPTION_ERROR;
2736: END IF;
2737: UPDATE OKC_TIMEVALUES_TL
2738: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2739: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2740: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2741: NAME = l_def_okc_timevalues_tl_rec.name,
2742: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2743: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

Line 2740: COMMENTS = l_def_okc_timevalues_tl_rec.comments,

2736: END IF;
2737: UPDATE OKC_TIMEVALUES_TL
2738: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2739: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2740: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2741: NAME = l_def_okc_timevalues_tl_rec.name,
2742: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2743: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2744: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

Line 2741: NAME = l_def_okc_timevalues_tl_rec.name,

2737: UPDATE OKC_TIMEVALUES_TL
2738: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2739: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2740: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2741: NAME = l_def_okc_timevalues_tl_rec.name,
2742: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2743: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2744: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2745: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

Line 2742: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

2738: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2739: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2740: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2741: NAME = l_def_okc_timevalues_tl_rec.name,
2742: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2743: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2744: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2745: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2746: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

Line 2743: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

2739: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2740: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2741: NAME = l_def_okc_timevalues_tl_rec.name,
2742: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2743: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2744: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2745: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2746: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2747: WHERE ID = l_def_okc_timevalues_tl_rec.id

Line 2744: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

2740: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2741: NAME = l_def_okc_timevalues_tl_rec.name,
2742: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2743: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2744: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2745: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2746: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2747: WHERE ID = l_def_okc_timevalues_tl_rec.id
2748: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);

Line 2745: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

2741: NAME = l_def_okc_timevalues_tl_rec.name,
2742: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2743: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2744: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2745: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2746: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2747: WHERE ID = l_def_okc_timevalues_tl_rec.id
2748: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2749:

Line 2746: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

2742: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2743: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2744: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2745: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2746: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2747: WHERE ID = l_def_okc_timevalues_tl_rec.id
2748: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2749:
2750: UPDATE OKC_TIMEVALUES_TL

Line 2747: WHERE ID = l_def_okc_timevalues_tl_rec.id

2743: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2744: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2745: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2746: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2747: WHERE ID = l_def_okc_timevalues_tl_rec.id
2748: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2749:
2750: UPDATE OKC_TIMEVALUES_TL
2751: SET SFWT_FLAG = 'Y'

Line 2750: UPDATE OKC_TIMEVALUES_TL

2746: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2747: WHERE ID = l_def_okc_timevalues_tl_rec.id
2748: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2749:
2750: UPDATE OKC_TIMEVALUES_TL
2751: SET SFWT_FLAG = 'Y'
2752: WHERE ID = l_def_okc_timevalues_tl_rec.id
2753: AND SOURCE_LANG <> USERENV('LANG');
2754: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;

Line 2752: WHERE ID = l_def_okc_timevalues_tl_rec.id

2748: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2749:
2750: UPDATE OKC_TIMEVALUES_TL
2751: SET SFWT_FLAG = 'Y'
2752: WHERE ID = l_def_okc_timevalues_tl_rec.id
2753: AND SOURCE_LANG <> USERENV('LANG');
2754: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2755: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2756: EXCEPTION

Line 2754: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;

2750: UPDATE OKC_TIMEVALUES_TL
2751: SET SFWT_FLAG = 'Y'
2752: WHERE ID = l_def_okc_timevalues_tl_rec.id
2753: AND SOURCE_LANG <> USERENV('LANG');
2754: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2755: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2756: EXCEPTION
2757: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2758: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2806: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2802: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2804: l_tgdv_rec tgdv_rec_type := p_tgdv_rec;
2805: l_def_tgdv_rec tgdv_rec_type;
2806: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2807: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2808: l_tve_rec tve_rec_type;
2809: lx_tve_rec tve_rec_type;
2810: -------------------------------

Line 2807: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2804: l_tgdv_rec tgdv_rec_type := p_tgdv_rec;
2805: l_def_tgdv_rec tgdv_rec_type;
2806: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2807: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2808: l_tve_rec tve_rec_type;
2809: lx_tve_rec tve_rec_type;
2810: -------------------------------
2811: -- FUNCTION fill_who_columns --

Line 3055: --Bug 3122962 migrate(l_def_tgdv_rec, l_okc_timevalues_tl_rec);

3051: END IF;
3052: --------------------------------------
3053: -- Move VIEW record to "Child" records
3054: --------------------------------------
3055: --Bug 3122962 migrate(l_def_tgdv_rec, l_okc_timevalues_tl_rec);
3056: migrate(l_def_tgdv_rec, l_tve_rec);
3057: --------------------------------------------
3058: -- Call the UPDATE_ROW for each child record
3059: --------------------------------------------

Line 3065: l_okc_timevalues_tl_rec,

3061: p_init_msg_list,
3062: x_return_status,
3063: x_msg_count,
3064: x_msg_data,
3065: l_okc_timevalues_tl_rec,
3066: lx_okc_timevalues_tl_rec
3067: );
3068: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3066: lx_okc_timevalues_tl_rec

3062: x_return_status,
3063: x_msg_count,
3064: x_msg_data,
3065: l_okc_timevalues_tl_rec,
3066: lx_okc_timevalues_tl_rec
3067: );
3068: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3070: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3073: migrate(lx_okc_timevalues_tl_rec, l_def_tgdv_rec);

3069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3070: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3071: RAISE OKC_API.G_EXCEPTION_ERROR;
3072: END IF;
3073: migrate(lx_okc_timevalues_tl_rec, l_def_tgdv_rec);
3074: */
3075: update_row(
3076: p_init_msg_list,
3077: x_return_status,

Line 3193: -- delete_row for:OKC_TIMEVALUES_B --

3189: ---------------------------------------------------------------------------
3190: -- PROCEDURE delete_row
3191: ---------------------------------------------------------------------------
3192: -------------------------------------
3193: -- delete_row for:OKC_TIMEVALUES_B --
3194: -------------------------------------
3195: PROCEDURE delete_row(
3196: p_init_msg_list IN VARCHAR2,
3197: x_return_status OUT NOCOPY VARCHAR2,

Line 3217: DELETE FROM OKC_TIMEVALUES

3213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3214: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3215: RAISE OKC_API.G_EXCEPTION_ERROR;
3216: END IF;
3217: DELETE FROM OKC_TIMEVALUES
3218: WHERE ID = l_tve_rec.id;
3219:
3220: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3221: EXCEPTION

Line 3254: -- delete_row for:OKC_TIMEVALUES_TL --

3250: '_PVT'
3251: );
3252: END delete_row;
3253: --------------------------------------
3254: -- delete_row for:OKC_TIMEVALUES_TL --
3255: --------------------------------------
3256: /* PROCEDURE delete_row(
3257: p_init_msg_list IN VARCHAR2,
3258: x_return_status OUT NOCOPY VARCHAR2,

Line 3261: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

3257: p_init_msg_list IN VARCHAR2,
3258: x_return_status OUT NOCOPY VARCHAR2,
3259: x_msg_count OUT NOCOPY NUMBER,
3260: x_msg_data OUT NOCOPY VARCHAR2,
3261: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
3262:
3263: l_api_version CONSTANT NUMBER := 1;
3264: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3265: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3266: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;

3262:
3263: l_api_version CONSTANT NUMBER := 1;
3264: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3265: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3266: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3267: l_row_notfound BOOLEAN := TRUE;
3268: ------------------------------------------
3269: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3270: ------------------------------------------

Line 3269: -- Set_Attributes for:OKC_TIMEVALUES_TL --

3265: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3266: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3267: l_row_notfound BOOLEAN := TRUE;
3268: ------------------------------------------
3269: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3270: ------------------------------------------
3271: FUNCTION Set_Attributes (
3272: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3273: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 3272: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

3268: ------------------------------------------
3269: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3270: ------------------------------------------
3271: FUNCTION Set_Attributes (
3272: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3273: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3274: ) RETURN VARCHAR2 IS
3275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3276: BEGIN

Line 3273: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

3269: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3270: ------------------------------------------
3271: FUNCTION Set_Attributes (
3272: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3273: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3274: ) RETURN VARCHAR2 IS
3275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3276: BEGIN
3277: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 3277: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

3273: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3274: ) RETURN VARCHAR2 IS
3275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3276: BEGIN
3277: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3278: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3279: RETURN(l_return_status);
3280: END Set_Attributes;
3281: BEGIN

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

3274: ) RETURN VARCHAR2 IS
3275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3276: BEGIN
3277: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3278: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3279: RETURN(l_return_status);
3280: END Set_Attributes;
3281: BEGIN
3282: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3293: p_okc_timevalues_tl_rec, -- IN

3289: RAISE OKC_API.G_EXCEPTION_ERROR;
3290: END IF;
3291: --- Setting item attributes
3292: l_return_status := Set_Attributes(
3293: p_okc_timevalues_tl_rec, -- IN
3294: l_okc_timevalues_tl_rec); -- OUT
3295: --- If any errors happen abort API
3296: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3297: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3294: l_okc_timevalues_tl_rec); -- OUT

3290: END IF;
3291: --- Setting item attributes
3292: l_return_status := Set_Attributes(
3293: p_okc_timevalues_tl_rec, -- IN
3294: l_okc_timevalues_tl_rec); -- OUT
3295: --- If any errors happen abort API
3296: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3297: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3298: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3301: DELETE FROM OKC_TIMEVALUES_TL

3297: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3298: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3299: RAISE OKC_API.G_EXCEPTION_ERROR;
3300: END IF;
3301: DELETE FROM OKC_TIMEVALUES_TL
3302: WHERE ID = l_okc_timevalues_tl_rec.id;
3303:
3304: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3305: EXCEPTION

Line 3302: WHERE ID = l_okc_timevalues_tl_rec.id;

3298: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3299: RAISE OKC_API.G_EXCEPTION_ERROR;
3300: END IF;
3301: DELETE FROM OKC_TIMEVALUES_TL
3302: WHERE ID = l_okc_timevalues_tl_rec.id;
3303:
3304: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3305: EXCEPTION
3306: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3353: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

3349: l_api_version CONSTANT NUMBER := 1;
3350: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3351: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3352: l_tgdv_rec tgdv_rec_type := p_tgdv_rec;
3353: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
3354: l_tve_rec tve_rec_type;
3355: BEGIN
3356: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3357: G_PKG_NAME,

Line 3371: --Bug 3122962 migrate(l_tgdv_rec, l_okc_timevalues_tl_rec);

3367: END IF;
3368: --------------------------------------
3369: -- Move VIEW record to "Child" records
3370: --------------------------------------
3371: --Bug 3122962 migrate(l_tgdv_rec, l_okc_timevalues_tl_rec);
3372: migrate(l_tgdv_rec, l_tve_rec);
3373: --------------------------------------------
3374: -- Call the DELETE_ROW for each child record
3375: --------------------------------------------

Line 3381: l_okc_timevalues_tl_rec

3377: p_init_msg_list,
3378: x_return_status,
3379: x_msg_count,
3380: x_msg_data,
3381: l_okc_timevalues_tl_rec
3382: );
3383: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3384: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3385: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN