APPS.AK_OBJECT_PVT dependencies on AK_INST_ATTRIBUTE_VALUES

Line 1801: 'from ak_inst_attribute_values ' || l_where_clause;

1797: --
1798: -- check to see if row already exists
1799: --
1800: l_sql_stmt := 'select 1 ' ||
1801: 'from ak_inst_attribute_values ' || l_where_clause;
1802: l_sql_csr := dbms_sql.open_cursor;
1803: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1804: dbms_sql.define_column(l_sql_csr, 1, l_dummy);
1805:

Line 1972: from AK_INST_ATTRIBUTE_VALUES

1968: ) is
1969: cursor l_get_attr_values_csr is
1970: select key_value1, key_value2, key_value3, key_value4, key_value5,
1971: key_value6, key_value7, key_value8, key_value9, key_value10
1972: from AK_INST_ATTRIBUTE_VALUES
1973: where database_object_name = p_database_object_name
1974: and attribute_application_id = p_attribute_application_id
1975: and attribute_code = p_attribute_code;
1976: cursor l_get_navigations_csr is

Line 2079: -- AK_INST_ATTRIBUTE_VALUES

2075: raise FND_API.G_EXC_ERROR;
2076: end if;
2077: close l_get_navigations_csr;
2078: --
2079: -- AK_INST_ATTRIBUTE_VALUES
2080: --
2081: open l_get_attr_values_csr;
2082: fetch l_get_attr_values_csr into
2083: l_key_value1, l_key_value2, l_key_value3, l_key_value4, l_key_value5,

Line 2162: -- AK_INST_ATTRIBUTE_VALUES

2158: end if;
2159: end loop;
2160: close l_get_navigations_csr;
2161: --
2162: -- AK_INST_ATTRIBUTE_VALUES
2163: --
2164: open l_get_attr_values_csr;
2165: loop
2166: fetch l_get_attr_values_csr into

Line 2740: l_sql_stmt := 'delete from ak_inst_attribute_values ' || l_where_clause;

2736: else
2737: l_where_clause := l_where_clause || 'and key_value10 = :key_value10 ';
2738: end if;
2739:
2740: l_sql_stmt := 'delete from ak_inst_attribute_values ' || l_where_clause;
2741: l_sql_csr := dbms_sql.open_cursor;
2742: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
2743:
2744: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',

Line 4924: insert into AK_INST_ATTRIBUTE_VALUES (

4920: p_create_or_update => 'CREATE') then
4921: null;
4922: end if;
4923:
4924: insert into AK_INST_ATTRIBUTE_VALUES (
4925: DATABASE_OBJECT_NAME,
4926: ATTRIBUTE_APPLICATION_ID,
4927: ATTRIBUTE_CODE,
4928: KEY_VALUE1,