APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_INST_HIST_DETAILS

Line 9167: Update oks_inst_hist_details set new_k_status = l_hdr_status

9163: Open l_hdr_sts_csr(p_kdtl_tbl (l_ctr).hdr_id);
9164: Fetch l_hdr_sts_csr into l_hdr_status;
9165: Close l_hdr_sts_csr;
9166:
9167: Update oks_inst_hist_details set new_k_status = l_hdr_status
9168: Where ins_id = l_instparent_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id;
9169:
9170: End If;
9171: END IF;

Line 9232: FROM oks_inst_hist_details

9228: p_cust_id NUMBER
9229: )
9230: IS
9231: SELECT DISTINCT new_contract_id
9232: FROM oks_inst_hist_details
9233: WHERE system_id = p_system_id
9234: AND transaction_date = p_trxn_date
9235: AND transaction_type = 'TRF'
9236: AND old_customer = p_cust_id

Line 13841: Update oks_inst_hist_details set new_k_status = l_hdr_sts

13837: Fetch l_hdr_sts_csr into l_hdr_sts;
13838: Close l_hdr_sts_csr;
13839:
13840: If p_kdtl_tbl (l_ctr).system_id Is Null Then
13841: Update oks_inst_hist_details set new_k_status = l_hdr_sts
13842: Where ins_id = l_instparent_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id;
13843: Else
13844: Update oks_inst_hist_details set new_k_status = l_hdr_sts
13845: Where system_id = p_kdtl_tbl (l_ctr).system_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id

Line 13844: Update oks_inst_hist_details set new_k_status = l_hdr_sts

13840: If p_kdtl_tbl (l_ctr).system_id Is Null Then
13841: Update oks_inst_hist_details set new_k_status = l_hdr_sts
13842: Where ins_id = l_instparent_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id;
13843: Else
13844: Update oks_inst_hist_details set new_k_status = l_hdr_sts
13845: Where system_id = p_kdtl_tbl (l_ctr).system_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id
13846: and transaction_date = p_kdtl_tbl (l_ctr).transaction_date;
13847: End If;
13848:

Line 14557: Update oks_inst_hist_details set new_k_status = l_hdr_status

14553: Open l_hdr_sts_csr(p_kdtl_tbl (l_ctr).hdr_id);
14554: Fetch l_hdr_sts_csr into l_hdr_status;
14555: Close l_hdr_sts_csr;
14556:
14557: Update oks_inst_hist_details set new_k_status = l_hdr_status
14558: Where ins_id = l_instparent_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id;
14559:
14560: End If;
14561: END IF;