eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CGP_PVT dependencies on OKC_K_GROUPS_TL

Line 72: DELETE FROM OKC_K_GROUPS_TL T

68: -- PROCEDURE add_language
69: ---------------------------------------------------------------------------
70: PROCEDURE add_language IS
71: BEGIN
72: DELETE FROM OKC_K_GROUPS_TL T
73: WHERE NOT EXISTS (
74: SELECT NULL
75: FROM OKC_K_GROUPS_B B
76: WHERE B.ID = T.ID

Line 79: UPDATE OKC_K_GROUPS_TL T SET (

75: FROM OKC_K_GROUPS_B B
76: WHERE B.ID = T.ID
77: );
78:
79: UPDATE OKC_K_GROUPS_TL T SET (
80: NAME,
81: SHORT_DESCRIPTION) = (SELECT
82: B.NAME,
83: B.SHORT_DESCRIPTION

Line 84: FROM OKC_K_GROUPS_TL B

80: NAME,
81: SHORT_DESCRIPTION) = (SELECT
82: B.NAME,
83: B.SHORT_DESCRIPTION
84: FROM OKC_K_GROUPS_TL B
85: WHERE B.ID = T.ID
86: AND B.LANGUAGE = T.SOURCE_LANG)
87: WHERE (
88: T.ID,

Line 93: FROM OKC_K_GROUPS_TL SUBB, OKC_K_GROUPS_TL SUBT

89: T.LANGUAGE)
90: IN (SELECT
91: SUBT.ID,
92: SUBT.LANGUAGE
93: FROM OKC_K_GROUPS_TL SUBB, OKC_K_GROUPS_TL SUBT
94: WHERE SUBB.ID = SUBT.ID
95: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
96: AND (SUBB.NAME <> SUBT.NAME
97: OR SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION

Line 100: INSERT INTO OKC_K_GROUPS_TL (

96: AND (SUBB.NAME <> SUBT.NAME
97: OR SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
98: ));
99:
100: INSERT INTO OKC_K_GROUPS_TL (
101: ID,
102: LANGUAGE,
103: SOURCE_LANG,
104: SFWT_FLAG,

Line 124: FROM OKC_K_GROUPS_TL B, FND_LANGUAGES L

120: B.CREATION_DATE,
121: B.LAST_UPDATED_BY,
122: B.LAST_UPDATE_DATE,
123: B.LAST_UPDATE_LOGIN
124: FROM OKC_K_GROUPS_TL B, FND_LANGUAGES L
125: WHERE L.INSTALLED_FLAG IN ('I', 'B')
126: AND B.LANGUAGE = USERENV('LANG')
127: AND NOT EXISTS(
128: SELECT NULL

Line 129: FROM OKC_K_GROUPS_TL T

125: WHERE L.INSTALLED_FLAG IN ('I', 'B')
126: AND B.LANGUAGE = USERENV('LANG')
127: AND NOT EXISTS(
128: SELECT NULL
129: FROM OKC_K_GROUPS_TL T
130: WHERE T.ID = B.ID
131: AND T.LANGUAGE = L.LANGUAGE_CODE
132: );
133:

Line 217: -- FUNCTION get_rec for: OKC_K_GROUPS_TL

213: BEGIN
214: RETURN(get_rec(p_cgp_rec, l_row_notfound));
215: END get_rec;
216: ---------------------------------------------------------------------------
217: -- FUNCTION get_rec for: OKC_K_GROUPS_TL
218: ---------------------------------------------------------------------------
219: FUNCTION get_rec (
220: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
221: x_no_data_found OUT NOCOPY BOOLEAN

Line 220: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,

216: ---------------------------------------------------------------------------
217: -- FUNCTION get_rec for: OKC_K_GROUPS_TL
218: ---------------------------------------------------------------------------
219: FUNCTION get_rec (
220: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
221: x_no_data_found OUT NOCOPY BOOLEAN
222: ) RETURN OkcContractGroupsTlRecType IS
223: CURSOR cgp_pktl_csr (p_id IN NUMBER,
224: p_language IN VARCHAR2) IS

Line 237: FROM Okc_K_Groups_Tl

233: CREATION_DATE,
234: LAST_UPDATED_BY,
235: LAST_UPDATE_DATE,
236: LAST_UPDATE_LOGIN
237: FROM Okc_K_Groups_Tl
238: WHERE okc_K_groups_tl.id = p_id
239: AND okc_K_groups_tl.language = p_language;
240: l_cgp_pktl cgp_pktl_csr%ROWTYPE;
241: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;

Line 238: WHERE okc_K_groups_tl.id = p_id

234: LAST_UPDATED_BY,
235: LAST_UPDATE_DATE,
236: LAST_UPDATE_LOGIN
237: FROM Okc_K_Groups_Tl
238: WHERE okc_K_groups_tl.id = p_id
239: AND okc_K_groups_tl.language = p_language;
240: l_cgp_pktl cgp_pktl_csr%ROWTYPE;
241: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
242: BEGIN

Line 239: AND okc_K_groups_tl.language = p_language;

235: LAST_UPDATE_DATE,
236: LAST_UPDATE_LOGIN
237: FROM Okc_K_Groups_Tl
238: WHERE okc_K_groups_tl.id = p_id
239: AND okc_K_groups_tl.language = p_language;
240: l_cgp_pktl cgp_pktl_csr%ROWTYPE;
241: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
242: BEGIN
243: x_no_data_found := TRUE;

Line 241: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;

237: FROM Okc_K_Groups_Tl
238: WHERE okc_K_groups_tl.id = p_id
239: AND okc_K_groups_tl.language = p_language;
240: l_cgp_pktl cgp_pktl_csr%ROWTYPE;
241: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
242: BEGIN
243: x_no_data_found := TRUE;
244: -- Get current database values
245: OPEN cgp_pktl_csr (p_okc_K_groups_tl_rec.id,

Line 245: OPEN cgp_pktl_csr (p_okc_K_groups_tl_rec.id,

241: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
242: BEGIN
243: x_no_data_found := TRUE;
244: -- Get current database values
245: OPEN cgp_pktl_csr (p_okc_K_groups_tl_rec.id,
246: p_okc_K_groups_tl_rec.language);
247: FETCH cgp_pktl_csr INTO
248: l_okc_K_groups_tl_rec.ID,
249: l_okc_K_groups_tl_rec.LANGUAGE,

Line 246: p_okc_K_groups_tl_rec.language);

242: BEGIN
243: x_no_data_found := TRUE;
244: -- Get current database values
245: OPEN cgp_pktl_csr (p_okc_K_groups_tl_rec.id,
246: p_okc_K_groups_tl_rec.language);
247: FETCH cgp_pktl_csr INTO
248: l_okc_K_groups_tl_rec.ID,
249: l_okc_K_groups_tl_rec.LANGUAGE,
250: l_okc_K_groups_tl_rec.SOURCE_LANG,

Line 248: l_okc_K_groups_tl_rec.ID,

244: -- Get current database values
245: OPEN cgp_pktl_csr (p_okc_K_groups_tl_rec.id,
246: p_okc_K_groups_tl_rec.language);
247: FETCH cgp_pktl_csr INTO
248: l_okc_K_groups_tl_rec.ID,
249: l_okc_K_groups_tl_rec.LANGUAGE,
250: l_okc_K_groups_tl_rec.SOURCE_LANG,
251: l_okc_K_groups_tl_rec.SFWT_FLAG,
252: l_okc_K_groups_tl_rec.NAME,

Line 249: l_okc_K_groups_tl_rec.LANGUAGE,

245: OPEN cgp_pktl_csr (p_okc_K_groups_tl_rec.id,
246: p_okc_K_groups_tl_rec.language);
247: FETCH cgp_pktl_csr INTO
248: l_okc_K_groups_tl_rec.ID,
249: l_okc_K_groups_tl_rec.LANGUAGE,
250: l_okc_K_groups_tl_rec.SOURCE_LANG,
251: l_okc_K_groups_tl_rec.SFWT_FLAG,
252: l_okc_K_groups_tl_rec.NAME,
253: l_okc_K_groups_tl_rec.SHORT_DESCRIPTION,

Line 250: l_okc_K_groups_tl_rec.SOURCE_LANG,

246: p_okc_K_groups_tl_rec.language);
247: FETCH cgp_pktl_csr INTO
248: l_okc_K_groups_tl_rec.ID,
249: l_okc_K_groups_tl_rec.LANGUAGE,
250: l_okc_K_groups_tl_rec.SOURCE_LANG,
251: l_okc_K_groups_tl_rec.SFWT_FLAG,
252: l_okc_K_groups_tl_rec.NAME,
253: l_okc_K_groups_tl_rec.SHORT_DESCRIPTION,
254: l_okc_K_groups_tl_rec.CREATED_BY,

Line 251: l_okc_K_groups_tl_rec.SFWT_FLAG,

247: FETCH cgp_pktl_csr INTO
248: l_okc_K_groups_tl_rec.ID,
249: l_okc_K_groups_tl_rec.LANGUAGE,
250: l_okc_K_groups_tl_rec.SOURCE_LANG,
251: l_okc_K_groups_tl_rec.SFWT_FLAG,
252: l_okc_K_groups_tl_rec.NAME,
253: l_okc_K_groups_tl_rec.SHORT_DESCRIPTION,
254: l_okc_K_groups_tl_rec.CREATED_BY,
255: l_okc_K_groups_tl_rec.CREATION_DATE,

Line 252: l_okc_K_groups_tl_rec.NAME,

248: l_okc_K_groups_tl_rec.ID,
249: l_okc_K_groups_tl_rec.LANGUAGE,
250: l_okc_K_groups_tl_rec.SOURCE_LANG,
251: l_okc_K_groups_tl_rec.SFWT_FLAG,
252: l_okc_K_groups_tl_rec.NAME,
253: l_okc_K_groups_tl_rec.SHORT_DESCRIPTION,
254: l_okc_K_groups_tl_rec.CREATED_BY,
255: l_okc_K_groups_tl_rec.CREATION_DATE,
256: l_okc_K_groups_tl_rec.LAST_UPDATED_BY,

Line 253: l_okc_K_groups_tl_rec.SHORT_DESCRIPTION,

249: l_okc_K_groups_tl_rec.LANGUAGE,
250: l_okc_K_groups_tl_rec.SOURCE_LANG,
251: l_okc_K_groups_tl_rec.SFWT_FLAG,
252: l_okc_K_groups_tl_rec.NAME,
253: l_okc_K_groups_tl_rec.SHORT_DESCRIPTION,
254: l_okc_K_groups_tl_rec.CREATED_BY,
255: l_okc_K_groups_tl_rec.CREATION_DATE,
256: l_okc_K_groups_tl_rec.LAST_UPDATED_BY,
257: l_okc_K_groups_tl_rec.LAST_UPDATE_DATE,

Line 254: l_okc_K_groups_tl_rec.CREATED_BY,

250: l_okc_K_groups_tl_rec.SOURCE_LANG,
251: l_okc_K_groups_tl_rec.SFWT_FLAG,
252: l_okc_K_groups_tl_rec.NAME,
253: l_okc_K_groups_tl_rec.SHORT_DESCRIPTION,
254: l_okc_K_groups_tl_rec.CREATED_BY,
255: l_okc_K_groups_tl_rec.CREATION_DATE,
256: l_okc_K_groups_tl_rec.LAST_UPDATED_BY,
257: l_okc_K_groups_tl_rec.LAST_UPDATE_DATE,
258: l_okc_K_groups_tl_rec.LAST_UPDATE_LOGIN;

Line 255: l_okc_K_groups_tl_rec.CREATION_DATE,

251: l_okc_K_groups_tl_rec.SFWT_FLAG,
252: l_okc_K_groups_tl_rec.NAME,
253: l_okc_K_groups_tl_rec.SHORT_DESCRIPTION,
254: l_okc_K_groups_tl_rec.CREATED_BY,
255: l_okc_K_groups_tl_rec.CREATION_DATE,
256: l_okc_K_groups_tl_rec.LAST_UPDATED_BY,
257: l_okc_K_groups_tl_rec.LAST_UPDATE_DATE,
258: l_okc_K_groups_tl_rec.LAST_UPDATE_LOGIN;
259: x_no_data_found := cgp_pktl_csr%NOTFOUND;

Line 256: l_okc_K_groups_tl_rec.LAST_UPDATED_BY,

252: l_okc_K_groups_tl_rec.NAME,
253: l_okc_K_groups_tl_rec.SHORT_DESCRIPTION,
254: l_okc_K_groups_tl_rec.CREATED_BY,
255: l_okc_K_groups_tl_rec.CREATION_DATE,
256: l_okc_K_groups_tl_rec.LAST_UPDATED_BY,
257: l_okc_K_groups_tl_rec.LAST_UPDATE_DATE,
258: l_okc_K_groups_tl_rec.LAST_UPDATE_LOGIN;
259: x_no_data_found := cgp_pktl_csr%NOTFOUND;
260: CLOSE cgp_pktl_csr;

Line 257: l_okc_K_groups_tl_rec.LAST_UPDATE_DATE,

253: l_okc_K_groups_tl_rec.SHORT_DESCRIPTION,
254: l_okc_K_groups_tl_rec.CREATED_BY,
255: l_okc_K_groups_tl_rec.CREATION_DATE,
256: l_okc_K_groups_tl_rec.LAST_UPDATED_BY,
257: l_okc_K_groups_tl_rec.LAST_UPDATE_DATE,
258: l_okc_K_groups_tl_rec.LAST_UPDATE_LOGIN;
259: x_no_data_found := cgp_pktl_csr%NOTFOUND;
260: CLOSE cgp_pktl_csr;
261: RETURN(l_okc_K_groups_tl_rec);

Line 258: l_okc_K_groups_tl_rec.LAST_UPDATE_LOGIN;

254: l_okc_K_groups_tl_rec.CREATED_BY,
255: l_okc_K_groups_tl_rec.CREATION_DATE,
256: l_okc_K_groups_tl_rec.LAST_UPDATED_BY,
257: l_okc_K_groups_tl_rec.LAST_UPDATE_DATE,
258: l_okc_K_groups_tl_rec.LAST_UPDATE_LOGIN;
259: x_no_data_found := cgp_pktl_csr%NOTFOUND;
260: CLOSE cgp_pktl_csr;
261: RETURN(l_okc_K_groups_tl_rec);
262: END get_rec;

Line 261: RETURN(l_okc_K_groups_tl_rec);

257: l_okc_K_groups_tl_rec.LAST_UPDATE_DATE,
258: l_okc_K_groups_tl_rec.LAST_UPDATE_LOGIN;
259: x_no_data_found := cgp_pktl_csr%NOTFOUND;
260: CLOSE cgp_pktl_csr;
261: RETURN(l_okc_K_groups_tl_rec);
262: END get_rec;
263:
264: FUNCTION get_rec (
265: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType

Line 265: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType

261: RETURN(l_okc_K_groups_tl_rec);
262: END get_rec;
263:
264: FUNCTION get_rec (
265: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType
266: ) RETURN OkcContractGroupsTlRecType IS
267: l_row_notfound BOOLEAN := TRUE;
268: BEGIN
269: RETURN(get_rec(p_okc_K_groups_tl_rec, l_row_notfound));

Line 269: RETURN(get_rec(p_okc_K_groups_tl_rec, l_row_notfound));

265: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType
266: ) RETURN OkcContractGroupsTlRecType IS
267: l_row_notfound BOOLEAN := TRUE;
268: BEGIN
269: RETURN(get_rec(p_okc_K_groups_tl_rec, l_row_notfound));
270: END get_rec;
271: ---------------------------------------------------------------------------
272: -- FUNCTION get_rec for: OKC_K_GROUPS_V
273: ---------------------------------------------------------------------------

Line 1041: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;

1037: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1038: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1039: l_cgpv_rec cgpv_rec_type := p_cgpv_rec;
1040: l_cgp_rec cgp_rec_type;
1041: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
1042: BEGIN
1043: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1044: G_PKG_NAME,
1045: p_init_msg_list,

Line 1305: -- insert_row for:OKC_K_GROUPS_TL --

1301: '_PVT'
1302: );
1303: END insert_row;
1304: -------------------------------------------
1305: -- insert_row for:OKC_K_GROUPS_TL --
1306: -------------------------------------------
1307: PROCEDURE insert_row(
1308: p_init_msg_list IN VARCHAR2 ,
1309: x_return_status OUT NOCOPY VARCHAR2,

Line 1312: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,

1308: p_init_msg_list IN VARCHAR2 ,
1309: x_return_status OUT NOCOPY VARCHAR2,
1310: x_msg_count OUT NOCOPY NUMBER,
1311: x_msg_data OUT NOCOPY VARCHAR2,
1312: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
1313: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType) IS
1314:
1315: l_api_version CONSTANT NUMBER := 1;
1316: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1313: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType) IS

1309: x_return_status OUT NOCOPY VARCHAR2,
1310: x_msg_count OUT NOCOPY NUMBER,
1311: x_msg_data OUT NOCOPY VARCHAR2,
1312: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
1313: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType) IS
1314:
1315: l_api_version CONSTANT NUMBER := 1;
1316: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1317: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1318: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType := p_okc_K_groups_tl_rec;

1314:
1315: l_api_version CONSTANT NUMBER := 1;
1316: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1317: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1318: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType := p_okc_K_groups_tl_rec;
1319: ldefokccontractgroupstlrec OkcContractGroupsTlRecType;
1320: CURSOR get_languages IS
1321: SELECT *
1322: FROM FND_LANGUAGES

Line 1325: -- Set_Attributes for:OKC_K_GROUPS_TL --

1321: SELECT *
1322: FROM FND_LANGUAGES
1323: WHERE INSTALLED_FLAG IN ('I', 'B');
1324: -----------------------------------------------
1325: -- Set_Attributes for:OKC_K_GROUPS_TL --
1326: -----------------------------------------------
1327: FUNCTION Set_Attributes (
1328: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
1329: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType

Line 1328: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,

1324: -----------------------------------------------
1325: -- Set_Attributes for:OKC_K_GROUPS_TL --
1326: -----------------------------------------------
1327: FUNCTION Set_Attributes (
1328: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
1329: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
1330: ) RETURN VARCHAR2 IS
1331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1332: BEGIN

Line 1329: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType

1325: -- Set_Attributes for:OKC_K_GROUPS_TL --
1326: -----------------------------------------------
1327: FUNCTION Set_Attributes (
1328: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
1329: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
1330: ) RETURN VARCHAR2 IS
1331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1332: BEGIN
1333: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;

Line 1333: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;

1329: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
1330: ) RETURN VARCHAR2 IS
1331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1332: BEGIN
1333: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;
1334: x_okc_K_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1335: x_okc_K_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1336: RETURN(l_return_status);
1337: END Set_Attributes;

Line 1334: x_okc_K_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

1330: ) RETURN VARCHAR2 IS
1331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1332: BEGIN
1333: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;
1334: x_okc_K_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1335: x_okc_K_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1336: RETURN(l_return_status);
1337: END Set_Attributes;
1338: BEGIN

Line 1335: x_okc_K_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

1331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1332: BEGIN
1333: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;
1334: x_okc_K_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1335: x_okc_K_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1336: RETURN(l_return_status);
1337: END Set_Attributes;
1338: BEGIN
1339: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1350: p_okc_K_groups_tl_rec, -- IN

1346: RAISE OKC_API.G_EXCEPTION_ERROR;
1347: END IF;
1348: --- Setting item attributes
1349: l_return_status := Set_Attributes(
1350: p_okc_K_groups_tl_rec, -- IN
1351: l_okc_K_groups_tl_rec); -- OUT
1352: --- If any errors happen abort API
1353: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1351: l_okc_K_groups_tl_rec); -- OUT

1347: END IF;
1348: --- Setting item attributes
1349: l_return_status := Set_Attributes(
1350: p_okc_K_groups_tl_rec, -- IN
1351: l_okc_K_groups_tl_rec); -- OUT
1352: --- If any errors happen abort API
1353: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1359: l_okc_K_groups_tl_rec.language := l_lang_rec.language_code;

1355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: FOR l_lang_rec IN get_languages LOOP
1359: l_okc_K_groups_tl_rec.language := l_lang_rec.language_code;
1360: INSERT INTO OKC_K_GROUPS_TL(
1361: id,
1362: language,
1363: source_lang,

Line 1360: INSERT INTO OKC_K_GROUPS_TL(

1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: FOR l_lang_rec IN get_languages LOOP
1359: l_okc_K_groups_tl_rec.language := l_lang_rec.language_code;
1360: INSERT INTO OKC_K_GROUPS_TL(
1361: id,
1362: language,
1363: source_lang,
1364: sfwt_flag,

Line 1373: l_okc_K_groups_tl_rec.id,

1369: last_updated_by,
1370: last_update_date,
1371: last_update_login)
1372: VALUES (
1373: l_okc_K_groups_tl_rec.id,
1374: l_okc_K_groups_tl_rec.language,
1375: l_okc_K_groups_tl_rec.source_lang,
1376: l_okc_K_groups_tl_rec.sfwt_flag,
1377: l_okc_K_groups_tl_rec.name,

Line 1374: l_okc_K_groups_tl_rec.language,

1370: last_update_date,
1371: last_update_login)
1372: VALUES (
1373: l_okc_K_groups_tl_rec.id,
1374: l_okc_K_groups_tl_rec.language,
1375: l_okc_K_groups_tl_rec.source_lang,
1376: l_okc_K_groups_tl_rec.sfwt_flag,
1377: l_okc_K_groups_tl_rec.name,
1378: l_okc_K_groups_tl_rec.short_description,

Line 1375: l_okc_K_groups_tl_rec.source_lang,

1371: last_update_login)
1372: VALUES (
1373: l_okc_K_groups_tl_rec.id,
1374: l_okc_K_groups_tl_rec.language,
1375: l_okc_K_groups_tl_rec.source_lang,
1376: l_okc_K_groups_tl_rec.sfwt_flag,
1377: l_okc_K_groups_tl_rec.name,
1378: l_okc_K_groups_tl_rec.short_description,
1379: l_okc_K_groups_tl_rec.created_by,

Line 1376: l_okc_K_groups_tl_rec.sfwt_flag,

1372: VALUES (
1373: l_okc_K_groups_tl_rec.id,
1374: l_okc_K_groups_tl_rec.language,
1375: l_okc_K_groups_tl_rec.source_lang,
1376: l_okc_K_groups_tl_rec.sfwt_flag,
1377: l_okc_K_groups_tl_rec.name,
1378: l_okc_K_groups_tl_rec.short_description,
1379: l_okc_K_groups_tl_rec.created_by,
1380: l_okc_K_groups_tl_rec.creation_date,

Line 1377: l_okc_K_groups_tl_rec.name,

1373: l_okc_K_groups_tl_rec.id,
1374: l_okc_K_groups_tl_rec.language,
1375: l_okc_K_groups_tl_rec.source_lang,
1376: l_okc_K_groups_tl_rec.sfwt_flag,
1377: l_okc_K_groups_tl_rec.name,
1378: l_okc_K_groups_tl_rec.short_description,
1379: l_okc_K_groups_tl_rec.created_by,
1380: l_okc_K_groups_tl_rec.creation_date,
1381: l_okc_K_groups_tl_rec.last_updated_by,

Line 1378: l_okc_K_groups_tl_rec.short_description,

1374: l_okc_K_groups_tl_rec.language,
1375: l_okc_K_groups_tl_rec.source_lang,
1376: l_okc_K_groups_tl_rec.sfwt_flag,
1377: l_okc_K_groups_tl_rec.name,
1378: l_okc_K_groups_tl_rec.short_description,
1379: l_okc_K_groups_tl_rec.created_by,
1380: l_okc_K_groups_tl_rec.creation_date,
1381: l_okc_K_groups_tl_rec.last_updated_by,
1382: l_okc_K_groups_tl_rec.last_update_date,

Line 1379: l_okc_K_groups_tl_rec.created_by,

1375: l_okc_K_groups_tl_rec.source_lang,
1376: l_okc_K_groups_tl_rec.sfwt_flag,
1377: l_okc_K_groups_tl_rec.name,
1378: l_okc_K_groups_tl_rec.short_description,
1379: l_okc_K_groups_tl_rec.created_by,
1380: l_okc_K_groups_tl_rec.creation_date,
1381: l_okc_K_groups_tl_rec.last_updated_by,
1382: l_okc_K_groups_tl_rec.last_update_date,
1383: l_okc_K_groups_tl_rec.last_update_login);

Line 1380: l_okc_K_groups_tl_rec.creation_date,

1376: l_okc_K_groups_tl_rec.sfwt_flag,
1377: l_okc_K_groups_tl_rec.name,
1378: l_okc_K_groups_tl_rec.short_description,
1379: l_okc_K_groups_tl_rec.created_by,
1380: l_okc_K_groups_tl_rec.creation_date,
1381: l_okc_K_groups_tl_rec.last_updated_by,
1382: l_okc_K_groups_tl_rec.last_update_date,
1383: l_okc_K_groups_tl_rec.last_update_login);
1384: END LOOP;

Line 1381: l_okc_K_groups_tl_rec.last_updated_by,

1377: l_okc_K_groups_tl_rec.name,
1378: l_okc_K_groups_tl_rec.short_description,
1379: l_okc_K_groups_tl_rec.created_by,
1380: l_okc_K_groups_tl_rec.creation_date,
1381: l_okc_K_groups_tl_rec.last_updated_by,
1382: l_okc_K_groups_tl_rec.last_update_date,
1383: l_okc_K_groups_tl_rec.last_update_login);
1384: END LOOP;
1385: -- Set OUT values

Line 1382: l_okc_K_groups_tl_rec.last_update_date,

1378: l_okc_K_groups_tl_rec.short_description,
1379: l_okc_K_groups_tl_rec.created_by,
1380: l_okc_K_groups_tl_rec.creation_date,
1381: l_okc_K_groups_tl_rec.last_updated_by,
1382: l_okc_K_groups_tl_rec.last_update_date,
1383: l_okc_K_groups_tl_rec.last_update_login);
1384: END LOOP;
1385: -- Set OUT values
1386: x_okc_K_groups_tl_rec := l_okc_K_groups_tl_rec;

Line 1383: l_okc_K_groups_tl_rec.last_update_login);

