APPS.JAI_INV_ITEMS_PKG dependencies on JAI_RGM_TMPL_ITM_REGNS

Line 274: FROM JAI_RGM_TMPL_ITM_REGNS tirg

270:
271: CURSOR cur_chk_templ_itm_regns
272: IS
273: SELECT templ_itm_regns_id
274: FROM JAI_RGM_TMPL_ITM_REGNS tirg
275: WHERE tirg.templ_org_regns_id = p_templ_org_regns_id
276: AND tirg.inventory_item_id = p_inv_itm_id;
277:
278: ln_templ_itm_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ITM_REGNS_ID%TYPE DEFAULT NULL;

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

274: FROM JAI_RGM_TMPL_ITM_REGNS tirg
275: WHERE tirg.templ_org_regns_id = p_templ_org_regns_id
276: AND tirg.inventory_item_id = p_inv_itm_id;
277:
278: ln_templ_itm_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ITM_REGNS_ID%TYPE DEFAULT NULL;
279:
280: BEGIN
281:
282: IF p_templ_org_regns_id IS NULL THEN

Line 316: INSERT INTO JAI_RGM_TMPL_ITM_REGNS

312: FETCH cur_chk_templ_itm_regns INTO ln_templ_itm_regns_id;
313: CLOSE cur_chk_templ_itm_regns;
314: /* Create template item association */
315: IF ln_templ_itm_regns_id IS NULL THEN
316: INSERT INTO JAI_RGM_TMPL_ITM_REGNS
317: (
318: templ_itm_regns_id
319: , templ_org_regns_id
320: , inventory_item_id

Line 328: JAI_RGM_TMPL_ITM_REGNS_S.nextval

324: , last_updated_by
325: , last_update_login
326: )
327: VALUES (
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

Line 750: FROM JAI_RGM_TMPL_ITM_REGNS tirg

746: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
747: )
748: IS
749: SELECT torg.template_id
750: FROM JAI_RGM_TMPL_ITM_REGNS tirg
751: ,JAI_RGM_TMPL_ORG_REGNS torg
752: ,JAI_RGM_ITM_TEMPLATES rgtmp
753: WHERE tirg.templ_org_regns_id = torg.templ_org_regns_id
754: AND torg.template_id = rgtmp.template_id

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

906: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE;
907: ln_templ_itm_regns NUMBER := NULL;
908: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.delete_items';
909:
910: CURSOR cur_chk_templ_itm_regns (cpn_templ_org_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ORG_REGNS_ID%TYPE)
911: IS
912: SELECT 1
913: FROM JAI_RGM_TMPL_ITM_REGNS
914: WHERE templ_org_regns_id = cpn_templ_org_regns_id;

Line 913: FROM JAI_RGM_TMPL_ITM_REGNS

909:
910: CURSOR cur_chk_templ_itm_regns (cpn_templ_org_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ORG_REGNS_ID%TYPE)
911: IS
912: SELECT 1
913: FROM JAI_RGM_TMPL_ITM_REGNS
914: WHERE templ_org_regns_id = cpn_templ_org_regns_id;
915:
916: BEGIN
917: ln_organization_id := pn_organization_id;

Line 931: DELETE FROM JAI_RGM_TMPL_ITM_REGNS

927: DELETE FROM JAI_RGM_ITM_TMPL_ATTRS
928: WHERE rgm_item_regns_id = ln_rgm_item_regns_id;
929: END IF;
930:
931: DELETE FROM JAI_RGM_TMPL_ITM_REGNS
932: WHERE templ_itm_regns_id IN (SELECT templ_itm_regns_id
933: FROM JAI_RGM_TMPL_ITM_REGNS tirg
934: ,JAI_RGM_TMPL_ORG_REGNS torg
935: ,JAI_RGM_ITM_TEMPLATES rgtmp

Line 933: FROM JAI_RGM_TMPL_ITM_REGNS tirg

929: END IF;
930:
931: DELETE FROM JAI_RGM_TMPL_ITM_REGNS
932: WHERE templ_itm_regns_id IN (SELECT templ_itm_regns_id
933: FROM JAI_RGM_TMPL_ITM_REGNS tirg
934: ,JAI_RGM_TMPL_ORG_REGNS torg
935: ,JAI_RGM_ITM_TEMPLATES rgtmp
936: WHERE tirg.templ_org_regns_id = torg.templ_org_regns_id
937: AND torg.template_id = rgtmp.template_id