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_AAE_PVT dependencies on OKC_ACTION_ATTRIBUTES_TL

Line 50: DELETE FROM OKC_ACTION_ATTRIBUTES_TL T

46: /* as a quick workaround to fix the time-consuming table handler issue */
47: /* Eventually we'll need to turn them into a separate fix_language procedure */
48: /*
49:
50: DELETE FROM OKC_ACTION_ATTRIBUTES_TL T
51: WHERE NOT EXISTS (
52: SELECT NULL
53: FROM OKC_ACTION_ATTRIBUTES_B B
54: WHERE B.ID = T.ID

Line 57: UPDATE OKC_ACTION_ATTRIBUTES_TL T SET (

53: FROM OKC_ACTION_ATTRIBUTES_B B
54: WHERE B.ID = T.ID
55: );
56:
57: UPDATE OKC_ACTION_ATTRIBUTES_TL T SET (
58: NAME,
59: DESCRIPTION) = (SELECT
60: B.NAME,
61: B.DESCRIPTION

Line 62: FROM OKC_ACTION_ATTRIBUTES_TL B

58: NAME,
59: DESCRIPTION) = (SELECT
60: B.NAME,
61: B.DESCRIPTION
62: FROM OKC_ACTION_ATTRIBUTES_TL B
63: WHERE B.ID = T.ID
64: AND B.LANGUAGE = T.SOURCE_LANG)
65: WHERE (
66: T.ID,

Line 71: FROM OKC_ACTION_ATTRIBUTES_TL SUBB, OKC_ACTION_ATTRIBUTES_TL SUBT

67: T.LANGUAGE)
68: IN (SELECT
69: SUBT.ID,
70: SUBT.LANGUAGE
71: FROM OKC_ACTION_ATTRIBUTES_TL SUBB, OKC_ACTION_ATTRIBUTES_TL SUBT
72: WHERE SUBB.ID = SUBT.ID
73: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
74: AND (SUBB.NAME <> SUBT.NAME
75: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 81: INSERT INTO OKC_ACTION_ATTRIBUTES_TL (

77: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
78: ));
79: */
80:
81: INSERT INTO OKC_ACTION_ATTRIBUTES_TL (
82: ID,
83: LANGUAGE,
84: SOURCE_LANG,
85: SFWT_FLAG,

Line 105: FROM OKC_ACTION_ATTRIBUTES_TL B, FND_LANGUAGES L

101: B.CREATION_DATE,
102: B.LAST_UPDATED_BY,
103: B.LAST_UPDATE_DATE,
104: B.LAST_UPDATE_LOGIN
105: FROM OKC_ACTION_ATTRIBUTES_TL B, FND_LANGUAGES L
106: WHERE L.INSTALLED_FLAG IN ('I', 'B')
107: AND B.LANGUAGE = USERENV('LANG')
108: AND NOT EXISTS(
109: SELECT NULL

Line 110: FROM OKC_ACTION_ATTRIBUTES_TL T

106: WHERE L.INSTALLED_FLAG IN ('I', 'B')
107: AND B.LANGUAGE = USERENV('LANG')
108: AND NOT EXISTS(
109: SELECT NULL
110: FROM OKC_ACTION_ATTRIBUTES_TL T
111: WHERE T.ID = B.ID
112: AND T.LANGUAGE = L.LANGUAGE_CODE
113: );
114:

Line 226: -- FUNCTION get_rec for: OKC_ACTION_ATTRIBUTES_TL

222: BEGIN
223: RETURN(get_rec(p_aae_rec, l_row_notfound));
224: END get_rec;
225: ---------------------------------------------------------------------------
226: -- FUNCTION get_rec for: OKC_ACTION_ATTRIBUTES_TL
227: ---------------------------------------------------------------------------
228: FUNCTION get_rec (
229: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
230: x_no_data_found OUT NOCOPY BOOLEAN

Line 229: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,

225: ---------------------------------------------------------------------------
226: -- FUNCTION get_rec for: OKC_ACTION_ATTRIBUTES_TL
227: ---------------------------------------------------------------------------
228: FUNCTION get_rec (
229: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
230: x_no_data_found OUT NOCOPY BOOLEAN
231: ) RETURN OkcActionAttributesTlRecType IS
232: CURSOR okc_action_attribute1_csr (p_id IN NUMBER,
233: p_language IN VARCHAR2) IS

Line 246: FROM Okc_Action_Attributes_Tl

242: CREATION_DATE,
243: LAST_UPDATED_BY,
244: LAST_UPDATE_DATE,
245: LAST_UPDATE_LOGIN
246: FROM Okc_Action_Attributes_Tl
247: WHERE okc_action_attributes_tl.id = p_id
248: AND okc_action_attributes_tl.language = p_language;
249: l_okc_action_attributes_tl_pk okc_action_attribute1_csr%ROWTYPE;
250: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;

Line 247: WHERE okc_action_attributes_tl.id = p_id

243: LAST_UPDATED_BY,
244: LAST_UPDATE_DATE,
245: LAST_UPDATE_LOGIN
246: FROM Okc_Action_Attributes_Tl
247: WHERE okc_action_attributes_tl.id = p_id
248: AND okc_action_attributes_tl.language = p_language;
249: l_okc_action_attributes_tl_pk okc_action_attribute1_csr%ROWTYPE;
250: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
251: BEGIN

Line 248: AND okc_action_attributes_tl.language = p_language;

244: LAST_UPDATE_DATE,
245: LAST_UPDATE_LOGIN
246: FROM Okc_Action_Attributes_Tl
247: WHERE okc_action_attributes_tl.id = p_id
248: AND okc_action_attributes_tl.language = p_language;
249: l_okc_action_attributes_tl_pk okc_action_attribute1_csr%ROWTYPE;
250: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
251: BEGIN
252: x_no_data_found := TRUE;

Line 249: l_okc_action_attributes_tl_pk okc_action_attribute1_csr%ROWTYPE;

245: LAST_UPDATE_LOGIN
246: FROM Okc_Action_Attributes_Tl
247: WHERE okc_action_attributes_tl.id = p_id
248: AND okc_action_attributes_tl.language = p_language;
249: l_okc_action_attributes_tl_pk okc_action_attribute1_csr%ROWTYPE;
250: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
251: BEGIN
252: x_no_data_found := TRUE;
253: -- Get current database values

Line 250: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;

246: FROM Okc_Action_Attributes_Tl
247: WHERE okc_action_attributes_tl.id = p_id
248: AND okc_action_attributes_tl.language = p_language;
249: l_okc_action_attributes_tl_pk okc_action_attribute1_csr%ROWTYPE;
250: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
251: BEGIN
252: x_no_data_found := TRUE;
253: -- Get current database values
254: OPEN okc_action_attribute1_csr (p_okc_action_attributes_tl_rec.id,

Line 254: OPEN okc_action_attribute1_csr (p_okc_action_attributes_tl_rec.id,

250: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
251: BEGIN
252: x_no_data_found := TRUE;
253: -- Get current database values
254: OPEN okc_action_attribute1_csr (p_okc_action_attributes_tl_rec.id,
255: p_okc_action_attributes_tl_rec.language);
256: FETCH okc_action_attribute1_csr INTO
257: l_okc_action_attributes_tl_rec.ID,
258: l_okc_action_attributes_tl_rec.LANGUAGE,

Line 255: p_okc_action_attributes_tl_rec.language);

251: BEGIN
252: x_no_data_found := TRUE;
253: -- Get current database values
254: OPEN okc_action_attribute1_csr (p_okc_action_attributes_tl_rec.id,
255: p_okc_action_attributes_tl_rec.language);
256: FETCH okc_action_attribute1_csr INTO
257: l_okc_action_attributes_tl_rec.ID,
258: l_okc_action_attributes_tl_rec.LANGUAGE,
259: l_okc_action_attributes_tl_rec.SOURCE_LANG,

Line 257: l_okc_action_attributes_tl_rec.ID,

253: -- Get current database values
254: OPEN okc_action_attribute1_csr (p_okc_action_attributes_tl_rec.id,
255: p_okc_action_attributes_tl_rec.language);
256: FETCH okc_action_attribute1_csr INTO
257: l_okc_action_attributes_tl_rec.ID,
258: l_okc_action_attributes_tl_rec.LANGUAGE,
259: l_okc_action_attributes_tl_rec.SOURCE_LANG,
260: l_okc_action_attributes_tl_rec.SFWT_FLAG,
261: l_okc_action_attributes_tl_rec.NAME,

Line 258: l_okc_action_attributes_tl_rec.LANGUAGE,

254: OPEN okc_action_attribute1_csr (p_okc_action_attributes_tl_rec.id,
255: p_okc_action_attributes_tl_rec.language);
256: FETCH okc_action_attribute1_csr INTO
257: l_okc_action_attributes_tl_rec.ID,
258: l_okc_action_attributes_tl_rec.LANGUAGE,
259: l_okc_action_attributes_tl_rec.SOURCE_LANG,
260: l_okc_action_attributes_tl_rec.SFWT_FLAG,
261: l_okc_action_attributes_tl_rec.NAME,
262: l_okc_action_attributes_tl_rec.DESCRIPTION,

Line 259: l_okc_action_attributes_tl_rec.SOURCE_LANG,

255: p_okc_action_attributes_tl_rec.language);
256: FETCH okc_action_attribute1_csr INTO
257: l_okc_action_attributes_tl_rec.ID,
258: l_okc_action_attributes_tl_rec.LANGUAGE,
259: l_okc_action_attributes_tl_rec.SOURCE_LANG,
260: l_okc_action_attributes_tl_rec.SFWT_FLAG,
261: l_okc_action_attributes_tl_rec.NAME,
262: l_okc_action_attributes_tl_rec.DESCRIPTION,
263: l_okc_action_attributes_tl_rec.CREATED_BY,

Line 260: l_okc_action_attributes_tl_rec.SFWT_FLAG,

256: FETCH okc_action_attribute1_csr INTO
257: l_okc_action_attributes_tl_rec.ID,
258: l_okc_action_attributes_tl_rec.LANGUAGE,
259: l_okc_action_attributes_tl_rec.SOURCE_LANG,
260: l_okc_action_attributes_tl_rec.SFWT_FLAG,
261: l_okc_action_attributes_tl_rec.NAME,
262: l_okc_action_attributes_tl_rec.DESCRIPTION,
263: l_okc_action_attributes_tl_rec.CREATED_BY,
264: l_okc_action_attributes_tl_rec.CREATION_DATE,

Line 261: l_okc_action_attributes_tl_rec.NAME,

257: l_okc_action_attributes_tl_rec.ID,
258: l_okc_action_attributes_tl_rec.LANGUAGE,
259: l_okc_action_attributes_tl_rec.SOURCE_LANG,
260: l_okc_action_attributes_tl_rec.SFWT_FLAG,
261: l_okc_action_attributes_tl_rec.NAME,
262: l_okc_action_attributes_tl_rec.DESCRIPTION,
263: l_okc_action_attributes_tl_rec.CREATED_BY,
264: l_okc_action_attributes_tl_rec.CREATION_DATE,
265: l_okc_action_attributes_tl_rec.LAST_UPDATED_BY,

Line 262: l_okc_action_attributes_tl_rec.DESCRIPTION,

258: l_okc_action_attributes_tl_rec.LANGUAGE,
259: l_okc_action_attributes_tl_rec.SOURCE_LANG,
260: l_okc_action_attributes_tl_rec.SFWT_FLAG,
261: l_okc_action_attributes_tl_rec.NAME,
262: l_okc_action_attributes_tl_rec.DESCRIPTION,
263: l_okc_action_attributes_tl_rec.CREATED_BY,
264: l_okc_action_attributes_tl_rec.CREATION_DATE,
265: l_okc_action_attributes_tl_rec.LAST_UPDATED_BY,
266: l_okc_action_attributes_tl_rec.LAST_UPDATE_DATE,

Line 263: l_okc_action_attributes_tl_rec.CREATED_BY,

259: l_okc_action_attributes_tl_rec.SOURCE_LANG,
260: l_okc_action_attributes_tl_rec.SFWT_FLAG,
261: l_okc_action_attributes_tl_rec.NAME,
262: l_okc_action_attributes_tl_rec.DESCRIPTION,
263: l_okc_action_attributes_tl_rec.CREATED_BY,
264: l_okc_action_attributes_tl_rec.CREATION_DATE,
265: l_okc_action_attributes_tl_rec.LAST_UPDATED_BY,
266: l_okc_action_attributes_tl_rec.LAST_UPDATE_DATE,
267: l_okc_action_attributes_tl_rec.LAST_UPDATE_LOGIN;

Line 264: l_okc_action_attributes_tl_rec.CREATION_DATE,

260: l_okc_action_attributes_tl_rec.SFWT_FLAG,
261: l_okc_action_attributes_tl_rec.NAME,
262: l_okc_action_attributes_tl_rec.DESCRIPTION,
263: l_okc_action_attributes_tl_rec.CREATED_BY,
264: l_okc_action_attributes_tl_rec.CREATION_DATE,
265: l_okc_action_attributes_tl_rec.LAST_UPDATED_BY,
266: l_okc_action_attributes_tl_rec.LAST_UPDATE_DATE,
267: l_okc_action_attributes_tl_rec.LAST_UPDATE_LOGIN;
268: x_no_data_found := okc_action_attribute1_csr%NOTFOUND;

Line 265: l_okc_action_attributes_tl_rec.LAST_UPDATED_BY,

261: l_okc_action_attributes_tl_rec.NAME,
262: l_okc_action_attributes_tl_rec.DESCRIPTION,
263: l_okc_action_attributes_tl_rec.CREATED_BY,
264: l_okc_action_attributes_tl_rec.CREATION_DATE,
265: l_okc_action_attributes_tl_rec.LAST_UPDATED_BY,
266: l_okc_action_attributes_tl_rec.LAST_UPDATE_DATE,
267: l_okc_action_attributes_tl_rec.LAST_UPDATE_LOGIN;
268: x_no_data_found := okc_action_attribute1_csr%NOTFOUND;
269: CLOSE okc_action_attribute1_csr;

Line 266: l_okc_action_attributes_tl_rec.LAST_UPDATE_DATE,

262: l_okc_action_attributes_tl_rec.DESCRIPTION,
263: l_okc_action_attributes_tl_rec.CREATED_BY,
264: l_okc_action_attributes_tl_rec.CREATION_DATE,
265: l_okc_action_attributes_tl_rec.LAST_UPDATED_BY,
266: l_okc_action_attributes_tl_rec.LAST_UPDATE_DATE,
267: l_okc_action_attributes_tl_rec.LAST_UPDATE_LOGIN;
268: x_no_data_found := okc_action_attribute1_csr%NOTFOUND;
269: CLOSE okc_action_attribute1_csr;
270: RETURN(l_okc_action_attributes_tl_rec);

Line 267: l_okc_action_attributes_tl_rec.LAST_UPDATE_LOGIN;

263: l_okc_action_attributes_tl_rec.CREATED_BY,
264: l_okc_action_attributes_tl_rec.CREATION_DATE,
265: l_okc_action_attributes_tl_rec.LAST_UPDATED_BY,
266: l_okc_action_attributes_tl_rec.LAST_UPDATE_DATE,
267: l_okc_action_attributes_tl_rec.LAST_UPDATE_LOGIN;
268: x_no_data_found := okc_action_attribute1_csr%NOTFOUND;
269: CLOSE okc_action_attribute1_csr;
270: RETURN(l_okc_action_attributes_tl_rec);
271: END get_rec;

Line 270: RETURN(l_okc_action_attributes_tl_rec);

266: l_okc_action_attributes_tl_rec.LAST_UPDATE_DATE,
267: l_okc_action_attributes_tl_rec.LAST_UPDATE_LOGIN;
268: x_no_data_found := okc_action_attribute1_csr%NOTFOUND;
269: CLOSE okc_action_attribute1_csr;
270: RETURN(l_okc_action_attributes_tl_rec);
271: END get_rec;
272:
273: FUNCTION get_rec (
274: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType

Line 274: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType

270: RETURN(l_okc_action_attributes_tl_rec);
271: END get_rec;
272:
273: FUNCTION get_rec (
274: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType
275: ) RETURN OkcActionAttributesTlRecType IS
276: l_row_notfound BOOLEAN := TRUE;
277: BEGIN
278: RETURN(get_rec(p_okc_action_attributes_tl_rec, l_row_notfound));

Line 278: RETURN(get_rec(p_okc_action_attributes_tl_rec, l_row_notfound));

274: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType
275: ) RETURN OkcActionAttributesTlRecType IS
276: l_row_notfound BOOLEAN := TRUE;
277: BEGIN
278: RETURN(get_rec(p_okc_action_attributes_tl_rec, l_row_notfound));
279: END get_rec;
280: ---------------------------------------------------------------------------
281: -- FUNCTION get_rec for: OKC_ACTION_ATTRIBUTES_V
282: ---------------------------------------------------------------------------

Line 2484: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;

2480: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
2481: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2482: l_aaev_rec aaev_rec_type := p_aaev_rec;
2483: l_aae_rec aae_rec_type;
2484: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
2485: BEGIN
2486: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2487: G_PKG_NAME,
2488: p_init_msg_list,

Line 2777: -- insert_row for:OKC_ACTION_ATTRIBUTES_TL --

2773: '_PVT'
2774: );
2775: END insert_row;
2776: ---------------------------------------------
2777: -- insert_row for:OKC_ACTION_ATTRIBUTES_TL --
2778: ---------------------------------------------
2779: PROCEDURE insert_row(
2780: p_init_msg_list IN VARCHAR2 ,
2781: x_return_status OUT NOCOPY VARCHAR2,

Line 2784: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,

2780: p_init_msg_list IN VARCHAR2 ,
2781: x_return_status OUT NOCOPY VARCHAR2,
2782: x_msg_count OUT NOCOPY NUMBER,
2783: x_msg_data OUT NOCOPY VARCHAR2,
2784: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
2785: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType) IS
2786:
2787: l_api_version CONSTANT NUMBER := 1;
2788: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 2785: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType) IS

2781: x_return_status OUT NOCOPY VARCHAR2,
2782: x_msg_count OUT NOCOPY NUMBER,
2783: x_msg_data OUT NOCOPY VARCHAR2,
2784: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
2785: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType) IS
2786:
2787: l_api_version CONSTANT NUMBER := 1;
2788: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2789: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2790: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType := p_okc_action_attributes_tl_rec;

2786:
2787: l_api_version CONSTANT NUMBER := 1;
2788: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2789: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2790: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType := p_okc_action_attributes_tl_rec;
2791: ldefokcactionattributestlrec OkcActionAttributesTlRecType;
2792: CURSOR get_languages IS
2793: SELECT *
2794: FROM FND_LANGUAGES

Line 2797: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --

2793: SELECT *
2794: FROM FND_LANGUAGES
2795: WHERE INSTALLED_FLAG IN ('I', 'B');
2796: -------------------------------------------------
2797: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --
2798: -------------------------------------------------
2799: FUNCTION Set_Attributes (
2800: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
2801: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType

Line 2800: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,

2796: -------------------------------------------------
2797: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --
2798: -------------------------------------------------
2799: FUNCTION Set_Attributes (
2800: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
2801: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
2802: ) RETURN VARCHAR2 IS
2803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2804: BEGIN

Line 2801: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType

2797: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --
2798: -------------------------------------------------
2799: FUNCTION Set_Attributes (
2800: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
2801: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
2802: ) RETURN VARCHAR2 IS
2803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2804: BEGIN
2805: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;

Line 2805: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;

2801: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
2802: ) RETURN VARCHAR2 IS
2803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2804: BEGIN
2805: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;
2806: x_okc_action_attributes_tl_rec.LANGUAGE := l_lang;
2807: x_okc_action_attributes_tl_rec.SOURCE_LANG := l_lang;
2808: RETURN(l_return_status);
2809: END Set_Attributes;

Line 2806: x_okc_action_attributes_tl_rec.LANGUAGE := l_lang;

2802: ) RETURN VARCHAR2 IS
2803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2804: BEGIN
2805: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;
2806: x_okc_action_attributes_tl_rec.LANGUAGE := l_lang;
2807: x_okc_action_attributes_tl_rec.SOURCE_LANG := l_lang;
2808: RETURN(l_return_status);
2809: END Set_Attributes;
2810: BEGIN

Line 2807: x_okc_action_attributes_tl_rec.SOURCE_LANG := l_lang;

2803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2804: BEGIN
2805: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;
2806: x_okc_action_attributes_tl_rec.LANGUAGE := l_lang;
2807: x_okc_action_attributes_tl_rec.SOURCE_LANG := l_lang;
2808: RETURN(l_return_status);
2809: END Set_Attributes;
2810: BEGIN
2811: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2822: p_okc_action_attributes_tl_rec, -- IN

2818: RAISE OKC_API.G_EXCEPTION_ERROR;
2819: END IF;
2820: --- Setting item attributes
2821: l_return_status := Set_Attributes(
2822: p_okc_action_attributes_tl_rec, -- IN
2823: l_okc_action_attributes_tl_rec); -- OUT
2824: --- If any errors happen abort API
2825: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2823: l_okc_action_attributes_tl_rec); -- OUT

2819: END IF;
2820: --- Setting item attributes
2821: l_return_status := Set_Attributes(
2822: p_okc_action_attributes_tl_rec, -- IN
2823: l_okc_action_attributes_tl_rec); -- OUT
2824: --- If any errors happen abort API
2825: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2827: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2831: l_okc_action_attributes_tl_rec.language := l_lang_rec.language_code;

