DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 25692: OKC_K_HEADERS_ALL_B okc

25688: SELECT
25689: oks.TRXN_EXTENSION_ID
25690: ,okc.BILL_TO_SITE_USE_ID
25691: FROM
25692: OKC_K_HEADERS_ALL_B okc
25693: ,OKS_K_HEADERS_B oks
25694: WHERE
25695: okc.id = oks.chr_id
25696: and okc.id = p_chr_id;

Line 26218: l_stage := 'Updating OKC_K_HEADERS_ALL_B';

26214: If l_party_count = 0 then
26215: Begin
26216: --Update OKC_K_HEADERS--
26217:
26218: l_stage := 'Updating OKC_K_HEADERS_ALL_B';
26219:
26220: UPDATE OKC_K_HEADERS_ALL_B
26221: SET
26222: CUST_ACCT_ID = NULL

Line 26220: UPDATE OKC_K_HEADERS_ALL_B

26216: --Update OKC_K_HEADERS--
26217:
26218: l_stage := 'Updating OKC_K_HEADERS_ALL_B';
26219:
26220: UPDATE OKC_K_HEADERS_ALL_B
26221: SET
26222: CUST_ACCT_ID = NULL
26223: ,BILL_TO_SITE_USE_ID = NULL
26224: ,SHIP_TO_SITE_USE_ID = NULL

Line 26466: OKC_K_HEADERS_ALL_B okc

26462: SELECT
26463: oks.TRXN_EXTENSION_ID
26464: ,okc.BILL_TO_SITE_USE_ID
26465: FROM
26466: OKC_K_HEADERS_ALL_B okc
26467: ,OKS_K_HEADERS_B oks
26468: WHERE
26469: okc.id = oks.chr_id
26470: and okc.id = p_from_chr_id;

Line 26988: update okc_k_headers_all_b

26984: End If;
26985: END;
26986: --end npalepu
26987:
26988: update okc_k_headers_all_b
26989: set sts_code = 'QA_HOLD'
26990: ,object_version_number = decode(l_Target_Contract_New_YN,'Y',object_version_number,object_version_number+1)
26991: where id = l_to_chr_id;
26992: