APPS.JAI_INV_ITEMS_PKG dependencies on JAI_RGM_ITM_TEMPLATES

Line 4: ( p_regime_code IN JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE ,

1: PACKAGE BODY jai_inv_items_pkg AS
2: /* $Header: jai_inv_items.plb 120.6 2012/05/23 08:40:50 zxin ship $ */
3: PROCEDURE jai_get_attrib
4: ( p_regime_code IN JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE ,
5: p_organization_id IN JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE ,
6: p_inventory_item_id IN JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE ,
7: p_attribute_code IN JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_CODE%TYPE,
8: p_attribute_value OUT NOCOPY JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE,

Line 195: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE

191: END jai_get_attrib;
192:
193: /*------------------------------------------- CREATE TEMPLATE -------------------------------------------*/
194:
195: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE
196: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE
197: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL
198: )
199: RETURN NUMBER

Line 196: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE

192:
193: /*------------------------------------------- CREATE TEMPLATE -------------------------------------------*/
194:
195: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE
196: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE
197: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL
198: )
199: RETURN NUMBER
200: AS

Line 197: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL

193: /*------------------------------------------- CREATE TEMPLATE -------------------------------------------*/
194:
195: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE
196: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE
197: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL
198: )
199: RETURN NUMBER
200: AS
201:

Line 202: ln_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE DEFAULT NULL;

198: )
199: RETURN NUMBER
200: AS
201:
202: ln_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE DEFAULT NULL;
203: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_template';
204: BEGIN -- Create Template
205:
206: --SELECT JAI_RGM_ITM_TEMPLATES_S.NEXTVAL INTO ln_template_id FROM DUAL;

Line 206: --SELECT JAI_RGM_ITM_TEMPLATES_S.NEXTVAL INTO ln_template_id FROM DUAL;

202: ln_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE DEFAULT NULL;
203: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_template';
204: BEGIN -- Create Template
205:
206: --SELECT JAI_RGM_ITM_TEMPLATES_S.NEXTVAL INTO ln_template_id FROM DUAL;
207:
208: INSERT INTO JAI_RGM_ITM_TEMPLATES
209: (
210: template_id

Line 208: INSERT INTO JAI_RGM_ITM_TEMPLATES

204: BEGIN -- Create Template
205:
206: --SELECT JAI_RGM_ITM_TEMPLATES_S.NEXTVAL INTO ln_template_id FROM DUAL;
207:
208: INSERT INTO JAI_RGM_ITM_TEMPLATES
209: (
210: template_id
211: , template_name
212: , description

Line 223: JAI_RGM_ITM_TEMPLATES_S.NEXTVAL /* Modified by Ramananda for removal of SQL LITERALs */

219: )
220: VALUES
221: (
222: --ln_template_id
223: JAI_RGM_ITM_TEMPLATES_S.NEXTVAL /* Modified by Ramananda for removal of SQL LITERALs */
224: , p_template_name
225: , p_description
226: , p_regime_code
227: , sysdate

Line 245: PROCEDURE jai_assign_template( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE

241: app_exception.raise_exception;
242: END jai_create_template;
243: /*---------------------------------------------- ASSIGN TEMPLATE ----------------------------------------*/
244:
245: PROCEDURE jai_assign_template( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
246: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
247: , p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
248: )
249: AS

Line 269: PROCEDURE assign_template (p_templ_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE

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
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: )

Line 450: PROCEDURE jai_create_attribs ( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE

446: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
447: app_exception.raise_exception;
448: END jai_create_item_regns ;
449: /* -------------------------------------- CREATE TEMPLATE ATTRIBUTES ------------------------------*/
450: PROCEDURE jai_create_attribs ( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
451: ,p_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE
452: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
453: )
454: IS

Line 759: ,JAI_RGM_ITM_TEMPLATES rgtmp

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
763: AND tirg.inventory_item_id = cpn_inventory_item_id

Line 946: ,JAI_RGM_ITM_TEMPLATES rgtmp

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
950: AND torg.organization_id = ln_organization_id