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_OBJECT2_PVT dependencies on AK_ON_OBJECTS_PUB

Line 44: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

40: where DATABASE_OBJECT_NAME = p_database_object_name
41: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
42: and ATTRIBUTE_CODE = p_attribute_code;
43: l_api_name CONSTANT varchar2(30) := 'Write_Navigation_to_buffer';
44: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
45: l_index NUMBER;
46: l_navigation_rec AK_OBJECT_ATTRIBUTE_NAVIGATION%ROWTYPE;
47: l_return_status varchar2(1);
48: begin

Line 93: to_char(l_navigation_rec.value_date, AK_ON_OBJECTS_PUB.G_DATE_FORMAT)

89: l_index := l_index + 1;
90: l_databuffer_tbl(l_index) := ' BEGIN ATTRIBUTE_NAVIGATION "' ||
91: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_navigation_rec.value_varchar2)
92: || '" "' ||
93: to_char(l_navigation_rec.value_date, AK_ON_OBJECTS_PUB.G_DATE_FORMAT)
94: || '" "' ||
95: nvl(to_char(l_navigation_rec.value_number),'') || '"';
96: if ((l_navigation_rec.to_region_appl_id IS NOT NULL) and
97: (l_navigation_rec.to_region_appl_id <> FND_API.G_MISS_NUM) and

Line 227: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

223: nvl(to_char(l_navigation_rec.created_by),'') || '"';
224: l_index := l_index + 1;
225: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
226: to_char(l_navigation_rec.creation_date,
227: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
228: l_index := l_index + 1;
229: -- CHANGED TO OWNER FOR R12
230: --l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
231: --nvl(to_char(l_navigation_rec.last_updated_by),'') || '"';

Line 237: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

233: FND_LOAD_UTIL.OWNER_NAME(l_navigation_rec.last_updated_by) || '"';
234: l_index := l_index + 1;
235: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
236: to_char(l_navigation_rec.last_update_date,
237: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
238: l_index := l_index + 1;
239: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
240: nvl(to_char(l_navigation_rec.last_update_login),'') || '"';
241:

Line 258: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

254: if (l_databuffer_tbl.count > 0) then
255: AK_ON_OBJECTS_PVT.WRITE_FILE (
256: p_return_status => l_return_status,
257: p_buffer_tbl => l_databuffer_tbl,
258: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
259: );
260: -- If API call returns with an error status...
261: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
262: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 337: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

333: and ATTRIBUTE_APPLICATION_ID = attribute_appl_id_param
334: and ATTRIBUTE_CODE = attribute_code_param
335: and LANGUAGE = p_nls_language;
336: l_api_name CONSTANT varchar2(30) := 'Write_Attribute_to_buffer';
337: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
338: l_index NUMBER;
339: l_attributes_rec AK_OBJECT_ATTRIBUTES%ROWTYPE;
340: l_attributes_tl_rec AK_OBJECT_ATTRIBUTES_TL%ROWTYPE;
341: l_return_status varchar2(1);

Line 492: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

488: (l_attributes_rec.default_value_date <> FND_API.G_MISS_CHAR)) then
489: l_index := l_index + 1;
490: l_databuffer_tbl(l_index) := ' DEFAULT_VALUE_DATE = "' ||
491: to_char(l_attributes_rec.default_value_date,
492: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
493: end if;
494:
495: -- Flex Fields
496: --

Line 616: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

612: nvl(to_char(l_attributes_rec.created_by),'') || '"';
613: l_index := l_index + 1;
614: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
615: to_char(l_attributes_rec.creation_date,
616: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
617: l_index := l_index + 1;
618: -- CHANGED TO OWNER FOR R12
619: --l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
620: --nvl(to_char(l_attributes_rec.last_updated_by),'') || '"';

Line 626: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

622: FND_LOAD_UTIL.OWNER_NAME(l_attributes_rec.last_updated_by) || '"';
623: l_index := l_index + 1;
624: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
625: to_char(l_attributes_rec.last_update_date,
626: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
627: l_index := l_index + 1;
628: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
629: nvl(to_char(l_attributes_rec.last_update_login),'') || '"';
630:

Line 709: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

705: -- write object attribute data to file
706: AK_ON_OBJECTS_PVT.WRITE_FILE (
707: p_return_status => l_return_status,
708: p_buffer_tbl => l_databuffer_tbl,
709: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
710: );
711: -- If API call returns with an error status...
712: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
713: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 747: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

743: -- write object attribute ending lines to file
744: AK_ON_OBJECTS_PVT.WRITE_FILE (
745: p_return_status => l_return_status,
746: p_buffer_tbl => l_databuffer_tbl,
747: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
748: );
749: -- If API call returns with an error status...
750: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
751: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 832: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

828: select *
829: from AK_FOREIGN_KEY_COLUMNS
830: where FOREIGN_KEY_NAME = foreign_key_name_param;
831: l_api_name CONSTANT varchar2(30) := 'Write_Foreign_key_to_buffer';
832: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
833: l_index NUMBER;
834: l_foreign_keys_rec AK_FOREIGN_KEYS%ROWTYPE;
835: l_foreign_keys_tl_rec AK_FOREIGN_KEYS_TL%ROWTYPE;
836: l_key_columns_rec AK_FOREIGN_KEY_COLUMNS%ROWTYPE;

Line 1005: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1001: nvl(to_char(l_foreign_keys_rec.created_by),'') || '"';
1002: l_index := l_index + 1;
1003: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
1004: to_char(l_foreign_keys_rec.creation_date,
1005: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1006: l_index := l_index + 1;
1007: -- CHANGED TO OWNER FOR R12
1008: --l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
1009: --nvl(to_char(l_foreign_keys_rec.last_updated_by),'') || '"';

Line 1015: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1011: FND_LOAD_UTIL.OWNER_NAME(l_foreign_keys_rec.last_updated_by) || '"';
1012: l_index := l_index + 1;
1013: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
1014: to_char(l_foreign_keys_rec.last_update_date,
1015: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1016: l_index := l_index + 1;
1017: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
1018: nvl(to_char(l_foreign_keys_rec.last_update_login),'') || '"';
1019:

Line 1207: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1203: nvl(to_char(l_key_columns_rec.created_by),'') || '"';
1204: l_index := l_index + 1;
1205: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
1206: to_char(l_key_columns_rec.creation_date,
1207: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1208: l_index := l_index + 1;
1209: -- CHANGED TO OWNER FOR R12
1210: --l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
1211: --nvl(to_char(l_key_columns_rec.last_updated_by),'') || '"';

Line 1217: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1213: FND_LOAD_UTIL.OWNER_NAME(l_key_columns_rec.last_updated_by) || '"';
1214: l_index := l_index + 1;
1215: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
1216: to_char(l_key_columns_rec.last_update_date,
1217: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1218: l_index := l_index + 1;
1219: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
1220: nvl(to_char(l_key_columns_rec.last_update_login),'') || '"';
1221:

Line 1248: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

1244: if (l_databuffer_tbl.count > 0) then
1245: AK_ON_OBJECTS_PVT.WRITE_FILE (
1246: p_return_status => l_return_status,
1247: p_buffer_tbl => l_databuffer_tbl,
1248: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1249: );
1250: -- If API call returns with an error status...
1251: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1252: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 1346: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

1342: from AK_UNIQUE_KEY_COLUMNS
1343: where UNIQUE_KEY_NAME = unique_key_name_param;
1344: l_api_name CONSTANT varchar2(30) := 'write_unique_key_to_buffer';
1345: l_index NUMBER;
1346: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1347: l_unique_keys_rec AK_UNIQUE_KEYS%ROWTYPE;
1348: l_key_columns_rec AK_UNIQUE_KEY_COLUMNS%ROWTYPE;
1349: l_return_status varchar2(1);
1350: begin

Line 1505: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1501: nvl(to_char(l_unique_keys_rec.created_by),'') || '"';
1502: l_index := l_index + 1;
1503: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
1504: to_char(l_unique_keys_rec.creation_date,
1505: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1506: l_index := l_index + 1;
1507: -- CHANGED TO OWNER FOR R12
1508: --l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
1509: --nvl(to_char(l_unique_keys_rec.last_updated_by),'') || '"';

Line 1515: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1511: FND_LOAD_UTIL.OWNER_NAME(l_unique_keys_rec.last_updated_by) || '"';
1512: l_index := l_index + 1;
1513: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
1514: to_char(l_unique_keys_rec.last_update_date,
1515: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1516: l_index := l_index + 1;
1517: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
1518: nvl(to_char(l_unique_keys_rec.last_update_login),'') || '"';
1519:

Line 1680: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1676: nvl(to_char(l_key_columns_rec.created_by),'') || '"';
1677: l_index := l_index + 1;
1678: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
1679: to_char(l_key_columns_rec.creation_date,
1680: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1681: l_index := l_index + 1;
1682: -- CHANGED TO OWNER FOR R12
1683: --l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
1684: --nvl(to_char(l_key_columns_rec.last_updated_by),'') || '"';

Line 1690: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1686: FND_LOAD_UTIL.OWNER_NAME(l_key_columns_rec.last_updated_by) || '"';
1687: l_index := l_index + 1;
1688: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
1689: to_char(l_key_columns_rec.last_update_date,
1690: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1691: l_index := l_index + 1;
1692: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
1693: nvl(to_char(l_key_columns_rec.last_update_login),'') || '"';
1694:

Line 1717: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

1713: if (l_databuffer_tbl.count > 0) then
1714: AK_ON_OBJECTS_PVT.WRITE_FILE (
1715: p_return_status => l_return_status,
1716: p_buffer_tbl => l_databuffer_tbl,
1717: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1718: );
1719: -- If API call returns with an error status...
1720: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1721: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 1787: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

1783: from AK_OBJECTS_TL
1784: where database_object_name = p_database_object_name
1785: and language = p_nls_language;
1786: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
1787: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1788: l_index NUMBER;
1789: l_objects_rec AK_OBJECTS%ROWTYPE;
1790: l_objects_tl_rec AK_OBJECTS_TL%ROWTYPE;
1791: l_return_status varchar2(1);

Line 2013: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

2009: nvl(to_char(l_objects_rec.created_by),'') || '"';
2010: l_index := l_index + 1;
2011: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
2012: to_char(l_objects_rec.creation_date,
2013: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
2014: l_index := l_index + 1;
2015: -- CHANGED TO OWNER FOR R12
2016: --l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
2017: --nvl(to_char(l_objects_rec.last_updated_by),'') || '"';

Line 2023: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

2019: FND_LOAD_UTIL.OWNER_NAME(l_objects_rec.last_updated_by) || '"';
2020: l_index := l_index + 1;
2021: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
2022: to_char(l_objects_rec.last_update_date,
2023: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
2024: l_index := l_index + 1;
2025: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
2026: nvl(to_char(l_objects_rec.last_update_login),'') || '"';
2027:

Line 2048: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

2044: -- - Write object data out to the specified file
2045: AK_ON_OBJECTS_PVT.WRITE_FILE (
2046: p_return_status => l_return_status,
2047: p_buffer_tbl => l_databuffer_tbl,
2048: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
2049: );
2050: -- If API call returns with an error status...
2051: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2052: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 2099: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

2095: -- - Finish up writing object data out to the specified file
2096: AK_ON_OBJECTS_PVT.WRITE_FILE (
2097: p_return_status => l_return_status,
2098: p_buffer_tbl => l_databuffer_tbl,
2099: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
2100: );
2101:
2102: -- If API call returns with an error status...
2103: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or