[Home] [Help]
644: BEGIN
645:
646: SELECT 1
647: INTO l_delta
648: FROM cz_config_details_v
649: WHERE config_delta = 0
650: AND config_hdr_id = p_line_rec.config_header_id
651: AND config_rev_nbr = p_line_rec.config_rev_nbr
652: AND config_item_id = p_line_rec.configuration_id;
658: OE_DEBUG_PUB.Add('ERRM: No Data Found when selecting config delta',3);
659:
660: SELECT description
661: INTO l_description
662: FROM cz_config_details_v cz_czv, mtl_system_items mtl_msi
663: WHERE cz_czv.inventory_item_id = mtl_msi.inventory_item_id
664: AND cz_czv.config_delta <> 0 --implies change
665: AND cz_czv.config_hdr_id = p_line_rec.config_header_id
666: AND cz_czv.config_rev_nbr = p_line_rec.config_rev_nbr
1073: ,oe_ol.config_header_id
1074: ,oe_ol.config_rev_nbr
1075: ,oe_ol.configuration_id
1076: FROM oe_order_lines oe_ol
1077: ,cz_config_details_v cz_det
1078: WHERE oe_ol.top_model_line_id = p_top_model_line_id
1079: AND cz_det.config_delta = 0
1080: AND cz_det.config_hdr_id = oe_ol.config_header_id
1081: AND cz_det.config_rev_nbr = oe_ol.config_rev_nbr
2098: -- The procedure populate_tso_order_lines will take care of creating model lines and child lines with the given instance table.
2099: -- We can continue to call this API in this case as the order is getting created in this call.
2100:
2101: -- The following API will call generate_config_tree procedure to generate the container models. OM creates the models first and then
2102: -- creates the child lines by looking at the cz_config_details_v.
2103:
2104: -- populate_tso_order_lines procedure accepts the instance record declared in package oe_install_base_util. But we have mentioned in the FDD to declare a new instance
2105: -- record. We need evaluate the need for the new record. If the new record is mandatory then the data needs to be populated into local instance table which is based
2106: -- on the oe_install_base_util's record structure.
3265: /*
3266: Select cz.config_hdr_id, cz.config_rev_nbr, substr(cz.component_code, 1,instr(cz.component_code,'-')-1),
3267: oe.top_model_line_id
3268: Into l_config_hdr_id, l_config_rev_nbr, L_item_id,x_top_model_line_id
3269: from cz_config_details_v cz, oe_order_lines_all oe
3270: where cz.instance_hdr_id = p_config_instance_hdr_id
3271: and oe.config_header_id = cz.config_hdr_id
3272: and oe.config_rev_nbr = cz.config_rev_nbr
3273: and oe.top_model_line_id = oe.line_id
3277: */
3278:
3279: Select config_hdr_id, config_rev_nbr, substr(component_code, 1,instr(component_code,'-')-1)
3280: Into l_config_hdr_id, l_config_rev_nbr, L_item_id
3281: from cz_config_details_v
3282: where instance_hdr_id = p_config_instance_hdr_id
3283: and instance_rev_nbr = p_config_instance_rev_number
3284: and component_instance_type = 'I';
3285:
3373:
3374: SELECT cz_hdr.baseline_rev_nbr
3375: INTO l_baseline_rev_nbr
3376: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
3377: cz_config_details_v czv
3378: WHERE oe_line.top_model_line_id = p_top_model_line_id
3379: AND oe_line.configuration_id = P_instance_item_id
3380: AND czv.config_hdr_id = oe_line.config_header_id
3381: AND czv.config_rev_nbr = oe_line.config_rev_nbr
3477: Begin
3478: SELECT cz_hdr.baseline_rev_nbr
3479: INTO l_baseline_rev_nbr
3480: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
3481: cz_config_details_v czv
3482: WHERE oe_line.line_id = p_line_id
3483: AND czv.config_hdr_id = oe_line.config_header_id
3484: AND czv.config_rev_nbr = oe_line.config_rev_nbr
3485: AND czv.config_item_id = oe_line.configuration_id