224: , p_template_name
225: , p_description
226: , p_regime_code
227: , sysdate
228: , fnd_global.user_id
229: , sysdate
230: , fnd_global.user_id
231: , fnd_global.login_id
232: )
226: , p_regime_code
227: , sysdate
228: , fnd_global.user_id
229: , sysdate
230: , fnd_global.user_id
231: , fnd_global.login_id
232: )
233: RETURNING template_id INTO ln_template_id;
234:
227: , sysdate
228: , fnd_global.user_id
229: , sysdate
230: , fnd_global.user_id
231: , fnd_global.login_id
232: )
233: RETURNING template_id INTO ln_template_id;
234:
235: RETURN ln_template_id ;
305: p_templ_org_regns_id
306: , p_templ_id
307: , p_org_id
308: , sysdate
309: , fnd_global.user_id
310: , sysdate
311: , fnd_global.user_id
312: , fnd_global.login_id
313: );
307: , p_org_id
308: , sysdate
309: , fnd_global.user_id
310: , sysdate
311: , fnd_global.user_id
312: , fnd_global.login_id
313: );
314: END IF;
315:
308: , sysdate
309: , fnd_global.user_id
310: , sysdate
311: , fnd_global.user_id
312: , fnd_global.login_id
313: );
314: END IF;
315:
316: OPEN cur_chk_templ_itm_regns;
333: JAI_RGM_TMPL_ITM_REGNS_S.nextval
334: , p_templ_org_regns_id
335: , p_inv_itm_id
336: , sysdate
337: , fnd_global.user_id
338: , sysdate
339: , fnd_global.user_id
340: , fnd_global.login_id
341: );
335: , p_inv_itm_id
336: , sysdate
337: , fnd_global.user_id
338: , sysdate
339: , fnd_global.user_id
340: , fnd_global.login_id
341: );
342: END IF;
343:
336: , sysdate
337: , fnd_global.user_id
338: , sysdate
339: , fnd_global.user_id
340: , fnd_global.login_id
341: );
342: END IF;
343:
344: END assign_template;
427: , p_regime_code
428: , p_organization_id
429: , p_inventory_item_id
430: , sysdate
431: , fnd_global.user_id
432: , sysdate
433: , fnd_global.user_id
434: , fnd_global.login_id
435: ) returning rgm_item_regns_id into ln_rgm_item_regns_id;
429: , p_inventory_item_id
430: , sysdate
431: , fnd_global.user_id
432: , sysdate
433: , fnd_global.user_id
434: , fnd_global.login_id
435: ) returning rgm_item_regns_id into ln_rgm_item_regns_id;
436: END IF;
437:
430: , sysdate
431: , fnd_global.user_id
432: , sysdate
433: , fnd_global.user_id
434: , fnd_global.login_id
435: ) returning rgm_item_regns_id into ln_rgm_item_regns_id;
436: END IF;
437:
438: jai_inv_items_pkg.jai_create_attribs( p_template_id => ''
473: ,p_template_id
474: ,p_rgm_item_regns_id
475: ,p_tab_attributes(ln_attrib).attribute_code
476: ,p_tab_attributes(ln_attrib).attribute_value
477: ,SYSDATE, fnd_global.user_id , SYSDATE, fnd_global.login_id, fnd_global.user_id
478: );
479: END LOOP;
480: EXCEPTION
481: WHEN OTHERS THEN
618: FROM mtl_system_items_interface intf
619: ,mtl_parameters master_org
620: WHERE intf.process_flag = 7
621: AND intf.transaction_type = 'CREATE'
622: AND intf.request_id = fnd_global.conc_request_id
623: AND intf.set_process_id = pn_set_process_id
624: AND intf.organization_id = master_org.organization_id
625: AND intf.organization_id <> master_org.master_organization_id ;
626:
887: , item_tariff
888: , item_folio
889: , excise_flag
890: , sysdate
891: , fnd_global.user_id
892: , sysdate
893: , fnd_global.user_id
894: , fnd_global.login_id
895: , item_trading_flag
889: , excise_flag
890: , sysdate
891: , fnd_global.user_id
892: , sysdate
893: , fnd_global.user_id
894: , fnd_global.login_id
895: , item_trading_flag
896: , NULL
897: FROM JAI_INV_ITM_SETUPS
890: , sysdate
891: , fnd_global.user_id
892: , sysdate
893: , fnd_global.user_id
894: , fnd_global.login_id
895: , item_trading_flag
896: , NULL
897: FROM JAI_INV_ITM_SETUPS
898: WHERE organization_id = ln_source_organization_id