APPS.OKS_RULE_MIGRATE dependencies on OKC_K_LINES_BH

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 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 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 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