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_CHR_PVT dependencies on OKC_K_HEADERS_TL

Line 2446: DELETE FROM OKC_K_HEADERS_TL T

2442: /* as a quick workaround to fix the time-consuming table handler issue */
2443: /* Eventually we'll need to turn them into a separate fix_language procedure */
2444: /*
2445:
2446: DELETE FROM OKC_K_HEADERS_TL T
2447: WHERE NOT EXISTS (
2448: SELECT NULL
2449: FROM OKC_K_HEADERS_B B
2450: WHERE B.ID = T.ID

Line 2453: UPDATE OKC_K_HEADERS_TL T SET (

2449: FROM OKC_K_HEADERS_B B
2450: WHERE B.ID = T.ID
2451: );
2452:
2453: UPDATE OKC_K_HEADERS_TL T SET (
2454: SHORT_DESCRIPTION,
2455: COMMENTS,
2456: DESCRIPTION,
2457: COGNOMEN,

Line 2468: FROM OKC_K_HEADERS_TL B

2464: B.COGNOMEN,
2465: B.NON_RESPONSE_REASON,
2466: B.NON_RESPONSE_EXPLAIN,
2467: B.SET_ASIDE_REASON
2468: FROM OKC_K_HEADERS_TL B
2469: WHERE B.ID = T.ID
2470: AND B.LANGUAGE = T.SOURCE_LANG)
2471: WHERE (
2472: T.ID,

Line 2477: FROM OKC_K_HEADERS_TL SUBB, OKC_K_HEADERS_TL SUBT

2473: T.LANGUAGE)
2474: IN (SELECT
2475: SUBT.ID,
2476: SUBT.LANGUAGE
2477: FROM OKC_K_HEADERS_TL SUBB, OKC_K_HEADERS_TL SUBT
2478: WHERE SUBB.ID = SUBT.ID
2479: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
2480: AND (SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
2481: OR SUBB.COMMENTS <> SUBT.COMMENTS

Line 2505: INSERT /+ append parallel(tt) / INTO OKC_K_HEADERS_TL tt(

2501: ));
2502: */
2503: /* Modifying Insert as per performance guidelines given in bug 3723874 */
2504:
2505: INSERT /*+ append parallel(tt) */ INTO OKC_K_HEADERS_TL tt(
2506: ID,
2507: LANGUAGE,
2508: SOURCE_LANG,
2509: SFWT_FLAG,

Line 2540: FROM OKC_K_HEADERS_TL B, FND_LANGUAGES L

2536: B.CREATION_DATE,
2537: B.LAST_UPDATED_BY,
2538: B.LAST_UPDATE_DATE,
2539: B.LAST_UPDATE_LOGIN
2540: FROM OKC_K_HEADERS_TL B, FND_LANGUAGES L
2541: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2542: AND B.LANGUAGE = USERENV('LANG')
2543: ) v, OKC_K_HEADERS_TL t
2544: WHERE t.ID( + ) = v.ID

Line 2543: ) v, OKC_K_HEADERS_TL t

2539: B.LAST_UPDATE_LOGIN
2540: FROM OKC_K_HEADERS_TL B, FND_LANGUAGES L
2541: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2542: AND B.LANGUAGE = USERENV('LANG')
2543: ) v, OKC_K_HEADERS_TL t
2544: WHERE t.ID( + ) = v.ID
2545: AND t.language( + ) = v.LANGUAGE_CODE
2546: AND t.id IS NULL;
2547:

Line 2551: DELETE FROM OKC_K_HEADERS_TLH T

2547:
2548:
2549: /* Commenting delete and update for bug 3723874 */
2550: /*
2551: DELETE FROM OKC_K_HEADERS_TLH T
2552: WHERE NOT EXISTS (
2553: SELECT NULL
2554: FROM OKC_K_HEADERS_BH B
2555: WHERE B.ID = T.ID

Line 2559: UPDATE OKC_K_HEADERS_TLH T SET (

2555: WHERE B.ID = T.ID
2556: AND B.MAJOR_VERSION = T.MAJOR_VERSION
2557: );
2558:
2559: UPDATE OKC_K_HEADERS_TLH T SET (
2560: SHORT_DESCRIPTION,
2561: COMMENTS,
2562: DESCRIPTION,
2563: COGNOMEN,

Line 2574: FROM OKC_K_HEADERS_TLH B

2570: B.COGNOMEN,
2571: B.NON_RESPONSE_REASON,
2572: B.NON_RESPONSE_EXPLAIN,
2573: B.SET_ASIDE_REASON
2574: FROM OKC_K_HEADERS_TLH B
2575: WHERE B.ID = T.ID
2576: AND B.MAJOR_VERSION = T.MAJOR_VERSION
2577: AND B.LANGUAGE = T.SOURCE_LANG)
2578: WHERE (

Line 2586: FROM OKC_K_HEADERS_TLH SUBB, OKC_K_HEADERS_TLH SUBT

2582: IN (SELECT
2583: SUBT.ID,
2584: SUBT.MAJOR_VERSION,
2585: SUBT.LANGUAGE
2586: FROM OKC_K_HEADERS_TLH SUBB, OKC_K_HEADERS_TLH SUBT
2587: WHERE SUBB.ID = SUBT.ID
2588: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
2589: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
2590: AND (SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION

Line 2615: INSERT /+ append parallel(tt) / INTO OKC_K_HEADERS_TLH tt(

2611: ));
2612:
2613: */
2614: /* Modifying Insert as per performance guidelines given in bug 3723874 */
2615: INSERT /*+ append parallel(tt) */ INTO OKC_K_HEADERS_TLH tt(
2616: ID,
2617: LANGUAGE,
2618: MAJOR_VERSION,
2619: SOURCE_LANG,

Line 2652: FROM OKC_K_HEADERS_TLH B, FND_LANGUAGES L

2648: B.CREATION_DATE,
2649: B.LAST_UPDATED_BY,
2650: B.LAST_UPDATE_DATE,
2651: B.LAST_UPDATE_LOGIN
2652: FROM OKC_K_HEADERS_TLH B, FND_LANGUAGES L
2653: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2654: AND B.LANGUAGE = USERENV('LANG')
2655: ) v, OKC_K_HEADERS_TLH t
2656: WHERE T.ID( + ) = v.ID

Line 2655: ) v, OKC_K_HEADERS_TLH t

2651: B.LAST_UPDATE_LOGIN
2652: FROM OKC_K_HEADERS_TLH B, FND_LANGUAGES L
2653: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2654: AND B.LANGUAGE = USERENV('LANG')
2655: ) v, OKC_K_HEADERS_TLH t
2656: WHERE T.ID( + ) = v.ID
2657: AND T.MAJOR_VERSION( + ) = v.MAJOR_VERSION
2658: AND T.LANGUAGE( + ) = v.LANGUAGE_CODE
2659: AND t.id IS NULL;

Line 2915: -- FUNCTION get_rec for: OKC_K_HEADERS_TL

2911: RETURN(get_rec(p_chr_rec, l_row_notfound));
2912:
2913: END get_rec;
2914: ---------------------------------------------------------------------------
2915: -- FUNCTION get_rec for: OKC_K_HEADERS_TL
2916: ---------------------------------------------------------------------------
2917: FUNCTION get_rec (
2918: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
2919: x_no_data_found OUT NOCOPY BOOLEAN

Line 2918: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,

2914: ---------------------------------------------------------------------------
2915: -- FUNCTION get_rec for: OKC_K_HEADERS_TL
2916: ---------------------------------------------------------------------------
2917: FUNCTION get_rec (
2918: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
2919: x_no_data_found OUT NOCOPY BOOLEAN
2920: ) RETURN okc_k_headers_tl_rec_type IS
2921: CURSOR chr_pktl_csr (p_id IN NUMBER,
2922: p_language IN VARCHAR2) IS

Line 2920: ) RETURN okc_k_headers_tl_rec_type IS

2916: ---------------------------------------------------------------------------
2917: FUNCTION get_rec (
2918: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
2919: x_no_data_found OUT NOCOPY BOOLEAN
2920: ) RETURN okc_k_headers_tl_rec_type IS
2921: CURSOR chr_pktl_csr (p_id IN NUMBER,
2922: p_language IN VARCHAR2) IS
2923: SELECT
2924: ID,

Line 2940: FROM Okc_K_Headers_Tl

2936: CREATION_DATE,
2937: LAST_UPDATED_BY,
2938: LAST_UPDATE_DATE,
2939: LAST_UPDATE_LOGIN
2940: FROM Okc_K_Headers_Tl
2941: WHERE okc_k_headers_tl.id = p_id
2942: AND okc_k_headers_tl.language = p_language;
2943: l_chr_pktl chr_pktl_csr%ROWTYPE;
2944: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

Line 2941: WHERE okc_k_headers_tl.id = p_id

2937: LAST_UPDATED_BY,
2938: LAST_UPDATE_DATE,
2939: LAST_UPDATE_LOGIN
2940: FROM Okc_K_Headers_Tl
2941: WHERE okc_k_headers_tl.id = p_id
2942: AND okc_k_headers_tl.language = p_language;
2943: l_chr_pktl chr_pktl_csr%ROWTYPE;
2944: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
2945: BEGIN

Line 2942: AND okc_k_headers_tl.language = p_language;

2938: LAST_UPDATE_DATE,
2939: LAST_UPDATE_LOGIN
2940: FROM Okc_K_Headers_Tl
2941: WHERE okc_k_headers_tl.id = p_id
2942: AND okc_k_headers_tl.language = p_language;
2943: l_chr_pktl chr_pktl_csr%ROWTYPE;
2944: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
2945: BEGIN
2946:

Line 2944: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

2940: FROM Okc_K_Headers_Tl
2941: WHERE okc_k_headers_tl.id = p_id
2942: AND okc_k_headers_tl.language = p_language;
2943: l_chr_pktl chr_pktl_csr%ROWTYPE;
2944: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
2945: BEGIN
2946:
2947: IF (l_debug = 'Y') THEN
2948: okc_debug.Set_Indentation('OKC_CHR_PVT');

Line 2954: OPEN chr_pktl_csr (p_okc_k_headers_tl_rec.id,

2950: END IF;
2951:
2952: x_no_data_found := TRUE;
2953: -- Get current database values
2954: OPEN chr_pktl_csr (p_okc_k_headers_tl_rec.id,
2955: p_okc_k_headers_tl_rec.language);
2956: FETCH chr_pktl_csr INTO
2957: l_okc_k_headers_tl_rec.ID,
2958: l_okc_k_headers_tl_rec.LANGUAGE,

Line 2955: p_okc_k_headers_tl_rec.language);

2951:
2952: x_no_data_found := TRUE;
2953: -- Get current database values
2954: OPEN chr_pktl_csr (p_okc_k_headers_tl_rec.id,
2955: p_okc_k_headers_tl_rec.language);
2956: FETCH chr_pktl_csr INTO
2957: l_okc_k_headers_tl_rec.ID,
2958: l_okc_k_headers_tl_rec.LANGUAGE,
2959: l_okc_k_headers_tl_rec.SOURCE_LANG,

Line 2957: l_okc_k_headers_tl_rec.ID,

2953: -- Get current database values
2954: OPEN chr_pktl_csr (p_okc_k_headers_tl_rec.id,
2955: p_okc_k_headers_tl_rec.language);
2956: FETCH chr_pktl_csr INTO
2957: l_okc_k_headers_tl_rec.ID,
2958: l_okc_k_headers_tl_rec.LANGUAGE,
2959: l_okc_k_headers_tl_rec.SOURCE_LANG,
2960: l_okc_k_headers_tl_rec.SFWT_FLAG,
2961: l_okc_k_headers_tl_rec.SHORT_DESCRIPTION,

Line 2958: l_okc_k_headers_tl_rec.LANGUAGE,

2954: OPEN chr_pktl_csr (p_okc_k_headers_tl_rec.id,
2955: p_okc_k_headers_tl_rec.language);
2956: FETCH chr_pktl_csr INTO
2957: l_okc_k_headers_tl_rec.ID,
2958: l_okc_k_headers_tl_rec.LANGUAGE,
2959: l_okc_k_headers_tl_rec.SOURCE_LANG,
2960: l_okc_k_headers_tl_rec.SFWT_FLAG,
2961: l_okc_k_headers_tl_rec.SHORT_DESCRIPTION,
2962: l_okc_k_headers_tl_rec.COMMENTS,

