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_OBJECT_PVT dependencies on DBMS_SQL

Line 1809: l_sql_csr := dbms_sql.open_cursor;

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:
1813: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',

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

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:
1813: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1814: p_database_object_name);

Line 1811: dbms_sql.define_column(l_sql_csr, 1, l_dummy);

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:
1813: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1814: p_database_object_name);
1815: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',

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

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:
1813: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1814: p_database_object_name);
1815: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1816: p_attribute_application_id);
1817: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);

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

1811: dbms_sql.define_column(l_sql_csr, 1, l_dummy);
1812:
1813: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1814: p_database_object_name);
1815: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1816: p_attribute_application_id);
1817: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
1818: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1819: if (l_key_value2 is not null) then

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

1813: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
1814: p_database_object_name);
1815: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1816: p_attribute_application_id);
1817: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
1818: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1819: if (l_key_value2 is not null) then
1820: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1821: end if;

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

1814: p_database_object_name);
1815: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
1816: p_attribute_application_id);
1817: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
1818: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1819: if (l_key_value2 is not null) then
1820: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1821: end if;
1822: if (l_key_value3 is not null) then

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

1816: p_attribute_application_id);
1817: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
1818: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
1819: if (l_key_value2 is not null) then
1820: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1821: end if;
1822: if (l_key_value3 is not null) then
1823: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
1824: end if;

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

1819: if (l_key_value2 is not null) then
1820: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
1821: end if;
1822: if (l_key_value3 is not null) then
1823: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
1824: end if;
1825: if (l_key_value4 is not null) then
1826: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
1827: end if;

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

1822: if (l_key_value3 is not null) then
1823: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
1824: end if;
1825: if (l_key_value4 is not null) then
1826: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
1827: end if;
1828: if (l_key_value5 is not null) then
1829: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
1830: end if;

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

1825: if (l_key_value4 is not null) then
1826: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
1827: end if;
1828: if (l_key_value5 is not null) then
1829: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
1830: end if;
1831: if (l_key_value6 is not null) then
1832: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
1833: end if;

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

1828: if (l_key_value5 is not null) then
1829: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
1830: end if;
1831: if (l_key_value6 is not null) then
1832: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
1833: end if;
1834: if (l_key_value7 is not null) then
1835: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
1836: end if;

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

1831: if (l_key_value6 is not null) then
1832: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
1833: end if;
1834: if (l_key_value7 is not null) then
1835: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
1836: end if;
1837: if (l_key_value8 is not null) then
1838: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
1839: end if;

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

1834: if (l_key_value7 is not null) then
1835: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
1836: end if;
1837: if (l_key_value8 is not null) then
1838: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
1839: end if;
1840: if (l_key_value9 is not null) then
1841: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
1842: end if;

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

1837: if (l_key_value8 is not null) then
1838: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
1839: end if;
1840: if (l_key_value9 is not null) then
1841: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
1842: end if;
1843: if (l_key_value10 is not null) then
1844: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
1845: end if;

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

1840: if (l_key_value9 is not null) then
1841: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
1842: end if;
1843: if (l_key_value10 is not null) then
1844: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
1845: end if;
1846:
1847: if (dbms_sql.execute_and_fetch(l_sql_csr) = 0) then
1848: dbms_sql.close_cursor(l_sql_csr);

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

1843: if (l_key_value10 is not null) then
1844: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
1845: end if;
1846:
1847: if (dbms_sql.execute_and_fetch(l_sql_csr) = 0) then
1848: dbms_sql.close_cursor(l_sql_csr);
1849: p_return_status := FND_API.G_RET_STS_SUCCESS;
1850: return FALSE;
1851: else

Line 1848: dbms_sql.close_cursor(l_sql_csr);

1844: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
1845: end if;
1846:
1847: if (dbms_sql.execute_and_fetch(l_sql_csr) = 0) then
1848: dbms_sql.close_cursor(l_sql_csr);
1849: p_return_status := FND_API.G_RET_STS_SUCCESS;
1850: return FALSE;
1851: else
1852: dbms_sql.close_cursor(l_sql_csr);

Line 1852: dbms_sql.close_cursor(l_sql_csr);

1848: dbms_sql.close_cursor(l_sql_csr);
1849: p_return_status := FND_API.G_RET_STS_SUCCESS;
1850: return FALSE;
1851: else
1852: dbms_sql.close_cursor(l_sql_csr);
1853: p_return_status := FND_API.G_RET_STS_SUCCESS;
1854: return TRUE;
1855: end if;
1856:

Line 2748: l_sql_csr := dbms_sql.open_cursor;

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',
2752: p_database_object_name);

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

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',
2752: p_database_object_name);
2753: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',

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

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',
2752: p_database_object_name);
2753: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
2754: p_attribute_application_id);
2755: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);

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

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',
2752: p_database_object_name);
2753: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
2754: p_attribute_application_id);
2755: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
2756: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
2757: if (l_key_value2 is not null) then

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

