APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_INST_HIST_DETAILS

Line 9398: Update oks_inst_hist_details set new_k_status = l_hdr_status

9394: Open l_hdr_sts_csr(p_kdtl_tbl (l_ctr).hdr_id);
9395: Fetch l_hdr_sts_csr into l_hdr_status;
9396: Close l_hdr_sts_csr;
9397:
9398: Update oks_inst_hist_details set new_k_status = l_hdr_status
9399: Where ins_id = l_instparent_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id;
9400:
9401: End If;
9402: END IF;

Line 9463: FROM oks_inst_hist_details

9459: p_cust_id NUMBER
9460: )
9461: IS
9462: SELECT DISTINCT new_contract_id
9463: FROM oks_inst_hist_details
9464: WHERE system_id = p_system_id
9465: AND transaction_date = p_trxn_date
9466: AND transaction_type = 'TRF'
9467: AND old_customer = p_cust_id

Line 14112: Update oks_inst_hist_details set new_k_status = l_hdr_sts

14108: Fetch l_hdr_sts_csr into l_hdr_sts;
14109: Close l_hdr_sts_csr;
14110:
14111: If p_kdtl_tbl (l_ctr).system_id Is Null Then
14112: Update oks_inst_hist_details set new_k_status = l_hdr_sts
14113: Where ins_id = l_instparent_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id;
14114: Else
14115: Update oks_inst_hist_details set new_k_status = l_hdr_sts
14116: Where system_id = p_kdtl_tbl (l_ctr).system_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id

Line 14115: Update oks_inst_hist_details set new_k_status = l_hdr_sts

14111: If p_kdtl_tbl (l_ctr).system_id Is Null Then
14112: Update oks_inst_hist_details set new_k_status = l_hdr_sts
14113: Where ins_id = l_instparent_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id;
14114: Else
14115: Update oks_inst_hist_details set new_k_status = l_hdr_sts
14116: Where system_id = p_kdtl_tbl (l_ctr).system_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id
14117: and transaction_date = p_kdtl_tbl (l_ctr).transaction_date;
14118: End If;
14119:

Line 14842: Update oks_inst_hist_details set new_k_status = l_hdr_status

14838: Open l_hdr_sts_csr(p_kdtl_tbl (l_ctr).hdr_id);
14839: Fetch l_hdr_sts_csr into l_hdr_status;
14840: Close l_hdr_sts_csr;
14841:
14842: Update oks_inst_hist_details set new_k_status = l_hdr_status
14843: Where ins_id = l_instparent_id and new_contract_id = p_kdtl_tbl (l_ctr).hdr_id;
14844:
14845: End If;
14846: END IF;