[Home] [Help]
7: -- Function : Insert, update and validation of the asset attribute assignemnt data
8: -- Pre-reqs : None.
9: */
10:
11: /* This procedure inserts a record in the mtl_eam_asset_attr_groups table
12: -- Parameters :
13: -- IN : P_API_VERSION IN NUMBER REQUIRED
14: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
15: -- DEFAULT = FND_API.G_FALSE
201: end if;
202: */
203: /* End validation calls */
204:
205: SELECT MTL_EAM_ASSET_ATTR_GROUPS_S.NEXTVAL INTO L_ASSOCIATION_ID FROM DUAL;
206:
207: X_NEW_ASSOCIATION_ID := L_ASSOCIATION_ID;
208:
209:
206:
207: X_NEW_ASSOCIATION_ID := L_ASSOCIATION_ID;
208:
209:
210: INSERT INTO MTL_EAM_ASSET_ATTR_GROUPS
211: (
212: ASSOCIATION_ID ,
213: APPLICATION_ID ,
214: DESCRIPTIVE_FLEXFIELD_NAME ,
287:
288: END INSERT_ASSETATTR_GRP;
289:
290: /*
291: This procedure updates a record in the mtl_eam_asset_attr_groups table
292: -- Parameters :
293: -- IN : P_API_VERSION IN NUMBER REQUIRED
294: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
295: -- DEFAULT = FND_API.G_FALSE
452: */
453: /* Standard Start of API savepoint */
454:
455:
456: UPDATE MTL_EAM_ASSET_ATTR_GROUPS SET
457: APPLICATION_ID = P_APPLICATION_ID ,
458: DESCRIPTIVE_FLEXFIELD_NAME = P_DESCRIPTIVE_FLEXFIELD_NAME ,
459: DESCRIPTIVE_FLEX_CONTEXT_CODE = P_DESC_FLEX_CONTEXT_CODE ,
460: /* ORGANIZATION_ID = P_ORGANIZATION_ID ,
668: begin
669: /*
670: if (p_item_type=1) then
671: select association_id into l_association_id
672: from mtl_eam_asset_attr_groups
673: where creation_organization_id=p_creation_organization_id
674: and inventory_item_id=p_inventory_item_id
675: and descriptive_flex_context_code=p_desc_flex_context_code;
676: elsif (p_item_type=3) then
675: and descriptive_flex_context_code=p_desc_flex_context_code;
676: elsif (p_item_type=3) then
677: */
678: select association_id into l_association_id
679: from mtl_eam_asset_attr_groups
680: where inventory_item_id=p_inventory_item_id
681: and descriptive_flex_context_code=p_desc_flex_context_code;
682: --end if;
683: