APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 25496: OKC_K_HEADERS_ALL_B okc

25492: SELECT
25493: oks.TRXN_EXTENSION_ID
25494: ,okc.BILL_TO_SITE_USE_ID
25495: FROM
25496: OKC_K_HEADERS_ALL_B okc
25497: ,OKS_K_HEADERS_B oks
25498: WHERE
25499: okc.id = oks.chr_id
25500: and okc.id = p_chr_id;

Line 26019: l_stage := 'Updating OKC_K_HEADERS_ALL_B';

26015: If l_party_count = 0 then
26016: Begin
26017: --Update OKC_K_HEADERS--
26018:
26019: l_stage := 'Updating OKC_K_HEADERS_ALL_B';
26020:
26021: UPDATE OKC_K_HEADERS_ALL_B
26022: SET
26023: CUST_ACCT_ID = NULL

Line 26021: UPDATE OKC_K_HEADERS_ALL_B

26017: --Update OKC_K_HEADERS--
26018:
26019: l_stage := 'Updating OKC_K_HEADERS_ALL_B';
26020:
26021: UPDATE OKC_K_HEADERS_ALL_B
26022: SET
26023: CUST_ACCT_ID = NULL
26024: ,BILL_TO_SITE_USE_ID = NULL
26025: ,SHIP_TO_SITE_USE_ID = NULL

Line 26267: OKC_K_HEADERS_ALL_B okc

26263: SELECT
26264: oks.TRXN_EXTENSION_ID
26265: ,okc.BILL_TO_SITE_USE_ID
26266: FROM
26267: OKC_K_HEADERS_ALL_B okc
26268: ,OKS_K_HEADERS_B oks
26269: WHERE
26270: okc.id = oks.chr_id
26271: and okc.id = p_from_chr_id;

Line 26789: update okc_k_headers_all_b

26785: End If;
26786: END;
26787: --end npalepu
26788:
26789: update okc_k_headers_all_b
26790: set sts_code = 'QA_HOLD'
26791: ,object_version_number = decode(l_Target_Contract_New_YN,'Y',object_version_number,object_version_number+1)
26792: where id = l_to_chr_id;
26793: End If;