DBA Data[Home] [Help]

APPS.OKS_INSERT_ROW_UPG dependencies on OKC_UTIL

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

8: (x_return_status OUT NOCOPY VARCHAR2,
9: P_CTZV_TBL OKS_CTZ_PVT.OksCoverageTimezonesVTblType) IS
10:
11: l_tabsize NUMBER := P_CTZV_TBL.COUNT;
12: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
13: In_ID OKC_DATATYPES.NumberTabTyp;
14: In_CLE_ID OKC_DATATYPES.NumberTabTyp;
15: In_DEFAULT_YN OKC_DATATYPES.VAR3TabTyp;
16: In_TIMEZONE_ID OKC_DATATYPES.NumberTabTyp;

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

125: (x_return_status OUT NOCOPY VARCHAR2,
126: P_CVTV_TBL OKS_CVT_PVT.oks_coverage_times_v_tbl_type) IS
127:
128: l_tabsize NUMBER := P_CVTV_TBL.COUNT;
129: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
130: In_ID OKC_DATATYPES.NumberTabTyp;
131: In_COV_TZE_LINE_ID OKC_DATATYPES.NumberTabTyp;
132: In_DNZ_CHR_ID OKC_DATATYPES.NumberTabTyp;
133: In_START_HOUR OKC_DATATYPES.NumberTabTyp;

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

272: (x_return_status OUT NOCOPY VARCHAR2,
273: P_ACMV_TBL OKS_ACM_PVT.oks_action_times_v_tbl_type) IS
274:
275: l_tabsize NUMBER := P_ACMV_TBL.COUNT;
276: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
277: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
278: In_ID OKC_DATATYPES.NumberTabTyp;
279: In_COV_ACTION_TYPE_ID OKC_DATATYPES.NumberTabTyp;
280: In_CLE_ID OKC_DATATYPES.NumberTabTyp;

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

414: (x_return_status OUT NOCOPY VARCHAR2,
415: P_ACTV_TBL OKS_ACT_PVT.OksActionTimeTypesVTblType) IS
416:
417: l_tabsize NUMBER := P_ACTV_TBL.COUNT;
418: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
419: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
420: In_ID OKC_DATATYPES.NumberTabTyp;
421: In_CLE_ID OKC_DATATYPES.NumberTabTyp;
422: In_DNZ_CHR_ID OKC_DATATYPES.NumberTabTyp;

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

525: (x_return_status OUT NOCOPY VARCHAR2,
526: P_KLNV_TBL OKS_KLN_PVT.klnv_tbl_type) IS
527:
528: l_tabsize NUMBER := P_KLNV_TBL.COUNT;
529: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
530: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
531: --In_ROW_ID OKC_DATATYPES.;
532: In_ID OKC_DATATYPES.NumberTabTyp;
533: In_CLE_ID OKC_DATATYPES.NumberTabTyp;

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

907: in_LAST_UPDATED_BY(i),
908: in_LAST_UPDATE_DATE(i),
909: in_LAST_UPDATE_LOGIN(i));
910:
911: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
912:
913: FORALL i in 1..l_tabsize
914: INSERT INTO Oks_K_Lines_TL(
915: id,

Line 930: OKC_UTIL.g_language_code(lang_i),

926: last_update_date,
927: last_update_login)
928: VALUES
929: ( in_ID(i),
930: OKC_UTIL.g_language_code(lang_i),
931: l_source_lang,
932: in_SFWT_FLAG(i),
933: in_INVOICE_TEXT(i),
934: in_IB_TRX_DETAILS(i),

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

965: (x_return_status OUT NOCOPY VARCHAR2,
966: p_oks_billrate_schedules_v_tbl OKS_BRS_PVT.OksBillrateSchedulesVTblType) IS
967:
968: l_tabsize NUMBER := p_oks_billrate_schedules_v_tbl.COUNT;
969: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
970: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
971: In_ID OKC_DATATYPES.NumberTabTyp;
972: In_CLE_ID OKC_DATATYPES.NumberTabTyp;
973: In_BT_CLE_ID OKC_DATATYPES.NumberTabTyp;

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

1149: P_KHRV_TBL OKS_KHR_PVT.khrv_tbl_type) IS
1150:
1151:
1152: l_tabsize NUMBER := P_KHRV_TBL.COUNT;
1153: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
1154: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
1155: In_ID OKC_DATATYPES.NumberTabTyp;
1156: In_CHR_ID OKC_DATATYPES.NumberTabTyp;
1157: In_ACCT_RULE_ID OKC_DATATYPES.NumberTabTyp;

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

1462:
1463:
1464: PROCEDURE INSERT_ROW_UPG_sllv_tbl (x_return_status OUT NOCOPY VARCHAR2, p_sllv_tbl OKS_SLL_PVT.sllv_tbl_type) IS
1465: l_tabsize NUMBER := p_sllv_tbl.COUNT;
1466: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
1467: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
1468: In_ID OKC_DATATYPES.NumberTabTyp;
1469: In_CHR_ID OKC_DATATYPES.NumberTabTyp;
1470: In_CLE_ID OKC_DATATYPES.NumberTabTyp;

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

1606:
1607:
1608: PROCEDURE INSERT_ROW_UPG_letv_tbl (x_return_status OUT NOCOPY VARCHAR2, p_letv_tbl OKS_BILL_LEVEL_ELEMENTS_PVT.letv_tbl_type) IS
1609: l_tabsize NUMBER := p_letv_tbl.COUNT;
1610: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
1611: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
1612: In_ID OKC_DATATYPES.NumberTabTyp;
1613: In_SEQUENCE_NUMBER OKC_DATATYPES.VAR240TabTyp;
1614: In_DATE_START OKC_DATATYPES.DateTabTyp;

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

1772: l_in_UPG_ORIG_SYSTEM_REF OKC_DATATYPES.Var75TabTyp;
1773: l_in_UPG_ORIG_SYSTEM_REF_ID OKC_DATATYPES.NumberTabTyp;
1774:
1775: l_in_tabsize NUMBER := P_SUBHDR_TBL.COUNT;
1776: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
1777: tbl_idx NUMBER;
1778: j NUMBER := 0;
1779:
1780:

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

1857: ,l_in_UPG_ORIG_SYSTEM_REF(x)
1858: ,l_in_UPG_ORIG_SYSTEM_REF_ID(x) );
1859:
1860:
1861: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
1862: FORALL x in 1..l_in_tabsize
1863: INSERT INTO OKS_SUBSCR_HEADER_TL(
1864: id,
1865: name,

Line 1881: ,OKC_UTIL.g_language_code(lang_i)

1877: VALUES (
1878: l_in_id(x)
1879: ,l_in_name(x)
1880: ,l_in_description(x)
1881: ,OKC_UTIL.g_language_code(lang_i)
1882: ,l_source_lang
1883: ,l_in_sfwt_flag(x)
1884: ,l_in_comments(x)
1885: ,l_in_created_by(x)