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_K_LINES_B

Line 27: FROM OKC_K_LINES_B L

23: FUNCTION GET_DATA_VOLUME RETURN NUMBER IS
24:
25: CURSOR L_DATA_VOLUME_CSR IS
26: SELECT /*+ PARALLEL(L) */ COUNT(*)
27: FROM OKC_K_LINES_B L
28: WHERE LSE_ID IN (1,2,3,4,5,6,7,8,9,10,11,35, 12,13,14,15,16,17,18,19,20,21,22,23,24,46) ;
29: L_COUNT NUMBER;
30: BEGIN
31:

Line 4402: , OKC_K_LINES_B LIN

4398: , RGP.ID RGP_ID
4399: FROM OKC_K_HEADERS_B HDR
4400: , OKC_RULE_GROUPS_B RGP
4401: , OKC_RULES_B RUL
4402: , OKC_K_LINES_B LIN
4403: WHERE HDR.ID = P_HDR_ID
4404: AND LIN.ID= P_CLE_ID
4405: AND RGP.DNZ_CHR_ID = P_HDR_ID
4406: AND RGP.DNZ_CHR_ID = RUL.DNZ_CHR_ID

Line 6855: , OKC_K_LINES_BH LIN

6851: , RGP.ID RGP_ID
6852: FROM OKC_K_HEADERS_BH HDR
6853: , OKC_RULE_GROUPS_BH RGP
6854: , OKC_RULES_BH RUL
6855: , OKC_K_LINES_BH LIN
6856: WHERE HDR.ID = P_HDR_ID
6857: AND LIN.ID= P_CLE_ID
6858: AND RGP.DNZ_CHR_ID = P_HDR_ID
6859: AND RGP.DNZ_CHR_ID = RUL.DNZ_CHR_ID

Line 12281: , OKC_K_LINES_B LIN

12277: , RGP.ID RGP_ID
12278: FROM OKC_K_HEADERS_B HDR
12279: , OKC_RULE_GROUPS_B RGP
12280: , OKC_RULES_B RUL
12281: , OKC_K_LINES_B LIN
12282: WHERE HDR.ID = P_HDR_ID
12283: AND LIN.ID= P_CLE_ID
12284: AND RGP.DNZ_CHR_ID = P_HDR_ID
12285: AND RGP.CLE_ID = LIN.ID

Line 17130: , OKC_K_LINES_BH LIN

17126: , RGP.ID RGP_ID
17127: FROM OKC_K_HEADERS_BH HDR
17128: , OKC_RULE_GROUPS_BH RGP
17129: , OKC_RULES_BH RUL
17130: , OKC_K_LINES_BH LIN
17131: WHERE HDR.ID = P_HDR_ID
17132: AND LIN.ID= P_CLE_ID
17133: AND RGP.DNZ_CHR_ID = P_HDR_ID
17134: AND RGP.DNZ_CHR_ID = RUL.DNZ_CHR_ID

Line 20800: -- Cursor to lock okc_k_lines_b before going for update

20796: FROM OKC_RULE_GROUPS_B
20797: WHERE ID = P_ID;
20798:
20799: -------------------------------------------------------
20800: -- Cursor to lock okc_k_lines_b before going for update
20801: -------------------------------------------------------
20802: CURSOR L_LOCK_LINE_CSR (p_rgp_id in number ) IS
20803: SELECT OKC.DNZ_CHR_ID
20804: FROM OKC_K_LINES_B OKC

Line 20804: FROM OKC_K_LINES_B OKC

20800: -- Cursor to lock okc_k_lines_b before going for update
20801: -------------------------------------------------------
20802: CURSOR L_LOCK_LINE_CSR (p_rgp_id in number ) IS
20803: SELECT OKC.DNZ_CHR_ID
20804: FROM OKC_K_LINES_B OKC
20805: , OKC_RULE_GROUPS_B RGP
20806: WHERE OKC.DNZ_CHR_ID = RGP.DNZ_CHR_ID
20807: AND RGP.ID = p_rgp_id
20808: AND LSE_ID in ( 1,12,19,46)

Line 21271: Update okc_k_lines_b okco

21267: End ;
21268:
21269: If ieflag <> 1 then
21270: Begin
21271: Update okc_k_lines_b okco
21272: Set okco.price_negotiated = ( select sum(okci.price_negotiated)
21273: from okc_k_lines_b okci
21274: where okci.cle_id = okco.id)
21275: Where okco.lse_id in ( 1,12,19)

Line 21273: from okc_k_lines_b okci

21269: If ieflag <> 1 then
21270: Begin
21271: Update okc_k_lines_b okco
21272: Set okco.price_negotiated = ( select sum(okci.price_negotiated)
21273: from okc_k_lines_b okci
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:

Line 21281: , okc_k_lines_b okci

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
21285: and okci.id = okso.cle_id )

Line 21287: and exists (select 1 from okc_k_lines_b okc

21283: and okci.id = oksi.cle_id
21284: and oksi.cle_id = okso.cle_id
21285: and okci.id = okso.cle_id )
21286: Where okso.dnz_chr_id = l_lock_id
21287: and exists (select 1 from okc_k_lines_b okc
21288: where okc.id = okso.cle_id
21289: and okc.lse_id in ( 1,12,19,46));
21290: Exception
21291: When others then

Line 22400: -- Cursor to lock okc_k_lines_b before going for update

22396: L_LOCK_ID NUMBER;
22397: rowcount number;
22398:
22399: -------------------------------------------------------
22400: -- Cursor to lock okc_k_lines_b before going for update
22401: -------------------------------------------------------
22402: CURSOR L_LOCK_LINE_CSR (p_id in number ) IS
22403: SELECT ID
22404: FROM OKC_K_LINES_B

Line 22404: FROM OKC_K_LINES_B

22400: -- Cursor to lock okc_k_lines_b before going for update
22401: -------------------------------------------------------
22402: CURSOR L_LOCK_LINE_CSR (p_id in number ) IS
22403: SELECT ID
22404: FROM OKC_K_LINES_B
22405: WHERE ID = P_ID
22406: FOR UPDATE NOWAIT;
22407:
22408: Eflag NUMBER;

Line 22755: , OKC_K_LINES_B LIN

22751: , RGP.ID RGP_ID
22752: FROM OKC_K_HEADERS_B HDR
22753: , OKC_RULE_GROUPS_B RGP
22754: , OKC_RULES_B RUL
22755: , OKC_K_LINES_B LIN
22756: WHERE HDR.ID = P_HDR_ID
22757: AND LIN.ID= P_CLE_ID
22758: AND RGP.DNZ_CHR_ID = P_HDR_ID
22759: AND RGP.CLE_ID = LIN.ID

Line 22801: , okc_k_lines_b okcl

22797: , okc.id
22798: , okcl.lse_id
22799: from oks_k_headers_b oks
22800: , okc_k_headers_b okc
22801: , okc_k_lines_b okcl
22802: , okc_rule_groups_b rgp
22803: where oks.chr_id = okc.id
22804: and okcl.lse_id in ( 1,12,19,46)
22805: and okcl.dnz_chr_id = oks.chr_id

Line 23041: Update okc_k_lines_b

23037:
23038: If l_cle_id > 0 then -- Label AA
23039: l_upd_cle_id := l_cle_id;
23040: Begin
23041: Update okc_k_lines_b
23042: Set cust_acct_id = cust_acct_id_chr
23043: ,bill_to_site_use_id = bill_to_site_use_id_chr
23044: ,inv_rule_id = inv_rule_id_chr
23045: ,line_renewal_type_code = l_line_renewal_type_code

Line 26374: -- Cursor to lock okc_k_lines_b before going for update

26370: where oks.chr_id = okc.id
26371: and oks.chr_id = p_id;
26372:
26373: -------------------------------------------------------
26374: -- Cursor to lock okc_k_lines_b before going for update
26375: -------------------------------------------------------
26376: CURSOR L_LOCK_LINE_CSR (p_id in number ) IS
26377: SELECT 1
26378: FROM OKC_K_LINES_B

Line 26378: FROM OKC_K_LINES_B

26374: -- Cursor to lock okc_k_lines_b before going for update
26375: -------------------------------------------------------
26376: CURSOR L_LOCK_LINE_CSR (p_id in number ) IS
26377: SELECT 1
26378: FROM OKC_K_LINES_B
26379: WHERE DNZ_CHR_ID = P_ID
26380: AND LSE_ID in ( 1,12,19,46)
26381: FOR UPDATE NOWAIT;
26382:

