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 OKS_K_LINES_TL

Line 23165: Update oks_k_lines_tl

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
23168: ,status_text = l_status_text
23169: ,react_time_name = rcn_react_time_name

Line 23185: Insert into oks_k_lines_tl (

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,
23188: source_lang,
23189: sfwt_flag,

Line 23387: Insert into oks_k_lines_tl (

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,
23390: source_lang,
23391: sfwt_flag,

Line 23509: insert into oks_k_lines_tl (id

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
23512: ,sfwt_flag
23513: ,created_by

Line 27421: INSERT INTO OKS_K_LINES_TLH (

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,
27424: language,
27425: source_lang,

Line 27493: INSERT INTO OKS_K_LINES_TLH (ID

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
27496: ,SOURCE_LANG
27497: ,SFWT_FLAG

Line 32043: INSERT INTO OKS_K_LINES_TL (

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,
32046: source_lang,
32047: sfwt_flag,

Line 32208: Update oks_k_lines_tl set

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
32211: ,IB_TRX_DETAILS = L_IB_TRX_DETAILS
32212: ,STATUS_TEXT = L_STATUS_TEXT

Line 34075: INSERT INTO OKS_K_LINES_TLH (

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,
34078: language,
34079: source_lang,

Line 34250: Update oks_k_lines_tlh

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
34253: ,STATUS_TEXT = L_STATUS_TEXT
34254: ,React_Time_Name = RCN_REACT_TIME_NAME

Line 38011: DELETE OKS_K_LINES_TL

38007: Close Cur_Klin_exists;
38008:
38009: IF ((l_check_var is NOT NULL) AND (l_NOT_FOUND = 1) ) THEN
38010:
38011: DELETE OKS_K_LINES_TL
38012: WHERE ID IN (SELECT ID FROM OKS_K_LINES_B WHERE CLE_ID = l_CLE_ID
38013: AND DNZ_CHR_ID = L_DNZ_CHR_ID);
38014:
38015: DELETE OKS_K_LINES_B

Line 38033: UPDATE OKS_K_LINES_TL SET

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
38037: AND DNZ_CHR_ID = L_DNZ_CHR_ID)

Line 38077: INSERT INTO OKS_K_LINES_TL(

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
38081: ,SFWT_FLAG

Line 38330: DELETE OKS_K_LINES_TL

38326:
38327:
38328: IF ((l_check_var is NOT NULL) AND (l_NOT_FOUND = 1) ) THEN
38329:
38330: DELETE OKS_K_LINES_TL
38331: WHERE ID IN (SELECT ID FROM OKS_K_LINES_B
38332: WHERE CLE_ID = l_CLE_ID
38333: AND DNZ_CHR_ID = L_DNZ_CHR_ID);
38334:

Line 38354: UPDATE OKS_K_LINES_TLH SET

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
38358: AND DNZ_CHR_ID = L_DNZ_CHR_ID

Line 38403: INSERT INTO OKS_K_LINES_TLH(

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
38407: ,SFWT_FLAG

Line 38946: INSERT INTO OKS_K_LINES_TL (ID

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
38948: ,SOURCE_LANG
38949: ,SFWT_FLAG
38950: ,created_by