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.4 2007/02/26 17:25:43 sacsethi 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 190: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE

186: END jai_get_attrib;
187:
188: /*------------------------------------------- CREATE TEMPLATE -------------------------------------------*/
189:
190: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE
191: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE
192: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL
193: )
194: RETURN NUMBER

Line 191: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE

187:
188: /*------------------------------------------- CREATE TEMPLATE -------------------------------------------*/
189:
190: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE
191: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE
192: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL
193: )
194: RETURN NUMBER
195: AS

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

188: /*------------------------------------------- CREATE TEMPLATE -------------------------------------------*/
189:
190: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE
191: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE
192: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL
193: )
194: RETURN NUMBER
195: AS
196:

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

193: )
194: RETURN NUMBER
195: AS
196:
197: ln_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE DEFAULT NULL;
198: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_template';
199: BEGIN -- Create Template
200:
201: --SELECT JAI_RGM_ITM_TEMPLATES_S.NEXTVAL INTO ln_template_id FROM DUAL;

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

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

Line 203: INSERT INTO JAI_RGM_ITM_TEMPLATES

199: BEGIN -- Create Template
200:
201: --SELECT JAI_RGM_ITM_TEMPLATES_S.NEXTVAL INTO ln_template_id FROM DUAL;
202:
203: INSERT INTO JAI_RGM_ITM_TEMPLATES
204: (
205: template_id
206: , template_name
207: , description

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

214: )
215: VALUES
216: (
217: --ln_template_id
218: JAI_RGM_ITM_TEMPLATES_S.NEXTVAL /* Modified by Ramananda for removal of SQL LITERALs */
219: , p_template_name
220: , p_description
221: , p_regime_code
222: , sysdate

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

236: app_exception.raise_exception;
237: END jai_create_template;
238: /*---------------------------------------------- ASSIGN TEMPLATE ----------------------------------------*/
239:
240: PROCEDURE jai_assign_template( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
241: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
242: , p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
243: )
244: AS

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

260: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE DEFAULT NULL;
261: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_assign_template';
262:
263: /* -------------------------------------- Local Procedure ---------------------------------------*/
264: PROCEDURE assign_template (p_templ_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
265: ,p_org_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
266: ,p_inv_itm_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
267: ,p_templ_org_regns_id IN OUT NOCOPY JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE
268: )

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

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

Line 752: ,JAI_RGM_ITM_TEMPLATES rgtmp

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
755: AND torg.organization_id = cpn_organization_id
756: AND tirg.inventory_item_id = cpn_inventory_item_id

Line 935: ,JAI_RGM_ITM_TEMPLATES rgtmp

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
938: AND tirg.inventory_item_id = ln_inventory_item_id
939: AND torg.organization_id = ln_organization_id