APPS.JAI_INV_ITEMS_PKG dependencies on JAI_RGM_TMPL_ITM_REGNS

Line 279: FROM JAI_RGM_TMPL_ITM_REGNS tirg

275:
276: CURSOR cur_chk_templ_itm_regns
277: IS
278: SELECT templ_itm_regns_id
279: FROM JAI_RGM_TMPL_ITM_REGNS tirg
280: WHERE tirg.templ_org_regns_id = p_templ_org_regns_id
281: AND tirg.inventory_item_id = p_inv_itm_id;
282:
283: ln_templ_itm_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ITM_REGNS_ID%TYPE DEFAULT NULL;

Line 283: ln_templ_itm_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ITM_REGNS_ID%TYPE DEFAULT NULL;

279: FROM JAI_RGM_TMPL_ITM_REGNS tirg
280: WHERE tirg.templ_org_regns_id = p_templ_org_regns_id
281: AND tirg.inventory_item_id = p_inv_itm_id;
282:
283: ln_templ_itm_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ITM_REGNS_ID%TYPE DEFAULT NULL;
284:
285: BEGIN
286:
287: IF p_templ_org_regns_id IS NULL THEN

Line 321: INSERT INTO JAI_RGM_TMPL_ITM_REGNS

317: FETCH cur_chk_templ_itm_regns INTO ln_templ_itm_regns_id;
318: CLOSE cur_chk_templ_itm_regns;
319: /* Create template item association */
320: IF ln_templ_itm_regns_id IS NULL THEN
321: INSERT INTO JAI_RGM_TMPL_ITM_REGNS
322: (
323: templ_itm_regns_id
324: , templ_org_regns_id
325: , inventory_item_id

Line 333: JAI_RGM_TMPL_ITM_REGNS_S.nextval

329: , last_updated_by
330: , last_update_login
331: )
332: VALUES (
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

Line 757: FROM JAI_RGM_TMPL_ITM_REGNS tirg

753: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
754: )
755: IS
756: SELECT torg.template_id
757: FROM JAI_RGM_TMPL_ITM_REGNS tirg
758: ,JAI_RGM_TMPL_ORG_REGNS torg
759: ,JAI_RGM_ITM_TEMPLATES rgtmp
760: WHERE tirg.templ_org_regns_id = torg.templ_org_regns_id
761: AND torg.template_id = rgtmp.template_id

Line 921: CURSOR cur_chk_templ_itm_regns (cpn_templ_org_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ORG_REGNS_ID%TYPE)

917: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE;
918: ln_templ_itm_regns NUMBER := NULL;
919: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.delete_items';
920:
921: CURSOR cur_chk_templ_itm_regns (cpn_templ_org_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ORG_REGNS_ID%TYPE)
922: IS
923: SELECT 1
924: FROM JAI_RGM_TMPL_ITM_REGNS
925: WHERE templ_org_regns_id = cpn_templ_org_regns_id;

Line 924: FROM JAI_RGM_TMPL_ITM_REGNS

920:
921: CURSOR cur_chk_templ_itm_regns (cpn_templ_org_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ORG_REGNS_ID%TYPE)
922: IS
923: SELECT 1
924: FROM JAI_RGM_TMPL_ITM_REGNS
925: WHERE templ_org_regns_id = cpn_templ_org_regns_id;
926:
927: BEGIN
928: ln_organization_id := pn_organization_id;

Line 942: DELETE FROM JAI_RGM_TMPL_ITM_REGNS

938: DELETE FROM JAI_RGM_ITM_TMPL_ATTRS
939: WHERE rgm_item_regns_id = ln_rgm_item_regns_id;
940: END IF;
941:
942: DELETE FROM JAI_RGM_TMPL_ITM_REGNS
943: WHERE templ_itm_regns_id IN (SELECT templ_itm_regns_id
944: FROM JAI_RGM_TMPL_ITM_REGNS tirg
945: ,JAI_RGM_TMPL_ORG_REGNS torg
946: ,JAI_RGM_ITM_TEMPLATES rgtmp

Line 944: FROM JAI_RGM_TMPL_ITM_REGNS tirg

940: END IF;
941:
942: DELETE FROM JAI_RGM_TMPL_ITM_REGNS
943: WHERE templ_itm_regns_id IN (SELECT templ_itm_regns_id
944: FROM JAI_RGM_TMPL_ITM_REGNS tirg
945: ,JAI_RGM_TMPL_ORG_REGNS torg
946: ,JAI_RGM_ITM_TEMPLATES rgtmp
947: WHERE tirg.templ_org_regns_id = torg.templ_org_regns_id
948: AND torg.template_id = rgtmp.template_id