[Home] [Help]
86: Description :
87:
88: Lock the configuration. Explode the bill.
89:
90: Get the records from cz_config_details_v
91: and bom_explosions and
92: insert,update,or deletethem from order_lines.
93:
94: We will open three cursors :
101: The third to pass an operation of DELETE
102: for records which exist but are no longer selected.
103: => handle_deletes proc
104:
105: get values from cz_config_details_v
106: viz. comp_code, qty, cfg_hdr_id, rev_no
107: and bom_explosions viz.
108: component_sequence_id, sort_order, bom_item_type,
109: bill_sequence_id, top_bill_sequence_id
119: after batch validation.
120:
121: Change Record:
122: Bug 2181376: explode bill is not required since in handle_inserts
123: procedure we will selecet all required data from cz_config_details_v
124: and do not need to join with bom_explosions anymore. This change is
125: also useful for multiple instance project.
126: --------------------------------------------------------------------*/
127:
212:
213: BEGIN
214: SELECT quantity, config_item_id
215: INTO l_model_new_qty, l_model_line_rec.configuration_id
216: FROM cz_config_details_v
217: WHERE config_hdr_id = p_config_hdr_id
218: AND config_rev_nbr = p_config_rev_nbr
219: AND inventory_item_id = l_model_line_rec.inventory_item_id;
220:
420:
421: /*------------------------------------------------------------------
422: PROCEDURE Handle_Inserts
423:
424: if a component is present in cz_config_details_v but not present
425: in oe_order_lines, we need to insert it.
426:
427: Change Record:
428: Bug 2181376: explode bill is not required since in this
425: in oe_order_lines, we need to insert it.
426:
427: Change Record:
428: Bug 2181376: explode bill is not required since in this
429: procedure we will selecet all required data from cz_config_details_v
430: and do not need to join with bom_explosions anymore. This change is
431: also useful for multiple instance project
432: Bug 2869052 :
433: Default_Child_Line procedure would be called only if there are
465: ,c.instance_hdr_id, c.instance_rev_nbr
466: ,c.component_sequence_id, c.bom_sort_order
467: ,c.bom_item_type, c.config_item_id
468: ,c.line_type
469: FROM CZ_CONFIG_DETAILS_V c
470: WHERE c.config_hdr_id = p_config_hdr_id
471: AND c.config_rev_nbr = p_config_rev_nbr
472: AND NOT EXISTS
473: ( SELECT 'X'
505:
506: UPDATE oe_order_lines oe
507: SET ( configuration_id , sort_order ) =
508: (SELECT config_item_id , bom_sort_order --bug6628691
509: FROM cz_config_details_v
510: WHERE config_hdr_id = p_config_hdr_id
511: AND config_rev_nbr = p_config_rev_nbr
512: AND component_code = oe.component_code
513: )
528:
529: UPDATE oe_order_lines oe
530: SET ( configuration_id , sort_order ) =
531: (SELECT config_item_id , bom_sort_order --bug6628691
532: FROM cz_config_details_v
533: WHERE config_hdr_id = p_config_hdr_id
534: AND config_rev_nbr = p_config_rev_nbr
535: AND component_code = oe.component_code
536: )
804:
805: /*------------------------------------------------------------
806: PROCEDURE Handle_Inserts_Old
807:
808: if a component is present in cz_config_details_v but not present
809: in oe_order_lines, we need to insert it.
810:
811: Change Record:
812: Bug 2181376: explode bill is not required since in this
809: in oe_order_lines, we need to insert it.
810:
811: Change Record:
812: Bug 2181376: explode bill is not required since in this
813: procedure we will selecet all required data from cz_config_details_v
814: and do not need to join with bom_explosions anymore. This change is
815: also useful for multiple instance project.
816: Bug 2869052 :
817: Default_Child_Line procedure would be called only if there are
833: SELECT c.component_code, c.quantity
834: ,c.uom_code, c.inventory_item_id
835: ,c.component_sequence_id, c.bom_sort_order
836: ,c.bom_item_type
837: FROM CZ_CONFIG_DETAILS_V c
838: WHERE c.config_hdr_id = p_config_hdr_id
839: AND c.config_rev_nbr = p_config_rev_nbr
840: AND NOT EXISTS
841: ( SELECT 'X'
971: /*-----------------------------------------------------------
972: PROCEDURE Handle_Updates
973:
974: If quantity of a component is different in oe_order_lines and
975: cz_config_details_v, we need to update that component.
976:
977: for config UI only: if there is a constraint on qty change,
978: should we pass a hardcoded reason/comment, or should we fail?
979: we should fail.
1001: ,l.cancelled_quantity -- 12695580
1002: ,l.item_type_code
1003: ,c.line_type
1004: ,c.bom_sort_order
1005: FROM CZ_CONFIG_DETAILS_V c, oe_order_lines l
1006: WHERE c.config_hdr_id = p_config_hdr_id
1007: AND c.config_rev_nbr = p_config_rev_nbr
1008: AND (c.quantity <> l.ordered_quantity OR
1009: c.line_type <> l.line_type_id OR
1133: /*-----------------------------------------------------------
1134: PROCEDURE Handle_Updates_Old
1135:
1136: If quantity of a component is different in oe_order_lines and
1137: cz_config_details_v, we need to update that component.
1138:
1139: for config UI only: if there is a constraint on qty change,
1140: should we pass a hardcoded reason/comment, or should we fail?
1141: we should fail.
1156: ,c.component_code
1157: ,c.quantity
1158: ,l.ordered_quantity
1159: ,l.item_type_code
1160: FROM CZ_CONFIG_DETAILS_V c, oe_order_lines l
1161: WHERE c.config_hdr_id = p_config_hdr_id
1162: AND c.config_rev_nbr = p_config_rev_nbr
1163: AND c.quantity <> l.ordered_quantity
1164: AND l.top_model_line_id = p_model_line_rec.line_id
1228: /*---------------------------------------------------------
1229: PROCEDURE Handle_Deletes
1230:
1231: If a component exists in oe_order_lines, but does not exist
1232: in cz_config_details_v, we need to delete that component.
1233:
1234: Change Record:
1235:
1236: bug 1939531: to not call check_if_cancellation
1266: AND l.open_flag = 'Y'
1267: AND
1268: (NOT EXISTS
1269: ( SELECT 'X'
1270: FROM CZ_CONFIG_DETAILS_V c
1271: WHERE c.component_code = l.component_code
1272: AND c.config_item_id = l.configuration_id
1273: AND c.config_hdr_id = p_config_hdr_id
1274: AND c.config_rev_nbr = p_config_rev_nbr )
1273: AND c.config_hdr_id = p_config_hdr_id
1274: AND c.config_rev_nbr = p_config_rev_nbr )
1275: OR EXISTS
1276: ( SELECT 'X'
1277: FROM CZ_CONFIG_DETAILS_V c
1278: WHERE c.component_code = l.component_code
1279: AND c.config_item_id = l.configuration_id
1280: AND c.config_hdr_id = p_config_hdr_id
1281: AND c.config_rev_nbr = p_config_rev_nbr
1417: /*---------------------------------------------------------
1418: PROCEDURE Handle_Deletes_Old
1419:
1420: If a component exists in oe_order_lines, but does not exist
1421: in cz_config_details_v, we need to delete that component.
1422:
1423: Change Record:
1424:
1425: bug 1939531: to not call check_if_cancellation
1455: AND l.open_flag = 'Y'
1456: AND
1457: (NOT EXISTS
1458: ( SELECT 'X'
1459: FROM CZ_CONFIG_DETAILS_V c
1460: WHERE c.component_code = l.component_code
1461: AND c.config_hdr_id = p_config_hdr_id
1462: AND c.config_rev_nbr = p_config_rev_nbr )
1463: OR EXISTS
1461: AND c.config_hdr_id = p_config_hdr_id
1462: AND c.config_rev_nbr = p_config_rev_nbr )
1463: OR EXISTS
1464: ( SELECT 'X'
1465: FROM CZ_CONFIG_DETAILS_V c
1466: WHERE c.component_code = l.component_code
1467: AND c.config_hdr_id = p_config_hdr_id
1468: AND c.config_rev_nbr = p_config_rev_nbr
1469: AND c.quantity = 0));
2702: FROM oe_order_lines OELNK
2703: WHERE OELNK.top_model_line_id = OEOPT.top_model_line_id
2704: AND OELNK.configuration_id =
2705: ( SELECT parent_config_item_id
2706: FROM cz_config_details_v
2707: WHERE config_hdr_id = OELNK.config_header_id
2708: AND config_rev_nbr = OELNK.config_rev_nbr
2709: AND config_item_id = OEOPT.configuration_id
2710: )
3000: FROM oe_order_lines OEATO
3001: WHERE OEOPT.top_model_line_id = OEATO.top_model_line_id
3002: AND OEATO.configuration_id =
3003: (SELECT ato_config_item_id
3004: FROM cz_config_details_v
3005: WHERE config_hdr_id = OEOPT.config_header_id
3006: AND config_rev_nbr = OEOPT.config_rev_nbr
3007: AND config_item_id = OEOPT.configuration_id)
3008: AND OEATO.open_flag = 'Y'