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_CGR_PVT dependencies on OKL_CONTEXT_GROUPS_TL

Line 40: DELETE FROM OKL_CONTEXT_GROUPS_TL T

36: -- PROCEDURE add_language
37: ---------------------------------------------------------------------------
38: PROCEDURE add_language IS
39: BEGIN
40: DELETE FROM OKL_CONTEXT_GROUPS_TL T
41: WHERE NOT EXISTS (
42: SELECT NULL
43: FROM OKL_CONTEXT_GROUPS_B B
44: WHERE B.ID = T.ID

Line 47: UPDATE OKL_CONTEXT_GROUPS_TL T SET (

43: FROM OKL_CONTEXT_GROUPS_B B
44: WHERE B.ID = T.ID
45: );
46:
47: UPDATE OKL_CONTEXT_GROUPS_TL T SET (
48: DESCRIPTION) = (SELECT
49: B.DESCRIPTION
50: FROM OKL_CONTEXT_GROUPS_TL B
51: WHERE B.ID = T.ID

Line 50: FROM OKL_CONTEXT_GROUPS_TL B

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

Line 59: FROM OKL_CONTEXT_GROUPS_TL SUBB, OKL_CONTEXT_GROUPS_TL SUBT

55: T.LANGUAGE)
56: IN (SELECT
57: SUBT.ID,
58: SUBT.LANGUAGE
59: FROM OKL_CONTEXT_GROUPS_TL SUBB, OKL_CONTEXT_GROUPS_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_CONTEXT_GROUPS_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_CONTEXT_GROUPS_TL (
68: ID,
69: LANGUAGE,
70: SOURCE_LANG,
71: SFWT_FLAG,

Line 89: FROM OKL_CONTEXT_GROUPS_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_CONTEXT_GROUPS_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_CONTEXT_GROUPS_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_CONTEXT_GROUPS_TL T
95: WHERE T.ID = B.ID
96: AND T.LANGUAGE = L.LANGUAGE_CODE
97: );
98:

Line 148: -- FUNCTION get_rec for: OKL_CONTEXT_GROUPS_TL

144: BEGIN
145: RETURN(get_rec(p_cgr_rec, l_row_notfound));
146: END get_rec;
147: ---------------------------------------------------------------------------
148: -- FUNCTION get_rec for: OKL_CONTEXT_GROUPS_TL
149: ---------------------------------------------------------------------------
150: FUNCTION get_rec (
151: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
152: x_no_data_found OUT NOCOPY BOOLEAN

Line 151: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,

147: ---------------------------------------------------------------------------
148: -- FUNCTION get_rec for: OKL_CONTEXT_GROUPS_TL
149: ---------------------------------------------------------------------------
150: FUNCTION get_rec (
151: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
152: x_no_data_found OUT NOCOPY BOOLEAN
153: ) RETURN okl_context_groups_tl_rec_type IS
154: CURSOR okl_context_groups_tl_pk_csr (p_id IN NUMBER,
155: p_language IN VARCHAR2) IS

Line 153: ) RETURN okl_context_groups_tl_rec_type IS

149: ---------------------------------------------------------------------------
150: FUNCTION get_rec (
151: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
152: x_no_data_found OUT NOCOPY BOOLEAN
153: ) RETURN okl_context_groups_tl_rec_type IS
154: CURSOR okl_context_groups_tl_pk_csr (p_id IN NUMBER,
155: p_language IN VARCHAR2) IS
156: SELECT
157: ID,

Line 154: CURSOR okl_context_groups_tl_pk_csr (p_id IN NUMBER,

150: FUNCTION get_rec (
151: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
152: x_no_data_found OUT NOCOPY BOOLEAN
153: ) RETURN okl_context_groups_tl_rec_type IS
154: CURSOR okl_context_groups_tl_pk_csr (p_id IN NUMBER,
155: p_language IN VARCHAR2) IS
156: SELECT
157: ID,
158: LANGUAGE,

Line 167: FROM Okl_Context_Groups_Tl

163: CREATION_DATE,
164: LAST_UPDATED_BY,
165: LAST_UPDATE_DATE,
166: LAST_UPDATE_LOGIN
167: FROM Okl_Context_Groups_Tl
168: WHERE okl_context_groups_tl.id = p_id
169: AND okl_context_groups_tl.language = p_language;
170: l_okl_context_groups_tl_pk okl_context_groups_tl_pk_csr%ROWTYPE;
171: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;

Line 168: WHERE okl_context_groups_tl.id = p_id

164: LAST_UPDATED_BY,
165: LAST_UPDATE_DATE,
166: LAST_UPDATE_LOGIN
167: FROM Okl_Context_Groups_Tl
168: WHERE okl_context_groups_tl.id = p_id
169: AND okl_context_groups_tl.language = p_language;
170: l_okl_context_groups_tl_pk okl_context_groups_tl_pk_csr%ROWTYPE;
171: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
172: BEGIN

Line 169: AND okl_context_groups_tl.language = p_language;

165: LAST_UPDATE_DATE,
166: LAST_UPDATE_LOGIN
167: FROM Okl_Context_Groups_Tl
168: WHERE okl_context_groups_tl.id = p_id
169: AND okl_context_groups_tl.language = p_language;
170: l_okl_context_groups_tl_pk okl_context_groups_tl_pk_csr%ROWTYPE;
171: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
172: BEGIN
173: x_no_data_found := TRUE;

Line 170: l_okl_context_groups_tl_pk okl_context_groups_tl_pk_csr%ROWTYPE;

166: LAST_UPDATE_LOGIN
167: FROM Okl_Context_Groups_Tl
168: WHERE okl_context_groups_tl.id = p_id
169: AND okl_context_groups_tl.language = p_language;
170: l_okl_context_groups_tl_pk okl_context_groups_tl_pk_csr%ROWTYPE;
171: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
172: BEGIN
173: x_no_data_found := TRUE;
174: -- Get current database values

Line 171: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;

167: FROM Okl_Context_Groups_Tl
168: WHERE okl_context_groups_tl.id = p_id
169: AND okl_context_groups_tl.language = p_language;
170: l_okl_context_groups_tl_pk okl_context_groups_tl_pk_csr%ROWTYPE;
171: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
172: BEGIN
173: x_no_data_found := TRUE;
174: -- Get current database values
175: OPEN okl_context_groups_tl_pk_csr (p_okl_context_groups_tl_rec.id,

Line 175: OPEN okl_context_groups_tl_pk_csr (p_okl_context_groups_tl_rec.id,

171: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
172: BEGIN
173: x_no_data_found := TRUE;
174: -- Get current database values
175: OPEN okl_context_groups_tl_pk_csr (p_okl_context_groups_tl_rec.id,
176: p_okl_context_groups_tl_rec.language);
177: FETCH okl_context_groups_tl_pk_csr INTO
178: l_okl_context_groups_tl_rec.ID,
179: l_okl_context_groups_tl_rec.LANGUAGE,

Line 176: p_okl_context_groups_tl_rec.language);

172: BEGIN
173: x_no_data_found := TRUE;
174: -- Get current database values
175: OPEN okl_context_groups_tl_pk_csr (p_okl_context_groups_tl_rec.id,
176: p_okl_context_groups_tl_rec.language);
177: FETCH okl_context_groups_tl_pk_csr INTO
178: l_okl_context_groups_tl_rec.ID,
179: l_okl_context_groups_tl_rec.LANGUAGE,
180: l_okl_context_groups_tl_rec.SOURCE_LANG,

Line 177: FETCH okl_context_groups_tl_pk_csr INTO

173: x_no_data_found := TRUE;
174: -- Get current database values
175: OPEN okl_context_groups_tl_pk_csr (p_okl_context_groups_tl_rec.id,
176: p_okl_context_groups_tl_rec.language);
177: FETCH okl_context_groups_tl_pk_csr INTO
178: l_okl_context_groups_tl_rec.ID,
179: l_okl_context_groups_tl_rec.LANGUAGE,
180: l_okl_context_groups_tl_rec.SOURCE_LANG,
181: l_okl_context_groups_tl_rec.SFWT_FLAG,

Line 178: l_okl_context_groups_tl_rec.ID,

174: -- Get current database values
175: OPEN okl_context_groups_tl_pk_csr (p_okl_context_groups_tl_rec.id,
176: p_okl_context_groups_tl_rec.language);
177: FETCH okl_context_groups_tl_pk_csr INTO
178: l_okl_context_groups_tl_rec.ID,
179: l_okl_context_groups_tl_rec.LANGUAGE,
180: l_okl_context_groups_tl_rec.SOURCE_LANG,
181: l_okl_context_groups_tl_rec.SFWT_FLAG,
182: l_okl_context_groups_tl_rec.DESCRIPTION,

Line 179: l_okl_context_groups_tl_rec.LANGUAGE,

175: OPEN okl_context_groups_tl_pk_csr (p_okl_context_groups_tl_rec.id,
176: p_okl_context_groups_tl_rec.language);
177: FETCH okl_context_groups_tl_pk_csr INTO
178: l_okl_context_groups_tl_rec.ID,
179: l_okl_context_groups_tl_rec.LANGUAGE,
180: l_okl_context_groups_tl_rec.SOURCE_LANG,
181: l_okl_context_groups_tl_rec.SFWT_FLAG,
182: l_okl_context_groups_tl_rec.DESCRIPTION,
183: l_okl_context_groups_tl_rec.CREATED_BY,

Line 180: l_okl_context_groups_tl_rec.SOURCE_LANG,

176: p_okl_context_groups_tl_rec.language);
177: FETCH okl_context_groups_tl_pk_csr INTO
178: l_okl_context_groups_tl_rec.ID,
179: l_okl_context_groups_tl_rec.LANGUAGE,
180: l_okl_context_groups_tl_rec.SOURCE_LANG,
181: l_okl_context_groups_tl_rec.SFWT_FLAG,
182: l_okl_context_groups_tl_rec.DESCRIPTION,
183: l_okl_context_groups_tl_rec.CREATED_BY,
184: l_okl_context_groups_tl_rec.CREATION_DATE,

Line 181: l_okl_context_groups_tl_rec.SFWT_FLAG,

177: FETCH okl_context_groups_tl_pk_csr INTO
178: l_okl_context_groups_tl_rec.ID,
179: l_okl_context_groups_tl_rec.LANGUAGE,
180: l_okl_context_groups_tl_rec.SOURCE_LANG,
181: l_okl_context_groups_tl_rec.SFWT_FLAG,
182: l_okl_context_groups_tl_rec.DESCRIPTION,
183: l_okl_context_groups_tl_rec.CREATED_BY,
184: l_okl_context_groups_tl_rec.CREATION_DATE,
185: l_okl_context_groups_tl_rec.LAST_UPDATED_BY,

Line 182: l_okl_context_groups_tl_rec.DESCRIPTION,

178: l_okl_context_groups_tl_rec.ID,
179: l_okl_context_groups_tl_rec.LANGUAGE,
180: l_okl_context_groups_tl_rec.SOURCE_LANG,
181: l_okl_context_groups_tl_rec.SFWT_FLAG,
182: l_okl_context_groups_tl_rec.DESCRIPTION,
183: l_okl_context_groups_tl_rec.CREATED_BY,
184: l_okl_context_groups_tl_rec.CREATION_DATE,
185: l_okl_context_groups_tl_rec.LAST_UPDATED_BY,
186: l_okl_context_groups_tl_rec.LAST_UPDATE_DATE,

Line 183: l_okl_context_groups_tl_rec.CREATED_BY,

179: l_okl_context_groups_tl_rec.LANGUAGE,
180: l_okl_context_groups_tl_rec.SOURCE_LANG,
181: l_okl_context_groups_tl_rec.SFWT_FLAG,
182: l_okl_context_groups_tl_rec.DESCRIPTION,
183: l_okl_context_groups_tl_rec.CREATED_BY,
184: l_okl_context_groups_tl_rec.CREATION_DATE,
185: l_okl_context_groups_tl_rec.LAST_UPDATED_BY,
186: l_okl_context_groups_tl_rec.LAST_UPDATE_DATE,
187: l_okl_context_groups_tl_rec.LAST_UPDATE_LOGIN;

Line 184: l_okl_context_groups_tl_rec.CREATION_DATE,

180: l_okl_context_groups_tl_rec.SOURCE_LANG,
181: l_okl_context_groups_tl_rec.SFWT_FLAG,
182: l_okl_context_groups_tl_rec.DESCRIPTION,
183: l_okl_context_groups_tl_rec.CREATED_BY,
184: l_okl_context_groups_tl_rec.CREATION_DATE,
185: l_okl_context_groups_tl_rec.LAST_UPDATED_BY,
186: l_okl_context_groups_tl_rec.LAST_UPDATE_DATE,
187: l_okl_context_groups_tl_rec.LAST_UPDATE_LOGIN;
188: x_no_data_found := okl_context_groups_tl_pk_csr%NOTFOUND;

Line 185: l_okl_context_groups_tl_rec.LAST_UPDATED_BY,

181: l_okl_context_groups_tl_rec.SFWT_FLAG,
182: l_okl_context_groups_tl_rec.DESCRIPTION,
183: l_okl_context_groups_tl_rec.CREATED_BY,
184: l_okl_context_groups_tl_rec.CREATION_DATE,
185: l_okl_context_groups_tl_rec.LAST_UPDATED_BY,
186: l_okl_context_groups_tl_rec.LAST_UPDATE_DATE,
187: l_okl_context_groups_tl_rec.LAST_UPDATE_LOGIN;
188: x_no_data_found := okl_context_groups_tl_pk_csr%NOTFOUND;
189: CLOSE okl_context_groups_tl_pk_csr;

Line 186: l_okl_context_groups_tl_rec.LAST_UPDATE_DATE,

182: l_okl_context_groups_tl_rec.DESCRIPTION,
183: l_okl_context_groups_tl_rec.CREATED_BY,
184: l_okl_context_groups_tl_rec.CREATION_DATE,
185: l_okl_context_groups_tl_rec.LAST_UPDATED_BY,
186: l_okl_context_groups_tl_rec.LAST_UPDATE_DATE,
187: l_okl_context_groups_tl_rec.LAST_UPDATE_LOGIN;
188: x_no_data_found := okl_context_groups_tl_pk_csr%NOTFOUND;
189: CLOSE okl_context_groups_tl_pk_csr;
190: RETURN(l_okl_context_groups_tl_rec);

Line 187: l_okl_context_groups_tl_rec.LAST_UPDATE_LOGIN;

183: l_okl_context_groups_tl_rec.CREATED_BY,
184: l_okl_context_groups_tl_rec.CREATION_DATE,
185: l_okl_context_groups_tl_rec.LAST_UPDATED_BY,
186: l_okl_context_groups_tl_rec.LAST_UPDATE_DATE,
187: l_okl_context_groups_tl_rec.LAST_UPDATE_LOGIN;
188: x_no_data_found := okl_context_groups_tl_pk_csr%NOTFOUND;
189: CLOSE okl_context_groups_tl_pk_csr;
190: RETURN(l_okl_context_groups_tl_rec);
191: END get_rec;

Line 188: x_no_data_found := okl_context_groups_tl_pk_csr%NOTFOUND;

184: l_okl_context_groups_tl_rec.CREATION_DATE,
185: l_okl_context_groups_tl_rec.LAST_UPDATED_BY,
186: l_okl_context_groups_tl_rec.LAST_UPDATE_DATE,
187: l_okl_context_groups_tl_rec.LAST_UPDATE_LOGIN;
188: x_no_data_found := okl_context_groups_tl_pk_csr%NOTFOUND;
189: CLOSE okl_context_groups_tl_pk_csr;
190: RETURN(l_okl_context_groups_tl_rec);
191: END get_rec;
192:

Line 189: CLOSE okl_context_groups_tl_pk_csr;

185: l_okl_context_groups_tl_rec.LAST_UPDATED_BY,
186: l_okl_context_groups_tl_rec.LAST_UPDATE_DATE,
187: l_okl_context_groups_tl_rec.LAST_UPDATE_LOGIN;
188: x_no_data_found := okl_context_groups_tl_pk_csr%NOTFOUND;
189: CLOSE okl_context_groups_tl_pk_csr;
190: RETURN(l_okl_context_groups_tl_rec);
191: END get_rec;
192:
193: FUNCTION get_rec (

Line 190: RETURN(l_okl_context_groups_tl_rec);

186: l_okl_context_groups_tl_rec.LAST_UPDATE_DATE,
187: l_okl_context_groups_tl_rec.LAST_UPDATE_LOGIN;
188: x_no_data_found := okl_context_groups_tl_pk_csr%NOTFOUND;
189: CLOSE okl_context_groups_tl_pk_csr;
190: RETURN(l_okl_context_groups_tl_rec);
191: END get_rec;
192:
193: FUNCTION get_rec (
194: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type

Line 194: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type

190: RETURN(l_okl_context_groups_tl_rec);
191: END get_rec;
192:
193: FUNCTION get_rec (
194: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type
195: ) RETURN okl_context_groups_tl_rec_type IS
196: l_row_notfound BOOLEAN := TRUE;
197: BEGIN
198: RETURN(get_rec(p_okl_context_groups_tl_rec, l_row_notfound));

Line 195: ) RETURN okl_context_groups_tl_rec_type IS

191: END get_rec;
192:
193: FUNCTION get_rec (
194: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type
195: ) RETURN okl_context_groups_tl_rec_type IS
196: l_row_notfound BOOLEAN := TRUE;
197: BEGIN
198: RETURN(get_rec(p_okl_context_groups_tl_rec, l_row_notfound));
199: END get_rec;

Line 198: RETURN(get_rec(p_okl_context_groups_tl_rec, l_row_notfound));

194: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type
195: ) RETURN okl_context_groups_tl_rec_type IS
196: l_row_notfound BOOLEAN := TRUE;
197: BEGIN
198: RETURN(get_rec(p_okl_context_groups_tl_rec, l_row_notfound));
199: END get_rec;
200: ---------------------------------------------------------------------------
201: -- FUNCTION get_rec for: OKL_CONTEXT_GROUPS_V
202: ---------------------------------------------------------------------------

Line 709: p_to IN OUT NOCOPY okl_context_groups_tl_rec_type

705: END migrate;
706: -- RPOONUGA001: Changed p_to to IN OUT variable
707: PROCEDURE migrate (
708: p_from IN cgrv_rec_type,
709: p_to IN OUT NOCOPY okl_context_groups_tl_rec_type
710: ) IS
711: BEGIN
712: p_to.id := p_from.id;
713: p_to.sfwt_flag := p_from.sfwt_flag;

Line 723: p_from IN okl_context_groups_tl_rec_type,

719: p_to.last_update_login := p_from.last_update_login;
720: END migrate;
721: -- RPOONUGA001: Changed p_to to IN OUT variable
722: PROCEDURE migrate (
723: p_from IN okl_context_groups_tl_rec_type,
724: p_to IN OUT NOCOPY cgrv_rec_type
725: ) IS
726: BEGIN
727: p_to.id := p_from.id;

Line 756: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;

752: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
753: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
754: l_cgrv_rec cgrv_rec_type := p_cgrv_rec;
755: l_cgr_rec cgr_rec_type;
756: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
757: BEGIN
758: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
759: G_PKG_NAME,
760: p_init_msg_list,

Line 997: -- insert_row for:OKL_CONTEXT_GROUPS_TL --

993: '_PVT'
994: );
995: END insert_row;
996: ------------------------------------------
997: -- insert_row for:OKL_CONTEXT_GROUPS_TL --
998: ------------------------------------------
999: PROCEDURE insert_row(
1000: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1001: x_return_status OUT NOCOPY VARCHAR2,

Line 1004: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,

1000: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1001: x_return_status OUT NOCOPY VARCHAR2,
1002: x_msg_count OUT NOCOPY NUMBER,
1003: x_msg_data OUT NOCOPY VARCHAR2,
1004: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1005: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type) IS
1006:
1007: l_api_version CONSTANT NUMBER := 1;
1008: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1005: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type) IS

1001: x_return_status OUT NOCOPY VARCHAR2,
1002: x_msg_count OUT NOCOPY NUMBER,
1003: x_msg_data OUT NOCOPY VARCHAR2,
1004: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1005: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type) IS
1006:
1007: l_api_version CONSTANT NUMBER := 1;
1008: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1009: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1010: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type := p_okl_context_groups_tl_rec;

1006:
1007: l_api_version CONSTANT NUMBER := 1;
1008: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1009: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1010: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type := p_okl_context_groups_tl_rec;
1011: ldefoklcontextgroupstlrec okl_context_groups_tl_rec_type;
1012: CURSOR get_languages IS
1013: SELECT *
1014: FROM FND_LANGUAGES

Line 1011: ldefoklcontextgroupstlrec okl_context_groups_tl_rec_type;

1007: l_api_version CONSTANT NUMBER := 1;
1008: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1009: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1010: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type := p_okl_context_groups_tl_rec;
1011: ldefoklcontextgroupstlrec okl_context_groups_tl_rec_type;
1012: CURSOR get_languages IS
1013: SELECT *
1014: FROM FND_LANGUAGES
1015: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1017: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --

1013: SELECT *
1014: FROM FND_LANGUAGES
1015: WHERE INSTALLED_FLAG IN ('I', 'B');
1016: ----------------------------------------------
1017: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --
1018: ----------------------------------------------
1019: FUNCTION Set_Attributes (
1020: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1021: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type

Line 1020: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,

1016: ----------------------------------------------
1017: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --
1018: ----------------------------------------------
1019: FUNCTION Set_Attributes (
1020: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1021: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
1022: ) RETURN VARCHAR2 IS
1023: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1024: BEGIN

Line 1021: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type

1017: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --
1018: ----------------------------------------------
1019: FUNCTION Set_Attributes (
1020: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1021: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
1022: ) RETURN VARCHAR2 IS
1023: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1024: BEGIN
1025: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;

Line 1025: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;

1021: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
1022: ) RETURN VARCHAR2 IS
1023: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1024: BEGIN
1025: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;
1026: x_okl_context_groups_tl_rec.LANGUAGE := USERENV('LANG');
1027: x_okl_context_groups_tl_rec.SOURCE_LANG := USERENV('LANG');
1028: RETURN(l_return_status);
1029: END Set_Attributes;

Line 1026: x_okl_context_groups_tl_rec.LANGUAGE := USERENV('LANG');

1022: ) RETURN VARCHAR2 IS
1023: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1024: BEGIN
1025: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;
1026: x_okl_context_groups_tl_rec.LANGUAGE := USERENV('LANG');
1027: x_okl_context_groups_tl_rec.SOURCE_LANG := USERENV('LANG');
1028: RETURN(l_return_status);
1029: END Set_Attributes;
1030: BEGIN

Line 1027: x_okl_context_groups_tl_rec.SOURCE_LANG := USERENV('LANG');

1023: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1024: BEGIN
1025: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;
1026: x_okl_context_groups_tl_rec.LANGUAGE := USERENV('LANG');
1027: x_okl_context_groups_tl_rec.SOURCE_LANG := USERENV('LANG');
1028: RETURN(l_return_status);
1029: END Set_Attributes;
1030: BEGIN
1031: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1042: p_okl_context_groups_tl_rec, -- IN

1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;
1040: --- Setting item attributes
1041: l_return_status := Set_Attributes(
1042: p_okl_context_groups_tl_rec, -- IN
1043: l_okl_context_groups_tl_rec); -- OUT
1044: --- If any errors happen abort API
1045: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1046: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1043: l_okl_context_groups_tl_rec); -- OUT

1039: END IF;
1040: --- Setting item attributes
1041: l_return_status := Set_Attributes(
1042: p_okl_context_groups_tl_rec, -- IN
1043: l_okl_context_groups_tl_rec); -- OUT
1044: --- If any errors happen abort API
1045: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1046: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1047: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1051: l_okl_context_groups_tl_rec.language := l_lang_rec.language_code;

