471: -- structured pricing value
472: IF (lp_qqhv_rec_type.structured_pricing = 'Y') THEN
473: -- For Standard Rate Template, nullify LRF
474: IF lp_qqhv_rec_type.rate_template_id IS NOT NULL THEN
475: lp_qqhv_rec_type.lease_rate_factor := fnd_api.g_miss_num;
476: END IF;
477: lp_qqhv_rec_type.rate_template_id := fnd_api.g_miss_num;
478: lp_qqhv_rec_type.rate_card_id := fnd_api.g_miss_num;
479: ELSIF (lp_qqhv_rec_type.structured_pricing = 'N') THEN
473: -- For Standard Rate Template, nullify LRF
474: IF lp_qqhv_rec_type.rate_template_id IS NOT NULL THEN
475: lp_qqhv_rec_type.lease_rate_factor := fnd_api.g_miss_num;
476: END IF;
477: lp_qqhv_rec_type.rate_template_id := fnd_api.g_miss_num;
478: lp_qqhv_rec_type.rate_card_id := fnd_api.g_miss_num;
479: ELSIF (lp_qqhv_rec_type.structured_pricing = 'N') THEN
480: lp_qqhv_rec_type.lease_rate_factor := fnd_api.g_miss_num;
481: -- For Standard Rate Template, nullify Rate Card Id and vice versa
474: IF lp_qqhv_rec_type.rate_template_id IS NOT NULL THEN
475: lp_qqhv_rec_type.lease_rate_factor := fnd_api.g_miss_num;
476: END IF;
477: lp_qqhv_rec_type.rate_template_id := fnd_api.g_miss_num;
478: lp_qqhv_rec_type.rate_card_id := fnd_api.g_miss_num;
479: ELSIF (lp_qqhv_rec_type.structured_pricing = 'N') THEN
480: lp_qqhv_rec_type.lease_rate_factor := fnd_api.g_miss_num;
481: -- For Standard Rate Template, nullify Rate Card Id and vice versa
482: IF lp_qqhv_rec_type.rate_template_id IS NOT NULL THEN
476: END IF;
477: lp_qqhv_rec_type.rate_template_id := fnd_api.g_miss_num;
478: lp_qqhv_rec_type.rate_card_id := fnd_api.g_miss_num;
479: ELSIF (lp_qqhv_rec_type.structured_pricing = 'N') THEN
480: lp_qqhv_rec_type.lease_rate_factor := fnd_api.g_miss_num;
481: -- For Standard Rate Template, nullify Rate Card Id and vice versa
482: IF lp_qqhv_rec_type.rate_template_id IS NOT NULL THEN
483: lp_qqhv_rec_type.rate_card_id := fnd_api.g_miss_num;
484: ELSE
479: ELSIF (lp_qqhv_rec_type.structured_pricing = 'N') THEN
480: lp_qqhv_rec_type.lease_rate_factor := fnd_api.g_miss_num;
481: -- For Standard Rate Template, nullify Rate Card Id and vice versa
482: IF lp_qqhv_rec_type.rate_template_id IS NOT NULL THEN
483: lp_qqhv_rec_type.rate_card_id := fnd_api.g_miss_num;
484: ELSE
485: lp_qqhv_rec_type.rate_template_id := fnd_api.g_miss_num;
486: END IF;
487: END IF;
481: -- For Standard Rate Template, nullify Rate Card Id and vice versa
482: IF lp_qqhv_rec_type.rate_template_id IS NOT NULL THEN
483: lp_qqhv_rec_type.rate_card_id := fnd_api.g_miss_num;
484: ELSE
485: lp_qqhv_rec_type.rate_template_id := fnd_api.g_miss_num;
486: END IF;
487: END IF;
488:
489: okl_qqh_pvt.update_row(p_api_version