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_CRT_PVT dependencies on OKC_CHANGE_REQUESTS_TL

Line 54: DELETE FROM OKC_CHANGE_REQUESTS_TL T

50: /* as a quick workaround to fix the time-consuming table handler issue */
51: /* Eventually we'll need to turn them into a separate fix_language procedure */
52: /* Refer Bugs 4210278, 3723612, 5264746
53:
54: DELETE FROM OKC_CHANGE_REQUESTS_TL T
55: WHERE NOT EXISTS (
56: SELECT NULL
57: FROM OKC_CHANGE_REQUESTS_B B
58: WHERE B.ID = T.ID

Line 61: UPDATE OKC_CHANGE_REQUESTS_TL T SET (

57: FROM OKC_CHANGE_REQUESTS_B B
58: WHERE B.ID = T.ID
59: );
60:
61: UPDATE OKC_CHANGE_REQUESTS_TL T SET (
62: NAME,
63: SHORT_DESCRIPTION) = (SELECT
64: B.NAME,
65: B.SHORT_DESCRIPTION

Line 66: FROM OKC_CHANGE_REQUESTS_TL B

62: NAME,
63: SHORT_DESCRIPTION) = (SELECT
64: B.NAME,
65: B.SHORT_DESCRIPTION
66: FROM OKC_CHANGE_REQUESTS_TL B
67: WHERE B.ID = T.ID
68: AND B.LANGUAGE = T.SOURCE_LANG)
69: WHERE (
70: T.ID,

Line 75: FROM OKC_CHANGE_REQUESTS_TL SUBB, OKC_CHANGE_REQUESTS_TL SUBT

71: T.LANGUAGE)
72: IN (SELECT
73: SUBT.ID,
74: SUBT.LANGUAGE
75: FROM OKC_CHANGE_REQUESTS_TL SUBB, OKC_CHANGE_REQUESTS_TL SUBT
76: WHERE SUBB.ID = SUBT.ID
77: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
78: AND (SUBB.NAME <> SUBT.NAME
79: OR SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION

Line 86: INSERT /+ append parallel(tt) / INTO OKC_CHANGE_REQUESTS_TL tt(

82: ));
83: */
84:
85: /* Modifying Insert as per performance guidelines given in bug 3723874 */
86: INSERT /*+ append parallel(tt) */ INTO OKC_CHANGE_REQUESTS_TL tt(
87: ID,
88: LANGUAGE,
89: SOURCE_LANG,
90: SFWT_FLAG,

Line 111: FROM OKC_CHANGE_REQUESTS_TL B, FND_LANGUAGES L

107: B.CREATION_DATE,
108: B.LAST_UPDATED_BY,
109: B.LAST_UPDATE_DATE,
110: B.LAST_UPDATE_LOGIN
111: FROM OKC_CHANGE_REQUESTS_TL B, FND_LANGUAGES L
112: WHERE L.INSTALLED_FLAG IN ('I', 'B')
113: AND B.LANGUAGE = USERENV('LANG')
114: ) v, OKC_CHANGE_REQUESTS_TL T
115: WHERE T.ID(+) = v.ID

Line 114: ) v, OKC_CHANGE_REQUESTS_TL T

110: B.LAST_UPDATE_LOGIN
111: FROM OKC_CHANGE_REQUESTS_TL B, FND_LANGUAGES L
112: WHERE L.INSTALLED_FLAG IN ('I', 'B')
113: AND B.LANGUAGE = USERENV('LANG')
114: ) v, OKC_CHANGE_REQUESTS_TL T
115: WHERE T.ID(+) = v.ID
116: AND T.LANGUAGE(+) = v.LANGUAGE_CODE
117: AND T.ID IS NULL;
118:

Line 228: -- FUNCTION get_rec for: OKC_CHANGE_REQUESTS_TL