1379: l_okc_K_groups_tl_rec.created_by,
1380: l_okc_K_groups_tl_rec.creation_date,
1381: l_okc_K_groups_tl_rec.last_updated_by,
1382: l_okc_K_groups_tl_rec.last_update_date,
1383: l_okc_K_groups_tl_rec.last_update_login);
1384: END LOOP;
1385: -- Set OUT values
1386: x_okc_K_groups_tl_rec := l_okc_K_groups_tl_rec;
1387: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1386: x_okc_K_groups_tl_rec := l_okc_K_groups_tl_rec;

1382: l_okc_K_groups_tl_rec.last_update_date,
1383: l_okc_K_groups_tl_rec.last_update_login);
1384: END LOOP;
1385: -- Set OUT values
1386: x_okc_K_groups_tl_rec := l_okc_K_groups_tl_rec;
1387: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1388: EXCEPTION
1389: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1390: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1439: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;

1435: l_cgpv_rec cgpv_rec_type;
1436: l_def_cgpv_rec cgpv_rec_type;
1437: l_cgp_rec cgp_rec_type;
1438: lx_cgp_rec cgp_rec_type;
1439: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
1440: lx_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
1441: -------------------------------
1442: -- FUNCTION fill_who_columns --
1443: -------------------------------

Line 1440: lx_okc_K_groups_tl_rec OkcContractGroupsTlRecType;

