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.OKS_RULE_MIGRATE dependencies on OKC_UTIL

Line 22391: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;

22387:
22388: --Misc Variables --
22389: L_ATTRIBUTE_NAME VARCHAR2(2000);
22390: L_ERROR_MSG VARCHAR2(2000);
22391: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;
22392:
22393: MAIN_EXCEPTION EXCEPTION;
22394: VAL_EXCEPTION EXCEPTION;
22395: LOCK_EXCEPTION EXCEPTION;

Line 23163: For lang_i in okc_util.g_language_code.first..okc_util.g_language_code.last

23159: End If; --Label GG
23160: Begin
23161: If rowcount > 0 then --Label CC
23162: Begin
23163: For lang_i in okc_util.g_language_code.first..okc_util.g_language_code.last
23164: Loop
23165: Update oks_k_lines_tl
23166: Set invoice_text = l_invoice_text
23167: ,ib_trx_details = l_ib_trx_details

Line 23171: and language = okc_util.g_language_code(lang_i)

23167: ,ib_trx_details = l_ib_trx_details
23168: ,status_text = l_status_text
23169: ,react_time_name = rcn_react_time_name
23170: Where id = l_upd_cle_id
23171: and language = okc_util.g_language_code(lang_i)
23172: and source_lang = l_userenv_lang ;
23173: rowcount := sql%rowcount;
23174: End loop;
23175: Exception

Line 23183: For lang_i in okc_util.g_language_code.first..okc_util.g_language_code.last

23179: Raise;
23180: End;
23181: If rowcount = 0 then -- Label DD
23182: Begin
23183: For lang_i in okc_util.g_language_code.first..okc_util.g_language_code.last
23184: Loop
23185: Insert into oks_k_lines_tl (
23186: id,
23187: language,

Line 23202: okc_util.g_language_code(lang_i),

23198: last_update_date,
23199: last_update_login)
23200: values(
23201: l_upd_cle_id,
23202: okc_util.g_language_code(lang_i),
23203: l_userenv_lang,
23204: 'S',
23205: l_invoice_text,
23206: l_ib_trx_details,

Line 23385: For lang_i in okc_util.g_language_code.first..okc_util.g_language_code.last

23381: Raise;
23382: End;
23383: If rowcount > 0 then -- Label HH
23384: Begin
23385: For lang_i in okc_util.g_language_code.first..okc_util.g_language_code.last
23386: Loop
23387: Insert into oks_k_lines_tl (
23388: id,
23389: language,

Line 23404: okc_util.g_language_code(lang_i),

23400: last_update_date,
23401: last_update_login)
23402: values(
23403: l_cle_id,
23404: okc_util.g_language_code(lang_i),
23405: l_userenv_lang,
23406: 'S',
23407: l_invoice_text,
23408: l_ib_trx_details,

Line 23507: for lang_i in okc_util.g_language_code.first..okc_util.g_language_code.last

23503: Raise;
23504: End ;
23505:
23506: Begin
23507: for lang_i in okc_util.g_language_code.first..okc_util.g_language_code.last
23508: loop
23509: insert into oks_k_lines_tl (id
23510: ,language
23511: ,source_lang

Line 23520: ,okc_util.g_language_code(lang_i)

23516: ,last_update_date
23517: ,last_update_login)
23518: values(
23519: l_id
23520: ,okc_util.g_language_code(lang_i)
23521: ,l_userenv_lang
23522: ,'S'
23523: ,1
23524: ,sysdate

Line 27043: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;

27039: and rul.major_version=p_major_version
27040: AND RUL.RULE_INFORMATION_CATEGORY = P_CATEGORY ;
27041:
27042: L_LINE_DTLS_REC L_LINE_DTLS_CSR%ROWTYPE;
27043: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;
27044: ----------------------------------------------------------------------------
27045: --Cursor to check whether the record exists in OKC_RULE_GROUPS_BH table.
27046: ----------------------------------------------------------------------------
27047: CURSOR L_CHECK_RGP_CSR ( P_ID IN NUMBER , P_MAJOR_VERSION IN NUMBER ) IS

Line 27419: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST

27415:
27416: END IF;
27417:
27418:
27419: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST
27420: LOOP
27421: INSERT INTO OKS_K_LINES_TLH (
27422: id,
27423: MAJOR_VERSION,

Line 27440: OKC_UTIL.g_language_code(lang_i),

27436: last_update_login)
27437: VALUES(
27438: CLE_ID,
27439: p_major_version,
27440: OKC_UTIL.g_language_code(lang_i),
27441: L_USERENV_LANG,
27442: 'S',
27443: l_invoice_text,
27444: l_ib_trx_details,

Line 27491: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST

27487: ,1
27488: ,SYSDATE
27489: ,2003);
27490:
27491: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST
27492: LOOP
27493: INSERT INTO OKS_K_LINES_TLH (ID
27494: ,MAJOR_VERSION
27495: ,LANGUAGE

Line 27506: ,OKC_UTIL.g_language_code(lang_i)

27502: ,last_update_login)
27503: VALUES(
27504: l_cle_id
27505: ,p_major_version
27506: ,OKC_UTIL.g_language_code(lang_i)
27507: ,L_USERENV_LANG
27508: ,'S'
27509: ,1
27510: ,sysdate

Line 31194: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;

31190:
31191: --Misc Variables --
31192: L_ATTRIBUTE_NAME VARCHAR2(2000);
31193: L_ERROR_MSG VARCHAR2(2000);
31194: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;
31195:
31196: MAIN_EXCEPTION EXCEPTION;
31197: VAL_EXCEPTION EXCEPTION;
31198: LOCK_EXCEPTION EXCEPTION;

Line 32041: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST

32037: AND T1.CLE_ID = RGP.CLE_ID)
32038: WHERE T1.CLE_ID = p_cle_id;
32039: END IF;
32040:
32041: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST
32042: LOOP
32043: INSERT INTO OKS_K_LINES_TL (
32044: id,
32045: language,

Line 32060: OKC_UTIL.g_language_code(lang_i),

32056: last_update_date,
32057: last_update_login)
32058: VALUES(
32059: P_CLE_ID,
32060: OKC_UTIL.g_language_code(lang_i),
32061: L_USERENV_LANG,
32062: 'S',
32063: l_invoice_text,
32064: l_ib_trx_details,

Line 32206: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST

32202: WHERE T1.CLE_ID = p_cle_id;
32203: END IF;
32204:
32205:
32206: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST
32207: LOOP
32208: Update oks_k_lines_tl set
32209:
32210: INVOICE_TEXT = L_INVOICE_TEXT

Line 32215: and language = OKC_UTIL.g_language_code(lang_i)

32211: ,IB_TRX_DETAILS = L_IB_TRX_DETAILS
32212: ,STATUS_TEXT = L_STATUS_TEXT
32213: ,React_Time_Name = RCN_REACT_TIME_NAME
32214: Where id=p_cle_id
32215: and language = OKC_UTIL.g_language_code(lang_i)
32216: and source_lang = L_USERENV_LANG ;
32217:
32218: END LOOP;
32219:

Line 33661: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;

33657:
33658:
33659:
33660: L_LINE_DTLS_REC L_LINE_DTLS_CSR%ROWTYPE;
33661: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;
33662: l_check_var VARCHAR2(1);
33663: ----------------------------------------------------------------------------
33664:
33665:

Line 34073: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST

34069: */
34070: END IF;
34071:
34072:
34073: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST
34074: LOOP
34075: INSERT INTO OKS_K_LINES_TLH (
34076: id,
34077: MAJOR_VERSION,

Line 34094: OKC_UTIL.g_language_code(lang_i),

34090: last_update_login)
34091: VALUES(
34092: P_CLE_ID,
34093: p_MAJOR_VERSION,
34094: OKC_UTIL.g_language_code(lang_i),
34095: L_USERENV_LANG,
34096: 'S',
34097: L_invoice_text,
34098: L_ib_trx_details,

Line 34248: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST

34244: */
34245: END IF;
34246:
34247:
34248: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST
34249: LOOP
34250: Update oks_k_lines_tlh
34251: set INVOICE_TEXT = L_INVOICE_TEXT
34252: ,IB_TRX_DETAILS = L_IB_TRX_DETAILS

Line 34256: and language = OKC_UTIL.g_language_code(lang_i)

34252: ,IB_TRX_DETAILS = L_IB_TRX_DETAILS
34253: ,STATUS_TEXT = L_STATUS_TEXT
34254: ,React_Time_Name = RCN_REACT_TIME_NAME
34255: Where id = p_cle_id
34256: and language = OKC_UTIL.g_language_code(lang_i)
34257: and source_lang = L_USERENV_LANG
34258: and major_version = p_major_version;
34259:
34260: END LOOP;

Line 37973: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;

37969: Cursor Cur_Klin_exists(p_cleid in number) IS
37970: select 'x'
37971: from oks_k_lines_b
37972: where cle_id=p_cleid;
37973: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;
37974: l_NOT_FOUND NUMBER := 0;
37975:
37976: BEGIN ----MAIN BEGIN
37977: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');

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

38028: REACT_ACTIVE_YN = REC_RCN_RSN_INFO.RCN_REACT_ACTIVE_YN
38029: WHERE CLE_ID = L_CLE_ID
38030: AND DNZ_CHR_ID = L_DNZ_CHR_ID;
38031:
38032: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
38033: UPDATE OKS_K_LINES_TL SET
38034: REACT_TIME_NAME = REC_RCN_RSN_INFO.RCN_REACT_TIME_NAME
38035: WHERE id= (SELECT id FROM OKS_K_LINES_B
38036: WHERE CLE_ID = L_CLE_ID

Line 38038: AND language = OKC_UTIL.g_language_code(lang_i)

38034: REACT_TIME_NAME = REC_RCN_RSN_INFO.RCN_REACT_TIME_NAME
38035: WHERE id= (SELECT id FROM OKS_K_LINES_B
38036: WHERE CLE_ID = L_CLE_ID
38037: AND DNZ_CHR_ID = L_DNZ_CHR_ID)
38038: AND language = OKC_UTIL.g_language_code(lang_i)
38039: AND source_lang = L_USERENV_LANG ;
38040: END LOOP;
38041: END;
38042: ELSE

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

38072: ,SYSDATE
38073: ,2003);
38074:
38075:
38076: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
38077: INSERT INTO OKS_K_LINES_TL(
38078: ID
38079: ,LANGUAGE
38080: ,SOURCE_LANG

Line 38094: ,OKC_UTIL.g_language_code(lang_i)

38090: ,LAST_UPDATE_DATE
38091: ,LAST_UPDATE_LOGIN)
38092: VALUES
38093: (REC_RCN_RSN_INFO.ID
38094: ,OKC_UTIL.g_language_code(lang_i)
38095: ,L_USERENV_LANG
38096: ,'S'
38097: ,NULL
38098: ,NULL

Line 38288: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;

38284: from oks_k_lines_bh
38285: where cle_id=p_cleid
38286: AND MAJOR_VERSION = p_MAJOR_VERSION;
38287:
38288: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;
38289:
38290: l_NOT_FOUND NUMBER := 0;
38291:
38292: BEGIN

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

38349: WHERE CLE_ID = L_CLE_ID
38350: AND DNZ_CHR_ID = L_DNZ_CHR_ID
38351: AND MAJOR_VERSION = L_MAJOR_VERSION;
38352:
38353: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
38354: UPDATE OKS_K_LINES_TLH SET
38355: REACT_TIME_NAME = REC_RCN_RSN_INFO.RCN_REACT_TIME_NAME
38356: WHERE id= (SELECT id FROM OKS_K_LINES_BH
38357: WHERE CLE_ID = L_CLE_ID

Line 38361: AND language = OKC_UTIL.g_language_code(lang_i)

38357: WHERE CLE_ID = L_CLE_ID
38358: AND DNZ_CHR_ID = L_DNZ_CHR_ID
38359: AND MAJOR_VERSION = L_MAJOR_VERSION)
38360: AND MAJOR_VERSION = L_MAJOR_VERSION
38361: AND language = OKC_UTIL.g_language_code(lang_i)
38362: AND source_lang = L_USERENV_LANG ;
38363: END LOOP;
38364: END;
38365: ELSE

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

38398: ,SYSDATE
38399: ,2003);
38400:
38401:
38402: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
38403: INSERT INTO OKS_K_LINES_TLH(
38404: ID
38405: ,LANGUAGE
38406: ,SOURCE_LANG

Line 38421: ,OKC_UTIL.g_language_code(lang_i)

38417: ,LAST_UPDATE_LOGIN
38418: ,MAJOR_VERSION)
38419: VALUES
38420: (REC_RCN_RSN_INFO.ID
38421: ,OKC_UTIL.g_language_code(lang_i)
38422: ,L_USERENV_LANG
38423: ,'S'
38424: ,NULL
38425: ,NULL

Line 38810: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;

38806: L_RET INTEGER;
38807: rc INTEGER;
38808: trunc_curs INTEGER;
38809: l_truncate_string varchar2(2000);
38810: L_USERENV_LANG VARCHAR2(100) := OKC_UTIL.get_userenv_lang ;
38811:
38812: ---------Variables for collecting table stats -----------------
38813: L_RETURN_CODE VARCHAR2(100);
38814: L_ERROR_BUFFER VARCHAR2(2000);

Line 38943: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST

38939: ,1
38940: ,SYSDATE
38941: ,2003 );
38942:
38943: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST
38944: LOOP
38945: FORALL I IN L_LINE_ID.FIRST..L_LINE_ID.LAST
38946: INSERT INTO OKS_K_LINES_TL (ID
38947: ,LANGUAGE

Line 38957: ,OKC_UTIL.g_language_code(lang_i)

38953: ,last_update_date
38954: ,last_update_login)
38955: VALUES(
38956: L_LINE_ID(I)
38957: ,OKC_UTIL.g_language_code(lang_i)
38958: ,L_USERENV_LANG
38959: ,'S'
38960: ,1
38961: ,sysdate