1047: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1048: RAISE OKC_API.G_EXCEPTION_ERROR;
1049: END IF;
1050: FOR l_lang_rec IN get_languages LOOP
1051: l_okl_context_groups_tl_rec.language := l_lang_rec.language_code;
1052: INSERT INTO OKL_CONTEXT_GROUPS_TL(
1053: id,
1054: language,
1055: source_lang,

Line 1052: INSERT INTO OKL_CONTEXT_GROUPS_TL(

1048: RAISE OKC_API.G_EXCEPTION_ERROR;
1049: END IF;
1050: FOR l_lang_rec IN get_languages LOOP
1051: l_okl_context_groups_tl_rec.language := l_lang_rec.language_code;
1052: INSERT INTO OKL_CONTEXT_GROUPS_TL(
1053: id,
1054: language,
1055: source_lang,
1056: sfwt_flag,

Line 1064: l_okl_context_groups_tl_rec.id,

1060: last_updated_by,
1061: last_update_date,
1062: last_update_login)
1063: VALUES (
1064: l_okl_context_groups_tl_rec.id,
1065: l_okl_context_groups_tl_rec.language,
1066: l_okl_context_groups_tl_rec.source_lang,
1067: l_okl_context_groups_tl_rec.sfwt_flag,
1068: l_okl_context_groups_tl_rec.description,

Line 1065: l_okl_context_groups_tl_rec.language,

1061: last_update_date,
1062: last_update_login)
1063: VALUES (
1064: l_okl_context_groups_tl_rec.id,
1065: l_okl_context_groups_tl_rec.language,
1066: l_okl_context_groups_tl_rec.source_lang,
1067: l_okl_context_groups_tl_rec.sfwt_flag,
1068: l_okl_context_groups_tl_rec.description,
1069: l_okl_context_groups_tl_rec.created_by,

Line 1066: l_okl_context_groups_tl_rec.source_lang,

1062: last_update_login)
1063: VALUES (
1064: l_okl_context_groups_tl_rec.id,
1065: l_okl_context_groups_tl_rec.language,
1066: l_okl_context_groups_tl_rec.source_lang,
1067: l_okl_context_groups_tl_rec.sfwt_flag,
1068: l_okl_context_groups_tl_rec.description,
1069: l_okl_context_groups_tl_rec.created_by,
1070: l_okl_context_groups_tl_rec.creation_date,

Line 1067: l_okl_context_groups_tl_rec.sfwt_flag,

1063: VALUES (
1064: l_okl_context_groups_tl_rec.id,
1065: l_okl_context_groups_tl_rec.language,
1066: l_okl_context_groups_tl_rec.source_lang,
1067: l_okl_context_groups_tl_rec.sfwt_flag,
1068: l_okl_context_groups_tl_rec.description,
1069: l_okl_context_groups_tl_rec.created_by,
1070: l_okl_context_groups_tl_rec.creation_date,
1071: l_okl_context_groups_tl_rec.last_updated_by,

Line 1068: l_okl_context_groups_tl_rec.description,

1064: l_okl_context_groups_tl_rec.id,
1065: l_okl_context_groups_tl_rec.language,
1066: l_okl_context_groups_tl_rec.source_lang,
1067: l_okl_context_groups_tl_rec.sfwt_flag,
1068: l_okl_context_groups_tl_rec.description,
1069: l_okl_context_groups_tl_rec.created_by,
1070: l_okl_context_groups_tl_rec.creation_date,
1071: l_okl_context_groups_tl_rec.last_updated_by,
1072: l_okl_context_groups_tl_rec.last_update_date,

Line 1069: l_okl_context_groups_tl_rec.created_by,

1065: l_okl_context_groups_tl_rec.language,
1066: l_okl_context_groups_tl_rec.source_lang,
1067: l_okl_context_groups_tl_rec.sfwt_flag,
1068: l_okl_context_groups_tl_rec.description,
1069: l_okl_context_groups_tl_rec.created_by,
1070: l_okl_context_groups_tl_rec.creation_date,
1071: l_okl_context_groups_tl_rec.last_updated_by,
1072: l_okl_context_groups_tl_rec.last_update_date,
1073: l_okl_context_groups_tl_rec.last_update_login);

Line 1070: l_okl_context_groups_tl_rec.creation_date,

1066: l_okl_context_groups_tl_rec.source_lang,
1067: l_okl_context_groups_tl_rec.sfwt_flag,
1068: l_okl_context_groups_tl_rec.description,
1069: l_okl_context_groups_tl_rec.created_by,
1070: l_okl_context_groups_tl_rec.creation_date,
1071: l_okl_context_groups_tl_rec.last_updated_by,
1072: l_okl_context_groups_tl_rec.last_update_date,
1073: l_okl_context_groups_tl_rec.last_update_login);
1074: END LOOP;

Line 1071: l_okl_context_groups_tl_rec.last_updated_by,

1067: l_okl_context_groups_tl_rec.sfwt_flag,
1068: l_okl_context_groups_tl_rec.description,
1069: l_okl_context_groups_tl_rec.created_by,
1070: l_okl_context_groups_tl_rec.creation_date,
1071: l_okl_context_groups_tl_rec.last_updated_by,
1072: l_okl_context_groups_tl_rec.last_update_date,
1073: l_okl_context_groups_tl_rec.last_update_login);
1074: END LOOP;
1075: -- Set OUT values

Line 1072: l_okl_context_groups_tl_rec.last_update_date,

1068: l_okl_context_groups_tl_rec.description,
1069: l_okl_context_groups_tl_rec.created_by,
1070: l_okl_context_groups_tl_rec.creation_date,
1071: l_okl_context_groups_tl_rec.last_updated_by,
1072: l_okl_context_groups_tl_rec.last_update_date,
1073: l_okl_context_groups_tl_rec.last_update_login);
1074: END LOOP;
1075: -- Set OUT values
1076: x_okl_context_groups_tl_rec := l_okl_context_groups_tl_rec;

Line 1073: l_okl_context_groups_tl_rec.last_update_login);

1069: l_okl_context_groups_tl_rec.created_by,
1070: l_okl_context_groups_tl_rec.creation_date,
1071: l_okl_context_groups_tl_rec.last_updated_by,
1072: l_okl_context_groups_tl_rec.last_update_date,
1073: l_okl_context_groups_tl_rec.last_update_login);
1074: END LOOP;
1075: -- Set OUT values
1076: x_okl_context_groups_tl_rec := l_okl_context_groups_tl_rec;
1077: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1076: x_okl_context_groups_tl_rec := l_okl_context_groups_tl_rec;

1072: l_okl_context_groups_tl_rec.last_update_date,
1073: l_okl_context_groups_tl_rec.last_update_login);
1074: END LOOP;
1075: -- Set OUT values
1076: x_okl_context_groups_tl_rec := l_okl_context_groups_tl_rec;
1077: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1078: EXCEPTION
1079: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1080: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1129: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;

1125: l_cgrv_rec cgrv_rec_type;
1126: l_def_cgrv_rec cgrv_rec_type;
1127: l_cgr_rec cgr_rec_type;
1128: lx_cgr_rec cgr_rec_type;
1129: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
1130: lx_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
1131: -------------------------------
1132: -- FUNCTION fill_who_columns --
1133: -------------------------------

Line 1130: lx_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;

1126: l_def_cgrv_rec cgrv_rec_type;
1127: l_cgr_rec cgr_rec_type;
1128: lx_cgr_rec cgr_rec_type;
1129: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
1130: lx_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
1131: -------------------------------
1132: -- FUNCTION fill_who_columns --
1133: -------------------------------
1134: FUNCTION fill_who_columns (

Line 1205: migrate(l_def_cgrv_rec, l_okl_context_groups_tl_rec);

1201: --------------------------------------
1202: -- Move VIEW record to "Child" records
1203: --------------------------------------
1204: migrate(l_def_cgrv_rec, l_cgr_rec);
1205: migrate(l_def_cgrv_rec, l_okl_context_groups_tl_rec);
1206: --------------------------------------------
1207: -- Call the INSERT_ROW for each child record
1208: --------------------------------------------
1209: insert_row(

Line 1228: l_okl_context_groups_tl_rec,

1224: p_init_msg_list,
1225: x_return_status,
1226: x_msg_count,
1227: x_msg_data,
1228: l_okl_context_groups_tl_rec,
1229: lx_okl_context_groups_tl_rec
1230: );
1231: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1232: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1229: lx_okl_context_groups_tl_rec

1225: x_return_status,
1226: x_msg_count,
1227: x_msg_data,
1228: l_okl_context_groups_tl_rec,
1229: lx_okl_context_groups_tl_rec
1230: );
1231: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1232: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1233: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1236: migrate(lx_okl_context_groups_tl_rec, l_def_cgrv_rec);

1232: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1233: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1234: RAISE OKC_API.G_EXCEPTION_ERROR;
1235: END IF;
1236: migrate(lx_okl_context_groups_tl_rec, l_def_cgrv_rec);
1237: -- Set OUT values
1238: x_cgrv_rec := l_def_cgrv_rec;
1239: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1240: EXCEPTION

Line 1459: -- lock_row for:OKL_CONTEXT_GROUPS_TL --

1455: '_PVT'
1456: );
1457: END lock_row;
1458: ----------------------------------------
1459: -- lock_row for:OKL_CONTEXT_GROUPS_TL --
1460: ----------------------------------------
1461: PROCEDURE lock_row(
1462: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1463: x_return_status OUT NOCOPY VARCHAR2,

Line 1466: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type) IS

1462: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1463: x_return_status OUT NOCOPY VARCHAR2,
1464: x_msg_count OUT NOCOPY NUMBER,
1465: x_msg_data OUT NOCOPY VARCHAR2,
1466: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type) IS
1467:
1468: E_Resource_Busy EXCEPTION;
1469: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1470: CURSOR lock_csr (p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type) IS

Line 1470: CURSOR lock_csr (p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type) IS

1466: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type) IS
1467:
1468: E_Resource_Busy EXCEPTION;
1469: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1470: CURSOR lock_csr (p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type) IS
1471: SELECT *
1472: FROM OKL_CONTEXT_GROUPS_TL
1473: WHERE ID = p_okl_context_groups_tl_rec.id
1474: FOR UPDATE NOWAIT;

Line 1472: FROM OKL_CONTEXT_GROUPS_TL

1468: E_Resource_Busy EXCEPTION;
1469: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1470: CURSOR lock_csr (p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type) IS
1471: SELECT *
1472: FROM OKL_CONTEXT_GROUPS_TL
1473: WHERE ID = p_okl_context_groups_tl_rec.id
1474: FOR UPDATE NOWAIT;
1475:
1476: l_api_version CONSTANT NUMBER := 1;

Line 1473: WHERE ID = p_okl_context_groups_tl_rec.id

1469: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1470: CURSOR lock_csr (p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type) IS
1471: SELECT *
1472: FROM OKL_CONTEXT_GROUPS_TL
1473: WHERE ID = p_okl_context_groups_tl_rec.id
1474: FOR UPDATE NOWAIT;
1475:
1476: l_api_version CONSTANT NUMBER := 1;
1477: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1493: OPEN lock_csr(p_okl_context_groups_tl_rec);

1489: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1490: RAISE OKC_API.G_EXCEPTION_ERROR;
1491: END IF;
1492: BEGIN
1493: OPEN lock_csr(p_okl_context_groups_tl_rec);
1494: FETCH lock_csr INTO l_lock_var;
1495: l_row_notfound := lock_csr%NOTFOUND;
1496: CLOSE lock_csr;
1497: EXCEPTION

Line 1558: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;

1554: l_api_version CONSTANT NUMBER := 1;
1555: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1556: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1557: l_cgr_rec cgr_rec_type;
1558: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
1559: BEGIN
1560: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1561: G_PKG_NAME,
1562: p_init_msg_list,

Line 1576: migrate(p_cgrv_rec, l_okl_context_groups_tl_rec);

1572: --------------------------------------
1573: -- Move VIEW record to "Child" records
1574: --------------------------------------
1575: migrate(p_cgrv_rec, l_cgr_rec);
1576: migrate(p_cgrv_rec, l_okl_context_groups_tl_rec);
1577: --------------------------------------------
1578: -- Call the LOCK_ROW for each child record
1579: --------------------------------------------
1580: lock_row(

Line 1597: l_okl_context_groups_tl_rec

1593: p_init_msg_list,
1594: x_return_status,
1595: x_msg_count,
1596: x_msg_data,
1597: l_okl_context_groups_tl_rec
1598: );
1599: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1600: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1601: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1866: -- update_row for:OKL_CONTEXT_GROUPS_TL --

1862: '_PVT'
1863: );
1864: END update_row;
1865: ------------------------------------------
1866: -- update_row for:OKL_CONTEXT_GROUPS_TL --
1867: ------------------------------------------
1868: PROCEDURE update_row(
1869: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1870: x_return_status OUT NOCOPY VARCHAR2,

Line 1873: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,

1869: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1870: x_return_status OUT NOCOPY VARCHAR2,
1871: x_msg_count OUT NOCOPY NUMBER,
1872: x_msg_data OUT NOCOPY VARCHAR2,
1873: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1874: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type) IS
1875:
1876: l_api_version CONSTANT NUMBER := 1;
1877: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 1874: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type) IS

1870: x_return_status OUT NOCOPY VARCHAR2,
1871: x_msg_count OUT NOCOPY NUMBER,
1872: x_msg_data OUT NOCOPY VARCHAR2,
1873: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1874: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type) IS
1875:
1876: l_api_version CONSTANT NUMBER := 1;
1877: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
1878: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1879: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type := p_okl_context_groups_tl_rec;

1875:
1876: l_api_version CONSTANT NUMBER := 1;
1877: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
1878: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1879: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type := p_okl_context_groups_tl_rec;
1880: ldefoklcontextgroupstlrec okl_context_groups_tl_rec_type;
1881: l_row_notfound BOOLEAN := TRUE;
1882: ----------------------------------
1883: -- FUNCTION populate_new_record --

Line 1880: ldefoklcontextgroupstlrec okl_context_groups_tl_rec_type;

1876: l_api_version CONSTANT NUMBER := 1;
1877: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
1878: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1879: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type := p_okl_context_groups_tl_rec;
1880: ldefoklcontextgroupstlrec okl_context_groups_tl_rec_type;
1881: l_row_notfound BOOLEAN := TRUE;
1882: ----------------------------------
1883: -- FUNCTION populate_new_record --
1884: ----------------------------------

Line 1886: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,

1882: ----------------------------------
1883: -- FUNCTION populate_new_record --
1884: ----------------------------------
1885: FUNCTION populate_new_record (
1886: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1887: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
1888: ) RETURN VARCHAR2 IS
1889: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
1890: l_row_notfound BOOLEAN := TRUE;

Line 1887: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type

1883: -- FUNCTION populate_new_record --
1884: ----------------------------------
1885: FUNCTION populate_new_record (
1886: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1887: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
1888: ) RETURN VARCHAR2 IS
1889: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
1890: l_row_notfound BOOLEAN := TRUE;
1891: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1889: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;

1885: FUNCTION populate_new_record (
1886: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1887: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
1888: ) RETURN VARCHAR2 IS
1889: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
1890: l_row_notfound BOOLEAN := TRUE;
1891: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1892: BEGIN
1893: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;

Line 1893: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;

1889: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
1890: l_row_notfound BOOLEAN := TRUE;
1891: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1892: BEGIN
1893: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;
1894: -- Get current database values
1895: l_okl_context_groups_tl_rec := get_rec(p_okl_context_groups_tl_rec, l_row_notfound);
1896: IF (l_row_notfound) THEN
1897: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1895: l_okl_context_groups_tl_rec := get_rec(p_okl_context_groups_tl_rec, l_row_notfound);

1891: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1892: BEGIN
1893: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;
1894: -- Get current database values
1895: l_okl_context_groups_tl_rec := get_rec(p_okl_context_groups_tl_rec, l_row_notfound);
1896: IF (l_row_notfound) THEN
1897: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1898: END IF;
1899: IF (x_okl_context_groups_tl_rec.id = OKC_API.G_MISS_NUM)

Line 1899: IF (x_okl_context_groups_tl_rec.id = OKC_API.G_MISS_NUM)