2827: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2828: RAISE OKC_API.G_EXCEPTION_ERROR;
2829: END IF;
2830: FOR l_lang_rec IN get_languages LOOP
2831: l_okc_action_attributes_tl_rec.language := l_lang_rec.language_code;
2832: INSERT INTO OKC_ACTION_ATTRIBUTES_TL(
2833: id,
2834: language,
2835: source_lang,

Line 2832: INSERT INTO OKC_ACTION_ATTRIBUTES_TL(

2828: RAISE OKC_API.G_EXCEPTION_ERROR;
2829: END IF;
2830: FOR l_lang_rec IN get_languages LOOP
2831: l_okc_action_attributes_tl_rec.language := l_lang_rec.language_code;
2832: INSERT INTO OKC_ACTION_ATTRIBUTES_TL(
2833: id,
2834: language,
2835: source_lang,
2836: sfwt_flag,

Line 2845: l_okc_action_attributes_tl_rec.id,

2841: last_updated_by,
2842: last_update_date,
2843: last_update_login)
2844: VALUES (
2845: l_okc_action_attributes_tl_rec.id,
2846: l_okc_action_attributes_tl_rec.language,
2847: l_okc_action_attributes_tl_rec.source_lang,
2848: l_okc_action_attributes_tl_rec.sfwt_flag,
2849: l_okc_action_attributes_tl_rec.name,

Line 2846: l_okc_action_attributes_tl_rec.language,

2842: last_update_date,
2843: last_update_login)
2844: VALUES (
2845: l_okc_action_attributes_tl_rec.id,
2846: l_okc_action_attributes_tl_rec.language,
2847: l_okc_action_attributes_tl_rec.source_lang,
2848: l_okc_action_attributes_tl_rec.sfwt_flag,
2849: l_okc_action_attributes_tl_rec.name,
2850: l_okc_action_attributes_tl_rec.description,

Line 2847: l_okc_action_attributes_tl_rec.source_lang,

2843: last_update_login)
2844: VALUES (
2845: l_okc_action_attributes_tl_rec.id,
2846: l_okc_action_attributes_tl_rec.language,
2847: l_okc_action_attributes_tl_rec.source_lang,
2848: l_okc_action_attributes_tl_rec.sfwt_flag,
2849: l_okc_action_attributes_tl_rec.name,
2850: l_okc_action_attributes_tl_rec.description,
2851: l_okc_action_attributes_tl_rec.created_by,

Line 2848: l_okc_action_attributes_tl_rec.sfwt_flag,

2844: VALUES (
2845: l_okc_action_attributes_tl_rec.id,
2846: l_okc_action_attributes_tl_rec.language,
2847: l_okc_action_attributes_tl_rec.source_lang,
2848: l_okc_action_attributes_tl_rec.sfwt_flag,
2849: l_okc_action_attributes_tl_rec.name,
2850: l_okc_action_attributes_tl_rec.description,
2851: l_okc_action_attributes_tl_rec.created_by,
2852: l_okc_action_attributes_tl_rec.creation_date,

Line 2849: l_okc_action_attributes_tl_rec.name,

2845: l_okc_action_attributes_tl_rec.id,
2846: l_okc_action_attributes_tl_rec.language,
2847: l_okc_action_attributes_tl_rec.source_lang,
2848: l_okc_action_attributes_tl_rec.sfwt_flag,
2849: l_okc_action_attributes_tl_rec.name,
2850: l_okc_action_attributes_tl_rec.description,
2851: l_okc_action_attributes_tl_rec.created_by,
2852: l_okc_action_attributes_tl_rec.creation_date,
2853: l_okc_action_attributes_tl_rec.last_updated_by,

Line 2850: l_okc_action_attributes_tl_rec.description,

2846: l_okc_action_attributes_tl_rec.language,
2847: l_okc_action_attributes_tl_rec.source_lang,
2848: l_okc_action_attributes_tl_rec.sfwt_flag,
2849: l_okc_action_attributes_tl_rec.name,
2850: l_okc_action_attributes_tl_rec.description,
2851: l_okc_action_attributes_tl_rec.created_by,
2852: l_okc_action_attributes_tl_rec.creation_date,
2853: l_okc_action_attributes_tl_rec.last_updated_by,
2854: l_okc_action_attributes_tl_rec.last_update_date,

Line 2851: l_okc_action_attributes_tl_rec.created_by,

2847: l_okc_action_attributes_tl_rec.source_lang,
2848: l_okc_action_attributes_tl_rec.sfwt_flag,
2849: l_okc_action_attributes_tl_rec.name,
2850: l_okc_action_attributes_tl_rec.description,
2851: l_okc_action_attributes_tl_rec.created_by,
2852: l_okc_action_attributes_tl_rec.creation_date,
2853: l_okc_action_attributes_tl_rec.last_updated_by,
2854: l_okc_action_attributes_tl_rec.last_update_date,
2855: l_okc_action_attributes_tl_rec.last_update_login);

Line 2852: l_okc_action_attributes_tl_rec.creation_date,

2848: l_okc_action_attributes_tl_rec.sfwt_flag,
2849: l_okc_action_attributes_tl_rec.name,
2850: l_okc_action_attributes_tl_rec.description,
2851: l_okc_action_attributes_tl_rec.created_by,
2852: l_okc_action_attributes_tl_rec.creation_date,
2853: l_okc_action_attributes_tl_rec.last_updated_by,
2854: l_okc_action_attributes_tl_rec.last_update_date,
2855: l_okc_action_attributes_tl_rec.last_update_login);
2856: END LOOP;

Line 2853: l_okc_action_attributes_tl_rec.last_updated_by,

2849: l_okc_action_attributes_tl_rec.name,
2850: l_okc_action_attributes_tl_rec.description,
2851: l_okc_action_attributes_tl_rec.created_by,
2852: l_okc_action_attributes_tl_rec.creation_date,
2853: l_okc_action_attributes_tl_rec.last_updated_by,
2854: l_okc_action_attributes_tl_rec.last_update_date,
2855: l_okc_action_attributes_tl_rec.last_update_login);
2856: END LOOP;
2857: -- Set OUT values

Line 2854: l_okc_action_attributes_tl_rec.last_update_date,

2850: l_okc_action_attributes_tl_rec.description,
2851: l_okc_action_attributes_tl_rec.created_by,
2852: l_okc_action_attributes_tl_rec.creation_date,
2853: l_okc_action_attributes_tl_rec.last_updated_by,
2854: l_okc_action_attributes_tl_rec.last_update_date,
2855: l_okc_action_attributes_tl_rec.last_update_login);
2856: END LOOP;
2857: -- Set OUT values
2858: x_okc_action_attributes_tl_rec := l_okc_action_attributes_tl_rec;

Line 2855: l_okc_action_attributes_tl_rec.last_update_login);

2851: l_okc_action_attributes_tl_rec.created_by,
2852: l_okc_action_attributes_tl_rec.creation_date,
2853: l_okc_action_attributes_tl_rec.last_updated_by,
2854: l_okc_action_attributes_tl_rec.last_update_date,
2855: l_okc_action_attributes_tl_rec.last_update_login);
2856: END LOOP;
2857: -- Set OUT values
2858: x_okc_action_attributes_tl_rec := l_okc_action_attributes_tl_rec;
2859: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2858: x_okc_action_attributes_tl_rec := l_okc_action_attributes_tl_rec;

2854: l_okc_action_attributes_tl_rec.last_update_date,
2855: l_okc_action_attributes_tl_rec.last_update_login);
2856: END LOOP;
2857: -- Set OUT values
2858: x_okc_action_attributes_tl_rec := l_okc_action_attributes_tl_rec;
2859: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2860: EXCEPTION
2861: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2862: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2912: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;

2908: l_aaev_rec aaev_rec_type;
2909: l_def_aaev_rec aaev_rec_type;
2910: l_aae_rec aae_rec_type;
2911: lx_aae_rec aae_rec_type;
2912: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
2913: LxOkcActionAttributesTlRec OkcActionAttributesTlRecType;
2914: -------------------------------
2915: -- FUNCTION fill_who_columns --
2916: -------------------------------

Line 2997: migrate(l_def_aaev_rec, l_okc_action_attributes_tl_rec);

2993: --------------------------------------
2994: -- Move VIEW record to "Child" records
2995: --------------------------------------
2996: migrate(l_def_aaev_rec, l_aae_rec);
2997: migrate(l_def_aaev_rec, l_okc_action_attributes_tl_rec);
2998: --------------------------------------------
2999: -- Call the INSERT_ROW for each child record
3000: --------------------------------------------
3001: insert_row(

Line 3020: l_okc_action_attributes_tl_rec,

3016: p_init_msg_list,
3017: x_return_status,
3018: x_msg_count,
3019: x_msg_data,
3020: l_okc_action_attributes_tl_rec,
3021: LxOkcActionAttributesTlRec
3022: );
3023: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3024: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3241: -- lock_row for:OKC_ACTION_ATTRIBUTES_TL --

3237: '_PVT'
3238: );
3239: END lock_row;
3240: -------------------------------------------
3241: -- lock_row for:OKC_ACTION_ATTRIBUTES_TL --
3242: -------------------------------------------
3243: PROCEDURE lock_row(
3244: p_init_msg_list IN VARCHAR2 ,
3245: x_return_status OUT NOCOPY VARCHAR2,

Line 3248: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType) IS

3244: p_init_msg_list IN VARCHAR2 ,
3245: x_return_status OUT NOCOPY VARCHAR2,
3246: x_msg_count OUT NOCOPY NUMBER,
3247: x_msg_data OUT NOCOPY VARCHAR2,
3248: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType) IS
3249:
3250: E_Resource_Busy EXCEPTION;
3251: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3252: CURSOR lock_csr (p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType) IS

Line 3252: CURSOR lock_csr (p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType) IS

3248: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType) IS
3249:
3250: E_Resource_Busy EXCEPTION;
3251: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3252: CURSOR lock_csr (p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType) IS
3253: SELECT *
3254: FROM OKC_ACTION_ATTRIBUTES_TL
3255: WHERE ID = p_okc_action_attributes_tl_rec.id
3256: FOR UPDATE NOWAIT;

Line 3254: FROM OKC_ACTION_ATTRIBUTES_TL

3250: E_Resource_Busy EXCEPTION;
3251: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3252: CURSOR lock_csr (p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType) IS
3253: SELECT *
3254: FROM OKC_ACTION_ATTRIBUTES_TL
3255: WHERE ID = p_okc_action_attributes_tl_rec.id
3256: FOR UPDATE NOWAIT;
3257:
3258: l_api_version CONSTANT NUMBER := 1;

Line 3255: WHERE ID = p_okc_action_attributes_tl_rec.id

3251: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3252: CURSOR lock_csr (p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType) IS
3253: SELECT *
3254: FROM OKC_ACTION_ATTRIBUTES_TL
3255: WHERE ID = p_okc_action_attributes_tl_rec.id
3256: FOR UPDATE NOWAIT;
3257:
3258: l_api_version CONSTANT NUMBER := 1;
3259: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 3275: OPEN lock_csr(p_okc_action_attributes_tl_rec);

3271: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3272: RAISE OKC_API.G_EXCEPTION_ERROR;
3273: END IF;
3274: BEGIN
3275: OPEN lock_csr(p_okc_action_attributes_tl_rec);
3276: FETCH lock_csr INTO l_lock_var;
3277: l_row_notfound := lock_csr%NOTFOUND;
3278: CLOSE lock_csr;
3279: EXCEPTION

Line 3340: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;

3336: l_api_version CONSTANT NUMBER := 1;
3337: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
3338: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3339: l_aae_rec aae_rec_type;
3340: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
3341: BEGIN
3342: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3343: G_PKG_NAME,
3344: p_init_msg_list,

Line 3358: migrate(p_aaev_rec, l_okc_action_attributes_tl_rec);

3354: --------------------------------------
3355: -- Move VIEW record to "Child" records
3356: --------------------------------------
3357: migrate(p_aaev_rec, l_aae_rec);
3358: migrate(p_aaev_rec, l_okc_action_attributes_tl_rec);
3359: --------------------------------------------
3360: -- Call the LOCK_ROW for each child record
3361: --------------------------------------------
3362: lock_row(

Line 3379: l_okc_action_attributes_tl_rec

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

Line 3793: -- update_row for:OKC_ACTION_ATTRIBUTES_TL --

3789: '_PVT'
3790: );
3791: END update_row;
3792: ---------------------------------------------
3793: -- update_row for:OKC_ACTION_ATTRIBUTES_TL --
3794: ---------------------------------------------
3795: PROCEDURE update_row(
3796: p_init_msg_list IN VARCHAR2 ,
3797: x_return_status OUT NOCOPY VARCHAR2,

Line 3800: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,

3796: p_init_msg_list IN VARCHAR2 ,
3797: x_return_status OUT NOCOPY VARCHAR2,
3798: x_msg_count OUT NOCOPY NUMBER,
3799: x_msg_data OUT NOCOPY VARCHAR2,
3800: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
3801: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType) IS
3802:
3803: l_api_version CONSTANT NUMBER := 1;
3804: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 3801: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType) IS

3797: x_return_status OUT NOCOPY VARCHAR2,
3798: x_msg_count OUT NOCOPY NUMBER,
3799: x_msg_data OUT NOCOPY VARCHAR2,
3800: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
3801: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType) IS
3802:
3803: l_api_version CONSTANT NUMBER := 1;
3804: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3805: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3806: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType := p_okc_action_attributes_tl_rec;

3802:
3803: l_api_version CONSTANT NUMBER := 1;
3804: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3805: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3806: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType := p_okc_action_attributes_tl_rec;
3807: ldefokcactionattributestlrec OkcActionAttributesTlRecType;
3808: l_row_notfound BOOLEAN := TRUE;
3809: ----------------------------------
3810: -- FUNCTION populate_new_record --

Line 3813: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,

3809: ----------------------------------
3810: -- FUNCTION populate_new_record --
3811: ----------------------------------
3812: FUNCTION populate_new_record (
3813: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
3814: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
3815: ) RETURN VARCHAR2 IS
3816: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
3817: l_row_notfound BOOLEAN := TRUE;

Line 3814: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType

3810: -- FUNCTION populate_new_record --
3811: ----------------------------------
3812: FUNCTION populate_new_record (
3813: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
3814: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
3815: ) RETURN VARCHAR2 IS
3816: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
3817: l_row_notfound BOOLEAN := TRUE;
3818: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3816: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;

3812: FUNCTION populate_new_record (
3813: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
3814: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
3815: ) RETURN VARCHAR2 IS
3816: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
3817: l_row_notfound BOOLEAN := TRUE;
3818: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3819: BEGIN
3820: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;

Line 3820: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;

3816: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
3817: l_row_notfound BOOLEAN := TRUE;
3818: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3819: BEGIN
3820: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;
3821: -- Get current database values
3822: l_okc_action_attributes_tl_rec := get_rec(p_okc_action_attributes_tl_rec, l_row_notfound);
3823: IF (l_row_notfound) THEN
3824: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 3822: l_okc_action_attributes_tl_rec := get_rec(p_okc_action_attributes_tl_rec, l_row_notfound);

3818: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3819: BEGIN
3820: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;
3821: -- Get current database values
3822: l_okc_action_attributes_tl_rec := get_rec(p_okc_action_attributes_tl_rec, l_row_notfound);
3823: IF (l_row_notfound) THEN
3824: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3825: END IF;
3826: IF (x_okc_action_attributes_tl_rec.id = OKC_API.G_MISS_NUM)

Line 3826: IF (x_okc_action_attributes_tl_rec.id = OKC_API.G_MISS_NUM)

3822: l_okc_action_attributes_tl_rec := get_rec(p_okc_action_attributes_tl_rec, l_row_notfound);
3823: IF (l_row_notfound) THEN
3824: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3825: END IF;
3826: IF (x_okc_action_attributes_tl_rec.id = OKC_API.G_MISS_NUM)
3827: THEN
3828: x_okc_action_attributes_tl_rec.id := l_okc_action_attributes_tl_rec.id;
3829: END IF;
3830: IF (x_okc_action_attributes_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 3828: x_okc_action_attributes_tl_rec.id := l_okc_action_attributes_tl_rec.id;

3824: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3825: END IF;
3826: IF (x_okc_action_attributes_tl_rec.id = OKC_API.G_MISS_NUM)
3827: THEN
3828: x_okc_action_attributes_tl_rec.id := l_okc_action_attributes_tl_rec.id;
3829: END IF;
3830: IF (x_okc_action_attributes_tl_rec.language = OKC_API.G_MISS_CHAR)
3831: THEN
3832: x_okc_action_attributes_tl_rec.language := l_okc_action_attributes_tl_rec.language;

Line 3830: IF (x_okc_action_attributes_tl_rec.language = OKC_API.G_MISS_CHAR)

3826: IF (x_okc_action_attributes_tl_rec.id = OKC_API.G_MISS_NUM)
3827: THEN
3828: x_okc_action_attributes_tl_rec.id := l_okc_action_attributes_tl_rec.id;
3829: END IF;
3830: IF (x_okc_action_attributes_tl_rec.language = OKC_API.G_MISS_CHAR)
3831: THEN
3832: x_okc_action_attributes_tl_rec.language := l_okc_action_attributes_tl_rec.language;
3833: END IF;
3834: IF (x_okc_action_attributes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 3832: x_okc_action_attributes_tl_rec.language := l_okc_action_attributes_tl_rec.language;

3828: x_okc_action_attributes_tl_rec.id := l_okc_action_attributes_tl_rec.id;
3829: END IF;
3830: IF (x_okc_action_attributes_tl_rec.language = OKC_API.G_MISS_CHAR)
3831: THEN
3832: x_okc_action_attributes_tl_rec.language := l_okc_action_attributes_tl_rec.language;
3833: END IF;
3834: IF (x_okc_action_attributes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3835: THEN
3836: x_okc_action_attributes_tl_rec.source_lang := l_okc_action_attributes_tl_rec.source_lang;

Line 3834: IF (x_okc_action_attributes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

3830: IF (x_okc_action_attributes_tl_rec.language = OKC_API.G_MISS_CHAR)
3831: THEN
3832: x_okc_action_attributes_tl_rec.language := l_okc_action_attributes_tl_rec.language;
3833: END IF;
3834: IF (x_okc_action_attributes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3835: THEN
3836: x_okc_action_attributes_tl_rec.source_lang := l_okc_action_attributes_tl_rec.source_lang;
3837: END IF;
3838: IF (x_okc_action_attributes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 3836: x_okc_action_attributes_tl_rec.source_lang := l_okc_action_attributes_tl_rec.source_lang;

3832: x_okc_action_attributes_tl_rec.language := l_okc_action_attributes_tl_rec.language;
3833: END IF;
3834: IF (x_okc_action_attributes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3835: THEN
3836: x_okc_action_attributes_tl_rec.source_lang := l_okc_action_attributes_tl_rec.source_lang;
3837: END IF;
3838: IF (x_okc_action_attributes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3839: THEN
3840: x_okc_action_attributes_tl_rec.sfwt_flag := l_okc_action_attributes_tl_rec.sfwt_flag;

Line 3838: IF (x_okc_action_attributes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

3834: IF (x_okc_action_attributes_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3835: THEN
3836: x_okc_action_attributes_tl_rec.source_lang := l_okc_action_attributes_tl_rec.source_lang;
3837: END IF;
3838: IF (x_okc_action_attributes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3839: THEN
3840: x_okc_action_attributes_tl_rec.sfwt_flag := l_okc_action_attributes_tl_rec.sfwt_flag;
3841: END IF;
3842: IF (x_okc_action_attributes_tl_rec.name = OKC_API.G_MISS_CHAR)

Line 3840: x_okc_action_attributes_tl_rec.sfwt_flag := l_okc_action_attributes_tl_rec.sfwt_flag;

3836: x_okc_action_attributes_tl_rec.source_lang := l_okc_action_attributes_tl_rec.source_lang;
3837: END IF;
3838: IF (x_okc_action_attributes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3839: THEN
3840: x_okc_action_attributes_tl_rec.sfwt_flag := l_okc_action_attributes_tl_rec.sfwt_flag;
3841: END IF;
3842: IF (x_okc_action_attributes_tl_rec.name = OKC_API.G_MISS_CHAR)
3843: THEN
3844: x_okc_action_attributes_tl_rec.name := l_okc_action_attributes_tl_rec.name;

Line 3842: IF (x_okc_action_attributes_tl_rec.name = OKC_API.G_MISS_CHAR)

3838: IF (x_okc_action_attributes_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3839: THEN
3840: x_okc_action_attributes_tl_rec.sfwt_flag := l_okc_action_attributes_tl_rec.sfwt_flag;
3841: END IF;
3842: IF (x_okc_action_attributes_tl_rec.name = OKC_API.G_MISS_CHAR)
3843: THEN
3844: x_okc_action_attributes_tl_rec.name := l_okc_action_attributes_tl_rec.name;
3845: END IF;
3846: IF (x_okc_action_attributes_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 3844: x_okc_action_attributes_tl_rec.name := l_okc_action_attributes_tl_rec.name;

3840: x_okc_action_attributes_tl_rec.sfwt_flag := l_okc_action_attributes_tl_rec.sfwt_flag;
3841: END IF;
3842: IF (x_okc_action_attributes_tl_rec.name = OKC_API.G_MISS_CHAR)
3843: THEN
3844: x_okc_action_attributes_tl_rec.name := l_okc_action_attributes_tl_rec.name;
3845: END IF;
3846: IF (x_okc_action_attributes_tl_rec.description = OKC_API.G_MISS_CHAR)
3847: THEN
3848: x_okc_action_attributes_tl_rec.description := l_okc_action_attributes_tl_rec.description;

Line 3846: IF (x_okc_action_attributes_tl_rec.description = OKC_API.G_MISS_CHAR)

3842: IF (x_okc_action_attributes_tl_rec.name = OKC_API.G_MISS_CHAR)
3843: THEN
3844: x_okc_action_attributes_tl_rec.name := l_okc_action_attributes_tl_rec.name;
3845: END IF;
3846: IF (x_okc_action_attributes_tl_rec.description = OKC_API.G_MISS_CHAR)
3847: THEN
3848: x_okc_action_attributes_tl_rec.description := l_okc_action_attributes_tl_rec.description;
3849: END IF;
3850: IF (x_okc_action_attributes_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 3848: x_okc_action_attributes_tl_rec.description := l_okc_action_attributes_tl_rec.description;

3844: x_okc_action_attributes_tl_rec.name := l_okc_action_attributes_tl_rec.name;
3845: END IF;
3846: IF (x_okc_action_attributes_tl_rec.description = OKC_API.G_MISS_CHAR)
3847: THEN
3848: x_okc_action_attributes_tl_rec.description := l_okc_action_attributes_tl_rec.description;
3849: END IF;
3850: IF (x_okc_action_attributes_tl_rec.created_by = OKC_API.G_MISS_NUM)
3851: THEN
3852: x_okc_action_attributes_tl_rec.created_by := l_okc_action_attributes_tl_rec.created_by;

Line 3850: IF (x_okc_action_attributes_tl_rec.created_by = OKC_API.G_MISS_NUM)

3846: IF (x_okc_action_attributes_tl_rec.description = OKC_API.G_MISS_CHAR)
3847: THEN
3848: x_okc_action_attributes_tl_rec.description := l_okc_action_attributes_tl_rec.description;
3849: END IF;
3850: IF (x_okc_action_attributes_tl_rec.created_by = OKC_API.G_MISS_NUM)
3851: THEN
3852: x_okc_action_attributes_tl_rec.created_by := l_okc_action_attributes_tl_rec.created_by;
3853: END IF;
3854: IF (x_okc_action_attributes_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 3852: x_okc_action_attributes_tl_rec.created_by := l_okc_action_attributes_tl_rec.created_by;

3848: x_okc_action_attributes_tl_rec.description := l_okc_action_attributes_tl_rec.description;
3849: END IF;
3850: IF (x_okc_action_attributes_tl_rec.created_by = OKC_API.G_MISS_NUM)
3851: THEN
3852: x_okc_action_attributes_tl_rec.created_by := l_okc_action_attributes_tl_rec.created_by;
3853: END IF;
3854: IF (x_okc_action_attributes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3855: THEN
3856: x_okc_action_attributes_tl_rec.creation_date := l_okc_action_attributes_tl_rec.creation_date;

Line 3854: IF (x_okc_action_attributes_tl_rec.creation_date = OKC_API.G_MISS_DATE)

3850: IF (x_okc_action_attributes_tl_rec.created_by = OKC_API.G_MISS_NUM)
3851: THEN
3852: x_okc_action_attributes_tl_rec.created_by := l_okc_action_attributes_tl_rec.created_by;
3853: END IF;
3854: IF (x_okc_action_attributes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3855: THEN
3856: x_okc_action_attributes_tl_rec.creation_date := l_okc_action_attributes_tl_rec.creation_date;
3857: END IF;
3858: IF (x_okc_action_attributes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 3856: x_okc_action_attributes_tl_rec.creation_date := l_okc_action_attributes_tl_rec.creation_date;

3852: x_okc_action_attributes_tl_rec.created_by := l_okc_action_attributes_tl_rec.created_by;
3853: END IF;
3854: IF (x_okc_action_attributes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3855: THEN
3856: x_okc_action_attributes_tl_rec.creation_date := l_okc_action_attributes_tl_rec.creation_date;
3857: END IF;
3858: IF (x_okc_action_attributes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3859: THEN
3860: x_okc_action_attributes_tl_rec.last_updated_by := l_okc_action_attributes_tl_rec.last_updated_by;

Line 3858: IF (x_okc_action_attributes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

3854: IF (x_okc_action_attributes_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3855: THEN
3856: x_okc_action_attributes_tl_rec.creation_date := l_okc_action_attributes_tl_rec.creation_date;
3857: END IF;
3858: IF (x_okc_action_attributes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3859: THEN
3860: x_okc_action_attributes_tl_rec.last_updated_by := l_okc_action_attributes_tl_rec.last_updated_by;
3861: END IF;
3862: IF (x_okc_action_attributes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 3860: x_okc_action_attributes_tl_rec.last_updated_by := l_okc_action_attributes_tl_rec.last_updated_by;

3856: x_okc_action_attributes_tl_rec.creation_date := l_okc_action_attributes_tl_rec.creation_date;
3857: END IF;
3858: IF (x_okc_action_attributes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3859: THEN
3860: x_okc_action_attributes_tl_rec.last_updated_by := l_okc_action_attributes_tl_rec.last_updated_by;
3861: END IF;
3862: IF (x_okc_action_attributes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3863: THEN
3864: x_okc_action_attributes_tl_rec.last_update_date := l_okc_action_attributes_tl_rec.last_update_date;

Line 3862: IF (x_okc_action_attributes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

3858: IF (x_okc_action_attributes_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3859: THEN
3860: x_okc_action_attributes_tl_rec.last_updated_by := l_okc_action_attributes_tl_rec.last_updated_by;
3861: END IF;
3862: IF (x_okc_action_attributes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3863: THEN
3864: x_okc_action_attributes_tl_rec.last_update_date := l_okc_action_attributes_tl_rec.last_update_date;
3865: END IF;
3866: IF (x_okc_action_attributes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 3864: x_okc_action_attributes_tl_rec.last_update_date := l_okc_action_attributes_tl_rec.last_update_date;

3860: x_okc_action_attributes_tl_rec.last_updated_by := l_okc_action_attributes_tl_rec.last_updated_by;
3861: END IF;
3862: IF (x_okc_action_attributes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3863: THEN
3864: x_okc_action_attributes_tl_rec.last_update_date := l_okc_action_attributes_tl_rec.last_update_date;
3865: END IF;
3866: IF (x_okc_action_attributes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3867: THEN
3868: x_okc_action_attributes_tl_rec.last_update_login := l_okc_action_attributes_tl_rec.last_update_login;

Line 3866: IF (x_okc_action_attributes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

3862: IF (x_okc_action_attributes_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3863: THEN
3864: x_okc_action_attributes_tl_rec.last_update_date := l_okc_action_attributes_tl_rec.last_update_date;
3865: END IF;
3866: IF (x_okc_action_attributes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3867: THEN
3868: x_okc_action_attributes_tl_rec.last_update_login := l_okc_action_attributes_tl_rec.last_update_login;
3869: END IF;
3870: RETURN(l_return_status);

Line 3868: x_okc_action_attributes_tl_rec.last_update_login := l_okc_action_attributes_tl_rec.last_update_login;

3864: x_okc_action_attributes_tl_rec.last_update_date := l_okc_action_attributes_tl_rec.last_update_date;
3865: END IF;
3866: IF (x_okc_action_attributes_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3867: THEN
3868: x_okc_action_attributes_tl_rec.last_update_login := l_okc_action_attributes_tl_rec.last_update_login;
3869: END IF;
3870: RETURN(l_return_status);
3871: END populate_new_record;
3872: -------------------------------------------------

Line 3873: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --

3869: END IF;
3870: RETURN(l_return_status);
3871: END populate_new_record;
3872: -------------------------------------------------
3873: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --
3874: -------------------------------------------------
3875: FUNCTION Set_Attributes (
3876: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
3877: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType

Line 3876: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,

3872: -------------------------------------------------
3873: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --
3874: -------------------------------------------------
3875: FUNCTION Set_Attributes (
3876: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
3877: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
3878: ) RETURN VARCHAR2 IS
3879: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3880: BEGIN

Line 3877: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType

3873: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --
3874: -------------------------------------------------
3875: FUNCTION Set_Attributes (
3876: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
3877: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
3878: ) RETURN VARCHAR2 IS
3879: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3880: BEGIN
3881: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;

Line 3881: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;

3877: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
3878: ) RETURN VARCHAR2 IS
3879: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3880: BEGIN
3881: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;
3882: x_okc_action_attributes_tl_rec.LANGUAGE := l_lang;
3883: x_okc_action_attributes_tl_rec.SOURCE_LANG := l_lang;
3884: RETURN(l_return_status);
3885: END Set_Attributes;

Line 3882: x_okc_action_attributes_tl_rec.LANGUAGE := l_lang;

3878: ) RETURN VARCHAR2 IS
3879: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3880: BEGIN
3881: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;
3882: x_okc_action_attributes_tl_rec.LANGUAGE := l_lang;
3883: x_okc_action_attributes_tl_rec.SOURCE_LANG := l_lang;
3884: RETURN(l_return_status);
3885: END Set_Attributes;
3886: BEGIN

Line 3883: x_okc_action_attributes_tl_rec.SOURCE_LANG := l_lang;

3879: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3880: BEGIN
3881: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;
3882: x_okc_action_attributes_tl_rec.LANGUAGE := l_lang;
3883: x_okc_action_attributes_tl_rec.SOURCE_LANG := l_lang;
3884: RETURN(l_return_status);
3885: END Set_Attributes;
3886: BEGIN
3887: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3898: p_okc_action_attributes_tl_rec, -- IN

3894: RAISE OKC_API.G_EXCEPTION_ERROR;
3895: END IF;
3896: --- Setting item attributes
3897: l_return_status := Set_Attributes(
3898: p_okc_action_attributes_tl_rec, -- IN
3899: l_okc_action_attributes_tl_rec); -- OUT
3900: --- If any errors happen abort API
3901: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3902: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3899: l_okc_action_attributes_tl_rec); -- OUT

3895: END IF;
3896: --- Setting item attributes
3897: l_return_status := Set_Attributes(
3898: p_okc_action_attributes_tl_rec, -- IN
3899: l_okc_action_attributes_tl_rec); -- OUT
3900: --- If any errors happen abort API
3901: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3902: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3903: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3906: l_return_status := populate_new_record(l_okc_action_attributes_tl_rec, ldefokcactionattributestlrec);

3902: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3903: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3904: RAISE OKC_API.G_EXCEPTION_ERROR;
3905: END IF;
3906: l_return_status := populate_new_record(l_okc_action_attributes_tl_rec, ldefokcactionattributestlrec);
3907: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3908: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3909: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3910: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3912: UPDATE OKC_ACTION_ATTRIBUTES_TL

3908: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3909: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3910: RAISE OKC_API.G_EXCEPTION_ERROR;
3911: END IF;
3912: UPDATE OKC_ACTION_ATTRIBUTES_TL
3913: SET NAME = ldefokcactionattributestlrec.name,
3914: DESCRIPTION = ldefokcactionattributestlrec.description,
3915: SOURCE_LANG = ldefokcactionattributestlrec.source_lang,
3916: CREATED_BY = ldefokcactionattributestlrec.created_by,

Line 3925: UPDATE OKC_ACTION_ATTRIBUTES_TL

3921: WHERE ID = ldefokcactionattributestlrec.id
3922: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
3923: --AND SOURCE_LANG = USERENV('LANG');
3924:
3925: UPDATE OKC_ACTION_ATTRIBUTES_TL
3926: SET SFWT_FLAG = 'Y'
3927: WHERE ID = ldefokcactionattributestlrec.id
3928: AND SOURCE_LANG <> USERENV('LANG');
3929:

Line 3930: x_okc_action_attributes_tl_rec := ldefokcactionattributestlrec;

3926: SET SFWT_FLAG = 'Y'
3927: WHERE ID = ldefokcactionattributestlrec.id
3928: AND SOURCE_LANG <> USERENV('LANG');
3929:
3930: x_okc_action_attributes_tl_rec := ldefokcactionattributestlrec;
3931: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3932: EXCEPTION
3933: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3934: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3981: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;

3977: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3978: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3979: l_aaev_rec aaev_rec_type := p_aaev_rec;
3980: l_def_aaev_rec aaev_rec_type;
3981: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
3982: LxOkcActionAttributesTlRec OkcActionAttributesTlRecType;
3983: l_aae_rec aae_rec_type;
3984: lx_aae_rec aae_rec_type;
3985: -------------------------------

Line 4259: migrate(l_def_aaev_rec, l_okc_action_attributes_tl_rec);

4255:
4256: --------------------------------------
4257: -- Move VIEW record to "Child" records
4258: --------------------------------------
4259: migrate(l_def_aaev_rec, l_okc_action_attributes_tl_rec);
4260: migrate(l_def_aaev_rec, l_aae_rec);
4261: --------------------------------------------
4262: -- Call the UPDATE_ROW for each child record
4263: --------------------------------------------

Line 4269: l_okc_action_attributes_tl_rec,

4265: p_init_msg_list,
4266: x_return_status,
4267: x_msg_count,
4268: x_msg_data,
4269: l_okc_action_attributes_tl_rec,
4270: LxOkcActionAttributesTlRec
4271: );
4272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4458: -- delete_row for:OKC_ACTION_ATTRIBUTES_TL --

4454: '_PVT'
4455: );
4456: END delete_row;
4457: ---------------------------------------------
4458: -- delete_row for:OKC_ACTION_ATTRIBUTES_TL --
4459: ---------------------------------------------
4460: PROCEDURE delete_row(
4461: p_init_msg_list IN VARCHAR2 ,
4462: x_return_status OUT NOCOPY VARCHAR2,

Line 4465: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType) IS

4461: p_init_msg_list IN VARCHAR2 ,
4462: x_return_status OUT NOCOPY VARCHAR2,
4463: x_msg_count OUT NOCOPY NUMBER,
4464: x_msg_data OUT NOCOPY VARCHAR2,
4465: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType) IS
4466:
4467: l_api_version CONSTANT NUMBER := 1;
4468: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
4469: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4470: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType:= p_okc_action_attributes_tl_rec;

4466:
4467: l_api_version CONSTANT NUMBER := 1;
4468: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
4469: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4470: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType:= p_okc_action_attributes_tl_rec;
4471: l_row_notfound BOOLEAN := TRUE;
4472: -------------------------------------------------
4473: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --
4474: -------------------------------------------------

Line 4473: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --

4469: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4470: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType:= p_okc_action_attributes_tl_rec;
4471: l_row_notfound BOOLEAN := TRUE;
4472: -------------------------------------------------
4473: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --
4474: -------------------------------------------------
4475: FUNCTION Set_Attributes (
4476: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
4477: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType

Line 4476: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,

4472: -------------------------------------------------
4473: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --
4474: -------------------------------------------------
4475: FUNCTION Set_Attributes (
4476: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
4477: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
4478: ) RETURN VARCHAR2 IS
4479: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4480: BEGIN

Line 4477: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType

4473: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_TL --
4474: -------------------------------------------------
4475: FUNCTION Set_Attributes (
4476: p_okc_action_attributes_tl_rec IN OkcActionAttributesTlRecType,
4477: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
4478: ) RETURN VARCHAR2 IS
4479: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4480: BEGIN
4481: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;

Line 4481: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;

4477: x_okc_action_attributes_tl_rec OUT NOCOPY OkcActionAttributesTlRecType
4478: ) RETURN VARCHAR2 IS
4479: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4480: BEGIN
4481: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;
4482: x_okc_action_attributes_tl_rec.LANGUAGE := l_lang;
4483: RETURN(l_return_status);
4484: END Set_Attributes;
4485: BEGIN

Line 4482: x_okc_action_attributes_tl_rec.LANGUAGE := l_lang;

4478: ) RETURN VARCHAR2 IS
4479: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4480: BEGIN
4481: x_okc_action_attributes_tl_rec := p_okc_action_attributes_tl_rec;
4482: x_okc_action_attributes_tl_rec.LANGUAGE := l_lang;
4483: RETURN(l_return_status);
4484: END Set_Attributes;
4485: BEGIN
4486: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4497: p_okc_action_attributes_tl_rec, -- IN

4493: RAISE OKC_API.G_EXCEPTION_ERROR;
4494: END IF;
4495: --- Setting item attributes
4496: l_return_status := Set_Attributes(
4497: p_okc_action_attributes_tl_rec, -- IN
4498: l_okc_action_attributes_tl_rec); -- OUT
4499: --- If any errors happen abort API
4500: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4501: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4498: l_okc_action_attributes_tl_rec); -- OUT

4494: END IF;
4495: --- Setting item attributes
4496: l_return_status := Set_Attributes(
4497: p_okc_action_attributes_tl_rec, -- IN
4498: l_okc_action_attributes_tl_rec); -- OUT
4499: --- If any errors happen abort API
4500: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4501: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4502: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4505: DELETE FROM OKC_ACTION_ATTRIBUTES_TL

4501: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4502: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4503: RAISE OKC_API.G_EXCEPTION_ERROR;
4504: END IF;
4505: DELETE FROM OKC_ACTION_ATTRIBUTES_TL
4506: WHERE ID = l_okc_action_attributes_tl_rec.id;
4507:
4508: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4509: EXCEPTION

Line 4506: WHERE ID = l_okc_action_attributes_tl_rec.id;

4502: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4503: RAISE OKC_API.G_EXCEPTION_ERROR;
4504: END IF;
4505: DELETE FROM OKC_ACTION_ATTRIBUTES_TL
4506: WHERE ID = l_okc_action_attributes_tl_rec.id;
4507:
4508: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4509: EXCEPTION
4510: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 4556: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;

4552: l_api_version CONSTANT NUMBER := 1;
4553: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
4554: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4555: l_aaev_rec aaev_rec_type := p_aaev_rec;
4556: l_okc_action_attributes_tl_rec OkcActionAttributesTlRecType;
4557: l_aae_rec aae_rec_type;
4558: BEGIN
4559: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
4560: G_PKG_NAME,

Line 4587: migrate(l_aaev_rec, l_okc_action_attributes_tl_rec);

4583: END IF;*/
4584: --------------------------------------
4585: -- Move VIEW record to "Child" records
4586: --------------------------------------
4587: migrate(l_aaev_rec, l_okc_action_attributes_tl_rec);
4588: migrate(l_aaev_rec, l_aae_rec);
4589: --------------------------------------------
4590: -- Call the DELETE_ROW for each child record
4591: --------------------------------------------

Line 4597: l_okc_action_attributes_tl_rec

4593: p_init_msg_list,
4594: x_return_status,
4595: x_msg_count,
4596: x_msg_data,
4597: l_okc_action_attributes_tl_rec
4598: );
4599: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4600: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4601: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN