APPS.AK_OBJECT_PVT dependencies on AK_INST_ATTRIBUTE_VALUES

Line 1808: 'from ak_inst_attribute_values ' || l_where_clause;

1804: --
1805: -- check to see if row already exists
1806: --
1807: l_sql_stmt := 'select 1 ' ||
1808: 'from ak_inst_attribute_values ' || l_where_clause;
1809: l_sql_csr := dbms_sql.open_cursor;
1810: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1811: dbms_sql.define_column(l_sql_csr, 1, l_dummy);
1812:

Line 1979: from AK_INST_ATTRIBUTE_VALUES

1975: ) is
1976: cursor l_get_attr_values_csr is
1977: select key_value1, key_value2, key_value3, key_value4, key_value5,
1978: key_value6, key_value7, key_value8, key_value9, key_value10
1979: from AK_INST_ATTRIBUTE_VALUES
1980: where database_object_name = p_database_object_name
1981: and attribute_application_id = p_attribute_application_id
1982: and attribute_code = p_attribute_code;
1983: cursor l_get_navigations_csr is

Line 2086: -- AK_INST_ATTRIBUTE_VALUES

2082: raise FND_API.G_EXC_ERROR;
2083: end if;
2084: close l_get_navigations_csr;
2085: --
2086: -- AK_INST_ATTRIBUTE_VALUES
2087: --
2088: open l_get_attr_values_csr;
2089: fetch l_get_attr_values_csr into
2090: l_key_value1, l_key_value2, l_key_value3, l_key_value4, l_key_value5,

Line 2169: -- AK_INST_ATTRIBUTE_VALUES

2165: end if;
2166: end loop;
2167: close l_get_navigations_csr;
2168: --
2169: -- AK_INST_ATTRIBUTE_VALUES
2170: --
2171: open l_get_attr_values_csr;
2172: loop
2173: fetch l_get_attr_values_csr into

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

2743: else
2744: l_where_clause := l_where_clause || 'and key_value10 = :key_value10 ';
2745: end if;
2746:
2747: l_sql_stmt := 'delete from ak_inst_attribute_values ' || l_where_clause;
2748: l_sql_csr := dbms_sql.open_cursor;
2749: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
2750:
2751: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',

Line 4931: insert into AK_INST_ATTRIBUTE_VALUES (

4927: p_create_or_update => 'CREATE') then
4928: null;
4929: end if;
4930:
4931: insert into AK_INST_ATTRIBUTE_VALUES (
4932: DATABASE_OBJECT_NAME,
4933: ATTRIBUTE_APPLICATION_ID,
4934: ATTRIBUTE_CODE,
4935: KEY_VALUE1,