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_B

Line 21278: Update oks_k_lines_b okso

21274: where okci.cle_id = okco.id)
21275: Where okco.lse_id in ( 1,12,19)
21276: and okco.dnz_chr_id = l_lock_id;
21277:
21278: Update oks_k_lines_b okso
21279: Set okso.tax_amount = ( Select oksi.tax_amount
21280: From oks_k_lines_b oksi
21281: , okc_k_lines_b okci
21282: Where okci.lse_id =46

Line 21280: From oks_k_lines_b oksi

21276: and okco.dnz_chr_id = l_lock_id;
21277:
21278: Update oks_k_lines_b okso
21279: Set okso.tax_amount = ( Select oksi.tax_amount
21280: From oks_k_lines_b oksi
21281: , okc_k_lines_b okci
21282: Where okci.lse_id =46
21283: and okci.id = oksi.cle_id
21284: and oksi.cle_id = okso.cle_id

Line 23064: Update oks_k_lines_b set

23060: End;
23061:
23062: If rowcount > 0 then --Label BB
23063: Begin
23064: Update oks_k_lines_b set
23065: discount_list = discount_list_chr
23066: ,acct_rule_id = acct_rule_id_chr
23067: ,grace_duration = grace_duration_chr
23068: ,grace_period = l_grace_period

Line 23139: update oks_k_lines_b t1

23135: If rowcount > 0 then -- Lable GG
23136: Begin
23137: If l_offset_duration is not null then -- Label FF
23138: l_upd_cle_id := l_cle_id ;
23139: update oks_k_lines_b t1
23140: set (t1.offset_period ,t1.offset_duration) =
23141: (select tim2.uom_code,tim2.duration
23142: from okc_timevalues_b tim ,okc_timevalues_b tim2,okc_rules_b rul,okc_rule_groups_b rgp
23143: where tim.id = offset_duration

Line 23226: Insert into oks_k_lines_b

23222: End;
23223: End If; --Label DD
23224: Elsif rowcount = 0 then -- Label CC
23225: Begin
23226: Insert into oks_k_lines_b
23227: ( id
23228: ,cle_id
23229: ,dnz_chr_id
23230: ,discount_list

Line 23430: update oks_k_lines_b t1

23426: If rowcount > 0 then -- Label II
23427: Begin
23428: If l_offset_duration is not null then
23429: l_upd_cle_id := cle_id ;
23430: update oks_k_lines_b t1
23431: set (t1.offset_period ,t1.offset_duration) =
23432: (select tim2.uom_code,tim2.duration
23433: from okc_timevalues_b tim ,okc_timevalues_b tim2,okc_rules_b rul,okc_rule_groups_b rgp
23434: where tim.id = offset_duration

Line 23466: insert into oks_k_lines_b(

23462: Fetch l_check_rgp_csr into l_id,l_dnz_chr_id;
23463: Close l_check_rgp_csr;
23464: If id is not null then -- Label EE
23465: Begin
23466: insert into oks_k_lines_b(
23467: id
23468: ,cle_id
23469: ,dnz_chr_id
23470: ,cust_po_number --to synchronize hdr value to line

Line 26424: Update oks_k_lines_b oks

26420: ,l_price_list_id
26421: ,l_dnz_chr_id ;
26422: close l_synhl_csr ;
26423:
26424: Update oks_k_lines_b oks
26425: set oks.payment_type = l_payment_type
26426: , oks.cc_no = l_cc_no
26427: , oks.cc_expiry_date = l_cc_expiry_date
26428: --, oks.cc_bank_acct_id = l_cc_bank_acct_id

Line 26433: from oks_k_lines_b oksi

26429: --, oks.cc_auth_code = l_cc_auth_code
26430: , oks.cust_po_number = l_cust_po_number
26431: , oks.cust_po_number_req_yn = l_cust_po_number_req_yn
26432: , oks.tax_amount = ( select oksi.tax_amount
26433: from oks_k_lines_b oksi
26434: , okc_k_lines_b okci
26435: where okci.lse_id = 46
26436: and okci.id = oksi.cle_id
26437: and oksi.cle_id = oks.cle_id

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 27402: UPDATE OKS_K_LINES_B T1

27398:
27399: IF l_OFFSET_DURATION IS NOT NULL THEN
27400: l_upd_cle_id := cle_id;
27401:
27402: UPDATE OKS_K_LINES_B T1
27403: SET (T1.offset_period ,T1.offset_duration) =
27404: (SELECT TIM2.UOM_CODE,TIM2.DURATION
27405: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
27406: WHERE TIM.Id = OFFSET_DURATION

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 30071: Update oks_k_lines_b oks

30067: ,l_price_list_idi
30068: ,l_dnz_chr_idi ;
30069: close l_synhl_csr ;
30070:
30071: Update oks_k_lines_b oks
30072: set oks.payment_type = l_payment_typei
30073: , oks.cc_no = l_cc_noi
30074: , oks.cc_expiry_date = l_cc_expiry_datei
30075: --, oks.cc_bank_acct_id = l_cc_bank_acct_idi

Line 30080: from oks_k_lines_b oksi

30076: --, oks.cc_auth_code = l_cc_auth_codei
30077: , oks.cust_po_number = l_cust_po_numberi
30078: , oks.cust_po_number_req_yn = l_cust_po_number_req_yni
30079: , oks.tax_amount = ( select oksi.tax_amount
30080: from oks_k_lines_b oksi
30081: , okc_k_lines_b okci
30082: where okci.lse_id = 46
30083: and okci.id = oksi.cle_id
30084: and oksi.cle_id = oks.cle_id

Line 31552: --in oks_k_lines_b

31548:
31549: L_LINE_DTLS_REC L_LINE_DTLS_CSR%ROWTYPE;
31550: -----------------------------------------------------------------------------
31551: --Cursor to check if the records corresponding to CLE_ID exists
31552: --in oks_k_lines_b
31553: -----------------------------------------------------------------------------
31554: Cursor Cur_Klin_exists(p_cleid in number) IS
31555: select 'x'
31556: from oks_k_lines_b

Line 31556: from oks_k_lines_b

31552: --in oks_k_lines_b
31553: -----------------------------------------------------------------------------
31554: Cursor Cur_Klin_exists(p_cleid in number) IS
31555: select 'x'
31556: from oks_k_lines_b
31557: where cle_id=p_cleid;
31558:
31559: -----------------------------------------------------------------------------
31560: --Cursor to check if the records corresponding to rgp_id exists

Line 31824: -- Begin of code to check if the row exists in oks_k_lines_b

31820:
31821: Eflag:=0;
31822: Emsg:=NULL;
31823:
31824: -- Begin of code to check if the row exists in oks_k_lines_b
31825: l_check_var:=NULL;
31826: Open Cur_Klin_exists(P_Cle_ID);
31827: Fetch Cur_Klin_exists into l_check_var;
31828: Close Cur_Klin_exists;

Line 31858: INSERT INTO OKS_K_LINES_B

31854: END;
31855:
31856: If(Eflag<>1) Then
31857: BEGIN
31858: INSERT INTO OKS_K_LINES_B
31859: ( ID
31860: ,CLE_ID
31861: ,DNZ_CHR_ID
31862: ,DISCOUNT_LIST

Line 32026: UPDATE OKS_K_LINES_B T1

32022: ,1 );
32023:
32024:
32025: IF L_OFFSET_DURATION IS NOT NULL THEN
32026: UPDATE OKS_K_LINES_B T1
32027: SET (T1.offset_period ,T1.offset_duration) =
32028: (SELECT TIM2.UOM_CODE,TIM2.DURATION
32029: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
32030: WHERE TIM.Id = OFFSET_DURATION

Line 32110: --Updating oks_k_lines_b

32106: Emsg :=SQLERRM;
32107: END;
32108:
32109: If(Eflag<> 1) Then
32110: --Updating oks_k_lines_b
32111: BEGIN
32112: Update oks_k_lines_b set
32113: DISCOUNT_LIST = DISCOUNT_LIST_CHR
32114: ,ACCT_RULE_ID = ACCT_RULE_ID_CHR

Line 32112: Update oks_k_lines_b set

32108:
32109: If(Eflag<> 1) Then
32110: --Updating oks_k_lines_b
32111: BEGIN
32112: Update oks_k_lines_b set
32113: DISCOUNT_LIST = DISCOUNT_LIST_CHR
32114: ,ACCT_RULE_ID = ACCT_RULE_ID_CHR
32115: --,PAYMENT_TYPE = L_PAYMENT_TYPE
32116: --,CC_NO = L_CC_NO

Line 32190: UPDATE OKS_K_LINES_B T1

32186: Where cle_id=p_cle_id;
32187:
32188: IF L_OFFSET_DURATION IS NOT NULL THEN
32189:
32190: UPDATE OKS_K_LINES_B T1
32191: SET (T1.offset_period ,T1.offset_duration) =
32192: (SELECT TIM2.UOM_CODE,TIM2.DURATION
32193: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
32194: WHERE TIM.Id = L_OFFSET_DURATION

Line 32228: Delete from oks_k_lines_b where cle_id = P_Cle_ID;

32224:
32225: End If;
32226: Else ---l_check_var is not null
32227: BEGIN
32228: Delete from oks_k_lines_b where cle_id = P_Cle_ID;
32229:
32230: UPDATE OKC_K_LINES_B
32231: SET CUST_ACCT_ID = CUST_ACCT_ID_CHR
32232: , BILL_TO_SITE_USE_ID = BILL_TO_SITE_USE_ID_CHR

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 34042: UPDATE OKS_K_LINES_B T1

34038: ,1 );
34039:
34040: IF L_OFFSET_DURATION IS NOT NULL THEN
34041:
34042: UPDATE OKS_K_LINES_B T1
34043: SET (T1.offset_period ,T1.offset_duration) =
34044: (SELECT TIM2.UOM_CODE,TIM2.DURATION
34045: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
34046: WHERE TIM.Id = L_OFFSET_DURATION

Line 34056: UPDATE OKS_K_LINES_B T1

34052: AND TIM.DNZ_CHR_ID = TIM2.DNZ_CHR_ID
34053: AND T1.CLE_ID = RGP.CLE_ID)
34054: WHERE T1.CLE_ID = p_cle_id;
34055: /*
34056: UPDATE OKS_K_LINES_B T1
34057: SET (T1.offset_period ,T1.offset_duration) =
34058: (SELECT UOM_CODE,DURATION
34059: FROM okc_timevalues_b TIM ,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
34060: WHERE RUL.Id = L_OFFSET_DURATION

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 34217: UPDATE OKS_K_LINES_B T1

34213: and major_version = p_major_version;
34214:
34215: IF L_OFFSET_DURATION IS NOT NULL THEN
34216:
34217: UPDATE OKS_K_LINES_B T1
34218: SET (T1.offset_period ,T1.offset_duration) =
34219: (SELECT TIM2.UOM_CODE,TIM2.DURATION
34220: FROM okc_timevalues_b TIM ,okc_timevalues_b TIM2,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
34221: WHERE TIM.Id = L_OFFSET_DURATION

Line 34231: UPDATE OKS_K_LINES_B T1

34227: AND TIM.DNZ_CHR_ID = TIM2.DNZ_CHR_ID
34228: AND T1.CLE_ID = RGP.CLE_ID)
34229: WHERE T1.CLE_ID = p_cle_id;
34230: /*
34231: UPDATE OKS_K_LINES_B T1
34232: SET (T1.offset_period ,T1.offset_duration) =
34233: (SELECT UOM_CODE,DURATION
34234: FROM okc_timevalues_b TIM ,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
34235: WHERE RUL.Id = L_OFFSET_DURATION

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 37451: --in oks_k_lines_b

37447: L_ERROR_MSG VARCHAR2(2000);
37448:
37449: -----------------------------------------------------------------------------
37450: --Cursor to check if the records corresponding to CLE_ID exists
37451: --in oks_k_lines_b
37452: -----------------------------------------------------------------------------
37453:
37454: Cursor Cur_Klin_exists(p_cleid in number) IS
37455: select 'x'

Line 37456: from oks_k_lines_b

37452: -----------------------------------------------------------------------------
37453:
37454: Cursor Cur_Klin_exists(p_cleid in number) IS
37455: select 'x'
37456: from oks_k_lines_b
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'

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 37537: Delete from oks_k_lines_b where cle_id = P_Cle_ID;

37533: Close Cur_RGP_exists;
37534:
37535: If(l_check_var is null) Then
37536:
37537: Delete from oks_k_lines_b where cle_id = P_Cle_ID;
37538:
37539: else
37540:
37541: l_check_var:=NULL;

Line 37550: UPDATE OKS_K_LINES_B T1

37546:
37547: If(l_check_var is NOT NULL) THEN
37548:
37549:
37550: UPDATE OKS_K_LINES_B T1
37551: SET (T1.offset_period ,T1.offset_duration) =
37552: (SELECT TIM2.UOM_CODE,TIM2.DURATION
37553: FROM okc_timevalues_b TIM,okc_timevalues_b TIM2 ,okc_rules_b Rul,OKC_RULE_GROUPS_B RGP
37554: WHERE RGP.CLE_ID = l_cle_id

Line 37573: INSERT INTO OKS_K_LINES_B

37569: Fetch Cur_Off_Period into l_off_period,l_off_duraion;
37570: Close Cur_Off_Period;
37571:
37572:
37573: INSERT INTO OKS_K_LINES_B
37574: ( ID
37575: ,CLE_ID
37576: ,DNZ_CHR_ID
37577: ,OFFSET_PERIOD

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 37745: Delete from oks_k_lines_b where cle_id = L_Cle_ID;

37741: Fetch Cur_RGP_exists into l_check_var;
37742: Close Cur_RGP_exists;
37743:
37744: IF(l_check_var is null) THEN
37745: Delete from oks_k_lines_b where cle_id = L_Cle_ID;
37746: END IF;
37747:
37748: DELETE OKS_COVERAGE_TIMES
37749: WHERE COV_TZE_LINE_ID IN (SELECT ID FROM OKS_COVERAGE_TIMEZONES

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 37971: from oks_k_lines_b

37967: REC_RCN_RSN_INFO GET_RCN_RSN_INFO%ROWTYPE;
37968:
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:

Line 38012: WHERE ID IN (SELECT ID FROM OKS_K_LINES_B WHERE CLE_ID = l_CLE_ID

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
38016: WHERE CLE_ID = l_CLE_ID;

Line 38015: DELETE OKS_K_LINES_B

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
38016: WHERE CLE_ID = l_CLE_ID;
38017:
38018: ELSIF((l_check_var is NOT NULL) AND (l_NOT_FOUND = 0)) THEN
38019:

Line 38021: --Updating oks_k_lines_b

38017:
38018: ELSIF((l_check_var is NOT NULL) AND (l_NOT_FOUND = 0)) THEN
38019:
38020:
38021: --Updating oks_k_lines_b
38022: BEGIN
38023: UPDATE OKS_K_LINES_B SET
38024: INCIDENT_SEVERITY_ID = REC_RCN_RSN_INFO.RCN_INCIDENT_SEVERITY_ID,
38025: PDF_ID = REC_RCN_RSN_INFO.RCN_PDF_ID,

Line 38023: UPDATE OKS_K_LINES_B SET

38019:
38020:
38021: --Updating oks_k_lines_b
38022: BEGIN
38023: UPDATE OKS_K_LINES_B SET
38024: INCIDENT_SEVERITY_ID = REC_RCN_RSN_INFO.RCN_INCIDENT_SEVERITY_ID,
38025: PDF_ID = REC_RCN_RSN_INFO.RCN_PDF_ID,
38026: --REACT_TIME_NAME = REC_RCN_RSN_INFO.RCN_REACT_TIME_NAME,
38027: WORK_THRU_YN = REC_RCN_RSN_INFO.RCN_WORK_THRU_YN,

Line 38035: WHERE id= (SELECT id FROM OKS_K_LINES_B

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)
38038: AND language = OKC_UTIL.g_language_code(lang_i)
38039: AND source_lang = L_USERENV_LANG ;

Line 38045: INSERT INTO OKS_K_LINES_B (

38041: END;
38042: ELSE
38043: BEGIN
38044: IF (l_check_var is NOT NULL) THEN
38045: INSERT INTO OKS_K_LINES_B (
38046: ID
38047: ,CLE_ID
38048: ,DNZ_CHR_ID
38049: ,INCIDENT_SEVERITY_ID

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 38331: WHERE ID IN (SELECT ID FROM OKS_K_LINES_B

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:
38335: DELETE OKS_K_LINES_B

Line 38335: DELETE OKS_K_LINES_B

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:
38335: DELETE OKS_K_LINES_B
38336: WHERE CLE_ID = l_CLE_ID
38337: AND DNZ_CHR_ID = L_DNZ_CHR_ID;
38338:
38339: ELSIF((l_check_var is NOT NULL) AND (l_NOT_FOUND = 0)) THEN

Line 38341: --Updating oks_k_lines_b

38337: AND DNZ_CHR_ID = L_DNZ_CHR_ID;
38338:
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,

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

Line 38780: AND NOT EXISTS ( SELECT 1 FROM OKS_K_LINES_B OKS1

38776: , OKCH.PRICE_LIST_ID
38777: FROM OKS_RULE_UPGRADE UPG
38778: , OKC_K_HEADERS_B OKCH
38779: WHERE UPG.RIC_CODE = 'LIN'
38780: AND NOT EXISTS ( SELECT 1 FROM OKS_K_LINES_B OKS1
38781: WHERE OKS1.CLE_ID = UPG.RGP_ID )
38782: AND OKCH.ID = UPG.DNZ_CHR_ID
38783: GROUP BY UPG.RGP_ID, UPG.DNZ_CHR_ID, CUST_PO_NUMBER, CUST_PO_NUMBER_REQ_YN, PRICE_LIST_ID ;
38784:

Line 38899: AND EXISTS ( SELECT 1 FROM OKS_K_LINES_B OKS

38895:
38896: DELETE /*+ PARALLEL(UPG1) */
38897: FROM OKS_RULE_UPGRADE UPG1
38898: WHERE UPG1.RIC_CODE = 'LIN'
38899: AND EXISTS ( SELECT 1 FROM OKS_K_LINES_B OKS
38900: WHERE OKS.CLE_ID = UPG1.RGP_ID );
38901: COMMIT;
38902:
38903:

Line 38918: INSERT /+ PARALLEL(OKS) / INTO OKS_K_LINES_B OKS

38914: CLOSE L_UPGLINE_CSR;
38915:
38916: IF L_LINE_ID.COUNT > 0 THEN
38917: FORALL I IN L_LINE_ID.FIRST..L_LINE_ID.LAST
38918: INSERT /*+ PARALLEL(OKS) */ INTO OKS_K_LINES_B OKS
38919: (ID
38920: ,CLE_ID
38921: ,DNZ_CHR_ID
38922: ,CUST_PO_NUMBER