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_ATTRIBUTE_PVT dependencies on AK_ATTRIBUTES

Line 345: from AK_ATTRIBUTES

341: p_attribute_code IN VARCHAR2
342: ) return BOOLEAN is
343: cursor l_check_csr is
344: select 1
345: from AK_ATTRIBUTES
346: where attribute_application_id = p_attribute_application_id
347: and attribute_code = p_attribute_code;
348: l_api_version_number CONSTANT number := 1.0;
349: l_api_name CONSTANT varchar2(30) := 'Attribute_Exists';

Line 826: insert into AK_ATTRIBUTES (

822:
823: select userenv('LANG') into l_lang
824: from dual;
825:
826: insert into AK_ATTRIBUTES (
827: ATTRIBUTE_APPLICATION_ID,
828: ATTRIBUTE_CODE,
829: ATTRIBUTE_LABEL_LENGTH,
830: ATTRIBUTE_VALUE_LENGTH,

Line 938: insert into AK_ATTRIBUTES_TL (

934: end if;
935: raise FND_API.G_EXC_ERROR;
936: end if;
937:
938: insert into AK_ATTRIBUTES_TL (
939: ATTRIBUTE_APPLICATION_ID,
940: ATTRIBUTE_CODE,
941: LANGUAGE,
942: NAME,

Line 970: from AK_ATTRIBUTES_TL T

966: from FND_LANGUAGES L
967: where L.INSTALLED_FLAG in ('I', 'B')
968: and not exists
969: (select NULL
970: from AK_ATTRIBUTES_TL T
971: where T.ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
972: and T.ATTRIBUTE_CODE = p_attribute_code
973: and T.LANGUAGE = L.LANGUAGE_CODE);
974:

Line 1279: delete from ak_attributes

1275: --
1276: -- delete attribute once we checked that there are no references
1277: -- to this attribute, or all references have been deleted.
1278: --
1279: delete from ak_attributes
1280: where attribute_application_id = p_attribute_application_id
1281: and attribute_code = p_attribute_code;
1282:
1283: if (sql%notfound) then

Line 1291: delete from ak_attributes_tl

1287: end if;
1288: raise FND_API.G_EXC_ERROR;
1289: end if;
1290:
1291: delete from ak_attributes_tl
1292: where attribute_application_id = p_attribute_application_id
1293: and attribute_code = p_attribute_code;
1294:
1295: if (sql%notfound) then

Line 1363: p_attributes_rec IN ak_attributes%ROWTYPE,

1359: --=======================================================
1360: procedure WRITE_TO_BUFFER (
1361: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1362: p_return_status OUT NOCOPY VARCHAR2,
1363: p_attributes_rec IN ak_attributes%ROWTYPE,
1364: p_attributes_tl_rec IN ak_attributes_tl%ROWTYPE
1365: ) is
1366: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
1367: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

Line 1364: p_attributes_tl_rec IN ak_attributes_tl%ROWTYPE

1360: procedure WRITE_TO_BUFFER (
1361: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1362: p_return_status OUT NOCOPY VARCHAR2,
1363: p_attributes_rec IN ak_attributes%ROWTYPE,
1364: p_attributes_tl_rec IN ak_attributes_tl%ROWTYPE
1365: ) is
1366: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
1367: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1368: l_index NUMBER;

Line 1838: from AK_ATTRIBUTES

1834: p_nls_language IN VARCHAR2
1835: ) is
1836: cursor l_get_attribute_1_csr (appl_id_parm number) is
1837: select *
1838: from AK_ATTRIBUTES
1839: where ATTRIBUTE_APPLICATION_ID = appl_id_parm;
1840: cursor l_get_attribute_2_csr (appl_id_parm number,
1841: attr_code_parm varchar2) is
1842: select *

Line 1843: from AK_ATTRIBUTES

1839: where ATTRIBUTE_APPLICATION_ID = appl_id_parm;
1840: cursor l_get_attribute_2_csr (appl_id_parm number,
1841: attr_code_parm varchar2) is
1842: select *
1843: from AK_ATTRIBUTES
1844: where ATTRIBUTE_APPLICATION_ID = appl_id_parm
1845: and ATTRIBUTE_CODE = attr_code_parm;
1846: cursor l_get_attribute_2p_csr (appl_id_parm number,
1847: attr_code_parm varchar2) is

Line 1849: from AK_ATTRIBUTES

1845: and ATTRIBUTE_CODE = attr_code_parm;
1846: cursor l_get_attribute_2p_csr (appl_id_parm number,
1847: attr_code_parm varchar2) is
1848: select *
1849: from AK_ATTRIBUTES
1850: where ATTRIBUTE_APPLICATION_ID = appl_id_parm
1851: and ATTRIBUTE_CODE like attr_code_parm;
1852: cursor l_get_tl_csr (appl_id_parm number,
1853: attr_code_parm varchar2,

Line 1856: from AK_ATTRIBUTES_TL

1852: cursor l_get_tl_csr (appl_id_parm number,
1853: attr_code_parm varchar2,
1854: lang_parm varchar2) is
1855: select *
1856: from AK_ATTRIBUTES_TL
1857: where ATTRIBUTE_APPLICATION_ID = appl_id_parm
1858: and ATTRIBUTE_CODE = attr_code_parm
1859: and LANGUAGE = lang_parm;
1860: cursor l_get_tlp_csr (appl_id_parm number,

Line 1864: from AK_ATTRIBUTES_TL

1860: cursor l_get_tlp_csr (appl_id_parm number,
1861: attr_code_parm varchar2,
1862: lang_parm varchar2) is
1863: select *
1864: from AK_ATTRIBUTES_TL
1865: where ATTRIBUTE_APPLICATION_ID = appl_id_parm
1866: and ATTRIBUTE_CODE like attr_code_parm
1867: and LANGUAGE = lang_parm;
1868: cursor l_percent_check (attr_code_parm varchar2) is

Line 1877: l_attributes_rec ak_attributes%ROWTYPE;

1873: l_api_name CONSTANT varchar2(30) := 'Download';
1874: l_attribute_found BOOLEAN;
1875: i number;
1876: l_attribute_appl_id NUMBER;
1877: l_attributes_rec ak_attributes%ROWTYPE;
1878: l_attributes_tl_rec ak_attributes_tl%ROWTYPE;
1879: l_return_status varchar2(1);
1880: l_select_by_appl_id BOOLEAN;
1881: l_percent NUMBER;

Line 1878: l_attributes_tl_rec ak_attributes_tl%ROWTYPE;

1874: l_attribute_found BOOLEAN;
1875: i number;
1876: l_attribute_appl_id NUMBER;
1877: l_attributes_rec ak_attributes%ROWTYPE;
1878: l_attributes_tl_rec ak_attributes_tl%ROWTYPE;
1879: l_return_status varchar2(1);
1880: l_select_by_appl_id BOOLEAN;
1881: l_percent NUMBER;
1882: begin

Line 1940: -- Retrieve attributes from AK_ATTRIBUTES that fits the selection

1936: l_select_by_appl_id := FALSE;
1937: end if;
1938:
1939: --
1940: -- Retrieve attributes from AK_ATTRIBUTES that fits the selection
1941: -- criteria, one at a time, and write it the buffer table
1942: --
1943: if (l_select_by_appl_id) then
1944: --

Line 2152: l_attribute_rec ak_attributes%ROWTYPE;

2148: p_pass IN NUMBER := 1
2149: ) is
2150: l_api_version_number CONSTANT number := 1.0;
2151: l_api_name CONSTANT varchar2(30) := 'Upload_Attribute';
2152: l_attribute_rec ak_attributes%ROWTYPE;
2153: l_attribute_tl_rec AK_ATTRIBUTE_PUB.Attribute_Tl_Rec_Type;
2154: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
2155: l_column varchar2(30);
2156: l_dummy NUMBER;

Line 2157: l_empty_attribute_rec ak_attributes%ROWTYPE;

2153: l_attribute_tl_rec AK_ATTRIBUTE_PUB.Attribute_Tl_Rec_Type;
2154: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
2155: l_column varchar2(30);
2156: l_dummy NUMBER;
2157: l_empty_attribute_rec ak_attributes%ROWTYPE;
2158: l_empty_attribute_tl_rec AK_ATTRIBUTE_PUB.Attribute_Tl_Rec_Type;
2159: l_eof_flag VARCHAR2(1);
2160: l_line_num NUMBER;
2161: l_lines_read NUMBER;

Line 2616: from ak_attributes aa, ak_attributes_tl aat

2612: if (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
2613: select aa.last_updated_by, aat.last_updated_by,
2614: aa.last_update_date, aat.last_update_date
2615: into l_user_id1, l_user_id2, l_update1, l_update2
2616: from ak_attributes aa, ak_attributes_tl aat
2617: where aa.attribute_code = l_attribute_rec.attribute_code
2618: and aa.attribute_application_id = l_attribute_rec.attribute_application_id
2619: and aa.attribute_code = aat.attribute_code
2620: and aa.attribute_application_id = aat.attribute_application_id

Line 3121: from AK_ATTRIBUTES

3117: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
3118: ) is
3119: cursor l_get_row_csr is
3120: select *
3121: from AK_ATTRIBUTES
3122: where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
3123: and ATTRIBUTE_CODE = p_attribute_code
3124: for update of ATTRIBUTE_APPLICATION_ID;
3125: cursor l_get_tl_row_csr (lang_parm varchar2) is

Line 3127: from AK_ATTRIBUTES_TL

3123: and ATTRIBUTE_CODE = p_attribute_code
3124: for update of ATTRIBUTE_APPLICATION_ID;
3125: cursor l_get_tl_row_csr (lang_parm varchar2) is
3126: select *
3127: from AK_ATTRIBUTES_TL
3128: where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
3129: and ATTRIBUTE_CODE = p_attribute_code
3130: and LANGUAGE = lang_parm
3131: for update of ATTRIBUTE_APPLICATION_ID;

Line 3149: l_attributes_rec ak_attributes%ROWTYPE;

3145: where ri.to_url_attribute_appl_id = p_attribute_application_id
3146: and ri.to_url_attribute_code = p_attribute_code;
3147: l_api_version_number CONSTANT number := 1.0;
3148: l_api_name CONSTANT varchar2(30) := 'Update_Attribute';
3149: l_attributes_rec ak_attributes%ROWTYPE;
3150: l_attributes_tl_rec ak_attributes_tl%ROWTYPE;
3151: l_created_by number;
3152: l_creation_date date;
3153: l_dummy number;

Line 3150: l_attributes_tl_rec ak_attributes_tl%ROWTYPE;

3146: and ri.to_url_attribute_code = p_attribute_code;
3147: l_api_version_number CONSTANT number := 1.0;
3148: l_api_name CONSTANT varchar2(30) := 'Update_Attribute';
3149: l_attributes_rec ak_attributes%ROWTYPE;
3150: l_attributes_tl_rec ak_attributes_tl%ROWTYPE;
3151: l_created_by number;
3152: l_creation_date date;
3153: l_dummy number;
3154: l_error boolean;

Line 3182: -- retrieve ak_attributes row if it exists

3178: select userenv('LANG') into l_lang
3179: from dual;
3180:
3181: --
3182: -- retrieve ak_attributes row if it exists
3183: --
3184: open l_get_row_csr;
3185: fetch l_get_row_csr into l_attributes_rec;
3186: if (l_get_row_csr%notfound) then

Line 3197: -- retrieve ak_attributes_tl row if it exists

3193: end if;
3194: close l_get_row_csr;
3195:
3196: --
3197: -- retrieve ak_attributes_tl row if it exists
3198: --
3199: open l_get_tl_row_csr(l_lang);
3200: fetch l_get_tl_row_csr into l_attributes_tl_rec;
3201: if (l_get_tl_row_csr%notfound) then

Line 3516: update AK_ATTRIBUTES set

3512: p_db_last_update_date => l_attributes_rec.last_update_date,
3513: p_last_update_login => l_last_update_login,
3514: p_create_or_update => 'UPDATE') then
3515:
3516: update AK_ATTRIBUTES set
3517: ATTRIBUTE_LABEL_LENGTH = l_attributes_rec.attribute_label_length,
3518: ATTRIBUTE_VALUE_LENGTH = l_attributes_rec.attribute_value_length,
3519: BOLD = l_attributes_rec.bold,
3520: ITALIC = l_attributes_rec.italic,

Line 3569: update AK_ATTRIBUTES_TL set

3565: end if;
3566: raise FND_API.G_EXC_ERROR;
3567: end if;
3568:
3569: update AK_ATTRIBUTES_TL set
3570: NAME = l_attributes_tl_rec.name,
3571: ATTRIBUTE_LABEL_LONG = l_attributes_tl_rec.attribute_label_long,
3572: ATTRIBUTE_LABEL_SHORT = l_attributes_tl_rec.attribute_label_short,
3573: DESCRIPTION = l_attributes_tl_rec.description,