1436: l_def_cgpv_rec cgpv_rec_type;
1437: l_cgp_rec cgp_rec_type;
1438: lx_cgp_rec cgp_rec_type;
1439: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
1440: lx_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
1441: -------------------------------
1442: -- FUNCTION fill_who_columns --
1443: -------------------------------
1444: FUNCTION fill_who_columns (

Line 1522: migrate(l_def_cgpv_rec, l_okc_K_groups_tl_rec);

1518: --------------------------------------
1519: -- Move VIEW record to "Child" records
1520: --------------------------------------
1521: migrate(l_def_cgpv_rec, l_cgp_rec);
1522: migrate(l_def_cgpv_rec, l_okc_K_groups_tl_rec);
1523: --------------------------------------------
1524: -- Call the INSERT_ROW for each child record
1525: --------------------------------------------
1526: insert_row(

Line 1545: l_okc_K_groups_tl_rec,

1541: p_init_msg_list,
1542: x_return_status,
1543: x_msg_count,
1544: x_msg_data,
1545: l_okc_K_groups_tl_rec,
1546: lx_okc_K_groups_tl_rec
1547: );
1548: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1546: lx_okc_K_groups_tl_rec

1542: x_return_status,
1543: x_msg_count,
1544: x_msg_data,
1545: l_okc_K_groups_tl_rec,
1546: lx_okc_K_groups_tl_rec
1547: );
1548: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1553: migrate(lx_okc_K_groups_tl_rec, l_def_cgpv_rec);

