APPS.ASO_CONFIG_OPERATIONS_PVT dependencies on CZ_CONFIG_HDRS

Line 41: Cursor to find complete configuration and valid configuration info from CZ_CONFIG_HDRS

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

Line 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

Line 212: Get complete configuration and valid configuration info from CZ_CONFIG_HDRS

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;

Line 402: Cursor to find complete configuration and valid configuration info from CZ_CONFIG_HDRS

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

Line 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: /****************************************************************

Line 662: Get complete configuration and valid configuration info from CZ_CONFIG_HDRS

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;