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_CNH_PVT dependencies on OKC_CONDITION_HEADERS_TL

Line 50: DELETE FROM OKC_CONDITION_HEADERS_TL T

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

Line 57: UPDATE OKC_CONDITION_HEADERS_TL T SET (

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

Line 66: FROM OKC_CONDITION_HEADERS_TL B

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

Line 75: FROM OKC_CONDITION_HEADERS_TL SUBB, OKC_CONDITION_HEADERS_TL SUBT

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

Line 91: INSERT INTO OKC_CONDITION_HEADERS_TL (

87: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
88: ));
89: */
90:
91: INSERT INTO OKC_CONDITION_HEADERS_TL (
92: ID,
93: LANGUAGE,
94: SOURCE_LANG,
95: SFWT_FLAG,

Line 119: FROM OKC_CONDITION_HEADERS_TL B, FND_LANGUAGES L

115: B.CREATION_DATE,
116: B.LAST_UPDATED_BY,
117: B.LAST_UPDATE_DATE,
118: B.LAST_UPDATE_LOGIN
119: FROM OKC_CONDITION_HEADERS_TL B, FND_LANGUAGES L
120: WHERE L.INSTALLED_FLAG IN ('I', 'B')
121: AND B.LANGUAGE = USERENV('LANG')
122: AND NOT EXISTS(
123: SELECT NULL

Line 124: FROM OKC_CONDITION_HEADERS_TL T

120: WHERE L.INSTALLED_FLAG IN ('I', 'B')
121: AND B.LANGUAGE = USERENV('LANG')
122: AND NOT EXISTS(
123: SELECT NULL
124: FROM OKC_CONDITION_HEADERS_TL T
125: WHERE T.ID = B.ID
126: AND T.LANGUAGE = L.LANGUAGE_CODE
127: );
128: DELETE FROM OKC_CONDITION_HEADERS_TLH T

Line 128: DELETE FROM OKC_CONDITION_HEADERS_TLH T

124: FROM OKC_CONDITION_HEADERS_TL T
125: WHERE T.ID = B.ID
126: AND T.LANGUAGE = L.LANGUAGE_CODE
127: );
128: DELETE FROM OKC_CONDITION_HEADERS_TLH T
129: WHERE NOT EXISTS (
130: SELECT NULL
131: FROM OKC_CONDITION_HEADERS_BH B
132: WHERE B.ID = T.ID

Line 135: UPDATE OKC_CONDITION_HEADERS_TLH T SET (

131: FROM OKC_CONDITION_HEADERS_BH B
132: WHERE B.ID = T.ID
133: AND B.MAJOR_VERSION = T.MAJOR_VERSION
134: );
135: UPDATE OKC_CONDITION_HEADERS_TLH T SET (
136: NAME,
137: DESCRIPTION,
138: SHORT_DESCRIPTION,
139: COMMENTS) = (SELECT

Line 144: FROM OKC_CONDITION_HEADERS_TLH B

140: B.NAME,
141: B.DESCRIPTION,
142: B.SHORT_DESCRIPTION,
143: B.COMMENTS
144: FROM OKC_CONDITION_HEADERS_TLH B
145: WHERE B.ID = T.ID
146: AND B.MAJOR_VERSION = T.MAJOR_VERSION
147: AND B.LANGUAGE = T.SOURCE_LANG)
148: WHERE (

Line 156: FROM OKC_CONDITION_HEADERS_TLH SUBB, OKC_CONDITION_HEADERS_TLH SUBT

152: IN (SELECT
153: SUBT.ID,
154: SUBT.MAJOR_VERSION,
155: SUBT.LANGUAGE
156: FROM OKC_CONDITION_HEADERS_TLH SUBB, OKC_CONDITION_HEADERS_TLH SUBT
157: WHERE SUBB.ID = SUBT.ID
158: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
159: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
160: AND (SUBB.NAME <> SUBT.NAME

Line 171: INSERT INTO OKC_CONDITION_HEADERS_TLH (

167: OR (SUBB.SHORT_DESCRIPTION IS NOT NULL AND SUBT.SHORT_DESCRIPTION IS NULL)
168: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
169: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
170: ));
171: INSERT INTO OKC_CONDITION_HEADERS_TLH (
172: ID,
173: LANGUAGE,
174: MAJOR_VERSION,
175: SOURCE_LANG,

Line 201: FROM OKC_CONDITION_HEADERS_TLH B, FND_LANGUAGES L

197: B.CREATION_DATE,
198: B.LAST_UPDATED_BY,
199: B.LAST_UPDATE_DATE,
200: B.LAST_UPDATE_LOGIN
201: FROM OKC_CONDITION_HEADERS_TLH B, FND_LANGUAGES L
202: WHERE L.INSTALLED_FLAG IN ('I', 'B')
203: AND B.LANGUAGE = USERENV('LANG')
204: AND NOT EXISTS(
205: SELECT NULL

Line 206: FROM OKC_CONDITION_HEADERS_TLH T

202: WHERE L.INSTALLED_FLAG IN ('I', 'B')
203: AND B.LANGUAGE = USERENV('LANG')
204: AND NOT EXISTS(
205: SELECT NULL
206: FROM OKC_CONDITION_HEADERS_TLH T
207: WHERE T.ID = B.ID
208: AND T.MAJOR_VERSION = B.MAJOR_VERSION
209: AND T.LANGUAGE = L.LANGUAGE_CODE
210: );

Line 329: -- FUNCTION get_rec for: OKC_CONDITION_HEADERS_TL

325: BEGIN
326: RETURN(get_rec(p_cnh_rec, l_row_notfound));
327: END get_rec;
328: ---------------------------------------------------------------------------
329: -- FUNCTION get_rec for: OKC_CONDITION_HEADERS_TL
330: ---------------------------------------------------------------------------
331: FUNCTION get_rec (
332: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
333: x_no_data_found OUT NOCOPY BOOLEAN

Line 332: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,

328: ---------------------------------------------------------------------------
329: -- FUNCTION get_rec for: OKC_CONDITION_HEADERS_TL
330: ---------------------------------------------------------------------------
331: FUNCTION get_rec (
332: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
333: x_no_data_found OUT NOCOPY BOOLEAN
334: ) RETURN OkcConditionHeadersTlRecType IS
335: CURSOR okc_condition_header1_csr (p_id IN NUMBER,
336: p_language IN VARCHAR2) IS

Line 351: FROM Okc_Condition_Headers_Tl

347: CREATION_DATE,
348: LAST_UPDATED_BY,
349: LAST_UPDATE_DATE,
350: LAST_UPDATE_LOGIN
351: FROM Okc_Condition_Headers_Tl
352: WHERE okc_condition_headers_tl.id = p_id
353: AND okc_condition_headers_tl.language = p_language;
354: l_okc_condition_headers_tl_pk okc_condition_header1_csr%ROWTYPE;
355: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;

Line 352: WHERE okc_condition_headers_tl.id = p_id

348: LAST_UPDATED_BY,
349: LAST_UPDATE_DATE,
350: LAST_UPDATE_LOGIN
351: FROM Okc_Condition_Headers_Tl
352: WHERE okc_condition_headers_tl.id = p_id
353: AND okc_condition_headers_tl.language = p_language;
354: l_okc_condition_headers_tl_pk okc_condition_header1_csr%ROWTYPE;
355: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
356: BEGIN

Line 353: AND okc_condition_headers_tl.language = p_language;

349: LAST_UPDATE_DATE,
350: LAST_UPDATE_LOGIN
351: FROM Okc_Condition_Headers_Tl
352: WHERE okc_condition_headers_tl.id = p_id
353: AND okc_condition_headers_tl.language = p_language;
354: l_okc_condition_headers_tl_pk okc_condition_header1_csr%ROWTYPE;
355: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
356: BEGIN
357: x_no_data_found := TRUE;

Line 354: l_okc_condition_headers_tl_pk okc_condition_header1_csr%ROWTYPE;

350: LAST_UPDATE_LOGIN
351: FROM Okc_Condition_Headers_Tl
352: WHERE okc_condition_headers_tl.id = p_id
353: AND okc_condition_headers_tl.language = p_language;
354: l_okc_condition_headers_tl_pk okc_condition_header1_csr%ROWTYPE;
355: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
356: BEGIN
357: x_no_data_found := TRUE;
358: -- Get current database values

Line 355: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;

351: FROM Okc_Condition_Headers_Tl
352: WHERE okc_condition_headers_tl.id = p_id
353: AND okc_condition_headers_tl.language = p_language;
354: l_okc_condition_headers_tl_pk okc_condition_header1_csr%ROWTYPE;
355: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
356: BEGIN
357: x_no_data_found := TRUE;
358: -- Get current database values
359: OPEN okc_condition_header1_csr (p_okc_condition_headers_tl_rec.id,

Line 359: OPEN okc_condition_header1_csr (p_okc_condition_headers_tl_rec.id,

355: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
356: BEGIN
357: x_no_data_found := TRUE;
358: -- Get current database values
359: OPEN okc_condition_header1_csr (p_okc_condition_headers_tl_rec.id,
360: p_okc_condition_headers_tl_rec.language);
361: FETCH okc_condition_header1_csr INTO
362: l_okc_condition_headers_tl_rec.ID,
363: l_okc_condition_headers_tl_rec.LANGUAGE,

Line 360: p_okc_condition_headers_tl_rec.language);

356: BEGIN
357: x_no_data_found := TRUE;
358: -- Get current database values
359: OPEN okc_condition_header1_csr (p_okc_condition_headers_tl_rec.id,
360: p_okc_condition_headers_tl_rec.language);
361: FETCH okc_condition_header1_csr INTO
362: l_okc_condition_headers_tl_rec.ID,
363: l_okc_condition_headers_tl_rec.LANGUAGE,
364: l_okc_condition_headers_tl_rec.SOURCE_LANG,

Line 362: l_okc_condition_headers_tl_rec.ID,

358: -- Get current database values
359: OPEN okc_condition_header1_csr (p_okc_condition_headers_tl_rec.id,
360: p_okc_condition_headers_tl_rec.language);
361: FETCH okc_condition_header1_csr INTO
362: l_okc_condition_headers_tl_rec.ID,
363: l_okc_condition_headers_tl_rec.LANGUAGE,
364: l_okc_condition_headers_tl_rec.SOURCE_LANG,
365: l_okc_condition_headers_tl_rec.SFWT_FLAG,
366: l_okc_condition_headers_tl_rec.NAME,

Line 363: l_okc_condition_headers_tl_rec.LANGUAGE,

359: OPEN okc_condition_header1_csr (p_okc_condition_headers_tl_rec.id,
360: p_okc_condition_headers_tl_rec.language);
361: FETCH okc_condition_header1_csr INTO
362: l_okc_condition_headers_tl_rec.ID,
363: l_okc_condition_headers_tl_rec.LANGUAGE,
364: l_okc_condition_headers_tl_rec.SOURCE_LANG,
365: l_okc_condition_headers_tl_rec.SFWT_FLAG,
366: l_okc_condition_headers_tl_rec.NAME,
367: l_okc_condition_headers_tl_rec.DESCRIPTION,

Line 364: l_okc_condition_headers_tl_rec.SOURCE_LANG,

360: p_okc_condition_headers_tl_rec.language);
361: FETCH okc_condition_header1_csr INTO
362: l_okc_condition_headers_tl_rec.ID,
363: l_okc_condition_headers_tl_rec.LANGUAGE,
364: l_okc_condition_headers_tl_rec.SOURCE_LANG,
365: l_okc_condition_headers_tl_rec.SFWT_FLAG,
366: l_okc_condition_headers_tl_rec.NAME,
367: l_okc_condition_headers_tl_rec.DESCRIPTION,
368: l_okc_condition_headers_tl_rec.SHORT_DESCRIPTION,

Line 365: l_okc_condition_headers_tl_rec.SFWT_FLAG,

361: FETCH okc_condition_header1_csr INTO
362: l_okc_condition_headers_tl_rec.ID,
363: l_okc_condition_headers_tl_rec.LANGUAGE,
364: l_okc_condition_headers_tl_rec.SOURCE_LANG,
365: l_okc_condition_headers_tl_rec.SFWT_FLAG,
366: l_okc_condition_headers_tl_rec.NAME,
367: l_okc_condition_headers_tl_rec.DESCRIPTION,
368: l_okc_condition_headers_tl_rec.SHORT_DESCRIPTION,
369: l_okc_condition_headers_tl_rec.COMMENTS,

Line 366: l_okc_condition_headers_tl_rec.NAME,

362: l_okc_condition_headers_tl_rec.ID,
363: l_okc_condition_headers_tl_rec.LANGUAGE,
364: l_okc_condition_headers_tl_rec.SOURCE_LANG,
365: l_okc_condition_headers_tl_rec.SFWT_FLAG,
366: l_okc_condition_headers_tl_rec.NAME,
367: l_okc_condition_headers_tl_rec.DESCRIPTION,
368: l_okc_condition_headers_tl_rec.SHORT_DESCRIPTION,
369: l_okc_condition_headers_tl_rec.COMMENTS,
370: l_okc_condition_headers_tl_rec.CREATED_BY,

Line 367: l_okc_condition_headers_tl_rec.DESCRIPTION,

363: l_okc_condition_headers_tl_rec.LANGUAGE,
364: l_okc_condition_headers_tl_rec.SOURCE_LANG,
365: l_okc_condition_headers_tl_rec.SFWT_FLAG,
366: l_okc_condition_headers_tl_rec.NAME,
367: l_okc_condition_headers_tl_rec.DESCRIPTION,
368: l_okc_condition_headers_tl_rec.SHORT_DESCRIPTION,
369: l_okc_condition_headers_tl_rec.COMMENTS,
370: l_okc_condition_headers_tl_rec.CREATED_BY,
371: l_okc_condition_headers_tl_rec.CREATION_DATE,

Line 368: l_okc_condition_headers_tl_rec.SHORT_DESCRIPTION,

364: l_okc_condition_headers_tl_rec.SOURCE_LANG,
365: l_okc_condition_headers_tl_rec.SFWT_FLAG,
366: l_okc_condition_headers_tl_rec.NAME,
367: l_okc_condition_headers_tl_rec.DESCRIPTION,
368: l_okc_condition_headers_tl_rec.SHORT_DESCRIPTION,
369: l_okc_condition_headers_tl_rec.COMMENTS,
370: l_okc_condition_headers_tl_rec.CREATED_BY,
371: l_okc_condition_headers_tl_rec.CREATION_DATE,
372: l_okc_condition_headers_tl_rec.LAST_UPDATED_BY,

Line 369: l_okc_condition_headers_tl_rec.COMMENTS,

365: l_okc_condition_headers_tl_rec.SFWT_FLAG,
366: l_okc_condition_headers_tl_rec.NAME,
367: l_okc_condition_headers_tl_rec.DESCRIPTION,
368: l_okc_condition_headers_tl_rec.SHORT_DESCRIPTION,
369: l_okc_condition_headers_tl_rec.COMMENTS,
370: l_okc_condition_headers_tl_rec.CREATED_BY,
371: l_okc_condition_headers_tl_rec.CREATION_DATE,
372: l_okc_condition_headers_tl_rec.LAST_UPDATED_BY,
373: l_okc_condition_headers_tl_rec.LAST_UPDATE_DATE,

Line 370: l_okc_condition_headers_tl_rec.CREATED_BY,

366: l_okc_condition_headers_tl_rec.NAME,
367: l_okc_condition_headers_tl_rec.DESCRIPTION,
368: l_okc_condition_headers_tl_rec.SHORT_DESCRIPTION,
369: l_okc_condition_headers_tl_rec.COMMENTS,
370: l_okc_condition_headers_tl_rec.CREATED_BY,
371: l_okc_condition_headers_tl_rec.CREATION_DATE,
372: l_okc_condition_headers_tl_rec.LAST_UPDATED_BY,
373: l_okc_condition_headers_tl_rec.LAST_UPDATE_DATE,
374: l_okc_condition_headers_tl_rec.LAST_UPDATE_LOGIN;

Line 371: l_okc_condition_headers_tl_rec.CREATION_DATE,

367: l_okc_condition_headers_tl_rec.DESCRIPTION,
368: l_okc_condition_headers_tl_rec.SHORT_DESCRIPTION,
369: l_okc_condition_headers_tl_rec.COMMENTS,
370: l_okc_condition_headers_tl_rec.CREATED_BY,
371: l_okc_condition_headers_tl_rec.CREATION_DATE,
372: l_okc_condition_headers_tl_rec.LAST_UPDATED_BY,
373: l_okc_condition_headers_tl_rec.LAST_UPDATE_DATE,
374: l_okc_condition_headers_tl_rec.LAST_UPDATE_LOGIN;
375: x_no_data_found := okc_condition_header1_csr%NOTFOUND;

Line 372: l_okc_condition_headers_tl_rec.LAST_UPDATED_BY,

368: l_okc_condition_headers_tl_rec.SHORT_DESCRIPTION,
369: l_okc_condition_headers_tl_rec.COMMENTS,
370: l_okc_condition_headers_tl_rec.CREATED_BY,
371: l_okc_condition_headers_tl_rec.CREATION_DATE,
372: l_okc_condition_headers_tl_rec.LAST_UPDATED_BY,
373: l_okc_condition_headers_tl_rec.LAST_UPDATE_DATE,
374: l_okc_condition_headers_tl_rec.LAST_UPDATE_LOGIN;
375: x_no_data_found := okc_condition_header1_csr%NOTFOUND;
376: CLOSE okc_condition_header1_csr;

Line 373: l_okc_condition_headers_tl_rec.LAST_UPDATE_DATE,

369: l_okc_condition_headers_tl_rec.COMMENTS,
370: l_okc_condition_headers_tl_rec.CREATED_BY,
371: l_okc_condition_headers_tl_rec.CREATION_DATE,
372: l_okc_condition_headers_tl_rec.LAST_UPDATED_BY,
373: l_okc_condition_headers_tl_rec.LAST_UPDATE_DATE,
374: l_okc_condition_headers_tl_rec.LAST_UPDATE_LOGIN;
375: x_no_data_found := okc_condition_header1_csr%NOTFOUND;
376: CLOSE okc_condition_header1_csr;
377: RETURN(l_okc_condition_headers_tl_rec);

Line 374: l_okc_condition_headers_tl_rec.LAST_UPDATE_LOGIN;

370: l_okc_condition_headers_tl_rec.CREATED_BY,
371: l_okc_condition_headers_tl_rec.CREATION_DATE,
372: l_okc_condition_headers_tl_rec.LAST_UPDATED_BY,
373: l_okc_condition_headers_tl_rec.LAST_UPDATE_DATE,
374: l_okc_condition_headers_tl_rec.LAST_UPDATE_LOGIN;
375: x_no_data_found := okc_condition_header1_csr%NOTFOUND;
376: CLOSE okc_condition_header1_csr;
377: RETURN(l_okc_condition_headers_tl_rec);
378: END get_rec;

Line 377: RETURN(l_okc_condition_headers_tl_rec);

373: l_okc_condition_headers_tl_rec.LAST_UPDATE_DATE,
374: l_okc_condition_headers_tl_rec.LAST_UPDATE_LOGIN;
375: x_no_data_found := okc_condition_header1_csr%NOTFOUND;
376: CLOSE okc_condition_header1_csr;
377: RETURN(l_okc_condition_headers_tl_rec);
378: END get_rec;
379:
380: FUNCTION get_rec (
381: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType

Line 381: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType

377: RETURN(l_okc_condition_headers_tl_rec);
378: END get_rec;
379:
380: FUNCTION get_rec (
381: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType
382: ) RETURN OkcConditionHeadersTlRecType IS
383: l_row_notfound BOOLEAN := TRUE;
384: BEGIN
385: RETURN(get_rec(p_okc_condition_headers_tl_rec, l_row_notfound));

Line 385: RETURN(get_rec(p_okc_condition_headers_tl_rec, l_row_notfound));

381: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType
382: ) RETURN OkcConditionHeadersTlRecType IS
383: l_row_notfound BOOLEAN := TRUE;
384: BEGIN
385: RETURN(get_rec(p_okc_condition_headers_tl_rec, l_row_notfound));
386: END get_rec;
387: ---------------------------------------------------------------------------
388: -- FUNCTION get_rec for: OKC_CONDITION_HEADERS_V
389: ---------------------------------------------------------------------------

Line 2755: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;

2751: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
2752: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2753: l_cnhv_rec cnhv_rec_type := p_cnhv_rec;
2754: l_cnh_rec cnh_rec_type;
2755: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
2756: BEGIN
2757: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2758: G_PKG_NAME,
2759: p_init_msg_list,

Line 3052: -- insert_row for:OKC_CONDITION_HEADERS_TL --

3048: '_PVT'
3049: );
3050: END insert_row;
3051: ---------------------------------------------
3052: -- insert_row for:OKC_CONDITION_HEADERS_TL --
3053: ---------------------------------------------
3054: PROCEDURE insert_row(
3055: p_init_msg_list IN VARCHAR2 ,
3056: x_return_status OUT NOCOPY VARCHAR2,

Line 3059: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,

3055: p_init_msg_list IN VARCHAR2 ,
3056: x_return_status OUT NOCOPY VARCHAR2,
3057: x_msg_count OUT NOCOPY NUMBER,
3058: x_msg_data OUT NOCOPY VARCHAR2,
3059: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
3060: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType) IS
3061:
3062: l_api_version CONSTANT NUMBER := 1;
3063: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 3060: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType) IS

3056: x_return_status OUT NOCOPY VARCHAR2,
3057: x_msg_count OUT NOCOPY NUMBER,
3058: x_msg_data OUT NOCOPY VARCHAR2,
3059: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
3060: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType) IS
3061:
3062: l_api_version CONSTANT NUMBER := 1;
3063: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
3064: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3065: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType := p_okc_condition_headers_tl_rec;

3061:
3062: l_api_version CONSTANT NUMBER := 1;
3063: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
3064: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3065: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType := p_okc_condition_headers_tl_rec;
3066: ldefokcconditionheaderstlrec OkcConditionHeadersTlRecType;
3067: CURSOR get_languages IS
3068: SELECT *
3069: FROM FND_LANGUAGES

Line 3072: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --

3068: SELECT *
3069: FROM FND_LANGUAGES
3070: WHERE INSTALLED_FLAG IN ('I', 'B');
3071: -------------------------------------------------
3072: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --
3073: -------------------------------------------------
3074: FUNCTION Set_Attributes (
3075: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
3076: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType

Line 3075: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,

3071: -------------------------------------------------
3072: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --
3073: -------------------------------------------------
3074: FUNCTION Set_Attributes (
3075: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
3076: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
3077: ) RETURN VARCHAR2 IS
3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3079: BEGIN

Line 3076: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType

3072: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --
3073: -------------------------------------------------
3074: FUNCTION Set_Attributes (
3075: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
3076: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
3077: ) RETURN VARCHAR2 IS
3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3079: BEGIN
3080: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;

Line 3080: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;

3076: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
3077: ) RETURN VARCHAR2 IS
3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3079: BEGIN
3080: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;
3081: x_okc_condition_headers_tl_rec.LANGUAGE := l_lang;
3082: x_okc_condition_headers_tl_rec.SOURCE_LANG := l_lang;
3083: RETURN(l_return_status);
3084: END Set_Attributes;

Line 3081: x_okc_condition_headers_tl_rec.LANGUAGE := l_lang;

3077: ) RETURN VARCHAR2 IS
3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3079: BEGIN
3080: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;
3081: x_okc_condition_headers_tl_rec.LANGUAGE := l_lang;
3082: x_okc_condition_headers_tl_rec.SOURCE_LANG := l_lang;
3083: RETURN(l_return_status);
3084: END Set_Attributes;
3085: BEGIN

Line 3082: x_okc_condition_headers_tl_rec.SOURCE_LANG := l_lang;

3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3079: BEGIN
3080: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;
3081: x_okc_condition_headers_tl_rec.LANGUAGE := l_lang;
3082: x_okc_condition_headers_tl_rec.SOURCE_LANG := l_lang;
3083: RETURN(l_return_status);
3084: END Set_Attributes;
3085: BEGIN
3086: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3097: p_okc_condition_headers_tl_rec, -- IN

3093: RAISE OKC_API.G_EXCEPTION_ERROR;
3094: END IF;
3095: --- Setting item attributes
3096: l_return_status := Set_Attributes(
3097: p_okc_condition_headers_tl_rec, -- IN
3098: l_okc_condition_headers_tl_rec); -- OUT
3099: --- If any errors happen abort API
3100: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3101: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3098: l_okc_condition_headers_tl_rec); -- OUT

3094: END IF;
3095: --- Setting item attributes
3096: l_return_status := Set_Attributes(
3097: p_okc_condition_headers_tl_rec, -- IN
3098: l_okc_condition_headers_tl_rec); -- OUT
3099: --- If any errors happen abort API
3100: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3101: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3102: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3106: l_okc_condition_headers_tl_rec.language := l_lang_rec.language_code;

3102: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3103: RAISE OKC_API.G_EXCEPTION_ERROR;
3104: END IF;
3105: FOR l_lang_rec IN get_languages LOOP
3106: l_okc_condition_headers_tl_rec.language := l_lang_rec.language_code;
3107: INSERT INTO OKC_CONDITION_HEADERS_TL(
3108: id,
3109: language,
3110: source_lang,

Line 3107: INSERT INTO OKC_CONDITION_HEADERS_TL(

3103: RAISE OKC_API.G_EXCEPTION_ERROR;
3104: END IF;
3105: FOR l_lang_rec IN get_languages LOOP
3106: l_okc_condition_headers_tl_rec.language := l_lang_rec.language_code;
3107: INSERT INTO OKC_CONDITION_HEADERS_TL(
3108: id,
3109: language,
3110: source_lang,
3111: sfwt_flag,

Line 3122: l_okc_condition_headers_tl_rec.id,

3118: last_updated_by,
3119: last_update_date,
3120: last_update_login)
3121: VALUES (
3122: l_okc_condition_headers_tl_rec.id,
3123: l_okc_condition_headers_tl_rec.language,
3124: l_okc_condition_headers_tl_rec.source_lang,
3125: l_okc_condition_headers_tl_rec.sfwt_flag,
3126: l_okc_condition_headers_tl_rec.name,

Line 3123: l_okc_condition_headers_tl_rec.language,

3119: last_update_date,
3120: last_update_login)
3121: VALUES (
3122: l_okc_condition_headers_tl_rec.id,
3123: l_okc_condition_headers_tl_rec.language,
3124: l_okc_condition_headers_tl_rec.source_lang,
3125: l_okc_condition_headers_tl_rec.sfwt_flag,
3126: l_okc_condition_headers_tl_rec.name,
3127: l_okc_condition_headers_tl_rec.description,

Line 3124: l_okc_condition_headers_tl_rec.source_lang,

3120: last_update_login)
3121: VALUES (
3122: l_okc_condition_headers_tl_rec.id,
3123: l_okc_condition_headers_tl_rec.language,
3124: l_okc_condition_headers_tl_rec.source_lang,
3125: l_okc_condition_headers_tl_rec.sfwt_flag,
3126: l_okc_condition_headers_tl_rec.name,
3127: l_okc_condition_headers_tl_rec.description,
3128: l_okc_condition_headers_tl_rec.short_description,

Line 3125: l_okc_condition_headers_tl_rec.sfwt_flag,

3121: VALUES (
3122: l_okc_condition_headers_tl_rec.id,
3123: l_okc_condition_headers_tl_rec.language,
3124: l_okc_condition_headers_tl_rec.source_lang,
3125: l_okc_condition_headers_tl_rec.sfwt_flag,
3126: l_okc_condition_headers_tl_rec.name,
3127: l_okc_condition_headers_tl_rec.description,
3128: l_okc_condition_headers_tl_rec.short_description,
3129: l_okc_condition_headers_tl_rec.comments,

Line 3126: l_okc_condition_headers_tl_rec.name,

3122: l_okc_condition_headers_tl_rec.id,
3123: l_okc_condition_headers_tl_rec.language,
3124: l_okc_condition_headers_tl_rec.source_lang,
3125: l_okc_condition_headers_tl_rec.sfwt_flag,
3126: l_okc_condition_headers_tl_rec.name,
3127: l_okc_condition_headers_tl_rec.description,
3128: l_okc_condition_headers_tl_rec.short_description,
3129: l_okc_condition_headers_tl_rec.comments,
3130: l_okc_condition_headers_tl_rec.created_by,

Line 3127: l_okc_condition_headers_tl_rec.description,

3123: l_okc_condition_headers_tl_rec.language,
3124: l_okc_condition_headers_tl_rec.source_lang,
3125: l_okc_condition_headers_tl_rec.sfwt_flag,
3126: l_okc_condition_headers_tl_rec.name,
3127: l_okc_condition_headers_tl_rec.description,
3128: l_okc_condition_headers_tl_rec.short_description,
3129: l_okc_condition_headers_tl_rec.comments,
3130: l_okc_condition_headers_tl_rec.created_by,
3131: l_okc_condition_headers_tl_rec.creation_date,

Line 3128: l_okc_condition_headers_tl_rec.short_description,

3124: l_okc_condition_headers_tl_rec.source_lang,
3125: l_okc_condition_headers_tl_rec.sfwt_flag,
3126: l_okc_condition_headers_tl_rec.name,
3127: l_okc_condition_headers_tl_rec.description,
3128: l_okc_condition_headers_tl_rec.short_description,
3129: l_okc_condition_headers_tl_rec.comments,
3130: l_okc_condition_headers_tl_rec.created_by,
3131: l_okc_condition_headers_tl_rec.creation_date,
3132: l_okc_condition_headers_tl_rec.last_updated_by,

Line 3129: l_okc_condition_headers_tl_rec.comments,

3125: l_okc_condition_headers_tl_rec.sfwt_flag,
3126: l_okc_condition_headers_tl_rec.name,
3127: l_okc_condition_headers_tl_rec.description,
3128: l_okc_condition_headers_tl_rec.short_description,
3129: l_okc_condition_headers_tl_rec.comments,
3130: l_okc_condition_headers_tl_rec.created_by,
3131: l_okc_condition_headers_tl_rec.creation_date,
3132: l_okc_condition_headers_tl_rec.last_updated_by,
3133: l_okc_condition_headers_tl_rec.last_update_date,

Line 3130: l_okc_condition_headers_tl_rec.created_by,

3126: l_okc_condition_headers_tl_rec.name,
3127: l_okc_condition_headers_tl_rec.description,
3128: l_okc_condition_headers_tl_rec.short_description,
3129: l_okc_condition_headers_tl_rec.comments,
3130: l_okc_condition_headers_tl_rec.created_by,
3131: l_okc_condition_headers_tl_rec.creation_date,
3132: l_okc_condition_headers_tl_rec.last_updated_by,
3133: l_okc_condition_headers_tl_rec.last_update_date,
3134: l_okc_condition_headers_tl_rec.last_update_login);

Line 3131: l_okc_condition_headers_tl_rec.creation_date,

3127: l_okc_condition_headers_tl_rec.description,
3128: l_okc_condition_headers_tl_rec.short_description,
3129: l_okc_condition_headers_tl_rec.comments,
3130: l_okc_condition_headers_tl_rec.created_by,
3131: l_okc_condition_headers_tl_rec.creation_date,
3132: l_okc_condition_headers_tl_rec.last_updated_by,
3133: l_okc_condition_headers_tl_rec.last_update_date,
3134: l_okc_condition_headers_tl_rec.last_update_login);
3135: END LOOP;

Line 3132: l_okc_condition_headers_tl_rec.last_updated_by,

3128: l_okc_condition_headers_tl_rec.short_description,
3129: l_okc_condition_headers_tl_rec.comments,
3130: l_okc_condition_headers_tl_rec.created_by,
3131: l_okc_condition_headers_tl_rec.creation_date,
3132: l_okc_condition_headers_tl_rec.last_updated_by,
3133: l_okc_condition_headers_tl_rec.last_update_date,
3134: l_okc_condition_headers_tl_rec.last_update_login);
3135: END LOOP;
3136: -- Set OUT values

Line 3133: l_okc_condition_headers_tl_rec.last_update_date,

3129: l_okc_condition_headers_tl_rec.comments,
3130: l_okc_condition_headers_tl_rec.created_by,
3131: l_okc_condition_headers_tl_rec.creation_date,
3132: l_okc_condition_headers_tl_rec.last_updated_by,
3133: l_okc_condition_headers_tl_rec.last_update_date,
3134: l_okc_condition_headers_tl_rec.last_update_login);
3135: END LOOP;
3136: -- Set OUT values
3137: x_okc_condition_headers_tl_rec := l_okc_condition_headers_tl_rec;

Line 3134: l_okc_condition_headers_tl_rec.last_update_login);

3130: l_okc_condition_headers_tl_rec.created_by,
3131: l_okc_condition_headers_tl_rec.creation_date,
3132: l_okc_condition_headers_tl_rec.last_updated_by,
3133: l_okc_condition_headers_tl_rec.last_update_date,
3134: l_okc_condition_headers_tl_rec.last_update_login);
3135: END LOOP;
3136: -- Set OUT values
3137: x_okc_condition_headers_tl_rec := l_okc_condition_headers_tl_rec;
3138: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3137: x_okc_condition_headers_tl_rec := l_okc_condition_headers_tl_rec;

3133: l_okc_condition_headers_tl_rec.last_update_date,
3134: l_okc_condition_headers_tl_rec.last_update_login);
3135: END LOOP;
3136: -- Set OUT values
3137: x_okc_condition_headers_tl_rec := l_okc_condition_headers_tl_rec;
3138: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3139: EXCEPTION
3140: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3141: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3191: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;

3187: l_cnhv_rec cnhv_rec_type;
3188: l_def_cnhv_rec cnhv_rec_type;
3189: l_cnh_rec cnh_rec_type;
3190: lx_cnh_rec cnh_rec_type;
3191: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
3192: LxOkcConditionHeadersTlRec OkcConditionHeadersTlRecType;
3193: -------------------------------
3194: -- FUNCTION fill_who_columns --
3195: -------------------------------

Line 3293: migrate(l_def_cnhv_rec, l_okc_condition_headers_tl_rec);

3289: --------------------------------------
3290: -- Move VIEW record to "Child" records
3291: --------------------------------------
3292: migrate(l_def_cnhv_rec, l_cnh_rec);
3293: migrate(l_def_cnhv_rec, l_okc_condition_headers_tl_rec);
3294: --------------------------------------------
3295: -- Call the INSERT_ROW for each child record
3296: --------------------------------------------
3297: insert_row(

Line 3316: l_okc_condition_headers_tl_rec,

3312: p_init_msg_list,
3313: x_return_status,
3314: x_msg_count,
3315: x_msg_data,
3316: l_okc_condition_headers_tl_rec,
3317: LxOkcConditionHeadersTlRec
3318: );
3319: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3320: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3537: -- lock_row for:OKC_CONDITION_HEADERS_TL --

3533: '_PVT'
3534: );
3535: END lock_row;
3536: -------------------------------------------
3537: -- lock_row for:OKC_CONDITION_HEADERS_TL --
3538: -------------------------------------------
3539: PROCEDURE lock_row(
3540: p_init_msg_list IN VARCHAR2 ,
3541: x_return_status OUT NOCOPY VARCHAR2,

Line 3544: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType) IS

3540: p_init_msg_list IN VARCHAR2 ,
3541: x_return_status OUT NOCOPY VARCHAR2,
3542: x_msg_count OUT NOCOPY NUMBER,
3543: x_msg_data OUT NOCOPY VARCHAR2,
3544: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType) IS
3545:
3546: E_Resource_Busy EXCEPTION;
3547: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3548: CURSOR lock_csr (p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType) IS

Line 3548: CURSOR lock_csr (p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType) IS

3544: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType) IS
3545:
3546: E_Resource_Busy EXCEPTION;
3547: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3548: CURSOR lock_csr (p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType) IS
3549: SELECT *
3550: FROM OKC_CONDITION_HEADERS_TL
3551: WHERE ID = p_okc_condition_headers_tl_rec.id
3552: FOR UPDATE NOWAIT;

Line 3550: FROM OKC_CONDITION_HEADERS_TL

3546: E_Resource_Busy EXCEPTION;
3547: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3548: CURSOR lock_csr (p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType) IS
3549: SELECT *
3550: FROM OKC_CONDITION_HEADERS_TL
3551: WHERE ID = p_okc_condition_headers_tl_rec.id
3552: FOR UPDATE NOWAIT;
3553:
3554: l_api_version CONSTANT NUMBER := 1;

Line 3551: WHERE ID = p_okc_condition_headers_tl_rec.id

3547: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3548: CURSOR lock_csr (p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType) IS
3549: SELECT *
3550: FROM OKC_CONDITION_HEADERS_TL
3551: WHERE ID = p_okc_condition_headers_tl_rec.id
3552: FOR UPDATE NOWAIT;
3553:
3554: l_api_version CONSTANT NUMBER := 1;
3555: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 3571: OPEN lock_csr(p_okc_condition_headers_tl_rec);

3567: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3568: RAISE OKC_API.G_EXCEPTION_ERROR;
3569: END IF;
3570: BEGIN
3571: OPEN lock_csr(p_okc_condition_headers_tl_rec);
3572: FETCH lock_csr INTO l_lock_var;
3573: l_row_notfound := lock_csr%NOTFOUND;
3574: CLOSE lock_csr;
3575: EXCEPTION

Line 3636: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;

3632: l_api_version CONSTANT NUMBER := 1;
3633: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
3634: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3635: l_cnh_rec cnh_rec_type;
3636: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
3637: BEGIN
3638: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3639: G_PKG_NAME,
3640: p_init_msg_list,

Line 3654: migrate(p_cnhv_rec, l_okc_condition_headers_tl_rec);

3650: --------------------------------------
3651: -- Move VIEW record to "Child" records
3652: --------------------------------------
3653: migrate(p_cnhv_rec, l_cnh_rec);
3654: migrate(p_cnhv_rec, l_okc_condition_headers_tl_rec);
3655: --------------------------------------------
3656: -- Call the LOCK_ROW for each child record
3657: --------------------------------------------
3658: lock_row(

Line 3675: l_okc_condition_headers_tl_rec

3671: p_init_msg_list,
3672: x_return_status,
3673: x_msg_count,
3674: x_msg_data,
3675: l_okc_condition_headers_tl_rec
3676: );
3677: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3678: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3679: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4099: -- update_row for:OKC_CONDITION_HEADERS_TL --

4095: '_PVT'
4096: );
4097: END update_row;
4098: ---------------------------------------------
4099: -- update_row for:OKC_CONDITION_HEADERS_TL --
4100: ---------------------------------------------
4101: PROCEDURE update_row(
4102: p_init_msg_list IN VARCHAR2 ,
4103: x_return_status OUT NOCOPY VARCHAR2,

Line 4106: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,

4102: p_init_msg_list IN VARCHAR2 ,
4103: x_return_status OUT NOCOPY VARCHAR2,
4104: x_msg_count OUT NOCOPY NUMBER,
4105: x_msg_data OUT NOCOPY VARCHAR2,
4106: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
4107: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType) IS
4108:
4109: l_api_version CONSTANT NUMBER := 1;
4110: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 4107: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType) IS

4103: x_return_status OUT NOCOPY VARCHAR2,
4104: x_msg_count OUT NOCOPY NUMBER,
4105: x_msg_data OUT NOCOPY VARCHAR2,
4106: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
4107: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType) IS
4108:
4109: l_api_version CONSTANT NUMBER := 1;
4110: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4111: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4112: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType := p_okc_condition_headers_tl_rec;

4108:
4109: l_api_version CONSTANT NUMBER := 1;
4110: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
4111: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4112: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType := p_okc_condition_headers_tl_rec;
4113: ldefokcconditionheaderstlrec OkcConditionHeadersTlRecType;
4114: l_row_notfound BOOLEAN := TRUE;
4115: ----------------------------------
4116: -- FUNCTION populate_new_record --

Line 4119: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,

4115: ----------------------------------
4116: -- FUNCTION populate_new_record --
4117: ----------------------------------
4118: FUNCTION populate_new_record (
4119: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
4120: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
4121: ) RETURN VARCHAR2 IS
4122: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
4123: l_row_notfound BOOLEAN := TRUE;

Line 4120: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType

4116: -- FUNCTION populate_new_record --
4117: ----------------------------------
4118: FUNCTION populate_new_record (
4119: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
4120: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
4121: ) RETURN VARCHAR2 IS
4122: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
4123: l_row_notfound BOOLEAN := TRUE;
4124: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4122: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;

4118: FUNCTION populate_new_record (
4119: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
4120: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
4121: ) RETURN VARCHAR2 IS
4122: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
4123: l_row_notfound BOOLEAN := TRUE;
4124: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4125: BEGIN
4126: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;

Line 4126: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;

4122: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
4123: l_row_notfound BOOLEAN := TRUE;
4124: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4125: BEGIN
4126: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;
4127: -- Get current database values
4128: l_okc_condition_headers_tl_rec := get_rec(p_okc_condition_headers_tl_rec, l_row_notfound);
4129: IF (l_row_notfound) THEN
4130: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 4128: l_okc_condition_headers_tl_rec := get_rec(p_okc_condition_headers_tl_rec, l_row_notfound);

4124: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4125: BEGIN
4126: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;
4127: -- Get current database values
4128: l_okc_condition_headers_tl_rec := get_rec(p_okc_condition_headers_tl_rec, l_row_notfound);
4129: IF (l_row_notfound) THEN
4130: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4131: END IF;
4132: IF (x_okc_condition_headers_tl_rec.id = OKC_API.G_MISS_NUM)

Line 4132: IF (x_okc_condition_headers_tl_rec.id = OKC_API.G_MISS_NUM)

4128: l_okc_condition_headers_tl_rec := get_rec(p_okc_condition_headers_tl_rec, l_row_notfound);
4129: IF (l_row_notfound) THEN
4130: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4131: END IF;
4132: IF (x_okc_condition_headers_tl_rec.id = OKC_API.G_MISS_NUM)
4133: THEN
4134: x_okc_condition_headers_tl_rec.id := l_okc_condition_headers_tl_rec.id;
4135: END IF;
4136: IF (x_okc_condition_headers_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 4134: x_okc_condition_headers_tl_rec.id := l_okc_condition_headers_tl_rec.id;

4130: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4131: END IF;
4132: IF (x_okc_condition_headers_tl_rec.id = OKC_API.G_MISS_NUM)
4133: THEN
4134: x_okc_condition_headers_tl_rec.id := l_okc_condition_headers_tl_rec.id;
4135: END IF;
4136: IF (x_okc_condition_headers_tl_rec.language = OKC_API.G_MISS_CHAR)
4137: THEN
4138: x_okc_condition_headers_tl_rec.language := l_okc_condition_headers_tl_rec.language;

Line 4136: IF (x_okc_condition_headers_tl_rec.language = OKC_API.G_MISS_CHAR)

4132: IF (x_okc_condition_headers_tl_rec.id = OKC_API.G_MISS_NUM)
4133: THEN
4134: x_okc_condition_headers_tl_rec.id := l_okc_condition_headers_tl_rec.id;
4135: END IF;
4136: IF (x_okc_condition_headers_tl_rec.language = OKC_API.G_MISS_CHAR)
4137: THEN
4138: x_okc_condition_headers_tl_rec.language := l_okc_condition_headers_tl_rec.language;
4139: END IF;
4140: IF (x_okc_condition_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 4138: x_okc_condition_headers_tl_rec.language := l_okc_condition_headers_tl_rec.language;

4134: x_okc_condition_headers_tl_rec.id := l_okc_condition_headers_tl_rec.id;
4135: END IF;
4136: IF (x_okc_condition_headers_tl_rec.language = OKC_API.G_MISS_CHAR)
4137: THEN
4138: x_okc_condition_headers_tl_rec.language := l_okc_condition_headers_tl_rec.language;
4139: END IF;
4140: IF (x_okc_condition_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4141: THEN
4142: x_okc_condition_headers_tl_rec.source_lang := l_okc_condition_headers_tl_rec.source_lang;

Line 4140: IF (x_okc_condition_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

4136: IF (x_okc_condition_headers_tl_rec.language = OKC_API.G_MISS_CHAR)
4137: THEN
4138: x_okc_condition_headers_tl_rec.language := l_okc_condition_headers_tl_rec.language;
4139: END IF;
4140: IF (x_okc_condition_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4141: THEN
4142: x_okc_condition_headers_tl_rec.source_lang := l_okc_condition_headers_tl_rec.source_lang;
4143: END IF;
4144: IF (x_okc_condition_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 4142: x_okc_condition_headers_tl_rec.source_lang := l_okc_condition_headers_tl_rec.source_lang;

4138: x_okc_condition_headers_tl_rec.language := l_okc_condition_headers_tl_rec.language;
4139: END IF;
4140: IF (x_okc_condition_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4141: THEN
4142: x_okc_condition_headers_tl_rec.source_lang := l_okc_condition_headers_tl_rec.source_lang;
4143: END IF;
4144: IF (x_okc_condition_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4145: THEN
4146: x_okc_condition_headers_tl_rec.sfwt_flag := l_okc_condition_headers_tl_rec.sfwt_flag;

Line 4144: IF (x_okc_condition_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

4140: IF (x_okc_condition_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
4141: THEN
4142: x_okc_condition_headers_tl_rec.source_lang := l_okc_condition_headers_tl_rec.source_lang;
4143: END IF;
4144: IF (x_okc_condition_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4145: THEN
4146: x_okc_condition_headers_tl_rec.sfwt_flag := l_okc_condition_headers_tl_rec.sfwt_flag;
4147: END IF;
4148: IF (x_okc_condition_headers_tl_rec.name = OKC_API.G_MISS_CHAR)

Line 4146: x_okc_condition_headers_tl_rec.sfwt_flag := l_okc_condition_headers_tl_rec.sfwt_flag;

4142: x_okc_condition_headers_tl_rec.source_lang := l_okc_condition_headers_tl_rec.source_lang;
4143: END IF;
4144: IF (x_okc_condition_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4145: THEN
4146: x_okc_condition_headers_tl_rec.sfwt_flag := l_okc_condition_headers_tl_rec.sfwt_flag;
4147: END IF;
4148: IF (x_okc_condition_headers_tl_rec.name = OKC_API.G_MISS_CHAR)
4149: THEN
4150: x_okc_condition_headers_tl_rec.name := l_okc_condition_headers_tl_rec.name;

Line 4148: IF (x_okc_condition_headers_tl_rec.name = OKC_API.G_MISS_CHAR)

4144: IF (x_okc_condition_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
4145: THEN
4146: x_okc_condition_headers_tl_rec.sfwt_flag := l_okc_condition_headers_tl_rec.sfwt_flag;
4147: END IF;
4148: IF (x_okc_condition_headers_tl_rec.name = OKC_API.G_MISS_CHAR)
4149: THEN
4150: x_okc_condition_headers_tl_rec.name := l_okc_condition_headers_tl_rec.name;
4151: END IF;
4152: IF (x_okc_condition_headers_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 4150: x_okc_condition_headers_tl_rec.name := l_okc_condition_headers_tl_rec.name;

4146: x_okc_condition_headers_tl_rec.sfwt_flag := l_okc_condition_headers_tl_rec.sfwt_flag;
4147: END IF;
4148: IF (x_okc_condition_headers_tl_rec.name = OKC_API.G_MISS_CHAR)
4149: THEN
4150: x_okc_condition_headers_tl_rec.name := l_okc_condition_headers_tl_rec.name;
4151: END IF;
4152: IF (x_okc_condition_headers_tl_rec.description = OKC_API.G_MISS_CHAR)
4153: THEN
4154: x_okc_condition_headers_tl_rec.description := l_okc_condition_headers_tl_rec.description;

Line 4152: IF (x_okc_condition_headers_tl_rec.description = OKC_API.G_MISS_CHAR)

4148: IF (x_okc_condition_headers_tl_rec.name = OKC_API.G_MISS_CHAR)
4149: THEN
4150: x_okc_condition_headers_tl_rec.name := l_okc_condition_headers_tl_rec.name;
4151: END IF;
4152: IF (x_okc_condition_headers_tl_rec.description = OKC_API.G_MISS_CHAR)
4153: THEN
4154: x_okc_condition_headers_tl_rec.description := l_okc_condition_headers_tl_rec.description;
4155: END IF;
4156: IF (x_okc_condition_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)

Line 4154: x_okc_condition_headers_tl_rec.description := l_okc_condition_headers_tl_rec.description;

4150: x_okc_condition_headers_tl_rec.name := l_okc_condition_headers_tl_rec.name;
4151: END IF;
4152: IF (x_okc_condition_headers_tl_rec.description = OKC_API.G_MISS_CHAR)
4153: THEN
4154: x_okc_condition_headers_tl_rec.description := l_okc_condition_headers_tl_rec.description;
4155: END IF;
4156: IF (x_okc_condition_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)
4157: THEN
4158: x_okc_condition_headers_tl_rec.short_description := l_okc_condition_headers_tl_rec.short_description;

Line 4156: IF (x_okc_condition_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)

4152: IF (x_okc_condition_headers_tl_rec.description = OKC_API.G_MISS_CHAR)
4153: THEN
4154: x_okc_condition_headers_tl_rec.description := l_okc_condition_headers_tl_rec.description;
4155: END IF;
4156: IF (x_okc_condition_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)
4157: THEN
4158: x_okc_condition_headers_tl_rec.short_description := l_okc_condition_headers_tl_rec.short_description;
4159: END IF;
4160: IF (x_okc_condition_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)

Line 4158: x_okc_condition_headers_tl_rec.short_description := l_okc_condition_headers_tl_rec.short_description;

4154: x_okc_condition_headers_tl_rec.description := l_okc_condition_headers_tl_rec.description;
4155: END IF;
4156: IF (x_okc_condition_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)
4157: THEN
4158: x_okc_condition_headers_tl_rec.short_description := l_okc_condition_headers_tl_rec.short_description;
4159: END IF;
4160: IF (x_okc_condition_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)
4161: THEN
4162: x_okc_condition_headers_tl_rec.comments := l_okc_condition_headers_tl_rec.comments;

Line 4160: IF (x_okc_condition_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)

4156: IF (x_okc_condition_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)
4157: THEN
4158: x_okc_condition_headers_tl_rec.short_description := l_okc_condition_headers_tl_rec.short_description;
4159: END IF;
4160: IF (x_okc_condition_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)
4161: THEN
4162: x_okc_condition_headers_tl_rec.comments := l_okc_condition_headers_tl_rec.comments;
4163: END IF;
4164: IF (x_okc_condition_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 4162: x_okc_condition_headers_tl_rec.comments := l_okc_condition_headers_tl_rec.comments;

4158: x_okc_condition_headers_tl_rec.short_description := l_okc_condition_headers_tl_rec.short_description;
4159: END IF;
4160: IF (x_okc_condition_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)
4161: THEN
4162: x_okc_condition_headers_tl_rec.comments := l_okc_condition_headers_tl_rec.comments;
4163: END IF;
4164: IF (x_okc_condition_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)
4165: THEN
4166: x_okc_condition_headers_tl_rec.created_by := l_okc_condition_headers_tl_rec.created_by;

Line 4164: IF (x_okc_condition_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)

4160: IF (x_okc_condition_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)
4161: THEN
4162: x_okc_condition_headers_tl_rec.comments := l_okc_condition_headers_tl_rec.comments;
4163: END IF;
4164: IF (x_okc_condition_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)
4165: THEN
4166: x_okc_condition_headers_tl_rec.created_by := l_okc_condition_headers_tl_rec.created_by;
4167: END IF;
4168: IF (x_okc_condition_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 4166: x_okc_condition_headers_tl_rec.created_by := l_okc_condition_headers_tl_rec.created_by;

4162: x_okc_condition_headers_tl_rec.comments := l_okc_condition_headers_tl_rec.comments;
4163: END IF;
4164: IF (x_okc_condition_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)
4165: THEN
4166: x_okc_condition_headers_tl_rec.created_by := l_okc_condition_headers_tl_rec.created_by;
4167: END IF;
4168: IF (x_okc_condition_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4169: THEN
4170: x_okc_condition_headers_tl_rec.creation_date := l_okc_condition_headers_tl_rec.creation_date;

Line 4168: IF (x_okc_condition_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)

4164: IF (x_okc_condition_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)
4165: THEN
4166: x_okc_condition_headers_tl_rec.created_by := l_okc_condition_headers_tl_rec.created_by;
4167: END IF;
4168: IF (x_okc_condition_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4169: THEN
4170: x_okc_condition_headers_tl_rec.creation_date := l_okc_condition_headers_tl_rec.creation_date;
4171: END IF;
4172: IF (x_okc_condition_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 4170: x_okc_condition_headers_tl_rec.creation_date := l_okc_condition_headers_tl_rec.creation_date;

4166: x_okc_condition_headers_tl_rec.created_by := l_okc_condition_headers_tl_rec.created_by;
4167: END IF;
4168: IF (x_okc_condition_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4169: THEN
4170: x_okc_condition_headers_tl_rec.creation_date := l_okc_condition_headers_tl_rec.creation_date;
4171: END IF;
4172: IF (x_okc_condition_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4173: THEN
4174: x_okc_condition_headers_tl_rec.last_updated_by := l_okc_condition_headers_tl_rec.last_updated_by;

Line 4172: IF (x_okc_condition_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

4168: IF (x_okc_condition_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)
4169: THEN
4170: x_okc_condition_headers_tl_rec.creation_date := l_okc_condition_headers_tl_rec.creation_date;
4171: END IF;
4172: IF (x_okc_condition_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4173: THEN
4174: x_okc_condition_headers_tl_rec.last_updated_by := l_okc_condition_headers_tl_rec.last_updated_by;
4175: END IF;
4176: IF (x_okc_condition_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 4174: x_okc_condition_headers_tl_rec.last_updated_by := l_okc_condition_headers_tl_rec.last_updated_by;

4170: x_okc_condition_headers_tl_rec.creation_date := l_okc_condition_headers_tl_rec.creation_date;
4171: END IF;
4172: IF (x_okc_condition_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4173: THEN
4174: x_okc_condition_headers_tl_rec.last_updated_by := l_okc_condition_headers_tl_rec.last_updated_by;
4175: END IF;
4176: IF (x_okc_condition_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4177: THEN
4178: x_okc_condition_headers_tl_rec.last_update_date := l_okc_condition_headers_tl_rec.last_update_date;

Line 4176: IF (x_okc_condition_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

4172: IF (x_okc_condition_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
4173: THEN
4174: x_okc_condition_headers_tl_rec.last_updated_by := l_okc_condition_headers_tl_rec.last_updated_by;
4175: END IF;
4176: IF (x_okc_condition_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4177: THEN
4178: x_okc_condition_headers_tl_rec.last_update_date := l_okc_condition_headers_tl_rec.last_update_date;
4179: END IF;
4180: IF (x_okc_condition_headers_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 4178: x_okc_condition_headers_tl_rec.last_update_date := l_okc_condition_headers_tl_rec.last_update_date;

4174: x_okc_condition_headers_tl_rec.last_updated_by := l_okc_condition_headers_tl_rec.last_updated_by;
4175: END IF;
4176: IF (x_okc_condition_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4177: THEN
4178: x_okc_condition_headers_tl_rec.last_update_date := l_okc_condition_headers_tl_rec.last_update_date;
4179: END IF;
4180: IF (x_okc_condition_headers_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4181: THEN
4182: x_okc_condition_headers_tl_rec.last_update_login := l_okc_condition_headers_tl_rec.last_update_login;

Line 4180: IF (x_okc_condition_headers_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

4176: IF (x_okc_condition_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
4177: THEN
4178: x_okc_condition_headers_tl_rec.last_update_date := l_okc_condition_headers_tl_rec.last_update_date;
4179: END IF;
4180: IF (x_okc_condition_headers_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4181: THEN
4182: x_okc_condition_headers_tl_rec.last_update_login := l_okc_condition_headers_tl_rec.last_update_login;
4183: END IF;
4184: RETURN(l_return_status);

Line 4182: x_okc_condition_headers_tl_rec.last_update_login := l_okc_condition_headers_tl_rec.last_update_login;

4178: x_okc_condition_headers_tl_rec.last_update_date := l_okc_condition_headers_tl_rec.last_update_date;
4179: END IF;
4180: IF (x_okc_condition_headers_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
4181: THEN
4182: x_okc_condition_headers_tl_rec.last_update_login := l_okc_condition_headers_tl_rec.last_update_login;
4183: END IF;
4184: RETURN(l_return_status);
4185: END populate_new_record;
4186: -------------------------------------------------

Line 4187: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --

4183: END IF;
4184: RETURN(l_return_status);
4185: END populate_new_record;
4186: -------------------------------------------------
4187: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --
4188: -------------------------------------------------
4189: FUNCTION Set_Attributes (
4190: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
4191: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType

Line 4190: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,

4186: -------------------------------------------------
4187: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --
4188: -------------------------------------------------
4189: FUNCTION Set_Attributes (
4190: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
4191: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
4192: ) RETURN VARCHAR2 IS
4193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4194: BEGIN

Line 4191: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType

4187: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --
4188: -------------------------------------------------
4189: FUNCTION Set_Attributes (
4190: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
4191: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
4192: ) RETURN VARCHAR2 IS
4193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4194: BEGIN
4195: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;

Line 4195: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;

4191: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
4192: ) RETURN VARCHAR2 IS
4193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4194: BEGIN
4195: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;
4196: x_okc_condition_headers_tl_rec.LANGUAGE := l_lang;
4197: x_okc_condition_headers_tl_rec.SOURCE_LANG := l_lang;
4198: RETURN(l_return_status);
4199: END Set_Attributes;

Line 4196: x_okc_condition_headers_tl_rec.LANGUAGE := l_lang;

4192: ) RETURN VARCHAR2 IS
4193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4194: BEGIN
4195: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;
4196: x_okc_condition_headers_tl_rec.LANGUAGE := l_lang;
4197: x_okc_condition_headers_tl_rec.SOURCE_LANG := l_lang;
4198: RETURN(l_return_status);
4199: END Set_Attributes;
4200: BEGIN

Line 4197: x_okc_condition_headers_tl_rec.SOURCE_LANG := l_lang;

4193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4194: BEGIN
4195: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;
4196: x_okc_condition_headers_tl_rec.LANGUAGE := l_lang;
4197: x_okc_condition_headers_tl_rec.SOURCE_LANG := l_lang;
4198: RETURN(l_return_status);
4199: END Set_Attributes;
4200: BEGIN
4201: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4212: p_okc_condition_headers_tl_rec, -- IN

4208: RAISE OKC_API.G_EXCEPTION_ERROR;
4209: END IF;
4210: --- Setting item attributes
4211: l_return_status := Set_Attributes(
4212: p_okc_condition_headers_tl_rec, -- IN
4213: l_okc_condition_headers_tl_rec); -- OUT
4214: --- If any errors happen abort API
4215: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4213: l_okc_condition_headers_tl_rec); -- OUT

4209: END IF;
4210: --- Setting item attributes
4211: l_return_status := Set_Attributes(
4212: p_okc_condition_headers_tl_rec, -- IN
4213: l_okc_condition_headers_tl_rec); -- OUT
4214: --- If any errors happen abort API
4215: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4217: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4220: l_return_status := populate_new_record(l_okc_condition_headers_tl_rec, ldefokcconditionheaderstlrec);

4216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4217: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4218: RAISE OKC_API.G_EXCEPTION_ERROR;
4219: END IF;
4220: l_return_status := populate_new_record(l_okc_condition_headers_tl_rec, ldefokcconditionheaderstlrec);
4221: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4222: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4223: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4224: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4226: UPDATE OKC_CONDITION_HEADERS_TL

4222: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4223: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4224: RAISE OKC_API.G_EXCEPTION_ERROR;
4225: END IF;
4226: UPDATE OKC_CONDITION_HEADERS_TL
4227: SET NAME = ldefokcconditionheaderstlrec.name,
4228: SOURCE_LANG = ldefokcconditionheaderstlrec.source_lang,
4229: DESCRIPTION = ldefokcconditionheaderstlrec.description,
4230: SHORT_DESCRIPTION = ldefokcconditionheaderstlrec.short_description,

Line 4241: UPDATE OKC_CONDITION_HEADERS_TL

4237: WHERE ID = ldefokcconditionheaderstlrec.id
4238: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
4239: --AND SOURCE_LANG = USERENV('LANG');
4240:
4241: UPDATE OKC_CONDITION_HEADERS_TL
4242: SET SFWT_FLAG = 'Y'
4243: WHERE ID = ldefokcconditionheaderstlrec.id
4244: AND SOURCE_LANG <> USERENV('LANG');
4245:

Line 4246: x_okc_condition_headers_tl_rec := ldefokcconditionheaderstlrec;

4242: SET SFWT_FLAG = 'Y'
4243: WHERE ID = ldefokcconditionheaderstlrec.id
4244: AND SOURCE_LANG <> USERENV('LANG');
4245:
4246: x_okc_condition_headers_tl_rec := ldefokcconditionheaderstlrec;
4247: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4248: EXCEPTION
4249: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4250: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 4297: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;

4293: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
4294: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4295: l_cnhv_rec cnhv_rec_type := p_cnhv_rec;
4296: l_def_cnhv_rec cnhv_rec_type;
4297: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
4298: LxOkcConditionHeadersTlRec OkcConditionHeadersTlRecType;
4299: l_cnh_rec cnh_rec_type;
4300: lx_cnh_rec cnh_rec_type;
4301: -------------------------------

Line 4602: migrate(l_def_cnhv_rec, l_okc_condition_headers_tl_rec);

4598:
4599: --------------------------------------
4600: -- Move VIEW record to "Child" records
4601: --------------------------------------
4602: migrate(l_def_cnhv_rec, l_okc_condition_headers_tl_rec);
4603: migrate(l_def_cnhv_rec, l_cnh_rec);
4604: --------------------------------------------
4605: -- Call the UPDATE_ROW for each child record
4606: --------------------------------------------

Line 4612: l_okc_condition_headers_tl_rec,

4608: p_init_msg_list,
4609: x_return_status,
4610: x_msg_count,
4611: x_msg_data,
4612: l_okc_condition_headers_tl_rec,
4613: LxOkcConditionHeadersTlRec
4614: );
4615: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4616: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4801: -- delete_row for:OKC_CONDITION_HEADERS_TL --

4797: '_PVT'
4798: );
4799: END delete_row;
4800: ---------------------------------------------
4801: -- delete_row for:OKC_CONDITION_HEADERS_TL --
4802: ---------------------------------------------
4803: PROCEDURE delete_row(
4804: p_init_msg_list IN VARCHAR2 ,
4805: x_return_status OUT NOCOPY VARCHAR2,

Line 4808: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType) IS

4804: p_init_msg_list IN VARCHAR2 ,
4805: x_return_status OUT NOCOPY VARCHAR2,
4806: x_msg_count OUT NOCOPY NUMBER,
4807: x_msg_data OUT NOCOPY VARCHAR2,
4808: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType) IS
4809:
4810: l_api_version CONSTANT NUMBER := 1;
4811: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
4812: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 4813: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType:= p_okc_condition_headers_tl_rec;

4809:
4810: l_api_version CONSTANT NUMBER := 1;
4811: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
4812: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4813: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType:= p_okc_condition_headers_tl_rec;
4814: l_row_notfound BOOLEAN := TRUE;
4815: -------------------------------------------------
4816: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --
4817: -------------------------------------------------

Line 4816: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --

4812: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4813: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType:= p_okc_condition_headers_tl_rec;
4814: l_row_notfound BOOLEAN := TRUE;
4815: -------------------------------------------------
4816: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --
4817: -------------------------------------------------
4818: FUNCTION Set_Attributes (
4819: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
4820: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType

Line 4819: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,

4815: -------------------------------------------------
4816: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --
4817: -------------------------------------------------
4818: FUNCTION Set_Attributes (
4819: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
4820: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
4821: ) RETURN VARCHAR2 IS
4822: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4823: BEGIN

Line 4820: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType

4816: -- Set_Attributes for:OKC_CONDITION_HEADERS_TL --
4817: -------------------------------------------------
4818: FUNCTION Set_Attributes (
4819: p_okc_condition_headers_tl_rec IN OkcConditionHeadersTlRecType,
4820: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
4821: ) RETURN VARCHAR2 IS
4822: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4823: BEGIN
4824: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;

Line 4824: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;

4820: x_okc_condition_headers_tl_rec OUT NOCOPY OkcConditionHeadersTlRecType
4821: ) RETURN VARCHAR2 IS
4822: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4823: BEGIN
4824: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;
4825: x_okc_condition_headers_tl_rec.LANGUAGE := l_lang;
4826: RETURN(l_return_status);
4827: END Set_Attributes;
4828: BEGIN

Line 4825: x_okc_condition_headers_tl_rec.LANGUAGE := l_lang;

4821: ) RETURN VARCHAR2 IS
4822: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4823: BEGIN
4824: x_okc_condition_headers_tl_rec := p_okc_condition_headers_tl_rec;
4825: x_okc_condition_headers_tl_rec.LANGUAGE := l_lang;
4826: RETURN(l_return_status);
4827: END Set_Attributes;
4828: BEGIN
4829: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4840: p_okc_condition_headers_tl_rec, -- IN

4836: RAISE OKC_API.G_EXCEPTION_ERROR;
4837: END IF;
4838: --- Setting item attributes
4839: l_return_status := Set_Attributes(
4840: p_okc_condition_headers_tl_rec, -- IN
4841: l_okc_condition_headers_tl_rec); -- OUT
4842: --- If any errors happen abort API
4843: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4841: l_okc_condition_headers_tl_rec); -- OUT

4837: END IF;
4838: --- Setting item attributes
4839: l_return_status := Set_Attributes(
4840: p_okc_condition_headers_tl_rec, -- IN
4841: l_okc_condition_headers_tl_rec); -- OUT
4842: --- If any errors happen abort API
4843: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4845: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4848: DELETE FROM OKC_CONDITION_HEADERS_TL

4844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4845: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4846: RAISE OKC_API.G_EXCEPTION_ERROR;
4847: END IF;
4848: DELETE FROM OKC_CONDITION_HEADERS_TL
4849: WHERE ID = l_okc_condition_headers_tl_rec.id;
4850:
4851: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4852: EXCEPTION

Line 4849: WHERE ID = l_okc_condition_headers_tl_rec.id;

4845: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4846: RAISE OKC_API.G_EXCEPTION_ERROR;
4847: END IF;
4848: DELETE FROM OKC_CONDITION_HEADERS_TL
4849: WHERE ID = l_okc_condition_headers_tl_rec.id;
4850:
4851: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4852: EXCEPTION
4853: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 4899: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;

4895: l_api_version CONSTANT NUMBER := 1;
4896: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
4897: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4898: l_cnhv_rec cnhv_rec_type := p_cnhv_rec;
4899: l_okc_condition_headers_tl_rec OkcConditionHeadersTlRecType;
4900: l_cnh_rec cnh_rec_type;
4901: BEGIN
4902: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
4903: G_PKG_NAME,

Line 4926: migrate(l_cnhv_rec, l_okc_condition_headers_tl_rec);

4922: END IF;*/
4923: --------------------------------------
4924: -- Move VIEW record to "Child" records
4925: --------------------------------------
4926: migrate(l_cnhv_rec, l_okc_condition_headers_tl_rec);
4927: migrate(l_cnhv_rec, l_cnh_rec);
4928: --------------------------------------------
4929: -- Call the DELETE_ROW for each child record
4930: --------------------------------------------

Line 4936: l_okc_condition_headers_tl_rec

4932: p_init_msg_list,
4933: x_return_status,
4934: x_msg_count,
4935: x_msg_data,
4936: l_okc_condition_headers_tl_rec
4937: );
4938: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4939: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4940: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5255: INSERT INTO OKC_CONDITION_HEADERS_TL(

5251: );
5252:
5253: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
5254: FORALL i in 1..l_tabsize
5255: INSERT INTO OKC_CONDITION_HEADERS_TL(
5256: id,
5257: language,
5258: source_lang,
5259: sfwt_flag,

Line 5410: INSERT INTO okc_condition_headers_tlh

5406: ------------------------------
5407: -- Versioning TL Table
5408: ------------------------------
5409:
5410: INSERT INTO okc_condition_headers_tlh
5411: (
5412: major_version,
5413: id,
5414: language,

Line 5442: FROM okc_condition_headers_tl

5438: last_updated_by,
5439: last_update_date,
5440: last_update_login,
5441: name
5442: FROM okc_condition_headers_tl
5443: WHERE id in ( select id from okc_condition_headers_b
5444: where dnz_chr_id = p_chr_id );
5445:
5446: RETURN l_return_status;

Line 5475: INSERT INTO okc_condition_headers_tl

5471:
5472: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
5473:
5474: BEGIN
5475: INSERT INTO okc_condition_headers_tl
5476: (
5477: id,
5478: language,
5479: source_lang,

Line 5505: FROM okc_condition_headers_tlh

5501: last_updated_by,
5502: last_update_date,
5503: last_update_login,
5504: name
5505: FROM okc_condition_headers_tlh
5506: WHERE id in (SELECT id
5507: FROM okc_condition_headers_bh
5508: WHERE dnz_chr_id = p_chr_id)
5509: AND major_version = p_major_version;