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.OKL_FMA_PVT dependencies on OKL_FORMULAE_TL

Line 40: DELETE FROM OKL_FORMULAE_TL T

36: -- PROCEDURE add_language
37: ---------------------------------------------------------------------------
38: PROCEDURE add_language IS
39: BEGIN
40: DELETE FROM OKL_FORMULAE_TL T
41: WHERE NOT EXISTS (
42: SELECT NULL
43: FROM OKL_FORMULAE_B B --fixed bug 3321017 by kmotepal
44: WHERE B.ID = T.ID

Line 47: UPDATE OKL_FORMULAE_TL T SET (

43: FROM OKL_FORMULAE_B B --fixed bug 3321017 by kmotepal
44: WHERE B.ID = T.ID
45: );
46:
47: UPDATE OKL_FORMULAE_TL T SET (
48: DESCRIPTION) = (SELECT
49: B.DESCRIPTION
50: FROM OKL_FORMULAE_TL B
51: WHERE B.ID = T.ID

Line 50: FROM OKL_FORMULAE_TL B

46:
47: UPDATE OKL_FORMULAE_TL T SET (
48: DESCRIPTION) = (SELECT
49: B.DESCRIPTION
50: FROM OKL_FORMULAE_TL B
51: WHERE B.ID = T.ID
52: AND B.LANGUAGE = T.SOURCE_LANG)
53: WHERE (
54: T.ID,

Line 59: FROM OKL_FORMULAE_TL SUBB, OKL_FORMULAE_TL SUBT

55: T.LANGUAGE)
56: IN (SELECT
57: SUBT.ID,
58: SUBT.LANGUAGE
59: FROM OKL_FORMULAE_TL SUBB, OKL_FORMULAE_TL SUBT
60: WHERE SUBB.ID = SUBT.ID
61: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
62: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
63: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 67: INSERT INTO OKL_FORMULAE_TL (

63: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
64: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
65: ));
66:
67: INSERT INTO OKL_FORMULAE_TL (
68: ID,
69: LANGUAGE,
70: SOURCE_LANG,
71: SFWT_FLAG,

Line 89: FROM OKL_FORMULAE_TL B, FND_LANGUAGES L

85: B.CREATION_DATE,
86: B.LAST_UPDATED_BY,
87: B.LAST_UPDATE_DATE,
88: B.LAST_UPDATE_LOGIN
89: FROM OKL_FORMULAE_TL B, FND_LANGUAGES L
90: WHERE L.INSTALLED_FLAG IN ('I', 'B')
91: AND B.LANGUAGE = USERENV('LANG')
92: AND NOT EXISTS(
93: SELECT NULL

Line 94: FROM OKL_FORMULAE_TL T

90: WHERE L.INSTALLED_FLAG IN ('I', 'B')
91: AND B.LANGUAGE = USERENV('LANG')
92: AND NOT EXISTS(
93: SELECT NULL
94: FROM OKL_FORMULAE_TL T
95: WHERE T.ID = B.ID
96: AND T.LANGUAGE = L.LANGUAGE_CODE
97: );
98:

Line 196: -- FUNCTION get_rec for: OKL_FORMULAE_TL

192: BEGIN
193: RETURN(get_rec(p_fma_rec, l_row_notfound));
194: END get_rec;
195: ---------------------------------------------------------------------------
196: -- FUNCTION get_rec for: OKL_FORMULAE_TL
197: ---------------------------------------------------------------------------
198: FUNCTION get_rec (
199: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
200: x_no_data_found OUT NOCOPY BOOLEAN

Line 199: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,

195: ---------------------------------------------------------------------------
196: -- FUNCTION get_rec for: OKL_FORMULAE_TL
197: ---------------------------------------------------------------------------
198: FUNCTION get_rec (
199: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
200: x_no_data_found OUT NOCOPY BOOLEAN
201: ) RETURN okl_formulae_tl_rec_type IS
202: CURSOR okl_formulae_tl_pk_csr (p_id IN NUMBER,
203: p_language IN VARCHAR2) IS

Line 201: ) RETURN okl_formulae_tl_rec_type IS

197: ---------------------------------------------------------------------------
198: FUNCTION get_rec (
199: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
200: x_no_data_found OUT NOCOPY BOOLEAN
201: ) RETURN okl_formulae_tl_rec_type IS
202: CURSOR okl_formulae_tl_pk_csr (p_id IN NUMBER,
203: p_language IN VARCHAR2) IS
204: SELECT
205: ID,

Line 202: CURSOR okl_formulae_tl_pk_csr (p_id IN NUMBER,

198: FUNCTION get_rec (
199: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
200: x_no_data_found OUT NOCOPY BOOLEAN
201: ) RETURN okl_formulae_tl_rec_type IS
202: CURSOR okl_formulae_tl_pk_csr (p_id IN NUMBER,
203: p_language IN VARCHAR2) IS
204: SELECT
205: ID,
206: LANGUAGE,

Line 215: FROM Okl_Formulae_Tl

211: CREATION_DATE,
212: LAST_UPDATED_BY,
213: LAST_UPDATE_DATE,
214: LAST_UPDATE_LOGIN
215: FROM Okl_Formulae_Tl
216: WHERE okl_formulae_tl.id = p_id
217: AND okl_formulae_tl.language = p_language;
218: l_okl_formulae_tl_pk okl_formulae_tl_pk_csr%ROWTYPE;
219: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;

Line 216: WHERE okl_formulae_tl.id = p_id

212: LAST_UPDATED_BY,
213: LAST_UPDATE_DATE,
214: LAST_UPDATE_LOGIN
215: FROM Okl_Formulae_Tl
216: WHERE okl_formulae_tl.id = p_id
217: AND okl_formulae_tl.language = p_language;
218: l_okl_formulae_tl_pk okl_formulae_tl_pk_csr%ROWTYPE;
219: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
220: BEGIN

Line 217: AND okl_formulae_tl.language = p_language;

213: LAST_UPDATE_DATE,
214: LAST_UPDATE_LOGIN
215: FROM Okl_Formulae_Tl
216: WHERE okl_formulae_tl.id = p_id
217: AND okl_formulae_tl.language = p_language;
218: l_okl_formulae_tl_pk okl_formulae_tl_pk_csr%ROWTYPE;
219: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
220: BEGIN
221: x_no_data_found := TRUE;

Line 218: l_okl_formulae_tl_pk okl_formulae_tl_pk_csr%ROWTYPE;

214: LAST_UPDATE_LOGIN
215: FROM Okl_Formulae_Tl
216: WHERE okl_formulae_tl.id = p_id
217: AND okl_formulae_tl.language = p_language;
218: l_okl_formulae_tl_pk okl_formulae_tl_pk_csr%ROWTYPE;
219: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
220: BEGIN
221: x_no_data_found := TRUE;
222: -- Get current database values

Line 219: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;

215: FROM Okl_Formulae_Tl
216: WHERE okl_formulae_tl.id = p_id
217: AND okl_formulae_tl.language = p_language;
218: l_okl_formulae_tl_pk okl_formulae_tl_pk_csr%ROWTYPE;
219: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
220: BEGIN
221: x_no_data_found := TRUE;
222: -- Get current database values
223: OPEN okl_formulae_tl_pk_csr (p_okl_formulae_tl_rec.id,

Line 223: OPEN okl_formulae_tl_pk_csr (p_okl_formulae_tl_rec.id,

219: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
220: BEGIN
221: x_no_data_found := TRUE;
222: -- Get current database values
223: OPEN okl_formulae_tl_pk_csr (p_okl_formulae_tl_rec.id,
224: p_okl_formulae_tl_rec.language);
225: FETCH okl_formulae_tl_pk_csr INTO
226: l_okl_formulae_tl_rec.ID,
227: l_okl_formulae_tl_rec.LANGUAGE,

Line 224: p_okl_formulae_tl_rec.language);

220: BEGIN
221: x_no_data_found := TRUE;
222: -- Get current database values
223: OPEN okl_formulae_tl_pk_csr (p_okl_formulae_tl_rec.id,
224: p_okl_formulae_tl_rec.language);
225: FETCH okl_formulae_tl_pk_csr INTO
226: l_okl_formulae_tl_rec.ID,
227: l_okl_formulae_tl_rec.LANGUAGE,
228: l_okl_formulae_tl_rec.SOURCE_LANG,

Line 225: FETCH okl_formulae_tl_pk_csr INTO

221: x_no_data_found := TRUE;
222: -- Get current database values
223: OPEN okl_formulae_tl_pk_csr (p_okl_formulae_tl_rec.id,
224: p_okl_formulae_tl_rec.language);
225: FETCH okl_formulae_tl_pk_csr INTO
226: l_okl_formulae_tl_rec.ID,
227: l_okl_formulae_tl_rec.LANGUAGE,
228: l_okl_formulae_tl_rec.SOURCE_LANG,
229: l_okl_formulae_tl_rec.SFWT_FLAG,

Line 226: l_okl_formulae_tl_rec.ID,

222: -- Get current database values
223: OPEN okl_formulae_tl_pk_csr (p_okl_formulae_tl_rec.id,
224: p_okl_formulae_tl_rec.language);
225: FETCH okl_formulae_tl_pk_csr INTO
226: l_okl_formulae_tl_rec.ID,
227: l_okl_formulae_tl_rec.LANGUAGE,
228: l_okl_formulae_tl_rec.SOURCE_LANG,
229: l_okl_formulae_tl_rec.SFWT_FLAG,
230: l_okl_formulae_tl_rec.DESCRIPTION,

Line 227: l_okl_formulae_tl_rec.LANGUAGE,

223: OPEN okl_formulae_tl_pk_csr (p_okl_formulae_tl_rec.id,
224: p_okl_formulae_tl_rec.language);
225: FETCH okl_formulae_tl_pk_csr INTO
226: l_okl_formulae_tl_rec.ID,
227: l_okl_formulae_tl_rec.LANGUAGE,
228: l_okl_formulae_tl_rec.SOURCE_LANG,
229: l_okl_formulae_tl_rec.SFWT_FLAG,
230: l_okl_formulae_tl_rec.DESCRIPTION,
231: l_okl_formulae_tl_rec.CREATED_BY,

Line 228: l_okl_formulae_tl_rec.SOURCE_LANG,

224: p_okl_formulae_tl_rec.language);
225: FETCH okl_formulae_tl_pk_csr INTO
226: l_okl_formulae_tl_rec.ID,
227: l_okl_formulae_tl_rec.LANGUAGE,
228: l_okl_formulae_tl_rec.SOURCE_LANG,
229: l_okl_formulae_tl_rec.SFWT_FLAG,
230: l_okl_formulae_tl_rec.DESCRIPTION,
231: l_okl_formulae_tl_rec.CREATED_BY,
232: l_okl_formulae_tl_rec.CREATION_DATE,

Line 229: l_okl_formulae_tl_rec.SFWT_FLAG,

225: FETCH okl_formulae_tl_pk_csr INTO
226: l_okl_formulae_tl_rec.ID,
227: l_okl_formulae_tl_rec.LANGUAGE,
228: l_okl_formulae_tl_rec.SOURCE_LANG,
229: l_okl_formulae_tl_rec.SFWT_FLAG,
230: l_okl_formulae_tl_rec.DESCRIPTION,
231: l_okl_formulae_tl_rec.CREATED_BY,
232: l_okl_formulae_tl_rec.CREATION_DATE,
233: l_okl_formulae_tl_rec.LAST_UPDATED_BY,

Line 230: l_okl_formulae_tl_rec.DESCRIPTION,

226: l_okl_formulae_tl_rec.ID,
227: l_okl_formulae_tl_rec.LANGUAGE,
228: l_okl_formulae_tl_rec.SOURCE_LANG,
229: l_okl_formulae_tl_rec.SFWT_FLAG,
230: l_okl_formulae_tl_rec.DESCRIPTION,
231: l_okl_formulae_tl_rec.CREATED_BY,
232: l_okl_formulae_tl_rec.CREATION_DATE,
233: l_okl_formulae_tl_rec.LAST_UPDATED_BY,
234: l_okl_formulae_tl_rec.LAST_UPDATE_DATE,

Line 231: l_okl_formulae_tl_rec.CREATED_BY,

227: l_okl_formulae_tl_rec.LANGUAGE,
228: l_okl_formulae_tl_rec.SOURCE_LANG,
229: l_okl_formulae_tl_rec.SFWT_FLAG,
230: l_okl_formulae_tl_rec.DESCRIPTION,
231: l_okl_formulae_tl_rec.CREATED_BY,
232: l_okl_formulae_tl_rec.CREATION_DATE,
233: l_okl_formulae_tl_rec.LAST_UPDATED_BY,
234: l_okl_formulae_tl_rec.LAST_UPDATE_DATE,
235: l_okl_formulae_tl_rec.LAST_UPDATE_LOGIN;

Line 232: l_okl_formulae_tl_rec.CREATION_DATE,

228: l_okl_formulae_tl_rec.SOURCE_LANG,
229: l_okl_formulae_tl_rec.SFWT_FLAG,
230: l_okl_formulae_tl_rec.DESCRIPTION,
231: l_okl_formulae_tl_rec.CREATED_BY,
232: l_okl_formulae_tl_rec.CREATION_DATE,
233: l_okl_formulae_tl_rec.LAST_UPDATED_BY,
234: l_okl_formulae_tl_rec.LAST_UPDATE_DATE,
235: l_okl_formulae_tl_rec.LAST_UPDATE_LOGIN;
236: x_no_data_found := okl_formulae_tl_pk_csr%NOTFOUND;

Line 233: l_okl_formulae_tl_rec.LAST_UPDATED_BY,

229: l_okl_formulae_tl_rec.SFWT_FLAG,
230: l_okl_formulae_tl_rec.DESCRIPTION,
231: l_okl_formulae_tl_rec.CREATED_BY,
232: l_okl_formulae_tl_rec.CREATION_DATE,
233: l_okl_formulae_tl_rec.LAST_UPDATED_BY,
234: l_okl_formulae_tl_rec.LAST_UPDATE_DATE,
235: l_okl_formulae_tl_rec.LAST_UPDATE_LOGIN;
236: x_no_data_found := okl_formulae_tl_pk_csr%NOTFOUND;
237: CLOSE okl_formulae_tl_pk_csr;

Line 234: l_okl_formulae_tl_rec.LAST_UPDATE_DATE,

230: l_okl_formulae_tl_rec.DESCRIPTION,
231: l_okl_formulae_tl_rec.CREATED_BY,
232: l_okl_formulae_tl_rec.CREATION_DATE,
233: l_okl_formulae_tl_rec.LAST_UPDATED_BY,
234: l_okl_formulae_tl_rec.LAST_UPDATE_DATE,
235: l_okl_formulae_tl_rec.LAST_UPDATE_LOGIN;
236: x_no_data_found := okl_formulae_tl_pk_csr%NOTFOUND;
237: CLOSE okl_formulae_tl_pk_csr;
238: RETURN(l_okl_formulae_tl_rec);

Line 235: l_okl_formulae_tl_rec.LAST_UPDATE_LOGIN;

231: l_okl_formulae_tl_rec.CREATED_BY,
232: l_okl_formulae_tl_rec.CREATION_DATE,
233: l_okl_formulae_tl_rec.LAST_UPDATED_BY,
234: l_okl_formulae_tl_rec.LAST_UPDATE_DATE,
235: l_okl_formulae_tl_rec.LAST_UPDATE_LOGIN;
236: x_no_data_found := okl_formulae_tl_pk_csr%NOTFOUND;
237: CLOSE okl_formulae_tl_pk_csr;
238: RETURN(l_okl_formulae_tl_rec);
239: END get_rec;

Line 236: x_no_data_found := okl_formulae_tl_pk_csr%NOTFOUND;

232: l_okl_formulae_tl_rec.CREATION_DATE,
233: l_okl_formulae_tl_rec.LAST_UPDATED_BY,
234: l_okl_formulae_tl_rec.LAST_UPDATE_DATE,
235: l_okl_formulae_tl_rec.LAST_UPDATE_LOGIN;
236: x_no_data_found := okl_formulae_tl_pk_csr%NOTFOUND;
237: CLOSE okl_formulae_tl_pk_csr;
238: RETURN(l_okl_formulae_tl_rec);
239: END get_rec;
240:

Line 237: CLOSE okl_formulae_tl_pk_csr;

233: l_okl_formulae_tl_rec.LAST_UPDATED_BY,
234: l_okl_formulae_tl_rec.LAST_UPDATE_DATE,
235: l_okl_formulae_tl_rec.LAST_UPDATE_LOGIN;
236: x_no_data_found := okl_formulae_tl_pk_csr%NOTFOUND;
237: CLOSE okl_formulae_tl_pk_csr;
238: RETURN(l_okl_formulae_tl_rec);
239: END get_rec;
240:
241: FUNCTION get_rec (

Line 238: RETURN(l_okl_formulae_tl_rec);

234: l_okl_formulae_tl_rec.LAST_UPDATE_DATE,
235: l_okl_formulae_tl_rec.LAST_UPDATE_LOGIN;
236: x_no_data_found := okl_formulae_tl_pk_csr%NOTFOUND;
237: CLOSE okl_formulae_tl_pk_csr;
238: RETURN(l_okl_formulae_tl_rec);
239: END get_rec;
240:
241: FUNCTION get_rec (
242: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type

Line 242: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type

238: RETURN(l_okl_formulae_tl_rec);
239: END get_rec;
240:
241: FUNCTION get_rec (
242: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type
243: ) RETURN okl_formulae_tl_rec_type IS
244: l_row_notfound BOOLEAN := TRUE;
245: BEGIN
246: RETURN(get_rec(p_okl_formulae_tl_rec, l_row_notfound));

Line 243: ) RETURN okl_formulae_tl_rec_type IS

239: END get_rec;
240:
241: FUNCTION get_rec (
242: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type
243: ) RETURN okl_formulae_tl_rec_type IS
244: l_row_notfound BOOLEAN := TRUE;
245: BEGIN
246: RETURN(get_rec(p_okl_formulae_tl_rec, l_row_notfound));
247: END get_rec;

Line 246: RETURN(get_rec(p_okl_formulae_tl_rec, l_row_notfound));

242: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type
243: ) RETURN okl_formulae_tl_rec_type IS
244: l_row_notfound BOOLEAN := TRUE;
245: BEGIN
246: RETURN(get_rec(p_okl_formulae_tl_rec, l_row_notfound));
247: END get_rec;
248: ---------------------------------------------------------------------------
249: -- FUNCTION get_rec for: OKL_FORMULAE_V
250: ---------------------------------------------------------------------------

Line 1719: p_to IN OUT NOCOPY okl_formulae_tl_rec_type

1715: p_to.last_update_login := p_from.last_update_login;
1716: END migrate;
1717: PROCEDURE migrate (
1718: p_from IN fmav_rec_type,
1719: p_to IN OUT NOCOPY okl_formulae_tl_rec_type
1720: ) IS
1721: BEGIN
1722: p_to.id := p_from.id;
1723: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1732: p_from IN okl_formulae_tl_rec_type,

1728: p_to.last_update_date := p_from.last_update_date;
1729: p_to.last_update_login := p_from.last_update_login;
1730: END migrate;
1731: PROCEDURE migrate (
1732: p_from IN okl_formulae_tl_rec_type,
1733: p_to IN OUT NOCOPY fmav_rec_type
1734: ) IS
1735: BEGIN
1736: p_to.id := p_from.id;

Line 1765: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;

1761: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1762: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1763: l_fmav_rec fmav_rec_type := p_fmav_rec;
1764: l_fma_rec fma_rec_type;
1765: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
1766: BEGIN
1767: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1768: G_PKG_NAME,
1769: p_init_msg_list,

Line 2055: -- insert_row for:OKL_FORMULAE_TL --

2051: '_PVT'
2052: );
2053: END insert_row;
2054: ------------------------------------
2055: -- insert_row for:OKL_FORMULAE_TL --
2056: ------------------------------------
2057: PROCEDURE insert_row(
2058: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2059: x_return_status OUT NOCOPY VARCHAR2,

Line 2062: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,

2058: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2059: x_return_status OUT NOCOPY VARCHAR2,
2060: x_msg_count OUT NOCOPY NUMBER,
2061: x_msg_data OUT NOCOPY VARCHAR2,
2062: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
2063: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type) IS
2064:
2065: l_api_version CONSTANT NUMBER := 1;
2066: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 2063: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type) IS

2059: x_return_status OUT NOCOPY VARCHAR2,
2060: x_msg_count OUT NOCOPY NUMBER,
2061: x_msg_data OUT NOCOPY VARCHAR2,
2062: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
2063: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type) IS
2064:
2065: l_api_version CONSTANT NUMBER := 1;
2066: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2067: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2068: l_okl_formulae_tl_rec okl_formulae_tl_rec_type := p_okl_formulae_tl_rec;

2064:
2065: l_api_version CONSTANT NUMBER := 1;
2066: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2067: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2068: l_okl_formulae_tl_rec okl_formulae_tl_rec_type := p_okl_formulae_tl_rec;
2069: l_def_okl_formulae_tl_rec okl_formulae_tl_rec_type;
2070: CURSOR get_languages IS
2071: SELECT *
2072: FROM FND_LANGUAGES

Line 2069: l_def_okl_formulae_tl_rec okl_formulae_tl_rec_type;

2065: l_api_version CONSTANT NUMBER := 1;
2066: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
2067: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2068: l_okl_formulae_tl_rec okl_formulae_tl_rec_type := p_okl_formulae_tl_rec;
2069: l_def_okl_formulae_tl_rec okl_formulae_tl_rec_type;
2070: CURSOR get_languages IS
2071: SELECT *
2072: FROM FND_LANGUAGES
2073: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 2075: -- Set_Attributes for:OKL_FORMULAE_TL --

2071: SELECT *
2072: FROM FND_LANGUAGES
2073: WHERE INSTALLED_FLAG IN ('I', 'B');
2074: ----------------------------------------
2075: -- Set_Attributes for:OKL_FORMULAE_TL --
2076: ----------------------------------------
2077: FUNCTION Set_Attributes (
2078: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
2079: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type

Line 2078: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,

2074: ----------------------------------------
2075: -- Set_Attributes for:OKL_FORMULAE_TL --
2076: ----------------------------------------
2077: FUNCTION Set_Attributes (
2078: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
2079: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
2080: ) RETURN VARCHAR2 IS
2081: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2082: BEGIN

Line 2079: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type

2075: -- Set_Attributes for:OKL_FORMULAE_TL --
2076: ----------------------------------------
2077: FUNCTION Set_Attributes (
2078: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
2079: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
2080: ) RETURN VARCHAR2 IS
2081: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2082: BEGIN
2083: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;

Line 2083: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;

2079: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
2080: ) RETURN VARCHAR2 IS
2081: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2082: BEGIN
2083: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;
2084: x_okl_formulae_tl_rec.LANGUAGE := USERENV('LANG');
2085: x_okl_formulae_tl_rec.SOURCE_LANG := USERENV('LANG');
2086: RETURN(l_return_status);
2087: END Set_Attributes;

Line 2084: x_okl_formulae_tl_rec.LANGUAGE := USERENV('LANG');

2080: ) RETURN VARCHAR2 IS
2081: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2082: BEGIN
2083: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;
2084: x_okl_formulae_tl_rec.LANGUAGE := USERENV('LANG');
2085: x_okl_formulae_tl_rec.SOURCE_LANG := USERENV('LANG');
2086: RETURN(l_return_status);
2087: END Set_Attributes;
2088: BEGIN

Line 2085: x_okl_formulae_tl_rec.SOURCE_LANG := USERENV('LANG');

2081: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2082: BEGIN
2083: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;
2084: x_okl_formulae_tl_rec.LANGUAGE := USERENV('LANG');
2085: x_okl_formulae_tl_rec.SOURCE_LANG := USERENV('LANG');
2086: RETURN(l_return_status);
2087: END Set_Attributes;
2088: BEGIN
2089: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2100: p_okl_formulae_tl_rec, -- IN

2096: RAISE OKC_API.G_EXCEPTION_ERROR;
2097: END IF;
2098: --- Setting item attributes
2099: l_return_status := Set_Attributes(
2100: p_okl_formulae_tl_rec, -- IN
2101: l_okl_formulae_tl_rec); -- OUT
2102: --- If any errors happen abort API
2103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2104: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2101: l_okl_formulae_tl_rec); -- OUT

