APPS.BIS_AK_REGION_PUB dependencies on AK_ATTRIBUTES

Line 476: from ak_attributes

472: l_nested_region_appl_id number;
473:
474: cursor cAttributeExists is
475: select count(1)
476: from ak_attributes
477: where attribute_code = X_ATTRIBUTE_CODE
478: and attribute_application_id = X_ATTRIBUTE_APPLICATION_ID;
479:
480: begin

Line 492: AK_ATTRIBUTES_PKG.INSERT_ROW (

488:
489: if l_attributeCount = 0 then
490: -- Insert into Attributes
491:
492: AK_ATTRIBUTES_PKG.INSERT_ROW (
493: X_ROWID => l_attribute_rowid,
494: X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
495: X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
496: X_ATTRIBUTE_LABEL_LENGTH => c_ATTR_LABEL_LENGTH,

Line 1763: from ak_attributes

1759: l_item_style varchar2(30);
1760: l_nested_region_appl_id number;
1761: cursor cAttributeExists is
1762: select count(1)
1763: from ak_attributes
1764: where attribute_code = p_ATTRIBUTE_CODE
1765: and attribute_application_id = p_ATTRIBUTE_APPLICATION_ID;
1766:
1767: begin

Line 1780: AK_ATTRIBUTES_PKG.INSERT_ROW (

1776:
1777: if l_attributeCount = 0 then
1778: -- Insert into Attributes
1779:
1780: AK_ATTRIBUTES_PKG.INSERT_ROW (
1781: X_ROWID => l_attribute_rowid,
1782: X_ATTRIBUTE_APPLICATION_ID => p_ATTRIBUTE_APPLICATION_ID,
1783: X_ATTRIBUTE_CODE => p_ATTRIBUTE_CODE,
1784: X_ATTRIBUTE_LABEL_LENGTH => c_ATTR_LABEL_LENGTH,

Line 1980: FROM ak_attributes

1976: l_Item_Style AK_REGION_ITEMS.ITEM_STYLE%TYPE;
1977:
1978: CURSOR cAttributeExists IS
1979: SELECT COUNT(1)
1980: FROM ak_attributes
1981: WHERE attribute_code = p_Region_Item_Rec.Attribute_Code
1982: AND attribute_application_id = p_Region_Item_Rec.Attribute_Application_Id;
1983:
1984: BEGIN

Line 1998: AK_ATTRIBUTES_PKG.INSERT_ROW (

1994:
1995:
1996: IF l_attributeCount = 0 THEN
1997: -- Insert into Attributes
1998: AK_ATTRIBUTES_PKG.INSERT_ROW (
1999: X_ROWID => l_attribute_rowid,
2000: X_ATTRIBUTE_APPLICATION_ID => p_Region_Item_Rec.Attribute_Application_Id,
2001: X_ATTRIBUTE_CODE => UPPER(p_Region_Item_Rec.Attribute_Code),
2002: X_ATTRIBUTE_LABEL_LENGTH => c_ATTR_LABEL_LENGTH,