Friday, 6 December 2024

API FOR TRANSFER TO MANUFACTURING IN ORACLE APPS R12

 /*API FOR TRANSFER TO MANUFACTURING IN ORACLE APPS R12*/

DECLARE
    l_inventory_item_id NUMBER := 11081350;
    l_org_id            NUMBER := 319;
    l_resp_id           NUMBER;
    l_appl_id           NUMBER;
BEGIN
    SELECT responsibility_id,
           application_id
    INTO   l_resp_id, l_appl_id
    FROM   fnd_responsibility
    WHERE  responsibility_key = '-------'; --'Transfer to Manufacturing';

    --initialize user session
    fnd_global.Apps_initialize(user_id=>fnd_global.user_id,resp_id=>l_resp_id,resp_appl_id=>l_appl_id);

    
eng_bom_rtg_transfer_pkg.Eng_bom_rtg_transfer 

    (x_org_id => l_org_id,
    x_eng_item_id => l_inventory_item_id, 
    x_mfg_item_id => l_inventory_item_id,
    x_transfer_option => 2, 
    x_designator_option => 1,
    x_alt_bom_designator => NULL,
    x_alt_rtg_designator => NULL, 
    x_effectivity_date => SYSDATE,
    x_last_login_id => -1, 
    x_bom_rev_starting => NULL,
    x_rtg_rev_starting => NULL,
    x_ecn_name => NULL, --'ABC.ABC_11377_121',
    x_item_code => 1, 
    x_bom_code => 1, 
    x_rtg_code => 1,
    x_mfg_description => NULL,
    x_segment1 => NULL, 
    x_segment2 => NULL, 
    x_segment3 => NULL,
    x_segment4 => NULL,
    x_segment5 => NULL, 
    x_segment6 => NULL, 
    x_segment7 => NULL,
    x_segment8 => NULL,
    x_segment9 => NULL, 
    x_segment10 => NULL, 
    x_segment11 => NULL,
    x_segment12 => NULL, 
    x_segment13 => NULL, 
    x_segment14 => NULL,
    x_segment15 => NULL, 
    x_segment16 => NULL, 
    x_segment17 => NULL,
    x_segment18 => NULL, 
    x_segment19 => NULL, 
    x_segment20 => NULL,
    x_implemented_only => 1, 
    x_unit_number => NULL, 
    x_commit => TRUE);
END; 

No comments:

Post a Comment