37: ASO_QUOTE_LINES_ALL a
38: where a.quote_line_id = p_quote_line_id;
39:
40: /***************************************************************************************
41: Cursor to find complete configuration and valid configuration info from CZ_CONFIG_HDRS
42: *****************************************************************************************/
43: Cursor c_configuration_details_csr(p_config_header_id Number,p_config_rev_number Number) is
44: Select Decode (has_failures,'0','Y','N'), decode (config_status,'2','Y','N')
45: from CZ_CONFIG_HDRS
41: Cursor to find complete configuration and valid configuration info from CZ_CONFIG_HDRS
42: *****************************************************************************************/
43: Cursor c_configuration_details_csr(p_config_header_id Number,p_config_rev_number Number) is
44: Select Decode (has_failures,'0','Y','N'), decode (config_status,'2','Y','N')
45: from CZ_CONFIG_HDRS
46: where config_hdr_id = p_config_header_id
47: and config_rev_nbr = p_config_rev_number;
48:
49: Cursor c_last_update_date_csr(p_qte_header_id Number) is
208: raise FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210:
211: /****************************************************************************
212: Get complete configuration and valid configuration info from CZ_CONFIG_HDRS
213: ****************************************************************************/
214: Open c_configuration_details_csr(lx_config_tree_rec.config_hdr_id,lx_config_tree_rec.config_rev_nbr);
215:
216: fetch c_configuration_details_csr into l_valid_configuration_flag,l_complete_configuration_flag;
398: and a.config_rev_nbr = p_config_rev_nbr
399: and a.config_item_id = p_config_item_id;
400:
401: /***************************************************************************************
402: Cursor to find complete configuration and valid configuration info from CZ_CONFIG_HDRS
403: *****************************************************************************************/
404: Cursor c_configuration_details_csr(p_config_header_id Number,p_config_rev_number Number) is
405: Select Decode (has_failures,'0','Y','N'), decode (config_status,'2','Y','N')
406: from CZ_CONFIG_HDRS
402: Cursor to find complete configuration and valid configuration info from CZ_CONFIG_HDRS
403: *****************************************************************************************/
404: Cursor c_configuration_details_csr(p_config_header_id Number,p_config_rev_number Number) is
405: Select Decode (has_failures,'0','Y','N'), decode (config_status,'2','Y','N')
406: from CZ_CONFIG_HDRS
407: where config_hdr_id = p_config_header_id
408: and config_rev_nbr = p_config_rev_number;
409:
410: /****************************************************************
658:
659: For k IN 1.. lx_out_config_tree_tbl.count Loop
660:
661: /****************************************************************************
662: Get complete configuration and valid configuration info from CZ_CONFIG_HDRS
663: ****************************************************************************/
664: Open c_configuration_details_csr(lx_out_config_tree_tbl(k).config_hdr_id,lx_out_config_tree_tbl(k).config_rev_nbr);
665:
666: fetch c_configuration_details_csr into l_valid_configuration_flag,l_complete_configuration_flag;