2751: dbms_sql.bind_variable(l_sql_csr, 'database_object_name',
2752: p_database_object_name);
2753: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
2754: p_attribute_application_id);
2755: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
2756: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
2757: if (l_key_value2 is not null) then
2758: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
2759: end if;

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

2752: p_database_object_name);
2753: dbms_sql.bind_variable(l_sql_csr, 'attribute_application_id',
2754: p_attribute_application_id);
2755: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
2756: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
2757: if (l_key_value2 is not null) then
2758: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
2759: end if;
2760: if (l_key_value3 is not null) then

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

2754: p_attribute_application_id);
2755: dbms_sql.bind_variable(l_sql_csr, 'attribute_code',p_attribute_code);
2756: dbms_sql.bind_variable(l_sql_csr, 'key_value1', p_key_value1);
2757: if (l_key_value2 is not null) then
2758: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
2759: end if;
2760: if (l_key_value3 is not null) then
2761: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
2762: end if;

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

2757: if (l_key_value2 is not null) then
2758: dbms_sql.bind_variable(l_sql_csr, 'key_value2', l_key_value2);
2759: end if;
2760: if (l_key_value3 is not null) then
2761: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
2762: end if;
2763: if (l_key_value4 is not null) then
2764: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
2765: end if;

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

2760: if (l_key_value3 is not null) then
2761: dbms_sql.bind_variable(l_sql_csr, 'key_value3', l_key_value3);
2762: end if;
2763: if (l_key_value4 is not null) then
2764: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
2765: end if;
2766: if (l_key_value5 is not null) then
2767: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
2768: end if;

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

2763: if (l_key_value4 is not null) then
2764: dbms_sql.bind_variable(l_sql_csr, 'key_value4', l_key_value4);
2765: end if;
2766: if (l_key_value5 is not null) then
2767: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
2768: end if;
2769: if (l_key_value6 is not null) then
2770: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
2771: end if;

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

2766: if (l_key_value5 is not null) then
2767: dbms_sql.bind_variable(l_sql_csr, 'key_value5', l_key_value5);
2768: end if;
2769: if (l_key_value6 is not null) then
2770: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
2771: end if;
2772: if (l_key_value7 is not null) then
2773: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
2774: end if;

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

2769: if (l_key_value6 is not null) then
2770: dbms_sql.bind_variable(l_sql_csr, 'key_value6', l_key_value6);
2771: end if;
2772: if (l_key_value7 is not null) then
2773: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
2774: end if;
2775: if (l_key_value8 is not null) then
2776: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
2777: end if;

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

2772: if (l_key_value7 is not null) then
2773: dbms_sql.bind_variable(l_sql_csr, 'key_value7', l_key_value7);
2774: end if;
2775: if (l_key_value8 is not null) then
2776: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
2777: end if;
2778: if (l_key_value9 is not null) then
2779: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
2780: end if;

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

2775: if (l_key_value8 is not null) then
2776: dbms_sql.bind_variable(l_sql_csr, 'key_value8', l_key_value8);
2777: end if;
2778: if (l_key_value9 is not null) then
2779: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
2780: end if;
2781: if (l_key_value10 is not null) then
2782: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
2783: end if;

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

2778: if (l_key_value9 is not null) then
2779: dbms_sql.bind_variable(l_sql_csr, 'key_value9', l_key_value9);
2780: end if;
2781: if (l_key_value10 is not null) then
2782: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
2783: end if;
2784:
2785: if (dbms_sql.execute(l_sql_csr) = 0) then
2786: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

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

2781: if (l_key_value10 is not null) then
2782: dbms_sql.bind_variable(l_sql_csr, 'key_value10', l_key_value10);
2783: end if;
2784:
2785: if (dbms_sql.execute(l_sql_csr) = 0) then
2786: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2787: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2788: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2789: FND_MSG_PUB.Add;

Line 2791: dbms_sql.close_cursor(l_sql_csr);

2787: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
2788: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
2789: FND_MSG_PUB.Add;
2790: end if;
2791: dbms_sql.close_cursor(l_sql_csr);
2792: raise FND_API.G_EXC_ERROR;
2793: end if;
2794:
2795: dbms_sql.close_cursor(l_sql_csr);

Line 2795: dbms_sql.close_cursor(l_sql_csr);

2791: dbms_sql.close_cursor(l_sql_csr);
2792: raise FND_API.G_EXC_ERROR;
2793: end if;
2794:
2795: dbms_sql.close_cursor(l_sql_csr);
2796: --
2797: -- Load success message
2798: --
2799: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then