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_CLE_PVT dependencies on OKC_K_LINES_TL

Line 2799: DELETE FROM OKC_K_LINES_TL T

2795: /* as a quick workaround to fix the time-consuming table handler issue */
2796: /* Eventually we'll need to turn them into a separate fix_language procedure */
2797: /*
2798:
2799: DELETE FROM OKC_K_LINES_TL T
2800: WHERE NOT EXISTS (
2801: SELECT NULL
2802: FROM OKC_K_LINES_B B
2803: WHERE B.ID = T.ID

Line 2806: UPDATE OKC_K_LINES_TL T SET (

2802: FROM OKC_K_LINES_B B
2803: WHERE B.ID = T.ID
2804: );
2805:
2806: UPDATE OKC_K_LINES_TL T SET (
2807: NAME,
2808: COMMENTS,
2809: ITEM_DESCRIPTION,
2810: OKE_BOE_DESCRIPTION,

Line 2819: FROM OKC_K_LINES_TL B

2815: B.ITEM_DESCRIPTION,
2816: B.OKE_BOE_DESCRIPTION,
2817: B.COGNOMEN,
2818: B.BLOCK23TEXT
2819: FROM OKC_K_LINES_TL B
2820: WHERE B.ID = T.ID
2821: AND B.LANGUAGE = T.SOURCE_LANG)
2822: WHERE (
2823: T.ID,

Line 2828: FROM OKC_K_LINES_TL SUBB, OKC_K_LINES_TL SUBT

2824: T.LANGUAGE)
2825: IN (SELECT
2826: SUBT.ID,
2827: SUBT.LANGUAGE
2828: FROM OKC_K_LINES_TL SUBB, OKC_K_LINES_TL SUBT
2829: WHERE SUBB.ID = SUBT.ID
2830: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
2831: AND (SUBB.NAME <> SUBT.NAME
2832: OR SUBB.COMMENTS <> SUBT.COMMENTS

Line 2852: INSERT /+ append parallel(tt) / INTO OKC_K_LINES_TL tt(

2848: OR (SUBB.BLOCK23TEXT IS NOT NULL AND SUBT.BLOCK23TEXT IS NULL)
2849: ));
2850: */
2851: /* Modifying Insert as per performance guidelines given in bug 3723874 */
2852: INSERT /*+ append parallel(tt) */ INTO OKC_K_LINES_TL tt(
2853: ID,
2854: LANGUAGE,
2855: SOURCE_LANG,
2856: SFWT_FLAG,

Line 2885: FROM OKC_K_LINES_TL B, FND_LANGUAGES L

2881: B.CREATION_DATE,
2882: B.LAST_UPDATED_BY,
2883: B.LAST_UPDATE_DATE,
2884: B.LAST_UPDATE_LOGIN
2885: FROM OKC_K_LINES_TL B, FND_LANGUAGES L
2886: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2887: AND B.LANGUAGE = USERENV('LANG')
2888: ) v , OKC_K_LINES_TL t
2889: WHERE t.ID(+) = v.ID

Line 2888: ) v , OKC_K_LINES_TL t

2884: B.LAST_UPDATE_LOGIN
2885: FROM OKC_K_LINES_TL B, FND_LANGUAGES L
2886: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2887: AND B.LANGUAGE = USERENV('LANG')
2888: ) v , OKC_K_LINES_TL t
2889: WHERE t.ID(+) = v.ID
2890: AND t.LANGUAGE(+) = v.LANGUAGE_CODE
2891: AND t.id IS NULL;
2892:

Line 2895: DELETE FROM OKC_K_LINES_TLH T

2891: AND t.id IS NULL;
2892:
2893: /* Commenting delete and update for bug 3723874 */
2894: /*
2895: DELETE FROM OKC_K_LINES_TLH T
2896: WHERE NOT EXISTS (
2897: SELECT NULL
2898: FROM OKC_K_LINES_BH B
2899: WHERE B.ID = T.ID

Line 2903: UPDATE OKC_K_LINES_TLH T SET (

2899: WHERE B.ID = T.ID
2900: AND T.MAJOR_VERSION = B.MAJOR_VERSION
2901: );
2902:
2903: UPDATE OKC_K_LINES_TLH T SET (
2904: NAME,
2905: COMMENTS,
2906: ITEM_DESCRIPTION,
2907: OKE_BOE_DESCRIPTION,

Line 2916: FROM OKC_K_LINES_TLH B

2912: B.ITEM_DESCRIPTION,
2913: B.OKE_BOE_DESCRIPTION,
2914: B.COGNOMEN,
2915: B.BLOCK23TEXT
2916: FROM OKC_K_LINES_TLH B
2917: WHERE B.ID = T.ID
2918: AND B.MAJOR_VERSION = T.MAJOR_VERSION
2919: AND B.LANGUAGE = T.SOURCE_LANG)
2920: WHERE (

Line 2928: FROM OKC_K_LINES_TLH SUBB, OKC_K_LINES_TLH SUBT

2924: IN (SELECT
2925: SUBT.ID,
2926: SUBT.MAJOR_VERSION,
2927: SUBT.LANGUAGE
2928: FROM OKC_K_LINES_TLH SUBB, OKC_K_LINES_TLH SUBT
2929: WHERE SUBB.ID = SUBT.ID
2930: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
2931: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
2932: AND (SUBB.NAME <> SUBT.NAME

Line 2953: INSERT /+ append parallel(tt) / INTO OKC_K_LINES_TLH tt (

2949: OR (SUBB.BLOCK23TEXT IS NOT NULL AND SUBT.BLOCK23TEXT IS NULL)
2950: ));
2951: */
2952: /* Modifying Insert as per performance guidelines given in bug 3723874 */
2953: INSERT /*+ append parallel(tt) */ INTO OKC_K_LINES_TLH tt (
2954: ID,
2955: LANGUAGE,
2956: MAJOR_VERSION,
2957: SOURCE_LANG,

Line 2989: FROM OKC_K_LINES_TLH B, FND_LANGUAGES L

2985: B.CREATION_DATE,
2986: B.LAST_UPDATED_BY,
2987: B.LAST_UPDATE_DATE,
2988: B.LAST_UPDATE_LOGIN
2989: FROM OKC_K_LINES_TLH B, FND_LANGUAGES L
2990: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2991: AND B.LANGUAGE = USERENV('LANG')
2992: ) v , OKC_K_LINES_TLH T
2993: WHERE T.ID(+) = v.ID

Line 2992: ) v , OKC_K_LINES_TLH T

2988: B.LAST_UPDATE_LOGIN
2989: FROM OKC_K_LINES_TLH B, FND_LANGUAGES L
2990: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2991: AND B.LANGUAGE = USERENV('LANG')
2992: ) v , OKC_K_LINES_TLH T
2993: WHERE T.ID(+) = v.ID
2994: AND T.LANGUAGE(+) = v.LANGUAGE_CODE
2995: AND T.MAJOR_VERSION(+) = v.MAJOR_VERSION
2996: AND t.id IS NULL;

Line 3244: -- FUNCTION get_rec for: OKC_K_LINES_TL

3240: RETURN(get_rec(p_cle_rec, l_row_notfound));
3241:
3242: END get_rec;
3243: ---------------------------------------------------------------------------
3244: -- FUNCTION get_rec for: OKC_K_LINES_TL
3245: ---------------------------------------------------------------------------
3246: FUNCTION get_rec (
3247: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
3248: x_no_data_found OUT NOCOPY BOOLEAN

Line 3247: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,

3243: ---------------------------------------------------------------------------
3244: -- FUNCTION get_rec for: OKC_K_LINES_TL
3245: ---------------------------------------------------------------------------
3246: FUNCTION get_rec (
3247: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
3248: x_no_data_found OUT NOCOPY BOOLEAN
3249: ) RETURN okc_k_lines_tl_rec_type IS
3250: CURSOR cle_pktl_csr (p_id IN NUMBER,
3251: p_language IN VARCHAR2) IS

Line 3249: ) RETURN okc_k_lines_tl_rec_type IS

3245: ---------------------------------------------------------------------------
3246: FUNCTION get_rec (
3247: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
3248: x_no_data_found OUT NOCOPY BOOLEAN
3249: ) RETURN okc_k_lines_tl_rec_type IS
3250: CURSOR cle_pktl_csr (p_id IN NUMBER,
3251: p_language IN VARCHAR2) IS
3252: SELECT
3253: ID,

Line 3268: FROM Okc_K_Lines_Tl

3264: CREATION_DATE,
3265: LAST_UPDATED_BY,
3266: LAST_UPDATE_DATE,
3267: LAST_UPDATE_LOGIN
3268: FROM Okc_K_Lines_Tl
3269: WHERE okc_k_lines_tl.id = p_id
3270: AND okc_k_lines_tl.language = p_language;
3271: l_cle_pktl cle_pktl_csr%ROWTYPE;
3272: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

Line 3269: WHERE okc_k_lines_tl.id = p_id

3265: LAST_UPDATED_BY,
3266: LAST_UPDATE_DATE,
3267: LAST_UPDATE_LOGIN
3268: FROM Okc_K_Lines_Tl
3269: WHERE okc_k_lines_tl.id = p_id
3270: AND okc_k_lines_tl.language = p_language;
3271: l_cle_pktl cle_pktl_csr%ROWTYPE;
3272: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
3273: BEGIN

Line 3270: AND okc_k_lines_tl.language = p_language;

3266: LAST_UPDATE_DATE,
3267: LAST_UPDATE_LOGIN
3268: FROM Okc_K_Lines_Tl
3269: WHERE okc_k_lines_tl.id = p_id
3270: AND okc_k_lines_tl.language = p_language;
3271: l_cle_pktl cle_pktl_csr%ROWTYPE;
3272: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
3273: BEGIN
3274:

Line 3272: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

3268: FROM Okc_K_Lines_Tl
3269: WHERE okc_k_lines_tl.id = p_id
3270: AND okc_k_lines_tl.language = p_language;
3271: l_cle_pktl cle_pktl_csr%ROWTYPE;
3272: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
3273: BEGIN
3274:
3275: IF (l_debug = 'Y') THEN
3276: okc_debug.Set_Indentation('OKC_CLE_PVT');

Line 3282: OPEN cle_pktl_csr (p_okc_k_lines_tl_rec.id,

3278: END IF;
3279:
3280: x_no_data_found := TRUE;
3281: -- Get current database values
3282: OPEN cle_pktl_csr (p_okc_k_lines_tl_rec.id,
3283: p_okc_k_lines_tl_rec.language);
3284: FETCH cle_pktl_csr INTO
3285: l_okc_k_lines_tl_rec.ID,
3286: l_okc_k_lines_tl_rec.LANGUAGE,

Line 3283: p_okc_k_lines_tl_rec.language);

3279:
3280: x_no_data_found := TRUE;
3281: -- Get current database values
3282: OPEN cle_pktl_csr (p_okc_k_lines_tl_rec.id,
3283: p_okc_k_lines_tl_rec.language);
3284: FETCH cle_pktl_csr INTO
3285: l_okc_k_lines_tl_rec.ID,
3286: l_okc_k_lines_tl_rec.LANGUAGE,
3287: l_okc_k_lines_tl_rec.SOURCE_LANG,

Line 3285: l_okc_k_lines_tl_rec.ID,

3281: -- Get current database values
3282: OPEN cle_pktl_csr (p_okc_k_lines_tl_rec.id,
3283: p_okc_k_lines_tl_rec.language);
3284: FETCH cle_pktl_csr INTO
3285: l_okc_k_lines_tl_rec.ID,
3286: l_okc_k_lines_tl_rec.LANGUAGE,
3287: l_okc_k_lines_tl_rec.SOURCE_LANG,
3288: l_okc_k_lines_tl_rec.SFWT_FLAG,
3289: l_okc_k_lines_tl_rec.NAME,

Line 3286: l_okc_k_lines_tl_rec.LANGUAGE,

3282: OPEN cle_pktl_csr (p_okc_k_lines_tl_rec.id,
3283: p_okc_k_lines_tl_rec.language);
3284: FETCH cle_pktl_csr INTO
3285: l_okc_k_lines_tl_rec.ID,
3286: l_okc_k_lines_tl_rec.LANGUAGE,
3287: l_okc_k_lines_tl_rec.SOURCE_LANG,
3288: l_okc_k_lines_tl_rec.SFWT_FLAG,
3289: l_okc_k_lines_tl_rec.NAME,
3290: l_okc_k_lines_tl_rec.COMMENTS,

Line 3287: l_okc_k_lines_tl_rec.SOURCE_LANG,

3283: p_okc_k_lines_tl_rec.language);
3284: FETCH cle_pktl_csr INTO
3285: l_okc_k_lines_tl_rec.ID,
3286: l_okc_k_lines_tl_rec.LANGUAGE,
3287: l_okc_k_lines_tl_rec.SOURCE_LANG,
3288: l_okc_k_lines_tl_rec.SFWT_FLAG,
3289: l_okc_k_lines_tl_rec.NAME,
3290: l_okc_k_lines_tl_rec.COMMENTS,
3291: l_okc_k_lines_tl_rec.ITEM_DESCRIPTION,

Line 3288: l_okc_k_lines_tl_rec.SFWT_FLAG,

3284: FETCH cle_pktl_csr INTO
3285: l_okc_k_lines_tl_rec.ID,
3286: l_okc_k_lines_tl_rec.LANGUAGE,
3287: l_okc_k_lines_tl_rec.SOURCE_LANG,
3288: l_okc_k_lines_tl_rec.SFWT_FLAG,
3289: l_okc_k_lines_tl_rec.NAME,
3290: l_okc_k_lines_tl_rec.COMMENTS,
3291: l_okc_k_lines_tl_rec.ITEM_DESCRIPTION,
3292: l_okc_k_lines_tl_rec.OKE_BOE_DESCRIPTION,

Line 3289: l_okc_k_lines_tl_rec.NAME,

3285: l_okc_k_lines_tl_rec.ID,
3286: l_okc_k_lines_tl_rec.LANGUAGE,
3287: l_okc_k_lines_tl_rec.SOURCE_LANG,
3288: l_okc_k_lines_tl_rec.SFWT_FLAG,
3289: l_okc_k_lines_tl_rec.NAME,
3290: l_okc_k_lines_tl_rec.COMMENTS,
3291: l_okc_k_lines_tl_rec.ITEM_DESCRIPTION,
3292: l_okc_k_lines_tl_rec.OKE_BOE_DESCRIPTION,
3293: l_okc_k_lines_tl_rec.COGNOMEN,

Line 3290: l_okc_k_lines_tl_rec.COMMENTS,

3286: l_okc_k_lines_tl_rec.LANGUAGE,
3287: l_okc_k_lines_tl_rec.SOURCE_LANG,
3288: l_okc_k_lines_tl_rec.SFWT_FLAG,
3289: l_okc_k_lines_tl_rec.NAME,
3290: l_okc_k_lines_tl_rec.COMMENTS,
3291: l_okc_k_lines_tl_rec.ITEM_DESCRIPTION,
3292: l_okc_k_lines_tl_rec.OKE_BOE_DESCRIPTION,
3293: l_okc_k_lines_tl_rec.COGNOMEN,
3294: l_okc_k_lines_tl_rec.BLOCK23TEXT,

Line 3291: l_okc_k_lines_tl_rec.ITEM_DESCRIPTION,

3287: l_okc_k_lines_tl_rec.SOURCE_LANG,
3288: l_okc_k_lines_tl_rec.SFWT_FLAG,
3289: l_okc_k_lines_tl_rec.NAME,
3290: l_okc_k_lines_tl_rec.COMMENTS,
3291: l_okc_k_lines_tl_rec.ITEM_DESCRIPTION,
3292: l_okc_k_lines_tl_rec.OKE_BOE_DESCRIPTION,
3293: l_okc_k_lines_tl_rec.COGNOMEN,
3294: l_okc_k_lines_tl_rec.BLOCK23TEXT,
3295: l_okc_k_lines_tl_rec.CREATED_BY,

Line 3292: l_okc_k_lines_tl_rec.OKE_BOE_DESCRIPTION,

3288: l_okc_k_lines_tl_rec.SFWT_FLAG,
3289: l_okc_k_lines_tl_rec.NAME,
3290: l_okc_k_lines_tl_rec.COMMENTS,
3291: l_okc_k_lines_tl_rec.ITEM_DESCRIPTION,
3292: l_okc_k_lines_tl_rec.OKE_BOE_DESCRIPTION,
3293: l_okc_k_lines_tl_rec.COGNOMEN,
3294: l_okc_k_lines_tl_rec.BLOCK23TEXT,
3295: l_okc_k_lines_tl_rec.CREATED_BY,
3296: l_okc_k_lines_tl_rec.CREATION_DATE,

Line 3293: l_okc_k_lines_tl_rec.COGNOMEN,

3289: l_okc_k_lines_tl_rec.NAME,
3290: l_okc_k_lines_tl_rec.COMMENTS,
3291: l_okc_k_lines_tl_rec.ITEM_DESCRIPTION,
3292: l_okc_k_lines_tl_rec.OKE_BOE_DESCRIPTION,
3293: l_okc_k_lines_tl_rec.COGNOMEN,
3294: l_okc_k_lines_tl_rec.BLOCK23TEXT,
3295: l_okc_k_lines_tl_rec.CREATED_BY,
3296: l_okc_k_lines_tl_rec.CREATION_DATE,
3297: l_okc_k_lines_tl_rec.LAST_UPDATED_BY,

Line 3294: l_okc_k_lines_tl_rec.BLOCK23TEXT,

3290: l_okc_k_lines_tl_rec.COMMENTS,
3291: l_okc_k_lines_tl_rec.ITEM_DESCRIPTION,
3292: l_okc_k_lines_tl_rec.OKE_BOE_DESCRIPTION,
3293: l_okc_k_lines_tl_rec.COGNOMEN,
3294: l_okc_k_lines_tl_rec.BLOCK23TEXT,
3295: l_okc_k_lines_tl_rec.CREATED_BY,
3296: l_okc_k_lines_tl_rec.CREATION_DATE,
3297: l_okc_k_lines_tl_rec.LAST_UPDATED_BY,
3298: l_okc_k_lines_tl_rec.LAST_UPDATE_DATE,

Line 3295: l_okc_k_lines_tl_rec.CREATED_BY,

3291: l_okc_k_lines_tl_rec.ITEM_DESCRIPTION,
3292: l_okc_k_lines_tl_rec.OKE_BOE_DESCRIPTION,
3293: l_okc_k_lines_tl_rec.COGNOMEN,
3294: l_okc_k_lines_tl_rec.BLOCK23TEXT,
3295: l_okc_k_lines_tl_rec.CREATED_BY,
3296: l_okc_k_lines_tl_rec.CREATION_DATE,
3297: l_okc_k_lines_tl_rec.LAST_UPDATED_BY,
3298: l_okc_k_lines_tl_rec.LAST_UPDATE_DATE,
3299: l_okc_k_lines_tl_rec.LAST_UPDATE_LOGIN;

Line 3296: l_okc_k_lines_tl_rec.CREATION_DATE,

3292: l_okc_k_lines_tl_rec.OKE_BOE_DESCRIPTION,
3293: l_okc_k_lines_tl_rec.COGNOMEN,
3294: l_okc_k_lines_tl_rec.BLOCK23TEXT,
3295: l_okc_k_lines_tl_rec.CREATED_BY,
3296: l_okc_k_lines_tl_rec.CREATION_DATE,
3297: l_okc_k_lines_tl_rec.LAST_UPDATED_BY,
3298: l_okc_k_lines_tl_rec.LAST_UPDATE_DATE,
3299: l_okc_k_lines_tl_rec.LAST_UPDATE_LOGIN;
3300: x_no_data_found := cle_pktl_csr%NOTFOUND;

Line 3297: l_okc_k_lines_tl_rec.LAST_UPDATED_BY,

3293: l_okc_k_lines_tl_rec.COGNOMEN,
3294: l_okc_k_lines_tl_rec.BLOCK23TEXT,
3295: l_okc_k_lines_tl_rec.CREATED_BY,
3296: l_okc_k_lines_tl_rec.CREATION_DATE,
3297: l_okc_k_lines_tl_rec.LAST_UPDATED_BY,
3298: l_okc_k_lines_tl_rec.LAST_UPDATE_DATE,
3299: l_okc_k_lines_tl_rec.LAST_UPDATE_LOGIN;
3300: x_no_data_found := cle_pktl_csr%NOTFOUND;
3301: CLOSE cle_pktl_csr;

Line 3298: l_okc_k_lines_tl_rec.LAST_UPDATE_DATE,

3294: l_okc_k_lines_tl_rec.BLOCK23TEXT,
3295: l_okc_k_lines_tl_rec.CREATED_BY,
3296: l_okc_k_lines_tl_rec.CREATION_DATE,
3297: l_okc_k_lines_tl_rec.LAST_UPDATED_BY,
3298: l_okc_k_lines_tl_rec.LAST_UPDATE_DATE,
3299: l_okc_k_lines_tl_rec.LAST_UPDATE_LOGIN;
3300: x_no_data_found := cle_pktl_csr%NOTFOUND;
3301: CLOSE cle_pktl_csr;
3302:

Line 3299: l_okc_k_lines_tl_rec.LAST_UPDATE_LOGIN;

3295: l_okc_k_lines_tl_rec.CREATED_BY,
3296: l_okc_k_lines_tl_rec.CREATION_DATE,
3297: l_okc_k_lines_tl_rec.LAST_UPDATED_BY,
3298: l_okc_k_lines_tl_rec.LAST_UPDATE_DATE,
3299: l_okc_k_lines_tl_rec.LAST_UPDATE_LOGIN;
3300: x_no_data_found := cle_pktl_csr%NOTFOUND;
3301: CLOSE cle_pktl_csr;
3302:
3303: IF (l_debug = 'Y') THEN

Line 3308: RETURN(l_okc_k_lines_tl_rec);

3304: okc_debug.log('11050: Leaving Fn get_rec ', 2);
3305: okc_debug.Reset_Indentation;
3306: END IF;
3307:
3308: RETURN(l_okc_k_lines_tl_rec);
3309:
3310: END get_rec;
3311:
3312: FUNCTION get_rec (

Line 3313: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type

3309:
3310: END get_rec;
3311:
3312: FUNCTION get_rec (
3313: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type
3314: ) RETURN okc_k_lines_tl_rec_type IS
3315: l_row_notfound BOOLEAN := TRUE;
3316: BEGIN
3317:

Line 3314: ) RETURN okc_k_lines_tl_rec_type IS

3310: END get_rec;
3311:
3312: FUNCTION get_rec (
3313: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type
3314: ) RETURN okc_k_lines_tl_rec_type IS
3315: l_row_notfound BOOLEAN := TRUE;
3316: BEGIN
3317:
3318: RETURN(get_rec(p_okc_k_lines_tl_rec, l_row_notfound));

Line 3318: RETURN(get_rec(p_okc_k_lines_tl_rec, l_row_notfound));

3314: ) RETURN okc_k_lines_tl_rec_type IS
3315: l_row_notfound BOOLEAN := TRUE;
3316: BEGIN
3317:
3318: RETURN(get_rec(p_okc_k_lines_tl_rec, l_row_notfound));
3319:
3320: END get_rec;
3321: ---------------------------------------------------------------------------
3322: -- FUNCTION get_rec for: OKC_K_LINES_V

Line 4607: p_to IN OUT NOCOPY okc_k_lines_tl_rec_type

4603:
4604:
4605: PROCEDURE migrate (
4606: p_from IN clev_rec_type,
4607: p_to IN OUT NOCOPY okc_k_lines_tl_rec_type
4608: ) IS
4609: BEGIN
4610:
4611: p_to.id := p_from.id;

Line 4629: p_from IN okc_k_lines_tl_rec_type,

4625: END migrate;
4626:
4627:
4628: PROCEDURE migrate (
4629: p_from IN okc_k_lines_tl_rec_type,
4630: p_to IN OUT NOCOPY clev_rec_type
4631: ) IS
4632: BEGIN
4633:

Line 4669: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

4665: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
4666: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4667: l_clev_rec clev_rec_type := p_clev_rec;
4668: l_cle_rec cle_rec_type;
4669: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
4670: BEGIN
4671:
4672: IF (l_debug = 'Y') THEN
4673: okc_debug.Set_Indentation('OKC_CLE_PVT');

Line 5201: -- insert_row for:OKC_K_LINES_TL --

5197: );
5198:
5199: END insert_row;
5200: -----------------------------------
5201: -- insert_row for:OKC_K_LINES_TL --
5202: -----------------------------------
5203: PROCEDURE insert_row(
5204: p_init_msg_list IN VARCHAR2,
5205: x_return_status OUT NOCOPY VARCHAR2,

Line 5208: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,

5204: p_init_msg_list IN VARCHAR2,
5205: x_return_status OUT NOCOPY VARCHAR2,
5206: x_msg_count OUT NOCOPY NUMBER,
5207: x_msg_data OUT NOCOPY VARCHAR2,
5208: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
5209: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type) IS
5210:
5211: l_api_version CONSTANT NUMBER := 1;
5212: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 5209: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type) IS

5205: x_return_status OUT NOCOPY VARCHAR2,
5206: x_msg_count OUT NOCOPY NUMBER,
5207: x_msg_data OUT NOCOPY VARCHAR2,
5208: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
5209: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type) IS
5210:
5211: l_api_version CONSTANT NUMBER := 1;
5212: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
5213: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 5214: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type := p_okc_k_lines_tl_rec;

5210:
5211: l_api_version CONSTANT NUMBER := 1;
5212: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
5213: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5214: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type := p_okc_k_lines_tl_rec;
5215: l_def_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
5216: CURSOR get_languages IS
5217: SELECT *
5218: FROM FND_LANGUAGES

Line 5215: l_def_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

5211: l_api_version CONSTANT NUMBER := 1;
5212: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
5213: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5214: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type := p_okc_k_lines_tl_rec;
5215: l_def_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
5216: CURSOR get_languages IS
5217: SELECT *
5218: FROM FND_LANGUAGES
5219: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 5221: -- Set_Attributes for:OKC_K_LINES_TL --

5217: SELECT *
5218: FROM FND_LANGUAGES
5219: WHERE INSTALLED_FLAG IN ('I', 'B');
5220: ---------------------------------------
5221: -- Set_Attributes for:OKC_K_LINES_TL --
5222: ---------------------------------------
5223: FUNCTION Set_Attributes (
5224: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
5225: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type

Line 5224: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,

5220: ---------------------------------------
5221: -- Set_Attributes for:OKC_K_LINES_TL --
5222: ---------------------------------------
5223: FUNCTION Set_Attributes (
5224: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
5225: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type
5226: ) RETURN VARCHAR2 IS
5227: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5228: BEGIN

Line 5225: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type

5221: -- Set_Attributes for:OKC_K_LINES_TL --
5222: ---------------------------------------
5223: FUNCTION Set_Attributes (
5224: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
5225: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type
5226: ) RETURN VARCHAR2 IS
5227: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5228: BEGIN
5229:

Line 5230: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;

5226: ) RETURN VARCHAR2 IS
5227: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5228: BEGIN
5229:
5230: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
5231: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5232: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5233:
5234: RETURN(l_return_status);

Line 5231: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

5227: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5228: BEGIN
5229:
5230: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
5231: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5232: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5233:
5234: RETURN(l_return_status);
5235:

Line 5232: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

5228: BEGIN
5229:
5230: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
5231: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5232: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5233:
5234: RETURN(l_return_status);
5235:
5236: END Set_Attributes;

Line 5255: p_okc_k_lines_tl_rec, -- IN

5251: RAISE OKC_API.G_EXCEPTION_ERROR;
5252: END IF;
5253: --- Setting item attributes
5254: l_return_status := Set_Attributes(
5255: p_okc_k_lines_tl_rec, -- IN
5256: l_okc_k_lines_tl_rec); -- OUT
5257: --- If any errors happen abort API
5258: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5259: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5256: l_okc_k_lines_tl_rec); -- OUT

5252: END IF;
5253: --- Setting item attributes
5254: l_return_status := Set_Attributes(
5255: p_okc_k_lines_tl_rec, -- IN
5256: l_okc_k_lines_tl_rec); -- OUT
5257: --- If any errors happen abort API
5258: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5259: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5260: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5264: l_okc_k_lines_tl_rec.language := l_lang_rec.language_code;

5260: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5261: RAISE OKC_API.G_EXCEPTION_ERROR;
5262: END IF;
5263: FOR l_lang_rec IN get_languages LOOP
5264: l_okc_k_lines_tl_rec.language := l_lang_rec.language_code;
5265: INSERT INTO OKC_K_LINES_TL(
5266: id,
5267: language,
5268: source_lang,

Line 5265: INSERT INTO OKC_K_LINES_TL(

5261: RAISE OKC_API.G_EXCEPTION_ERROR;
5262: END IF;
5263: FOR l_lang_rec IN get_languages LOOP
5264: l_okc_k_lines_tl_rec.language := l_lang_rec.language_code;
5265: INSERT INTO OKC_K_LINES_TL(
5266: id,
5267: language,
5268: source_lang,
5269: sfwt_flag,

Line 5282: l_okc_k_lines_tl_rec.id,

5278: last_updated_by,
5279: last_update_date,
5280: last_update_login)
5281: VALUES (
5282: l_okc_k_lines_tl_rec.id,
5283: l_okc_k_lines_tl_rec.language,
5284: l_okc_k_lines_tl_rec.source_lang,
5285: l_okc_k_lines_tl_rec.sfwt_flag,
5286: l_okc_k_lines_tl_rec.name,

Line 5283: l_okc_k_lines_tl_rec.language,

5279: last_update_date,
5280: last_update_login)
5281: VALUES (
5282: l_okc_k_lines_tl_rec.id,
5283: l_okc_k_lines_tl_rec.language,
5284: l_okc_k_lines_tl_rec.source_lang,
5285: l_okc_k_lines_tl_rec.sfwt_flag,
5286: l_okc_k_lines_tl_rec.name,
5287: l_okc_k_lines_tl_rec.comments,

Line 5284: l_okc_k_lines_tl_rec.source_lang,

5280: last_update_login)
5281: VALUES (
5282: l_okc_k_lines_tl_rec.id,
5283: l_okc_k_lines_tl_rec.language,
5284: l_okc_k_lines_tl_rec.source_lang,
5285: l_okc_k_lines_tl_rec.sfwt_flag,
5286: l_okc_k_lines_tl_rec.name,
5287: l_okc_k_lines_tl_rec.comments,
5288: l_okc_k_lines_tl_rec.item_description,

Line 5285: l_okc_k_lines_tl_rec.sfwt_flag,

5281: VALUES (
5282: l_okc_k_lines_tl_rec.id,
5283: l_okc_k_lines_tl_rec.language,
5284: l_okc_k_lines_tl_rec.source_lang,
5285: l_okc_k_lines_tl_rec.sfwt_flag,
5286: l_okc_k_lines_tl_rec.name,
5287: l_okc_k_lines_tl_rec.comments,
5288: l_okc_k_lines_tl_rec.item_description,
5289: l_okc_k_lines_tl_rec.oke_boe_description,

Line 5286: l_okc_k_lines_tl_rec.name,

5282: l_okc_k_lines_tl_rec.id,
5283: l_okc_k_lines_tl_rec.language,
5284: l_okc_k_lines_tl_rec.source_lang,
5285: l_okc_k_lines_tl_rec.sfwt_flag,
5286: l_okc_k_lines_tl_rec.name,
5287: l_okc_k_lines_tl_rec.comments,
5288: l_okc_k_lines_tl_rec.item_description,
5289: l_okc_k_lines_tl_rec.oke_boe_description,
5290: l_okc_k_lines_tl_rec.cognomen,

Line 5287: l_okc_k_lines_tl_rec.comments,

5283: l_okc_k_lines_tl_rec.language,
5284: l_okc_k_lines_tl_rec.source_lang,
5285: l_okc_k_lines_tl_rec.sfwt_flag,
5286: l_okc_k_lines_tl_rec.name,
5287: l_okc_k_lines_tl_rec.comments,
5288: l_okc_k_lines_tl_rec.item_description,
5289: l_okc_k_lines_tl_rec.oke_boe_description,
5290: l_okc_k_lines_tl_rec.cognomen,
5291: l_okc_k_lines_tl_rec.block23text,

Line 5288: l_okc_k_lines_tl_rec.item_description,

5284: l_okc_k_lines_tl_rec.source_lang,
5285: l_okc_k_lines_tl_rec.sfwt_flag,
5286: l_okc_k_lines_tl_rec.name,
5287: l_okc_k_lines_tl_rec.comments,
5288: l_okc_k_lines_tl_rec.item_description,
5289: l_okc_k_lines_tl_rec.oke_boe_description,
5290: l_okc_k_lines_tl_rec.cognomen,
5291: l_okc_k_lines_tl_rec.block23text,
5292: l_okc_k_lines_tl_rec.created_by,

Line 5289: l_okc_k_lines_tl_rec.oke_boe_description,

5285: l_okc_k_lines_tl_rec.sfwt_flag,
5286: l_okc_k_lines_tl_rec.name,
5287: l_okc_k_lines_tl_rec.comments,
5288: l_okc_k_lines_tl_rec.item_description,
5289: l_okc_k_lines_tl_rec.oke_boe_description,
5290: l_okc_k_lines_tl_rec.cognomen,
5291: l_okc_k_lines_tl_rec.block23text,
5292: l_okc_k_lines_tl_rec.created_by,
5293: l_okc_k_lines_tl_rec.creation_date,

Line 5290: l_okc_k_lines_tl_rec.cognomen,

5286: l_okc_k_lines_tl_rec.name,
5287: l_okc_k_lines_tl_rec.comments,
5288: l_okc_k_lines_tl_rec.item_description,
5289: l_okc_k_lines_tl_rec.oke_boe_description,
5290: l_okc_k_lines_tl_rec.cognomen,
5291: l_okc_k_lines_tl_rec.block23text,
5292: l_okc_k_lines_tl_rec.created_by,
5293: l_okc_k_lines_tl_rec.creation_date,
5294: l_okc_k_lines_tl_rec.last_updated_by,

Line 5291: l_okc_k_lines_tl_rec.block23text,

5287: l_okc_k_lines_tl_rec.comments,
5288: l_okc_k_lines_tl_rec.item_description,
5289: l_okc_k_lines_tl_rec.oke_boe_description,
5290: l_okc_k_lines_tl_rec.cognomen,
5291: l_okc_k_lines_tl_rec.block23text,
5292: l_okc_k_lines_tl_rec.created_by,
5293: l_okc_k_lines_tl_rec.creation_date,
5294: l_okc_k_lines_tl_rec.last_updated_by,
5295: l_okc_k_lines_tl_rec.last_update_date,

Line 5292: l_okc_k_lines_tl_rec.created_by,

5288: l_okc_k_lines_tl_rec.item_description,
5289: l_okc_k_lines_tl_rec.oke_boe_description,
5290: l_okc_k_lines_tl_rec.cognomen,
5291: l_okc_k_lines_tl_rec.block23text,
5292: l_okc_k_lines_tl_rec.created_by,
5293: l_okc_k_lines_tl_rec.creation_date,
5294: l_okc_k_lines_tl_rec.last_updated_by,
5295: l_okc_k_lines_tl_rec.last_update_date,
5296: l_okc_k_lines_tl_rec.last_update_login);

Line 5293: l_okc_k_lines_tl_rec.creation_date,

5289: l_okc_k_lines_tl_rec.oke_boe_description,
5290: l_okc_k_lines_tl_rec.cognomen,
5291: l_okc_k_lines_tl_rec.block23text,
5292: l_okc_k_lines_tl_rec.created_by,
5293: l_okc_k_lines_tl_rec.creation_date,
5294: l_okc_k_lines_tl_rec.last_updated_by,
5295: l_okc_k_lines_tl_rec.last_update_date,
5296: l_okc_k_lines_tl_rec.last_update_login);
5297: END LOOP;

Line 5294: l_okc_k_lines_tl_rec.last_updated_by,

5290: l_okc_k_lines_tl_rec.cognomen,
5291: l_okc_k_lines_tl_rec.block23text,
5292: l_okc_k_lines_tl_rec.created_by,
5293: l_okc_k_lines_tl_rec.creation_date,
5294: l_okc_k_lines_tl_rec.last_updated_by,
5295: l_okc_k_lines_tl_rec.last_update_date,
5296: l_okc_k_lines_tl_rec.last_update_login);
5297: END LOOP;
5298: -- Set OUT values

Line 5295: l_okc_k_lines_tl_rec.last_update_date,

5291: l_okc_k_lines_tl_rec.block23text,
5292: l_okc_k_lines_tl_rec.created_by,
5293: l_okc_k_lines_tl_rec.creation_date,
5294: l_okc_k_lines_tl_rec.last_updated_by,
5295: l_okc_k_lines_tl_rec.last_update_date,
5296: l_okc_k_lines_tl_rec.last_update_login);
5297: END LOOP;
5298: -- Set OUT values
5299: x_okc_k_lines_tl_rec := l_okc_k_lines_tl_rec;

Line 5296: l_okc_k_lines_tl_rec.last_update_login);

5292: l_okc_k_lines_tl_rec.created_by,
5293: l_okc_k_lines_tl_rec.creation_date,
5294: l_okc_k_lines_tl_rec.last_updated_by,
5295: l_okc_k_lines_tl_rec.last_update_date,
5296: l_okc_k_lines_tl_rec.last_update_login);
5297: END LOOP;
5298: -- Set OUT values
5299: x_okc_k_lines_tl_rec := l_okc_k_lines_tl_rec;
5300: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 5299: x_okc_k_lines_tl_rec := l_okc_k_lines_tl_rec;

5295: l_okc_k_lines_tl_rec.last_update_date,
5296: l_okc_k_lines_tl_rec.last_update_login);
5297: END LOOP;
5298: -- Set OUT values
5299: x_okc_k_lines_tl_rec := l_okc_k_lines_tl_rec;
5300: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5301:
5302: IF (l_debug = 'Y') THEN
5303: okc_debug.log('14100: Exiting insert_row', 2);

Line 5377: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

5373: l_clev_rec clev_rec_type;
5374: l_def_clev_rec clev_rec_type;
5375: l_cle_rec cle_rec_type;
5376: lx_cle_rec cle_rec_type;
5377: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
5378: lx_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
5379: -------------------------------
5380: -- FUNCTION fill_who_columns --
5381: -------------------------------

Line 5378: lx_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

5374: l_def_clev_rec clev_rec_type;
5375: l_cle_rec cle_rec_type;
5376: lx_cle_rec cle_rec_type;
5377: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
5378: lx_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
5379: -------------------------------
5380: -- FUNCTION fill_who_columns --
5381: -------------------------------
5382: FUNCTION fill_who_columns (

Line 5500: migrate(l_def_clev_rec, l_okc_k_lines_tl_rec);

5496: --------------------------------------
5497: -- Move VIEW record to "Child" records
5498: --------------------------------------
5499: migrate(l_def_clev_rec, l_cle_rec);
5500: migrate(l_def_clev_rec, l_okc_k_lines_tl_rec);
5501: --------------------------------------------
5502: -- Call the INSERT_ROW for each child record
5503: --------------------------------------------
5504: insert_row(

Line 5523: l_okc_k_lines_tl_rec,

5519: p_init_msg_list,
5520: x_return_status,
5521: x_msg_count,
5522: x_msg_data,
5523: l_okc_k_lines_tl_rec,
5524: lx_okc_k_lines_tl_rec
5525: );
5526: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5524: lx_okc_k_lines_tl_rec

5520: x_return_status,
5521: x_msg_count,
5522: x_msg_data,
5523: l_okc_k_lines_tl_rec,
5524: lx_okc_k_lines_tl_rec
5525: );
5526: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5528: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5531: migrate(lx_okc_k_lines_tl_rec, l_def_clev_rec);

5527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5528: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5529: RAISE OKC_API.G_EXCEPTION_ERROR;
5530: END IF;
5531: migrate(lx_okc_k_lines_tl_rec, l_def_clev_rec);
5532: -- Set OUT values
5533: x_clev_rec := l_def_clev_rec;
5534:
5535: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 5861: -- lock_row for:OKC_K_LINES_TL --

5857: );
5858:
5859: END lock_row;
5860: ---------------------------------
5861: -- lock_row for:OKC_K_LINES_TL --
5862: ---------------------------------
5863: PROCEDURE lock_row(
5864: p_init_msg_list IN VARCHAR2,
5865: x_return_status OUT NOCOPY VARCHAR2,

Line 5868: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type) IS

5864: p_init_msg_list IN VARCHAR2,
5865: x_return_status OUT NOCOPY VARCHAR2,
5866: x_msg_count OUT NOCOPY NUMBER,
5867: x_msg_data OUT NOCOPY VARCHAR2,
5868: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type) IS
5869:
5870: E_Resource_Busy EXCEPTION;
5871: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5872: CURSOR lock_csr (p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type) IS

Line 5872: CURSOR lock_csr (p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type) IS

5868: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type) IS
5869:
5870: E_Resource_Busy EXCEPTION;
5871: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5872: CURSOR lock_csr (p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type) IS
5873: SELECT *
5874: FROM OKC_K_LINES_TL
5875: WHERE ID = p_okc_k_lines_tl_rec.id
5876: FOR UPDATE NOWAIT;

Line 5874: FROM OKC_K_LINES_TL

5870: E_Resource_Busy EXCEPTION;
5871: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5872: CURSOR lock_csr (p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type) IS
5873: SELECT *
5874: FROM OKC_K_LINES_TL
5875: WHERE ID = p_okc_k_lines_tl_rec.id
5876: FOR UPDATE NOWAIT;
5877:
5878: l_api_version CONSTANT NUMBER := 1;

Line 5875: WHERE ID = p_okc_k_lines_tl_rec.id

5871: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5872: CURSOR lock_csr (p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type) IS
5873: SELECT *
5874: FROM OKC_K_LINES_TL
5875: WHERE ID = p_okc_k_lines_tl_rec.id
5876: FOR UPDATE NOWAIT;
5877:
5878: l_api_version CONSTANT NUMBER := 1;
5879: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 5907: OPEN lock_csr(p_okc_k_lines_tl_rec);

5903: okc_debug.Set_Indentation('OKC_CLE_PVT');
5904: okc_debug.log('16600: Entered lock_row', 2);
5905: END IF;
5906:
5907: OPEN lock_csr(p_okc_k_lines_tl_rec);
5908: FETCH lock_csr INTO l_lock_var;
5909: l_row_notfound := lock_csr%NOTFOUND;
5910: CLOSE lock_csr;
5911:

Line 6009: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

6005: l_api_version CONSTANT NUMBER := 1;
6006: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
6007: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6008: l_cle_rec cle_rec_type;
6009: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
6010: BEGIN
6011:
6012: IF (l_debug = 'Y') THEN
6013: okc_debug.Set_Indentation('OKC_CLE_PVT');

Line 6033: migrate(p_clev_rec, l_okc_k_lines_tl_rec);

6029: --------------------------------------
6030: -- Move VIEW record to "Child" records
6031: --------------------------------------
6032: migrate(p_clev_rec, l_cle_rec);
6033: migrate(p_clev_rec, l_okc_k_lines_tl_rec);
6034: --------------------------------------------
6035: -- Call the LOCK_ROW for each child record
6036: --------------------------------------------
6037: lock_row(

Line 6054: l_okc_k_lines_tl_rec

6050: p_init_msg_list,
6051: x_return_status,
6052: x_msg_count,
6053: x_msg_data,
6054: l_okc_k_lines_tl_rec
6055: );
6056: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6057: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6058: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 6866: -- update_row for:OKC_K_LINES_TL --

6862: );
6863:
6864: END update_row;
6865: -----------------------------------
6866: -- update_row for:OKC_K_LINES_TL --
6867: -----------------------------------
6868: PROCEDURE update_row(
6869: p_init_msg_list IN VARCHAR2,
6870: x_return_status OUT NOCOPY VARCHAR2,

Line 6873: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,

6869: p_init_msg_list IN VARCHAR2,
6870: x_return_status OUT NOCOPY VARCHAR2,
6871: x_msg_count OUT NOCOPY NUMBER,
6872: x_msg_data OUT NOCOPY VARCHAR2,
6873: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
6874: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type) IS
6875:
6876: l_api_version CONSTANT NUMBER := 1;
6877: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 6874: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type) IS

6870: x_return_status OUT NOCOPY VARCHAR2,
6871: x_msg_count OUT NOCOPY NUMBER,
6872: x_msg_data OUT NOCOPY VARCHAR2,
6873: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
6874: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type) IS
6875:
6876: l_api_version CONSTANT NUMBER := 1;
6877: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
6878: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 6879: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type := p_okc_k_lines_tl_rec;

6875:
6876: l_api_version CONSTANT NUMBER := 1;
6877: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
6878: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6879: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type := p_okc_k_lines_tl_rec;
6880: l_def_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
6881: l_row_notfound BOOLEAN := TRUE;
6882: ----------------------------------
6883: -- FUNCTION populate_new_record --

Line 6880: l_def_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

6876: l_api_version CONSTANT NUMBER := 1;
6877: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
6878: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6879: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type := p_okc_k_lines_tl_rec;
6880: l_def_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
6881: l_row_notfound BOOLEAN := TRUE;
6882: ----------------------------------
6883: -- FUNCTION populate_new_record --
6884: ----------------------------------

Line 6886: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,

6882: ----------------------------------
6883: -- FUNCTION populate_new_record --
6884: ----------------------------------
6885: FUNCTION populate_new_record (
6886: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
6887: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type
6888: ) RETURN VARCHAR2 IS
6889: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
6890: l_row_notfound BOOLEAN := TRUE;

Line 6887: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type

6883: -- FUNCTION populate_new_record --
6884: ----------------------------------
6885: FUNCTION populate_new_record (
6886: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
6887: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type
6888: ) RETURN VARCHAR2 IS
6889: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
6890: l_row_notfound BOOLEAN := TRUE;
6891: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 6889: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

6885: FUNCTION populate_new_record (
6886: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
6887: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type
6888: ) RETURN VARCHAR2 IS
6889: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
6890: l_row_notfound BOOLEAN := TRUE;
6891: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6892: BEGIN
6893:

Line 6899: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;

6895: okc_debug.Set_Indentation('OKC_CLE_PVT');
6896: okc_debug.log('19000: Entered populate_new_record', 2);
6897: END IF;
6898:
6899: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
6900: -- Get current database values
6901: l_okc_k_lines_tl_rec := get_rec(p_okc_k_lines_tl_rec, l_row_notfound);
6902: IF (l_row_notfound) THEN
6903: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 6901: l_okc_k_lines_tl_rec := get_rec(p_okc_k_lines_tl_rec, l_row_notfound);

6897: END IF;
6898:
6899: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
6900: -- Get current database values
6901: l_okc_k_lines_tl_rec := get_rec(p_okc_k_lines_tl_rec, l_row_notfound);
6902: IF (l_row_notfound) THEN
6903: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6904: END IF;
6905: IF (x_okc_k_lines_tl_rec.id = OKC_API.G_MISS_NUM)

Line 6905: IF (x_okc_k_lines_tl_rec.id = OKC_API.G_MISS_NUM)

6901: l_okc_k_lines_tl_rec := get_rec(p_okc_k_lines_tl_rec, l_row_notfound);
6902: IF (l_row_notfound) THEN
6903: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6904: END IF;
6905: IF (x_okc_k_lines_tl_rec.id = OKC_API.G_MISS_NUM)
6906: THEN
6907: x_okc_k_lines_tl_rec.id := l_okc_k_lines_tl_rec.id;
6908: END IF;
6909: IF (x_okc_k_lines_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 6907: x_okc_k_lines_tl_rec.id := l_okc_k_lines_tl_rec.id;

6903: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6904: END IF;
6905: IF (x_okc_k_lines_tl_rec.id = OKC_API.G_MISS_NUM)
6906: THEN
6907: x_okc_k_lines_tl_rec.id := l_okc_k_lines_tl_rec.id;
6908: END IF;
6909: IF (x_okc_k_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
6910: THEN
6911: x_okc_k_lines_tl_rec.language := l_okc_k_lines_tl_rec.language;

Line 6909: IF (x_okc_k_lines_tl_rec.language = OKC_API.G_MISS_CHAR)

6905: IF (x_okc_k_lines_tl_rec.id = OKC_API.G_MISS_NUM)
6906: THEN
6907: x_okc_k_lines_tl_rec.id := l_okc_k_lines_tl_rec.id;
6908: END IF;
6909: IF (x_okc_k_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
6910: THEN
6911: x_okc_k_lines_tl_rec.language := l_okc_k_lines_tl_rec.language;
6912: END IF;
6913: IF (x_okc_k_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 6911: x_okc_k_lines_tl_rec.language := l_okc_k_lines_tl_rec.language;

6907: x_okc_k_lines_tl_rec.id := l_okc_k_lines_tl_rec.id;
6908: END IF;
6909: IF (x_okc_k_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
6910: THEN
6911: x_okc_k_lines_tl_rec.language := l_okc_k_lines_tl_rec.language;
6912: END IF;
6913: IF (x_okc_k_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6914: THEN
6915: x_okc_k_lines_tl_rec.source_lang := l_okc_k_lines_tl_rec.source_lang;

Line 6913: IF (x_okc_k_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

6909: IF (x_okc_k_lines_tl_rec.language = OKC_API.G_MISS_CHAR)
6910: THEN
6911: x_okc_k_lines_tl_rec.language := l_okc_k_lines_tl_rec.language;
6912: END IF;
6913: IF (x_okc_k_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6914: THEN
6915: x_okc_k_lines_tl_rec.source_lang := l_okc_k_lines_tl_rec.source_lang;
6916: END IF;
6917: IF (x_okc_k_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 6915: x_okc_k_lines_tl_rec.source_lang := l_okc_k_lines_tl_rec.source_lang;

6911: x_okc_k_lines_tl_rec.language := l_okc_k_lines_tl_rec.language;
6912: END IF;
6913: IF (x_okc_k_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6914: THEN
6915: x_okc_k_lines_tl_rec.source_lang := l_okc_k_lines_tl_rec.source_lang;
6916: END IF;
6917: IF (x_okc_k_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6918: THEN
6919: x_okc_k_lines_tl_rec.sfwt_flag := l_okc_k_lines_tl_rec.sfwt_flag;

Line 6917: IF (x_okc_k_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

6913: IF (x_okc_k_lines_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6914: THEN
6915: x_okc_k_lines_tl_rec.source_lang := l_okc_k_lines_tl_rec.source_lang;
6916: END IF;
6917: IF (x_okc_k_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6918: THEN
6919: x_okc_k_lines_tl_rec.sfwt_flag := l_okc_k_lines_tl_rec.sfwt_flag;
6920: END IF;
6921: IF (x_okc_k_lines_tl_rec.name = OKC_API.G_MISS_CHAR)

Line 6919: x_okc_k_lines_tl_rec.sfwt_flag := l_okc_k_lines_tl_rec.sfwt_flag;

6915: x_okc_k_lines_tl_rec.source_lang := l_okc_k_lines_tl_rec.source_lang;
6916: END IF;
6917: IF (x_okc_k_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6918: THEN
6919: x_okc_k_lines_tl_rec.sfwt_flag := l_okc_k_lines_tl_rec.sfwt_flag;
6920: END IF;
6921: IF (x_okc_k_lines_tl_rec.name = OKC_API.G_MISS_CHAR)
6922: THEN
6923: x_okc_k_lines_tl_rec.name := l_okc_k_lines_tl_rec.name;

Line 6921: IF (x_okc_k_lines_tl_rec.name = OKC_API.G_MISS_CHAR)

6917: IF (x_okc_k_lines_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6918: THEN
6919: x_okc_k_lines_tl_rec.sfwt_flag := l_okc_k_lines_tl_rec.sfwt_flag;
6920: END IF;
6921: IF (x_okc_k_lines_tl_rec.name = OKC_API.G_MISS_CHAR)
6922: THEN
6923: x_okc_k_lines_tl_rec.name := l_okc_k_lines_tl_rec.name;
6924: END IF;
6925: IF (x_okc_k_lines_tl_rec.comments = OKC_API.G_MISS_CHAR)

Line 6923: x_okc_k_lines_tl_rec.name := l_okc_k_lines_tl_rec.name;

6919: x_okc_k_lines_tl_rec.sfwt_flag := l_okc_k_lines_tl_rec.sfwt_flag;
6920: END IF;
6921: IF (x_okc_k_lines_tl_rec.name = OKC_API.G_MISS_CHAR)
6922: THEN
6923: x_okc_k_lines_tl_rec.name := l_okc_k_lines_tl_rec.name;
6924: END IF;
6925: IF (x_okc_k_lines_tl_rec.comments = OKC_API.G_MISS_CHAR)
6926: THEN
6927: x_okc_k_lines_tl_rec.comments := l_okc_k_lines_tl_rec.comments;

Line 6925: IF (x_okc_k_lines_tl_rec.comments = OKC_API.G_MISS_CHAR)

6921: IF (x_okc_k_lines_tl_rec.name = OKC_API.G_MISS_CHAR)
6922: THEN
6923: x_okc_k_lines_tl_rec.name := l_okc_k_lines_tl_rec.name;
6924: END IF;
6925: IF (x_okc_k_lines_tl_rec.comments = OKC_API.G_MISS_CHAR)
6926: THEN
6927: x_okc_k_lines_tl_rec.comments := l_okc_k_lines_tl_rec.comments;
6928: END IF;
6929: IF (x_okc_k_lines_tl_rec.item_description = OKC_API.G_MISS_CHAR)

Line 6927: x_okc_k_lines_tl_rec.comments := l_okc_k_lines_tl_rec.comments;

6923: x_okc_k_lines_tl_rec.name := l_okc_k_lines_tl_rec.name;
6924: END IF;
6925: IF (x_okc_k_lines_tl_rec.comments = OKC_API.G_MISS_CHAR)
6926: THEN
6927: x_okc_k_lines_tl_rec.comments := l_okc_k_lines_tl_rec.comments;
6928: END IF;
6929: IF (x_okc_k_lines_tl_rec.item_description = OKC_API.G_MISS_CHAR)
6930: THEN
6931: x_okc_k_lines_tl_rec.item_description := l_okc_k_lines_tl_rec.item_description;

Line 6929: IF (x_okc_k_lines_tl_rec.item_description = OKC_API.G_MISS_CHAR)

6925: IF (x_okc_k_lines_tl_rec.comments = OKC_API.G_MISS_CHAR)
6926: THEN
6927: x_okc_k_lines_tl_rec.comments := l_okc_k_lines_tl_rec.comments;
6928: END IF;
6929: IF (x_okc_k_lines_tl_rec.item_description = OKC_API.G_MISS_CHAR)
6930: THEN
6931: x_okc_k_lines_tl_rec.item_description := l_okc_k_lines_tl_rec.item_description;
6932: END IF;
6933: IF (x_okc_k_lines_tl_rec.oke_boe_description = OKC_API.G_MISS_CHAR)

Line 6931: x_okc_k_lines_tl_rec.item_description := l_okc_k_lines_tl_rec.item_description;

6927: x_okc_k_lines_tl_rec.comments := l_okc_k_lines_tl_rec.comments;
6928: END IF;
6929: IF (x_okc_k_lines_tl_rec.item_description = OKC_API.G_MISS_CHAR)
6930: THEN
6931: x_okc_k_lines_tl_rec.item_description := l_okc_k_lines_tl_rec.item_description;
6932: END IF;
6933: IF (x_okc_k_lines_tl_rec.oke_boe_description = OKC_API.G_MISS_CHAR)
6934: THEN
6935: x_okc_k_lines_tl_rec.oke_boe_description := l_okc_k_lines_tl_rec.oke_boe_description;

Line 6933: IF (x_okc_k_lines_tl_rec.oke_boe_description = OKC_API.G_MISS_CHAR)

6929: IF (x_okc_k_lines_tl_rec.item_description = OKC_API.G_MISS_CHAR)
6930: THEN
6931: x_okc_k_lines_tl_rec.item_description := l_okc_k_lines_tl_rec.item_description;
6932: END IF;
6933: IF (x_okc_k_lines_tl_rec.oke_boe_description = OKC_API.G_MISS_CHAR)
6934: THEN
6935: x_okc_k_lines_tl_rec.oke_boe_description := l_okc_k_lines_tl_rec.oke_boe_description;
6936: END IF;
6937: IF (x_okc_k_lines_tl_rec.cognomen = OKC_API.G_MISS_CHAR)

Line 6935: x_okc_k_lines_tl_rec.oke_boe_description := l_okc_k_lines_tl_rec.oke_boe_description;

6931: x_okc_k_lines_tl_rec.item_description := l_okc_k_lines_tl_rec.item_description;
6932: END IF;
6933: IF (x_okc_k_lines_tl_rec.oke_boe_description = OKC_API.G_MISS_CHAR)
6934: THEN
6935: x_okc_k_lines_tl_rec.oke_boe_description := l_okc_k_lines_tl_rec.oke_boe_description;
6936: END IF;
6937: IF (x_okc_k_lines_tl_rec.cognomen = OKC_API.G_MISS_CHAR)
6938: THEN
6939: x_okc_k_lines_tl_rec.cognomen := l_okc_k_lines_tl_rec.cognomen;

Line 6937: IF (x_okc_k_lines_tl_rec.cognomen = OKC_API.G_MISS_CHAR)

6933: IF (x_okc_k_lines_tl_rec.oke_boe_description = OKC_API.G_MISS_CHAR)
6934: THEN
6935: x_okc_k_lines_tl_rec.oke_boe_description := l_okc_k_lines_tl_rec.oke_boe_description;
6936: END IF;
6937: IF (x_okc_k_lines_tl_rec.cognomen = OKC_API.G_MISS_CHAR)
6938: THEN
6939: x_okc_k_lines_tl_rec.cognomen := l_okc_k_lines_tl_rec.cognomen;
6940: END IF;
6941: IF (x_okc_k_lines_tl_rec.block23text = OKC_API.G_MISS_CHAR)

Line 6939: x_okc_k_lines_tl_rec.cognomen := l_okc_k_lines_tl_rec.cognomen;

6935: x_okc_k_lines_tl_rec.oke_boe_description := l_okc_k_lines_tl_rec.oke_boe_description;
6936: END IF;
6937: IF (x_okc_k_lines_tl_rec.cognomen = OKC_API.G_MISS_CHAR)
6938: THEN
6939: x_okc_k_lines_tl_rec.cognomen := l_okc_k_lines_tl_rec.cognomen;
6940: END IF;
6941: IF (x_okc_k_lines_tl_rec.block23text = OKC_API.G_MISS_CHAR)
6942: THEN
6943: x_okc_k_lines_tl_rec.block23text := l_okc_k_lines_tl_rec.block23text;

Line 6941: IF (x_okc_k_lines_tl_rec.block23text = OKC_API.G_MISS_CHAR)

6937: IF (x_okc_k_lines_tl_rec.cognomen = OKC_API.G_MISS_CHAR)
6938: THEN
6939: x_okc_k_lines_tl_rec.cognomen := l_okc_k_lines_tl_rec.cognomen;
6940: END IF;
6941: IF (x_okc_k_lines_tl_rec.block23text = OKC_API.G_MISS_CHAR)
6942: THEN
6943: x_okc_k_lines_tl_rec.block23text := l_okc_k_lines_tl_rec.block23text;
6944: END IF;
6945: IF (x_okc_k_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 6943: x_okc_k_lines_tl_rec.block23text := l_okc_k_lines_tl_rec.block23text;

6939: x_okc_k_lines_tl_rec.cognomen := l_okc_k_lines_tl_rec.cognomen;
6940: END IF;
6941: IF (x_okc_k_lines_tl_rec.block23text = OKC_API.G_MISS_CHAR)
6942: THEN
6943: x_okc_k_lines_tl_rec.block23text := l_okc_k_lines_tl_rec.block23text;
6944: END IF;
6945: IF (x_okc_k_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)
6946: THEN
6947: x_okc_k_lines_tl_rec.created_by := l_okc_k_lines_tl_rec.created_by;

Line 6945: IF (x_okc_k_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)

6941: IF (x_okc_k_lines_tl_rec.block23text = OKC_API.G_MISS_CHAR)
6942: THEN
6943: x_okc_k_lines_tl_rec.block23text := l_okc_k_lines_tl_rec.block23text;
6944: END IF;
6945: IF (x_okc_k_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)
6946: THEN
6947: x_okc_k_lines_tl_rec.created_by := l_okc_k_lines_tl_rec.created_by;
6948: END IF;
6949: IF (x_okc_k_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 6947: x_okc_k_lines_tl_rec.created_by := l_okc_k_lines_tl_rec.created_by;

6943: x_okc_k_lines_tl_rec.block23text := l_okc_k_lines_tl_rec.block23text;
6944: END IF;
6945: IF (x_okc_k_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)
6946: THEN
6947: x_okc_k_lines_tl_rec.created_by := l_okc_k_lines_tl_rec.created_by;
6948: END IF;
6949: IF (x_okc_k_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6950: THEN
6951: x_okc_k_lines_tl_rec.creation_date := l_okc_k_lines_tl_rec.creation_date;

Line 6949: IF (x_okc_k_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)

6945: IF (x_okc_k_lines_tl_rec.created_by = OKC_API.G_MISS_NUM)
6946: THEN
6947: x_okc_k_lines_tl_rec.created_by := l_okc_k_lines_tl_rec.created_by;
6948: END IF;
6949: IF (x_okc_k_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6950: THEN
6951: x_okc_k_lines_tl_rec.creation_date := l_okc_k_lines_tl_rec.creation_date;
6952: END IF;
6953: IF (x_okc_k_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 6951: x_okc_k_lines_tl_rec.creation_date := l_okc_k_lines_tl_rec.creation_date;

6947: x_okc_k_lines_tl_rec.created_by := l_okc_k_lines_tl_rec.created_by;
6948: END IF;
6949: IF (x_okc_k_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6950: THEN
6951: x_okc_k_lines_tl_rec.creation_date := l_okc_k_lines_tl_rec.creation_date;
6952: END IF;
6953: IF (x_okc_k_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6954: THEN
6955: x_okc_k_lines_tl_rec.last_updated_by := l_okc_k_lines_tl_rec.last_updated_by;

Line 6953: IF (x_okc_k_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

6949: IF (x_okc_k_lines_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6950: THEN
6951: x_okc_k_lines_tl_rec.creation_date := l_okc_k_lines_tl_rec.creation_date;
6952: END IF;
6953: IF (x_okc_k_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6954: THEN
6955: x_okc_k_lines_tl_rec.last_updated_by := l_okc_k_lines_tl_rec.last_updated_by;
6956: END IF;
6957: IF (x_okc_k_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 6955: x_okc_k_lines_tl_rec.last_updated_by := l_okc_k_lines_tl_rec.last_updated_by;

6951: x_okc_k_lines_tl_rec.creation_date := l_okc_k_lines_tl_rec.creation_date;
6952: END IF;
6953: IF (x_okc_k_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6954: THEN
6955: x_okc_k_lines_tl_rec.last_updated_by := l_okc_k_lines_tl_rec.last_updated_by;
6956: END IF;
6957: IF (x_okc_k_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6958: THEN
6959: x_okc_k_lines_tl_rec.last_update_date := l_okc_k_lines_tl_rec.last_update_date;

Line 6957: IF (x_okc_k_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

6953: IF (x_okc_k_lines_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6954: THEN
6955: x_okc_k_lines_tl_rec.last_updated_by := l_okc_k_lines_tl_rec.last_updated_by;
6956: END IF;
6957: IF (x_okc_k_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6958: THEN
6959: x_okc_k_lines_tl_rec.last_update_date := l_okc_k_lines_tl_rec.last_update_date;
6960: END IF;
6961: IF (x_okc_k_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 6959: x_okc_k_lines_tl_rec.last_update_date := l_okc_k_lines_tl_rec.last_update_date;

6955: x_okc_k_lines_tl_rec.last_updated_by := l_okc_k_lines_tl_rec.last_updated_by;
6956: END IF;
6957: IF (x_okc_k_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6958: THEN
6959: x_okc_k_lines_tl_rec.last_update_date := l_okc_k_lines_tl_rec.last_update_date;
6960: END IF;
6961: IF (x_okc_k_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
6962: THEN
6963: x_okc_k_lines_tl_rec.last_update_login := l_okc_k_lines_tl_rec.last_update_login;

Line 6961: IF (x_okc_k_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

6957: IF (x_okc_k_lines_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6958: THEN
6959: x_okc_k_lines_tl_rec.last_update_date := l_okc_k_lines_tl_rec.last_update_date;
6960: END IF;
6961: IF (x_okc_k_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
6962: THEN
6963: x_okc_k_lines_tl_rec.last_update_login := l_okc_k_lines_tl_rec.last_update_login;
6964: END IF;
6965:

Line 6963: x_okc_k_lines_tl_rec.last_update_login := l_okc_k_lines_tl_rec.last_update_login;

6959: x_okc_k_lines_tl_rec.last_update_date := l_okc_k_lines_tl_rec.last_update_date;
6960: END IF;
6961: IF (x_okc_k_lines_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
6962: THEN
6963: x_okc_k_lines_tl_rec.last_update_login := l_okc_k_lines_tl_rec.last_update_login;
6964: END IF;
6965:
6966: IF (l_debug = 'Y') THEN
6967: okc_debug.log('19050: Leaving update_row', 2);

Line 6975: -- Set_Attributes for:OKC_K_LINES_TL --

6971: RETURN(l_return_status);
6972:
6973: END populate_new_record;
6974: ---------------------------------------
6975: -- Set_Attributes for:OKC_K_LINES_TL --
6976: ---------------------------------------
6977: FUNCTION Set_Attributes (
6978: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
6979: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type

Line 6978: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,

6974: ---------------------------------------
6975: -- Set_Attributes for:OKC_K_LINES_TL --
6976: ---------------------------------------
6977: FUNCTION Set_Attributes (
6978: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
6979: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type
6980: ) RETURN VARCHAR2 IS
6981: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6982: BEGIN

Line 6979: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type

6975: -- Set_Attributes for:OKC_K_LINES_TL --
6976: ---------------------------------------
6977: FUNCTION Set_Attributes (
6978: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
6979: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type
6980: ) RETURN VARCHAR2 IS
6981: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6982: BEGIN
6983:

Line 6984: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;

6980: ) RETURN VARCHAR2 IS
6981: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6982: BEGIN
6983:
6984: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
6985: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6986: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6987:
6988: RETURN(l_return_status);

Line 6985: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

6981: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6982: BEGIN
6983:
6984: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
6985: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6986: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6987:
6988: RETURN(l_return_status);
6989:

Line 6986: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

6982: BEGIN
6983:
6984: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
6985: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6986: x_okc_k_lines_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6987:
6988: RETURN(l_return_status);
6989:
6990: END Set_Attributes;

Line 7009: p_okc_k_lines_tl_rec, -- IN

7005: RAISE OKC_API.G_EXCEPTION_ERROR;
7006: END IF;
7007: --- Setting item attributes
7008: l_return_status := Set_Attributes(
7009: p_okc_k_lines_tl_rec, -- IN
7010: l_okc_k_lines_tl_rec); -- OUT
7011: --- If any errors happen abort API
7012: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 7010: l_okc_k_lines_tl_rec); -- OUT

7006: END IF;
7007: --- Setting item attributes
7008: l_return_status := Set_Attributes(
7009: p_okc_k_lines_tl_rec, -- IN
7010: l_okc_k_lines_tl_rec); -- OUT
7011: --- If any errors happen abort API
7012: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7014: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 7017: l_return_status := populate_new_record(l_okc_k_lines_tl_rec, l_def_okc_k_lines_tl_rec);

7013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7014: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7015: RAISE OKC_API.G_EXCEPTION_ERROR;
7016: END IF;
7017: l_return_status := populate_new_record(l_okc_k_lines_tl_rec, l_def_okc_k_lines_tl_rec);
7018: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7019: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7020: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7021: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 7023: UPDATE OKC_K_LINES_TL

7019: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7020: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7021: RAISE OKC_API.G_EXCEPTION_ERROR;
7022: END IF;
7023: UPDATE OKC_K_LINES_TL
7024: SET NAME = l_def_okc_k_lines_tl_rec.name,
7025: COMMENTS = l_def_okc_k_lines_tl_rec.comments,
7026: ITEM_DESCRIPTION = l_def_okc_k_lines_tl_rec.item_description,
7027: OKE_BOE_DESCRIPTION = l_def_okc_k_lines_tl_rec.oke_boe_description,

Line 7024: SET NAME = l_def_okc_k_lines_tl_rec.name,

7020: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7021: RAISE OKC_API.G_EXCEPTION_ERROR;
7022: END IF;
7023: UPDATE OKC_K_LINES_TL
7024: SET NAME = l_def_okc_k_lines_tl_rec.name,
7025: COMMENTS = l_def_okc_k_lines_tl_rec.comments,
7026: ITEM_DESCRIPTION = l_def_okc_k_lines_tl_rec.item_description,
7027: OKE_BOE_DESCRIPTION = l_def_okc_k_lines_tl_rec.oke_boe_description,
7028: COGNOMEN = l_def_okc_k_lines_tl_rec.cognomen,

Line 7025: COMMENTS = l_def_okc_k_lines_tl_rec.comments,

7021: RAISE OKC_API.G_EXCEPTION_ERROR;
7022: END IF;
7023: UPDATE OKC_K_LINES_TL
7024: SET NAME = l_def_okc_k_lines_tl_rec.name,
7025: COMMENTS = l_def_okc_k_lines_tl_rec.comments,
7026: ITEM_DESCRIPTION = l_def_okc_k_lines_tl_rec.item_description,
7027: OKE_BOE_DESCRIPTION = l_def_okc_k_lines_tl_rec.oke_boe_description,
7028: COGNOMEN = l_def_okc_k_lines_tl_rec.cognomen,
7029: BLOCK23TEXT = l_def_okc_k_lines_tl_rec.block23text,

Line 7026: ITEM_DESCRIPTION = l_def_okc_k_lines_tl_rec.item_description,

7022: END IF;
7023: UPDATE OKC_K_LINES_TL
7024: SET NAME = l_def_okc_k_lines_tl_rec.name,
7025: COMMENTS = l_def_okc_k_lines_tl_rec.comments,
7026: ITEM_DESCRIPTION = l_def_okc_k_lines_tl_rec.item_description,
7027: OKE_BOE_DESCRIPTION = l_def_okc_k_lines_tl_rec.oke_boe_description,
7028: COGNOMEN = l_def_okc_k_lines_tl_rec.cognomen,
7029: BLOCK23TEXT = l_def_okc_k_lines_tl_rec.block23text,
7030: SOURCE_LANG = l_def_okc_k_lines_tl_rec.source_lang,

Line 7027: OKE_BOE_DESCRIPTION = l_def_okc_k_lines_tl_rec.oke_boe_description,

7023: UPDATE OKC_K_LINES_TL
7024: SET NAME = l_def_okc_k_lines_tl_rec.name,
7025: COMMENTS = l_def_okc_k_lines_tl_rec.comments,
7026: ITEM_DESCRIPTION = l_def_okc_k_lines_tl_rec.item_description,
7027: OKE_BOE_DESCRIPTION = l_def_okc_k_lines_tl_rec.oke_boe_description,
7028: COGNOMEN = l_def_okc_k_lines_tl_rec.cognomen,
7029: BLOCK23TEXT = l_def_okc_k_lines_tl_rec.block23text,
7030: SOURCE_LANG = l_def_okc_k_lines_tl_rec.source_lang,
7031: CREATED_BY = l_def_okc_k_lines_tl_rec.created_by,

Line 7028: COGNOMEN = l_def_okc_k_lines_tl_rec.cognomen,

7024: SET NAME = l_def_okc_k_lines_tl_rec.name,
7025: COMMENTS = l_def_okc_k_lines_tl_rec.comments,
7026: ITEM_DESCRIPTION = l_def_okc_k_lines_tl_rec.item_description,
7027: OKE_BOE_DESCRIPTION = l_def_okc_k_lines_tl_rec.oke_boe_description,
7028: COGNOMEN = l_def_okc_k_lines_tl_rec.cognomen,
7029: BLOCK23TEXT = l_def_okc_k_lines_tl_rec.block23text,
7030: SOURCE_LANG = l_def_okc_k_lines_tl_rec.source_lang,
7031: CREATED_BY = l_def_okc_k_lines_tl_rec.created_by,
7032: CREATION_DATE = l_def_okc_k_lines_tl_rec.creation_date,

Line 7029: BLOCK23TEXT = l_def_okc_k_lines_tl_rec.block23text,

7025: COMMENTS = l_def_okc_k_lines_tl_rec.comments,
7026: ITEM_DESCRIPTION = l_def_okc_k_lines_tl_rec.item_description,
7027: OKE_BOE_DESCRIPTION = l_def_okc_k_lines_tl_rec.oke_boe_description,
7028: COGNOMEN = l_def_okc_k_lines_tl_rec.cognomen,
7029: BLOCK23TEXT = l_def_okc_k_lines_tl_rec.block23text,
7030: SOURCE_LANG = l_def_okc_k_lines_tl_rec.source_lang,
7031: CREATED_BY = l_def_okc_k_lines_tl_rec.created_by,
7032: CREATION_DATE = l_def_okc_k_lines_tl_rec.creation_date,
7033: LAST_UPDATED_BY = l_def_okc_k_lines_tl_rec.last_updated_by,

Line 7030: SOURCE_LANG = l_def_okc_k_lines_tl_rec.source_lang,

7026: ITEM_DESCRIPTION = l_def_okc_k_lines_tl_rec.item_description,
7027: OKE_BOE_DESCRIPTION = l_def_okc_k_lines_tl_rec.oke_boe_description,
7028: COGNOMEN = l_def_okc_k_lines_tl_rec.cognomen,
7029: BLOCK23TEXT = l_def_okc_k_lines_tl_rec.block23text,
7030: SOURCE_LANG = l_def_okc_k_lines_tl_rec.source_lang,
7031: CREATED_BY = l_def_okc_k_lines_tl_rec.created_by,
7032: CREATION_DATE = l_def_okc_k_lines_tl_rec.creation_date,
7033: LAST_UPDATED_BY = l_def_okc_k_lines_tl_rec.last_updated_by,
7034: LAST_UPDATE_DATE = l_def_okc_k_lines_tl_rec.last_update_date,

Line 7031: CREATED_BY = l_def_okc_k_lines_tl_rec.created_by,

7027: OKE_BOE_DESCRIPTION = l_def_okc_k_lines_tl_rec.oke_boe_description,
7028: COGNOMEN = l_def_okc_k_lines_tl_rec.cognomen,
7029: BLOCK23TEXT = l_def_okc_k_lines_tl_rec.block23text,
7030: SOURCE_LANG = l_def_okc_k_lines_tl_rec.source_lang,
7031: CREATED_BY = l_def_okc_k_lines_tl_rec.created_by,
7032: CREATION_DATE = l_def_okc_k_lines_tl_rec.creation_date,
7033: LAST_UPDATED_BY = l_def_okc_k_lines_tl_rec.last_updated_by,
7034: LAST_UPDATE_DATE = l_def_okc_k_lines_tl_rec.last_update_date,
7035: LAST_UPDATE_LOGIN = l_def_okc_k_lines_tl_rec.last_update_login

Line 7032: CREATION_DATE = l_def_okc_k_lines_tl_rec.creation_date,

7028: COGNOMEN = l_def_okc_k_lines_tl_rec.cognomen,
7029: BLOCK23TEXT = l_def_okc_k_lines_tl_rec.block23text,
7030: SOURCE_LANG = l_def_okc_k_lines_tl_rec.source_lang,
7031: CREATED_BY = l_def_okc_k_lines_tl_rec.created_by,
7032: CREATION_DATE = l_def_okc_k_lines_tl_rec.creation_date,
7033: LAST_UPDATED_BY = l_def_okc_k_lines_tl_rec.last_updated_by,
7034: LAST_UPDATE_DATE = l_def_okc_k_lines_tl_rec.last_update_date,
7035: LAST_UPDATE_LOGIN = l_def_okc_k_lines_tl_rec.last_update_login
7036: WHERE ID = l_def_okc_k_lines_tl_rec.id

Line 7033: LAST_UPDATED_BY = l_def_okc_k_lines_tl_rec.last_updated_by,

7029: BLOCK23TEXT = l_def_okc_k_lines_tl_rec.block23text,
7030: SOURCE_LANG = l_def_okc_k_lines_tl_rec.source_lang,
7031: CREATED_BY = l_def_okc_k_lines_tl_rec.created_by,
7032: CREATION_DATE = l_def_okc_k_lines_tl_rec.creation_date,
7033: LAST_UPDATED_BY = l_def_okc_k_lines_tl_rec.last_updated_by,
7034: LAST_UPDATE_DATE = l_def_okc_k_lines_tl_rec.last_update_date,
7035: LAST_UPDATE_LOGIN = l_def_okc_k_lines_tl_rec.last_update_login
7036: WHERE ID = l_def_okc_k_lines_tl_rec.id
7037: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);

Line 7034: LAST_UPDATE_DATE = l_def_okc_k_lines_tl_rec.last_update_date,

7030: SOURCE_LANG = l_def_okc_k_lines_tl_rec.source_lang,
7031: CREATED_BY = l_def_okc_k_lines_tl_rec.created_by,
7032: CREATION_DATE = l_def_okc_k_lines_tl_rec.creation_date,
7033: LAST_UPDATED_BY = l_def_okc_k_lines_tl_rec.last_updated_by,
7034: LAST_UPDATE_DATE = l_def_okc_k_lines_tl_rec.last_update_date,
7035: LAST_UPDATE_LOGIN = l_def_okc_k_lines_tl_rec.last_update_login
7036: WHERE ID = l_def_okc_k_lines_tl_rec.id
7037: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
7038:

Line 7035: LAST_UPDATE_LOGIN = l_def_okc_k_lines_tl_rec.last_update_login

7031: CREATED_BY = l_def_okc_k_lines_tl_rec.created_by,
7032: CREATION_DATE = l_def_okc_k_lines_tl_rec.creation_date,
7033: LAST_UPDATED_BY = l_def_okc_k_lines_tl_rec.last_updated_by,
7034: LAST_UPDATE_DATE = l_def_okc_k_lines_tl_rec.last_update_date,
7035: LAST_UPDATE_LOGIN = l_def_okc_k_lines_tl_rec.last_update_login
7036: WHERE ID = l_def_okc_k_lines_tl_rec.id
7037: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
7038:
7039: UPDATE OKC_K_LINES_TL

Line 7036: WHERE ID = l_def_okc_k_lines_tl_rec.id

7032: CREATION_DATE = l_def_okc_k_lines_tl_rec.creation_date,
7033: LAST_UPDATED_BY = l_def_okc_k_lines_tl_rec.last_updated_by,
7034: LAST_UPDATE_DATE = l_def_okc_k_lines_tl_rec.last_update_date,
7035: LAST_UPDATE_LOGIN = l_def_okc_k_lines_tl_rec.last_update_login
7036: WHERE ID = l_def_okc_k_lines_tl_rec.id
7037: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
7038:
7039: UPDATE OKC_K_LINES_TL
7040: SET SFWT_FLAG = 'Y'

Line 7039: UPDATE OKC_K_LINES_TL

7035: LAST_UPDATE_LOGIN = l_def_okc_k_lines_tl_rec.last_update_login
7036: WHERE ID = l_def_okc_k_lines_tl_rec.id
7037: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
7038:
7039: UPDATE OKC_K_LINES_TL
7040: SET SFWT_FLAG = 'Y'
7041: WHERE ID = l_def_okc_k_lines_tl_rec.id
7042: AND SOURCE_LANG <> USERENV('LANG');
7043:

Line 7041: WHERE ID = l_def_okc_k_lines_tl_rec.id

7037: AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);
7038:
7039: UPDATE OKC_K_LINES_TL
7040: SET SFWT_FLAG = 'Y'
7041: WHERE ID = l_def_okc_k_lines_tl_rec.id
7042: AND SOURCE_LANG <> USERENV('LANG');
7043:
7044: x_okc_k_lines_tl_rec := l_def_okc_k_lines_tl_rec;
7045: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 7044: x_okc_k_lines_tl_rec := l_def_okc_k_lines_tl_rec;

7040: SET SFWT_FLAG = 'Y'
7041: WHERE ID = l_def_okc_k_lines_tl_rec.id
7042: AND SOURCE_LANG <> USERENV('LANG');
7043:
7044: x_okc_k_lines_tl_rec := l_def_okc_k_lines_tl_rec;
7045: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
7046:
7047: IF (l_debug = 'Y') THEN
7048: okc_debug.log('19300: Exiting update_row', 2);

Line 7121: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

7117: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
7118: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7119: l_clev_rec clev_rec_type := p_clev_rec;
7120: l_def_clev_rec clev_rec_type;
7121: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
7122: lx_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
7123: l_cle_rec cle_rec_type;
7124: lx_cle_rec cle_rec_type;
7125: -------------------------------

Line 7122: lx_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

7118: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7119: l_clev_rec clev_rec_type := p_clev_rec;
7120: l_def_clev_rec clev_rec_type;
7121: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
7122: lx_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
7123: l_cle_rec cle_rec_type;
7124: lx_cle_rec cle_rec_type;
7125: -------------------------------
7126: -- FUNCTION fill_who_columns --

Line 7637: migrate(l_def_clev_rec, l_okc_k_lines_tl_rec);

7633:
7634: --------------------------------------
7635: -- Move VIEW record to "Child" records
7636: --------------------------------------
7637: migrate(l_def_clev_rec, l_okc_k_lines_tl_rec);
7638: migrate(l_def_clev_rec, l_cle_rec);
7639: --------------------------------------------
7640: -- Call the UPDATE_ROW for each child record
7641: --------------------------------------------

Line 7647: l_okc_k_lines_tl_rec,

7643: p_init_msg_list,
7644: x_return_status,
7645: x_msg_count,
7646: x_msg_data,
7647: l_okc_k_lines_tl_rec,
7648: lx_okc_k_lines_tl_rec
7649: );
7650: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7651: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 7648: lx_okc_k_lines_tl_rec

7644: x_return_status,
7645: x_msg_count,
7646: x_msg_data,
7647: l_okc_k_lines_tl_rec,
7648: lx_okc_k_lines_tl_rec
7649: );
7650: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7651: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7652: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 7655: migrate(lx_okc_k_lines_tl_rec, l_def_clev_rec);

7651: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7652: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7653: RAISE OKC_API.G_EXCEPTION_ERROR;
7654: END IF;
7655: migrate(lx_okc_k_lines_tl_rec, l_def_clev_rec);
7656: update_row(
7657: p_init_msg_list,
7658: x_return_status,
7659: x_msg_count,

Line 7937: -- delete_row for:OKC_K_LINES_TL --

7933: );
7934:
7935: END delete_row;
7936: -----------------------------------
7937: -- delete_row for:OKC_K_LINES_TL --
7938: -----------------------------------
7939: PROCEDURE delete_row(
7940: p_init_msg_list IN VARCHAR2,
7941: x_return_status OUT NOCOPY VARCHAR2,

Line 7944: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type) IS

7940: p_init_msg_list IN VARCHAR2,
7941: x_return_status OUT NOCOPY VARCHAR2,
7942: x_msg_count OUT NOCOPY NUMBER,
7943: x_msg_data OUT NOCOPY VARCHAR2,
7944: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type) IS
7945:
7946: l_api_version CONSTANT NUMBER := 1;
7947: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
7948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 7949: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type:= p_okc_k_lines_tl_rec;

7945:
7946: l_api_version CONSTANT NUMBER := 1;
7947: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
7948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7949: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type:= p_okc_k_lines_tl_rec;
7950: l_row_notfound BOOLEAN := TRUE;
7951: ---------------------------------------
7952: -- Set_Attributes for:OKC_K_LINES_TL --
7953: ---------------------------------------

Line 7952: -- Set_Attributes for:OKC_K_LINES_TL --

7948: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7949: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type:= p_okc_k_lines_tl_rec;
7950: l_row_notfound BOOLEAN := TRUE;
7951: ---------------------------------------
7952: -- Set_Attributes for:OKC_K_LINES_TL --
7953: ---------------------------------------
7954: FUNCTION Set_Attributes (
7955: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
7956: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type

Line 7955: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,

7951: ---------------------------------------
7952: -- Set_Attributes for:OKC_K_LINES_TL --
7953: ---------------------------------------
7954: FUNCTION Set_Attributes (
7955: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
7956: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type
7957: ) RETURN VARCHAR2 IS
7958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7959: BEGIN

Line 7956: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type

7952: -- Set_Attributes for:OKC_K_LINES_TL --
7953: ---------------------------------------
7954: FUNCTION Set_Attributes (
7955: p_okc_k_lines_tl_rec IN okc_k_lines_tl_rec_type,
7956: x_okc_k_lines_tl_rec OUT NOCOPY okc_k_lines_tl_rec_type
7957: ) RETURN VARCHAR2 IS
7958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7959: BEGIN
7960:

Line 7961: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;

7957: ) RETURN VARCHAR2 IS
7958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7959: BEGIN
7960:
7961: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
7962: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
7963: RETURN(l_return_status);
7964:
7965: END Set_Attributes;

Line 7962: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

7958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7959: BEGIN
7960:
7961: x_okc_k_lines_tl_rec := p_okc_k_lines_tl_rec;
7962: x_okc_k_lines_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
7963: RETURN(l_return_status);
7964:
7965: END Set_Attributes;
7966: BEGIN

Line 7984: p_okc_k_lines_tl_rec, -- IN

7980: RAISE OKC_API.G_EXCEPTION_ERROR;
7981: END IF;
7982: --- Setting item attributes
7983: l_return_status := Set_Attributes(
7984: p_okc_k_lines_tl_rec, -- IN
7985: l_okc_k_lines_tl_rec); -- OUT
7986: --- If any errors happen abort API
7987: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 7985: l_okc_k_lines_tl_rec); -- OUT

7981: END IF;
7982: --- Setting item attributes
7983: l_return_status := Set_Attributes(
7984: p_okc_k_lines_tl_rec, -- IN
7985: l_okc_k_lines_tl_rec); -- OUT
7986: --- If any errors happen abort API
7987: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7989: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 7992: DELETE FROM OKC_K_LINES_TL

7988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7989: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7990: RAISE OKC_API.G_EXCEPTION_ERROR;
7991: END IF;
7992: DELETE FROM OKC_K_LINES_TL
7993: WHERE ID = l_okc_k_lines_tl_rec.id;
7994:
7995: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
7996:

Line 7993: WHERE ID = l_okc_k_lines_tl_rec.id;

7989: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7990: RAISE OKC_API.G_EXCEPTION_ERROR;
7991: END IF;
7992: DELETE FROM OKC_K_LINES_TL
7993: WHERE ID = l_okc_k_lines_tl_rec.id;
7994:
7995: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
7996:
7997: IF (l_debug = 'Y') THEN

Line 8068: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

8064: l_api_version CONSTANT NUMBER := 1;
8065: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
8066: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8067: l_clev_rec clev_rec_type := p_clev_rec;
8068: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
8069: l_cle_rec cle_rec_type;
8070: l_olev_rec OKC_OPER_INST_PUB.olev_rec_type;
8071: x_olev_rec OKC_OPER_INST_PUB.olev_rec_type;
8072: l_opn_code VARCHAR2(30);

Line 8155: migrate(l_clev_rec, l_okc_k_lines_tl_rec);

8151:
8152: --------------------------------------
8153: -- Move VIEW record to "Child" records
8154: --------------------------------------
8155: migrate(l_clev_rec, l_okc_k_lines_tl_rec);
8156: migrate(l_clev_rec, l_cle_rec);
8157:
8158: --------------------------------------------
8159: -- Call the DELETE_ROW for each child record

Line 8166: l_okc_k_lines_tl_rec

8162: p_init_msg_list,
8163: x_return_status,
8164: x_msg_count,
8165: x_msg_data,
8166: l_okc_k_lines_tl_rec
8167: );
8168: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8169: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8170: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 8454: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;

8450: l_api_version CONSTANT NUMBER := 1;
8451: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
8452: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8453: l_clev_rec clev_rec_type := p_clev_rec;
8454: l_okc_k_lines_tl_rec okc_k_lines_tl_rec_type;
8455: l_cle_rec cle_rec_type;
8456: l_olev_rec OKC_OPER_INST_PUB.olev_rec_type;
8457: x_olev_rec OKC_OPER_INST_PUB.olev_rec_type;
8458: l_opn_code VARCHAR2(30);

Line 8485: migrate(l_clev_rec, l_okc_k_lines_tl_rec);

8481:
8482: --------------------------------------
8483: -- Move VIEW record to "Child" records
8484: --------------------------------------
8485: migrate(l_clev_rec, l_okc_k_lines_tl_rec);
8486: migrate(l_clev_rec, l_cle_rec);
8487:
8488: --------------------------------------------
8489: -- Call the DELETE_ROW for each child record

Line 8496: l_okc_k_lines_tl_rec

8492: p_init_msg_list,
8493: x_return_status,
8494: x_msg_count,
8495: x_msg_data,
8496: l_okc_k_lines_tl_rec
8497: );
8498: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8500: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 9155: INSERT INTO OKC_K_LINES_TL(

9151: );
9152:
9153: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
9154: FORALL i in 1..l_tabsize
9155: INSERT INTO OKC_K_LINES_TL(
9156: id,
9157: language,
9158: source_lang,
9159: sfwt_flag,

Line 9443: INSERT INTO okc_k_lines_tlh

9439: ----------------------------------
9440: -- Version TL Table
9441: ----------------------------------
9442:
9443: INSERT INTO okc_k_lines_tlh
9444: (
9445: major_version,
9446: id,
9447: language,

Line 9479: FROM okc_k_lines_tl

9475: creation_date,
9476: last_updated_by,
9477: last_update_date,
9478: last_update_login
9479: FROM okc_k_lines_tl
9480: WHERE id in (select id
9481: from okc_k_lines_b
9482: where dnz_chr_id = p_chr_id);
9483:

Line 9532: INSERT INTO okc_k_lines_tl

9528: okc_debug.Set_Indentation('OKC_CLE_PVT');
9529: okc_debug.log('23700: Entered restore_version', 2);
9530: END IF;
9531:
9532: INSERT INTO okc_k_lines_tl
9533: (
9534: id,
9535: language,
9536: source_lang,

Line 9566: FROM okc_k_lines_tlh

9562: creation_date,
9563: last_updated_by,
9564: last_update_date,
9565: last_update_login
9566: FROM okc_k_lines_tlh
9567: WHERE id in (SELECT id
9568: FROM okc_k_lines_bh
9569: WHERE dnz_chr_id = p_chr_id)
9570: AND major_version = p_major_version;