Line 2959: l_okc_k_headers_tl_rec.SOURCE_LANG,

2955: p_okc_k_headers_tl_rec.language);
2956: FETCH chr_pktl_csr INTO
2957: l_okc_k_headers_tl_rec.ID,
2958: l_okc_k_headers_tl_rec.LANGUAGE,
2959: l_okc_k_headers_tl_rec.SOURCE_LANG,
2960: l_okc_k_headers_tl_rec.SFWT_FLAG,
2961: l_okc_k_headers_tl_rec.SHORT_DESCRIPTION,
2962: l_okc_k_headers_tl_rec.COMMENTS,
2963: l_okc_k_headers_tl_rec.DESCRIPTION,

Line 2960: l_okc_k_headers_tl_rec.SFWT_FLAG,

2956: FETCH chr_pktl_csr INTO
2957: l_okc_k_headers_tl_rec.ID,
2958: l_okc_k_headers_tl_rec.LANGUAGE,
2959: l_okc_k_headers_tl_rec.SOURCE_LANG,
2960: l_okc_k_headers_tl_rec.SFWT_FLAG,
2961: l_okc_k_headers_tl_rec.SHORT_DESCRIPTION,
2962: l_okc_k_headers_tl_rec.COMMENTS,
2963: l_okc_k_headers_tl_rec.DESCRIPTION,
2964: l_okc_k_headers_tl_rec.COGNOMEN,

Line 2961: l_okc_k_headers_tl_rec.SHORT_DESCRIPTION,

2957: l_okc_k_headers_tl_rec.ID,
2958: l_okc_k_headers_tl_rec.LANGUAGE,
2959: l_okc_k_headers_tl_rec.SOURCE_LANG,
2960: l_okc_k_headers_tl_rec.SFWT_FLAG,
2961: l_okc_k_headers_tl_rec.SHORT_DESCRIPTION,
2962: l_okc_k_headers_tl_rec.COMMENTS,
2963: l_okc_k_headers_tl_rec.DESCRIPTION,
2964: l_okc_k_headers_tl_rec.COGNOMEN,
2965: l_okc_k_headers_tl_rec.NON_RESPONSE_REASON,

Line 2962: l_okc_k_headers_tl_rec.COMMENTS,

2958: l_okc_k_headers_tl_rec.LANGUAGE,
2959: l_okc_k_headers_tl_rec.SOURCE_LANG,
2960: l_okc_k_headers_tl_rec.SFWT_FLAG,
2961: l_okc_k_headers_tl_rec.SHORT_DESCRIPTION,
2962: l_okc_k_headers_tl_rec.COMMENTS,
2963: l_okc_k_headers_tl_rec.DESCRIPTION,
2964: l_okc_k_headers_tl_rec.COGNOMEN,
2965: l_okc_k_headers_tl_rec.NON_RESPONSE_REASON,
2966: l_okc_k_headers_tl_rec.NON_RESPONSE_EXPLAIN,

Line 2963: l_okc_k_headers_tl_rec.DESCRIPTION,

2959: l_okc_k_headers_tl_rec.SOURCE_LANG,
2960: l_okc_k_headers_tl_rec.SFWT_FLAG,
2961: l_okc_k_headers_tl_rec.SHORT_DESCRIPTION,
2962: l_okc_k_headers_tl_rec.COMMENTS,
2963: l_okc_k_headers_tl_rec.DESCRIPTION,
2964: l_okc_k_headers_tl_rec.COGNOMEN,
2965: l_okc_k_headers_tl_rec.NON_RESPONSE_REASON,
2966: l_okc_k_headers_tl_rec.NON_RESPONSE_EXPLAIN,
2967: l_okc_k_headers_tl_rec.SET_ASIDE_REASON,

Line 2964: l_okc_k_headers_tl_rec.COGNOMEN,

2960: l_okc_k_headers_tl_rec.SFWT_FLAG,
2961: l_okc_k_headers_tl_rec.SHORT_DESCRIPTION,
2962: l_okc_k_headers_tl_rec.COMMENTS,
2963: l_okc_k_headers_tl_rec.DESCRIPTION,
2964: l_okc_k_headers_tl_rec.COGNOMEN,
2965: l_okc_k_headers_tl_rec.NON_RESPONSE_REASON,
2966: l_okc_k_headers_tl_rec.NON_RESPONSE_EXPLAIN,
2967: l_okc_k_headers_tl_rec.SET_ASIDE_REASON,
2968: l_okc_k_headers_tl_rec.CREATED_BY,

Line 2965: l_okc_k_headers_tl_rec.NON_RESPONSE_REASON,

2961: l_okc_k_headers_tl_rec.SHORT_DESCRIPTION,
2962: l_okc_k_headers_tl_rec.COMMENTS,
2963: l_okc_k_headers_tl_rec.DESCRIPTION,
2964: l_okc_k_headers_tl_rec.COGNOMEN,
2965: l_okc_k_headers_tl_rec.NON_RESPONSE_REASON,
2966: l_okc_k_headers_tl_rec.NON_RESPONSE_EXPLAIN,
2967: l_okc_k_headers_tl_rec.SET_ASIDE_REASON,
2968: l_okc_k_headers_tl_rec.CREATED_BY,
2969: l_okc_k_headers_tl_rec.CREATION_DATE,

Line 2966: l_okc_k_headers_tl_rec.NON_RESPONSE_EXPLAIN,

2962: l_okc_k_headers_tl_rec.COMMENTS,
2963: l_okc_k_headers_tl_rec.DESCRIPTION,
2964: l_okc_k_headers_tl_rec.COGNOMEN,
2965: l_okc_k_headers_tl_rec.NON_RESPONSE_REASON,
2966: l_okc_k_headers_tl_rec.NON_RESPONSE_EXPLAIN,
2967: l_okc_k_headers_tl_rec.SET_ASIDE_REASON,
2968: l_okc_k_headers_tl_rec.CREATED_BY,
2969: l_okc_k_headers_tl_rec.CREATION_DATE,
2970: l_okc_k_headers_tl_rec.LAST_UPDATED_BY,

Line 2967: l_okc_k_headers_tl_rec.SET_ASIDE_REASON,

2963: l_okc_k_headers_tl_rec.DESCRIPTION,
2964: l_okc_k_headers_tl_rec.COGNOMEN,
2965: l_okc_k_headers_tl_rec.NON_RESPONSE_REASON,
2966: l_okc_k_headers_tl_rec.NON_RESPONSE_EXPLAIN,
2967: l_okc_k_headers_tl_rec.SET_ASIDE_REASON,
2968: l_okc_k_headers_tl_rec.CREATED_BY,
2969: l_okc_k_headers_tl_rec.CREATION_DATE,
2970: l_okc_k_headers_tl_rec.LAST_UPDATED_BY,
2971: l_okc_k_headers_tl_rec.LAST_UPDATE_DATE,

Line 2968: l_okc_k_headers_tl_rec.CREATED_BY,

2964: l_okc_k_headers_tl_rec.COGNOMEN,
2965: l_okc_k_headers_tl_rec.NON_RESPONSE_REASON,
2966: l_okc_k_headers_tl_rec.NON_RESPONSE_EXPLAIN,
2967: l_okc_k_headers_tl_rec.SET_ASIDE_REASON,
2968: l_okc_k_headers_tl_rec.CREATED_BY,
2969: l_okc_k_headers_tl_rec.CREATION_DATE,
2970: l_okc_k_headers_tl_rec.LAST_UPDATED_BY,
2971: l_okc_k_headers_tl_rec.LAST_UPDATE_DATE,
2972: l_okc_k_headers_tl_rec.LAST_UPDATE_LOGIN;

Line 2969: l_okc_k_headers_tl_rec.CREATION_DATE,

2965: l_okc_k_headers_tl_rec.NON_RESPONSE_REASON,
2966: l_okc_k_headers_tl_rec.NON_RESPONSE_EXPLAIN,
2967: l_okc_k_headers_tl_rec.SET_ASIDE_REASON,
2968: l_okc_k_headers_tl_rec.CREATED_BY,
2969: l_okc_k_headers_tl_rec.CREATION_DATE,
2970: l_okc_k_headers_tl_rec.LAST_UPDATED_BY,
2971: l_okc_k_headers_tl_rec.LAST_UPDATE_DATE,
2972: l_okc_k_headers_tl_rec.LAST_UPDATE_LOGIN;
2973: x_no_data_found := chr_pktl_csr%NOTFOUND;

Line 2970: l_okc_k_headers_tl_rec.LAST_UPDATED_BY,

2966: l_okc_k_headers_tl_rec.NON_RESPONSE_EXPLAIN,
2967: l_okc_k_headers_tl_rec.SET_ASIDE_REASON,
2968: l_okc_k_headers_tl_rec.CREATED_BY,
2969: l_okc_k_headers_tl_rec.CREATION_DATE,
2970: l_okc_k_headers_tl_rec.LAST_UPDATED_BY,
2971: l_okc_k_headers_tl_rec.LAST_UPDATE_DATE,
2972: l_okc_k_headers_tl_rec.LAST_UPDATE_LOGIN;
2973: x_no_data_found := chr_pktl_csr%NOTFOUND;
2974: CLOSE chr_pktl_csr;

Line 2971: l_okc_k_headers_tl_rec.LAST_UPDATE_DATE,

2967: l_okc_k_headers_tl_rec.SET_ASIDE_REASON,
2968: l_okc_k_headers_tl_rec.CREATED_BY,
2969: l_okc_k_headers_tl_rec.CREATION_DATE,
2970: l_okc_k_headers_tl_rec.LAST_UPDATED_BY,
2971: l_okc_k_headers_tl_rec.LAST_UPDATE_DATE,
2972: l_okc_k_headers_tl_rec.LAST_UPDATE_LOGIN;
2973: x_no_data_found := chr_pktl_csr%NOTFOUND;
2974: CLOSE chr_pktl_csr;
2975: RETURN(l_okc_k_headers_tl_rec);

Line 2972: l_okc_k_headers_tl_rec.LAST_UPDATE_LOGIN;

2968: l_okc_k_headers_tl_rec.CREATED_BY,
2969: l_okc_k_headers_tl_rec.CREATION_DATE,
2970: l_okc_k_headers_tl_rec.LAST_UPDATED_BY,
2971: l_okc_k_headers_tl_rec.LAST_UPDATE_DATE,
2972: l_okc_k_headers_tl_rec.LAST_UPDATE_LOGIN;
2973: x_no_data_found := chr_pktl_csr%NOTFOUND;
2974: CLOSE chr_pktl_csr;
2975: RETURN(l_okc_k_headers_tl_rec);
2976:

Line 2975: RETURN(l_okc_k_headers_tl_rec);

2971: l_okc_k_headers_tl_rec.LAST_UPDATE_DATE,
2972: l_okc_k_headers_tl_rec.LAST_UPDATE_LOGIN;
2973: x_no_data_found := chr_pktl_csr%NOTFOUND;
2974: CLOSE chr_pktl_csr;
2975: RETURN(l_okc_k_headers_tl_rec);
2976:
2977: END get_rec;
2978:
2979: FUNCTION get_rec (

Line 2980: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type

2976:
2977: END get_rec;
2978:
2979: FUNCTION get_rec (
2980: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type
2981: ) RETURN okc_k_headers_tl_rec_type IS
2982: l_row_notfound BOOLEAN := TRUE;
2983: BEGIN
2984:

Line 2981: ) RETURN okc_k_headers_tl_rec_type IS

2977: END get_rec;
2978:
2979: FUNCTION get_rec (
2980: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type
2981: ) RETURN okc_k_headers_tl_rec_type IS
2982: l_row_notfound BOOLEAN := TRUE;
2983: BEGIN
2984:
2985: IF (l_debug = 'Y') THEN

Line 2990: RETURN(get_rec(p_okc_k_headers_tl_rec, l_row_notfound));

2986: okc_debug.Set_Indentation('OKC_CHR_PVT');
2987: okc_debug.LOG('10500: Entered get_rec', 2);
2988: END IF;
2989:
2990: RETURN(get_rec(p_okc_k_headers_tl_rec, l_row_notfound));
2991:
2992: END get_rec;
2993: ---------------------------------------------------------------------------
2994: -- FUNCTION get_rec for: OKC_K_HEADERS_V

Line 4473: p_to IN OUT NOCOPY okc_k_headers_tl_rec_type

4469:
4470: END migrate;
4471: PROCEDURE migrate (
4472: p_from IN chrv_rec_type,
4473: p_to IN OUT NOCOPY okc_k_headers_tl_rec_type
4474: ) IS
4475: BEGIN
4476:
4477: IF (l_debug = 'Y') THEN

Line 4499: p_from IN okc_k_headers_tl_rec_type,

4495: p_to.last_update_login := p_from.last_update_login;
4496:
4497: END migrate;
4498: PROCEDURE migrate (
4499: p_from IN okc_k_headers_tl_rec_type,
4500: p_to IN OUT NOCOPY chrv_rec_type
4501: ) IS
4502: BEGIN
4503:

Line 4545: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

4541: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
4542: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4543: l_chrv_rec chrv_rec_type := p_chrv_rec;
4544: l_chr_rec chr_rec_type;
4545: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
4546: BEGIN
4547:
4548: IF (l_debug = 'Y') THEN
4549: okc_debug.Set_Indentation('OKC_CHR_PVT');

Line 5080: -- insert_row for:OKC_K_HEADERS_TL --

5076: );
5077:
5078: END insert_row;
5079: -------------------------------------
5080: -- insert_row for:OKC_K_HEADERS_TL --
5081: -------------------------------------
5082: PROCEDURE insert_row(
5083: p_init_msg_list IN VARCHAR2,
5084: x_return_status OUT NOCOPY VARCHAR2,

Line 5087: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,

5083: p_init_msg_list IN VARCHAR2,
5084: x_return_status OUT NOCOPY VARCHAR2,
5085: x_msg_count OUT NOCOPY NUMBER,
5086: x_msg_data OUT NOCOPY VARCHAR2,
5087: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
5088: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type) IS
5089:
5090: l_api_version CONSTANT NUMBER := 1;
5091: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 5088: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type) IS

5084: x_return_status OUT NOCOPY VARCHAR2,
5085: x_msg_count OUT NOCOPY NUMBER,
5086: x_msg_data OUT NOCOPY VARCHAR2,
5087: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
5088: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type) IS
5089:
5090: l_api_version CONSTANT NUMBER := 1;
5091: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
5092: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 5093: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type := p_okc_k_headers_tl_rec;

5089:
5090: l_api_version CONSTANT NUMBER := 1;
5091: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
5092: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5093: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type := p_okc_k_headers_tl_rec;
5094: l_def_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
5095: CURSOR get_languages IS
5096: SELECT *
5097: FROM FND_LANGUAGES

Line 5094: l_def_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

5090: l_api_version CONSTANT NUMBER := 1;
5091: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
5092: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5093: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type := p_okc_k_headers_tl_rec;
5094: l_def_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
5095: CURSOR get_languages IS
5096: SELECT *
5097: FROM FND_LANGUAGES
5098: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 5100: -- Set_Attributes for:OKC_K_HEADERS_TL --

5096: SELECT *
5097: FROM FND_LANGUAGES
5098: WHERE INSTALLED_FLAG IN ('I', 'B');
5099: -----------------------------------------
5100: -- Set_Attributes for:OKC_K_HEADERS_TL --
5101: -----------------------------------------
5102: FUNCTION Set_Attributes (
5103: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
5104: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type

Line 5103: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,

5099: -----------------------------------------
5100: -- Set_Attributes for:OKC_K_HEADERS_TL --
5101: -----------------------------------------
5102: FUNCTION Set_Attributes (
5103: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
5104: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type
5105: ) RETURN VARCHAR2 IS
5106: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5107: BEGIN

Line 5104: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type

5100: -- Set_Attributes for:OKC_K_HEADERS_TL --
5101: -----------------------------------------
5102: FUNCTION Set_Attributes (
5103: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
5104: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type
5105: ) RETURN VARCHAR2 IS
5106: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5107: BEGIN
5108:

Line 5114: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;

5110: okc_debug.Set_Indentation('OKC_CHR_PVT');
5111: okc_debug.LOG('14200: Entered Set_Attributes', 2);
5112: END IF;
5113:
5114: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
5115: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5116: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5117: RETURN(l_return_status);
5118:

Line 5115: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

5111: okc_debug.LOG('14200: Entered Set_Attributes', 2);
5112: END IF;
5113:
5114: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
5115: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5116: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5117: RETURN(l_return_status);
5118:
5119: END Set_Attributes;

Line 5116: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

5112: END IF;
5113:
5114: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
5115: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
5116: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
5117: RETURN(l_return_status);
5118:
5119: END Set_Attributes;
5120: BEGIN

Line 5138: p_okc_k_headers_tl_rec, -- IN

5134: RAISE OKC_API.G_EXCEPTION_ERROR;
5135: END IF;
5136: --- Setting item attributes
5137: l_return_status := Set_Attributes(
5138: p_okc_k_headers_tl_rec, -- IN
5139: l_okc_k_headers_tl_rec); -- OUT
5140: --- If any errors happen abort API
5141: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5142: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5139: l_okc_k_headers_tl_rec); -- OUT

5135: END IF;
5136: --- Setting item attributes
5137: l_return_status := Set_Attributes(
5138: p_okc_k_headers_tl_rec, -- IN
5139: l_okc_k_headers_tl_rec); -- OUT
5140: --- If any errors happen abort API
5141: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5142: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5143: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5147: l_okc_k_headers_tl_rec.language := l_lang_rec.language_code;

5143: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5144: RAISE OKC_API.G_EXCEPTION_ERROR;
5145: END IF;
5146: FOR l_lang_rec IN get_languages LOOP
5147: l_okc_k_headers_tl_rec.language := l_lang_rec.language_code;
5148: INSERT INTO OKC_K_HEADERS_TL(
5149: id,
5150: language,
5151: source_lang,

Line 5148: INSERT INTO OKC_K_HEADERS_TL(

5144: RAISE OKC_API.G_EXCEPTION_ERROR;
5145: END IF;
5146: FOR l_lang_rec IN get_languages LOOP
5147: l_okc_k_headers_tl_rec.language := l_lang_rec.language_code;
5148: INSERT INTO OKC_K_HEADERS_TL(
5149: id,
5150: language,
5151: source_lang,
5152: sfwt_flag,

Line 5166: l_okc_k_headers_tl_rec.id,

5162: last_updated_by,
5163: last_update_date,
5164: last_update_login)
5165: VALUES (
5166: l_okc_k_headers_tl_rec.id,
5167: l_okc_k_headers_tl_rec.language,
5168: l_okc_k_headers_tl_rec.source_lang,
5169: l_okc_k_headers_tl_rec.sfwt_flag,
5170: l_okc_k_headers_tl_rec.short_description,

Line 5167: l_okc_k_headers_tl_rec.language,

5163: last_update_date,
5164: last_update_login)
5165: VALUES (
5166: l_okc_k_headers_tl_rec.id,
5167: l_okc_k_headers_tl_rec.language,
5168: l_okc_k_headers_tl_rec.source_lang,
5169: l_okc_k_headers_tl_rec.sfwt_flag,
5170: l_okc_k_headers_tl_rec.short_description,
5171: l_okc_k_headers_tl_rec.comments,

Line 5168: l_okc_k_headers_tl_rec.source_lang,

5164: last_update_login)
5165: VALUES (
5166: l_okc_k_headers_tl_rec.id,
5167: l_okc_k_headers_tl_rec.language,
5168: l_okc_k_headers_tl_rec.source_lang,
5169: l_okc_k_headers_tl_rec.sfwt_flag,
5170: l_okc_k_headers_tl_rec.short_description,
5171: l_okc_k_headers_tl_rec.comments,
5172: l_okc_k_headers_tl_rec.description,

Line 5169: l_okc_k_headers_tl_rec.sfwt_flag,

5165: VALUES (
5166: l_okc_k_headers_tl_rec.id,
5167: l_okc_k_headers_tl_rec.language,
5168: l_okc_k_headers_tl_rec.source_lang,
5169: l_okc_k_headers_tl_rec.sfwt_flag,
5170: l_okc_k_headers_tl_rec.short_description,
5171: l_okc_k_headers_tl_rec.comments,
5172: l_okc_k_headers_tl_rec.description,
5173: l_okc_k_headers_tl_rec.cognomen,

Line 5170: l_okc_k_headers_tl_rec.short_description,

5166: l_okc_k_headers_tl_rec.id,
5167: l_okc_k_headers_tl_rec.language,
5168: l_okc_k_headers_tl_rec.source_lang,
5169: l_okc_k_headers_tl_rec.sfwt_flag,
5170: l_okc_k_headers_tl_rec.short_description,
5171: l_okc_k_headers_tl_rec.comments,
5172: l_okc_k_headers_tl_rec.description,
5173: l_okc_k_headers_tl_rec.cognomen,
5174: l_okc_k_headers_tl_rec.non_response_reason,

Line 5171: l_okc_k_headers_tl_rec.comments,

5167: l_okc_k_headers_tl_rec.language,
5168: l_okc_k_headers_tl_rec.source_lang,
5169: l_okc_k_headers_tl_rec.sfwt_flag,
5170: l_okc_k_headers_tl_rec.short_description,
5171: l_okc_k_headers_tl_rec.comments,
5172: l_okc_k_headers_tl_rec.description,
5173: l_okc_k_headers_tl_rec.cognomen,
5174: l_okc_k_headers_tl_rec.non_response_reason,
5175: l_okc_k_headers_tl_rec.non_response_explain,

Line 5172: l_okc_k_headers_tl_rec.description,

5168: l_okc_k_headers_tl_rec.source_lang,
5169: l_okc_k_headers_tl_rec.sfwt_flag,
5170: l_okc_k_headers_tl_rec.short_description,
5171: l_okc_k_headers_tl_rec.comments,
5172: l_okc_k_headers_tl_rec.description,
5173: l_okc_k_headers_tl_rec.cognomen,
5174: l_okc_k_headers_tl_rec.non_response_reason,
5175: l_okc_k_headers_tl_rec.non_response_explain,
5176: l_okc_k_headers_tl_rec.set_aside_reason,

Line 5173: l_okc_k_headers_tl_rec.cognomen,

5169: l_okc_k_headers_tl_rec.sfwt_flag,
5170: l_okc_k_headers_tl_rec.short_description,
5171: l_okc_k_headers_tl_rec.comments,
5172: l_okc_k_headers_tl_rec.description,
5173: l_okc_k_headers_tl_rec.cognomen,
5174: l_okc_k_headers_tl_rec.non_response_reason,
5175: l_okc_k_headers_tl_rec.non_response_explain,
5176: l_okc_k_headers_tl_rec.set_aside_reason,
5177: l_okc_k_headers_tl_rec.created_by,

Line 5174: l_okc_k_headers_tl_rec.non_response_reason,

5170: l_okc_k_headers_tl_rec.short_description,
5171: l_okc_k_headers_tl_rec.comments,
5172: l_okc_k_headers_tl_rec.description,
5173: l_okc_k_headers_tl_rec.cognomen,
5174: l_okc_k_headers_tl_rec.non_response_reason,
5175: l_okc_k_headers_tl_rec.non_response_explain,
5176: l_okc_k_headers_tl_rec.set_aside_reason,
5177: l_okc_k_headers_tl_rec.created_by,
5178: l_okc_k_headers_tl_rec.creation_date,

Line 5175: l_okc_k_headers_tl_rec.non_response_explain,

5171: l_okc_k_headers_tl_rec.comments,
5172: l_okc_k_headers_tl_rec.description,
5173: l_okc_k_headers_tl_rec.cognomen,
5174: l_okc_k_headers_tl_rec.non_response_reason,
5175: l_okc_k_headers_tl_rec.non_response_explain,
5176: l_okc_k_headers_tl_rec.set_aside_reason,
5177: l_okc_k_headers_tl_rec.created_by,
5178: l_okc_k_headers_tl_rec.creation_date,
5179: l_okc_k_headers_tl_rec.last_updated_by,

Line 5176: l_okc_k_headers_tl_rec.set_aside_reason,

5172: l_okc_k_headers_tl_rec.description,
5173: l_okc_k_headers_tl_rec.cognomen,
5174: l_okc_k_headers_tl_rec.non_response_reason,
5175: l_okc_k_headers_tl_rec.non_response_explain,
5176: l_okc_k_headers_tl_rec.set_aside_reason,
5177: l_okc_k_headers_tl_rec.created_by,
5178: l_okc_k_headers_tl_rec.creation_date,
5179: l_okc_k_headers_tl_rec.last_updated_by,
5180: l_okc_k_headers_tl_rec.last_update_date,

Line 5177: l_okc_k_headers_tl_rec.created_by,

5173: l_okc_k_headers_tl_rec.cognomen,
5174: l_okc_k_headers_tl_rec.non_response_reason,
5175: l_okc_k_headers_tl_rec.non_response_explain,
5176: l_okc_k_headers_tl_rec.set_aside_reason,
5177: l_okc_k_headers_tl_rec.created_by,
5178: l_okc_k_headers_tl_rec.creation_date,
5179: l_okc_k_headers_tl_rec.last_updated_by,
5180: l_okc_k_headers_tl_rec.last_update_date,
5181: l_okc_k_headers_tl_rec.last_update_login);

Line 5178: l_okc_k_headers_tl_rec.creation_date,

5174: l_okc_k_headers_tl_rec.non_response_reason,
5175: l_okc_k_headers_tl_rec.non_response_explain,
5176: l_okc_k_headers_tl_rec.set_aside_reason,
5177: l_okc_k_headers_tl_rec.created_by,
5178: l_okc_k_headers_tl_rec.creation_date,
5179: l_okc_k_headers_tl_rec.last_updated_by,
5180: l_okc_k_headers_tl_rec.last_update_date,
5181: l_okc_k_headers_tl_rec.last_update_login);
5182: END LOOP;

Line 5179: l_okc_k_headers_tl_rec.last_updated_by,

5175: l_okc_k_headers_tl_rec.non_response_explain,
5176: l_okc_k_headers_tl_rec.set_aside_reason,
5177: l_okc_k_headers_tl_rec.created_by,
5178: l_okc_k_headers_tl_rec.creation_date,
5179: l_okc_k_headers_tl_rec.last_updated_by,
5180: l_okc_k_headers_tl_rec.last_update_date,
5181: l_okc_k_headers_tl_rec.last_update_login);
5182: END LOOP;
5183: -- Set OUT values

Line 5180: l_okc_k_headers_tl_rec.last_update_date,

5176: l_okc_k_headers_tl_rec.set_aside_reason,
5177: l_okc_k_headers_tl_rec.created_by,
5178: l_okc_k_headers_tl_rec.creation_date,
5179: l_okc_k_headers_tl_rec.last_updated_by,
5180: l_okc_k_headers_tl_rec.last_update_date,
5181: l_okc_k_headers_tl_rec.last_update_login);
5182: END LOOP;
5183: -- Set OUT values
5184: x_okc_k_headers_tl_rec := l_okc_k_headers_tl_rec;

Line 5181: l_okc_k_headers_tl_rec.last_update_login);

5177: l_okc_k_headers_tl_rec.created_by,
5178: l_okc_k_headers_tl_rec.creation_date,
5179: l_okc_k_headers_tl_rec.last_updated_by,
5180: l_okc_k_headers_tl_rec.last_update_date,
5181: l_okc_k_headers_tl_rec.last_update_login);
5182: END LOOP;
5183: -- Set OUT values
5184: x_okc_k_headers_tl_rec := l_okc_k_headers_tl_rec;
5185: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 5184: x_okc_k_headers_tl_rec := l_okc_k_headers_tl_rec;

5180: l_okc_k_headers_tl_rec.last_update_date,
5181: l_okc_k_headers_tl_rec.last_update_login);
5182: END LOOP;
5183: -- Set OUT values
5184: x_okc_k_headers_tl_rec := l_okc_k_headers_tl_rec;
5185: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5186: IF (l_debug = 'Y') THEN
5187: okc_debug.LOG('14400: Exiting insert_row', 2);
5188: okc_debug.Reset_Indentation;

Line 5262: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

5258: l_chrv_rec chrv_rec_type;
5259: l_def_chrv_rec chrv_rec_type;
5260: l_chr_rec chr_rec_type;
5261: lx_chr_rec chr_rec_type;
5262: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
5263: lx_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
5264: -------------------------------
5265: -- FUNCTION fill_who_columns --
5266: -------------------------------

Line 5263: lx_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

5259: l_def_chrv_rec chrv_rec_type;
5260: l_chr_rec chr_rec_type;
5261: lx_chr_rec chr_rec_type;
5262: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
5263: lx_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
5264: -------------------------------
5265: -- FUNCTION fill_who_columns --
5266: -------------------------------
5267: FUNCTION fill_who_columns (

Line 5389: migrate(l_def_chrv_rec, l_okc_k_headers_tl_rec);

5385: --------------------------------------
5386: -- Move VIEW record to "Child" records
5387: --------------------------------------
5388: migrate(l_def_chrv_rec, l_chr_rec);
5389: migrate(l_def_chrv_rec, l_okc_k_headers_tl_rec);
5390:
5391: --------------------------------------------
5392: -- Call the INSERT_ROW for each child record
5393: --------------------------------------------

Line 5413: l_okc_k_headers_tl_rec,

5409: p_init_msg_list,
5410: x_return_status,
5411: x_msg_count,
5412: x_msg_data,
5413: l_okc_k_headers_tl_rec,
5414: lx_okc_k_headers_tl_rec
5415: );
5416: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5414: lx_okc_k_headers_tl_rec

5410: x_return_status,
5411: x_msg_count,
5412: x_msg_data,
5413: l_okc_k_headers_tl_rec,
5414: lx_okc_k_headers_tl_rec
5415: );
5416: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5418: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5421: migrate(lx_okc_k_headers_tl_rec, l_def_chrv_rec);

5417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5418: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5419: RAISE OKC_API.G_EXCEPTION_ERROR;
5420: END IF;
5421: migrate(lx_okc_k_headers_tl_rec, l_def_chrv_rec);
5422: -- Set OUT values
5423: x_chrv_rec := l_def_chrv_rec;
5424: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5425: IF (l_debug = 'Y') THEN

Line 5777: -- lock_row for:OKC_K_HEADERS_TL --

5773: );
5774:
5775: END lock_row;
5776: -----------------------------------
5777: -- lock_row for:OKC_K_HEADERS_TL --
5778: -----------------------------------
5779: PROCEDURE lock_row(
5780: p_init_msg_list IN VARCHAR2,
5781: x_return_status OUT NOCOPY VARCHAR2,

Line 5784: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type) IS

5780: p_init_msg_list IN VARCHAR2,
5781: x_return_status OUT NOCOPY VARCHAR2,
5782: x_msg_count OUT NOCOPY NUMBER,
5783: x_msg_data OUT NOCOPY VARCHAR2,
5784: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type) IS
5785:
5786: E_Resource_Busy EXCEPTION;
5787: PRAGMA EXCEPTION_INIT(E_Resource_Busy, - 00054);
5788: CURSOR lock_csr (p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type) IS

Line 5788: CURSOR lock_csr (p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type) IS

5784: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type) IS
5785:
5786: E_Resource_Busy EXCEPTION;
5787: PRAGMA EXCEPTION_INIT(E_Resource_Busy, - 00054);
5788: CURSOR lock_csr (p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type) IS
5789: SELECT *
5790: FROM OKC_K_HEADERS_TL
5791: WHERE ID = p_okc_k_headers_tl_rec.id
5792: FOR UPDATE NOWAIT;

Line 5790: FROM OKC_K_HEADERS_TL

5786: E_Resource_Busy EXCEPTION;
5787: PRAGMA EXCEPTION_INIT(E_Resource_Busy, - 00054);
5788: CURSOR lock_csr (p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type) IS
5789: SELECT *
5790: FROM OKC_K_HEADERS_TL
5791: WHERE ID = p_okc_k_headers_tl_rec.id
5792: FOR UPDATE NOWAIT;
5793:
5794: l_api_version CONSTANT NUMBER := 1;

Line 5791: WHERE ID = p_okc_k_headers_tl_rec.id

5787: PRAGMA EXCEPTION_INIT(E_Resource_Busy, - 00054);
5788: CURSOR lock_csr (p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type) IS
5789: SELECT *
5790: FROM OKC_K_HEADERS_TL
5791: WHERE ID = p_okc_k_headers_tl_rec.id
5792: FOR UPDATE NOWAIT;
5793:
5794: l_api_version CONSTANT NUMBER := 1;
5795: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 5823: OPEN lock_csr(p_okc_k_headers_tl_rec);

5819: okc_debug.Set_Indentation('OKC_CHR_PVT');
5820: okc_debug.LOG('16900: Entered lock_row', 2);
5821: END IF;
5822:
5823: OPEN lock_csr(p_okc_k_headers_tl_rec);
5824: FETCH lock_csr INTO l_lock_var;
5825: l_row_notfound := lock_csr%NOTFOUND;
5826: CLOSE lock_csr;
5827: IF (l_debug = 'Y') THEN

Line 5925: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

5921: l_api_version CONSTANT NUMBER := 1;
5922: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
5923: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5924: l_chr_rec chr_rec_type;
5925: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
5926: BEGIN
5927:
5928: IF (l_debug = 'Y') THEN
5929: okc_debug.Set_Indentation('OKC_CHR_PVT');

Line 5949: migrate(p_chrv_rec, l_okc_k_headers_tl_rec);

5945: --------------------------------------
5946: -- Move VIEW record to "Child" records
5947: --------------------------------------
5948: migrate(p_chrv_rec, l_chr_rec);
5949: migrate(p_chrv_rec, l_okc_k_headers_tl_rec);
5950: --------------------------------------------
5951: -- Call the LOCK_ROW for each child record
5952: --------------------------------------------
5953: lock_row(

Line 5970: l_okc_k_headers_tl_rec

5966: p_init_msg_list,
5967: x_return_status,
5968: x_msg_count,
5969: x_msg_data,
5970: l_okc_k_headers_tl_rec
5971: );
5972: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5973: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5974: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 6782: -- update_row for:OKC_K_HEADERS_TL --

6778: );
6779:
6780: END update_row;
6781: -------------------------------------
6782: -- update_row for:OKC_K_HEADERS_TL --
6783: -------------------------------------
6784: PROCEDURE update_row(
6785: p_init_msg_list IN VARCHAR2,
6786: x_return_status OUT NOCOPY VARCHAR2,

Line 6789: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,

6785: p_init_msg_list IN VARCHAR2,
6786: x_return_status OUT NOCOPY VARCHAR2,
6787: x_msg_count OUT NOCOPY NUMBER,
6788: x_msg_data OUT NOCOPY VARCHAR2,
6789: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
6790: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type) IS
6791:
6792: l_api_version CONSTANT NUMBER := 1;
6793: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 6790: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type) IS

6786: x_return_status OUT NOCOPY VARCHAR2,
6787: x_msg_count OUT NOCOPY NUMBER,
6788: x_msg_data OUT NOCOPY VARCHAR2,
6789: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
6790: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type) IS
6791:
6792: l_api_version CONSTANT NUMBER := 1;
6793: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
6794: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 6795: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type := p_okc_k_headers_tl_rec;

6791:
6792: l_api_version CONSTANT NUMBER := 1;
6793: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
6794: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6795: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type := p_okc_k_headers_tl_rec;
6796: l_def_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
6797: l_row_notfound BOOLEAN := TRUE;
6798: ----------------------------------
6799: -- FUNCTION populate_new_record --

Line 6796: l_def_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

6792: l_api_version CONSTANT NUMBER := 1;
6793: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
6794: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6795: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type := p_okc_k_headers_tl_rec;
6796: l_def_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
6797: l_row_notfound BOOLEAN := TRUE;
6798: ----------------------------------
6799: -- FUNCTION populate_new_record --
6800: ----------------------------------

Line 6802: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,

6798: ----------------------------------
6799: -- FUNCTION populate_new_record --
6800: ----------------------------------
6801: FUNCTION populate_new_record (
6802: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
6803: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type
6804: ) RETURN VARCHAR2 IS
6805: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
6806: l_row_notfound BOOLEAN := TRUE;

Line 6803: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type

6799: -- FUNCTION populate_new_record --
6800: ----------------------------------
6801: FUNCTION populate_new_record (
6802: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
6803: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type
6804: ) RETURN VARCHAR2 IS
6805: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
6806: l_row_notfound BOOLEAN := TRUE;
6807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 6805: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

6801: FUNCTION populate_new_record (
6802: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
6803: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type
6804: ) RETURN VARCHAR2 IS
6805: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
6806: l_row_notfound BOOLEAN := TRUE;
6807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6808: BEGIN
6809:

Line 6815: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;

6811: okc_debug.Set_Indentation('OKC_CHR_PVT');
6812: okc_debug.LOG('19300: Entered populate_new_record', 2);
6813: END IF;
6814:
6815: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
6816: -- Get current database values
6817: l_okc_k_headers_tl_rec := get_rec(p_okc_k_headers_tl_rec, l_row_notfound);
6818: IF (l_row_notfound) THEN
6819: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 6817: l_okc_k_headers_tl_rec := get_rec(p_okc_k_headers_tl_rec, l_row_notfound);

6813: END IF;
6814:
6815: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
6816: -- Get current database values
6817: l_okc_k_headers_tl_rec := get_rec(p_okc_k_headers_tl_rec, l_row_notfound);
6818: IF (l_row_notfound) THEN
6819: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6820: END IF;
6821: IF (x_okc_k_headers_tl_rec.id = OKC_API.G_MISS_NUM)

Line 6821: IF (x_okc_k_headers_tl_rec.id = OKC_API.G_MISS_NUM)

6817: l_okc_k_headers_tl_rec := get_rec(p_okc_k_headers_tl_rec, l_row_notfound);
6818: IF (l_row_notfound) THEN
6819: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6820: END IF;
6821: IF (x_okc_k_headers_tl_rec.id = OKC_API.G_MISS_NUM)
6822: THEN
6823: x_okc_k_headers_tl_rec.id := l_okc_k_headers_tl_rec.id;
6824: END IF;
6825: IF (x_okc_k_headers_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 6823: x_okc_k_headers_tl_rec.id := l_okc_k_headers_tl_rec.id;

6819: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6820: END IF;
6821: IF (x_okc_k_headers_tl_rec.id = OKC_API.G_MISS_NUM)
6822: THEN
6823: x_okc_k_headers_tl_rec.id := l_okc_k_headers_tl_rec.id;
6824: END IF;
6825: IF (x_okc_k_headers_tl_rec.language = OKC_API.G_MISS_CHAR)
6826: THEN
6827: x_okc_k_headers_tl_rec.language := l_okc_k_headers_tl_rec.language;

Line 6825: IF (x_okc_k_headers_tl_rec.language = OKC_API.G_MISS_CHAR)

6821: IF (x_okc_k_headers_tl_rec.id = OKC_API.G_MISS_NUM)
6822: THEN
6823: x_okc_k_headers_tl_rec.id := l_okc_k_headers_tl_rec.id;
6824: END IF;
6825: IF (x_okc_k_headers_tl_rec.language = OKC_API.G_MISS_CHAR)
6826: THEN
6827: x_okc_k_headers_tl_rec.language := l_okc_k_headers_tl_rec.language;
6828: END IF;
6829: IF (x_okc_k_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 6827: x_okc_k_headers_tl_rec.language := l_okc_k_headers_tl_rec.language;

6823: x_okc_k_headers_tl_rec.id := l_okc_k_headers_tl_rec.id;
6824: END IF;
6825: IF (x_okc_k_headers_tl_rec.language = OKC_API.G_MISS_CHAR)
6826: THEN
6827: x_okc_k_headers_tl_rec.language := l_okc_k_headers_tl_rec.language;
6828: END IF;
6829: IF (x_okc_k_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6830: THEN
6831: x_okc_k_headers_tl_rec.source_lang := l_okc_k_headers_tl_rec.source_lang;

Line 6829: IF (x_okc_k_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

6825: IF (x_okc_k_headers_tl_rec.language = OKC_API.G_MISS_CHAR)
6826: THEN
6827: x_okc_k_headers_tl_rec.language := l_okc_k_headers_tl_rec.language;
6828: END IF;
6829: IF (x_okc_k_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6830: THEN
6831: x_okc_k_headers_tl_rec.source_lang := l_okc_k_headers_tl_rec.source_lang;
6832: END IF;
6833: IF (x_okc_k_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 6831: x_okc_k_headers_tl_rec.source_lang := l_okc_k_headers_tl_rec.source_lang;

6827: x_okc_k_headers_tl_rec.language := l_okc_k_headers_tl_rec.language;
6828: END IF;
6829: IF (x_okc_k_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6830: THEN
6831: x_okc_k_headers_tl_rec.source_lang := l_okc_k_headers_tl_rec.source_lang;
6832: END IF;
6833: IF (x_okc_k_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6834: THEN
6835: x_okc_k_headers_tl_rec.sfwt_flag := l_okc_k_headers_tl_rec.sfwt_flag;

Line 6833: IF (x_okc_k_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

6829: IF (x_okc_k_headers_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
6830: THEN
6831: x_okc_k_headers_tl_rec.source_lang := l_okc_k_headers_tl_rec.source_lang;
6832: END IF;
6833: IF (x_okc_k_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6834: THEN
6835: x_okc_k_headers_tl_rec.sfwt_flag := l_okc_k_headers_tl_rec.sfwt_flag;
6836: END IF;
6837: IF (x_okc_k_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)

Line 6835: x_okc_k_headers_tl_rec.sfwt_flag := l_okc_k_headers_tl_rec.sfwt_flag;

6831: x_okc_k_headers_tl_rec.source_lang := l_okc_k_headers_tl_rec.source_lang;
6832: END IF;
6833: IF (x_okc_k_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6834: THEN
6835: x_okc_k_headers_tl_rec.sfwt_flag := l_okc_k_headers_tl_rec.sfwt_flag;
6836: END IF;
6837: IF (x_okc_k_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)
6838: THEN
6839: x_okc_k_headers_tl_rec.short_description := l_okc_k_headers_tl_rec.short_description;

Line 6837: IF (x_okc_k_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)

6833: IF (x_okc_k_headers_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
6834: THEN
6835: x_okc_k_headers_tl_rec.sfwt_flag := l_okc_k_headers_tl_rec.sfwt_flag;
6836: END IF;
6837: IF (x_okc_k_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)
6838: THEN
6839: x_okc_k_headers_tl_rec.short_description := l_okc_k_headers_tl_rec.short_description;
6840: END IF;
6841: IF (x_okc_k_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)

Line 6839: x_okc_k_headers_tl_rec.short_description := l_okc_k_headers_tl_rec.short_description;

6835: x_okc_k_headers_tl_rec.sfwt_flag := l_okc_k_headers_tl_rec.sfwt_flag;
6836: END IF;
6837: IF (x_okc_k_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)
6838: THEN
6839: x_okc_k_headers_tl_rec.short_description := l_okc_k_headers_tl_rec.short_description;
6840: END IF;
6841: IF (x_okc_k_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)
6842: THEN
6843: x_okc_k_headers_tl_rec.comments := l_okc_k_headers_tl_rec.comments;

Line 6841: IF (x_okc_k_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)

6837: IF (x_okc_k_headers_tl_rec.short_description = OKC_API.G_MISS_CHAR)
6838: THEN
6839: x_okc_k_headers_tl_rec.short_description := l_okc_k_headers_tl_rec.short_description;
6840: END IF;
6841: IF (x_okc_k_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)
6842: THEN
6843: x_okc_k_headers_tl_rec.comments := l_okc_k_headers_tl_rec.comments;
6844: END IF;
6845: IF (x_okc_k_headers_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 6843: x_okc_k_headers_tl_rec.comments := l_okc_k_headers_tl_rec.comments;

6839: x_okc_k_headers_tl_rec.short_description := l_okc_k_headers_tl_rec.short_description;
6840: END IF;
6841: IF (x_okc_k_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)
6842: THEN
6843: x_okc_k_headers_tl_rec.comments := l_okc_k_headers_tl_rec.comments;
6844: END IF;
6845: IF (x_okc_k_headers_tl_rec.description = OKC_API.G_MISS_CHAR)
6846: THEN
6847: x_okc_k_headers_tl_rec.description := l_okc_k_headers_tl_rec.description;

Line 6845: IF (x_okc_k_headers_tl_rec.description = OKC_API.G_MISS_CHAR)

6841: IF (x_okc_k_headers_tl_rec.comments = OKC_API.G_MISS_CHAR)
6842: THEN
6843: x_okc_k_headers_tl_rec.comments := l_okc_k_headers_tl_rec.comments;
6844: END IF;
6845: IF (x_okc_k_headers_tl_rec.description = OKC_API.G_MISS_CHAR)
6846: THEN
6847: x_okc_k_headers_tl_rec.description := l_okc_k_headers_tl_rec.description;
6848: END IF;
6849: IF (x_okc_k_headers_tl_rec.cognomen = OKC_API.G_MISS_CHAR)

Line 6847: x_okc_k_headers_tl_rec.description := l_okc_k_headers_tl_rec.description;

6843: x_okc_k_headers_tl_rec.comments := l_okc_k_headers_tl_rec.comments;
6844: END IF;
6845: IF (x_okc_k_headers_tl_rec.description = OKC_API.G_MISS_CHAR)
6846: THEN
6847: x_okc_k_headers_tl_rec.description := l_okc_k_headers_tl_rec.description;
6848: END IF;
6849: IF (x_okc_k_headers_tl_rec.cognomen = OKC_API.G_MISS_CHAR)
6850: THEN
6851: x_okc_k_headers_tl_rec.cognomen := l_okc_k_headers_tl_rec.cognomen;

Line 6849: IF (x_okc_k_headers_tl_rec.cognomen = OKC_API.G_MISS_CHAR)

6845: IF (x_okc_k_headers_tl_rec.description = OKC_API.G_MISS_CHAR)
6846: THEN
6847: x_okc_k_headers_tl_rec.description := l_okc_k_headers_tl_rec.description;
6848: END IF;
6849: IF (x_okc_k_headers_tl_rec.cognomen = OKC_API.G_MISS_CHAR)
6850: THEN
6851: x_okc_k_headers_tl_rec.cognomen := l_okc_k_headers_tl_rec.cognomen;
6852: END IF;
6853: IF (x_okc_k_headers_tl_rec.non_response_reason = OKC_API.G_MISS_CHAR)

Line 6851: x_okc_k_headers_tl_rec.cognomen := l_okc_k_headers_tl_rec.cognomen;

6847: x_okc_k_headers_tl_rec.description := l_okc_k_headers_tl_rec.description;
6848: END IF;
6849: IF (x_okc_k_headers_tl_rec.cognomen = OKC_API.G_MISS_CHAR)
6850: THEN
6851: x_okc_k_headers_tl_rec.cognomen := l_okc_k_headers_tl_rec.cognomen;
6852: END IF;
6853: IF (x_okc_k_headers_tl_rec.non_response_reason = OKC_API.G_MISS_CHAR)
6854: THEN
6855: x_okc_k_headers_tl_rec.non_response_reason := l_okc_k_headers_tl_rec.non_response_reason;

Line 6853: IF (x_okc_k_headers_tl_rec.non_response_reason = OKC_API.G_MISS_CHAR)

6849: IF (x_okc_k_headers_tl_rec.cognomen = OKC_API.G_MISS_CHAR)
6850: THEN
6851: x_okc_k_headers_tl_rec.cognomen := l_okc_k_headers_tl_rec.cognomen;
6852: END IF;
6853: IF (x_okc_k_headers_tl_rec.non_response_reason = OKC_API.G_MISS_CHAR)
6854: THEN
6855: x_okc_k_headers_tl_rec.non_response_reason := l_okc_k_headers_tl_rec.non_response_reason;
6856: END IF;
6857: IF (x_okc_k_headers_tl_rec.non_response_explain = OKC_API.G_MISS_CHAR)

Line 6855: x_okc_k_headers_tl_rec.non_response_reason := l_okc_k_headers_tl_rec.non_response_reason;

6851: x_okc_k_headers_tl_rec.cognomen := l_okc_k_headers_tl_rec.cognomen;
6852: END IF;
6853: IF (x_okc_k_headers_tl_rec.non_response_reason = OKC_API.G_MISS_CHAR)
6854: THEN
6855: x_okc_k_headers_tl_rec.non_response_reason := l_okc_k_headers_tl_rec.non_response_reason;
6856: END IF;
6857: IF (x_okc_k_headers_tl_rec.non_response_explain = OKC_API.G_MISS_CHAR)
6858: THEN
6859: x_okc_k_headers_tl_rec.non_response_explain := l_okc_k_headers_tl_rec.non_response_explain;

Line 6857: IF (x_okc_k_headers_tl_rec.non_response_explain = OKC_API.G_MISS_CHAR)

6853: IF (x_okc_k_headers_tl_rec.non_response_reason = OKC_API.G_MISS_CHAR)
6854: THEN
6855: x_okc_k_headers_tl_rec.non_response_reason := l_okc_k_headers_tl_rec.non_response_reason;
6856: END IF;
6857: IF (x_okc_k_headers_tl_rec.non_response_explain = OKC_API.G_MISS_CHAR)
6858: THEN
6859: x_okc_k_headers_tl_rec.non_response_explain := l_okc_k_headers_tl_rec.non_response_explain;
6860: END IF;
6861: IF (x_okc_k_headers_tl_rec.set_aside_reason = OKC_API.G_MISS_CHAR)

Line 6859: x_okc_k_headers_tl_rec.non_response_explain := l_okc_k_headers_tl_rec.non_response_explain;

6855: x_okc_k_headers_tl_rec.non_response_reason := l_okc_k_headers_tl_rec.non_response_reason;
6856: END IF;
6857: IF (x_okc_k_headers_tl_rec.non_response_explain = OKC_API.G_MISS_CHAR)
6858: THEN
6859: x_okc_k_headers_tl_rec.non_response_explain := l_okc_k_headers_tl_rec.non_response_explain;
6860: END IF;
6861: IF (x_okc_k_headers_tl_rec.set_aside_reason = OKC_API.G_MISS_CHAR)
6862: THEN
6863: x_okc_k_headers_tl_rec.set_aside_reason := l_okc_k_headers_tl_rec.set_aside_reason;

Line 6861: IF (x_okc_k_headers_tl_rec.set_aside_reason = OKC_API.G_MISS_CHAR)

6857: IF (x_okc_k_headers_tl_rec.non_response_explain = OKC_API.G_MISS_CHAR)
6858: THEN
6859: x_okc_k_headers_tl_rec.non_response_explain := l_okc_k_headers_tl_rec.non_response_explain;
6860: END IF;
6861: IF (x_okc_k_headers_tl_rec.set_aside_reason = OKC_API.G_MISS_CHAR)
6862: THEN
6863: x_okc_k_headers_tl_rec.set_aside_reason := l_okc_k_headers_tl_rec.set_aside_reason;
6864: END IF;
6865: IF (x_okc_k_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 6863: x_okc_k_headers_tl_rec.set_aside_reason := l_okc_k_headers_tl_rec.set_aside_reason;

6859: x_okc_k_headers_tl_rec.non_response_explain := l_okc_k_headers_tl_rec.non_response_explain;
6860: END IF;
6861: IF (x_okc_k_headers_tl_rec.set_aside_reason = OKC_API.G_MISS_CHAR)
6862: THEN
6863: x_okc_k_headers_tl_rec.set_aside_reason := l_okc_k_headers_tl_rec.set_aside_reason;
6864: END IF;
6865: IF (x_okc_k_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)
6866: THEN
6867: x_okc_k_headers_tl_rec.created_by := l_okc_k_headers_tl_rec.created_by;

Line 6865: IF (x_okc_k_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)

6861: IF (x_okc_k_headers_tl_rec.set_aside_reason = OKC_API.G_MISS_CHAR)
6862: THEN
6863: x_okc_k_headers_tl_rec.set_aside_reason := l_okc_k_headers_tl_rec.set_aside_reason;
6864: END IF;
6865: IF (x_okc_k_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)
6866: THEN
6867: x_okc_k_headers_tl_rec.created_by := l_okc_k_headers_tl_rec.created_by;
6868: END IF;
6869: IF (x_okc_k_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 6867: x_okc_k_headers_tl_rec.created_by := l_okc_k_headers_tl_rec.created_by;

6863: x_okc_k_headers_tl_rec.set_aside_reason := l_okc_k_headers_tl_rec.set_aside_reason;
6864: END IF;
6865: IF (x_okc_k_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)
6866: THEN
6867: x_okc_k_headers_tl_rec.created_by := l_okc_k_headers_tl_rec.created_by;
6868: END IF;
6869: IF (x_okc_k_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6870: THEN
6871: x_okc_k_headers_tl_rec.creation_date := l_okc_k_headers_tl_rec.creation_date;

Line 6869: IF (x_okc_k_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)

6865: IF (x_okc_k_headers_tl_rec.created_by = OKC_API.G_MISS_NUM)
6866: THEN
6867: x_okc_k_headers_tl_rec.created_by := l_okc_k_headers_tl_rec.created_by;
6868: END IF;
6869: IF (x_okc_k_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6870: THEN
6871: x_okc_k_headers_tl_rec.creation_date := l_okc_k_headers_tl_rec.creation_date;
6872: END IF;
6873: IF (x_okc_k_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 6871: x_okc_k_headers_tl_rec.creation_date := l_okc_k_headers_tl_rec.creation_date;

6867: x_okc_k_headers_tl_rec.created_by := l_okc_k_headers_tl_rec.created_by;
6868: END IF;
6869: IF (x_okc_k_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6870: THEN
6871: x_okc_k_headers_tl_rec.creation_date := l_okc_k_headers_tl_rec.creation_date;
6872: END IF;
6873: IF (x_okc_k_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6874: THEN
6875: x_okc_k_headers_tl_rec.last_updated_by := l_okc_k_headers_tl_rec.last_updated_by;

Line 6873: IF (x_okc_k_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

6869: IF (x_okc_k_headers_tl_rec.creation_date = OKC_API.G_MISS_DATE)
6870: THEN
6871: x_okc_k_headers_tl_rec.creation_date := l_okc_k_headers_tl_rec.creation_date;
6872: END IF;
6873: IF (x_okc_k_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6874: THEN
6875: x_okc_k_headers_tl_rec.last_updated_by := l_okc_k_headers_tl_rec.last_updated_by;
6876: END IF;
6877: IF (x_okc_k_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 6875: x_okc_k_headers_tl_rec.last_updated_by := l_okc_k_headers_tl_rec.last_updated_by;

6871: x_okc_k_headers_tl_rec.creation_date := l_okc_k_headers_tl_rec.creation_date;
6872: END IF;
6873: IF (x_okc_k_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6874: THEN
6875: x_okc_k_headers_tl_rec.last_updated_by := l_okc_k_headers_tl_rec.last_updated_by;
6876: END IF;
6877: IF (x_okc_k_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6878: THEN
6879: x_okc_k_headers_tl_rec.last_update_date := l_okc_k_headers_tl_rec.last_update_date;

Line 6877: IF (x_okc_k_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

6873: IF (x_okc_k_headers_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
6874: THEN
6875: x_okc_k_headers_tl_rec.last_updated_by := l_okc_k_headers_tl_rec.last_updated_by;
6876: END IF;
6877: IF (x_okc_k_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6878: THEN
6879: x_okc_k_headers_tl_rec.last_update_date := l_okc_k_headers_tl_rec.last_update_date;
6880: END IF;
6881: IF (x_okc_k_headers_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 6879: x_okc_k_headers_tl_rec.last_update_date := l_okc_k_headers_tl_rec.last_update_date;

6875: x_okc_k_headers_tl_rec.last_updated_by := l_okc_k_headers_tl_rec.last_updated_by;
6876: END IF;
6877: IF (x_okc_k_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6878: THEN
6879: x_okc_k_headers_tl_rec.last_update_date := l_okc_k_headers_tl_rec.last_update_date;
6880: END IF;
6881: IF (x_okc_k_headers_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
6882: THEN
6883: x_okc_k_headers_tl_rec.last_update_login := l_okc_k_headers_tl_rec.last_update_login;

Line 6881: IF (x_okc_k_headers_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

6877: IF (x_okc_k_headers_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
6878: THEN
6879: x_okc_k_headers_tl_rec.last_update_date := l_okc_k_headers_tl_rec.last_update_date;
6880: END IF;
6881: IF (x_okc_k_headers_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
6882: THEN
6883: x_okc_k_headers_tl_rec.last_update_login := l_okc_k_headers_tl_rec.last_update_login;
6884: END IF;
6885: RETURN(l_return_status);

Line 6883: x_okc_k_headers_tl_rec.last_update_login := l_okc_k_headers_tl_rec.last_update_login;

6879: x_okc_k_headers_tl_rec.last_update_date := l_okc_k_headers_tl_rec.last_update_date;
6880: END IF;
6881: IF (x_okc_k_headers_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
6882: THEN
6883: x_okc_k_headers_tl_rec.last_update_login := l_okc_k_headers_tl_rec.last_update_login;
6884: END IF;
6885: RETURN(l_return_status);
6886:
6887: END populate_new_record;

Line 6889: -- Set_Attributes for:OKC_K_HEADERS_TL --

6885: RETURN(l_return_status);
6886:
6887: END populate_new_record;
6888: -----------------------------------------
6889: -- Set_Attributes for:OKC_K_HEADERS_TL --
6890: -----------------------------------------
6891: FUNCTION Set_Attributes (
6892: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
6893: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type

Line 6892: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,

6888: -----------------------------------------
6889: -- Set_Attributes for:OKC_K_HEADERS_TL --
6890: -----------------------------------------
6891: FUNCTION Set_Attributes (
6892: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
6893: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type
6894: ) RETURN VARCHAR2 IS
6895: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6896: BEGIN

Line 6893: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type

6889: -- Set_Attributes for:OKC_K_HEADERS_TL --
6890: -----------------------------------------
6891: FUNCTION Set_Attributes (
6892: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
6893: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type
6894: ) RETURN VARCHAR2 IS
6895: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6896: BEGIN
6897:

Line 6903: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;

6899: okc_debug.Set_Indentation('OKC_CHR_PVT');
6900: okc_debug.LOG('19400: Entered Set_Attributes', 2);
6901: END IF;
6902:
6903: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
6904: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6905: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6906: RETURN(l_return_status);
6907:

Line 6904: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

6900: okc_debug.LOG('19400: Entered Set_Attributes', 2);
6901: END IF;
6902:
6903: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
6904: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6905: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6906: RETURN(l_return_status);
6907:
6908: END Set_Attributes;

Line 6905: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

6901: END IF;
6902:
6903: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
6904: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
6905: x_okc_k_headers_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
6906: RETURN(l_return_status);
6907:
6908: END Set_Attributes;
6909: BEGIN

Line 6927: p_okc_k_headers_tl_rec, -- IN

6923: RAISE OKC_API.G_EXCEPTION_ERROR;
6924: END IF;
6925: --- Setting item attributes
6926: l_return_status := Set_Attributes(
6927: p_okc_k_headers_tl_rec, -- IN
6928: l_okc_k_headers_tl_rec); -- OUT
6929: --- If any errors happen abort API
6930: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6931: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6928: l_okc_k_headers_tl_rec); -- OUT

6924: END IF;
6925: --- Setting item attributes
6926: l_return_status := Set_Attributes(
6927: p_okc_k_headers_tl_rec, -- IN
6928: l_okc_k_headers_tl_rec); -- OUT
6929: --- If any errors happen abort API
6930: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6931: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6932: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 6935: l_return_status := populate_new_record(l_okc_k_headers_tl_rec, l_def_okc_k_headers_tl_rec);

6931: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6932: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6933: RAISE OKC_API.G_EXCEPTION_ERROR;
6934: END IF;
6935: l_return_status := populate_new_record(l_okc_k_headers_tl_rec, l_def_okc_k_headers_tl_rec);
6936: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6937: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6938: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6939: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 6941: UPDATE OKC_K_HEADERS_TL

6937: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6938: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6939: RAISE OKC_API.G_EXCEPTION_ERROR;
6940: END IF;
6941: UPDATE OKC_K_HEADERS_TL
6942: SET SHORT_DESCRIPTION = l_def_okc_k_headers_tl_rec.short_description,
6943: COMMENTS = l_def_okc_k_headers_tl_rec.comments,
6944: DESCRIPTION = l_def_okc_k_headers_tl_rec.description,
6945: COGNOMEN = l_def_okc_k_headers_tl_rec.cognomen,

Line 6942: SET SHORT_DESCRIPTION = l_def_okc_k_headers_tl_rec.short_description,

6938: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6939: RAISE OKC_API.G_EXCEPTION_ERROR;
6940: END IF;
6941: UPDATE OKC_K_HEADERS_TL
6942: SET SHORT_DESCRIPTION = l_def_okc_k_headers_tl_rec.short_description,
6943: COMMENTS = l_def_okc_k_headers_tl_rec.comments,
6944: DESCRIPTION = l_def_okc_k_headers_tl_rec.description,
6945: COGNOMEN = l_def_okc_k_headers_tl_rec.cognomen,
6946: NON_RESPONSE_REASON = l_def_okc_k_headers_tl_rec.non_response_reason,

Line 6943: COMMENTS = l_def_okc_k_headers_tl_rec.comments,

6939: RAISE OKC_API.G_EXCEPTION_ERROR;
6940: END IF;
6941: UPDATE OKC_K_HEADERS_TL
6942: SET SHORT_DESCRIPTION = l_def_okc_k_headers_tl_rec.short_description,
6943: COMMENTS = l_def_okc_k_headers_tl_rec.comments,
6944: DESCRIPTION = l_def_okc_k_headers_tl_rec.description,
6945: COGNOMEN = l_def_okc_k_headers_tl_rec.cognomen,
6946: NON_RESPONSE_REASON = l_def_okc_k_headers_tl_rec.non_response_reason,
6947: NON_RESPONSE_EXPLAIN = l_def_okc_k_headers_tl_rec.non_response_explain,

Line 6944: DESCRIPTION = l_def_okc_k_headers_tl_rec.description,

6940: END IF;
6941: UPDATE OKC_K_HEADERS_TL
6942: SET SHORT_DESCRIPTION = l_def_okc_k_headers_tl_rec.short_description,
6943: COMMENTS = l_def_okc_k_headers_tl_rec.comments,
6944: DESCRIPTION = l_def_okc_k_headers_tl_rec.description,
6945: COGNOMEN = l_def_okc_k_headers_tl_rec.cognomen,
6946: NON_RESPONSE_REASON = l_def_okc_k_headers_tl_rec.non_response_reason,
6947: NON_RESPONSE_EXPLAIN = l_def_okc_k_headers_tl_rec.non_response_explain,
6948: SET_ASIDE_REASON = l_def_okc_k_headers_tl_rec.set_aside_reason,

Line 6945: COGNOMEN = l_def_okc_k_headers_tl_rec.cognomen,

6941: UPDATE OKC_K_HEADERS_TL
6942: SET SHORT_DESCRIPTION = l_def_okc_k_headers_tl_rec.short_description,
6943: COMMENTS = l_def_okc_k_headers_tl_rec.comments,
6944: DESCRIPTION = l_def_okc_k_headers_tl_rec.description,
6945: COGNOMEN = l_def_okc_k_headers_tl_rec.cognomen,
6946: NON_RESPONSE_REASON = l_def_okc_k_headers_tl_rec.non_response_reason,
6947: NON_RESPONSE_EXPLAIN = l_def_okc_k_headers_tl_rec.non_response_explain,
6948: SET_ASIDE_REASON = l_def_okc_k_headers_tl_rec.set_aside_reason,
6949: SOURCE_LANG = l_def_okc_k_headers_tl_rec.source_lang,

Line 6946: NON_RESPONSE_REASON = l_def_okc_k_headers_tl_rec.non_response_reason,

6942: SET SHORT_DESCRIPTION = l_def_okc_k_headers_tl_rec.short_description,
6943: COMMENTS = l_def_okc_k_headers_tl_rec.comments,
6944: DESCRIPTION = l_def_okc_k_headers_tl_rec.description,
6945: COGNOMEN = l_def_okc_k_headers_tl_rec.cognomen,
6946: NON_RESPONSE_REASON = l_def_okc_k_headers_tl_rec.non_response_reason,
6947: NON_RESPONSE_EXPLAIN = l_def_okc_k_headers_tl_rec.non_response_explain,
6948: SET_ASIDE_REASON = l_def_okc_k_headers_tl_rec.set_aside_reason,
6949: SOURCE_LANG = l_def_okc_k_headers_tl_rec.source_lang,
6950: --CREATED_BY = l_def_okc_k_headers_tl_rec.created_by,

Line 6947: NON_RESPONSE_EXPLAIN = l_def_okc_k_headers_tl_rec.non_response_explain,

6943: COMMENTS = l_def_okc_k_headers_tl_rec.comments,
6944: DESCRIPTION = l_def_okc_k_headers_tl_rec.description,
6945: COGNOMEN = l_def_okc_k_headers_tl_rec.cognomen,
6946: NON_RESPONSE_REASON = l_def_okc_k_headers_tl_rec.non_response_reason,
6947: NON_RESPONSE_EXPLAIN = l_def_okc_k_headers_tl_rec.non_response_explain,
6948: SET_ASIDE_REASON = l_def_okc_k_headers_tl_rec.set_aside_reason,
6949: SOURCE_LANG = l_def_okc_k_headers_tl_rec.source_lang,
6950: --CREATED_BY = l_def_okc_k_headers_tl_rec.created_by,
6951: --CREATION_DATE = l_def_okc_k_headers_tl_rec.creation_date,

Line 6948: SET_ASIDE_REASON = l_def_okc_k_headers_tl_rec.set_aside_reason,

6944: DESCRIPTION = l_def_okc_k_headers_tl_rec.description,
6945: COGNOMEN = l_def_okc_k_headers_tl_rec.cognomen,
6946: NON_RESPONSE_REASON = l_def_okc_k_headers_tl_rec.non_response_reason,
6947: NON_RESPONSE_EXPLAIN = l_def_okc_k_headers_tl_rec.non_response_explain,
6948: SET_ASIDE_REASON = l_def_okc_k_headers_tl_rec.set_aside_reason,
6949: SOURCE_LANG = l_def_okc_k_headers_tl_rec.source_lang,
6950: --CREATED_BY = l_def_okc_k_headers_tl_rec.created_by,
6951: --CREATION_DATE = l_def_okc_k_headers_tl_rec.creation_date,
6952: LAST_UPDATED_BY = l_def_okc_k_headers_tl_rec.last_updated_by,

Line 6949: SOURCE_LANG = l_def_okc_k_headers_tl_rec.source_lang,

6945: COGNOMEN = l_def_okc_k_headers_tl_rec.cognomen,
6946: NON_RESPONSE_REASON = l_def_okc_k_headers_tl_rec.non_response_reason,
6947: NON_RESPONSE_EXPLAIN = l_def_okc_k_headers_tl_rec.non_response_explain,
6948: SET_ASIDE_REASON = l_def_okc_k_headers_tl_rec.set_aside_reason,
6949: SOURCE_LANG = l_def_okc_k_headers_tl_rec.source_lang,
6950: --CREATED_BY = l_def_okc_k_headers_tl_rec.created_by,
6951: --CREATION_DATE = l_def_okc_k_headers_tl_rec.creation_date,
6952: LAST_UPDATED_BY = l_def_okc_k_headers_tl_rec.last_updated_by,
6953: LAST_UPDATE_DATE = l_def_okc_k_headers_tl_rec.last_update_date,

Line 6950: --CREATED_BY = l_def_okc_k_headers_tl_rec.created_by,

6946: NON_RESPONSE_REASON = l_def_okc_k_headers_tl_rec.non_response_reason,
6947: NON_RESPONSE_EXPLAIN = l_def_okc_k_headers_tl_rec.non_response_explain,
6948: SET_ASIDE_REASON = l_def_okc_k_headers_tl_rec.set_aside_reason,
6949: SOURCE_LANG = l_def_okc_k_headers_tl_rec.source_lang,
6950: --CREATED_BY = l_def_okc_k_headers_tl_rec.created_by,
6951: --CREATION_DATE = l_def_okc_k_headers_tl_rec.creation_date,
6952: LAST_UPDATED_BY = l_def_okc_k_headers_tl_rec.last_updated_by,
6953: LAST_UPDATE_DATE = l_def_okc_k_headers_tl_rec.last_update_date,
6954: LAST_UPDATE_LOGIN = l_def_okc_k_headers_tl_rec.last_update_login

Line 6951: --CREATION_DATE = l_def_okc_k_headers_tl_rec.creation_date,

6947: NON_RESPONSE_EXPLAIN = l_def_okc_k_headers_tl_rec.non_response_explain,
6948: SET_ASIDE_REASON = l_def_okc_k_headers_tl_rec.set_aside_reason,
6949: SOURCE_LANG = l_def_okc_k_headers_tl_rec.source_lang,
6950: --CREATED_BY = l_def_okc_k_headers_tl_rec.created_by,
6951: --CREATION_DATE = l_def_okc_k_headers_tl_rec.creation_date,
6952: LAST_UPDATED_BY = l_def_okc_k_headers_tl_rec.last_updated_by,
6953: LAST_UPDATE_DATE = l_def_okc_k_headers_tl_rec.last_update_date,
6954: LAST_UPDATE_LOGIN = l_def_okc_k_headers_tl_rec.last_update_login
6955: WHERE ID = l_def_okc_k_headers_tl_rec.id

Line 6952: LAST_UPDATED_BY = l_def_okc_k_headers_tl_rec.last_updated_by,

6948: SET_ASIDE_REASON = l_def_okc_k_headers_tl_rec.set_aside_reason,
6949: SOURCE_LANG = l_def_okc_k_headers_tl_rec.source_lang,
6950: --CREATED_BY = l_def_okc_k_headers_tl_rec.created_by,
6951: --CREATION_DATE = l_def_okc_k_headers_tl_rec.creation_date,
6952: LAST_UPDATED_BY = l_def_okc_k_headers_tl_rec.last_updated_by,
6953: LAST_UPDATE_DATE = l_def_okc_k_headers_tl_rec.last_update_date,
6954: LAST_UPDATE_LOGIN = l_def_okc_k_headers_tl_rec.last_update_login
6955: WHERE ID = l_def_okc_k_headers_tl_rec.id
6956: AND USERENV('LANG') IN (SOURCE_LANG, LANGUAGE);

Line 6953: LAST_UPDATE_DATE = l_def_okc_k_headers_tl_rec.last_update_date,

6949: SOURCE_LANG = l_def_okc_k_headers_tl_rec.source_lang,
6950: --CREATED_BY = l_def_okc_k_headers_tl_rec.created_by,
6951: --CREATION_DATE = l_def_okc_k_headers_tl_rec.creation_date,
6952: LAST_UPDATED_BY = l_def_okc_k_headers_tl_rec.last_updated_by,
6953: LAST_UPDATE_DATE = l_def_okc_k_headers_tl_rec.last_update_date,
6954: LAST_UPDATE_LOGIN = l_def_okc_k_headers_tl_rec.last_update_login
6955: WHERE ID = l_def_okc_k_headers_tl_rec.id
6956: AND USERENV('LANG') IN (SOURCE_LANG, LANGUAGE);
6957:

Line 6954: LAST_UPDATE_LOGIN = l_def_okc_k_headers_tl_rec.last_update_login

6950: --CREATED_BY = l_def_okc_k_headers_tl_rec.created_by,
6951: --CREATION_DATE = l_def_okc_k_headers_tl_rec.creation_date,
6952: LAST_UPDATED_BY = l_def_okc_k_headers_tl_rec.last_updated_by,
6953: LAST_UPDATE_DATE = l_def_okc_k_headers_tl_rec.last_update_date,
6954: LAST_UPDATE_LOGIN = l_def_okc_k_headers_tl_rec.last_update_login
6955: WHERE ID = l_def_okc_k_headers_tl_rec.id
6956: AND USERENV('LANG') IN (SOURCE_LANG, LANGUAGE);
6957:
6958: UPDATE OKC_K_HEADERS_TL

Line 6955: WHERE ID = l_def_okc_k_headers_tl_rec.id

6951: --CREATION_DATE = l_def_okc_k_headers_tl_rec.creation_date,
6952: LAST_UPDATED_BY = l_def_okc_k_headers_tl_rec.last_updated_by,
6953: LAST_UPDATE_DATE = l_def_okc_k_headers_tl_rec.last_update_date,
6954: LAST_UPDATE_LOGIN = l_def_okc_k_headers_tl_rec.last_update_login
6955: WHERE ID = l_def_okc_k_headers_tl_rec.id
6956: AND USERENV('LANG') IN (SOURCE_LANG, LANGUAGE);
6957:
6958: UPDATE OKC_K_HEADERS_TL
6959: SET SFWT_FLAG = 'Y'

Line 6958: UPDATE OKC_K_HEADERS_TL

6954: LAST_UPDATE_LOGIN = l_def_okc_k_headers_tl_rec.last_update_login
6955: WHERE ID = l_def_okc_k_headers_tl_rec.id
6956: AND USERENV('LANG') IN (SOURCE_LANG, LANGUAGE);
6957:
6958: UPDATE OKC_K_HEADERS_TL
6959: SET SFWT_FLAG = 'Y'
6960: WHERE ID = l_def_okc_k_headers_tl_rec.id
6961: AND SOURCE_LANG <> USERENV('LANG');
6962:

Line 6960: WHERE ID = l_def_okc_k_headers_tl_rec.id

6956: AND USERENV('LANG') IN (SOURCE_LANG, LANGUAGE);
6957:
6958: UPDATE OKC_K_HEADERS_TL
6959: SET SFWT_FLAG = 'Y'
6960: WHERE ID = l_def_okc_k_headers_tl_rec.id
6961: AND SOURCE_LANG <> USERENV('LANG');
6962:
6963: x_okc_k_headers_tl_rec := l_def_okc_k_headers_tl_rec;
6964: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 6963: x_okc_k_headers_tl_rec := l_def_okc_k_headers_tl_rec;

6959: SET SFWT_FLAG = 'Y'
6960: WHERE ID = l_def_okc_k_headers_tl_rec.id
6961: AND SOURCE_LANG <> USERENV('LANG');
6962:
6963: x_okc_k_headers_tl_rec := l_def_okc_k_headers_tl_rec;
6964: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
6965: IF (l_debug = 'Y') THEN
6966: okc_debug.LOG('19600: Exiting update_row', 2);
6967: okc_debug.Reset_Indentation;

Line 7040: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

7036: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
7037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7038: l_chrv_rec chrv_rec_type := p_chrv_rec;
7039: l_def_chrv_rec chrv_rec_type;
7040: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
7041: lx_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
7042: l_chr_rec chr_rec_type;
7043: lx_chr_rec chr_rec_type;
7044: -------------------------------

Line 7041: lx_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

7037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7038: l_chrv_rec chrv_rec_type := p_chrv_rec;
7039: l_def_chrv_rec chrv_rec_type;
7040: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
7041: lx_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
7042: l_chr_rec chr_rec_type;
7043: lx_chr_rec chr_rec_type;
7044: -------------------------------
7045: -- FUNCTION fill_who_columns --

Line 7603: migrate(l_def_chrv_rec, l_okc_k_headers_tl_rec);

7599:
7600: --------------------------------------
7601: -- Move VIEW record to "Child" records
7602: --------------------------------------
7603: migrate(l_def_chrv_rec, l_okc_k_headers_tl_rec);
7604: migrate(l_def_chrv_rec, l_chr_rec);
7605: --------------------------------------------
7606: -- Call the UPDATE_ROW for each child record
7607: --------------------------------------------

Line 7613: l_okc_k_headers_tl_rec,

7609: p_init_msg_list,
7610: x_return_status,
7611: x_msg_count,
7612: x_msg_data,
7613: l_okc_k_headers_tl_rec,
7614: lx_okc_k_headers_tl_rec
7615: );
7616: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 7614: lx_okc_k_headers_tl_rec

7610: x_return_status,
7611: x_msg_count,
7612: x_msg_data,
7613: l_okc_k_headers_tl_rec,
7614: lx_okc_k_headers_tl_rec
7615: );
7616: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7618: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 7621: migrate(lx_okc_k_headers_tl_rec, l_def_chrv_rec);

7617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7618: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
7619: RAISE OKC_API.G_EXCEPTION_ERROR;
7620: END IF;
7621: migrate(lx_okc_k_headers_tl_rec, l_def_chrv_rec);
7622: update_row(
7623: p_init_msg_list,
7624: x_return_status,
7625: x_msg_count,

Line 7903: -- delete_row for:OKC_K_HEADERS_TL --

7899: );
7900:
7901: END delete_row;
7902: -------------------------------------
7903: -- delete_row for:OKC_K_HEADERS_TL --
7904: -------------------------------------
7905: PROCEDURE delete_row(
7906: p_init_msg_list IN VARCHAR2,
7907: x_return_status OUT NOCOPY VARCHAR2,

Line 7910: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type) IS

7906: p_init_msg_list IN VARCHAR2,
7907: x_return_status OUT NOCOPY VARCHAR2,
7908: x_msg_count OUT NOCOPY NUMBER,
7909: x_msg_data OUT NOCOPY VARCHAR2,
7910: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type) IS
7911:
7912: l_api_version CONSTANT NUMBER := 1;
7913: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
7914: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 7915: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type := p_okc_k_headers_tl_rec;

7911:
7912: l_api_version CONSTANT NUMBER := 1;
7913: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
7914: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7915: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type := p_okc_k_headers_tl_rec;
7916: l_row_notfound BOOLEAN := TRUE;
7917: -----------------------------------------
7918: -- Set_Attributes for:OKC_K_HEADERS_TL --
7919: -----------------------------------------

Line 7918: -- Set_Attributes for:OKC_K_HEADERS_TL --

7914: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7915: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type := p_okc_k_headers_tl_rec;
7916: l_row_notfound BOOLEAN := TRUE;
7917: -----------------------------------------
7918: -- Set_Attributes for:OKC_K_HEADERS_TL --
7919: -----------------------------------------
7920: FUNCTION Set_Attributes (
7921: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
7922: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type

Line 7921: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,

7917: -----------------------------------------
7918: -- Set_Attributes for:OKC_K_HEADERS_TL --
7919: -----------------------------------------
7920: FUNCTION Set_Attributes (
7921: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
7922: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type
7923: ) RETURN VARCHAR2 IS
7924: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7925: BEGIN

Line 7922: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type

7918: -- Set_Attributes for:OKC_K_HEADERS_TL --
7919: -----------------------------------------
7920: FUNCTION Set_Attributes (
7921: p_okc_k_headers_tl_rec IN okc_k_headers_tl_rec_type,
7922: x_okc_k_headers_tl_rec OUT NOCOPY okc_k_headers_tl_rec_type
7923: ) RETURN VARCHAR2 IS
7924: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7925: BEGIN
7926:

Line 7932: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;

7928: okc_debug.Set_Indentation('OKC_CHR_PVT');
7929: okc_debug.LOG('21800: Entered Set_Attributes', 2);
7930: END IF;
7931:
7932: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
7933: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
7934: RETURN(l_return_status);
7935:
7936: END Set_Attributes;

Line 7933: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

7929: okc_debug.LOG('21800: Entered Set_Attributes', 2);
7930: END IF;
7931:
7932: x_okc_k_headers_tl_rec := p_okc_k_headers_tl_rec;
7933: x_okc_k_headers_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
7934: RETURN(l_return_status);
7935:
7936: END Set_Attributes;
7937: BEGIN

Line 7955: p_okc_k_headers_tl_rec, -- IN

7951: RAISE OKC_API.G_EXCEPTION_ERROR;
7952: END IF;
7953: --- Setting item attributes
7954: l_return_status := Set_Attributes(
7955: p_okc_k_headers_tl_rec, -- IN
7956: l_okc_k_headers_tl_rec); -- OUT
7957: --- If any errors happen abort API
7958: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7959: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 7956: l_okc_k_headers_tl_rec); -- OUT

7952: END IF;
7953: --- Setting item attributes
7954: l_return_status := Set_Attributes(
7955: p_okc_k_headers_tl_rec, -- IN
7956: l_okc_k_headers_tl_rec); -- OUT
7957: --- If any errors happen abort API
7958: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7959: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7960: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 7963: DELETE FROM OKC_K_HEADERS_TL

7959: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7960: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7961: RAISE OKC_API.G_EXCEPTION_ERROR;
7962: END IF;
7963: DELETE FROM OKC_K_HEADERS_TL
7964: WHERE ID = l_okc_k_headers_tl_rec.id;
7965:
7966: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
7967: IF (l_debug = 'Y') THEN

Line 7964: WHERE ID = l_okc_k_headers_tl_rec.id;

7960: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7961: RAISE OKC_API.G_EXCEPTION_ERROR;
7962: END IF;
7963: DELETE FROM OKC_K_HEADERS_TL
7964: WHERE ID = l_okc_k_headers_tl_rec.id;
7965:
7966: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
7967: IF (l_debug = 'Y') THEN
7968: okc_debug.LOG('22000: Exiting delete_row', 2);

Line 8039: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;

8035: l_api_version CONSTANT NUMBER := 1;
8036: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
8037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8038: l_chrv_rec chrv_rec_type := p_chrv_rec;
8039: l_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
8040: l_chr_rec chr_rec_type;
8041: BEGIN
8042:
8043: IF (l_debug = 'Y') THEN

Line 8063: migrate(l_chrv_rec, l_okc_k_headers_tl_rec);

8059: END IF;
8060: --------------------------------------
8061: -- Move VIEW record to "Child" records
8062: --------------------------------------
8063: migrate(l_chrv_rec, l_okc_k_headers_tl_rec);
8064: migrate(l_chrv_rec, l_chr_rec);
8065: --------------------------------------------
8066: -- Call the DELETE_ROW for each child record
8067: --------------------------------------------

Line 8073: l_okc_k_headers_tl_rec

8069: p_init_msg_list,
8070: x_return_status,
8071: x_msg_count,
8072: x_msg_data,
8073: l_okc_k_headers_tl_rec
8074: );
8075: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8076: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8077: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 8765: INSERT INTO OKC_K_HEADERS_TL(

8761: );
8762:
8763: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
8764: FORALL i IN 1..l_tabsize
8765: INSERT INTO OKC_K_HEADERS_TL(
8766: id,
8767: language,
8768: source_lang,
8769: sfwt_flag,

Line 9091: INSERT INTO okc_k_headers_tlh

9087: --------------------------------
9088: -- Versioning TL Table
9089: --------------------------------
9090:
9091: INSERT INTO okc_k_headers_tlh
9092: (
9093: major_version,
9094: id,
9095: language,

Line 9129: FROM okc_k_headers_tl

9125: creation_date,
9126: last_updated_by,
9127: last_update_date,
9128: last_update_login
9129: FROM okc_k_headers_tl
9130: WHERE id = p_chr_id;
9131:
9132: RETURN l_return_status;
9133: IF (l_debug = 'Y') THEN

Line 9181: INSERT INTO okc_k_headers_tl

9177: okc_debug.Set_Indentation('OKC_CHR_PVT');
9178: okc_debug.LOG('24000: Entered restore_version', 2);
9179: END IF;
9180:
9181: INSERT INTO okc_k_headers_tl
9182: (
9183: id,
9184: language,
9185: source_lang,

Line 9217: FROM okc_k_headers_tlh

9213: creation_date,
9214: last_updated_by,
9215: last_update_date,
9216: last_update_login
9217: FROM okc_k_headers_tlh
9218: WHERE id = p_chr_id
9219: AND major_version = p_major_version;
9220:
9221: --------------------------------------