224: BEGIN
225: RETURN(get_rec(p_crt_rec, l_row_notfound));
226: END get_rec;
227: ---------------------------------------------------------------------------
228: -- FUNCTION get_rec for: OKC_CHANGE_REQUESTS_TL
229: ---------------------------------------------------------------------------
230: FUNCTION get_rec (
231: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
232: x_no_data_found OUT NOCOPY BOOLEAN

Line 231: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,

227: ---------------------------------------------------------------------------
228: -- FUNCTION get_rec for: OKC_CHANGE_REQUESTS_TL
229: ---------------------------------------------------------------------------
230: FUNCTION get_rec (
231: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
232: x_no_data_found OUT NOCOPY BOOLEAN
233: ) RETURN OkcChangeRequestsTlRecType IS
234: CURSOR crt_pktl_csr (p_id IN NUMBER,
235: p_language IN VARCHAR2) IS

Line 248: FROM Okc_Change_Requests_Tl

244: CREATION_DATE,
245: LAST_UPDATED_BY,
246: LAST_UPDATE_DATE,
247: LAST_UPDATE_LOGIN
248: FROM Okc_Change_Requests_Tl
249: WHERE okc_change_requests_tl.id = p_id
250: AND okc_change_requests_tl.language = p_language;
251: l_crt_pktl crt_pktl_csr%ROWTYPE;
252: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;

Line 249: WHERE okc_change_requests_tl.id = p_id

245: LAST_UPDATED_BY,
246: LAST_UPDATE_DATE,
247: LAST_UPDATE_LOGIN
248: FROM Okc_Change_Requests_Tl
249: WHERE okc_change_requests_tl.id = p_id
250: AND okc_change_requests_tl.language = p_language;
251: l_crt_pktl crt_pktl_csr%ROWTYPE;
252: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
253: BEGIN

Line 250: AND okc_change_requests_tl.language = p_language;

246: LAST_UPDATE_DATE,
247: LAST_UPDATE_LOGIN
248: FROM Okc_Change_Requests_Tl
249: WHERE okc_change_requests_tl.id = p_id
250: AND okc_change_requests_tl.language = p_language;
251: l_crt_pktl crt_pktl_csr%ROWTYPE;
252: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
253: BEGIN
254: x_no_data_found := TRUE;

Line 252: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;

248: FROM Okc_Change_Requests_Tl
249: WHERE okc_change_requests_tl.id = p_id
250: AND okc_change_requests_tl.language = p_language;
251: l_crt_pktl crt_pktl_csr%ROWTYPE;
252: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
253: BEGIN
254: x_no_data_found := TRUE;
255: -- Get current database values
256: OPEN crt_pktl_csr (p_okc_change_requests_tl_rec.id,

Line 256: OPEN crt_pktl_csr (p_okc_change_requests_tl_rec.id,

252: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
253: BEGIN
254: x_no_data_found := TRUE;
255: -- Get current database values
256: OPEN crt_pktl_csr (p_okc_change_requests_tl_rec.id,
257: p_okc_change_requests_tl_rec.language);
258: FETCH crt_pktl_csr INTO
259: l_okc_change_requests_tl_rec.ID,
260: l_okc_change_requests_tl_rec.LANGUAGE,

Line 257: p_okc_change_requests_tl_rec.language);

253: BEGIN
254: x_no_data_found := TRUE;
255: -- Get current database values
256: OPEN crt_pktl_csr (p_okc_change_requests_tl_rec.id,
257: p_okc_change_requests_tl_rec.language);
258: FETCH crt_pktl_csr INTO
259: l_okc_change_requests_tl_rec.ID,
260: l_okc_change_requests_tl_rec.LANGUAGE,
261: l_okc_change_requests_tl_rec.SOURCE_LANG,

Line 259: l_okc_change_requests_tl_rec.ID,

255: -- Get current database values
256: OPEN crt_pktl_csr (p_okc_change_requests_tl_rec.id,
257: p_okc_change_requests_tl_rec.language);
258: FETCH crt_pktl_csr INTO
259: l_okc_change_requests_tl_rec.ID,
260: l_okc_change_requests_tl_rec.LANGUAGE,
261: l_okc_change_requests_tl_rec.SOURCE_LANG,
262: l_okc_change_requests_tl_rec.SFWT_FLAG,
263: l_okc_change_requests_tl_rec.NAME,

Line 260: l_okc_change_requests_tl_rec.LANGUAGE,

256: OPEN crt_pktl_csr (p_okc_change_requests_tl_rec.id,
257: p_okc_change_requests_tl_rec.language);
258: FETCH crt_pktl_csr INTO
259: l_okc_change_requests_tl_rec.ID,
260: l_okc_change_requests_tl_rec.LANGUAGE,
261: l_okc_change_requests_tl_rec.SOURCE_LANG,
262: l_okc_change_requests_tl_rec.SFWT_FLAG,
263: l_okc_change_requests_tl_rec.NAME,
264: l_okc_change_requests_tl_rec.SHORT_DESCRIPTION,

Line 261: l_okc_change_requests_tl_rec.SOURCE_LANG,

257: p_okc_change_requests_tl_rec.language);
258: FETCH crt_pktl_csr INTO
259: l_okc_change_requests_tl_rec.ID,
260: l_okc_change_requests_tl_rec.LANGUAGE,
261: l_okc_change_requests_tl_rec.SOURCE_LANG,
262: l_okc_change_requests_tl_rec.SFWT_FLAG,
263: l_okc_change_requests_tl_rec.NAME,
264: l_okc_change_requests_tl_rec.SHORT_DESCRIPTION,
265: l_okc_change_requests_tl_rec.CREATED_BY,

Line 262: l_okc_change_requests_tl_rec.SFWT_FLAG,

258: FETCH crt_pktl_csr INTO
259: l_okc_change_requests_tl_rec.ID,
260: l_okc_change_requests_tl_rec.LANGUAGE,
261: l_okc_change_requests_tl_rec.SOURCE_LANG,
262: l_okc_change_requests_tl_rec.SFWT_FLAG,
263: l_okc_change_requests_tl_rec.NAME,
264: l_okc_change_requests_tl_rec.SHORT_DESCRIPTION,
265: l_okc_change_requests_tl_rec.CREATED_BY,
266: l_okc_change_requests_tl_rec.CREATION_DATE,

Line 263: l_okc_change_requests_tl_rec.NAME,

259: l_okc_change_requests_tl_rec.ID,
260: l_okc_change_requests_tl_rec.LANGUAGE,
261: l_okc_change_requests_tl_rec.SOURCE_LANG,
262: l_okc_change_requests_tl_rec.SFWT_FLAG,
263: l_okc_change_requests_tl_rec.NAME,
264: l_okc_change_requests_tl_rec.SHORT_DESCRIPTION,
265: l_okc_change_requests_tl_rec.CREATED_BY,
266: l_okc_change_requests_tl_rec.CREATION_DATE,
267: l_okc_change_requests_tl_rec.LAST_UPDATED_BY,

Line 264: l_okc_change_requests_tl_rec.SHORT_DESCRIPTION,

260: l_okc_change_requests_tl_rec.LANGUAGE,
261: l_okc_change_requests_tl_rec.SOURCE_LANG,
262: l_okc_change_requests_tl_rec.SFWT_FLAG,
263: l_okc_change_requests_tl_rec.NAME,
264: l_okc_change_requests_tl_rec.SHORT_DESCRIPTION,
265: l_okc_change_requests_tl_rec.CREATED_BY,
266: l_okc_change_requests_tl_rec.CREATION_DATE,
267: l_okc_change_requests_tl_rec.LAST_UPDATED_BY,
268: l_okc_change_requests_tl_rec.LAST_UPDATE_DATE,

Line 265: l_okc_change_requests_tl_rec.CREATED_BY,

261: l_okc_change_requests_tl_rec.SOURCE_LANG,
262: l_okc_change_requests_tl_rec.SFWT_FLAG,
263: l_okc_change_requests_tl_rec.NAME,
264: l_okc_change_requests_tl_rec.SHORT_DESCRIPTION,
265: l_okc_change_requests_tl_rec.CREATED_BY,
266: l_okc_change_requests_tl_rec.CREATION_DATE,
267: l_okc_change_requests_tl_rec.LAST_UPDATED_BY,
268: l_okc_change_requests_tl_rec.LAST_UPDATE_DATE,
269: l_okc_change_requests_tl_rec.LAST_UPDATE_LOGIN;

Line 266: l_okc_change_requests_tl_rec.CREATION_DATE,

262: l_okc_change_requests_tl_rec.SFWT_FLAG,
263: l_okc_change_requests_tl_rec.NAME,
264: l_okc_change_requests_tl_rec.SHORT_DESCRIPTION,
265: l_okc_change_requests_tl_rec.CREATED_BY,
266: l_okc_change_requests_tl_rec.CREATION_DATE,
267: l_okc_change_requests_tl_rec.LAST_UPDATED_BY,
268: l_okc_change_requests_tl_rec.LAST_UPDATE_DATE,
269: l_okc_change_requests_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := crt_pktl_csr%NOTFOUND;

Line 267: l_okc_change_requests_tl_rec.LAST_UPDATED_BY,

263: l_okc_change_requests_tl_rec.NAME,
264: l_okc_change_requests_tl_rec.SHORT_DESCRIPTION,
265: l_okc_change_requests_tl_rec.CREATED_BY,
266: l_okc_change_requests_tl_rec.CREATION_DATE,
267: l_okc_change_requests_tl_rec.LAST_UPDATED_BY,
268: l_okc_change_requests_tl_rec.LAST_UPDATE_DATE,
269: l_okc_change_requests_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := crt_pktl_csr%NOTFOUND;
271: CLOSE crt_pktl_csr;

Line 268: l_okc_change_requests_tl_rec.LAST_UPDATE_DATE,

264: l_okc_change_requests_tl_rec.SHORT_DESCRIPTION,
265: l_okc_change_requests_tl_rec.CREATED_BY,
266: l_okc_change_requests_tl_rec.CREATION_DATE,
267: l_okc_change_requests_tl_rec.LAST_UPDATED_BY,
268: l_okc_change_requests_tl_rec.LAST_UPDATE_DATE,
269: l_okc_change_requests_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := crt_pktl_csr%NOTFOUND;
271: CLOSE crt_pktl_csr;
272: RETURN(l_okc_change_requests_tl_rec);

Line 269: l_okc_change_requests_tl_rec.LAST_UPDATE_LOGIN;

265: l_okc_change_requests_tl_rec.CREATED_BY,
266: l_okc_change_requests_tl_rec.CREATION_DATE,
267: l_okc_change_requests_tl_rec.LAST_UPDATED_BY,
268: l_okc_change_requests_tl_rec.LAST_UPDATE_DATE,
269: l_okc_change_requests_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := crt_pktl_csr%NOTFOUND;
271: CLOSE crt_pktl_csr;
272: RETURN(l_okc_change_requests_tl_rec);
273: END get_rec;

Line 272: RETURN(l_okc_change_requests_tl_rec);

268: l_okc_change_requests_tl_rec.LAST_UPDATE_DATE,
269: l_okc_change_requests_tl_rec.LAST_UPDATE_LOGIN;
270: x_no_data_found := crt_pktl_csr%NOTFOUND;
271: CLOSE crt_pktl_csr;
272: RETURN(l_okc_change_requests_tl_rec);
273: END get_rec;
274:
275: FUNCTION get_rec (
276: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType

Line 276: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType

272: RETURN(l_okc_change_requests_tl_rec);
273: END get_rec;
274:
275: FUNCTION get_rec (
276: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType
277: ) RETURN OkcChangeRequestsTlRecType IS
278: l_row_notfound BOOLEAN := TRUE;
279: BEGIN
280: RETURN(get_rec(p_okc_change_requests_tl_rec, l_row_notfound));

Line 280: RETURN(get_rec(p_okc_change_requests_tl_rec, l_row_notfound));

276: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType
277: ) RETURN OkcChangeRequestsTlRecType IS
278: l_row_notfound BOOLEAN := TRUE;
279: BEGIN
280: RETURN(get_rec(p_okc_change_requests_tl_rec, l_row_notfound));
281: END get_rec;
282: ---------------------------------------------------------------------------
283: -- FUNCTION get_rec for: OKC_CHANGE_REQUESTS_V
284: ---------------------------------------------------------------------------

Line 1290: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;

1286: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1287: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1288: l_crtv_rec crtv_rec_type := p_crtv_rec;
1289: l_crt_rec crt_rec_type;
1290: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
1291: BEGIN
1292: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1293: G_PKG_NAME,
1294: p_init_msg_list,

Line 1581: -- insert_row for:OKC_CHANGE_REQUESTS_TL --

1577: '_PVT'
1578: );
1579: END insert_row;
1580: -------------------------------------------
1581: -- insert_row for:OKC_CHANGE_REQUESTS_TL --
1582: -------------------------------------------
1583: PROCEDURE insert_row(
1584: p_init_msg_list IN VARCHAR2 ,
1585: x_return_status OUT NOCOPY VARCHAR2,

Line 1588: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,

1584: p_init_msg_list IN VARCHAR2 ,
1585: x_return_status OUT NOCOPY VARCHAR2,
1586: x_msg_count OUT NOCOPY NUMBER,
1587: x_msg_data OUT NOCOPY VARCHAR2,
1588: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
1589: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType) IS
1590:
1591: l_api_version CONSTANT NUMBER := 1;
1592: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1589: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType) IS

1585: x_return_status OUT NOCOPY VARCHAR2,
1586: x_msg_count OUT NOCOPY NUMBER,
1587: x_msg_data OUT NOCOPY VARCHAR2,
1588: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
1589: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType) IS
1590:
1591: l_api_version CONSTANT NUMBER := 1;
1592: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1593: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1594: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType := p_okc_change_requests_tl_rec;

1590:
1591: l_api_version CONSTANT NUMBER := 1;
1592: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1593: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1594: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType := p_okc_change_requests_tl_rec;
1595: ldefokcchangerequeststlrec OkcChangeRequestsTlRecType;
1596: CURSOR get_languages IS
1597: SELECT *
1598: FROM FND_LANGUAGES

Line 1601: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --

1597: SELECT *
1598: FROM FND_LANGUAGES
1599: WHERE INSTALLED_FLAG IN ('I', 'B');
1600: -----------------------------------------------
1601: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --
1602: -----------------------------------------------
1603: FUNCTION Set_Attributes (
1604: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
1605: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType

Line 1604: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,

1600: -----------------------------------------------
1601: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --
1602: -----------------------------------------------
1603: FUNCTION Set_Attributes (
1604: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
1605: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
1606: ) RETURN VARCHAR2 IS
1607: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1608: BEGIN

Line 1605: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType

1601: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --
1602: -----------------------------------------------
1603: FUNCTION Set_Attributes (
1604: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
1605: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
1606: ) RETURN VARCHAR2 IS
1607: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1608: BEGIN
1609: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;

Line 1609: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;

1605: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
1606: ) RETURN VARCHAR2 IS
1607: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1608: BEGIN
1609: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;
1610: x_okc_change_requests_tl_rec.LANGUAGE := USERENV('LANG');
1611: x_okc_change_requests_tl_rec.SOURCE_LANG := USERENV('LANG');
1612: RETURN(l_return_status);
1613: END Set_Attributes;

Line 1610: x_okc_change_requests_tl_rec.LANGUAGE := USERENV('LANG');

1606: ) RETURN VARCHAR2 IS
1607: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1608: BEGIN
1609: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;
1610: x_okc_change_requests_tl_rec.LANGUAGE := USERENV('LANG');
1611: x_okc_change_requests_tl_rec.SOURCE_LANG := USERENV('LANG');
1612: RETURN(l_return_status);
1613: END Set_Attributes;
1614: BEGIN

Line 1611: x_okc_change_requests_tl_rec.SOURCE_LANG := USERENV('LANG');

1607: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1608: BEGIN
1609: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;
1610: x_okc_change_requests_tl_rec.LANGUAGE := USERENV('LANG');
1611: x_okc_change_requests_tl_rec.SOURCE_LANG := USERENV('LANG');
1612: RETURN(l_return_status);
1613: END Set_Attributes;
1614: BEGIN
1615: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1626: p_okc_change_requests_tl_rec, -- IN

1622: RAISE OKC_API.G_EXCEPTION_ERROR;
1623: END IF;
1624: --- Setting item attributes
1625: l_return_status := Set_Attributes(
1626: p_okc_change_requests_tl_rec, -- IN
1627: l_okc_change_requests_tl_rec); -- OUT
1628: --- If any errors happen abort API
1629: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1630: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1627: l_okc_change_requests_tl_rec); -- OUT

1623: END IF;
1624: --- Setting item attributes
1625: l_return_status := Set_Attributes(
1626: p_okc_change_requests_tl_rec, -- IN
1627: l_okc_change_requests_tl_rec); -- OUT
1628: --- If any errors happen abort API
1629: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1630: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1631: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1635: l_okc_change_requests_tl_rec.language := l_lang_rec.language_code;

