APPS.OKS_RULE_MIGRATE dependencies on OKS_K_HEADERS_BH

Line 25193: INSERT INTO oks_k_headers_bh(

25189: --Attempting to insert records first
25190: --as OKS_RULE_REPROCESS might have many records with no data issue
25191:
25192: BEGIN
25193: INSERT INTO oks_k_headers_bh(
25194: ID
25195: ,MAJOR_VERSION
25196: ,CHR_ID
25197: ,ACCT_RULE_ID

Line 25340: INSERT INTO OKS_K_HEADERS_BH OKS1

25336: FETCH L_CHECK_RGP_CSR INTO L_CHR_ID;
25337: CLOSE L_CHECK_RGP_CSR;
25338:
25339: if(l_chr_id is not null) then
25340: INSERT INTO OKS_K_HEADERS_BH OKS1
25341: ( OKS1.ID
25342: ,OKS1.MAJOR_VERSION
25343: ,OKS1.CHR_ID
25344: ,OKS1.OBJECT_VERSION_NUMBER

Line 35706: --in oks_k_headers_bh

35702: ----------------------------------------------------------------------------
35703:
35704: -----------------------------------------------------------------------------
35705: --Cursor to check if the records corresponding to chr_id exists
35706: --in oks_k_headers_bh
35707: -----------------------------------------------------------------------------
35708:
35709: Cursor Cur_KHdr_exists(p_chrid in number) IS
35710: select 'x'

Line 35711: from oks_k_headers_bh

35707: -----------------------------------------------------------------------------
35708:
35709: Cursor Cur_KHdr_exists(p_chrid in number) IS
35710: select 'x'
35711: from oks_k_headers_bh
35712: where chr_id=p_chrid
35713: and major_version = p_major_version;
35714:
35715: ------------------------------------------------------------------------------

Line 35934: INSERT INTO oks_k_headers_bh(

35930:
35931:
35932: If( Eflag <> 1) Then
35933: BEGIN
35934: INSERT INTO oks_k_headers_bh(
35935: ID
35936: ,MAJOR_VERSION
35937: ,CHR_ID
35938: ,ACCT_RULE_ID

Line 36088: UPDATE OKS_K_HEADERS_BH

36084: If(l_check_var is not null) Then
36085:
36086: --Updating oks_k_headers_b
36087: BEGIN
36088: UPDATE OKS_K_HEADERS_BH
36089: SET
36090: ACCT_RULE_ID = ACCT_RULE_ID_CHR
36091: ,PAYMENT_TYPE = L_PAYMENT_TYPE
36092: ,CC_NO = L_CC_NO

Line 36190: Delete from oks_k_headers_bh where chr_id = P_CHR_ID

36186: Else
36187:
36188: BEGIN
36189:
36190: Delete from oks_k_headers_bh where chr_id = P_CHR_ID
36191: and major_version = p_major_version;
36192:
36193:
36194: