DBA Data[Home] [Help]

APPS.OKC_TIME_PVT dependencies on OKC_UTIL

Line 2916: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

2912: -- Procedure for mass insert in OKC_TIMEVALUES _B and TL tables
2913: ---------------------------------------------------------------
2914: PROCEDURE INSERT_IGS_ROW_UPG(p_igsv_ext_tbl IN igsv_ext_tbl_type) IS
2915: l_tabsize NUMBER := p_igsv_ext_tbl.COUNT;
2916: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
2917:
2918: in_id OKC_DATATYPES.NumberTabTyp;
2919: in_object_version_number OKC_DATATYPES.NumberTabTyp;
2920: --Bug 3122962 in_sfwt_flag OKC_DATATYPES.Var3TabTyp;

Line 3252: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP

3248: );
3249:
3250: --Bug 3122962
3251: /*
3252: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3253: FORALL i in 1..j
3254: INSERT INTO OKC_TIMEVALUES_TL(
3255: id,
3256: language,

Line 3271: OKC_UTIL.g_language_code(lang_i),

3267: last_update_login
3268: )
3269: VALUES (
3270: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3271: OKC_UTIL.g_language_code(lang_i),
3272: l_source_lang,
3273: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3274: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3275: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),

Line 3293: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

3289: END INSERT_IGS_ROW_UPG;
3290:
3291: PROCEDURE INSERT_TGD_ROW_UPG(p_tgdv_ext_tbl IN tgdv_ext_tbl_type) IS
3292: l_tabsize NUMBER := p_tgdv_ext_tbl.COUNT;
3293: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
3294:
3295: in_id OKC_DATATYPES.NumberTabTyp;
3296: in_object_version_number OKC_DATATYPES.NumberTabTyp;
3297: --Bug 3122962 in_sfwt_flag OKC_DATATYPES.Var3TabTyp;

Line 3517: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP

3513: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3514: );
3515: --Bug 3122962
3516: /*
3517: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3518: FORALL i in 1..j
3519: INSERT INTO OKC_TIMEVALUES_TL(
3520: id,
3521: language,

Line 3536: OKC_UTIL.g_language_code(lang_i),

3532: last_update_login
3533: )
3534: VALUES (
3535: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3536: OKC_UTIL.g_language_code(lang_i),
3537: l_source_lang,
3538: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3539: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3540: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),

Line 3558: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

3554: END INSERT_TGD_ROW_UPG;
3555:
3556: PROCEDURE INSERT_ISE_ROW_UPG(p_isev_ext_tbl IN isev_ext_tbl_type) IS
3557: l_tabsize NUMBER := p_isev_ext_tbl.COUNT;
3558: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
3559: in_id OKC_DATATYPES.NumberTabTyp;
3560: in_object_version_number OKC_DATATYPES.NumberTabTyp;
3561: --Bug 3122962 in_sfwt_flag OKC_DATATYPES.Var3TabTyp;
3562: in_spn_id OKC_DATATYPES.NumberTabTyp;

Line 3854: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP

3850: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3851: );
3852: --Bug 3122962
3853: /*
3854: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3855: FORALL i in 1..j
3856: INSERT INTO OKC_TIMEVALUES_TL(
3857: id,
3858: language,

Line 3873: OKC_UTIL.g_language_code(lang_i),

3869: last_update_login
3870: )
3871: VALUES (
3872: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3873: OKC_UTIL.g_language_code(lang_i),
3874: l_source_lang,
3875: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3876: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3877: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),

Line 3895: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

3891: END INSERT_ISE_ROW_UPG;
3892:
3893: PROCEDURE INSERT_ISE_ROW_UPG(p_isev_rel_tbl IN isev_rel_tbl_type) IS
3894: l_tabsize NUMBER := p_isev_rel_tbl.COUNT;
3895: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
3896: in_id OKC_DATATYPES.NumberTabTyp;
3897: in_object_version_number OKC_DATATYPES.NumberTabTyp;
3898: --Bug 3122962 in_sfwt_flag OKC_DATATYPES.Var3TabTyp;
3899: in_spn_id OKC_DATATYPES.NumberTabTyp;

Line 4196: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP

4192: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
4193: );
4194: --Bug 3122962
4195: /*
4196: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
4197: FORALL i in 1..j
4198: INSERT INTO OKC_TIMEVALUES_TL(
4199: id,
4200: language,

Line 4215: OKC_UTIL.g_language_code(lang_i),

4211: last_update_login
4212: )
4213: VALUES (
4214: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
4215: OKC_UTIL.g_language_code(lang_i),
4216: l_source_lang,
4217: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
4218: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4219: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),