/*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_transfer_option => 2,
x_designator_option => 1,
x_alt_bom_designator => NULL,
x_alt_rtg_designator => NULL,
x_alt_bom_designator => NULL,
x_alt_rtg_designator => NULL,
x_effectivity_date => SYSDATE,
x_last_login_id => -1,
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_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_mfg_description => NULL,
x_segment1 => NULL,
x_segment2 => NULL,
x_segment3 => NULL,
x_segment4 => NULL,
x_segment5 => NULL,
x_segment4 => NULL,
x_segment5 => NULL,
x_segment6 => NULL,
x_segment7 => NULL,
x_segment8 => NULL,
x_segment9 => NULL,
x_segment8 => NULL,
x_segment9 => NULL,
x_segment10 => NULL,
x_segment11 => NULL,
x_segment12 => NULL,
x_segment12 => NULL,
x_segment13 => NULL,
x_segment14 => NULL,
x_segment15 => NULL,
x_segment15 => NULL,
x_segment16 => NULL,
x_segment17 => NULL,
x_segment18 => NULL,
x_segment18 => NULL,
x_segment19 => NULL,
x_segment20 => NULL,
x_implemented_only => 1,
x_implemented_only => 1,
x_unit_number => NULL,
x_commit => TRUE);
END;
END;
No comments:
Post a Comment