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_TGN_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_TPG_NAMED_V

Line 429: -- FUNCTION null_out_defaults for: OKC_TIMEVALUES_V --

425: END null_out_defaults;
426:
427: --**** Change from TAPI Code---follow till end of change---------------
428: ------------------------------------------------------
429: -- FUNCTION null_out_defaults for: OKC_TIMEVALUES_V --
430: ------------------------------------------------------
431: -- 1. Added null_out_defaults to overcome number initialization
432: -- problem while populating optional columns for supertypes from a subtype
433: -- 2. Moved all column validations (including FK) to Validate_column

Line 514: p_tve_tl_rec IN okc_timevalues_tl_rec_type

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

Line 515: ) RETURN okc_timevalues_tl_rec_type IS

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

Line 516: l_tve_tl_rec okc_timevalues_tl_rec_type := p_tve_tl_rec;

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

Line 656: FROM Okc_Timevalues

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

Line 958: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type

954: --Bug 3122962
955: /*
956: PROCEDURE migrate (
957: p_from IN tgnv_rec_type,
958: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
959: ) IS
960: l_tve_tl_type okc_timevalues_tl_rec_type;
961: BEGIN
962: p_to.id := p_from.id;

Line 960: l_tve_tl_type okc_timevalues_tl_rec_type;

956: PROCEDURE migrate (
957: p_from IN tgnv_rec_type,
958: p_to IN OUT NOCOPY okc_timevalues_tl_rec_type
959: ) IS
960: l_tve_tl_type okc_timevalues_tl_rec_type;
961: BEGIN
962: p_to.id := p_from.id;
963: p_to.sfwt_flag := p_from.sfwt_flag;
964: p_to.description := p_from.description;

Line 978: p_from IN okc_timevalues_tl_rec_type,

974: l_tve_tl_type := null_out_defaults(p_to);
975: p_to := l_tve_tl_type;
976: END migrate;
977: PROCEDURE migrate (
978: p_from IN okc_timevalues_tl_rec_type,
979: p_to IN OUT NOCOPY tgnv_rec_type
980: ) IS
981: BEGIN
982: p_to.id := p_from.id;

Line 1013: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1009: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1010: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1011: l_tgnv_rec tgnv_rec_type := p_tgnv_rec;
1012: l_tve_rec tve_rec_type;
1013: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1014: BEGIN
1015: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1016: G_PKG_NAME,
1017: p_init_msg_list,

Line 1142: -- insert_row for:OKC_TIMEVALUES_B --

1138: ---------------------------------------------------------------------------
1139: -- PROCEDURE insert_row
1140: ---------------------------------------------------------------------------
1141: -------------------------------------
1142: -- insert_row for:OKC_TIMEVALUES_B --
1143: -------------------------------------
1144: PROCEDURE insert_row(
1145: p_init_msg_list IN VARCHAR2,
1146: x_return_status OUT NOCOPY VARCHAR2,

Line 1158: -- Set_Attributes for:OKC_TIMEVALUES_B --

1154: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1155: l_tve_rec tve_rec_type := p_tve_rec;
1156: l_def_tve_rec tve_rec_type;
1157: -----------------------------------------
1158: -- Set_Attributes for:OKC_TIMEVALUES_B --
1159: -----------------------------------------
1160: FUNCTION Set_Attributes (
1161: p_tve_rec IN tve_rec_type,
1162: x_tve_rec OUT NOCOPY tve_rec_type

Line 1189: INSERT INTO OKC_TIMEVALUES(

1185: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1186: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_ERROR;
1188: END IF;
1189: INSERT INTO OKC_TIMEVALUES(
1190: id,
1191: spn_id,
1192: tve_id_offset,
1193: uom_code,

Line 1331: -- insert_row for:OKC_TIMEVALUES_TL --

1327: '_PVT'
1328: );
1329: END insert_row;
1330: --------------------------------------
1331: -- insert_row for:OKC_TIMEVALUES_TL --
1332: --------------------------------------
1333: /* PROCEDURE insert_row(
1334: p_init_msg_list IN VARCHAR2,
1335: x_return_status OUT NOCOPY VARCHAR2,

Line 1338: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1334: p_init_msg_list IN VARCHAR2,
1335: x_return_status OUT NOCOPY VARCHAR2,
1336: x_msg_count OUT NOCOPY NUMBER,
1337: x_msg_data OUT NOCOPY VARCHAR2,
1338: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1339: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1340:
1341: l_api_version CONSTANT NUMBER := 1;
1342: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1339: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

1335: x_return_status OUT NOCOPY VARCHAR2,
1336: x_msg_count OUT NOCOPY NUMBER,
1337: x_msg_data OUT NOCOPY VARCHAR2,
1338: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1339: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
1340:
1341: l_api_version CONSTANT NUMBER := 1;
1342: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1343: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1344: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

1340:
1341: l_api_version CONSTANT NUMBER := 1;
1342: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1343: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1344: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1345: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1346: CURSOR get_languages IS
1347: SELECT *
1348: FROM FND_LANGUAGES

Line 1345: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1341: l_api_version CONSTANT NUMBER := 1;
1342: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1343: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1344: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
1345: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1346: CURSOR get_languages IS
1347: SELECT *
1348: FROM FND_LANGUAGES
1349: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1351: -- Set_Attributes for:OKC_TIMEVALUES_TL --

1347: SELECT *
1348: FROM FND_LANGUAGES
1349: WHERE INSTALLED_FLAG IN ('I', 'B');
1350: ------------------------------------------
1351: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1352: ------------------------------------------
1353: FUNCTION Set_Attributes (
1354: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1355: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 1354: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

1350: ------------------------------------------
1351: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1352: ------------------------------------------
1353: FUNCTION Set_Attributes (
1354: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1355: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1356: ) RETURN VARCHAR2 IS
1357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1358: BEGIN

Line 1355: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

1351: -- Set_Attributes for:OKC_TIMEVALUES_TL --
1352: ------------------------------------------
1353: FUNCTION Set_Attributes (
1354: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
1355: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1356: ) RETURN VARCHAR2 IS
1357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1358: BEGIN
1359: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 1359: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

1355: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
1356: ) RETURN VARCHAR2 IS
1357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1358: BEGIN
1359: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1360: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1361: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1362: RETURN(l_return_status);
1363: END Set_Attributes;

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

1356: ) RETURN VARCHAR2 IS
1357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1358: BEGIN
1359: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1360: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1361: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1362: RETURN(l_return_status);
1363: END Set_Attributes;
1364: BEGIN

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

1357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1358: BEGIN
1359: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
1360: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1361: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1362: RETURN(l_return_status);
1363: END Set_Attributes;
1364: BEGIN
1365: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1376: p_okc_timevalues_tl_rec, -- IN

1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;
1374: --- Setting item attributes
1375: l_return_status := Set_Attributes(
1376: p_okc_timevalues_tl_rec, -- IN
1377: l_okc_timevalues_tl_rec); -- OUT
1378: --- If any errors happen abort API
1379: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1380: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1377: l_okc_timevalues_tl_rec); -- OUT

1373: END IF;
1374: --- Setting item attributes
1375: l_return_status := Set_Attributes(
1376: p_okc_timevalues_tl_rec, -- IN
1377: l_okc_timevalues_tl_rec); -- OUT
1378: --- If any errors happen abort API
1379: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1380: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1381: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

1381: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1382: RAISE OKC_API.G_EXCEPTION_ERROR;
1383: END IF;
1384: FOR l_lang_rec IN get_languages LOOP
1385: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1386: INSERT INTO OKC_TIMEVALUES_TL(
1387: id,
1388: language,
1389: source_lang,

Line 1386: INSERT INTO OKC_TIMEVALUES_TL(

1382: RAISE OKC_API.G_EXCEPTION_ERROR;
1383: END IF;
1384: FOR l_lang_rec IN get_languages LOOP
1385: l_okc_timevalues_tl_rec.language := l_lang_rec.language_code;
1386: INSERT INTO OKC_TIMEVALUES_TL(
1387: id,
1388: language,
1389: source_lang,
1390: sfwt_flag,

Line 1401: l_okc_timevalues_tl_rec.id,

1397: last_updated_by,
1398: last_update_date,
1399: last_update_login)
1400: VALUES (
1401: l_okc_timevalues_tl_rec.id,
1402: l_okc_timevalues_tl_rec.language,
1403: l_okc_timevalues_tl_rec.source_lang,
1404: l_okc_timevalues_tl_rec.sfwt_flag,
1405: l_okc_timevalues_tl_rec.description,

Line 1402: l_okc_timevalues_tl_rec.language,

1398: last_update_date,
1399: last_update_login)
1400: VALUES (
1401: l_okc_timevalues_tl_rec.id,
1402: l_okc_timevalues_tl_rec.language,
1403: l_okc_timevalues_tl_rec.source_lang,
1404: l_okc_timevalues_tl_rec.sfwt_flag,
1405: l_okc_timevalues_tl_rec.description,
1406: l_okc_timevalues_tl_rec.short_description,

Line 1403: l_okc_timevalues_tl_rec.source_lang,

1399: last_update_login)
1400: VALUES (
1401: l_okc_timevalues_tl_rec.id,
1402: l_okc_timevalues_tl_rec.language,
1403: l_okc_timevalues_tl_rec.source_lang,
1404: l_okc_timevalues_tl_rec.sfwt_flag,
1405: l_okc_timevalues_tl_rec.description,
1406: l_okc_timevalues_tl_rec.short_description,
1407: l_okc_timevalues_tl_rec.comments,

Line 1404: l_okc_timevalues_tl_rec.sfwt_flag,

1400: VALUES (
1401: l_okc_timevalues_tl_rec.id,
1402: l_okc_timevalues_tl_rec.language,
1403: l_okc_timevalues_tl_rec.source_lang,
1404: l_okc_timevalues_tl_rec.sfwt_flag,
1405: l_okc_timevalues_tl_rec.description,
1406: l_okc_timevalues_tl_rec.short_description,
1407: l_okc_timevalues_tl_rec.comments,
1408: l_okc_timevalues_tl_rec.name,

Line 1405: l_okc_timevalues_tl_rec.description,

1401: l_okc_timevalues_tl_rec.id,
1402: l_okc_timevalues_tl_rec.language,
1403: l_okc_timevalues_tl_rec.source_lang,
1404: l_okc_timevalues_tl_rec.sfwt_flag,
1405: l_okc_timevalues_tl_rec.description,
1406: l_okc_timevalues_tl_rec.short_description,
1407: l_okc_timevalues_tl_rec.comments,
1408: l_okc_timevalues_tl_rec.name,
1409: l_okc_timevalues_tl_rec.created_by,

Line 1406: l_okc_timevalues_tl_rec.short_description,

1402: l_okc_timevalues_tl_rec.language,
1403: l_okc_timevalues_tl_rec.source_lang,
1404: l_okc_timevalues_tl_rec.sfwt_flag,
1405: l_okc_timevalues_tl_rec.description,
1406: l_okc_timevalues_tl_rec.short_description,
1407: l_okc_timevalues_tl_rec.comments,
1408: l_okc_timevalues_tl_rec.name,
1409: l_okc_timevalues_tl_rec.created_by,
1410: l_okc_timevalues_tl_rec.creation_date,

Line 1407: l_okc_timevalues_tl_rec.comments,

1403: l_okc_timevalues_tl_rec.source_lang,
1404: l_okc_timevalues_tl_rec.sfwt_flag,
1405: l_okc_timevalues_tl_rec.description,
1406: l_okc_timevalues_tl_rec.short_description,
1407: l_okc_timevalues_tl_rec.comments,
1408: l_okc_timevalues_tl_rec.name,
1409: l_okc_timevalues_tl_rec.created_by,
1410: l_okc_timevalues_tl_rec.creation_date,
1411: l_okc_timevalues_tl_rec.last_updated_by,

Line 1408: l_okc_timevalues_tl_rec.name,

1404: l_okc_timevalues_tl_rec.sfwt_flag,
1405: l_okc_timevalues_tl_rec.description,
1406: l_okc_timevalues_tl_rec.short_description,
1407: l_okc_timevalues_tl_rec.comments,
1408: l_okc_timevalues_tl_rec.name,
1409: l_okc_timevalues_tl_rec.created_by,
1410: l_okc_timevalues_tl_rec.creation_date,
1411: l_okc_timevalues_tl_rec.last_updated_by,
1412: l_okc_timevalues_tl_rec.last_update_date,

Line 1409: l_okc_timevalues_tl_rec.created_by,

1405: l_okc_timevalues_tl_rec.description,
1406: l_okc_timevalues_tl_rec.short_description,
1407: l_okc_timevalues_tl_rec.comments,
1408: l_okc_timevalues_tl_rec.name,
1409: l_okc_timevalues_tl_rec.created_by,
1410: l_okc_timevalues_tl_rec.creation_date,
1411: l_okc_timevalues_tl_rec.last_updated_by,
1412: l_okc_timevalues_tl_rec.last_update_date,
1413: l_okc_timevalues_tl_rec.last_update_login);

Line 1410: l_okc_timevalues_tl_rec.creation_date,

1406: l_okc_timevalues_tl_rec.short_description,
1407: l_okc_timevalues_tl_rec.comments,
1408: l_okc_timevalues_tl_rec.name,
1409: l_okc_timevalues_tl_rec.created_by,
1410: l_okc_timevalues_tl_rec.creation_date,
1411: l_okc_timevalues_tl_rec.last_updated_by,
1412: l_okc_timevalues_tl_rec.last_update_date,
1413: l_okc_timevalues_tl_rec.last_update_login);
1414: END LOOP;

Line 1411: l_okc_timevalues_tl_rec.last_updated_by,

1407: l_okc_timevalues_tl_rec.comments,
1408: l_okc_timevalues_tl_rec.name,
1409: l_okc_timevalues_tl_rec.created_by,
1410: l_okc_timevalues_tl_rec.creation_date,
1411: l_okc_timevalues_tl_rec.last_updated_by,
1412: l_okc_timevalues_tl_rec.last_update_date,
1413: l_okc_timevalues_tl_rec.last_update_login);
1414: END LOOP;
1415: -- Set OUT values

Line 1412: l_okc_timevalues_tl_rec.last_update_date,

1408: l_okc_timevalues_tl_rec.name,
1409: l_okc_timevalues_tl_rec.created_by,
1410: l_okc_timevalues_tl_rec.creation_date,
1411: l_okc_timevalues_tl_rec.last_updated_by,
1412: l_okc_timevalues_tl_rec.last_update_date,
1413: l_okc_timevalues_tl_rec.last_update_login);
1414: END LOOP;
1415: -- Set OUT values
1416: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

Line 1413: l_okc_timevalues_tl_rec.last_update_login);

1409: l_okc_timevalues_tl_rec.created_by,
1410: l_okc_timevalues_tl_rec.creation_date,
1411: l_okc_timevalues_tl_rec.last_updated_by,
1412: l_okc_timevalues_tl_rec.last_update_date,
1413: l_okc_timevalues_tl_rec.last_update_login);
1414: END LOOP;
1415: -- Set OUT values
1416: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1417: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1416: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;

1412: l_okc_timevalues_tl_rec.last_update_date,
1413: l_okc_timevalues_tl_rec.last_update_login);
1414: END LOOP;
1415: -- Set OUT values
1416: x_okc_timevalues_tl_rec := l_okc_timevalues_tl_rec;
1417: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1418: EXCEPTION
1419: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1420: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1470: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1466: l_tgnv_rec tgnv_rec_type;
1467: l_def_tgnv_rec tgnv_rec_type;
1468: l_tve_rec tve_rec_type;
1469: lx_tve_rec tve_rec_type;
1470: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1471: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1472: -------------------------------
1473: -- FUNCTION fill_who_columns --
1474: -------------------------------

Line 1471: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1467: l_def_tgnv_rec tgnv_rec_type;
1468: l_tve_rec tve_rec_type;
1469: lx_tve_rec tve_rec_type;
1470: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1471: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1472: -------------------------------
1473: -- FUNCTION fill_who_columns --
1474: -------------------------------
1475: FUNCTION fill_who_columns (

Line 1546: --Bug 3122962 migrate(l_def_tgnv_rec, l_okc_timevalues_tl_rec);

1542: --------------------------------------
1543: -- Move VIEW record to "Child" records
1544: --------------------------------------
1545: migrate(l_def_tgnv_rec, l_tve_rec);
1546: --Bug 3122962 migrate(l_def_tgnv_rec, l_okc_timevalues_tl_rec);
1547: --------------------------------------------
1548: -- Call the INSERT_ROW for each child record
1549: --------------------------------------------
1550: insert_row(

Line 1569: l_okc_timevalues_tl_rec,

1565: p_init_msg_list,
1566: x_return_status,
1567: x_msg_count,
1568: x_msg_data,
1569: l_okc_timevalues_tl_rec,
1570: lx_okc_timevalues_tl_rec
1571: );
1572: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1570: lx_okc_timevalues_tl_rec

1566: x_return_status,
1567: x_msg_count,
1568: x_msg_data,
1569: l_okc_timevalues_tl_rec,
1570: lx_okc_timevalues_tl_rec
1571: );
1572: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1574: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1577: migrate(lx_okc_timevalues_tl_rec, l_def_tgnv_rec);

1573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1574: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1575: RAISE OKC_API.G_EXCEPTION_ERROR;
1576: END IF;
1577: migrate(lx_okc_timevalues_tl_rec, l_def_tgnv_rec);
1578: */
1579: -- Set OUT values
1580: x_tgnv_rec := l_def_tgnv_rec;
1581: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1684: -- lock_row for:OKC_TIMEVALUES_B --