1549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1551: RAISE OKC_API.G_EXCEPTION_ERROR;
1552: END IF;
1553: migrate(lx_okc_K_groups_tl_rec, l_def_cgpv_rec);
1554: -- Set OUT values
1555: x_cgpv_rec := l_def_cgpv_rec;
1556: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1557: EXCEPTION

Line 1765: -- lock_row for:OKC_K_GROUPS_TL --

1761: '_PVT'
1762: );
1763: END lock_row;
1764: -----------------------------------------
1765: -- lock_row for:OKC_K_GROUPS_TL --
1766: -----------------------------------------
1767: PROCEDURE lock_row(
1768: p_init_msg_list IN VARCHAR2 ,
1769: x_return_status OUT NOCOPY VARCHAR2,

Line 1772: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType) IS

1768: p_init_msg_list IN VARCHAR2 ,
1769: x_return_status OUT NOCOPY VARCHAR2,
1770: x_msg_count OUT NOCOPY NUMBER,
1771: x_msg_data OUT NOCOPY VARCHAR2,
1772: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType) IS
1773:
1774: E_Resource_Busy EXCEPTION;
1775: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1776: CURSOR lock_csr (p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType) IS

Line 1776: CURSOR lock_csr (p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType) IS

1772: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType) IS
1773:
1774: E_Resource_Busy EXCEPTION;
1775: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1776: CURSOR lock_csr (p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType) IS
1777: SELECT *
1778: FROM OKC_K_GROUPS_TL
1779: WHERE ID = p_okc_K_groups_tl_rec.id
1780: FOR UPDATE NOWAIT;