2097: END IF;
2098: --- Setting item attributes
2099: l_return_status := Set_Attributes(
2100: p_okl_formulae_tl_rec, -- IN
2101: l_okl_formulae_tl_rec); -- OUT
2102: --- If any errors happen abort API
2103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2104: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2109: l_okl_formulae_tl_rec.language := l_lang_rec.language_code;

2105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2106: RAISE OKC_API.G_EXCEPTION_ERROR;
2107: END IF;
2108: FOR l_lang_rec IN get_languages LOOP
2109: l_okl_formulae_tl_rec.language := l_lang_rec.language_code;
2110: INSERT INTO OKL_FORMULAE_TL(
2111: id,
2112: language,
2113: source_lang,

Line 2110: INSERT INTO OKL_FORMULAE_TL(

2106: RAISE OKC_API.G_EXCEPTION_ERROR;
2107: END IF;
2108: FOR l_lang_rec IN get_languages LOOP
2109: l_okl_formulae_tl_rec.language := l_lang_rec.language_code;
2110: INSERT INTO OKL_FORMULAE_TL(
2111: id,
2112: language,
2113: source_lang,
2114: sfwt_flag,

Line 2122: l_okl_formulae_tl_rec.id,

2118: last_updated_by,
2119: last_update_date,
2120: last_update_login)
2121: VALUES (
2122: l_okl_formulae_tl_rec.id,
2123: l_okl_formulae_tl_rec.language,
2124: l_okl_formulae_tl_rec.source_lang,
2125: l_okl_formulae_tl_rec.sfwt_flag,
2126: l_okl_formulae_tl_rec.description,

Line 2123: l_okl_formulae_tl_rec.language,

2119: last_update_date,
2120: last_update_login)
2121: VALUES (
2122: l_okl_formulae_tl_rec.id,
2123: l_okl_formulae_tl_rec.language,
2124: l_okl_formulae_tl_rec.source_lang,
2125: l_okl_formulae_tl_rec.sfwt_flag,
2126: l_okl_formulae_tl_rec.description,
2127: l_okl_formulae_tl_rec.created_by,

Line 2124: l_okl_formulae_tl_rec.source_lang,

2120: last_update_login)
2121: VALUES (
2122: l_okl_formulae_tl_rec.id,
2123: l_okl_formulae_tl_rec.language,
2124: l_okl_formulae_tl_rec.source_lang,
2125: l_okl_formulae_tl_rec.sfwt_flag,
2126: l_okl_formulae_tl_rec.description,
2127: l_okl_formulae_tl_rec.created_by,
2128: l_okl_formulae_tl_rec.creation_date,

Line 2125: l_okl_formulae_tl_rec.sfwt_flag,

2121: VALUES (
2122: l_okl_formulae_tl_rec.id,
2123: l_okl_formulae_tl_rec.language,
2124: l_okl_formulae_tl_rec.source_lang,
2125: l_okl_formulae_tl_rec.sfwt_flag,
2126: l_okl_formulae_tl_rec.description,
2127: l_okl_formulae_tl_rec.created_by,
2128: l_okl_formulae_tl_rec.creation_date,
2129: l_okl_formulae_tl_rec.last_updated_by,

Line 2126: l_okl_formulae_tl_rec.description,

2122: l_okl_formulae_tl_rec.id,
2123: l_okl_formulae_tl_rec.language,
2124: l_okl_formulae_tl_rec.source_lang,
2125: l_okl_formulae_tl_rec.sfwt_flag,
2126: l_okl_formulae_tl_rec.description,
2127: l_okl_formulae_tl_rec.created_by,
2128: l_okl_formulae_tl_rec.creation_date,
2129: l_okl_formulae_tl_rec.last_updated_by,
2130: l_okl_formulae_tl_rec.last_update_date,

Line 2127: l_okl_formulae_tl_rec.created_by,

2123: l_okl_formulae_tl_rec.language,
2124: l_okl_formulae_tl_rec.source_lang,
2125: l_okl_formulae_tl_rec.sfwt_flag,
2126: l_okl_formulae_tl_rec.description,
2127: l_okl_formulae_tl_rec.created_by,
2128: l_okl_formulae_tl_rec.creation_date,
2129: l_okl_formulae_tl_rec.last_updated_by,
2130: l_okl_formulae_tl_rec.last_update_date,
2131: l_okl_formulae_tl_rec.last_update_login);

Line 2128: l_okl_formulae_tl_rec.creation_date,

2124: l_okl_formulae_tl_rec.source_lang,
2125: l_okl_formulae_tl_rec.sfwt_flag,
2126: l_okl_formulae_tl_rec.description,
2127: l_okl_formulae_tl_rec.created_by,
2128: l_okl_formulae_tl_rec.creation_date,
2129: l_okl_formulae_tl_rec.last_updated_by,
2130: l_okl_formulae_tl_rec.last_update_date,
2131: l_okl_formulae_tl_rec.last_update_login);
2132: END LOOP;

Line 2129: l_okl_formulae_tl_rec.last_updated_by,

2125: l_okl_formulae_tl_rec.sfwt_flag,
2126: l_okl_formulae_tl_rec.description,
2127: l_okl_formulae_tl_rec.created_by,
2128: l_okl_formulae_tl_rec.creation_date,
2129: l_okl_formulae_tl_rec.last_updated_by,
2130: l_okl_formulae_tl_rec.last_update_date,
2131: l_okl_formulae_tl_rec.last_update_login);
2132: END LOOP;
2133: -- Set OUT values

Line 2130: l_okl_formulae_tl_rec.last_update_date,

2126: l_okl_formulae_tl_rec.description,
2127: l_okl_formulae_tl_rec.created_by,
2128: l_okl_formulae_tl_rec.creation_date,
2129: l_okl_formulae_tl_rec.last_updated_by,
2130: l_okl_formulae_tl_rec.last_update_date,
2131: l_okl_formulae_tl_rec.last_update_login);
2132: END LOOP;
2133: -- Set OUT values
2134: x_okl_formulae_tl_rec := l_okl_formulae_tl_rec;