1631: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1632: RAISE OKC_API.G_EXCEPTION_ERROR;
1633: END IF;
1634: FOR l_lang_rec IN get_languages LOOP
1635: l_okc_change_requests_tl_rec.language := l_lang_rec.language_code;
1636: INSERT INTO OKC_CHANGE_REQUESTS_TL(
1637: id,
1638: language,
1639: source_lang,

Line 1636: INSERT INTO OKC_CHANGE_REQUESTS_TL(

1632: RAISE OKC_API.G_EXCEPTION_ERROR;
1633: END IF;
1634: FOR l_lang_rec IN get_languages LOOP
1635: l_okc_change_requests_tl_rec.language := l_lang_rec.language_code;
1636: INSERT INTO OKC_CHANGE_REQUESTS_TL(
1637: id,
1638: language,
1639: source_lang,
1640: sfwt_flag,

Line 1649: l_okc_change_requests_tl_rec.id,

1645: last_updated_by,
1646: last_update_date,
1647: last_update_login)
1648: VALUES (
1649: l_okc_change_requests_tl_rec.id,
1650: l_okc_change_requests_tl_rec.language,
1651: l_okc_change_requests_tl_rec.source_lang,
1652: l_okc_change_requests_tl_rec.sfwt_flag,
1653: l_okc_change_requests_tl_rec.name,

Line 1650: l_okc_change_requests_tl_rec.language,

1646: last_update_date,
1647: last_update_login)
1648: VALUES (
1649: l_okc_change_requests_tl_rec.id,
1650: l_okc_change_requests_tl_rec.language,
1651: l_okc_change_requests_tl_rec.source_lang,
1652: l_okc_change_requests_tl_rec.sfwt_flag,
1653: l_okc_change_requests_tl_rec.name,
1654: l_okc_change_requests_tl_rec.short_description,

Line 1651: l_okc_change_requests_tl_rec.source_lang,

1647: last_update_login)
1648: VALUES (
1649: l_okc_change_requests_tl_rec.id,
1650: l_okc_change_requests_tl_rec.language,
1651: l_okc_change_requests_tl_rec.source_lang,
1652: l_okc_change_requests_tl_rec.sfwt_flag,
1653: l_okc_change_requests_tl_rec.name,
1654: l_okc_change_requests_tl_rec.short_description,
1655: l_okc_change_requests_tl_rec.created_by,

Line 1652: l_okc_change_requests_tl_rec.sfwt_flag,

1648: VALUES (
1649: l_okc_change_requests_tl_rec.id,
1650: l_okc_change_requests_tl_rec.language,
1651: l_okc_change_requests_tl_rec.source_lang,
1652: l_okc_change_requests_tl_rec.sfwt_flag,
1653: l_okc_change_requests_tl_rec.name,
1654: l_okc_change_requests_tl_rec.short_description,
1655: l_okc_change_requests_tl_rec.created_by,
1656: l_okc_change_requests_tl_rec.creation_date,

Line 1653: l_okc_change_requests_tl_rec.name,

1649: l_okc_change_requests_tl_rec.id,
1650: l_okc_change_requests_tl_rec.language,
1651: l_okc_change_requests_tl_rec.source_lang,
1652: l_okc_change_requests_tl_rec.sfwt_flag,
1653: l_okc_change_requests_tl_rec.name,
1654: l_okc_change_requests_tl_rec.short_description,
1655: l_okc_change_requests_tl_rec.created_by,
1656: l_okc_change_requests_tl_rec.creation_date,
1657: l_okc_change_requests_tl_rec.last_updated_by,

Line 1654: l_okc_change_requests_tl_rec.short_description,

1650: l_okc_change_requests_tl_rec.language,
1651: l_okc_change_requests_tl_rec.source_lang,
1652: l_okc_change_requests_tl_rec.sfwt_flag,
1653: l_okc_change_requests_tl_rec.name,
1654: l_okc_change_requests_tl_rec.short_description,
1655: l_okc_change_requests_tl_rec.created_by,
1656: l_okc_change_requests_tl_rec.creation_date,
1657: l_okc_change_requests_tl_rec.last_updated_by,
1658: l_okc_change_requests_tl_rec.last_update_date,

Line 1655: l_okc_change_requests_tl_rec.created_by,

1651: l_okc_change_requests_tl_rec.source_lang,
1652: l_okc_change_requests_tl_rec.sfwt_flag,
1653: l_okc_change_requests_tl_rec.name,
1654: l_okc_change_requests_tl_rec.short_description,
1655: l_okc_change_requests_tl_rec.created_by,
1656: l_okc_change_requests_tl_rec.creation_date,
1657: l_okc_change_requests_tl_rec.last_updated_by,
1658: l_okc_change_requests_tl_rec.last_update_date,
1659: l_okc_change_requests_tl_rec.last_update_login);

Line 1656: l_okc_change_requests_tl_rec.creation_date,

1652: l_okc_change_requests_tl_rec.sfwt_flag,
1653: l_okc_change_requests_tl_rec.name,
1654: l_okc_change_requests_tl_rec.short_description,
1655: l_okc_change_requests_tl_rec.created_by,
1656: l_okc_change_requests_tl_rec.creation_date,
1657: l_okc_change_requests_tl_rec.last_updated_by,
1658: l_okc_change_requests_tl_rec.last_update_date,
1659: l_okc_change_requests_tl_rec.last_update_login);
1660: END LOOP;

Line 1657: l_okc_change_requests_tl_rec.last_updated_by,

1653: l_okc_change_requests_tl_rec.name,
1654: l_okc_change_requests_tl_rec.short_description,
1655: l_okc_change_requests_tl_rec.created_by,
1656: l_okc_change_requests_tl_rec.creation_date,
1657: l_okc_change_requests_tl_rec.last_updated_by,
1658: l_okc_change_requests_tl_rec.last_update_date,
1659: l_okc_change_requests_tl_rec.last_update_login);
1660: END LOOP;
1661: -- Set OUT values

Line 1658: l_okc_change_requests_tl_rec.last_update_date,

1654: l_okc_change_requests_tl_rec.short_description,
1655: l_okc_change_requests_tl_rec.created_by,
1656: l_okc_change_requests_tl_rec.creation_date,
1657: l_okc_change_requests_tl_rec.last_updated_by,
1658: l_okc_change_requests_tl_rec.last_update_date,
1659: l_okc_change_requests_tl_rec.last_update_login);
1660: END LOOP;
1661: -- Set OUT values
1662: x_okc_change_requests_tl_rec := l_okc_change_requests_tl_rec;

Line 1659: l_okc_change_requests_tl_rec.last_update_login);

1655: l_okc_change_requests_tl_rec.created_by,
1656: l_okc_change_requests_tl_rec.creation_date,
1657: l_okc_change_requests_tl_rec.last_updated_by,
1658: l_okc_change_requests_tl_rec.last_update_date,
1659: l_okc_change_requests_tl_rec.last_update_login);
1660: END LOOP;
1661: -- Set OUT values
1662: x_okc_change_requests_tl_rec := l_okc_change_requests_tl_rec;
1663: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1662: x_okc_change_requests_tl_rec := l_okc_change_requests_tl_rec;

1658: l_okc_change_requests_tl_rec.last_update_date,
1659: l_okc_change_requests_tl_rec.last_update_login);
1660: END LOOP;
1661: -- Set OUT values
1662: x_okc_change_requests_tl_rec := l_okc_change_requests_tl_rec;
1663: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1664: EXCEPTION
1665: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1666: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1715: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;

1711: l_crtv_rec crtv_rec_type;
1712: l_def_crtv_rec crtv_rec_type;
1713: l_crt_rec crt_rec_type;
1714: lx_crt_rec crt_rec_type;
1715: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
1716: lx_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
1717: -------------------------------
1718: -- FUNCTION fill_who_columns --
1719: -------------------------------

Line 1716: lx_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;

1712: l_def_crtv_rec crtv_rec_type;
1713: l_crt_rec crt_rec_type;
1714: lx_crt_rec crt_rec_type;
1715: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
1716: lx_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
1717: -------------------------------
1718: -- FUNCTION fill_who_columns --
1719: -------------------------------
1720: FUNCTION fill_who_columns (

Line 1791: migrate(l_def_crtv_rec, l_okc_change_requests_tl_rec);

1787: --------------------------------------
1788: -- Move VIEW record to "Child" records
1789: --------------------------------------
1790: migrate(l_def_crtv_rec, l_crt_rec);
1791: migrate(l_def_crtv_rec, l_okc_change_requests_tl_rec);
1792: --------------------------------------------
1793: -- Call the INSERT_ROW for each child record
1794: --------------------------------------------
1795: insert_row(

Line 1814: l_okc_change_requests_tl_rec,

1810: p_init_msg_list,
1811: x_return_status,
1812: x_msg_count,
1813: x_msg_data,
1814: l_okc_change_requests_tl_rec,
1815: lx_okc_change_requests_tl_rec
1816: );
1817: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1818: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1815: lx_okc_change_requests_tl_rec

1811: x_return_status,
1812: x_msg_count,
1813: x_msg_data,
1814: l_okc_change_requests_tl_rec,
1815: lx_okc_change_requests_tl_rec
1816: );
1817: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1818: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1819: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1822: migrate(lx_okc_change_requests_tl_rec, l_def_crtv_rec);

1818: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1819: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1820: RAISE OKC_API.G_EXCEPTION_ERROR;
1821: END IF;
1822: migrate(lx_okc_change_requests_tl_rec, l_def_crtv_rec);
1823: -- Set OUT values
1824: x_crtv_rec := l_def_crtv_rec;
1825: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1826: EXCEPTION

Line 2035: -- lock_row for:OKC_CHANGE_REQUESTS_TL --

2031: '_PVT'
2032: );
2033: END lock_row;
2034: -----------------------------------------
2035: -- lock_row for:OKC_CHANGE_REQUESTS_TL --
2036: -----------------------------------------
2037: PROCEDURE lock_row(
2038: p_init_msg_list IN VARCHAR2 ,
2039: x_return_status OUT NOCOPY VARCHAR2,

Line 2042: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType) IS

2038: p_init_msg_list IN VARCHAR2 ,
2039: x_return_status OUT NOCOPY VARCHAR2,
2040: x_msg_count OUT NOCOPY NUMBER,
2041: x_msg_data OUT NOCOPY VARCHAR2,
2042: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType) IS
2043:
2044: E_Resource_Busy EXCEPTION;
2045: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2046: CURSOR lock_csr (p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType) IS

Line 2046: CURSOR lock_csr (p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType) IS

2042: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType) IS
2043:
2044: E_Resource_Busy EXCEPTION;
2045: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2046: CURSOR lock_csr (p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType) IS
2047: SELECT *
2048: FROM OKC_CHANGE_REQUESTS_TL
2049: WHERE ID = p_okc_change_requests_tl_rec.id
2050: FOR UPDATE NOWAIT;

Line 2048: FROM OKC_CHANGE_REQUESTS_TL

2044: E_Resource_Busy EXCEPTION;
2045: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2046: CURSOR lock_csr (p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType) IS
2047: SELECT *
2048: FROM OKC_CHANGE_REQUESTS_TL
2049: WHERE ID = p_okc_change_requests_tl_rec.id
2050: FOR UPDATE NOWAIT;
2051:
2052: l_api_version CONSTANT NUMBER := 1;

Line 2049: WHERE ID = p_okc_change_requests_tl_rec.id

2045: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2046: CURSOR lock_csr (p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType) IS
2047: SELECT *
2048: FROM OKC_CHANGE_REQUESTS_TL
2049: WHERE ID = p_okc_change_requests_tl_rec.id
2050: FOR UPDATE NOWAIT;
2051:
2052: l_api_version CONSTANT NUMBER := 1;
2053: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2069: OPEN lock_csr(p_okc_change_requests_tl_rec);

2065: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2066: RAISE OKC_API.G_EXCEPTION_ERROR;
2067: END IF;
2068: BEGIN
2069: OPEN lock_csr(p_okc_change_requests_tl_rec);
2070: FETCH lock_csr INTO l_lock_var;
2071: l_row_notfound := lock_csr%NOTFOUND;
2072: CLOSE lock_csr;
2073: EXCEPTION

Line 2134: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;

2130: l_api_version CONSTANT NUMBER := 1;
2131: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2132: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2133: l_crt_rec crt_rec_type;
2134: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
2135: BEGIN
2136: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2137: G_PKG_NAME,
2138: p_init_msg_list,

Line 2152: migrate(p_crtv_rec, l_okc_change_requests_tl_rec);

2148: --------------------------------------
2149: -- Move VIEW record to "Child" records
2150: --------------------------------------
2151: migrate(p_crtv_rec, l_crt_rec);
2152: migrate(p_crtv_rec, l_okc_change_requests_tl_rec);
2153: --------------------------------------------
2154: -- Call the LOCK_ROW for each child record
2155: --------------------------------------------
2156: lock_row(

Line 2173: l_okc_change_requests_tl_rec

2169: p_init_msg_list,
2170: x_return_status,
2171: x_msg_count,
2172: x_msg_data,
2173: l_okc_change_requests_tl_rec
2174: );
2175: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2177: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2582: -- update_row for:OKC_CHANGE_REQUESTS_TL --

2578: '_PVT'
2579: );
2580: END update_row;
2581: -------------------------------------------
2582: -- update_row for:OKC_CHANGE_REQUESTS_TL --
2583: -------------------------------------------
2584: PROCEDURE update_row(
2585: p_init_msg_list IN VARCHAR2 ,
2586: x_return_status OUT NOCOPY VARCHAR2,

Line 2589: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,

2585: p_init_msg_list IN VARCHAR2 ,
2586: x_return_status OUT NOCOPY VARCHAR2,
2587: x_msg_count OUT NOCOPY NUMBER,
2588: x_msg_data OUT NOCOPY VARCHAR2,
2589: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
2590: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType) IS
2591:
2592: l_api_version CONSTANT NUMBER := 1;
2593: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2590: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType) IS

2586: x_return_status OUT NOCOPY VARCHAR2,
2587: x_msg_count OUT NOCOPY NUMBER,
2588: x_msg_data OUT NOCOPY VARCHAR2,
2589: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
2590: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType) IS
2591:
2592: l_api_version CONSTANT NUMBER := 1;
2593: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2594: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2595: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType := p_okc_change_requests_tl_rec;

2591:
2592: l_api_version CONSTANT NUMBER := 1;
2593: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2594: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2595: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType := p_okc_change_requests_tl_rec;
2596: ldefokcchangerequeststlrec OkcChangeRequestsTlRecType;
2597: l_row_notfound BOOLEAN := TRUE;
2598: ----------------------------------
2599: -- FUNCTION populate_new_record --

Line 2602: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,

2598: ----------------------------------
2599: -- FUNCTION populate_new_record --
2600: ----------------------------------
2601: FUNCTION populate_new_record (
2602: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
2603: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
2604: ) RETURN VARCHAR2 IS
2605: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
2606: l_row_notfound BOOLEAN := TRUE;

Line 2603: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType

2599: -- FUNCTION populate_new_record --
2600: ----------------------------------
2601: FUNCTION populate_new_record (
2602: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
2603: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
2604: ) RETURN VARCHAR2 IS
2605: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
2606: l_row_notfound BOOLEAN := TRUE;
2607: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2605: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;

2601: FUNCTION populate_new_record (
2602: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
2603: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
2604: ) RETURN VARCHAR2 IS
2605: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
2606: l_row_notfound BOOLEAN := TRUE;
2607: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2608: BEGIN
2609: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;

Line 2609: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;

2605: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
2606: l_row_notfound BOOLEAN := TRUE;
2607: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2608: BEGIN
2609: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;
2610: -- Get current database values
2611: l_okc_change_requests_tl_rec := get_rec(p_okc_change_requests_tl_rec, l_row_notfound);
2612: IF (l_row_notfound) THEN
2613: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2611: l_okc_change_requests_tl_rec := get_rec(p_okc_change_requests_tl_rec, l_row_notfound);

2607: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2608: BEGIN
2609: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;
2610: -- Get current database values
2611: l_okc_change_requests_tl_rec := get_rec(p_okc_change_requests_tl_rec, l_row_notfound);
2612: IF (l_row_notfound) THEN
2613: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2614: END IF;
2615: IF (x_okc_change_requests_tl_rec.id = OKC_API.G_MISS_NUM)

Line 2615: IF (x_okc_change_requests_tl_rec.id = OKC_API.G_MISS_NUM)