1895: l_okl_context_groups_tl_rec := get_rec(p_okl_context_groups_tl_rec, l_row_notfound);
1896: IF (l_row_notfound) THEN
1897: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1898: END IF;
1899: IF (x_okl_context_groups_tl_rec.id = OKC_API.G_MISS_NUM)
1900: THEN
1901: x_okl_context_groups_tl_rec.id := l_okl_context_groups_tl_rec.id;
1902: END IF;
1903: IF (x_okl_context_groups_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 1901: x_okl_context_groups_tl_rec.id := l_okl_context_groups_tl_rec.id;

1897: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1898: END IF;
1899: IF (x_okl_context_groups_tl_rec.id = OKC_API.G_MISS_NUM)
1900: THEN
1901: x_okl_context_groups_tl_rec.id := l_okl_context_groups_tl_rec.id;
1902: END IF;
1903: IF (x_okl_context_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
1904: THEN
1905: x_okl_context_groups_tl_rec.language := l_okl_context_groups_tl_rec.language;

Line 1903: IF (x_okl_context_groups_tl_rec.language = OKC_API.G_MISS_CHAR)

1899: IF (x_okl_context_groups_tl_rec.id = OKC_API.G_MISS_NUM)
1900: THEN
1901: x_okl_context_groups_tl_rec.id := l_okl_context_groups_tl_rec.id;
1902: END IF;
1903: IF (x_okl_context_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
1904: THEN
1905: x_okl_context_groups_tl_rec.language := l_okl_context_groups_tl_rec.language;
1906: END IF;
1907: IF (x_okl_context_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 1905: x_okl_context_groups_tl_rec.language := l_okl_context_groups_tl_rec.language;

1901: x_okl_context_groups_tl_rec.id := l_okl_context_groups_tl_rec.id;
1902: END IF;
1903: IF (x_okl_context_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
1904: THEN
1905: x_okl_context_groups_tl_rec.language := l_okl_context_groups_tl_rec.language;
1906: END IF;
1907: IF (x_okl_context_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
1908: THEN
1909: x_okl_context_groups_tl_rec.source_lang := l_okl_context_groups_tl_rec.source_lang;

Line 1907: IF (x_okl_context_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

1903: IF (x_okl_context_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
1904: THEN
1905: x_okl_context_groups_tl_rec.language := l_okl_context_groups_tl_rec.language;
1906: END IF;
1907: IF (x_okl_context_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
1908: THEN
1909: x_okl_context_groups_tl_rec.source_lang := l_okl_context_groups_tl_rec.source_lang;
1910: END IF;
1911: IF (x_okl_context_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 1909: x_okl_context_groups_tl_rec.source_lang := l_okl_context_groups_tl_rec.source_lang;

1905: x_okl_context_groups_tl_rec.language := l_okl_context_groups_tl_rec.language;
1906: END IF;
1907: IF (x_okl_context_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
1908: THEN
1909: x_okl_context_groups_tl_rec.source_lang := l_okl_context_groups_tl_rec.source_lang;
1910: END IF;
1911: IF (x_okl_context_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1912: THEN
1913: x_okl_context_groups_tl_rec.sfwt_flag := l_okl_context_groups_tl_rec.sfwt_flag;

Line 1911: IF (x_okl_context_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

1907: IF (x_okl_context_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
1908: THEN
1909: x_okl_context_groups_tl_rec.source_lang := l_okl_context_groups_tl_rec.source_lang;
1910: END IF;
1911: IF (x_okl_context_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1912: THEN
1913: x_okl_context_groups_tl_rec.sfwt_flag := l_okl_context_groups_tl_rec.sfwt_flag;
1914: END IF;
1915: IF (x_okl_context_groups_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 1913: x_okl_context_groups_tl_rec.sfwt_flag := l_okl_context_groups_tl_rec.sfwt_flag;

1909: x_okl_context_groups_tl_rec.source_lang := l_okl_context_groups_tl_rec.source_lang;
1910: END IF;
1911: IF (x_okl_context_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1912: THEN
1913: x_okl_context_groups_tl_rec.sfwt_flag := l_okl_context_groups_tl_rec.sfwt_flag;
1914: END IF;
1915: IF (x_okl_context_groups_tl_rec.description = OKC_API.G_MISS_CHAR)
1916: THEN
1917: x_okl_context_groups_tl_rec.description := l_okl_context_groups_tl_rec.description;

Line 1915: IF (x_okl_context_groups_tl_rec.description = OKC_API.G_MISS_CHAR)

1911: IF (x_okl_context_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1912: THEN
1913: x_okl_context_groups_tl_rec.sfwt_flag := l_okl_context_groups_tl_rec.sfwt_flag;
1914: END IF;
1915: IF (x_okl_context_groups_tl_rec.description = OKC_API.G_MISS_CHAR)
1916: THEN
1917: x_okl_context_groups_tl_rec.description := l_okl_context_groups_tl_rec.description;
1918: END IF;
1919: IF (x_okl_context_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 1917: x_okl_context_groups_tl_rec.description := l_okl_context_groups_tl_rec.description;

1913: x_okl_context_groups_tl_rec.sfwt_flag := l_okl_context_groups_tl_rec.sfwt_flag;
1914: END IF;
1915: IF (x_okl_context_groups_tl_rec.description = OKC_API.G_MISS_CHAR)
1916: THEN
1917: x_okl_context_groups_tl_rec.description := l_okl_context_groups_tl_rec.description;
1918: END IF;
1919: IF (x_okl_context_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
1920: THEN
1921: x_okl_context_groups_tl_rec.created_by := l_okl_context_groups_tl_rec.created_by;

Line 1919: IF (x_okl_context_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)

1915: IF (x_okl_context_groups_tl_rec.description = OKC_API.G_MISS_CHAR)
1916: THEN
1917: x_okl_context_groups_tl_rec.description := l_okl_context_groups_tl_rec.description;
1918: END IF;
1919: IF (x_okl_context_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
1920: THEN
1921: x_okl_context_groups_tl_rec.created_by := l_okl_context_groups_tl_rec.created_by;
1922: END IF;
1923: IF (x_okl_context_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1921: x_okl_context_groups_tl_rec.created_by := l_okl_context_groups_tl_rec.created_by;

1917: x_okl_context_groups_tl_rec.description := l_okl_context_groups_tl_rec.description;
1918: END IF;
1919: IF (x_okl_context_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
1920: THEN
1921: x_okl_context_groups_tl_rec.created_by := l_okl_context_groups_tl_rec.created_by;
1922: END IF;
1923: IF (x_okl_context_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
1924: THEN
1925: x_okl_context_groups_tl_rec.creation_date := l_okl_context_groups_tl_rec.creation_date;

Line 1923: IF (x_okl_context_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)

1919: IF (x_okl_context_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
1920: THEN
1921: x_okl_context_groups_tl_rec.created_by := l_okl_context_groups_tl_rec.created_by;
1922: END IF;
1923: IF (x_okl_context_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
1924: THEN
1925: x_okl_context_groups_tl_rec.creation_date := l_okl_context_groups_tl_rec.creation_date;
1926: END IF;
1927: IF (x_okl_context_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1925: x_okl_context_groups_tl_rec.creation_date := l_okl_context_groups_tl_rec.creation_date;

1921: x_okl_context_groups_tl_rec.created_by := l_okl_context_groups_tl_rec.created_by;
1922: END IF;
1923: IF (x_okl_context_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
1924: THEN
1925: x_okl_context_groups_tl_rec.creation_date := l_okl_context_groups_tl_rec.creation_date;
1926: END IF;
1927: IF (x_okl_context_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
1928: THEN
1929: x_okl_context_groups_tl_rec.last_updated_by := l_okl_context_groups_tl_rec.last_updated_by;

Line 1927: IF (x_okl_context_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

1923: IF (x_okl_context_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
1924: THEN
1925: x_okl_context_groups_tl_rec.creation_date := l_okl_context_groups_tl_rec.creation_date;
1926: END IF;
1927: IF (x_okl_context_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
1928: THEN
1929: x_okl_context_groups_tl_rec.last_updated_by := l_okl_context_groups_tl_rec.last_updated_by;
1930: END IF;
1931: IF (x_okl_context_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1929: x_okl_context_groups_tl_rec.last_updated_by := l_okl_context_groups_tl_rec.last_updated_by;

1925: x_okl_context_groups_tl_rec.creation_date := l_okl_context_groups_tl_rec.creation_date;
1926: END IF;
1927: IF (x_okl_context_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
1928: THEN
1929: x_okl_context_groups_tl_rec.last_updated_by := l_okl_context_groups_tl_rec.last_updated_by;
1930: END IF;
1931: IF (x_okl_context_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
1932: THEN
1933: x_okl_context_groups_tl_rec.last_update_date := l_okl_context_groups_tl_rec.last_update_date;

Line 1931: IF (x_okl_context_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

1927: IF (x_okl_context_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
1928: THEN
1929: x_okl_context_groups_tl_rec.last_updated_by := l_okl_context_groups_tl_rec.last_updated_by;
1930: END IF;
1931: IF (x_okl_context_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
1932: THEN
1933: x_okl_context_groups_tl_rec.last_update_date := l_okl_context_groups_tl_rec.last_update_date;
1934: END IF;
1935: IF (x_okl_context_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1933: x_okl_context_groups_tl_rec.last_update_date := l_okl_context_groups_tl_rec.last_update_date;

1929: x_okl_context_groups_tl_rec.last_updated_by := l_okl_context_groups_tl_rec.last_updated_by;
1930: END IF;
1931: IF (x_okl_context_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
1932: THEN
1933: x_okl_context_groups_tl_rec.last_update_date := l_okl_context_groups_tl_rec.last_update_date;
1934: END IF;
1935: IF (x_okl_context_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
1936: THEN
1937: x_okl_context_groups_tl_rec.last_update_login := l_okl_context_groups_tl_rec.last_update_login;

Line 1935: IF (x_okl_context_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

1931: IF (x_okl_context_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
1932: THEN
1933: x_okl_context_groups_tl_rec.last_update_date := l_okl_context_groups_tl_rec.last_update_date;
1934: END IF;
1935: IF (x_okl_context_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
1936: THEN
1937: x_okl_context_groups_tl_rec.last_update_login := l_okl_context_groups_tl_rec.last_update_login;
1938: END IF;
1939: RETURN(l_return_status);

Line 1937: x_okl_context_groups_tl_rec.last_update_login := l_okl_context_groups_tl_rec.last_update_login;

1933: x_okl_context_groups_tl_rec.last_update_date := l_okl_context_groups_tl_rec.last_update_date;
1934: END IF;
1935: IF (x_okl_context_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
1936: THEN
1937: x_okl_context_groups_tl_rec.last_update_login := l_okl_context_groups_tl_rec.last_update_login;
1938: END IF;
1939: RETURN(l_return_status);
1940: END populate_new_record;
1941: ----------------------------------------------

Line 1942: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --

1938: END IF;
1939: RETURN(l_return_status);
1940: END populate_new_record;
1941: ----------------------------------------------
1942: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --
1943: ----------------------------------------------
1944: FUNCTION Set_Attributes (
1945: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1946: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type

Line 1945: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,

1941: ----------------------------------------------
1942: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --
1943: ----------------------------------------------
1944: FUNCTION Set_Attributes (
1945: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1946: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
1947: ) RETURN VARCHAR2 IS
1948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1949: BEGIN

Line 1946: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type

1942: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --
1943: ----------------------------------------------
1944: FUNCTION Set_Attributes (
1945: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
1946: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
1947: ) RETURN VARCHAR2 IS
1948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1949: BEGIN
1950: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;

Line 1950: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;

1946: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
1947: ) RETURN VARCHAR2 IS
1948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1949: BEGIN
1950: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;
1951: x_okl_context_groups_tl_rec.LANGUAGE := USERENV('LANG');
1952: x_okl_context_groups_tl_rec.SOURCE_LANG := USERENV('LANG');
1953: RETURN(l_return_status);
1954: END Set_Attributes;

Line 1951: x_okl_context_groups_tl_rec.LANGUAGE := USERENV('LANG');

1947: ) RETURN VARCHAR2 IS
1948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1949: BEGIN
1950: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;
1951: x_okl_context_groups_tl_rec.LANGUAGE := USERENV('LANG');
1952: x_okl_context_groups_tl_rec.SOURCE_LANG := USERENV('LANG');
1953: RETURN(l_return_status);
1954: END Set_Attributes;
1955: BEGIN

Line 1952: x_okl_context_groups_tl_rec.SOURCE_LANG := USERENV('LANG');

1948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1949: BEGIN
1950: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;
1951: x_okl_context_groups_tl_rec.LANGUAGE := USERENV('LANG');
1952: x_okl_context_groups_tl_rec.SOURCE_LANG := USERENV('LANG');
1953: RETURN(l_return_status);
1954: END Set_Attributes;
1955: BEGIN
1956: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1967: p_okl_context_groups_tl_rec, -- IN

1963: RAISE OKC_API.G_EXCEPTION_ERROR;
1964: END IF;
1965: --- Setting item attributes
1966: l_return_status := Set_Attributes(
1967: p_okl_context_groups_tl_rec, -- IN
1968: l_okl_context_groups_tl_rec); -- OUT
1969: --- If any errors happen abort API
1970: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1971: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1968: l_okl_context_groups_tl_rec); -- OUT

1964: END IF;
1965: --- Setting item attributes
1966: l_return_status := Set_Attributes(
1967: p_okl_context_groups_tl_rec, -- IN
1968: l_okl_context_groups_tl_rec); -- OUT
1969: --- If any errors happen abort API
1970: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1971: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1972: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1975: l_return_status := populate_new_record(l_okl_context_groups_tl_rec, ldefoklcontextgroupstlrec);

1971: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1972: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1973: RAISE OKC_API.G_EXCEPTION_ERROR;
1974: END IF;
1975: l_return_status := populate_new_record(l_okl_context_groups_tl_rec, ldefoklcontextgroupstlrec);
1976: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1978: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1981: UPDATE OKL_CONTEXT_GROUPS_TL

1977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1978: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_ERROR;
1980: END IF;
1981: UPDATE OKL_CONTEXT_GROUPS_TL
1982: SET DESCRIPTION = ldefoklcontextgroupstlrec.description,
1983: CREATED_BY = ldefoklcontextgroupstlrec.created_by,
1984: SOURCE_LANG = ldefoklcontextgroupstlrec.source_lang,
1985: CREATION_DATE = ldefoklcontextgroupstlrec.creation_date,

Line 1993: UPDATE OKL_CONTEXT_GROUPS_TL

1989: WHERE ID = ldefoklcontextgroupstlrec.id
1990: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
1991: --AND SOURCE_LANG = USERENV('LANG');
1992:
1993: UPDATE OKL_CONTEXT_GROUPS_TL
1994: SET SFWT_FLAG = 'Y'
1995: WHERE ID = ldefoklcontextgroupstlrec.id
1996: AND SOURCE_LANG <> USERENV('LANG');
1997:

Line 1998: x_okl_context_groups_tl_rec := ldefoklcontextgroupstlrec;

1994: SET SFWT_FLAG = 'Y'
1995: WHERE ID = ldefoklcontextgroupstlrec.id
1996: AND SOURCE_LANG <> USERENV('LANG');
1997:
1998: x_okl_context_groups_tl_rec := ldefoklcontextgroupstlrec;
1999: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2000: EXCEPTION
2001: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2002: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2049: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;

2045: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2046: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2047: l_cgrv_rec cgrv_rec_type := p_cgrv_rec;
2048: l_def_cgrv_rec cgrv_rec_type;
2049: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
2050: lx_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
2051: l_cgr_rec cgr_rec_type;
2052: lx_cgr_rec cgr_rec_type;
2053: -------------------------------

Line 2050: lx_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;

2046: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2047: l_cgrv_rec cgrv_rec_type := p_cgrv_rec;
2048: l_def_cgrv_rec cgrv_rec_type;
2049: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
2050: lx_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
2051: l_cgr_rec cgr_rec_type;
2052: lx_cgr_rec cgr_rec_type;
2053: -------------------------------
2054: -- FUNCTION fill_who_columns --

Line 2186: migrate(l_def_cgrv_rec, l_okl_context_groups_tl_rec);

2182:
2183: --------------------------------------
2184: -- Move VIEW record to "Child" records
2185: --------------------------------------
2186: migrate(l_def_cgrv_rec, l_okl_context_groups_tl_rec);
2187: migrate(l_def_cgrv_rec, l_cgr_rec);
2188: --------------------------------------------
2189: -- Call the UPDATE_ROW for each child record
2190: --------------------------------------------

Line 2196: l_okl_context_groups_tl_rec,

2192: p_init_msg_list,
2193: x_return_status,
2194: x_msg_count,
2195: x_msg_data,
2196: l_okl_context_groups_tl_rec,
2197: lx_okl_context_groups_tl_rec
2198: );
2199: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2200: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2197: lx_okl_context_groups_tl_rec

2193: x_return_status,
2194: x_msg_count,
2195: x_msg_data,
2196: l_okl_context_groups_tl_rec,
2197: lx_okl_context_groups_tl_rec
2198: );
2199: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2200: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2201: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2204: migrate(lx_okl_context_groups_tl_rec, l_def_cgrv_rec);

2200: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2201: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2202: RAISE OKC_API.G_EXCEPTION_ERROR;
2203: END IF;
2204: migrate(lx_okl_context_groups_tl_rec, l_def_cgrv_rec);
2205: update_row(
2206: p_init_msg_list,
2207: x_return_status,
2208: x_msg_count,

Line 2395: -- delete_row for:OKL_CONTEXT_GROUPS_TL --

2391: '_PVT'
2392: );
2393: END delete_row;
2394: ------------------------------------------
2395: -- delete_row for:OKL_CONTEXT_GROUPS_TL --
2396: ------------------------------------------
2397: PROCEDURE delete_row(
2398: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2399: x_return_status OUT NOCOPY VARCHAR2,

Line 2402: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type) IS

2398: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2399: x_return_status OUT NOCOPY VARCHAR2,
2400: x_msg_count OUT NOCOPY NUMBER,
2401: x_msg_data OUT NOCOPY VARCHAR2,
2402: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type) IS
2403:
2404: l_api_version CONSTANT NUMBER := 1;
2405: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2406: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2407: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type:= p_okl_context_groups_tl_rec;

2403:
2404: l_api_version CONSTANT NUMBER := 1;
2405: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2406: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2407: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type:= p_okl_context_groups_tl_rec;
2408: l_row_notfound BOOLEAN := TRUE;
2409: ----------------------------------------------
2410: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --
2411: ----------------------------------------------

Line 2410: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --

2406: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2407: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type:= p_okl_context_groups_tl_rec;
2408: l_row_notfound BOOLEAN := TRUE;
2409: ----------------------------------------------
2410: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --
2411: ----------------------------------------------
2412: FUNCTION Set_Attributes (
2413: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
2414: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type

Line 2413: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,

2409: ----------------------------------------------
2410: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --
2411: ----------------------------------------------
2412: FUNCTION Set_Attributes (
2413: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
2414: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
2415: ) RETURN VARCHAR2 IS
2416: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2417: BEGIN

Line 2414: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type

2410: -- Set_Attributes for:OKL_CONTEXT_GROUPS_TL --
2411: ----------------------------------------------
2412: FUNCTION Set_Attributes (
2413: p_okl_context_groups_tl_rec IN okl_context_groups_tl_rec_type,
2414: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
2415: ) RETURN VARCHAR2 IS
2416: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2417: BEGIN
2418: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;

Line 2418: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;

2414: x_okl_context_groups_tl_rec OUT NOCOPY okl_context_groups_tl_rec_type
2415: ) RETURN VARCHAR2 IS
2416: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2417: BEGIN
2418: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;
2419: x_okl_context_groups_tl_rec.LANGUAGE := USERENV('LANG');
2420: RETURN(l_return_status);
2421: END Set_Attributes;
2422: BEGIN

Line 2419: x_okl_context_groups_tl_rec.LANGUAGE := USERENV('LANG');

2415: ) RETURN VARCHAR2 IS
2416: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2417: BEGIN
2418: x_okl_context_groups_tl_rec := p_okl_context_groups_tl_rec;
2419: x_okl_context_groups_tl_rec.LANGUAGE := USERENV('LANG');
2420: RETURN(l_return_status);
2421: END Set_Attributes;
2422: BEGIN
2423: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2434: p_okl_context_groups_tl_rec, -- IN

2430: RAISE OKC_API.G_EXCEPTION_ERROR;
2431: END IF;
2432: --- Setting item attributes
2433: l_return_status := Set_Attributes(
2434: p_okl_context_groups_tl_rec, -- IN
2435: l_okl_context_groups_tl_rec); -- OUT
2436: --- If any errors happen abort API
2437: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2438: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2435: l_okl_context_groups_tl_rec); -- OUT

2431: END IF;
2432: --- Setting item attributes
2433: l_return_status := Set_Attributes(
2434: p_okl_context_groups_tl_rec, -- IN
2435: l_okl_context_groups_tl_rec); -- OUT
2436: --- If any errors happen abort API
2437: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2438: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2439: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2442: DELETE FROM OKL_CONTEXT_GROUPS_TL

2438: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2439: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2440: RAISE OKC_API.G_EXCEPTION_ERROR;
2441: END IF;
2442: DELETE FROM OKL_CONTEXT_GROUPS_TL
2443: WHERE ID = l_okl_context_groups_tl_rec.id;
2444:
2445: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2446: EXCEPTION

Line 2443: WHERE ID = l_okl_context_groups_tl_rec.id;

2439: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2440: RAISE OKC_API.G_EXCEPTION_ERROR;
2441: END IF;
2442: DELETE FROM OKL_CONTEXT_GROUPS_TL
2443: WHERE ID = l_okl_context_groups_tl_rec.id;
2444:
2445: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2446: EXCEPTION
2447: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2493: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;

2489: l_api_version CONSTANT NUMBER := 1;
2490: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2491: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2492: l_cgrv_rec cgrv_rec_type := p_cgrv_rec;
2493: l_okl_context_groups_tl_rec okl_context_groups_tl_rec_type;
2494: l_cgr_rec cgr_rec_type;
2495: BEGIN
2496: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2497: G_PKG_NAME,

Line 2511: migrate(l_cgrv_rec, l_okl_context_groups_tl_rec);

2507: END IF;
2508: --------------------------------------
2509: -- Move VIEW record to "Child" records
2510: --------------------------------------
2511: migrate(l_cgrv_rec, l_okl_context_groups_tl_rec);
2512: migrate(l_cgrv_rec, l_cgr_rec);
2513: --------------------------------------------
2514: -- Call the DELETE_ROW for each child record
2515: --------------------------------------------

Line 2521: l_okl_context_groups_tl_rec

2517: p_init_msg_list,
2518: x_return_status,
2519: x_msg_count,
2520: x_msg_data,
2521: l_okl_context_groups_tl_rec
2522: );
2523: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2524: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2525: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2671: FROM OKL_CONTEXT_GROUPS_TL

2667: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
2668:
2669: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
2670: INTO db_luby, db_ludate
2671: FROM OKL_CONTEXT_GROUPS_TL
2672: where ID = to_number(p_cgrv_rec.id)
2673: and USERENV('LANG') =language;
2674:
2675: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 2677: UPDATE OKL_CONTEXT_GROUPS_TL

2673: and USERENV('LANG') =language;
2674:
2675: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2676: db_ludate, '')) then
2677: UPDATE OKL_CONTEXT_GROUPS_TL
2678: SET DESCRIPTION = p_cgrv_rec.DESCRIPTION,
2679: LAST_UPDATE_DATE = f_ludate,
2680: LAST_UPDATED_BY = f_luby,
2681: LAST_UPDATE_LOGIN = 0,

Line 2727: UPDATE OKL_CONTEXT_GROUPS_TL

2723: LAST_UPDATED_BY = f_luby,
2724: LAST_UPDATE_LOGIN = 0
2725: WHERE ID = to_number(p_cgrv_rec.id);
2726: --Update _TL
2727: UPDATE OKL_CONTEXT_GROUPS_TL
2728: SET DESCRIPTION = p_cgrv_rec.description,
2729: LAST_UPDATE_DATE = f_ludate,
2730: LAST_UPDATED_BY = f_luby,
2731: LAST_UPDATE_LOGIN = 0,

Line 2738: INSERT INTO OKL_CONTEXT_GROUPS_TL

2734: AND USERENV('LANG') IN (language,source_lang);
2735:
2736: IF(sql%notfound) THEN
2737:
2738: INSERT INTO OKL_CONTEXT_GROUPS_TL
2739: (
2740: ID,
2741: LANGUAGE,
2742: SOURCE_LANG,

Line 2766: FROM OKL_CONTEXT_GROUPS_TL TL

2762: FROM FND_LANGUAGES L
2763: WHERE L.INSTALLED_FLAG IN ('I','B')
2764: AND NOT EXISTS
2765: (SELECT NULL
2766: FROM OKL_CONTEXT_GROUPS_TL TL
2767: WHERE TL.ID = TO_NUMBER(p_cgrv_rec.id)
2768: AND TL.LANGUAGE = L.LANGUAGE_CODE);
2769: END IF;
2770:

Line 2801: INSERT INTO OKL_CONTEXT_GROUPS_TL

2797: WHERE NOT EXISTS (SELECT 1
2798: from OKL_CONTEXT_GROUPS_B
2799: where NAME = p_cgrv_rec.NAME);
2800:
2801: INSERT INTO OKL_CONTEXT_GROUPS_TL
2802: (
2803: ID,
2804: LANGUAGE,
2805: SOURCE_LANG,

Line 2829: FROM OKL_CONTEXT_GROUPS_TL TL

2825: FROM FND_LANGUAGES L
2826: WHERE L.INSTALLED_FLAG IN ('I','B')
2827: AND NOT EXISTS
2828: (SELECT NULL
2829: FROM OKL_CONTEXT_GROUPS_TL TL
2830: WHERE TL.ID = TO_NUMBER(p_cgrv_rec.id)
2831: AND TL.LANGUAGE = L.LANGUAGE_CODE);
2832:
2833: END LOAD_ROW;