Line 2131: l_okl_formulae_tl_rec.last_update_login);

2127: l_okl_formulae_tl_rec.created_by,
2128: l_okl_formulae_tl_rec.creation_date,
2129: l_okl_formulae_tl_rec.last_updated_by,
2130: l_okl_formulae_tl_rec.last_update_date,
2131: l_okl_formulae_tl_rec.last_update_login);
2132: END LOOP;
2133: -- Set OUT values
2134: x_okl_formulae_tl_rec := l_okl_formulae_tl_rec;
2135: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2134: x_okl_formulae_tl_rec := l_okl_formulae_tl_rec;

2130: l_okl_formulae_tl_rec.last_update_date,
2131: l_okl_formulae_tl_rec.last_update_login);
2132: END LOOP;
2133: -- Set OUT values
2134: x_okl_formulae_tl_rec := l_okl_formulae_tl_rec;
2135: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2136: EXCEPTION
2137: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2138: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2187: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;

2183: l_fmav_rec fmav_rec_type;
2184: l_def_fmav_rec fmav_rec_type;
2185: l_fma_rec fma_rec_type;
2186: lx_fma_rec fma_rec_type;
2187: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
2188: lx_okl_formulae_tl_rec okl_formulae_tl_rec_type;
2189: -------------------------------
2190: -- FUNCTION fill_who_columns --
2191: -------------------------------

Line 2188: lx_okl_formulae_tl_rec okl_formulae_tl_rec_type;

2184: l_def_fmav_rec fmav_rec_type;
2185: l_fma_rec fma_rec_type;
2186: lx_fma_rec fma_rec_type;
2187: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
2188: lx_okl_formulae_tl_rec okl_formulae_tl_rec_type;
2189: -------------------------------
2190: -- FUNCTION fill_who_columns --
2191: -------------------------------
2192: FUNCTION fill_who_columns (

Line 2263: migrate(l_def_fmav_rec, l_okl_formulae_tl_rec);

2259: --------------------------------------
2260: -- Move VIEW record to "Child" records
2261: --------------------------------------
2262: migrate(l_def_fmav_rec, l_fma_rec);
2263: migrate(l_def_fmav_rec, l_okl_formulae_tl_rec);
2264: --------------------------------------------
2265: -- Call the INSERT_ROW for each child record
2266: --------------------------------------------
2267: insert_row(

Line 2286: l_okl_formulae_tl_rec,

2282: p_init_msg_list,
2283: x_return_status,
2284: x_msg_count,
2285: x_msg_data,
2286: l_okl_formulae_tl_rec,
2287: lx_okl_formulae_tl_rec
2288: );
2289: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2287: lx_okl_formulae_tl_rec

2283: x_return_status,
2284: x_msg_count,
2285: x_msg_data,
2286: l_okl_formulae_tl_rec,
2287: lx_okl_formulae_tl_rec
2288: );
2289: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2291: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2294: migrate(lx_okl_formulae_tl_rec, l_def_fmav_rec);

2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2291: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2292: RAISE OKC_API.G_EXCEPTION_ERROR;
2293: END IF;
2294: migrate(lx_okl_formulae_tl_rec, l_def_fmav_rec);
2295: -- Set OUT values
2296: x_fmav_rec := l_def_fmav_rec;
2297: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2298: EXCEPTION

Line 2518: -- lock_row for:OKL_FORMULAE_TL --

2514: '_PVT'
2515: );
2516: END lock_row;
2517: ----------------------------------
2518: -- lock_row for:OKL_FORMULAE_TL --
2519: ----------------------------------
2520: PROCEDURE lock_row(
2521: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2522: x_return_status OUT NOCOPY VARCHAR2,

Line 2525: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type) IS

2521: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2522: x_return_status OUT NOCOPY VARCHAR2,
2523: x_msg_count OUT NOCOPY NUMBER,
2524: x_msg_data OUT NOCOPY VARCHAR2,
2525: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type) IS
2526:
2527: E_Resource_Busy EXCEPTION;
2528: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2529: CURSOR lock_csr (p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type) IS

Line 2529: CURSOR lock_csr (p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type) IS

2525: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type) IS
2526:
2527: E_Resource_Busy EXCEPTION;
2528: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2529: CURSOR lock_csr (p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type) IS
2530: SELECT *
2531: FROM OKL_FORMULAE_TL
2532: WHERE ID = p_okl_formulae_tl_rec.id
2533: FOR UPDATE NOWAIT;

Line 2531: FROM OKL_FORMULAE_TL

2527: E_Resource_Busy EXCEPTION;
2528: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2529: CURSOR lock_csr (p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type) IS
2530: SELECT *
2531: FROM OKL_FORMULAE_TL
2532: WHERE ID = p_okl_formulae_tl_rec.id
2533: FOR UPDATE NOWAIT;
2534:
2535: l_api_version CONSTANT NUMBER := 1;

Line 2532: WHERE ID = p_okl_formulae_tl_rec.id

2528: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2529: CURSOR lock_csr (p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type) IS
2530: SELECT *
2531: FROM OKL_FORMULAE_TL
2532: WHERE ID = p_okl_formulae_tl_rec.id
2533: FOR UPDATE NOWAIT;
2534:
2535: l_api_version CONSTANT NUMBER := 1;
2536: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2552: OPEN lock_csr(p_okl_formulae_tl_rec);

2548: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2549: RAISE OKC_API.G_EXCEPTION_ERROR;
2550: END IF;
2551: BEGIN
2552: OPEN lock_csr(p_okl_formulae_tl_rec);
2553: FETCH lock_csr INTO l_lock_var;
2554: l_row_notfound := lock_csr%NOTFOUND;
2555: CLOSE lock_csr;
2556: EXCEPTION

Line 2617: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;

2613: l_api_version CONSTANT NUMBER := 1;
2614: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2615: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2616: l_fma_rec fma_rec_type;
2617: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
2618: BEGIN
2619: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2620: G_PKG_NAME,
2621: p_init_msg_list,

Line 2635: migrate(p_fmav_rec, l_okl_formulae_tl_rec);

2631: --------------------------------------
2632: -- Move VIEW record to "Child" records
2633: --------------------------------------
2634: migrate(p_fmav_rec, l_fma_rec);
2635: migrate(p_fmav_rec, l_okl_formulae_tl_rec);
2636: --------------------------------------------
2637: -- Call the LOCK_ROW for each child record
2638: --------------------------------------------
2639: lock_row(

Line 2656: l_okl_formulae_tl_rec

2652: p_init_msg_list,
2653: x_return_status,
2654: x_msg_count,
2655: x_msg_data,
2656: l_okl_formulae_tl_rec
2657: );
2658: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2659: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2660: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3046: -- update_row for:OKL_FORMULAE_TL --

3042: '_PVT'
3043: );
3044: END update_row;
3045: ------------------------------------
3046: -- update_row for:OKL_FORMULAE_TL --
3047: ------------------------------------
3048: PROCEDURE update_row(
3049: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3050: x_return_status OUT NOCOPY VARCHAR2,

Line 3053: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,

3049: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3050: x_return_status OUT NOCOPY VARCHAR2,
3051: x_msg_count OUT NOCOPY NUMBER,
3052: x_msg_data OUT NOCOPY VARCHAR2,
3053: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
3054: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type) IS
3055:
3056: l_api_version CONSTANT NUMBER := 1;
3057: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 3054: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type) IS

3050: x_return_status OUT NOCOPY VARCHAR2,
3051: x_msg_count OUT NOCOPY NUMBER,
3052: x_msg_data OUT NOCOPY VARCHAR2,
3053: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
3054: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type) IS
3055:
3056: l_api_version CONSTANT NUMBER := 1;
3057: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3058: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3059: l_okl_formulae_tl_rec okl_formulae_tl_rec_type := p_okl_formulae_tl_rec;

3055:
3056: l_api_version CONSTANT NUMBER := 1;
3057: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3058: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3059: l_okl_formulae_tl_rec okl_formulae_tl_rec_type := p_okl_formulae_tl_rec;
3060: l_def_okl_formulae_tl_rec okl_formulae_tl_rec_type;
3061: l_row_notfound BOOLEAN := TRUE;
3062: ----------------------------------
3063: -- FUNCTION populate_new_record --

Line 3060: l_def_okl_formulae_tl_rec okl_formulae_tl_rec_type;

3056: l_api_version CONSTANT NUMBER := 1;
3057: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3058: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3059: l_okl_formulae_tl_rec okl_formulae_tl_rec_type := p_okl_formulae_tl_rec;
3060: l_def_okl_formulae_tl_rec okl_formulae_tl_rec_type;
3061: l_row_notfound BOOLEAN := TRUE;
3062: ----------------------------------
3063: -- FUNCTION populate_new_record --
3064: ----------------------------------

Line 3066: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,

3062: ----------------------------------
3063: -- FUNCTION populate_new_record --
3064: ----------------------------------
3065: FUNCTION populate_new_record (
3066: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
3067: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
3068: ) RETURN VARCHAR2 IS
3069: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
3070: l_row_notfound BOOLEAN := TRUE;

Line 3067: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type

3063: -- FUNCTION populate_new_record --
3064: ----------------------------------
3065: FUNCTION populate_new_record (
3066: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
3067: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
3068: ) RETURN VARCHAR2 IS
3069: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
3070: l_row_notfound BOOLEAN := TRUE;
3071: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3069: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;

3065: FUNCTION populate_new_record (
3066: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
3067: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
3068: ) RETURN VARCHAR2 IS
3069: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
3070: l_row_notfound BOOLEAN := TRUE;
3071: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3072: BEGIN
3073: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;

Line 3073: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;

3069: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
3070: l_row_notfound BOOLEAN := TRUE;
3071: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3072: BEGIN
3073: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;
3074: -- Get current database values
3075: l_okl_formulae_tl_rec := get_rec(p_okl_formulae_tl_rec, l_row_notfound);
3076: IF (l_row_notfound) THEN
3077: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 3075: l_okl_formulae_tl_rec := get_rec(p_okl_formulae_tl_rec, l_row_notfound);

3071: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3072: BEGIN
3073: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;
3074: -- Get current database values
3075: l_okl_formulae_tl_rec := get_rec(p_okl_formulae_tl_rec, l_row_notfound);
3076: IF (l_row_notfound) THEN
3077: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3078: END IF;
3079: IF (x_okl_formulae_tl_rec.id = OKC_API.G_MISS_NUM)

Line 3079: IF (x_okl_formulae_tl_rec.id = OKC_API.G_MISS_NUM)

