[Home] [Help]
400: markup_percent, price_list_id1, line_renewal_type,
401: link_chr_id, contact_id, site_id, email_id, phone_id, fax_id,
402: billing_profile_id --new parameter added -vigandhi (May29-02)
403: ,RENEWAL_APPROVAL_FLAG --Bug# 5173373
404: FROM oks_k_order_details_v
405: WHERE order_line_id1 = TO_CHAR (p_order_line_id);
406:
407: -- Fix for bug# 4690982
408:
4094: IS
4095: CURSOR l_link_csr1
4096: IS
4097: SELECT NVL (link_ord_line_id1, order_line_id1)
4098: FROM oks_k_order_details
4099: WHERE order_line_id1 = TO_CHAR (p_order_line_id);
4100:
4101: CURSOR l_link_csr_a (l_link_ord_id VARCHAR2)
4102: IS
4100:
4101: CURSOR l_link_csr_a (l_link_ord_id VARCHAR2)
4102: IS
4103: SELECT ID, order_line_id1, object_version_number
4104: FROM oks_k_order_details
4105: WHERE link_ord_line_id1 = l_link_ord_id AND chr_id IS NULL;
4106:
4107: CURSOR l_link_csr_b (l_link_ord_id VARCHAR2)
4108: IS
4106:
4107: CURSOR l_link_csr_b (l_link_ord_id VARCHAR2)
4108: IS
4109: SELECT ID, order_line_id1, object_version_number
4110: FROM oks_k_order_details
4111: WHERE order_line_id1 = l_link_ord_id AND chr_id IS NULL;
4112:
4113: l_link_rec1 l_link_csr_a%ROWTYPE;
4114: l_link_rec2 l_link_csr_b%ROWTYPE;