APPS.JAI_INV_ITEMS_PKG dependencies on JAI_RGM_TMPL_ORG_REGNS

Line 261: FROM JAI_RGM_TMPL_ORG_REGNS torg

257:
258: CURSOR cur_chk_templ_org
259: IS
260: SELECT templ_org_regns_id
261: FROM JAI_RGM_TMPL_ORG_REGNS torg
262: WHERE torg.organization_id = p_organization_id
263: AND torg.template_id = p_template_id;
264:
265: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE DEFAULT NULL;

Line 265: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE DEFAULT NULL;

261: FROM JAI_RGM_TMPL_ORG_REGNS torg
262: WHERE torg.organization_id = p_organization_id
263: AND torg.template_id = p_template_id;
264:
265: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE DEFAULT NULL;
266: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_assign_template';
267:
268: /* -------------------------------------- Local Procedure ---------------------------------------*/
269: PROCEDURE assign_template (p_templ_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE

Line 272: ,p_templ_org_regns_id IN OUT NOCOPY JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE

268: /* -------------------------------------- Local Procedure ---------------------------------------*/
269: PROCEDURE assign_template (p_templ_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
270: ,p_org_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
271: ,p_inv_itm_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
272: ,p_templ_org_regns_id IN OUT NOCOPY JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE
273: )
274: AS
275:
276: CURSOR cur_chk_templ_itm_regns

Line 289: SELECT JAI_RGM_TMPL_ORG_REGNS_S.NEXTVAL

285: BEGIN
286:
287: IF p_templ_org_regns_id IS NULL THEN
288:
289: SELECT JAI_RGM_TMPL_ORG_REGNS_S.NEXTVAL
290: INTO p_templ_org_regns_id
291: FROM DUAL;
292: /* Create template organization association */
293: INSERT INTO JAI_RGM_TMPL_ORG_REGNS

Line 293: INSERT INTO JAI_RGM_TMPL_ORG_REGNS

289: SELECT JAI_RGM_TMPL_ORG_REGNS_S.NEXTVAL
290: INTO p_templ_org_regns_id
291: FROM DUAL;
292: /* Create template organization association */
293: INSERT INTO JAI_RGM_TMPL_ORG_REGNS
294: ( templ_org_regns_id
295: , template_id
296: , organization_id
297: , creation_date

Line 758: ,JAI_RGM_TMPL_ORG_REGNS torg

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
762: AND torg.organization_id = cpn_organization_id

Line 917: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE;

913: IS
914: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
915: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
916: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_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)

Line 945: ,JAI_RGM_TMPL_ORG_REGNS torg

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
949: AND tirg.inventory_item_id = ln_inventory_item_id

Line 964: DELETE FROM JAI_RGM_TMPL_ORG_REGNS

960: FETCH cur_chk_templ_itm_regns INTO ln_templ_itm_regns ;
961: CLOSE cur_chk_templ_itm_regns ;
962:
963: IF ln_templ_itm_regns IS NULL THEN
964: DELETE FROM JAI_RGM_TMPL_ORG_REGNS
965: WHERE templ_org_regns_id = ln_templ_org_regns_id;
966: END IF;
967:
968: DELETE FROM JAI_INV_ITM_SETUPS