1680: ---------------------------------------------------------------------------
1681: -- PROCEDURE lock_row
1682: ---------------------------------------------------------------------------
1683: -----------------------------------
1684: -- lock_row for:OKC_TIMEVALUES_B --
1685: -----------------------------------
1686: PROCEDURE lock_row(
1687: p_init_msg_list IN VARCHAR2,
1688: x_return_status OUT NOCOPY VARCHAR2,

Line 1697: FROM OKC_TIMEVALUES

1693: E_Resource_Busy EXCEPTION;
1694: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1695: CURSOR lock_csr (p_tve_rec IN tve_rec_type) IS
1696: SELECT OBJECT_VERSION_NUMBER
1697: FROM OKC_TIMEVALUES
1698: WHERE ID = p_tve_rec.id
1699: AND OBJECT_VERSION_NUMBER = p_tve_rec.object_version_number
1700: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1701:

Line 1704: FROM OKC_TIMEVALUES

1700: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1701:
1702: CURSOR lchk_csr (p_tve_rec IN tve_rec_type) IS
1703: SELECT OBJECT_VERSION_NUMBER
1704: FROM OKC_TIMEVALUES
1705: WHERE ID = p_tve_rec.id;
1706: l_api_version CONSTANT NUMBER := 1;
1707: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1708: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1709: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1705: WHERE ID = p_tve_rec.id;
1706: l_api_version CONSTANT NUMBER := 1;
1707: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1708: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1709: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1710: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1711: l_row_notfound BOOLEAN := FALSE;
1712: lc_row_notfound BOOLEAN := FALSE;
1713: BEGIN

Line 1710: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

1706: l_api_version CONSTANT NUMBER := 1;
1707: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1708: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1709: l_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1710: lc_object_version_number OKC_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
1711: l_row_notfound BOOLEAN := FALSE;
1712: lc_row_notfound BOOLEAN := FALSE;
1713: BEGIN
1714: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1790: -- lock_row for:OKC_TIMEVALUES_TL --

1786: '_PVT'
1787: );
1788: END lock_row;
1789: ------------------------------------
1790: -- lock_row for:OKC_TIMEVALUES_TL --
1791: ------------------------------------
1792: /* PROCEDURE lock_row(
1793: p_init_msg_list IN VARCHAR2,
1794: x_return_status OUT NOCOPY VARCHAR2,

Line 1797: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

1793: p_init_msg_list IN VARCHAR2,
1794: x_return_status OUT NOCOPY VARCHAR2,
1795: x_msg_count OUT NOCOPY NUMBER,
1796: x_msg_data OUT NOCOPY VARCHAR2,
1797: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1798:
1799: E_Resource_Busy EXCEPTION;
1800: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1801: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

Line 1801: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

1797: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1798:
1799: E_Resource_Busy EXCEPTION;
1800: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1801: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1802: SELECT id
1803: FROM OKC_TIMEVALUES_TL
1804: WHERE ID = p_okc_timevalues_tl_rec.id
1805: FOR UPDATE NOWAIT;

Line 1803: FROM OKC_TIMEVALUES_TL

1799: E_Resource_Busy EXCEPTION;
1800: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1801: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1802: SELECT id
1803: FROM OKC_TIMEVALUES_TL
1804: WHERE ID = p_okc_timevalues_tl_rec.id
1805: FOR UPDATE NOWAIT;
1806:
1807: l_api_version CONSTANT NUMBER := 1;

Line 1804: WHERE ID = p_okc_timevalues_tl_rec.id

1800: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1801: CURSOR lock_csr (p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
1802: SELECT id
1803: FROM OKC_TIMEVALUES_TL
1804: WHERE ID = p_okc_timevalues_tl_rec.id
1805: FOR UPDATE NOWAIT;
1806:
1807: l_api_version CONSTANT NUMBER := 1;
1808: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1824: OPEN lock_csr(p_okc_timevalues_tl_rec);

1820: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1821: RAISE OKC_API.G_EXCEPTION_ERROR;
1822: END IF;
1823: BEGIN
1824: OPEN lock_csr(p_okc_timevalues_tl_rec);
1825: FETCH lock_csr INTO l_lock_var;
1826: l_row_notfound := lock_csr%NOTFOUND;
1827: CLOSE lock_csr;
1828: EXCEPTION

Line 1890: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

1886: l_api_version CONSTANT NUMBER := 1;
1887: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1888: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1889: l_tve_rec tve_rec_type;
1890: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
1891: BEGIN
1892: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1893: G_PKG_NAME,
1894: p_init_msg_list,

Line 1908: --Bug 3122962 migrate(p_tgnv_rec, l_okc_timevalues_tl_rec);

1904: --------------------------------------
1905: -- Move VIEW record to "Child" records
1906: --------------------------------------
1907: migrate(p_tgnv_rec, l_tve_rec);
1908: --Bug 3122962 migrate(p_tgnv_rec, l_okc_timevalues_tl_rec);
1909: --------------------------------------------
1910: -- Call the LOCK_ROW for each child record
1911: --------------------------------------------
1912: lock_row(

Line 1929: l_okc_timevalues_tl_rec

1925: p_init_msg_list,
1926: x_return_status,
1927: x_msg_count,
1928: x_msg_data,
1929: l_okc_timevalues_tl_rec
1930: );
1931: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1933: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2038: -- update_row for:OKC_TIMEVALUES_B --

2034: ---------------------------------------------------------------------------
2035: -- PROCEDURE update_row
2036: ---------------------------------------------------------------------------
2037: -------------------------------------
2038: -- update_row for:OKC_TIMEVALUES_B --
2039: -------------------------------------
2040: PROCEDURE update_row(
2041: p_init_msg_list IN VARCHAR2,
2042: x_return_status OUT NOCOPY VARCHAR2,

Line 2276: -- Set_Attributes for:OKC_TIMEVALUES_B --

2272:
2273: RETURN(l_return_status);
2274: END populate_new_record;
2275: -----------------------------------------
2276: -- Set_Attributes for:OKC_TIMEVALUES_B --
2277: -----------------------------------------
2278: FUNCTION Set_Attributes (
2279: p_tve_rec IN tve_rec_type,
2280: x_tve_rec OUT NOCOPY tve_rec_type

Line 2313: UPDATE OKC_TIMEVALUES

2309: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2310: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2311: RAISE OKC_API.G_EXCEPTION_ERROR;
2312: END IF;
2313: UPDATE OKC_TIMEVALUES
2314: SET SPN_ID = l_def_tve_rec.spn_id,
2315: TVE_ID_OFFSET = l_def_tve_rec.tve_id_offset,
2316: uom_code = l_def_tve_rec.uom_code,
2317: CNH_ID = l_def_tve_rec.cnh_id,

Line 2401: -- update_row for:OKC_TIMEVALUES_TL --

2397: '_PVT'
2398: );
2399: END update_row;
2400: --------------------------------------
2401: -- update_row for:OKC_TIMEVALUES_TL --
2402: --------------------------------------
2403: /*
2404: PROCEDURE update_row(
2405: p_init_msg_list IN VARCHAR2,

Line 2409: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2405: p_init_msg_list IN VARCHAR2,
2406: x_return_status OUT NOCOPY VARCHAR2,
2407: x_msg_count OUT NOCOPY NUMBER,
2408: x_msg_data OUT NOCOPY VARCHAR2,
2409: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2410: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2411:
2412: l_api_version CONSTANT NUMBER := 1;
2413: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2410: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS

2406: x_return_status OUT NOCOPY VARCHAR2,
2407: x_msg_count OUT NOCOPY NUMBER,
2408: x_msg_data OUT NOCOPY VARCHAR2,
2409: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2410: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type) IS
2411:
2412: l_api_version CONSTANT NUMBER := 1;
2413: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2414: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2415: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;

2411:
2412: l_api_version CONSTANT NUMBER := 1;
2413: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2414: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2415: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2416: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2417: l_row_notfound BOOLEAN := TRUE;
2418: ----------------------------------
2419: -- FUNCTION populate_new_record --

Line 2416: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2412: l_api_version CONSTANT NUMBER := 1;
2413: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2414: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2415: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type := p_okc_timevalues_tl_rec;
2416: l_def_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2417: l_row_notfound BOOLEAN := TRUE;
2418: ----------------------------------
2419: -- FUNCTION populate_new_record --
2420: ----------------------------------

Line 2422: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2418: ----------------------------------
2419: -- FUNCTION populate_new_record --
2420: ----------------------------------
2421: FUNCTION populate_new_record (
2422: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2423: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2424: ) RETURN VARCHAR2 IS
2425: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2426: l_row_notfound BOOLEAN := TRUE;

Line 2423: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2419: -- FUNCTION populate_new_record --
2420: ----------------------------------
2421: FUNCTION populate_new_record (
2422: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2423: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2424: ) RETURN VARCHAR2 IS
2425: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2426: l_row_notfound BOOLEAN := TRUE;
2427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2425: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2421: FUNCTION populate_new_record (
2422: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2423: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2424: ) RETURN VARCHAR2 IS
2425: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2426: l_row_notfound BOOLEAN := TRUE;
2427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2428: BEGIN
2429: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2429: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2425: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2426: l_row_notfound BOOLEAN := TRUE;
2427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2428: BEGIN
2429: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2430: -- Get current database values
2431: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2432: IF (l_row_notfound) THEN
2433: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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

2427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2428: BEGIN
2429: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2430: -- Get current database values
2431: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2432: IF (l_row_notfound) THEN
2433: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2434: END IF;
2435: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)

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

2431: l_okc_timevalues_tl_rec := get_rec(p_okc_timevalues_tl_rec, l_row_notfound);
2432: IF (l_row_notfound) THEN
2433: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2434: END IF;
2435: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2436: THEN
2437: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2438: END IF;
2439: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)

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

2433: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2434: END IF;
2435: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2436: THEN
2437: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2438: END IF;
2439: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2440: THEN
2441: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;

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

2435: IF (x_okc_timevalues_tl_rec.id = OKC_API.G_MISS_NUM)
2436: THEN
2437: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2438: END IF;
2439: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2440: THEN
2441: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2442: END IF;
2443: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

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

2437: x_okc_timevalues_tl_rec.id := l_okc_timevalues_tl_rec.id;
2438: END IF;
2439: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2440: THEN
2441: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2442: END IF;
2443: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2444: THEN
2445: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;

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

2439: IF (x_okc_timevalues_tl_rec.language = OKC_API.G_MISS_CHAR)
2440: THEN
2441: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2442: END IF;
2443: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2444: THEN
2445: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2446: END IF;
2447: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

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

2441: x_okc_timevalues_tl_rec.language := l_okc_timevalues_tl_rec.language;
2442: END IF;
2443: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2444: THEN
2445: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2446: END IF;
2447: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2448: THEN
2449: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;

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

2443: IF (x_okc_timevalues_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2444: THEN
2445: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2446: END IF;
2447: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2448: THEN
2449: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2450: END IF;
2451: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)

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

2445: x_okc_timevalues_tl_rec.source_lang := l_okc_timevalues_tl_rec.source_lang;
2446: END IF;
2447: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2448: THEN
2449: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2450: END IF;
2451: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2452: THEN
2453: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;

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

2447: IF (x_okc_timevalues_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2448: THEN
2449: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2450: END IF;
2451: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2452: THEN
2453: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2454: END IF;
2455: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)

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

2449: x_okc_timevalues_tl_rec.sfwt_flag := l_okc_timevalues_tl_rec.sfwt_flag;
2450: END IF;
2451: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2452: THEN
2453: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2454: END IF;
2455: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2456: THEN
2457: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;

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

2451: IF (x_okc_timevalues_tl_rec.description = OKC_API.G_MISS_CHAR)
2452: THEN
2453: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2454: END IF;
2455: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2456: THEN
2457: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2458: END IF;
2459: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)

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

2453: x_okc_timevalues_tl_rec.description := l_okc_timevalues_tl_rec.description;
2454: END IF;
2455: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2456: THEN
2457: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2458: END IF;
2459: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2460: THEN
2461: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;

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

2455: IF (x_okc_timevalues_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2456: THEN
2457: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2458: END IF;
2459: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2460: THEN
2461: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2462: END IF;
2463: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)

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

2457: x_okc_timevalues_tl_rec.short_description := l_okc_timevalues_tl_rec.short_description;
2458: END IF;
2459: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2460: THEN
2461: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2462: END IF;
2463: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2464: THEN
2465: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;

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

2459: IF (x_okc_timevalues_tl_rec.comments = OKC_API.G_MISS_CHAR)
2460: THEN
2461: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2462: END IF;
2463: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2464: THEN
2465: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2466: END IF;
2467: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)

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

2461: x_okc_timevalues_tl_rec.comments := l_okc_timevalues_tl_rec.comments;
2462: END IF;
2463: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2464: THEN
2465: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2466: END IF;
2467: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2468: THEN
2469: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;

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

2463: IF (x_okc_timevalues_tl_rec.name = OKC_API.G_MISS_CHAR)
2464: THEN
2465: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2466: END IF;
2467: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2468: THEN
2469: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2470: END IF;
2471: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)

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

2465: x_okc_timevalues_tl_rec.name := l_okc_timevalues_tl_rec.name;
2466: END IF;
2467: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2468: THEN
2469: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2470: END IF;
2471: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2472: THEN
2473: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;

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

2467: IF (x_okc_timevalues_tl_rec.created_by = OKC_API.G_MISS_NUM)
2468: THEN
2469: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2470: END IF;
2471: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2472: THEN
2473: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2474: END IF;
2475: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

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

2469: x_okc_timevalues_tl_rec.created_by := l_okc_timevalues_tl_rec.created_by;
2470: END IF;
2471: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2472: THEN
2473: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2474: END IF;
2475: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2476: THEN
2477: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;

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

2471: IF (x_okc_timevalues_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2472: THEN
2473: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2474: END IF;
2475: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2476: THEN
2477: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2478: END IF;
2479: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

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

2473: x_okc_timevalues_tl_rec.creation_date := l_okc_timevalues_tl_rec.creation_date;
2474: END IF;
2475: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2476: THEN
2477: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2478: END IF;
2479: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2480: THEN
2481: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;

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

2475: IF (x_okc_timevalues_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2476: THEN
2477: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2478: END IF;
2479: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2480: THEN
2481: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2482: END IF;
2483: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

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

2477: x_okc_timevalues_tl_rec.last_updated_by := l_okc_timevalues_tl_rec.last_updated_by;
2478: END IF;
2479: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2480: THEN
2481: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2482: END IF;
2483: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2484: THEN
2485: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;

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

2479: IF (x_okc_timevalues_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2480: THEN
2481: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2482: END IF;
2483: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2484: THEN
2485: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2486: END IF;
2487: RETURN(l_return_status);

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

2481: x_okc_timevalues_tl_rec.last_update_date := l_okc_timevalues_tl_rec.last_update_date;
2482: END IF;
2483: IF (x_okc_timevalues_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2484: THEN
2485: x_okc_timevalues_tl_rec.last_update_login := l_okc_timevalues_tl_rec.last_update_login;
2486: END IF;
2487: RETURN(l_return_status);
2488: END populate_new_record;
2489: ------------------------------------------

Line 2490: -- Set_Attributes for:OKC_TIMEVALUES_TL --

2486: END IF;
2487: RETURN(l_return_status);
2488: END populate_new_record;
2489: ------------------------------------------
2490: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2491: ------------------------------------------
2492: FUNCTION Set_Attributes (
2493: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2494: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 2493: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

2489: ------------------------------------------
2490: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2491: ------------------------------------------
2492: FUNCTION Set_Attributes (
2493: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2494: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2495: ) RETURN VARCHAR2 IS
2496: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2497: BEGIN

Line 2494: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

2490: -- Set_Attributes for:OKC_TIMEVALUES_TL --
2491: ------------------------------------------
2492: FUNCTION Set_Attributes (
2493: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
2494: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2495: ) RETURN VARCHAR2 IS
2496: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2497: BEGIN
2498: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 2498: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

2494: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
2495: ) RETURN VARCHAR2 IS
2496: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2497: BEGIN
2498: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2499: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2500: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2501: RETURN(l_return_status);
2502: END Set_Attributes;

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

2495: ) RETURN VARCHAR2 IS
2496: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2497: BEGIN
2498: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2499: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2500: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2501: RETURN(l_return_status);
2502: END Set_Attributes;
2503: BEGIN

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

2496: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2497: BEGIN
2498: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
2499: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2500: x_okc_timevalues_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2501: RETURN(l_return_status);
2502: END Set_Attributes;
2503: BEGIN
2504: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2515: p_okc_timevalues_tl_rec, -- IN

2511: RAISE OKC_API.G_EXCEPTION_ERROR;
2512: END IF;
2513: --- Setting item attributes
2514: l_return_status := Set_Attributes(
2515: p_okc_timevalues_tl_rec, -- IN
2516: l_okc_timevalues_tl_rec); -- OUT
2517: --- If any errors happen abort API
2518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2516: l_okc_timevalues_tl_rec); -- OUT

2512: END IF;
2513: --- Setting item attributes
2514: l_return_status := Set_Attributes(
2515: p_okc_timevalues_tl_rec, -- IN
2516: l_okc_timevalues_tl_rec); -- OUT
2517: --- If any errors happen abort API
2518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

2519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2521: RAISE OKC_API.G_EXCEPTION_ERROR;
2522: END IF;
2523: l_return_status := populate_new_record(l_okc_timevalues_tl_rec, l_def_okc_timevalues_tl_rec);
2524: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2525: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2526: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2527: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2529: UPDATE OKC_TIMEVALUES_TL

2525: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2526: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2527: RAISE OKC_API.G_EXCEPTION_ERROR;
2528: END IF;
2529: UPDATE OKC_TIMEVALUES_TL
2530: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2531: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2532: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2533: NAME = l_def_okc_timevalues_tl_rec.name,

Line 2530: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,

2526: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2527: RAISE OKC_API.G_EXCEPTION_ERROR;
2528: END IF;
2529: UPDATE OKC_TIMEVALUES_TL
2530: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2531: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2532: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2533: NAME = l_def_okc_timevalues_tl_rec.name,
2534: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

Line 2531: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,

2527: RAISE OKC_API.G_EXCEPTION_ERROR;
2528: END IF;
2529: UPDATE OKC_TIMEVALUES_TL
2530: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2531: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2532: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2533: NAME = l_def_okc_timevalues_tl_rec.name,
2534: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2535: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

Line 2532: COMMENTS = l_def_okc_timevalues_tl_rec.comments,

2528: END IF;
2529: UPDATE OKC_TIMEVALUES_TL
2530: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2531: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2532: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2533: NAME = l_def_okc_timevalues_tl_rec.name,
2534: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2535: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2536: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

Line 2533: NAME = l_def_okc_timevalues_tl_rec.name,

2529: UPDATE OKC_TIMEVALUES_TL
2530: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2531: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2532: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2533: NAME = l_def_okc_timevalues_tl_rec.name,
2534: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2535: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2536: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2537: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

Line 2534: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,

2530: SET DESCRIPTION = l_def_okc_timevalues_tl_rec.description,
2531: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2532: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2533: NAME = l_def_okc_timevalues_tl_rec.name,
2534: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2535: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2536: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2537: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2538: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

Line 2535: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,

2531: SHORT_DESCRIPTION = l_def_okc_timevalues_tl_rec.short_description,
2532: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2533: NAME = l_def_okc_timevalues_tl_rec.name,
2534: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2535: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2536: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2537: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2538: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2539: WHERE ID = l_def_okc_timevalues_tl_rec.id

Line 2536: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,

2532: COMMENTS = l_def_okc_timevalues_tl_rec.comments,
2533: NAME = l_def_okc_timevalues_tl_rec.name,
2534: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2535: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2536: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2537: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2538: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2539: WHERE ID = l_def_okc_timevalues_tl_rec.id
2540: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);

Line 2537: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,

2533: NAME = l_def_okc_timevalues_tl_rec.name,
2534: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2535: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2536: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2537: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2538: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2539: WHERE ID = l_def_okc_timevalues_tl_rec.id
2540: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2541:

Line 2538: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login

2534: CREATED_BY = l_def_okc_timevalues_tl_rec.created_by,
2535: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2536: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2537: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2538: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2539: WHERE ID = l_def_okc_timevalues_tl_rec.id
2540: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2541:
2542: UPDATE OKC_TIMEVALUES_TL

Line 2539: WHERE ID = l_def_okc_timevalues_tl_rec.id

2535: CREATION_DATE = l_def_okc_timevalues_tl_rec.creation_date,
2536: LAST_UPDATED_BY = l_def_okc_timevalues_tl_rec.last_updated_by,
2537: LAST_UPDATE_DATE = l_def_okc_timevalues_tl_rec.last_update_date,
2538: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2539: WHERE ID = l_def_okc_timevalues_tl_rec.id
2540: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2541:
2542: UPDATE OKC_TIMEVALUES_TL
2543: SET SFWT_FLAG = 'Y'

Line 2542: UPDATE OKC_TIMEVALUES_TL

2538: LAST_UPDATE_LOGIN = l_def_okc_timevalues_tl_rec.last_update_login
2539: WHERE ID = l_def_okc_timevalues_tl_rec.id
2540: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2541:
2542: UPDATE OKC_TIMEVALUES_TL
2543: SET SFWT_FLAG = 'Y'
2544: WHERE ID = l_def_okc_timevalues_tl_rec.id
2545: AND SOURCE_LANG <> USERENV('LANG');
2546:

Line 2544: WHERE ID = l_def_okc_timevalues_tl_rec.id

2540: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
2541:
2542: UPDATE OKC_TIMEVALUES_TL
2543: SET SFWT_FLAG = 'Y'
2544: WHERE ID = l_def_okc_timevalues_tl_rec.id
2545: AND SOURCE_LANG <> USERENV('LANG');
2546:
2547: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2548: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2547: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;

2543: SET SFWT_FLAG = 'Y'
2544: WHERE ID = l_def_okc_timevalues_tl_rec.id
2545: AND SOURCE_LANG <> USERENV('LANG');
2546:
2547: x_okc_timevalues_tl_rec := l_def_okc_timevalues_tl_rec;
2548: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2549: EXCEPTION
2550: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2551: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2599: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2595: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2596: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2597: l_tgnv_rec tgnv_rec_type := p_tgnv_rec;
2598: l_def_tgnv_rec tgnv_rec_type;
2599: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2600: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2601: l_tve_rec tve_rec_type;
2602: lx_tve_rec tve_rec_type;
2603: -------------------------------

Line 2600: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

2596: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2597: l_tgnv_rec tgnv_rec_type := p_tgnv_rec;
2598: l_def_tgnv_rec tgnv_rec_type;
2599: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2600: --Bug 3122962 lx_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
2601: l_tve_rec tve_rec_type;
2602: lx_tve_rec tve_rec_type;
2603: -------------------------------
2604: -- FUNCTION fill_who_columns --

Line 2824: --Bug 3122962 migrate(l_def_tgnv_rec, l_okc_timevalues_tl_rec);

2820:
2821: --------------------------------------
2822: -- Move VIEW record to "Child" records
2823: --------------------------------------
2824: --Bug 3122962 migrate(l_def_tgnv_rec, l_okc_timevalues_tl_rec);
2825: migrate(l_def_tgnv_rec, l_tve_rec);
2826: --------------------------------------------
2827: -- Call the UPDATE_ROW for each child record
2828: --------------------------------------------

Line 2834: l_okc_timevalues_tl_rec,

2830: p_init_msg_list,
2831: x_return_status,
2832: x_msg_count,
2833: x_msg_data,
2834: l_okc_timevalues_tl_rec,
2835: lx_okc_timevalues_tl_rec
2836: );
2837: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2835: lx_okc_timevalues_tl_rec

2831: x_return_status,
2832: x_msg_count,
2833: x_msg_data,
2834: l_okc_timevalues_tl_rec,
2835: lx_okc_timevalues_tl_rec
2836: );
2837: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2839: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2842: migrate(lx_okc_timevalues_tl_rec, l_def_tgnv_rec);

2838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2839: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2840: RAISE OKC_API.G_EXCEPTION_ERROR;
2841: END IF;
2842: migrate(lx_okc_timevalues_tl_rec, l_def_tgnv_rec);
2843: */
2844: update_row(
2845: p_init_msg_list,
2846: x_return_status,

Line 2962: -- delete_row for:OKC_TIMEVALUES_B --

2958: ---------------------------------------------------------------------------
2959: -- PROCEDURE delete_row
2960: ---------------------------------------------------------------------------
2961: -------------------------------------
2962: -- delete_row for:OKC_TIMEVALUES_B --
2963: -------------------------------------
2964: PROCEDURE delete_row(
2965: p_init_msg_list IN VARCHAR2,
2966: x_return_status OUT NOCOPY VARCHAR2,

Line 2986: DELETE FROM OKC_TIMEVALUES

2982: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2983: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2984: RAISE OKC_API.G_EXCEPTION_ERROR;
2985: END IF;
2986: DELETE FROM OKC_TIMEVALUES
2987: WHERE ID = l_tve_rec.id;
2988:
2989: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2990: EXCEPTION

Line 3023: -- delete_row for:OKC_TIMEVALUES_TL --

3019: '_PVT'
3020: );
3021: END delete_row;
3022: --------------------------------------
3023: -- delete_row for:OKC_TIMEVALUES_TL --
3024: --------------------------------------
3025: /* PROCEDURE delete_row(
3026: p_init_msg_list IN VARCHAR2,
3027: x_return_status OUT NOCOPY VARCHAR2,

Line 3030: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS

3026: p_init_msg_list IN VARCHAR2,
3027: x_return_status OUT NOCOPY VARCHAR2,
3028: x_msg_count OUT NOCOPY NUMBER,
3029: x_msg_data OUT NOCOPY VARCHAR2,
3030: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type) IS
3031:
3032: l_api_version CONSTANT NUMBER := 1;
3033: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3034: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3035: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;

3031:
3032: l_api_version CONSTANT NUMBER := 1;
3033: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3034: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3035: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3036: l_row_notfound BOOLEAN := TRUE;
3037: ------------------------------------------
3038: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3039: ------------------------------------------

Line 3038: -- Set_Attributes for:OKC_TIMEVALUES_TL --

3034: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3035: l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type:= p_okc_timevalues_tl_rec;
3036: l_row_notfound BOOLEAN := TRUE;
3037: ------------------------------------------
3038: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3039: ------------------------------------------
3040: FUNCTION Set_Attributes (
3041: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3042: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

Line 3041: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,

3037: ------------------------------------------
3038: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3039: ------------------------------------------
3040: FUNCTION Set_Attributes (
3041: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3042: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3043: ) RETURN VARCHAR2 IS
3044: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3045: BEGIN

Line 3042: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type

3038: -- Set_Attributes for:OKC_TIMEVALUES_TL --
3039: ------------------------------------------
3040: FUNCTION Set_Attributes (
3041: p_okc_timevalues_tl_rec IN okc_timevalues_tl_rec_type,
3042: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3043: ) RETURN VARCHAR2 IS
3044: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3045: BEGIN
3046: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

Line 3046: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;

3042: x_okc_timevalues_tl_rec OUT NOCOPY okc_timevalues_tl_rec_type
3043: ) RETURN VARCHAR2 IS
3044: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3045: BEGIN
3046: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3047: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3048: RETURN(l_return_status);
3049: END Set_Attributes;
3050: BEGIN

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

3043: ) RETURN VARCHAR2 IS
3044: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3045: BEGIN
3046: x_okc_timevalues_tl_rec := p_okc_timevalues_tl_rec;
3047: x_okc_timevalues_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3048: RETURN(l_return_status);
3049: END Set_Attributes;
3050: BEGIN
3051: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3062: p_okc_timevalues_tl_rec, -- IN

3058: RAISE OKC_API.G_EXCEPTION_ERROR;
3059: END IF;
3060: --- Setting item attributes
3061: l_return_status := Set_Attributes(
3062: p_okc_timevalues_tl_rec, -- IN
3063: l_okc_timevalues_tl_rec); -- OUT
3064: --- If any errors happen abort API
3065: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3066: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3063: l_okc_timevalues_tl_rec); -- OUT

3059: END IF;
3060: --- Setting item attributes
3061: l_return_status := Set_Attributes(
3062: p_okc_timevalues_tl_rec, -- IN
3063: l_okc_timevalues_tl_rec); -- OUT
3064: --- If any errors happen abort API
3065: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3066: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3067: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3070: DELETE FROM OKC_TIMEVALUES_TL

3066: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3067: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3068: RAISE OKC_API.G_EXCEPTION_ERROR;
3069: END IF;
3070: DELETE FROM OKC_TIMEVALUES_TL
3071: WHERE ID = l_okc_timevalues_tl_rec.id;
3072:
3073: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3074: EXCEPTION

Line 3071: WHERE ID = l_okc_timevalues_tl_rec.id;

3067: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3068: RAISE OKC_API.G_EXCEPTION_ERROR;
3069: END IF;
3070: DELETE FROM OKC_TIMEVALUES_TL
3071: WHERE ID = l_okc_timevalues_tl_rec.id;
3072:
3073: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3074: EXCEPTION
3075: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3122: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

3118: l_api_version CONSTANT NUMBER := 1;
3119: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3120: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3121: l_tgnv_rec tgnv_rec_type := p_tgnv_rec;
3122: --Bug 3122962 l_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
3123: l_tve_rec tve_rec_type;
3124: BEGIN
3125: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3126: G_PKG_NAME,

Line 3140: --Bug 3122962 migrate(l_tgnv_rec, l_okc_timevalues_tl_rec);

3136: END IF;
3137: --------------------------------------
3138: -- Move VIEW record to "Child" records
3139: --------------------------------------
3140: --Bug 3122962 migrate(l_tgnv_rec, l_okc_timevalues_tl_rec);
3141: migrate(l_tgnv_rec, l_tve_rec);
3142: --------------------------------------------
3143: -- Call the DELETE_ROW for each child record
3144: --------------------------------------------

Line 3151: l_okc_timevalues_tl_rec

3147: p_init_msg_list,
3148: x_return_status,
3149: x_msg_count,
3150: x_msg_data,
3151: l_okc_timevalues_tl_rec
3152: );
3153: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3155: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN