bom_copy_routing

Hi All,

Wanted to copy a routing with different alternate and commonizing to its model assembly.

Have tried with BOM_COPY_ROUTING.COPY_ROUTING, but no luck.

DECLARE

    lv_id             NUMBER;

    X_msg_count       NUMBER;

    x_msg_data        VARCHAR2 (4000);

    x_return_status   VARCHAR2 (2000);

BEGIN

    SELECT bom_operational_routings_s.NEXTVAL INTO lv_id FROM DUAL;

    dummy (lv_id);

    fnd_msg_pub.initialize ();

    bom_copy_routing.copy_routing (lv_id,

                                   18878246,

                                   166,

                                   166,

                                   2,

                                   -1,

                                   43600725,

                                   1,

                                   'FA',

                                   SYSDATE,

                                   NULL,                      -- Change Notice

                                   NULL,           -- Revised Item Sequence Id

                                   1, -- routing_or_eco ( Routing always for the existing flows )

                                   -- Existing routing copy will copied to sysdate