Line 1778: FROM OKC_K_GROUPS_TL

1774: E_Resource_Busy EXCEPTION;
1775: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1776: CURSOR lock_csr (p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType) IS
1777: SELECT *
1778: FROM OKC_K_GROUPS_TL
1779: WHERE ID = p_okc_K_groups_tl_rec.id
1780: FOR UPDATE NOWAIT;
1781:
1782: l_api_version CONSTANT NUMBER := 1;

Line 1779: WHERE ID = p_okc_K_groups_tl_rec.id

1775: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1776: CURSOR lock_csr (p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType) IS
1777: SELECT *
1778: FROM OKC_K_GROUPS_TL
1779: WHERE ID = p_okc_K_groups_tl_rec.id
1780: FOR UPDATE NOWAIT;
1781:
1782: l_api_version CONSTANT NUMBER := 1;
1783: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1799: OPEN lock_csr(p_okc_K_groups_tl_rec);

1795: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1796: RAISE OKC_API.G_EXCEPTION_ERROR;
1797: END IF;
1798: BEGIN
1799: OPEN lock_csr(p_okc_K_groups_tl_rec);
1800: FETCH lock_csr INTO l_lock_var;
1801: l_row_notfound := lock_csr%NOTFOUND;
1802: CLOSE lock_csr;
1803: EXCEPTION

Line 1864: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;

1860: l_api_version CONSTANT NUMBER := 1;
1861: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1862: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1863: l_cgp_rec cgp_rec_type;
1864: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
1865: BEGIN
1866: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1867: G_PKG_NAME,
1868: p_init_msg_list,

Line 1882: migrate(p_cgpv_rec, l_okc_K_groups_tl_rec);

1878: --------------------------------------
1879: -- Move VIEW record to "Child" records
1880: --------------------------------------
1881: migrate(p_cgpv_rec, l_cgp_rec);
1882: migrate(p_cgpv_rec, l_okc_K_groups_tl_rec);
1883: --------------------------------------------
1884: -- Call the LOCK_ROW for each child record
1885: --------------------------------------------
1886: lock_row(

Line 1903: l_okc_K_groups_tl_rec

1899: p_init_msg_list,
1900: x_return_status,
1901: x_msg_count,
1902: x_msg_data,
1903: l_okc_K_groups_tl_rec
1904: );
1905: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1907: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2246: -- update_row for:OKC_K_GROUPS_TL --

2242: '_PVT'
2243: );
2244: END update_row;
2245: -------------------------------------------
2246: -- update_row for:OKC_K_GROUPS_TL --
2247: -------------------------------------------
2248: PROCEDURE update_row(
2249: p_init_msg_list IN VARCHAR2 ,
2250: x_return_status OUT NOCOPY VARCHAR2,

Line 2253: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,

2249: p_init_msg_list IN VARCHAR2 ,
2250: x_return_status OUT NOCOPY VARCHAR2,
2251: x_msg_count OUT NOCOPY NUMBER,
2252: x_msg_data OUT NOCOPY VARCHAR2,
2253: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
2254: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType) IS
2255:
2256: l_api_version CONSTANT NUMBER := 1;
2257: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2254: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType) IS

2250: x_return_status OUT NOCOPY VARCHAR2,
2251: x_msg_count OUT NOCOPY NUMBER,
2252: x_msg_data OUT NOCOPY VARCHAR2,
2253: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
2254: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType) IS
2255:
2256: l_api_version CONSTANT NUMBER := 1;
2257: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2258: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2259: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType := p_okc_K_groups_tl_rec;

2255:
2256: l_api_version CONSTANT NUMBER := 1;
2257: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2258: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2259: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType := p_okc_K_groups_tl_rec;
2260: ldefokccontractgroupstlrec OkcContractGroupsTlRecType;
2261: l_row_notfound BOOLEAN := TRUE;
2262: ----------------------------------
2263: -- FUNCTION populate_new_record --

Line 2266: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,

2262: ----------------------------------
2263: -- FUNCTION populate_new_record --
2264: ----------------------------------
2265: FUNCTION populate_new_record (
2266: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
2267: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
2268: ) RETURN VARCHAR2 IS
2269: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
2270: l_row_notfound BOOLEAN := TRUE;

Line 2267: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType

2263: -- FUNCTION populate_new_record --
2264: ----------------------------------
2265: FUNCTION populate_new_record (
2266: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
2267: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
2268: ) RETURN VARCHAR2 IS
2269: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
2270: l_row_notfound BOOLEAN := TRUE;
2271: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2269: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;

2265: FUNCTION populate_new_record (
2266: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
2267: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
2268: ) RETURN VARCHAR2 IS
2269: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
2270: l_row_notfound BOOLEAN := TRUE;
2271: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2272: BEGIN
2273: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;

Line 2273: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;

2269: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
2270: l_row_notfound BOOLEAN := TRUE;
2271: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2272: BEGIN
2273: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;
2274: -- Get current database values
2275: l_okc_K_groups_tl_rec := get_rec(p_okc_K_groups_tl_rec, l_row_notfound);
2276: IF (l_row_notfound) THEN
2277: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2275: l_okc_K_groups_tl_rec := get_rec(p_okc_K_groups_tl_rec, l_row_notfound);

2271: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2272: BEGIN
2273: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;
2274: -- Get current database values
2275: l_okc_K_groups_tl_rec := get_rec(p_okc_K_groups_tl_rec, l_row_notfound);
2276: IF (l_row_notfound) THEN
2277: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2278: END IF;
2279: IF (x_okc_K_groups_tl_rec.id = OKC_API.G_MISS_NUM)

Line 2279: IF (x_okc_K_groups_tl_rec.id = OKC_API.G_MISS_NUM)

2275: l_okc_K_groups_tl_rec := get_rec(p_okc_K_groups_tl_rec, l_row_notfound);
2276: IF (l_row_notfound) THEN
2277: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2278: END IF;
2279: IF (x_okc_K_groups_tl_rec.id = OKC_API.G_MISS_NUM)
2280: THEN
2281: x_okc_K_groups_tl_rec.id := l_okc_K_groups_tl_rec.id;
2282: END IF;
2283: IF (x_okc_K_groups_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2281: x_okc_K_groups_tl_rec.id := l_okc_K_groups_tl_rec.id;

2277: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2278: END IF;
2279: IF (x_okc_K_groups_tl_rec.id = OKC_API.G_MISS_NUM)
2280: THEN
2281: x_okc_K_groups_tl_rec.id := l_okc_K_groups_tl_rec.id;
2282: END IF;
2283: IF (x_okc_K_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
2284: THEN
2285: x_okc_K_groups_tl_rec.language := l_okc_K_groups_tl_rec.language;

Line 2283: IF (x_okc_K_groups_tl_rec.language = OKC_API.G_MISS_CHAR)

2279: IF (x_okc_K_groups_tl_rec.id = OKC_API.G_MISS_NUM)
2280: THEN
2281: x_okc_K_groups_tl_rec.id := l_okc_K_groups_tl_rec.id;
2282: END IF;
2283: IF (x_okc_K_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
2284: THEN
2285: x_okc_K_groups_tl_rec.language := l_okc_K_groups_tl_rec.language;
2286: END IF;
2287: IF (x_okc_K_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2285: x_okc_K_groups_tl_rec.language := l_okc_K_groups_tl_rec.language;

2281: x_okc_K_groups_tl_rec.id := l_okc_K_groups_tl_rec.id;
2282: END IF;
2283: IF (x_okc_K_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
2284: THEN
2285: x_okc_K_groups_tl_rec.language := l_okc_K_groups_tl_rec.language;
2286: END IF;
2287: IF (x_okc_K_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2288: THEN
2289: x_okc_K_groups_tl_rec.source_lang := l_okc_K_groups_tl_rec.source_lang;

Line 2287: IF (x_okc_K_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2283: IF (x_okc_K_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
2284: THEN
2285: x_okc_K_groups_tl_rec.language := l_okc_K_groups_tl_rec.language;
2286: END IF;
2287: IF (x_okc_K_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2288: THEN
2289: x_okc_K_groups_tl_rec.source_lang := l_okc_K_groups_tl_rec.source_lang;
2290: END IF;
2291: IF (x_okc_K_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2289: x_okc_K_groups_tl_rec.source_lang := l_okc_K_groups_tl_rec.source_lang;

2285: x_okc_K_groups_tl_rec.language := l_okc_K_groups_tl_rec.language;
2286: END IF;
2287: IF (x_okc_K_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2288: THEN
2289: x_okc_K_groups_tl_rec.source_lang := l_okc_K_groups_tl_rec.source_lang;
2290: END IF;
2291: IF (x_okc_K_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2292: THEN
2293: x_okc_K_groups_tl_rec.sfwt_flag := l_okc_K_groups_tl_rec.sfwt_flag;

Line 2291: IF (x_okc_K_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2287: IF (x_okc_K_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2288: THEN
2289: x_okc_K_groups_tl_rec.source_lang := l_okc_K_groups_tl_rec.source_lang;
2290: END IF;
2291: IF (x_okc_K_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2292: THEN
2293: x_okc_K_groups_tl_rec.sfwt_flag := l_okc_K_groups_tl_rec.sfwt_flag;
2294: END IF;
2295: IF (x_okc_K_groups_tl_rec.name = OKC_API.G_MISS_CHAR)

Line 2293: x_okc_K_groups_tl_rec.sfwt_flag := l_okc_K_groups_tl_rec.sfwt_flag;

2289: x_okc_K_groups_tl_rec.source_lang := l_okc_K_groups_tl_rec.source_lang;
2290: END IF;
2291: IF (x_okc_K_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2292: THEN
2293: x_okc_K_groups_tl_rec.sfwt_flag := l_okc_K_groups_tl_rec.sfwt_flag;
2294: END IF;
2295: IF (x_okc_K_groups_tl_rec.name = OKC_API.G_MISS_CHAR)
2296: THEN
2297: x_okc_K_groups_tl_rec.name := l_okc_K_groups_tl_rec.name;

Line 2295: IF (x_okc_K_groups_tl_rec.name = OKC_API.G_MISS_CHAR)

2291: IF (x_okc_K_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2292: THEN
2293: x_okc_K_groups_tl_rec.sfwt_flag := l_okc_K_groups_tl_rec.sfwt_flag;
2294: END IF;
2295: IF (x_okc_K_groups_tl_rec.name = OKC_API.G_MISS_CHAR)
2296: THEN
2297: x_okc_K_groups_tl_rec.name := l_okc_K_groups_tl_rec.name;
2298: END IF;
2299: IF (x_okc_K_groups_tl_rec.short_description = OKC_API.G_MISS_CHAR)

Line 2297: x_okc_K_groups_tl_rec.name := l_okc_K_groups_tl_rec.name;

2293: x_okc_K_groups_tl_rec.sfwt_flag := l_okc_K_groups_tl_rec.sfwt_flag;
2294: END IF;
2295: IF (x_okc_K_groups_tl_rec.name = OKC_API.G_MISS_CHAR)
2296: THEN
2297: x_okc_K_groups_tl_rec.name := l_okc_K_groups_tl_rec.name;
2298: END IF;
2299: IF (x_okc_K_groups_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2300: THEN
2301: x_okc_K_groups_tl_rec.short_description := l_okc_K_groups_tl_rec.short_description;

Line 2299: IF (x_okc_K_groups_tl_rec.short_description = OKC_API.G_MISS_CHAR)

2295: IF (x_okc_K_groups_tl_rec.name = OKC_API.G_MISS_CHAR)
2296: THEN
2297: x_okc_K_groups_tl_rec.name := l_okc_K_groups_tl_rec.name;
2298: END IF;
2299: IF (x_okc_K_groups_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2300: THEN
2301: x_okc_K_groups_tl_rec.short_description := l_okc_K_groups_tl_rec.short_description;
2302: END IF;
2303: IF (x_okc_K_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2301: x_okc_K_groups_tl_rec.short_description := l_okc_K_groups_tl_rec.short_description;

2297: x_okc_K_groups_tl_rec.name := l_okc_K_groups_tl_rec.name;
2298: END IF;
2299: IF (x_okc_K_groups_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2300: THEN
2301: x_okc_K_groups_tl_rec.short_description := l_okc_K_groups_tl_rec.short_description;
2302: END IF;
2303: IF (x_okc_K_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
2304: THEN
2305: x_okc_K_groups_tl_rec.created_by := l_okc_K_groups_tl_rec.created_by;

Line 2303: IF (x_okc_K_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)

2299: IF (x_okc_K_groups_tl_rec.short_description = OKC_API.G_MISS_CHAR)
2300: THEN
2301: x_okc_K_groups_tl_rec.short_description := l_okc_K_groups_tl_rec.short_description;
2302: END IF;
2303: IF (x_okc_K_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
2304: THEN
2305: x_okc_K_groups_tl_rec.created_by := l_okc_K_groups_tl_rec.created_by;
2306: END IF;
2307: IF (x_okc_K_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2305: x_okc_K_groups_tl_rec.created_by := l_okc_K_groups_tl_rec.created_by;

2301: x_okc_K_groups_tl_rec.short_description := l_okc_K_groups_tl_rec.short_description;
2302: END IF;
2303: IF (x_okc_K_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
2304: THEN
2305: x_okc_K_groups_tl_rec.created_by := l_okc_K_groups_tl_rec.created_by;
2306: END IF;
2307: IF (x_okc_K_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2308: THEN
2309: x_okc_K_groups_tl_rec.creation_date := l_okc_K_groups_tl_rec.creation_date;

Line 2307: IF (x_okc_K_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2303: IF (x_okc_K_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
2304: THEN
2305: x_okc_K_groups_tl_rec.created_by := l_okc_K_groups_tl_rec.created_by;
2306: END IF;
2307: IF (x_okc_K_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2308: THEN
2309: x_okc_K_groups_tl_rec.creation_date := l_okc_K_groups_tl_rec.creation_date;
2310: END IF;
2311: IF (x_okc_K_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2309: x_okc_K_groups_tl_rec.creation_date := l_okc_K_groups_tl_rec.creation_date;

2305: x_okc_K_groups_tl_rec.created_by := l_okc_K_groups_tl_rec.created_by;
2306: END IF;
2307: IF (x_okc_K_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2308: THEN
2309: x_okc_K_groups_tl_rec.creation_date := l_okc_K_groups_tl_rec.creation_date;
2310: END IF;
2311: IF (x_okc_K_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2312: THEN
2313: x_okc_K_groups_tl_rec.last_updated_by := l_okc_K_groups_tl_rec.last_updated_by;

Line 2311: IF (x_okc_K_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2307: IF (x_okc_K_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2308: THEN
2309: x_okc_K_groups_tl_rec.creation_date := l_okc_K_groups_tl_rec.creation_date;
2310: END IF;
2311: IF (x_okc_K_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2312: THEN
2313: x_okc_K_groups_tl_rec.last_updated_by := l_okc_K_groups_tl_rec.last_updated_by;
2314: END IF;
2315: IF (x_okc_K_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2313: x_okc_K_groups_tl_rec.last_updated_by := l_okc_K_groups_tl_rec.last_updated_by;

2309: x_okc_K_groups_tl_rec.creation_date := l_okc_K_groups_tl_rec.creation_date;
2310: END IF;
2311: IF (x_okc_K_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2312: THEN
2313: x_okc_K_groups_tl_rec.last_updated_by := l_okc_K_groups_tl_rec.last_updated_by;
2314: END IF;
2315: IF (x_okc_K_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2316: THEN
2317: x_okc_K_groups_tl_rec.last_update_date := l_okc_K_groups_tl_rec.last_update_date;

Line 2315: IF (x_okc_K_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2311: IF (x_okc_K_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2312: THEN
2313: x_okc_K_groups_tl_rec.last_updated_by := l_okc_K_groups_tl_rec.last_updated_by;
2314: END IF;
2315: IF (x_okc_K_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2316: THEN
2317: x_okc_K_groups_tl_rec.last_update_date := l_okc_K_groups_tl_rec.last_update_date;
2318: END IF;
2319: IF (x_okc_K_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2317: x_okc_K_groups_tl_rec.last_update_date := l_okc_K_groups_tl_rec.last_update_date;

2313: x_okc_K_groups_tl_rec.last_updated_by := l_okc_K_groups_tl_rec.last_updated_by;
2314: END IF;
2315: IF (x_okc_K_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2316: THEN
2317: x_okc_K_groups_tl_rec.last_update_date := l_okc_K_groups_tl_rec.last_update_date;
2318: END IF;
2319: IF (x_okc_K_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2320: THEN
2321: x_okc_K_groups_tl_rec.last_update_login := l_okc_K_groups_tl_rec.last_update_login;

Line 2319: IF (x_okc_K_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2315: IF (x_okc_K_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2316: THEN
2317: x_okc_K_groups_tl_rec.last_update_date := l_okc_K_groups_tl_rec.last_update_date;
2318: END IF;
2319: IF (x_okc_K_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2320: THEN
2321: x_okc_K_groups_tl_rec.last_update_login := l_okc_K_groups_tl_rec.last_update_login;
2322: END IF;
2323: RETURN(l_return_status);

Line 2321: x_okc_K_groups_tl_rec.last_update_login := l_okc_K_groups_tl_rec.last_update_login;

2317: x_okc_K_groups_tl_rec.last_update_date := l_okc_K_groups_tl_rec.last_update_date;
2318: END IF;
2319: IF (x_okc_K_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2320: THEN
2321: x_okc_K_groups_tl_rec.last_update_login := l_okc_K_groups_tl_rec.last_update_login;
2322: END IF;
2323: RETURN(l_return_status);
2324: END populate_new_record;
2325: -----------------------------------------------

Line 2326: -- Set_Attributes for:OKC_K_GROUPS_TL --

2322: END IF;
2323: RETURN(l_return_status);
2324: END populate_new_record;
2325: -----------------------------------------------
2326: -- Set_Attributes for:OKC_K_GROUPS_TL --
2327: -----------------------------------------------
2328: FUNCTION Set_Attributes (
2329: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
2330: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType

Line 2329: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,

2325: -----------------------------------------------
2326: -- Set_Attributes for:OKC_K_GROUPS_TL --
2327: -----------------------------------------------
2328: FUNCTION Set_Attributes (
2329: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
2330: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
2331: ) RETURN VARCHAR2 IS
2332: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2333: BEGIN

Line 2330: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType

2326: -- Set_Attributes for:OKC_K_GROUPS_TL --
2327: -----------------------------------------------
2328: FUNCTION Set_Attributes (
2329: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
2330: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
2331: ) RETURN VARCHAR2 IS
2332: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2333: BEGIN
2334: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;

Line 2334: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;

2330: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
2331: ) RETURN VARCHAR2 IS
2332: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2333: BEGIN
2334: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;
2335: x_okc_K_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2336: x_okc_K_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2337: RETURN(l_return_status);
2338: END Set_Attributes;

Line 2335: x_okc_K_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2331: ) RETURN VARCHAR2 IS
2332: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2333: BEGIN
2334: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;
2335: x_okc_K_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2336: x_okc_K_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2337: RETURN(l_return_status);
2338: END Set_Attributes;
2339: BEGIN

Line 2336: x_okc_K_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

2332: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2333: BEGIN
2334: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;
2335: x_okc_K_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2336: x_okc_K_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2337: RETURN(l_return_status);
2338: END Set_Attributes;
2339: BEGIN
2340: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2351: p_okc_K_groups_tl_rec, -- IN

2347: RAISE OKC_API.G_EXCEPTION_ERROR;
2348: END IF;
2349: --- Setting item attributes
2350: l_return_status := Set_Attributes(
2351: p_okc_K_groups_tl_rec, -- IN
2352: l_okc_K_groups_tl_rec); -- OUT
2353: --- If any errors happen abort API
2354: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2355: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2352: l_okc_K_groups_tl_rec); -- OUT

2348: END IF;
2349: --- Setting item attributes
2350: l_return_status := Set_Attributes(
2351: p_okc_K_groups_tl_rec, -- IN
2352: l_okc_K_groups_tl_rec); -- OUT
2353: --- If any errors happen abort API
2354: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2355: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2356: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2359: l_return_status := populate_new_record(l_okc_K_groups_tl_rec, ldefokccontractgroupstlrec);

2355: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2356: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2357: RAISE OKC_API.G_EXCEPTION_ERROR;
2358: END IF;
2359: l_return_status := populate_new_record(l_okc_K_groups_tl_rec, ldefokccontractgroupstlrec);
2360: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2361: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2362: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2363: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2365: UPDATE OKC_K_GROUPS_TL

2361: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2362: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2363: RAISE OKC_API.G_EXCEPTION_ERROR;
2364: END IF;
2365: UPDATE OKC_K_GROUPS_TL
2366: SET NAME = ldefokccontractgroupstlrec.name,
2367: SHORT_DESCRIPTION = ldefokccontractgroupstlrec.short_description,
2368: CREATED_BY = ldefokccontractgroupstlrec.created_by,
2369: CREATION_DATE = ldefokccontractgroupstlrec.creation_date,

Line 2376: UPDATE OKC_K_GROUPS_TL

2372: LAST_UPDATE_LOGIN = ldefokccontractgroupstlrec.last_update_login
2373: WHERE ID = ldefokccontractgroupstlrec.id
2374: AND SOURCE_LANG = USERENV('LANG');
2375:
2376: UPDATE OKC_K_GROUPS_TL
2377: SET SFWT_FLAG = 'Y'
2378: WHERE ID = ldefokccontractgroupstlrec.id
2379: AND SOURCE_LANG <> USERENV('LANG');
2380:

Line 2381: x_okc_K_groups_tl_rec := ldefokccontractgroupstlrec;

2377: SET SFWT_FLAG = 'Y'
2378: WHERE ID = ldefokccontractgroupstlrec.id
2379: AND SOURCE_LANG <> USERENV('LANG');
2380:
2381: x_okc_K_groups_tl_rec := ldefokccontractgroupstlrec;
2382: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2383: EXCEPTION
2384: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2385: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2432: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;

2428: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2429: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2430: l_cgpv_rec cgpv_rec_type := p_cgpv_rec;
2431: l_def_cgpv_rec cgpv_rec_type;
2432: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
2433: lx_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
2434: l_cgp_rec cgp_rec_type;
2435: lx_cgp_rec cgp_rec_type;
2436: -------------------------------

Line 2433: lx_okc_K_groups_tl_rec OkcContractGroupsTlRecType;

2429: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2430: l_cgpv_rec cgpv_rec_type := p_cgpv_rec;
2431: l_def_cgpv_rec cgpv_rec_type;
2432: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
2433: lx_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
2434: l_cgp_rec cgp_rec_type;
2435: lx_cgp_rec cgp_rec_type;
2436: -------------------------------
2437: -- FUNCTION fill_who_columns --

Line 2655: migrate(l_def_cgpv_rec, l_okc_K_groups_tl_rec);

2651:
2652: --------------------------------------
2653: -- Move VIEW record to "Child" records
2654: --------------------------------------
2655: migrate(l_def_cgpv_rec, l_okc_K_groups_tl_rec);
2656: migrate(l_def_cgpv_rec, l_cgp_rec);
2657: --------------------------------------------
2658: -- Call the UPDATE_ROW for each child record
2659: --------------------------------------------

Line 2665: l_okc_K_groups_tl_rec,

2661: p_init_msg_list,
2662: x_return_status,
2663: x_msg_count,
2664: x_msg_data,
2665: l_okc_K_groups_tl_rec,
2666: lx_okc_K_groups_tl_rec
2667: );
2668: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2666: lx_okc_K_groups_tl_rec

2662: x_return_status,
2663: x_msg_count,
2664: x_msg_data,
2665: l_okc_K_groups_tl_rec,
2666: lx_okc_K_groups_tl_rec
2667: );
2668: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2670: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2673: migrate(lx_okc_K_groups_tl_rec, l_def_cgpv_rec);

2669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2670: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2671: RAISE OKC_API.G_EXCEPTION_ERROR;
2672: END IF;
2673: migrate(lx_okc_K_groups_tl_rec, l_def_cgpv_rec);
2674: update_row(
2675: p_init_msg_list,
2676: x_return_status,
2677: x_msg_count,

Line 2853: -- delete_row for:OKC_K_GROUPS_TL --

2849: '_PVT'
2850: );
2851: END delete_row;
2852: -------------------------------------------
2853: -- delete_row for:OKC_K_GROUPS_TL --
2854: -------------------------------------------
2855: PROCEDURE delete_row(
2856: p_init_msg_list IN VARCHAR2 ,
2857: x_return_status OUT NOCOPY VARCHAR2,

Line 2860: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType) IS

2856: p_init_msg_list IN VARCHAR2 ,
2857: x_return_status OUT NOCOPY VARCHAR2,
2858: x_msg_count OUT NOCOPY NUMBER,
2859: x_msg_data OUT NOCOPY VARCHAR2,
2860: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType) IS
2861:
2862: l_api_version CONSTANT NUMBER := 1;
2863: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2864: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2865: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType:= p_okc_K_groups_tl_rec;

2861:
2862: l_api_version CONSTANT NUMBER := 1;
2863: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2864: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2865: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType:= p_okc_K_groups_tl_rec;
2866: l_row_notfound BOOLEAN := TRUE;
2867: -----------------------------------------------
2868: -- Set_Attributes for:OKC_K_GROUPS_TL --
2869: -----------------------------------------------

Line 2868: -- Set_Attributes for:OKC_K_GROUPS_TL --

2864: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2865: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType:= p_okc_K_groups_tl_rec;
2866: l_row_notfound BOOLEAN := TRUE;
2867: -----------------------------------------------
2868: -- Set_Attributes for:OKC_K_GROUPS_TL --
2869: -----------------------------------------------
2870: FUNCTION Set_Attributes (
2871: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
2872: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType

Line 2871: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,

2867: -----------------------------------------------
2868: -- Set_Attributes for:OKC_K_GROUPS_TL --
2869: -----------------------------------------------
2870: FUNCTION Set_Attributes (
2871: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
2872: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
2873: ) RETURN VARCHAR2 IS
2874: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2875: BEGIN

Line 2872: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType

2868: -- Set_Attributes for:OKC_K_GROUPS_TL --
2869: -----------------------------------------------
2870: FUNCTION Set_Attributes (
2871: p_okc_K_groups_tl_rec IN OkcContractGroupsTlRecType,
2872: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
2873: ) RETURN VARCHAR2 IS
2874: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2875: BEGIN
2876: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;

Line 2876: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;

2872: x_okc_K_groups_tl_rec OUT NOCOPY OkcContractGroupsTlRecType
2873: ) RETURN VARCHAR2 IS
2874: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2875: BEGIN
2876: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;
2877: x_okc_K_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2878: RETURN(l_return_status);
2879: END Set_Attributes;
2880: BEGIN

Line 2877: x_okc_K_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2873: ) RETURN VARCHAR2 IS
2874: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2875: BEGIN
2876: x_okc_K_groups_tl_rec := p_okc_K_groups_tl_rec;
2877: x_okc_K_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2878: RETURN(l_return_status);
2879: END Set_Attributes;
2880: BEGIN
2881: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2892: p_okc_K_groups_tl_rec, -- IN

2888: RAISE OKC_API.G_EXCEPTION_ERROR;
2889: END IF;
2890: --- Setting item attributes
2891: l_return_status := Set_Attributes(
2892: p_okc_K_groups_tl_rec, -- IN
2893: l_okc_K_groups_tl_rec); -- OUT
2894: --- If any errors happen abort API
2895: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2896: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2893: l_okc_K_groups_tl_rec); -- OUT

2889: END IF;
2890: --- Setting item attributes
2891: l_return_status := Set_Attributes(
2892: p_okc_K_groups_tl_rec, -- IN
2893: l_okc_K_groups_tl_rec); -- OUT
2894: --- If any errors happen abort API
2895: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2896: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2897: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2900: DELETE FROM OKC_K_GROUPS_TL

2896: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2897: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2898: RAISE OKC_API.G_EXCEPTION_ERROR;
2899: END IF;
2900: DELETE FROM OKC_K_GROUPS_TL
2901: WHERE ID = l_okc_K_groups_tl_rec.id;
2902:
2903: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2904: EXCEPTION

Line 2901: WHERE ID = l_okc_K_groups_tl_rec.id;

2897: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2898: RAISE OKC_API.G_EXCEPTION_ERROR;
2899: END IF;
2900: DELETE FROM OKC_K_GROUPS_TL
2901: WHERE ID = l_okc_K_groups_tl_rec.id;
2902:
2903: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2904: EXCEPTION
2905: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2951: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;

2947: l_api_version CONSTANT NUMBER := 1;
2948: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2949: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2950: l_cgpv_rec cgpv_rec_type := p_cgpv_rec;
2951: l_okc_K_groups_tl_rec OkcContractGroupsTlRecType;
2952: l_cgp_rec cgp_rec_type;
2953: BEGIN
2954: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2955: G_PKG_NAME,

Line 2983: migrate(l_cgpv_rec, l_okc_K_groups_tl_rec);

2979: END IF;
2980: --------------------------------------
2981: -- Move VIEW record to "Child" records
2982: --------------------------------------
2983: migrate(l_cgpv_rec, l_okc_K_groups_tl_rec);
2984: migrate(l_cgpv_rec, l_cgp_rec);
2985: --------------------------------------------
2986: -- Call the DELETE_ROW for each child record
2987: --------------------------------------------

Line 2993: l_okc_K_groups_tl_rec

2989: p_init_msg_list,
2990: x_return_status,
2991: x_msg_count,
2992: x_msg_data,
2993: l_okc_K_groups_tl_rec
2994: );
2995: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2997: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN