eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_OBJECT3_PVT dependencies on DBMS_SQL

Line 1557: l_sql_csr := dbms_sql.open_cursor;

1553:
1554: --** retrieve ak_inst_attribute_values row if it exists **
1555: l_sql_stmt := 'select value_varchar2, value_date, value_number ' ||
1556: 'from ak_inst_attribute_values ' || l_where_clause;
1557: l_sql_csr := dbms_sql.open_cursor;
1558: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1559: dbms_sql.define_column(l_sql_csr, 1, l_value_varchar2, 240);
1560: dbms_sql.define_column(l_sql_csr, 2, l_value_date);
1561: dbms_sql.define_column(l_sql_csr, 3, l_value_number);

Line 1558: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);

1554: --** retrieve ak_inst_attribute_values row if it exists **
1555: l_sql_stmt := 'select value_varchar2, value_date, value_number ' ||
1556: 'from ak_inst_attribute_values ' || l_where_clause;
1557: l_sql_csr := dbms_sql.open_cursor;
1558: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1559: dbms_sql.define_column(l_sql_csr, 1, l_value_varchar2, 240);
1560: dbms_sql.define_column(l_sql_csr, 2, l_value_date);
1561: dbms_sql.define_column(l_sql_csr, 3, l_value_number);
1562:

Line 1559: dbms_sql.define_column(l_sql_csr, 1, l_value_varchar2, 240);

1555: l_sql_stmt := 'select value_varchar2, value_date, value_number ' ||
1556: 'from ak_inst_attribute_values ' || l_where_clause;
1557: l_sql_csr := dbms_sql.open_cursor;
1558: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1559: dbms_sql.define_column(l_sql_csr, 1, l_value_varchar2, 240);
1560: dbms_sql.define_column(l_sql_csr, 2, l_value_date);
1561: dbms_sql.define_column(l_sql_csr, 3, l_value_number);
1562:
1563: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',

Line 1560: dbms_sql.define_column(l_sql_csr, 2, l_value_date);

1556: 'from ak_inst_attribute_values ' || l_where_clause;
1557: l_sql_csr := dbms_sql.open_cursor;
1558: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1559: dbms_sql.define_column(l_sql_csr, 1, l_value_varchar2, 240);
1560: dbms_sql.define_column(l_sql_csr, 2, l_value_date);
1561: dbms_sql.define_column(l_sql_csr, 3, l_value_number);
1562:
1563: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1564: p_database_object_name);

Line 1561: dbms_sql.define_column(l_sql_csr, 3, l_value_number);

1557: l_sql_csr := dbms_sql.open_cursor;
1558: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1559: dbms_sql.define_column(l_sql_csr, 1, l_value_varchar2, 240);
1560: dbms_sql.define_column(l_sql_csr, 2, l_value_date);
1561: dbms_sql.define_column(l_sql_csr, 3, l_value_number);
1562:
1563: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1564: p_database_object_name);
1565: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',

Line 1563: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',

1559: dbms_sql.define_column(l_sql_csr, 1, l_value_varchar2, 240);
1560: dbms_sql.define_column(l_sql_csr, 2, l_value_date);
1561: dbms_sql.define_column(l_sql_csr, 3, l_value_number);
1562:
1563: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1564: p_database_object_name);
1565: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1566: p_attribute_application_id);
1567: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);

Line 1565: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',

1561: dbms_sql.define_column(l_sql_csr, 3, l_value_number);
1562:
1563: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1564: p_database_object_name);
1565: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1566: p_attribute_application_id);
1567: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
1568: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1569: if (l_key_value2 is not null) then

Line 1567: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);

1563: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1564: p_database_object_name);
1565: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1566: p_attribute_application_id);
1567: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
1568: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1569: if (l_key_value2 is not null) then
1570: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1571: end if;

Line 1568: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);

1564: p_database_object_name);
1565: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1566: p_attribute_application_id);
1567: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
1568: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1569: if (l_key_value2 is not null) then
1570: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1571: end if;
1572: if (l_key_value3 is not null) then

Line 1570: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);

1566: p_attribute_application_id);
1567: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
1568: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1569: if (l_key_value2 is not null) then
1570: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1571: end if;
1572: if (l_key_value3 is not null) then
1573: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
1574: end if;

Line 1573: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);

1569: if (l_key_value2 is not null) then
1570: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1571: end if;
1572: if (l_key_value3 is not null) then
1573: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
1574: end if;
1575: if (l_key_value4 is not null) then
1576: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
1577: end if;

Line 1576: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);

1572: if (l_key_value3 is not null) then
1573: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
1574: end if;
1575: if (l_key_value4 is not null) then
1576: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
1577: end if;
1578: if (l_key_value5 is not null) then
1579: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
1580: end if;

