APPS.CTO_MANUAL_LINK_CONFIG dependencies on BOM_CTO_ORDER_LINES

Line 325: FROM bom_cto_order_lines

321: ship_from_org_id
322: BULK COLLECT INTO old_config_dtls.config_item_id,
323: old_config_dtls.base_item_id,
324: old_config_dtls.ship_from_org_id
325: FROM bom_cto_order_lines
326: WHERE top_model_line_id = p_model_line_id
327: AND config_item_id IS NOT NULL
328: AND line_id <> top_model_line_id;
329:

Line 343: UPDATE bom_cto_order_lines

339: END IF;
340:
341: l_stmt_num := 180;
342:
343: UPDATE bom_cto_order_lines
344: SET config_item_id = p_config_item_id
345: WHERE line_id = p_model_line_id;
346:
347: ELSE

Line 452: UPDATE bom_cto_order_lines

448:
449: IF flag = 0 THEN --bom doesn't exist in any orgs in sourcing chain. Updating the top level config
450: l_stmt_num := 230;
451:
452: UPDATE bom_cto_order_lines
453: SET config_item_id = p_config_item_id
454: WHERE line_id = p_model_line_id;
455:
456: UPDATE bom_cto_order_lines --Updating the lower level configs to NULL

Line 456: UPDATE bom_cto_order_lines --Updating the lower level configs to NULL

452: UPDATE bom_cto_order_lines
453: SET config_item_id = p_config_item_id
454: WHERE line_id = p_model_line_id;
455:
456: UPDATE bom_cto_order_lines --Updating the lower level configs to NULL
457: SET config_item_id = NULL
458: WHERE top_model_line_id = p_model_line_id
459: AND config_item_id IS NOT NULL
460: AND line_id <> top_model_line_id;

Line 482: UPDATE bom_cto_order_lines

478: IF new_config_dtls.config_item_id.Count = 0 THEN
479: --New config doesn't have child configs. Updating only the top level config
480: l_stmt_num := 260;
481:
482: UPDATE bom_cto_order_lines
483: SET config_item_id = p_config_item_id
484: WHERE line_id = p_model_line_id;
485:
486: --Updating lower level configs of original config to NULL

Line 487: UPDATE bom_cto_order_lines

483: SET config_item_id = p_config_item_id
484: WHERE line_id = p_model_line_id;
485:
486: --Updating lower level configs of original config to NULL
487: UPDATE bom_cto_order_lines
488: SET config_item_id = NULL
489: WHERE top_model_line_id = p_model_line_id
490: AND config_item_id IS NOT NULL
491: AND line_id <> top_model_line_id;

Line 508: UPDATE bom_cto_order_lines

504: bmodel_exists := 1;
505: l_stmt_num := 270;
506:
507: --Updating config id corresponding to the model old_config_dtls.base_item_id(i)
508: UPDATE bom_cto_order_lines
509: SET config_item_id = new_config_dtls.config_item_id(j)
510: WHERE ato_line_id = p_model_line_id
511: AND inventory_item_id = new_config_dtls.base_item_id(j);
512:

Line 521: UPDATE bom_cto_order_lines

517:
518: IF bmodel_exists = 0 THEN --BOM of new config doesn't have this model
519: l_stmt_num := 280;
520:
521: UPDATE bom_cto_order_lines
522: SET config_item_id = NULL
523: WHERE ato_line_id = p_model_line_id
524: AND inventory_item_id = old_config_dtls.base_item_id(i);
525: END IF;

Line 537: UPDATE bom_cto_order_lines

533: NULL;
534: ELSE
535: l_stmt_num := 290;
536:
537: UPDATE bom_cto_order_lines
538: SET config_item_id = p_config_item_id
539: WHERE line_id = p_model_line_id;
540: END IF;
541: --End Bugfix 6398466