Line 26434: , okc_k_lines_b okci

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
26438: and okci.id = oks.cle_id )

Line 26441: select 1 from okc_k_lines_b okc

26437: and oksi.cle_id = oks.cle_id
26438: and okci.id = oks.cle_id )
26439: where oks.dnz_chr_id = p_id
26440: and exists (
26441: select 1 from okc_k_lines_b okc
26442: where okc.id = oks.cle_id
26443: and okc.lse_id in ( 1,12,19,46));
26444:
26445: Update okc_k_lines_b okc

Line 26445: Update okc_k_lines_b okc

26441: select 1 from okc_k_lines_b okc
26442: where okc.id = oks.cle_id
26443: and okc.lse_id in ( 1,12,19,46));
26444:
26445: Update okc_k_lines_b okc
26446: set okc.price_list_id = l_price_list_id
26447: , okc.price_negotiated = ( select sum(okci.price_negotiated)
26448: from okc_k_lines_b okci
26449: where ( okci.cle_id = okc.id OR (okci.id = okc.id and okci.lse_id = 46 )))

Line 26448: from okc_k_lines_b okci

26444:
26445: Update okc_k_lines_b okc
26446: set okc.price_list_id = l_price_list_id
26447: , okc.price_negotiated = ( select sum(okci.price_negotiated)
26448: from okc_k_lines_b okci
26449: where ( okci.cle_id = okc.id OR (okci.id = okc.id and okci.lse_id = 46 )))
26450: where dnz_chr_id = p_id
26451: and lse_id in ( 1,12,19,46);
26452: Exception

Line 26491: , OKC_K_LINES_B LINES

26487: , LINES.ID CLE_ID
26488: , LINES.DNZ_CHR_ID DNZ_CHR_ID
26489: , NVL(LINES.CLE_ID , LINES.ID ) PARENT_CLE_ID
26490: FROM OKC_RULES_B RUL
26491: , OKC_K_LINES_B LINES
26492: , OKC_RULE_GROUPS_B RGP
26493: WHERE RUL.RULE_INFORMATION_CATEGORY = 'SLL'
26494: AND RUL.RGP_ID = RGP.ID
26495: AND RGP.DNZ_CHR_ID = LINES.DNZ_CHR_ID

Line 27029: , OKC_K_LINES_BH LIN

27025: , RGP.ID RGP_ID
27026: FROM OKC_K_HEADERS_BH HDR
27027: , OKC_RULE_GROUPS_BH RGP
27028: , OKC_RULES_BH RUL
27029: , OKC_K_LINES_BH LIN
27030: WHERE HDR.ID = P_HDR_ID
27031: AND LIN.ID= P_CLE_ID
27032: AND RGP.DNZ_CHR_ID = P_HDR_ID
27033: AND RGP.CLE_ID = LIN.ID

Line 27530: UPDATE OKC_K_LINES_BH

27526: if(iEflag = 0) THEN
27527: l_upd_cle_id := cle_id;
27528:
27529: BEGIN
27530: UPDATE OKC_K_LINES_BH
27531: SET
27532: CUST_ACCT_ID = CUST_ACCT_ID_CHR
27533: , BILL_TO_SITE_USE_ID = BILL_TO_SITE_USE_ID_CHR
27534: , INV_RULE_ID = INV_RULE_ID_CHR

Line 29534: -- Cursor to lock okc_k_lines_b before going for update

29530: where oks.chr_id = okc.id
29531: and oks.id = p_id;
29532:
29533: -------------------------------------------------------
29534: -- Cursor to lock okc_k_lines_b before going for update
29535: -------------------------------------------------------
29536: CURSOR L_LOCK_LINE_CSR (p_id in number ) IS
29537: SELECT 1
29538: FROM OKC_K_LINES_B

Line 29538: FROM OKC_K_LINES_B

29534: -- Cursor to lock okc_k_lines_b before going for update
29535: -------------------------------------------------------
29536: CURSOR L_LOCK_LINE_CSR (p_id in number ) IS
29537: SELECT 1
29538: FROM OKC_K_LINES_B
29539: WHERE DNZ_CHR_ID = P_ID
29540: AND LSE_ID in ( 1,12,19,46)
29541: FOR UPDATE NOWAIT;
29542:

Line 30081: , okc_k_lines_b okci

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
30085: and okci.id = oks.cle_id )

Line 30088: select 1 from okc_k_lines_b okc

30084: and oksi.cle_id = oks.cle_id
30085: and okci.id = oks.cle_id )
30086: where oks.dnz_chr_id = p_chr_id
30087: and exists (
30088: select 1 from okc_k_lines_b okc
30089: where okc.id = oks.cle_id
30090: and okc.lse_id in ( 1,12,19,46));
30091:
30092: Update okc_k_lines_b okc

Line 30092: Update okc_k_lines_b okc

30088: select 1 from okc_k_lines_b okc
30089: where okc.id = oks.cle_id
30090: and okc.lse_id in ( 1,12,19,46));
30091:
30092: Update okc_k_lines_b okc
30093: set okc.price_list_id = l_price_list_idi
30094: , okc.price_negotiated = ( select sum(okci.price_negotiated)
30095: from okc_k_lines_b okci
30096: where ( okci.cle_id = okc.id OR (okci.id = okc.id and okci.lse_id = 46 )))

Line 30095: from okc_k_lines_b okci

30091:
30092: Update okc_k_lines_b okc
30093: set okc.price_list_id = l_price_list_idi
30094: , okc.price_negotiated = ( select sum(okci.price_negotiated)
30095: from okc_k_lines_b okci
30096: where ( okci.cle_id = okc.id OR (okci.id = okc.id and okci.lse_id = 46 )))
30097: where dnz_chr_id = p_chr_id
30098: and lse_id in ( 1,12,19,46);
30099: Exception

Line 31202: FROM OKC_K_LINES_B

31198: LOCK_EXCEPTION EXCEPTION;
31199:
31200: CURSOR L_LOCK_CSR ( P_CLE_ID in NUMBER ) IS
31201: SELECT ID
31202: FROM OKC_K_LINES_B
31203: WHERE ID = P_CLE_ID
31204: FOR UPDATE NOWAIT;
31205: L_LOCK_ID NUMBER;
31206: Eflag NUMBER;

Line 31540: , OKC_K_LINES_B LIN

31536: , RGP.ID RGP_ID
31537: FROM OKC_K_HEADERS_B HDR
31538: , OKC_RULE_GROUPS_B RGP
31539: , OKC_RULES_B RUL
31540: , OKC_K_LINES_B LIN
31541: WHERE HDR.ID = P_HDR_ID
31542: AND LIN.ID= P_CLE_ID
31543: AND RGP.DNZ_CHR_ID = P_HDR_ID
31544: AND RGP.CLE_ID = LIN.ID

Line 31598: , okc_k_lines_b okcl

31594: , okc.id
31595: , okcl.lse_id
31596: from oks_k_headers_b oks
31597: , okc_k_headers_b okc
31598: , okc_k_lines_b okcl
31599: where oks.chr_id = okc.id
31600: and okcl.lse_id in ( 1,12,19,46)
31601: and okcl.dnz_chr_id = oks.chr_id
31602: and okcl.dnz_chr_id = okc.id

Line 31837: UPDATE OKC_K_LINES_B

31833: Close Cur_RGP_exists;
31834:
31835: If(l_check_var is NULL and l_check_var1 is not null ) THEN
31836: BEGIN
31837: UPDATE OKC_K_LINES_B
31838: SET CUST_ACCT_ID = CUST_ACCT_ID_CHR
31839: , BILL_TO_SITE_USE_ID = BILL_TO_SITE_USE_ID_CHR
31840: , INV_RULE_ID = INV_RULE_ID_CHR
31841: , LINE_RENEWAL_TYPE_CODE = L_LINE_RENEWAL_TYPE_CODE

Line 32089: UPDATE OKC_K_LINES_B

32085: Close Cur_RGP_exists;
32086:
32087: If(l_check_var is not null) Then
32088: BEGIN
32089: UPDATE OKC_K_LINES_B
32090: SET
32091: CUST_ACCT_ID = CUST_ACCT_ID_CHR
32092: , BILL_TO_SITE_USE_ID = BILL_TO_SITE_USE_ID_CHR
32093: , INV_RULE_ID = INV_RULE_ID_CHR

Line 32230: UPDATE OKC_K_LINES_B

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
32233: , INV_RULE_ID = INV_RULE_ID_CHR
32234: , LINE_RENEWAL_TYPE_CODE = L_LINE_RENEWAL_TYPE_CODE

Line 33271: FROM OKC_K_LINES_BH

33267: LOCK_EXCEPTION EXCEPTION;
33268:
33269: CURSOR L_LOCK_CSR ( P_CLE_ID in NUMBER, P_MAJOR_VERSION_NUMBER IN NUMBER ) IS
33270: SELECT ID
33271: FROM OKC_K_LINES_BH
33272: WHERE ID = P_CLE_ID
33273: AND MAJOR_VERSION = P_MAJOR_VERSION_NUMBER
33274: FOR UPDATE NOWAIT;
33275: L_LOCK_ID NUMBER;

Line 33618: , OKC_K_LINES_BH LIN

33614: , RGP.ID RGP_ID
33615: FROM OKC_K_HEADERS_BH HDR
33616: , OKC_RULE_GROUPS_BH RGP
33617: , OKC_RULES_BH RUL
33618: , OKC_K_LINES_BH LIN
33619: WHERE HDR.ID = P_HDR_ID
33620: AND LIN.ID= P_CLE_ID
33621: AND RGP.DNZ_CHR_ID = P_HDR_ID
33622: AND RGP.CLE_ID = LIN.ID

Line 33866: UPDATE OKC_K_LINES_BH

33862:
33863: If(l_check_var is NULL) THEN
33864:
33865: BEGIN
33866: UPDATE OKC_K_LINES_BH
33867: SET
33868: CUST_ACCT_ID = CUST_ACCT_ID_CHR
33869: , BILL_TO_SITE_USE_ID = BILL_TO_SITE_USE_ID_CHR
33870: , INV_RULE_ID = INV_RULE_ID_CHR

Line 34126: UPDATE OKC_K_LINES_BH

34122:
34123: If(l_check_var is not null) Then
34124:
34125: BEGIN
34126: UPDATE OKC_K_LINES_BH
34127: SET CUST_ACCT_ID = CUST_ACCT_ID_CHR
34128: , BILL_TO_SITE_USE_ID = BILL_TO_SITE_USE_ID_CHR
34129: , INV_RULE_ID = INV_RULE_ID_CHR
34130: , LINE_RENEWAL_TYPE_CODE = L_LINE_RENEWAL_TYPE_CODE

Line 34274: UPDATE OKC_K_LINES_BH

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
34276: , BILL_TO_SITE_USE_ID = BILL_TO_SITE_USE_ID_CHR
34277: , INV_RULE_ID = INV_RULE_ID_CHR
34278: , LINE_RENEWAL_TYPE_CODE = L_LINE_RENEWAL_TYPE_CODE

Line 37175: , OKC_K_LINES_B LINES

37171: , LINES.ID CLE_ID
37172: , LINES.DNZ_CHR_ID DNZ_CHR_ID
37173: , NVL(LINES.CLE_ID , LINES.ID ) PARENT_CLE_ID
37174: FROM OKC_RULES_B RUL
37175: , OKC_K_LINES_B LINES
37176: , OKC_RULE_GROUPS_B RGP
37177: WHERE RUL.RULE_INFORMATION_CATEGORY = 'SLL'
37178: AND RUL.RGP_ID = RGP.ID
37179: AND RGP.DNZ_CHR_ID = LINES.DNZ_CHR_ID

Line 38907: AND NOT EXISTS ( SELECT 1 FROM OKC_K_LINES_B OKC

38903:
38904: DELETE /*+ PARALLEL(UPG1) */
38905: FROM OKS_RULE_UPGRADE UPG1
38906: WHERE UPG1.RIC_CODE = 'LIN'
38907: AND NOT EXISTS ( SELECT 1 FROM OKC_K_LINES_B OKC
38908: WHERE OKC.ID = UPG1.RGP_ID );
38909: COMMIT;
38910:
38911:

Line 38968: UPDATE OKC_K_LINES_B

38964: ,2003);
38965: END LOOP;
38966:
38967: FORALL I IN L_LINE_ID.FIRST..L_LINE_ID.LAST
38968: UPDATE OKC_K_LINES_B
38969: SET PRICE_LIST_ID = L_PRICE_LIST_ID(I)
38970: WHERE ID = L_LINE_ID(I);
38971:
38972: FORALL I IN L_LINE_ID.FIRST..L_LINE_ID.LAST