Line 1579: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);

1575: if (l_key_value4 is not null) then
1576: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
1577: end if;
1578: if (l_key_value5 is not null) then
1579: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
1580: end if;
1581: if (l_key_value6 is not null) then
1582: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
1583: end if;

Line 1582: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);

1578: if (l_key_value5 is not null) then
1579: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
1580: end if;
1581: if (l_key_value6 is not null) then
1582: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
1583: end if;
1584: if (l_key_value7 is not null) then
1585: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
1586: end if;

Line 1585: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);

1581: if (l_key_value6 is not null) then
1582: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
1583: end if;
1584: if (l_key_value7 is not null) then
1585: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
1586: end if;
1587: if (l_key_value8 is not null) then
1588: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
1589: end if;

Line 1588: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);

1584: if (l_key_value7 is not null) then
1585: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
1586: end if;
1587: if (l_key_value8 is not null) then
1588: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
1589: end if;
1590: if (l_key_value9 is not null) then
1591: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
1592: end if;

Line 1591: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);

1587: if (l_key_value8 is not null) then
1588: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
1589: end if;
1590: if (l_key_value9 is not null) then
1591: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
1592: end if;
1593: if (l_key_value10 is not null) then
1594: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
1595: end if;

Line 1594: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);

1590: if (l_key_value9 is not null) then
1591: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
1592: end if;
1593: if (l_key_value10 is not null) then
1594: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
1595: end if;
1596:
1597: if (dbms_sql.execute_and_fetch(l_sql_csr) = 0) then
1598: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 1597: if (dbms_sql.execute_and_fetch(l_sql_csr) = 0) then

1593: if (l_key_value10 is not null) then
1594: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
1595: end if;
1596:
1597: if (dbms_sql.execute_and_fetch(l_sql_csr) = 0) then
1598: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1599: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
1600: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1601: FND_MSG_PUB.Add;

Line 1605: dbms_sql.close_cursor(l_sql_csr);

1601: FND_MSG_PUB.Add;
1602: end if;
1603: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
1604: --close l_get_row_csr;
1605: dbms_sql.close_cursor(l_sql_csr);
1606: raise FND_API.G_EXC_ERROR;
1607: end if;
1608: dbms_sql.close_cursor(l_sql_csr);
1609:

Line 1608: dbms_sql.close_cursor(l_sql_csr);

1604: --close l_get_row_csr;
1605: dbms_sql.close_cursor(l_sql_csr);
1606: raise FND_API.G_EXC_ERROR;
1607: end if;
1608: dbms_sql.close_cursor(l_sql_csr);
1609:
1610: --** validate table columns passed in **
1611: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
1612: if not ak_object_pvt.validate_attribute_value (

Line 1680: l_sql_csr := dbms_sql.open_cursor;

1676: 'LAST_UPDATE_DATE = :last_update_date, ' ||
1677: 'LAST_UPDATED_BY = :last_updated_by, ' ||
1678: 'LAST_UPDATE_LOGIN = :last_update_login ' ||
1679: l_where_clause;
1680: l_sql_csr := dbms_sql.open_cursor;
1681: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1682:
1683: dbms_sql.bind_variable(l_sql_csr, 'value_varchar2', l_value_varchar2);
1684: dbms_sql.bind_variable(l_sql_csr, 'value_date', l_value_date);

Line 1681: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);

1677: 'LAST_UPDATED_BY = :last_updated_by, ' ||
1678: 'LAST_UPDATE_LOGIN = :last_update_login ' ||
1679: l_where_clause;
1680: l_sql_csr := dbms_sql.open_cursor;
1681: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1682:
1683: dbms_sql.bind_variable(l_sql_csr, 'value_varchar2', l_value_varchar2);
1684: dbms_sql.bind_variable(l_sql_csr, 'value_date', l_value_date);
1685: dbms_sql.bind_variable(l_sql_csr, 'value_number', l_value_number);

Line 1683: dbms_sql.bind_variable(l_sql_csr, 'value_varchar2', l_value_varchar2);

1679: l_where_clause;
1680: l_sql_csr := dbms_sql.open_cursor;
1681: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1682:
1683: dbms_sql.bind_variable(l_sql_csr, 'value_varchar2', l_value_varchar2);
1684: dbms_sql.bind_variable(l_sql_csr, 'value_date', l_value_date);
1685: dbms_sql.bind_variable(l_sql_csr, 'value_number', l_value_number);
1686: dbms_sql.bind_variable(l_sql_csr, 'last_update_date', l_last_update_date);
1687: dbms_sql.bind_variable(l_sql_csr, 'last_updated_by', l_last_updated_by);

Line 1684: dbms_sql.bind_variable(l_sql_csr, 'value_date', l_value_date);

1680: l_sql_csr := dbms_sql.open_cursor;
1681: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1682:
1683: dbms_sql.bind_variable(l_sql_csr, 'value_varchar2', l_value_varchar2);
1684: dbms_sql.bind_variable(l_sql_csr, 'value_date', l_value_date);
1685: dbms_sql.bind_variable(l_sql_csr, 'value_number', l_value_number);
1686: dbms_sql.bind_variable(l_sql_csr, 'last_update_date', l_last_update_date);
1687: dbms_sql.bind_variable(l_sql_csr, 'last_updated_by', l_last_updated_by);
1688: dbms_sql.bind_variable(l_sql_csr, 'last_update_login', l_last_update_login);

Line 1685: dbms_sql.bind_variable(l_sql_csr, 'value_number', l_value_number);

1681: dbms_sql.parse(l_sql_csr, l_sql_stmt, DBMS_SQL.V7);
1682:
1683: dbms_sql.bind_variable(l_sql_csr, 'value_varchar2', l_value_varchar2);
1684: dbms_sql.bind_variable(l_sql_csr, 'value_date', l_value_date);
1685: dbms_sql.bind_variable(l_sql_csr, 'value_number', l_value_number);
1686: dbms_sql.bind_variable(l_sql_csr, 'last_update_date', l_last_update_date);
1687: dbms_sql.bind_variable(l_sql_csr, 'last_updated_by', l_last_updated_by);
1688: dbms_sql.bind_variable(l_sql_csr, 'last_update_login', l_last_update_login);
1689: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',

Line 1686: dbms_sql.bind_variable(l_sql_csr, 'last_update_date', l_last_update_date);

1682:
1683: dbms_sql.bind_variable(l_sql_csr, 'value_varchar2', l_value_varchar2);
1684: dbms_sql.bind_variable(l_sql_csr, 'value_date', l_value_date);
1685: dbms_sql.bind_variable(l_sql_csr, 'value_number', l_value_number);
1686: dbms_sql.bind_variable(l_sql_csr, 'last_update_date', l_last_update_date);
1687: dbms_sql.bind_variable(l_sql_csr, 'last_updated_by', l_last_updated_by);
1688: dbms_sql.bind_variable(l_sql_csr, 'last_update_login', l_last_update_login);
1689: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1690: p_database_object_name);

Line 1687: dbms_sql.bind_variable(l_sql_csr, 'last_updated_by', l_last_updated_by);

1683: dbms_sql.bind_variable(l_sql_csr, 'value_varchar2', l_value_varchar2);
1684: dbms_sql.bind_variable(l_sql_csr, 'value_date', l_value_date);
1685: dbms_sql.bind_variable(l_sql_csr, 'value_number', l_value_number);
1686: dbms_sql.bind_variable(l_sql_csr, 'last_update_date', l_last_update_date);
1687: dbms_sql.bind_variable(l_sql_csr, 'last_updated_by', l_last_updated_by);
1688: dbms_sql.bind_variable(l_sql_csr, 'last_update_login', l_last_update_login);
1689: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1690: p_database_object_name);
1691: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',

Line 1688: dbms_sql.bind_variable(l_sql_csr, 'last_update_login', l_last_update_login);

1684: dbms_sql.bind_variable(l_sql_csr, 'value_date', l_value_date);
1685: dbms_sql.bind_variable(l_sql_csr, 'value_number', l_value_number);
1686: dbms_sql.bind_variable(l_sql_csr, 'last_update_date', l_last_update_date);
1687: dbms_sql.bind_variable(l_sql_csr, 'last_updated_by', l_last_updated_by);
1688: dbms_sql.bind_variable(l_sql_csr, 'last_update_login', l_last_update_login);
1689: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1690: p_database_object_name);
1691: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1692: p_attribute_application_id);

Line 1689: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',

1685: dbms_sql.bind_variable(l_sql_csr, 'value_number', l_value_number);
1686: dbms_sql.bind_variable(l_sql_csr, 'last_update_date', l_last_update_date);
1687: dbms_sql.bind_variable(l_sql_csr, 'last_updated_by', l_last_updated_by);
1688: dbms_sql.bind_variable(l_sql_csr, 'last_update_login', l_last_update_login);
1689: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1690: p_database_object_name);
1691: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1692: p_attribute_application_id);
1693: dbms_sql.bind_variable(l_sql_csr, 'attribute_code', p_attribute_code);

Line 1691: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',

1687: dbms_sql.bind_variable(l_sql_csr, 'last_updated_by', l_last_updated_by);
1688: dbms_sql.bind_variable(l_sql_csr, 'last_update_login', l_last_update_login);
1689: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1690: p_database_object_name);
1691: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1692: p_attribute_application_id);
1693: dbms_sql.bind_variable(l_sql_csr, 'attribute_code', p_attribute_code);
1694: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1695: if (l_key_value2 is not null) then

Line 1693: dbms_sql.bind_variable(l_sql_csr, 'attribute_code', p_attribute_code);

1689: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1690: p_database_object_name);
1691: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1692: p_attribute_application_id);
1693: dbms_sql.bind_variable(l_sql_csr, 'attribute_code', p_attribute_code);
1694: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1695: if (l_key_value2 is not null) then
1696: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1697: end if;

Line 1694: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);

1690: p_database_object_name);
1691: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1692: p_attribute_application_id);
1693: dbms_sql.bind_variable(l_sql_csr, 'attribute_code', p_attribute_code);
1694: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1695: if (l_key_value2 is not null) then
1696: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1697: end if;
1698: if (l_key_value3 is not null) then

Line 1696: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);

1692: p_attribute_application_id);
1693: dbms_sql.bind_variable(l_sql_csr, 'attribute_code', p_attribute_code);
1694: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1695: if (l_key_value2 is not null) then
1696: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1697: end if;
1698: if (l_key_value3 is not null) then
1699: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
1700: end if;

Line 1699: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);

1695: if (l_key_value2 is not null) then
1696: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1697: end if;
1698: if (l_key_value3 is not null) then
1699: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
1700: end if;
1701: if (l_key_value4 is not null) then
1702: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
1703: end if;

Line 1702: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);

1698: if (l_key_value3 is not null) then
1699: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
1700: end if;
1701: if (l_key_value4 is not null) then
1702: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
1703: end if;
1704: if (l_key_value5 is not null) then
1705: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
1706: end if;

Line 1705: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);

1701: if (l_key_value4 is not null) then
1702: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
1703: end if;
1704: if (l_key_value5 is not null) then
1705: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
1706: end if;
1707: if (l_key_value6 is not null) then
1708: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
1709: end if;

Line 1708: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);

1704: if (l_key_value5 is not null) then
1705: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
1706: end if;
1707: if (l_key_value6 is not null) then
1708: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
1709: end if;
1710: if (l_key_value7 is not null) then
1711: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
1712: end if;

Line 1711: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);

1707: if (l_key_value6 is not null) then
1708: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
1709: end if;
1710: if (l_key_value7 is not null) then
1711: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
1712: end if;
1713: if (l_key_value8 is not null) then
1714: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
1715: end if;

Line 1714: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);

1710: if (l_key_value7 is not null) then
1711: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
1712: end if;
1713: if (l_key_value8 is not null) then
1714: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
1715: end if;
1716: if (l_key_value9 is not null) then
1717: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
1718: end if;

Line 1717: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);

1713: if (l_key_value8 is not null) then
1714: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
1715: end if;
1716: if (l_key_value9 is not null) then
1717: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
1718: end if;
1719: if (l_key_value10 is not null) then
1720: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
1721: end if;

Line 1720: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);

1716: if (l_key_value9 is not null) then
1717: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
1718: end if;
1719: if (l_key_value10 is not null) then
1720: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
1721: end if;
1722:
1723: if (dbms_sql.execute(l_sql_csr) = 0) then
1724: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1723: if (dbms_sql.execute(l_sql_csr) = 0) then

1719: if (l_key_value10 is not null) then
1720: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
1721: end if;
1722:
1723: if (dbms_sql.execute(l_sql_csr) = 0) then
1724: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1725: FND_MESSAGE.SET_NAME('AK','AK_UPDATE_FAILED');
1726: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1727: FND_MSG_PUB.Add;

Line 1730: dbms_sql.close_cursor(l_sql_csr);

1726: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1727: FND_MSG_PUB.Add;
1728: end if;
1729: --dbms_output.put_line('Row does not exist during update');
1730: dbms_sql.close_cursor(l_sql_csr);
1731: raise FND_API.G_EXC_ERROR;
1732: end if;
1733: dbms_sql.close_cursor(l_sql_csr);
1734:

Line 1733: dbms_sql.close_cursor(l_sql_csr);

1729: --dbms_output.put_line('Row does not exist during update');
1730: dbms_sql.close_cursor(l_sql_csr);
1731: raise FND_API.G_EXC_ERROR;
1732: end if;
1733: dbms_sql.close_cursor(l_sql_csr);
1734:
1735: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1736: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATED');
1737: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);