3075: l_okl_formulae_tl_rec := get_rec(p_okl_formulae_tl_rec, l_row_notfound);
3076: IF (l_row_notfound) THEN
3077: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3078: END IF;
3079: IF (x_okl_formulae_tl_rec.id = OKC_API.G_MISS_NUM)
3080: THEN
3081: x_okl_formulae_tl_rec.id := l_okl_formulae_tl_rec.id;
3082: END IF;
3083: IF (x_okl_formulae_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 3081: x_okl_formulae_tl_rec.id := l_okl_formulae_tl_rec.id;

3077: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3078: END IF;
3079: IF (x_okl_formulae_tl_rec.id = OKC_API.G_MISS_NUM)
3080: THEN
3081: x_okl_formulae_tl_rec.id := l_okl_formulae_tl_rec.id;
3082: END IF;
3083: IF (x_okl_formulae_tl_rec.language = OKC_API.G_MISS_CHAR)
3084: THEN
3085: x_okl_formulae_tl_rec.language := l_okl_formulae_tl_rec.language;

Line 3083: IF (x_okl_formulae_tl_rec.language = OKC_API.G_MISS_CHAR)

3079: IF (x_okl_formulae_tl_rec.id = OKC_API.G_MISS_NUM)
3080: THEN
3081: x_okl_formulae_tl_rec.id := l_okl_formulae_tl_rec.id;
3082: END IF;
3083: IF (x_okl_formulae_tl_rec.language = OKC_API.G_MISS_CHAR)
3084: THEN
3085: x_okl_formulae_tl_rec.language := l_okl_formulae_tl_rec.language;
3086: END IF;
3087: IF (x_okl_formulae_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 3085: x_okl_formulae_tl_rec.language := l_okl_formulae_tl_rec.language;

3081: x_okl_formulae_tl_rec.id := l_okl_formulae_tl_rec.id;
3082: END IF;
3083: IF (x_okl_formulae_tl_rec.language = OKC_API.G_MISS_CHAR)
3084: THEN
3085: x_okl_formulae_tl_rec.language := l_okl_formulae_tl_rec.language;
3086: END IF;
3087: IF (x_okl_formulae_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3088: THEN
3089: x_okl_formulae_tl_rec.source_lang := l_okl_formulae_tl_rec.source_lang;

Line 3087: IF (x_okl_formulae_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

3083: IF (x_okl_formulae_tl_rec.language = OKC_API.G_MISS_CHAR)
3084: THEN
3085: x_okl_formulae_tl_rec.language := l_okl_formulae_tl_rec.language;
3086: END IF;
3087: IF (x_okl_formulae_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3088: THEN
3089: x_okl_formulae_tl_rec.source_lang := l_okl_formulae_tl_rec.source_lang;
3090: END IF;
3091: IF (x_okl_formulae_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 3089: x_okl_formulae_tl_rec.source_lang := l_okl_formulae_tl_rec.source_lang;

3085: x_okl_formulae_tl_rec.language := l_okl_formulae_tl_rec.language;
3086: END IF;
3087: IF (x_okl_formulae_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3088: THEN
3089: x_okl_formulae_tl_rec.source_lang := l_okl_formulae_tl_rec.source_lang;
3090: END IF;
3091: IF (x_okl_formulae_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3092: THEN
3093: x_okl_formulae_tl_rec.sfwt_flag := l_okl_formulae_tl_rec.sfwt_flag;

Line 3091: IF (x_okl_formulae_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

3087: IF (x_okl_formulae_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3088: THEN
3089: x_okl_formulae_tl_rec.source_lang := l_okl_formulae_tl_rec.source_lang;
3090: END IF;
3091: IF (x_okl_formulae_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3092: THEN
3093: x_okl_formulae_tl_rec.sfwt_flag := l_okl_formulae_tl_rec.sfwt_flag;
3094: END IF;
3095: IF (x_okl_formulae_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 3093: x_okl_formulae_tl_rec.sfwt_flag := l_okl_formulae_tl_rec.sfwt_flag;

3089: x_okl_formulae_tl_rec.source_lang := l_okl_formulae_tl_rec.source_lang;
3090: END IF;
3091: IF (x_okl_formulae_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3092: THEN
3093: x_okl_formulae_tl_rec.sfwt_flag := l_okl_formulae_tl_rec.sfwt_flag;
3094: END IF;
3095: IF (x_okl_formulae_tl_rec.description = OKC_API.G_MISS_CHAR)
3096: THEN
3097: x_okl_formulae_tl_rec.description := l_okl_formulae_tl_rec.description;

Line 3095: IF (x_okl_formulae_tl_rec.description = OKC_API.G_MISS_CHAR)

3091: IF (x_okl_formulae_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3092: THEN
3093: x_okl_formulae_tl_rec.sfwt_flag := l_okl_formulae_tl_rec.sfwt_flag;
3094: END IF;
3095: IF (x_okl_formulae_tl_rec.description = OKC_API.G_MISS_CHAR)
3096: THEN
3097: x_okl_formulae_tl_rec.description := l_okl_formulae_tl_rec.description;
3098: END IF;
3099: IF (x_okl_formulae_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 3097: x_okl_formulae_tl_rec.description := l_okl_formulae_tl_rec.description;

3093: x_okl_formulae_tl_rec.sfwt_flag := l_okl_formulae_tl_rec.sfwt_flag;
3094: END IF;
3095: IF (x_okl_formulae_tl_rec.description = OKC_API.G_MISS_CHAR)
3096: THEN
3097: x_okl_formulae_tl_rec.description := l_okl_formulae_tl_rec.description;
3098: END IF;
3099: IF (x_okl_formulae_tl_rec.created_by = OKC_API.G_MISS_NUM)
3100: THEN
3101: x_okl_formulae_tl_rec.created_by := l_okl_formulae_tl_rec.created_by;

Line 3099: IF (x_okl_formulae_tl_rec.created_by = OKC_API.G_MISS_NUM)

3095: IF (x_okl_formulae_tl_rec.description = OKC_API.G_MISS_CHAR)
3096: THEN
3097: x_okl_formulae_tl_rec.description := l_okl_formulae_tl_rec.description;
3098: END IF;
3099: IF (x_okl_formulae_tl_rec.created_by = OKC_API.G_MISS_NUM)
3100: THEN
3101: x_okl_formulae_tl_rec.created_by := l_okl_formulae_tl_rec.created_by;
3102: END IF;
3103: IF (x_okl_formulae_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 3101: x_okl_formulae_tl_rec.created_by := l_okl_formulae_tl_rec.created_by;

3097: x_okl_formulae_tl_rec.description := l_okl_formulae_tl_rec.description;
3098: END IF;
3099: IF (x_okl_formulae_tl_rec.created_by = OKC_API.G_MISS_NUM)
3100: THEN
3101: x_okl_formulae_tl_rec.created_by := l_okl_formulae_tl_rec.created_by;
3102: END IF;
3103: IF (x_okl_formulae_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3104: THEN
3105: x_okl_formulae_tl_rec.creation_date := l_okl_formulae_tl_rec.creation_date;

Line 3103: IF (x_okl_formulae_tl_rec.creation_date = OKC_API.G_MISS_DATE)

3099: IF (x_okl_formulae_tl_rec.created_by = OKC_API.G_MISS_NUM)
3100: THEN
3101: x_okl_formulae_tl_rec.created_by := l_okl_formulae_tl_rec.created_by;
3102: END IF;
3103: IF (x_okl_formulae_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3104: THEN
3105: x_okl_formulae_tl_rec.creation_date := l_okl_formulae_tl_rec.creation_date;
3106: END IF;
3107: IF (x_okl_formulae_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 3105: x_okl_formulae_tl_rec.creation_date := l_okl_formulae_tl_rec.creation_date;

3101: x_okl_formulae_tl_rec.created_by := l_okl_formulae_tl_rec.created_by;
3102: END IF;
3103: IF (x_okl_formulae_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3104: THEN
3105: x_okl_formulae_tl_rec.creation_date := l_okl_formulae_tl_rec.creation_date;
3106: END IF;
3107: IF (x_okl_formulae_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3108: THEN
3109: x_okl_formulae_tl_rec.last_updated_by := l_okl_formulae_tl_rec.last_updated_by;

Line 3107: IF (x_okl_formulae_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

3103: IF (x_okl_formulae_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3104: THEN
3105: x_okl_formulae_tl_rec.creation_date := l_okl_formulae_tl_rec.creation_date;
3106: END IF;
3107: IF (x_okl_formulae_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3108: THEN
3109: x_okl_formulae_tl_rec.last_updated_by := l_okl_formulae_tl_rec.last_updated_by;
3110: END IF;
3111: IF (x_okl_formulae_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 3109: x_okl_formulae_tl_rec.last_updated_by := l_okl_formulae_tl_rec.last_updated_by;

3105: x_okl_formulae_tl_rec.creation_date := l_okl_formulae_tl_rec.creation_date;
3106: END IF;
3107: IF (x_okl_formulae_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3108: THEN
3109: x_okl_formulae_tl_rec.last_updated_by := l_okl_formulae_tl_rec.last_updated_by;
3110: END IF;
3111: IF (x_okl_formulae_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3112: THEN
3113: x_okl_formulae_tl_rec.last_update_date := l_okl_formulae_tl_rec.last_update_date;

Line 3111: IF (x_okl_formulae_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

3107: IF (x_okl_formulae_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3108: THEN
3109: x_okl_formulae_tl_rec.last_updated_by := l_okl_formulae_tl_rec.last_updated_by;
3110: END IF;
3111: IF (x_okl_formulae_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3112: THEN
3113: x_okl_formulae_tl_rec.last_update_date := l_okl_formulae_tl_rec.last_update_date;
3114: END IF;
3115: IF (x_okl_formulae_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 3113: x_okl_formulae_tl_rec.last_update_date := l_okl_formulae_tl_rec.last_update_date;

3109: x_okl_formulae_tl_rec.last_updated_by := l_okl_formulae_tl_rec.last_updated_by;
3110: END IF;
3111: IF (x_okl_formulae_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3112: THEN
3113: x_okl_formulae_tl_rec.last_update_date := l_okl_formulae_tl_rec.last_update_date;
3114: END IF;
3115: IF (x_okl_formulae_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3116: THEN
3117: x_okl_formulae_tl_rec.last_update_login := l_okl_formulae_tl_rec.last_update_login;

Line 3115: IF (x_okl_formulae_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

3111: IF (x_okl_formulae_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3112: THEN
3113: x_okl_formulae_tl_rec.last_update_date := l_okl_formulae_tl_rec.last_update_date;
3114: END IF;
3115: IF (x_okl_formulae_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3116: THEN
3117: x_okl_formulae_tl_rec.last_update_login := l_okl_formulae_tl_rec.last_update_login;
3118: END IF;
3119: RETURN(l_return_status);

Line 3117: x_okl_formulae_tl_rec.last_update_login := l_okl_formulae_tl_rec.last_update_login;

3113: x_okl_formulae_tl_rec.last_update_date := l_okl_formulae_tl_rec.last_update_date;
3114: END IF;
3115: IF (x_okl_formulae_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3116: THEN
3117: x_okl_formulae_tl_rec.last_update_login := l_okl_formulae_tl_rec.last_update_login;
3118: END IF;
3119: RETURN(l_return_status);
3120: END populate_new_record;
3121: ----------------------------------------

Line 3122: -- Set_Attributes for:OKL_FORMULAE_TL --

3118: END IF;
3119: RETURN(l_return_status);
3120: END populate_new_record;
3121: ----------------------------------------
3122: -- Set_Attributes for:OKL_FORMULAE_TL --
3123: ----------------------------------------
3124: FUNCTION Set_Attributes (
3125: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
3126: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type

Line 3125: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,

3121: ----------------------------------------
3122: -- Set_Attributes for:OKL_FORMULAE_TL --
3123: ----------------------------------------
3124: FUNCTION Set_Attributes (
3125: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
3126: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
3127: ) RETURN VARCHAR2 IS
3128: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3129: BEGIN

Line 3126: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type

3122: -- Set_Attributes for:OKL_FORMULAE_TL --
3123: ----------------------------------------
3124: FUNCTION Set_Attributes (
3125: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
3126: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
3127: ) RETURN VARCHAR2 IS
3128: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3129: BEGIN
3130: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;

Line 3130: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;

3126: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
3127: ) RETURN VARCHAR2 IS
3128: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3129: BEGIN
3130: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;
3131: x_okl_formulae_tl_rec.LANGUAGE := USERENV('LANG');
3132: x_okl_formulae_tl_rec.SOURCE_LANG := USERENV('LANG');
3133: RETURN(l_return_status);
3134: END Set_Attributes;

Line 3131: x_okl_formulae_tl_rec.LANGUAGE := USERENV('LANG');

3127: ) RETURN VARCHAR2 IS
3128: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3129: BEGIN
3130: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;
3131: x_okl_formulae_tl_rec.LANGUAGE := USERENV('LANG');
3132: x_okl_formulae_tl_rec.SOURCE_LANG := USERENV('LANG');
3133: RETURN(l_return_status);
3134: END Set_Attributes;
3135: BEGIN

Line 3132: x_okl_formulae_tl_rec.SOURCE_LANG := USERENV('LANG');

3128: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3129: BEGIN
3130: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;
3131: x_okl_formulae_tl_rec.LANGUAGE := USERENV('LANG');
3132: x_okl_formulae_tl_rec.SOURCE_LANG := USERENV('LANG');
3133: RETURN(l_return_status);
3134: END Set_Attributes;
3135: BEGIN
3136: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3147: p_okl_formulae_tl_rec, -- IN

3143: RAISE OKC_API.G_EXCEPTION_ERROR;
3144: END IF;
3145: --- Setting item attributes
3146: l_return_status := Set_Attributes(
3147: p_okl_formulae_tl_rec, -- IN
3148: l_okl_formulae_tl_rec); -- OUT
3149: --- If any errors happen abort API
3150: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3151: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3148: l_okl_formulae_tl_rec); -- OUT

3144: END IF;
3145: --- Setting item attributes
3146: l_return_status := Set_Attributes(
3147: p_okl_formulae_tl_rec, -- IN
3148: l_okl_formulae_tl_rec); -- OUT
3149: --- If any errors happen abort API
3150: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3151: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3152: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3155: l_return_status := populate_new_record(l_okl_formulae_tl_rec, l_def_okl_formulae_tl_rec);

3151: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3152: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3153: RAISE OKC_API.G_EXCEPTION_ERROR;
3154: END IF;
3155: l_return_status := populate_new_record(l_okl_formulae_tl_rec, l_def_okl_formulae_tl_rec);
3156: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3157: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3158: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3159: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3161: UPDATE OKL_FORMULAE_TL

3157: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3158: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3159: RAISE OKC_API.G_EXCEPTION_ERROR;
3160: END IF;
3161: UPDATE OKL_FORMULAE_TL
3162: SET DESCRIPTION = l_def_okl_formulae_tl_rec.description,
3163: CREATED_BY = l_def_okl_formulae_tl_rec.created_by,
3164: SOURCE_LANG = l_def_okl_formulae_tl_rec.source_lang,
3165: CREATION_DATE = l_def_okl_formulae_tl_rec.creation_date,

Line 3162: SET DESCRIPTION = l_def_okl_formulae_tl_rec.description,

3158: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3159: RAISE OKC_API.G_EXCEPTION_ERROR;
3160: END IF;
3161: UPDATE OKL_FORMULAE_TL
3162: SET DESCRIPTION = l_def_okl_formulae_tl_rec.description,
3163: CREATED_BY = l_def_okl_formulae_tl_rec.created_by,
3164: SOURCE_LANG = l_def_okl_formulae_tl_rec.source_lang,
3165: CREATION_DATE = l_def_okl_formulae_tl_rec.creation_date,
3166: LAST_UPDATED_BY = l_def_okl_formulae_tl_rec.last_updated_by,

Line 3163: CREATED_BY = l_def_okl_formulae_tl_rec.created_by,

3159: RAISE OKC_API.G_EXCEPTION_ERROR;
3160: END IF;
3161: UPDATE OKL_FORMULAE_TL
3162: SET DESCRIPTION = l_def_okl_formulae_tl_rec.description,
3163: CREATED_BY = l_def_okl_formulae_tl_rec.created_by,
3164: SOURCE_LANG = l_def_okl_formulae_tl_rec.source_lang,
3165: CREATION_DATE = l_def_okl_formulae_tl_rec.creation_date,
3166: LAST_UPDATED_BY = l_def_okl_formulae_tl_rec.last_updated_by,
3167: LAST_UPDATE_DATE = l_def_okl_formulae_tl_rec.last_update_date,

Line 3164: SOURCE_LANG = l_def_okl_formulae_tl_rec.source_lang,

3160: END IF;
3161: UPDATE OKL_FORMULAE_TL
3162: SET DESCRIPTION = l_def_okl_formulae_tl_rec.description,
3163: CREATED_BY = l_def_okl_formulae_tl_rec.created_by,
3164: SOURCE_LANG = l_def_okl_formulae_tl_rec.source_lang,
3165: CREATION_DATE = l_def_okl_formulae_tl_rec.creation_date,
3166: LAST_UPDATED_BY = l_def_okl_formulae_tl_rec.last_updated_by,
3167: LAST_UPDATE_DATE = l_def_okl_formulae_tl_rec.last_update_date,
3168: LAST_UPDATE_LOGIN = l_def_okl_formulae_tl_rec.last_update_login

Line 3165: CREATION_DATE = l_def_okl_formulae_tl_rec.creation_date,

3161: UPDATE OKL_FORMULAE_TL
3162: SET DESCRIPTION = l_def_okl_formulae_tl_rec.description,
3163: CREATED_BY = l_def_okl_formulae_tl_rec.created_by,
3164: SOURCE_LANG = l_def_okl_formulae_tl_rec.source_lang,
3165: CREATION_DATE = l_def_okl_formulae_tl_rec.creation_date,
3166: LAST_UPDATED_BY = l_def_okl_formulae_tl_rec.last_updated_by,
3167: LAST_UPDATE_DATE = l_def_okl_formulae_tl_rec.last_update_date,
3168: LAST_UPDATE_LOGIN = l_def_okl_formulae_tl_rec.last_update_login
3169: WHERE ID = l_def_okl_formulae_tl_rec.id

Line 3166: LAST_UPDATED_BY = l_def_okl_formulae_tl_rec.last_updated_by,

3162: SET DESCRIPTION = l_def_okl_formulae_tl_rec.description,
3163: CREATED_BY = l_def_okl_formulae_tl_rec.created_by,
3164: SOURCE_LANG = l_def_okl_formulae_tl_rec.source_lang,
3165: CREATION_DATE = l_def_okl_formulae_tl_rec.creation_date,
3166: LAST_UPDATED_BY = l_def_okl_formulae_tl_rec.last_updated_by,
3167: LAST_UPDATE_DATE = l_def_okl_formulae_tl_rec.last_update_date,
3168: LAST_UPDATE_LOGIN = l_def_okl_formulae_tl_rec.last_update_login
3169: WHERE ID = l_def_okl_formulae_tl_rec.id
3170: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);

Line 3167: LAST_UPDATE_DATE = l_def_okl_formulae_tl_rec.last_update_date,

3163: CREATED_BY = l_def_okl_formulae_tl_rec.created_by,
3164: SOURCE_LANG = l_def_okl_formulae_tl_rec.source_lang,
3165: CREATION_DATE = l_def_okl_formulae_tl_rec.creation_date,
3166: LAST_UPDATED_BY = l_def_okl_formulae_tl_rec.last_updated_by,
3167: LAST_UPDATE_DATE = l_def_okl_formulae_tl_rec.last_update_date,
3168: LAST_UPDATE_LOGIN = l_def_okl_formulae_tl_rec.last_update_login
3169: WHERE ID = l_def_okl_formulae_tl_rec.id
3170: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
3171: --AND SOURCE_LANG = USERENV('LANG');

Line 3168: LAST_UPDATE_LOGIN = l_def_okl_formulae_tl_rec.last_update_login

3164: SOURCE_LANG = l_def_okl_formulae_tl_rec.source_lang,
3165: CREATION_DATE = l_def_okl_formulae_tl_rec.creation_date,
3166: LAST_UPDATED_BY = l_def_okl_formulae_tl_rec.last_updated_by,
3167: LAST_UPDATE_DATE = l_def_okl_formulae_tl_rec.last_update_date,
3168: LAST_UPDATE_LOGIN = l_def_okl_formulae_tl_rec.last_update_login
3169: WHERE ID = l_def_okl_formulae_tl_rec.id
3170: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
3171: --AND SOURCE_LANG = USERENV('LANG');
3172:

Line 3169: WHERE ID = l_def_okl_formulae_tl_rec.id

3165: CREATION_DATE = l_def_okl_formulae_tl_rec.creation_date,
3166: LAST_UPDATED_BY = l_def_okl_formulae_tl_rec.last_updated_by,
3167: LAST_UPDATE_DATE = l_def_okl_formulae_tl_rec.last_update_date,
3168: LAST_UPDATE_LOGIN = l_def_okl_formulae_tl_rec.last_update_login
3169: WHERE ID = l_def_okl_formulae_tl_rec.id
3170: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
3171: --AND SOURCE_LANG = USERENV('LANG');
3172:
3173: UPDATE OKL_FORMULAE_TL

Line 3173: UPDATE OKL_FORMULAE_TL

3169: WHERE ID = l_def_okl_formulae_tl_rec.id
3170: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
3171: --AND SOURCE_LANG = USERENV('LANG');
3172:
3173: UPDATE OKL_FORMULAE_TL
3174: SET SFWT_FLAG = 'Y'
3175: WHERE ID = l_def_okl_formulae_tl_rec.id
3176: AND SOURCE_LANG <> USERENV('LANG');
3177:

Line 3175: WHERE ID = l_def_okl_formulae_tl_rec.id

3171: --AND SOURCE_LANG = USERENV('LANG');
3172:
3173: UPDATE OKL_FORMULAE_TL
3174: SET SFWT_FLAG = 'Y'
3175: WHERE ID = l_def_okl_formulae_tl_rec.id
3176: AND SOURCE_LANG <> USERENV('LANG');
3177:
3178: x_okl_formulae_tl_rec := l_def_okl_formulae_tl_rec;
3179: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3178: x_okl_formulae_tl_rec := l_def_okl_formulae_tl_rec;

3174: SET SFWT_FLAG = 'Y'
3175: WHERE ID = l_def_okl_formulae_tl_rec.id
3176: AND SOURCE_LANG <> USERENV('LANG');
3177:
3178: x_okl_formulae_tl_rec := l_def_okl_formulae_tl_rec;
3179: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3180: EXCEPTION
3181: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3182: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3229: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;

3225: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3226: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3227: l_fmav_rec fmav_rec_type := p_fmav_rec;
3228: l_def_fmav_rec fmav_rec_type;
3229: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
3230: lx_okl_formulae_tl_rec okl_formulae_tl_rec_type;
3231: l_fma_rec fma_rec_type;
3232: lx_fma_rec fma_rec_type;
3233: -------------------------------

Line 3230: lx_okl_formulae_tl_rec okl_formulae_tl_rec_type;

3226: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3227: l_fmav_rec fmav_rec_type := p_fmav_rec;
3228: l_def_fmav_rec fmav_rec_type;
3229: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
3230: lx_okl_formulae_tl_rec okl_formulae_tl_rec_type;
3231: l_fma_rec fma_rec_type;
3232: lx_fma_rec fma_rec_type;
3233: -------------------------------
3234: -- FUNCTION fill_who_columns --

Line 3461: migrate(l_def_fmav_rec, l_okl_formulae_tl_rec);

3457: END IF;
3458: --------------------------------------
3459: -- Move VIEW record to "Child" records
3460: --------------------------------------
3461: migrate(l_def_fmav_rec, l_okl_formulae_tl_rec);
3462: migrate(l_def_fmav_rec, l_fma_rec);
3463: --------------------------------------------
3464: -- Call the UPDATE_ROW for each child record
3465: --------------------------------------------

Line 3471: l_okl_formulae_tl_rec,

3467: p_init_msg_list,
3468: x_return_status,
3469: x_msg_count,
3470: x_msg_data,
3471: l_okl_formulae_tl_rec,
3472: lx_okl_formulae_tl_rec
3473: );
3474: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3475: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3472: lx_okl_formulae_tl_rec

3468: x_return_status,
3469: x_msg_count,
3470: x_msg_data,
3471: l_okl_formulae_tl_rec,
3472: lx_okl_formulae_tl_rec
3473: );
3474: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3475: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3476: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3479: migrate(lx_okl_formulae_tl_rec, l_def_fmav_rec);

3475: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3476: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3477: RAISE OKC_API.G_EXCEPTION_ERROR;
3478: END IF;
3479: migrate(lx_okl_formulae_tl_rec, l_def_fmav_rec);
3480: update_row(
3481: p_init_msg_list,
3482: x_return_status,
3483: x_msg_count,

Line 3671: -- delete_row for:OKL_FORMULAE_TL --

3667: '_PVT'
3668: );
3669: END delete_row;
3670: ------------------------------------
3671: -- delete_row for:OKL_FORMULAE_TL --
3672: ------------------------------------
3673: PROCEDURE delete_row(
3674: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3675: x_return_status OUT NOCOPY VARCHAR2,

Line 3678: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type) IS

3674: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3675: x_return_status OUT NOCOPY VARCHAR2,
3676: x_msg_count OUT NOCOPY NUMBER,
3677: x_msg_data OUT NOCOPY VARCHAR2,
3678: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type) IS
3679:
3680: l_api_version CONSTANT NUMBER := 1;
3681: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3682: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3683: l_okl_formulae_tl_rec okl_formulae_tl_rec_type:= p_okl_formulae_tl_rec;

3679:
3680: l_api_version CONSTANT NUMBER := 1;
3681: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3682: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3683: l_okl_formulae_tl_rec okl_formulae_tl_rec_type:= p_okl_formulae_tl_rec;
3684: l_row_notfound BOOLEAN := TRUE;
3685: ----------------------------------------
3686: -- Set_Attributes for:OKL_FORMULAE_TL --
3687: ----------------------------------------

Line 3686: -- Set_Attributes for:OKL_FORMULAE_TL --

3682: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3683: l_okl_formulae_tl_rec okl_formulae_tl_rec_type:= p_okl_formulae_tl_rec;
3684: l_row_notfound BOOLEAN := TRUE;
3685: ----------------------------------------
3686: -- Set_Attributes for:OKL_FORMULAE_TL --
3687: ----------------------------------------
3688: FUNCTION Set_Attributes (
3689: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
3690: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type

Line 3689: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,

3685: ----------------------------------------
3686: -- Set_Attributes for:OKL_FORMULAE_TL --
3687: ----------------------------------------
3688: FUNCTION Set_Attributes (
3689: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
3690: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
3691: ) RETURN VARCHAR2 IS
3692: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3693: BEGIN

Line 3690: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type

3686: -- Set_Attributes for:OKL_FORMULAE_TL --
3687: ----------------------------------------
3688: FUNCTION Set_Attributes (
3689: p_okl_formulae_tl_rec IN okl_formulae_tl_rec_type,
3690: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
3691: ) RETURN VARCHAR2 IS
3692: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3693: BEGIN
3694: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;

Line 3694: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;

3690: x_okl_formulae_tl_rec OUT NOCOPY okl_formulae_tl_rec_type
3691: ) RETURN VARCHAR2 IS
3692: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3693: BEGIN
3694: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;
3695: x_okl_formulae_tl_rec.LANGUAGE := USERENV('LANG');
3696: RETURN(l_return_status);
3697: END Set_Attributes;
3698: BEGIN

Line 3695: x_okl_formulae_tl_rec.LANGUAGE := USERENV('LANG');

3691: ) RETURN VARCHAR2 IS
3692: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3693: BEGIN
3694: x_okl_formulae_tl_rec := p_okl_formulae_tl_rec;
3695: x_okl_formulae_tl_rec.LANGUAGE := USERENV('LANG');
3696: RETURN(l_return_status);
3697: END Set_Attributes;
3698: BEGIN
3699: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3710: p_okl_formulae_tl_rec, -- IN

3706: RAISE OKC_API.G_EXCEPTION_ERROR;
3707: END IF;
3708: --- Setting item attributes
3709: l_return_status := Set_Attributes(
3710: p_okl_formulae_tl_rec, -- IN
3711: l_okl_formulae_tl_rec); -- OUT
3712: --- If any errors happen abort API
3713: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3711: l_okl_formulae_tl_rec); -- OUT

3707: END IF;
3708: --- Setting item attributes
3709: l_return_status := Set_Attributes(
3710: p_okl_formulae_tl_rec, -- IN
3711: l_okl_formulae_tl_rec); -- OUT
3712: --- If any errors happen abort API
3713: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3715: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3718: DELETE FROM OKL_FORMULAE_TL

3714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3715: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3716: RAISE OKC_API.G_EXCEPTION_ERROR;
3717: END IF;
3718: DELETE FROM OKL_FORMULAE_TL
3719: WHERE ID = l_okl_formulae_tl_rec.id;
3720:
3721: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3722: EXCEPTION

Line 3719: WHERE ID = l_okl_formulae_tl_rec.id;

3715: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3716: RAISE OKC_API.G_EXCEPTION_ERROR;
3717: END IF;
3718: DELETE FROM OKL_FORMULAE_TL
3719: WHERE ID = l_okl_formulae_tl_rec.id;
3720:
3721: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3722: EXCEPTION
3723: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3769: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;

3765: l_api_version CONSTANT NUMBER := 1;
3766: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3767: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3768: l_fmav_rec fmav_rec_type := p_fmav_rec;
3769: l_okl_formulae_tl_rec okl_formulae_tl_rec_type;
3770: l_fma_rec fma_rec_type;
3771: BEGIN
3772: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3773: G_PKG_NAME,

Line 3787: migrate(l_fmav_rec, l_okl_formulae_tl_rec);

3783: END IF;
3784: --------------------------------------
3785: -- Move VIEW record to "Child" records
3786: --------------------------------------
3787: migrate(l_fmav_rec, l_okl_formulae_tl_rec);
3788: migrate(l_fmav_rec, l_fma_rec);
3789: --------------------------------------------
3790: -- Call the DELETE_ROW for each child record
3791: --------------------------------------------

Line 3797: l_okl_formulae_tl_rec

3793: p_init_msg_list,
3794: x_return_status,
3795: x_msg_count,
3796: x_msg_data,
3797: l_okl_formulae_tl_rec
3798: );
3799: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3801: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3947: FROM OKL_FORMULAE_TL

3943: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
3944:
3945: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
3946: INTO db_luby, db_ludate
3947: FROM OKL_FORMULAE_TL
3948: where ID = to_number(p_fmav_rec.id)
3949: and USERENV('LANG') =language;
3950:
3951: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 3954: UPDATE OKL_FORMULAE_TL

3950:
3951: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3952: db_ludate, '')) then
3953: --Update TL
3954: UPDATE OKL_FORMULAE_TL
3955: SET DESCRIPTION = p_fmav_rec.DESCRIPTION,
3956: LAST_UPDATE_DATE = f_ludate,
3957: LAST_UPDATED_BY = f_luby,
3958: LAST_UPDATE_LOGIN = 0,

Line 4026: UPDATE OKL_FORMULAE_TL

4022: LAST_UPDATE_LOGIN = 0
4023: WHERE ID = to_number(p_fmav_rec.id);
4024: --Update _TL
4025:
4026: UPDATE OKL_FORMULAE_TL
4027: SET
4028: DESCRIPTION = p_fmav_rec.DESCRIPTION,
4029: LAST_UPDATE_DATE = f_ludate,
4030: LAST_UPDATED_BY = f_luby,

Line 4037: INSERT INTO OKL_FORMULAE_TL

4033: WHERE ID = to_number(p_fmav_rec.id)
4034: AND USERENV('LANG') IN (language,source_lang);
4035:
4036: IF(sql%notfound) THEN
4037: INSERT INTO OKL_FORMULAE_TL
4038: (
4039: ID,
4040: LANGUAGE,
4041: SOURCE_LANG,

Line 4065: FROM OKL_FORMULAE_TL TL

4061: FROM FND_LANGUAGES L
4062: WHERE L.INSTALLED_FLAG IN ('I','B')
4063: AND NOT EXISTS
4064: (SELECT NULL
4065: FROM OKL_FORMULAE_TL TL
4066: WHERE TL.ID = TO_NUMBER(p_fmav_rec.id)
4067: AND TL.LANGUAGE = L.LANGUAGE_CODE);
4068: END IF;
4069:

Line 4150: INSERT INTO OKL_FORMULAE_TL

4146: from OKL_FORMULAE_B
4147: where ( ID = TO_NUMBER(p_fmav_rec.id) OR
4148: (NAME = p_fmav_rec.NAME AND VERSION = p_fmav_rec.VERSION)));
4149:
4150: INSERT INTO OKL_FORMULAE_TL
4151: (
4152: ID,
4153: LANGUAGE,
4154: SOURCE_LANG,

Line 4177: FROM OKL_FORMULAE_TL TL

4173: FROM FND_LANGUAGES L
4174: WHERE L.INSTALLED_FLAG IN ('I','B')
4175: AND NOT EXISTS
4176: (SELECT NULL
4177: FROM OKL_FORMULAE_TL TL
4178: WHERE TL.ID = TO_NUMBER(p_fmav_rec.id)
4179: AND TL.LANGUAGE = L.LANGUAGE_CODE);
4180:
4181: END LOAD_ROW;