2611: l_okc_change_requests_tl_rec := get_rec(p_okc_change_requests_tl_rec, l_row_notfound);
2612: IF (l_row_notfound) THEN
2613: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2614: END IF;
2615: IF (x_okc_change_requests_tl_rec.id = OKC_API.G_MISS_NUM)
2616: THEN
2617: x_okc_change_requests_tl_rec.id := l_okc_change_requests_tl_rec.id;
2618: END IF;
2619: IF (x_okc_change_requests_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2617: x_okc_change_requests_tl_rec.id := l_okc_change_requests_tl_rec.id;

2613: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2614: END IF;
2615: IF (x_okc_change_requests_tl_rec.id = OKC_API.G_MISS_NUM)
2616: THEN
2617: x_okc_change_requests_tl_rec.id := l_okc_change_requests_tl_rec.id;
2618: END IF;
2619: IF (x_okc_change_requests_tl_rec.language = OKC_API.G_MISS_CHAR)
2620: THEN
2621: x_okc_change_requests_tl_rec.language := l_okc_change_requests_tl_rec.language;

Line 2619: IF (x_okc_change_requests_tl_rec.language = OKC_API.G_MISS_CHAR)

2615: IF (x_okc_change_requests_tl_rec.id = OKC_API.G_MISS_NUM)
2616: THEN
2617: x_okc_change_requests_tl_rec.id := l_okc_change_requests_tl_rec.id;
2618: END IF;
2619: IF (x_okc_change_requests_tl_rec.language = OKC_API.G_MISS_CHAR)
2620: THEN
2621: x_okc_change_requests_tl_rec.language := l_okc_change_requests_tl_rec.language;
2622: END IF;
2623: IF (x_okc_change_requests_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2621: x_okc_change_requests_tl_rec.language := l_okc_change_requests_tl_rec.language;

2617: x_okc_change_requests_tl_rec.id := l_okc_change_requests_tl_rec.id;
2618: END IF;
2619: IF (x_okc_change_requests_tl_rec.language = OKC_API.G_MISS_CHAR)
2620: THEN
2621: x_okc_change_requests_tl_rec.language := l_okc_change_requests_tl_rec.language;
2622: END IF;
2623: IF (x_okc_change_requests_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2624: THEN
2625: x_okc_change_requests_tl_rec.source_lang := l_okc_change_requests_tl_rec.source_lang;

Line 2623: IF (x_okc_change_requests_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2619: IF (x_okc_change_requests_tl_rec.language = OKC_API.G_MISS_CHAR)
2620: THEN
2621: x_okc_change_requests_tl_rec.language := l_okc_change_requests_tl_rec.language;
2622: END IF;
2623: IF (x_okc_change_requests_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2624: THEN
2625: x_okc_change_requests_tl_rec.source_lang := l_okc_change_requests_tl_rec.source_lang;
2626: END IF;
2627: IF (x_okc_change_requests_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2625: x_okc_change_requests_tl_rec.source_lang := l_okc_change_requests_tl_rec.source_lang;

2621: x_okc_change_requests_tl_rec.language := l_okc_change_requests_tl_rec.language;
2622: END IF;
2623: IF (x_okc_change_requests_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2624: THEN
2625: x_okc_change_requests_tl_rec.source_lang := l_okc_change_requests_tl_rec.source_lang;
2626: END IF;
2627: IF (x_okc_change_requests_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2628: THEN
2629: x_okc_change_requests_tl_rec.sfwt_flag := l_okc_change_requests_tl_rec.sfwt_flag;

Line 2627: IF (x_okc_change_requests_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2623: IF (x_okc_change_requests_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2624: THEN
2625: x_okc_change_requests_tl_rec.source_lang := l_okc_change_requests_tl_rec.source_lang;
2626: END IF;
2627: IF (x_okc_change_requests_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2628: THEN
2629: x_okc_change_requests_tl_rec.sfwt_flag := l_okc_change_requests_tl_rec.sfwt_flag;
2630: END IF;
2631: IF (x_okc_change_requests_tl_rec.name = OKC_API.G_MISS_CHAR)

Line 2629: x_okc_change_requests_tl_rec.sfwt_flag := l_okc_change_requests_tl_rec.sfwt_flag;

2625: x_okc_change_requests_tl_rec.source_lang := l_okc_change_requests_tl_rec.source_lang;
2626: END IF;
2627: IF (x_okc_change_requests_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2628: THEN
2629: x_okc_change_requests_tl_rec.sfwt_flag := l_okc_change_requests_tl_rec.sfwt_flag;
2630: END IF;
2631: IF (x_okc_change_requests_tl_rec.name = OKC_API.G_MISS_CHAR)
2632: THEN
2633: x_okc_change_requests_tl_rec.name := l_okc_change_requests_tl_rec.name;

Line 2631: IF (x_okc_change_requests_tl_rec.name = OKC_API.G_MISS_CHAR)

2627: IF (x_okc_change_requests_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2628: THEN
2629: x_okc_change_requests_tl_rec.sfwt_flag := l_okc_change_requests_tl_rec.sfwt_flag;
2630: END IF;
2631: IF (x_okc_change_requests_tl_rec.name = OKC_API.G_MISS_CHAR)
2632: THEN
2633: x_okc_change_requests_tl_rec.name := l_okc_change_requests_tl_rec.name;
2634: END IF;
2635: IF (x_okc_change_requests_tl_rec.short_description = OKC_API.G_MISS_CHAR)

Line 2633: x_okc_change_requests_tl_rec.name := l_okc_change_requests_tl_rec.name;

2629: x_okc_change_requests_tl_rec.sfwt_flag := l_okc_change_requests_tl_rec.sfwt_flag;
2630: END IF;
2631: IF (x_okc_change_requests_tl_rec.name = OKC_API.G_MISS_CHAR)
2632: THEN
2633: x_okc_change_requests_tl_rec.name := l_okc_change_requests_tl_rec.name;
2634: END IF;
2635: IF (x_okc_change_requests_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2636: THEN
2637: x_okc_change_requests_tl_rec.short_description := l_okc_change_requests_tl_rec.short_description;

Line 2635: IF (x_okc_change_requests_tl_rec.short_description = OKC_API.G_MISS_CHAR)

2631: IF (x_okc_change_requests_tl_rec.name = OKC_API.G_MISS_CHAR)
2632: THEN
2633: x_okc_change_requests_tl_rec.name := l_okc_change_requests_tl_rec.name;
2634: END IF;
2635: IF (x_okc_change_requests_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2636: THEN
2637: x_okc_change_requests_tl_rec.short_description := l_okc_change_requests_tl_rec.short_description;
2638: END IF;
2639: IF (x_okc_change_requests_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2637: x_okc_change_requests_tl_rec.short_description := l_okc_change_requests_tl_rec.short_description;

2633: x_okc_change_requests_tl_rec.name := l_okc_change_requests_tl_rec.name;
2634: END IF;
2635: IF (x_okc_change_requests_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2636: THEN
2637: x_okc_change_requests_tl_rec.short_description := l_okc_change_requests_tl_rec.short_description;
2638: END IF;
2639: IF (x_okc_change_requests_tl_rec.created_by = OKC_API.G_MISS_NUM)
2640: THEN
2641: x_okc_change_requests_tl_rec.created_by := l_okc_change_requests_tl_rec.created_by;

Line 2639: IF (x_okc_change_requests_tl_rec.created_by = OKC_API.G_MISS_NUM)

2635: IF (x_okc_change_requests_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2636: THEN
2637: x_okc_change_requests_tl_rec.short_description := l_okc_change_requests_tl_rec.short_description;
2638: END IF;
2639: IF (x_okc_change_requests_tl_rec.created_by = OKC_API.G_MISS_NUM)
2640: THEN
2641: x_okc_change_requests_tl_rec.created_by := l_okc_change_requests_tl_rec.created_by;
2642: END IF;
2643: IF (x_okc_change_requests_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2641: x_okc_change_requests_tl_rec.created_by := l_okc_change_requests_tl_rec.created_by;

2637: x_okc_change_requests_tl_rec.short_description := l_okc_change_requests_tl_rec.short_description;
2638: END IF;
2639: IF (x_okc_change_requests_tl_rec.created_by = OKC_API.G_MISS_NUM)
2640: THEN
2641: x_okc_change_requests_tl_rec.created_by := l_okc_change_requests_tl_rec.created_by;
2642: END IF;
2643: IF (x_okc_change_requests_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2644: THEN
2645: x_okc_change_requests_tl_rec.creation_date := l_okc_change_requests_tl_rec.creation_date;

Line 2643: IF (x_okc_change_requests_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2639: IF (x_okc_change_requests_tl_rec.created_by = OKC_API.G_MISS_NUM)
2640: THEN
2641: x_okc_change_requests_tl_rec.created_by := l_okc_change_requests_tl_rec.created_by;
2642: END IF;
2643: IF (x_okc_change_requests_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2644: THEN
2645: x_okc_change_requests_tl_rec.creation_date := l_okc_change_requests_tl_rec.creation_date;
2646: END IF;
2647: IF (x_okc_change_requests_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2645: x_okc_change_requests_tl_rec.creation_date := l_okc_change_requests_tl_rec.creation_date;

2641: x_okc_change_requests_tl_rec.created_by := l_okc_change_requests_tl_rec.created_by;
2642: END IF;
2643: IF (x_okc_change_requests_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2644: THEN
2645: x_okc_change_requests_tl_rec.creation_date := l_okc_change_requests_tl_rec.creation_date;
2646: END IF;
2647: IF (x_okc_change_requests_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2648: THEN
2649: x_okc_change_requests_tl_rec.last_updated_by := l_okc_change_requests_tl_rec.last_updated_by;

Line 2647: IF (x_okc_change_requests_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2643: IF (x_okc_change_requests_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2644: THEN
2645: x_okc_change_requests_tl_rec.creation_date := l_okc_change_requests_tl_rec.creation_date;
2646: END IF;
2647: IF (x_okc_change_requests_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2648: THEN
2649: x_okc_change_requests_tl_rec.last_updated_by := l_okc_change_requests_tl_rec.last_updated_by;
2650: END IF;
2651: IF (x_okc_change_requests_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2649: x_okc_change_requests_tl_rec.last_updated_by := l_okc_change_requests_tl_rec.last_updated_by;

2645: x_okc_change_requests_tl_rec.creation_date := l_okc_change_requests_tl_rec.creation_date;
2646: END IF;
2647: IF (x_okc_change_requests_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2648: THEN
2649: x_okc_change_requests_tl_rec.last_updated_by := l_okc_change_requests_tl_rec.last_updated_by;
2650: END IF;
2651: IF (x_okc_change_requests_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2652: THEN
2653: x_okc_change_requests_tl_rec.last_update_date := l_okc_change_requests_tl_rec.last_update_date;

Line 2651: IF (x_okc_change_requests_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2647: IF (x_okc_change_requests_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2648: THEN
2649: x_okc_change_requests_tl_rec.last_updated_by := l_okc_change_requests_tl_rec.last_updated_by;
2650: END IF;
2651: IF (x_okc_change_requests_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2652: THEN
2653: x_okc_change_requests_tl_rec.last_update_date := l_okc_change_requests_tl_rec.last_update_date;
2654: END IF;
2655: IF (x_okc_change_requests_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2653: x_okc_change_requests_tl_rec.last_update_date := l_okc_change_requests_tl_rec.last_update_date;

2649: x_okc_change_requests_tl_rec.last_updated_by := l_okc_change_requests_tl_rec.last_updated_by;
2650: END IF;
2651: IF (x_okc_change_requests_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2652: THEN
2653: x_okc_change_requests_tl_rec.last_update_date := l_okc_change_requests_tl_rec.last_update_date;
2654: END IF;
2655: IF (x_okc_change_requests_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2656: THEN
2657: x_okc_change_requests_tl_rec.last_update_login := l_okc_change_requests_tl_rec.last_update_login;

Line 2655: IF (x_okc_change_requests_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2651: IF (x_okc_change_requests_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2652: THEN
2653: x_okc_change_requests_tl_rec.last_update_date := l_okc_change_requests_tl_rec.last_update_date;
2654: END IF;
2655: IF (x_okc_change_requests_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2656: THEN
2657: x_okc_change_requests_tl_rec.last_update_login := l_okc_change_requests_tl_rec.last_update_login;
2658: END IF;
2659: RETURN(l_return_status);

Line 2657: x_okc_change_requests_tl_rec.last_update_login := l_okc_change_requests_tl_rec.last_update_login;

2653: x_okc_change_requests_tl_rec.last_update_date := l_okc_change_requests_tl_rec.last_update_date;
2654: END IF;
2655: IF (x_okc_change_requests_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2656: THEN
2657: x_okc_change_requests_tl_rec.last_update_login := l_okc_change_requests_tl_rec.last_update_login;
2658: END IF;
2659: RETURN(l_return_status);
2660: END populate_new_record;
2661: -----------------------------------------------

Line 2662: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --

2658: END IF;
2659: RETURN(l_return_status);
2660: END populate_new_record;
2661: -----------------------------------------------
2662: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --
2663: -----------------------------------------------
2664: FUNCTION Set_Attributes (
2665: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
2666: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType

Line 2665: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,

2661: -----------------------------------------------
2662: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --
2663: -----------------------------------------------
2664: FUNCTION Set_Attributes (
2665: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
2666: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
2667: ) RETURN VARCHAR2 IS
2668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2669: BEGIN

Line 2666: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType

2662: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --
2663: -----------------------------------------------
2664: FUNCTION Set_Attributes (
2665: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
2666: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
2667: ) RETURN VARCHAR2 IS
2668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2669: BEGIN
2670: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;

Line 2670: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;

2666: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
2667: ) RETURN VARCHAR2 IS
2668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2669: BEGIN
2670: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;
2671: x_okc_change_requests_tl_rec.LANGUAGE := USERENV('LANG');
2672: x_okc_change_requests_tl_rec.SOURCE_LANG := USERENV('LANG');
2673: RETURN(l_return_status);
2674: END Set_Attributes;

Line 2671: x_okc_change_requests_tl_rec.LANGUAGE := USERENV('LANG');

2667: ) RETURN VARCHAR2 IS
2668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2669: BEGIN
2670: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;
2671: x_okc_change_requests_tl_rec.LANGUAGE := USERENV('LANG');
2672: x_okc_change_requests_tl_rec.SOURCE_LANG := USERENV('LANG');
2673: RETURN(l_return_status);
2674: END Set_Attributes;
2675: BEGIN

Line 2672: x_okc_change_requests_tl_rec.SOURCE_LANG := USERENV('LANG');

2668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2669: BEGIN
2670: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;
2671: x_okc_change_requests_tl_rec.LANGUAGE := USERENV('LANG');
2672: x_okc_change_requests_tl_rec.SOURCE_LANG := USERENV('LANG');
2673: RETURN(l_return_status);
2674: END Set_Attributes;
2675: BEGIN
2676: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2687: p_okc_change_requests_tl_rec, -- IN

2683: RAISE OKC_API.G_EXCEPTION_ERROR;
2684: END IF;
2685: --- Setting item attributes
2686: l_return_status := Set_Attributes(
2687: p_okc_change_requests_tl_rec, -- IN
2688: l_okc_change_requests_tl_rec); -- OUT
2689: --- If any errors happen abort API
2690: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2691: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2688: l_okc_change_requests_tl_rec); -- OUT

2684: END IF;
2685: --- Setting item attributes
2686: l_return_status := Set_Attributes(
2687: p_okc_change_requests_tl_rec, -- IN
2688: l_okc_change_requests_tl_rec); -- OUT
2689: --- If any errors happen abort API
2690: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2691: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2692: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2695: l_return_status := populate_new_record(l_okc_change_requests_tl_rec, ldefokcchangerequeststlrec);

2691: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2692: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2693: RAISE OKC_API.G_EXCEPTION_ERROR;
2694: END IF;
2695: l_return_status := populate_new_record(l_okc_change_requests_tl_rec, ldefokcchangerequeststlrec);
2696: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2697: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2698: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2699: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2701: UPDATE OKC_CHANGE_REQUESTS_TL

2697: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2698: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2699: RAISE OKC_API.G_EXCEPTION_ERROR;
2700: END IF;
2701: UPDATE OKC_CHANGE_REQUESTS_TL
2702: SET NAME = ldefokcchangerequeststlrec.name,
2703: SHORT_DESCRIPTION = ldefokcchangerequeststlrec.short_description,
2704: CREATED_BY = ldefokcchangerequeststlrec.created_by,
2705: CREATION_DATE = ldefokcchangerequeststlrec.creation_date,

Line 2713: UPDATE OKC_CHANGE_REQUESTS_TL

2709: SOURCE_LANG = ldefokcchangerequeststlrec.source_lang
2710: WHERE ID = ldefokcchangerequeststlrec.id
2711: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);
2712:
2713: UPDATE OKC_CHANGE_REQUESTS_TL
2714: SET SFWT_FLAG = 'Y'
2715: WHERE ID = ldefokcchangerequeststlrec.id
2716: AND SOURCE_LANG <> USERENV('LANG');
2717:

Line 2718: x_okc_change_requests_tl_rec := ldefokcchangerequeststlrec;

2714: SET SFWT_FLAG = 'Y'
2715: WHERE ID = ldefokcchangerequeststlrec.id
2716: AND SOURCE_LANG <> USERENV('LANG');
2717:
2718: x_okc_change_requests_tl_rec := ldefokcchangerequeststlrec;
2719: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2720: EXCEPTION
2721: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2722: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2769: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;

2765: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2766: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2767: l_crtv_rec crtv_rec_type := p_crtv_rec;
2768: l_def_crtv_rec crtv_rec_type;
2769: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
2770: lx_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
2771: l_crt_rec crt_rec_type;
2772: lx_crt_rec crt_rec_type;
2773: -------------------------------

Line 2770: lx_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;

2766: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2767: l_crtv_rec crtv_rec_type := p_crtv_rec;
2768: l_def_crtv_rec crtv_rec_type;
2769: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
2770: lx_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
2771: l_crt_rec crt_rec_type;
2772: lx_crt_rec crt_rec_type;
2773: -------------------------------
2774: -- FUNCTION fill_who_columns --

Line 3030: migrate(l_def_crtv_rec, l_okc_change_requests_tl_rec);

3026:
3027: --------------------------------------
3028: -- Move VIEW record to "Child" records
3029: --------------------------------------
3030: migrate(l_def_crtv_rec, l_okc_change_requests_tl_rec);
3031: migrate(l_def_crtv_rec, l_crt_rec);
3032: --------------------------------------------
3033: -- Call the UPDATE_ROW for each child record
3034: --------------------------------------------

Line 3040: l_okc_change_requests_tl_rec,

3036: p_init_msg_list,
3037: x_return_status,
3038: x_msg_count,
3039: x_msg_data,
3040: l_okc_change_requests_tl_rec,
3041: lx_okc_change_requests_tl_rec
3042: );
3043: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3044: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3041: lx_okc_change_requests_tl_rec

3037: x_return_status,
3038: x_msg_count,
3039: x_msg_data,
3040: l_okc_change_requests_tl_rec,
3041: lx_okc_change_requests_tl_rec
3042: );
3043: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3044: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3045: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3048: migrate(lx_okc_change_requests_tl_rec, l_def_crtv_rec);

3044: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3045: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3046: RAISE OKC_API.G_EXCEPTION_ERROR;
3047: END IF;
3048: migrate(lx_okc_change_requests_tl_rec, l_def_crtv_rec);
3049: update_row(
3050: p_init_msg_list,
3051: x_return_status,
3052: x_msg_count,

Line 3229: -- delete_row for:OKC_CHANGE_REQUESTS_TL --

3225: '_PVT'
3226: );
3227: END delete_row;
3228: -------------------------------------------
3229: -- delete_row for:OKC_CHANGE_REQUESTS_TL --
3230: -------------------------------------------
3231: PROCEDURE delete_row(
3232: p_init_msg_list IN VARCHAR2 ,
3233: x_return_status OUT NOCOPY VARCHAR2,

Line 3236: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType) IS

3232: p_init_msg_list IN VARCHAR2 ,
3233: x_return_status OUT NOCOPY VARCHAR2,
3234: x_msg_count OUT NOCOPY NUMBER,
3235: x_msg_data OUT NOCOPY VARCHAR2,
3236: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType) IS
3237:
3238: l_api_version CONSTANT NUMBER := 1;
3239: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3241: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType:= p_okc_change_requests_tl_rec;

3237:
3238: l_api_version CONSTANT NUMBER := 1;
3239: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3241: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType:= p_okc_change_requests_tl_rec;
3242: l_row_notfound BOOLEAN := TRUE;
3243: -----------------------------------------------
3244: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --
3245: -----------------------------------------------

Line 3244: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --

3240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3241: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType:= p_okc_change_requests_tl_rec;
3242: l_row_notfound BOOLEAN := TRUE;
3243: -----------------------------------------------
3244: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --
3245: -----------------------------------------------
3246: FUNCTION Set_Attributes (
3247: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
3248: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType

Line 3247: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,

3243: -----------------------------------------------
3244: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --
3245: -----------------------------------------------
3246: FUNCTION Set_Attributes (
3247: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
3248: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
3249: ) RETURN VARCHAR2 IS
3250: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3251: BEGIN

Line 3248: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType

3244: -- Set_Attributes for:OKC_CHANGE_REQUESTS_TL --
3245: -----------------------------------------------
3246: FUNCTION Set_Attributes (
3247: p_okc_change_requests_tl_rec IN OkcChangeRequestsTlRecType,
3248: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
3249: ) RETURN VARCHAR2 IS
3250: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3251: BEGIN
3252: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;

Line 3252: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;

3248: x_okc_change_requests_tl_rec OUT NOCOPY OkcChangeRequestsTlRecType
3249: ) RETURN VARCHAR2 IS
3250: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3251: BEGIN
3252: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;
3253: x_okc_change_requests_tl_rec.LANGUAGE := USERENV('LANG');
3254: RETURN(l_return_status);
3255: END Set_Attributes;
3256: BEGIN

Line 3253: x_okc_change_requests_tl_rec.LANGUAGE := USERENV('LANG');

3249: ) RETURN VARCHAR2 IS
3250: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3251: BEGIN
3252: x_okc_change_requests_tl_rec := p_okc_change_requests_tl_rec;
3253: x_okc_change_requests_tl_rec.LANGUAGE := USERENV('LANG');
3254: RETURN(l_return_status);
3255: END Set_Attributes;
3256: BEGIN
3257: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3268: p_okc_change_requests_tl_rec, -- IN

3264: RAISE OKC_API.G_EXCEPTION_ERROR;
3265: END IF;
3266: --- Setting item attributes
3267: l_return_status := Set_Attributes(
3268: p_okc_change_requests_tl_rec, -- IN
3269: l_okc_change_requests_tl_rec); -- OUT
3270: --- If any errors happen abort API
3271: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3272: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3269: l_okc_change_requests_tl_rec); -- OUT

3265: END IF;
3266: --- Setting item attributes
3267: l_return_status := Set_Attributes(
3268: p_okc_change_requests_tl_rec, -- IN
3269: l_okc_change_requests_tl_rec); -- OUT
3270: --- If any errors happen abort API
3271: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3272: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3273: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3276: DELETE FROM OKC_CHANGE_REQUESTS_TL

3272: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3273: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3274: RAISE OKC_API.G_EXCEPTION_ERROR;
3275: END IF;
3276: DELETE FROM OKC_CHANGE_REQUESTS_TL
3277: WHERE ID = l_okc_change_requests_tl_rec.id;
3278:
3279: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3280: EXCEPTION

Line 3277: WHERE ID = l_okc_change_requests_tl_rec.id;

3273: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3274: RAISE OKC_API.G_EXCEPTION_ERROR;
3275: END IF;
3276: DELETE FROM OKC_CHANGE_REQUESTS_TL
3277: WHERE ID = l_okc_change_requests_tl_rec.id;
3278:
3279: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3280: EXCEPTION
3281: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3327: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;

3323: l_api_version CONSTANT NUMBER := 1;
3324: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3325: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3326: l_crtv_rec crtv_rec_type := p_crtv_rec;
3327: l_okc_change_requests_tl_rec OkcChangeRequestsTlRecType;
3328: l_crt_rec crt_rec_type;
3329: BEGIN
3330: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3331: G_PKG_NAME,

Line 3345: migrate(l_crtv_rec, l_okc_change_requests_tl_rec);

3341: END IF;
3342: --------------------------------------
3343: -- Move VIEW record to "Child" records
3344: --------------------------------------
3345: migrate(l_crtv_rec, l_okc_change_requests_tl_rec);
3346: migrate(l_crtv_rec, l_crt_rec);
3347: --------------------------------------------
3348: -- Call the DELETE_ROW for each child record
3349: --------------------------------------------

Line 3355: l_okc_change_requests_tl_rec

3351: p_init_msg_list,
3352: x_return_status,
3353: x_msg_count,
3354: x_msg_data,
3355: l_okc_change_requests_tl_rec
3356: );
3357: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3358: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3359: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN