219: , p_template_name
220: , p_description
221: , p_regime_code
222: , sysdate
223: , fnd_global.user_id
224: , sysdate
225: , fnd_global.user_id
226: , fnd_global.login_id
227: )
221: , p_regime_code
222: , sysdate
223: , fnd_global.user_id
224: , sysdate
225: , fnd_global.user_id
226: , fnd_global.login_id
227: )
228: RETURNING template_id INTO ln_template_id;
229:
222: , sysdate
223: , fnd_global.user_id
224: , sysdate
225: , fnd_global.user_id
226: , fnd_global.login_id
227: )
228: RETURNING template_id INTO ln_template_id;
229:
230: RETURN ln_template_id ;
300: p_templ_org_regns_id
301: , p_templ_id
302: , p_org_id
303: , sysdate
304: , fnd_global.user_id
305: , sysdate
306: , fnd_global.user_id
307: , fnd_global.login_id
308: );
302: , p_org_id
303: , sysdate
304: , fnd_global.user_id
305: , sysdate
306: , fnd_global.user_id
307: , fnd_global.login_id
308: );
309: END IF;
310:
303: , sysdate
304: , fnd_global.user_id
305: , sysdate
306: , fnd_global.user_id
307: , fnd_global.login_id
308: );
309: END IF;
310:
311: OPEN cur_chk_templ_itm_regns;
328: JAI_RGM_TMPL_ITM_REGNS_S.nextval
329: , p_templ_org_regns_id
330: , p_inv_itm_id
331: , sysdate
332: , fnd_global.user_id
333: , sysdate
334: , fnd_global.user_id
335: , fnd_global.login_id
336: );
330: , p_inv_itm_id
331: , sysdate
332: , fnd_global.user_id
333: , sysdate
334: , fnd_global.user_id
335: , fnd_global.login_id
336: );
337: END IF;
338:
331: , sysdate
332: , fnd_global.user_id
333: , sysdate
334: , fnd_global.user_id
335: , fnd_global.login_id
336: );
337: END IF;
338:
339: END assign_template;
422: , p_regime_code
423: , p_organization_id
424: , p_inventory_item_id
425: , sysdate
426: , fnd_global.user_id
427: , sysdate
428: , fnd_global.user_id
429: , fnd_global.login_id
430: ) returning rgm_item_regns_id into ln_rgm_item_regns_id;
424: , p_inventory_item_id
425: , sysdate
426: , fnd_global.user_id
427: , sysdate
428: , fnd_global.user_id
429: , fnd_global.login_id
430: ) returning rgm_item_regns_id into ln_rgm_item_regns_id;
431: END IF;
432:
425: , sysdate
426: , fnd_global.user_id
427: , sysdate
428: , fnd_global.user_id
429: , fnd_global.login_id
430: ) returning rgm_item_regns_id into ln_rgm_item_regns_id;
431: END IF;
432:
433: jai_inv_items_pkg.jai_create_attribs( p_template_id => ''
468: ,p_template_id
469: ,p_rgm_item_regns_id
470: ,p_tab_attributes(ln_attrib).attribute_code
471: ,p_tab_attributes(ln_attrib).attribute_value
472: ,SYSDATE, fnd_global.user_id , SYSDATE, fnd_global.login_id, fnd_global.user_id
473: );
474: END LOOP;
475: EXCEPTION
476: WHEN OTHERS THEN
613: FROM mtl_system_items_interface intf
614: ,mtl_parameters master_org
615: WHERE intf.process_flag = 7
616: AND intf.transaction_type = 'CREATE'
617: AND intf.request_id = fnd_global.conc_request_id
618: AND intf.set_process_id = pn_set_process_id
619: AND intf.organization_id = master_org.organization_id
620: AND intf.organization_id <> master_org.master_organization_id ;
621:
877: , item_tariff
878: , item_folio
879: , excise_flag
880: , sysdate
881: , fnd_global.user_id
882: , sysdate
883: , fnd_global.user_id
884: , fnd_global.login_id
885: , item_trading_flag
879: , excise_flag
880: , sysdate
881: , fnd_global.user_id
882: , sysdate
883: , fnd_global.user_id
884: , fnd_global.login_id
885: , item_trading_flag
886: , NULL
887: FROM JAI_INV_ITM_SETUPS
880: , sysdate
881: , fnd_global.user_id
882: , sysdate
883: , fnd_global.user_id
884: , fnd_global.login_id
885: , item_trading_flag
886: , NULL
887: FROM JAI_INV_ITM_SETUPS
888: WHERE organization_id = ln_source_organization_id