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_BH

Line 27246: INSERT INTO OKS_K_LINES_BH

27242: --Attempting to insert records first
27243: --as OKS_RULE_REPROCESS might have many records with no data issue
27244:
27245: BEGIN
27246: INSERT INTO OKS_K_LINES_BH
27247: ( ID
27248: ,MAJOR_VERSION
27249: ,CLE_ID
27250: ,DNZ_CHR_ID

Line 27470: INSERT INTO OKS_K_LINES_BH (ID

27466: CLOSE L_CHECK_RGP_CSR;
27467:
27468: If( l_cle_id is not null) then
27469:
27470: INSERT INTO OKS_K_LINES_BH (ID
27471: ,MAJOR_VERSION
27472: ,CLE_ID
27473: ,DNZ_CHR_ID
27474: ,OBJECT_VERSION_NUMBER

Line 33633: --in oks_k_lines_bh

33629: AND RUL.RULE_INFORMATION_CATEGORY = P_CATEGORY ;
33630:
33631: -----------------------------------------------------------------------------
33632: --Cursor to check if the records corresponding to cle_id exists
33633: --in oks_k_lines_bh
33634: -----------------------------------------------------------------------------
33635:
33636: Cursor Cur_Klin_exists(p_cleid in number) IS
33637: select 'x'

Line 33638: from oks_k_lines_bh

33634: -----------------------------------------------------------------------------
33635:
33636: Cursor Cur_Klin_exists(p_cleid in number) IS
33637: select 'x'
33638: from oks_k_lines_bh
33639: where cle_id=p_cleid
33640: and major_version = p_major_version;
33641:
33642: ------------------------------------------------------------------------------

Line 33885: INSERT INTO OKS_K_LINES_BH

33881: END;
33882:
33883: If(Eflag<>1) Then
33884: BEGIN
33885: INSERT INTO OKS_K_LINES_BH
33886: ( ID
33887: ,MAJOR_VERSION
33888: ,CLE_ID
33889: ,DNZ_CHR_ID

Line 34144: --Updating oks_k_lines_bh

34140: END;
34141:
34142: If(Eflag<> 1) Then
34143:
34144: --Updating oks_k_lines_bh
34145: BEGIN
34146: Update oks_k_lines_bh set
34147: DISCOUNT_LIST = DISCOUNT_LIST_CHR
34148: ,ACCT_RULE_ID = ACCT_RULE_ID_CHR

Line 34146: Update oks_k_lines_bh set

34142: If(Eflag<> 1) Then
34143:
34144: --Updating oks_k_lines_bh
34145: BEGIN
34146: Update oks_k_lines_bh set
34147: DISCOUNT_LIST = DISCOUNT_LIST_CHR
34148: ,ACCT_RULE_ID = ACCT_RULE_ID_CHR
34149: ,PAYMENT_TYPE = L_PAYMENT_TYPE
34150: ,CC_NO = L_CC_NO

Line 34271: Delete from oks_k_lines_bh where cle_id = P_Cle_ID

34267: End If;
34268:
34269: Else ---l_check_var is not null
34270: BEGIN
34271: Delete from oks_k_lines_bh where cle_id = P_Cle_ID
34272: and major_version = p_major_version;
34273:
34274: UPDATE OKC_K_LINES_BH
34275: SET CUST_ACCT_ID = CUST_ACCT_ID_CHR

Line 37461: from oks_k_lines_bh

37457: where cle_id=p_cleid;
37458:
37459: Cursor Cur_Klinh_exists(p_cleid in number,p_major_version IN NUMBER) IS
37460: select 'x'
37461: from oks_k_lines_bh
37462: where cle_id=p_cleid
37463: AND major_version = p_major_version;
37464: -----------------------------------------------------------------------------
37465: --Cursor to check if the records corresponding to rgp_id exists

Line 37610: DELETE FROM OKS_K_LINES_BH

37606: Close Cur_RGPH_exists;
37607:
37608: If(l_check_var is null) Then
37609:
37610: DELETE FROM OKS_K_LINES_BH
37611: WHERE cle_id = P_Cle_ID
37612: AND major_version = l_major_version;
37613:
37614: else

Line 37626: UPDATE OKS_K_LINES_BH T1

37622:
37623: If(l_check_var is NOT NULL) THEN
37624:
37625:
37626: UPDATE OKS_K_LINES_BH T1
37627: SET (T1.offset_period ,T1.offset_duration) =
37628: (SELECT TIM2.UOM_CODE,TIM2.DURATION
37629: FROM okc_timevalues_bh TIM ,okc_timevalues_bh TIM2,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP
37630: WHERE RGP.CLE_ID = l_cle_id

Line 37656: INSERT INTO OKS_K_LINES_BH

37652: Fetch Cur_Off_Period_H into l_off_period,l_off_duraion;
37653: Close Cur_Off_Period_H;
37654:
37655:
37656: INSERT INTO OKS_K_LINES_BH
37657: ( ID
37658: ,CLE_ID
37659: ,DNZ_CHR_ID
37660: ,MAJOR_VERSION

Line 37835: Delete from oks_k_lines_bh where cle_id = P_Cle_ID and major_version = L_MAJOR_VERSION;

37831: Close Cur_RGPH_exists;
37832:
37833: If(l_check_var is null) Then
37834:
37835: Delete from oks_k_lines_bh where cle_id = P_Cle_ID and major_version = L_MAJOR_VERSION;
37836: END IF;
37837:
37838: DELETE OKS_COVERAGE_TIMES_H
37839: WHERE COV_TZE_LINE_ID IN (SELECT ID FROM OKS_COVERAGE_TIMEZONES_H

Line 38284: from oks_k_lines_bh

38280: REC_RCN_RSN_INFO GET_RCN_RSN_INFO%ROWTYPE;
38281:
38282: Cursor Cur_Klin_exists(p_cleid in number,p_major_version in number) IS
38283: select 'x'
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 ;

Line 38343: UPDATE OKS_K_LINES_BH SET

38339: ELSIF((l_check_var is NOT NULL) AND (l_NOT_FOUND = 0)) THEN
38340:
38341: --Updating oks_k_lines_b
38342: BEGIN
38343: UPDATE OKS_K_LINES_BH SET
38344: INCIDENT_SEVERITY_ID = REC_RCN_RSN_INFO.RCN_INCIDENT_SEVERITY_ID,
38345: PDF_ID = REC_RCN_RSN_INFO.RCN_PDF_ID,
38346: --REACT_TIME_NAME = REC_RCN_RSN_INFO.RCN_REACT_TIME_NAME,
38347: WORK_THRU_YN = REC_RCN_RSN_INFO.RCN_WORK_THRU_YN,

Line 38356: WHERE id= (SELECT id FROM OKS_K_LINES_BH

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
38359: AND MAJOR_VERSION = L_MAJOR_VERSION)
38360: AND MAJOR_VERSION = L_MAJOR_VERSION

Line 38369: INSERT INTO OKS_K_LINES_BH (

38365: ELSE
38366: BEGIN
38367: IF (l_check_var is NOT NULL) THEN
38368:
38369: INSERT INTO OKS_K_LINES_BH (
38370: ID
38371: ,CLE_ID
38372: ,DNZ_CHR_ID
38373: ,INCIDENT_SEVERITY_ID