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

Line 661: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

657: p_return_status OUT NOCOPY VARCHAR2,
658: p_resp_sec_attr_rec IN ak_resp_security_attributes%ROWTYPE
659: ) is
660: l_api_name CONSTANT varchar2(30) := 'Write_Resp_Sec_Attr_to_buffer';
661: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
662: l_index NUMBER;
663: l_return_status varchar2(1);
664: begin
665: --

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

703: nvl(to_char(p_resp_sec_attr_rec.created_by),'""');
704: l_index := l_index + 1;
705: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
706: to_char(p_resp_sec_attr_rec.creation_date,
707: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
708: l_index := l_index + 1;
709: -- CHANGED TO OWNER FOR R12
710: --l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = ' ||
711: --nvl(to_char(p_resp_sec_attr_rec.last_updated_by),'""');

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

713: FND_LOAD_UTIL.OWNER_NAME(p_resp_sec_attr_rec.last_updated_by) || '"';
714: l_index := l_index + 1;
715: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
716: to_char(p_resp_sec_attr_rec.last_update_date,
717: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
718: l_index := l_index + 1;
719: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = ' ||
720: nvl(to_char(p_resp_sec_attr_rec.last_update_login),'""');
721:

Line 733: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

729: --
730: AK_ON_OBJECTS_PVT.WRITE_FILE (
731: p_return_status => l_return_status,
732: p_buffer_tbl => l_databuffer_tbl,
733: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
734: );
735:
736: --
737: -- If API call returns with an error status...

Line 801: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

797: p_return_status OUT NOCOPY VARCHAR2,
798: p_excluded_rec IN ak_excluded_items%ROWTYPE
799: ) is
800: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
801: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
802: l_index NUMBER;
803: l_lov_object VARCHAR2(30);
804: l_return_status varchar2(1);
805: begin

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

843: nvl(to_char(p_excluded_rec.created_by),'""');
844: l_index := l_index + 1;
845: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
846: to_char(p_excluded_rec.creation_date,
847: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
848: l_index := l_index + 1;
849: -- CHANGED TO OWNER FOR R12
850: --l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = ' ||
851: --nvl(to_char(p_excluded_rec.last_updated_by),'""');

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

853: FND_LOAD_UTIL.OWNER_NAME(p_excluded_rec.last_updated_by) || '"';
854: l_index := l_index + 1;
855: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
856: to_char(p_excluded_rec.last_update_date,
857: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
858: l_index := l_index + 1;
859: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = ' ||
860: nvl(to_char(p_excluded_rec.last_update_login),'""');
861:

Line 873: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

869: --
870: AK_ON_OBJECTS_PVT.WRITE_FILE (
871: p_return_status => l_return_status,
872: p_buffer_tbl => l_databuffer_tbl,
873: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
874: );
875:
876: --
877: -- If API call returns with an error status...

Line 1482: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,

1478: p_return_status OUT NOCOPY VARCHAR2,
1479: p_index IN OUT NOCOPY NUMBER,
1480: p_loader_timestamp IN DATE,
1481: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1482: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1483: p_line_num_out OUT NOCOPY NUMBER,
1484: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1485: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp
1486: ) is

Line 1484: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,

1480: p_loader_timestamp IN DATE,
1481: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1482: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1483: p_line_num_out OUT NOCOPY NUMBER,
1484: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1485: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp
1486: ) is
1487: l_api_version_number CONSTANT number := 1.0;
1488: l_api_name CONSTANT varchar2(30) := 'Upload_Security';

Line 1485: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp

1481: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1482: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1483: p_line_num_out OUT NOCOPY NUMBER,
1484: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1485: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp
1486: ) is
1487: l_api_version_number CONSTANT number := 1.0;
1488: l_api_name CONSTANT varchar2(30) := 'Upload_Security';
1489: l_excluded_items_rec ak_excluded_items%ROWTYPE;

Line 1491: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

1487: l_api_version_number CONSTANT number := 1.0;
1488: l_api_name CONSTANT varchar2(30) := 'Upload_Security';
1489: l_excluded_items_rec ak_excluded_items%ROWTYPE;
1490: l_resp_sec_attr_rec ak_resp_security_attributes%ROWTYPE;
1491: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
1492: l_column varchar2(30);
1493: l_dummy NUMBER;
1494: l_empty_excluded_items_rec ak_excluded_items%ROWTYPE;
1495: l_empty_resp_sec_attr_rec ak_resp_security_attributes%ROWTYPE;

Line 1503: l_saved_token AK_ON_OBJECTS_PUB.Buffer_type;

1499: l_msg_count NUMBER;
1500: l_msg_data VARCHAR2(2000);
1501: l_more_item BOOLEAN := TRUE;
1502: l_return_status varchar2(1);
1503: l_saved_token AK_ON_OBJECTS_PUB.Buffer_type;
1504: l_state NUMBER; /* parse state */
1505: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
1506: l_value_count NUMBER; /* # of values read for current column */
1507: begin

Line 1505: l_token AK_ON_OBJECTS_PUB.Buffer_Type;

1501: l_more_item BOOLEAN := TRUE;
1502: l_return_status varchar2(1);
1503: l_saved_token AK_ON_OBJECTS_PUB.Buffer_type;
1504: l_state NUMBER; /* parse state */
1505: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
1506: l_value_count NUMBER; /* # of values read for current column */
1507: begin
1508: IF NOT FND_API.Compatible_API_Call (
1509: l_api_version_number, p_api_version_number, l_api_name,

Line 1717: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or

1713: --
1714: if (l_value_count = 2) then
1715: l_saved_token := l_token;
1716: end if;
1717: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1718: (l_value_count is null) then
1719: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1720: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1721: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 1754: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1750: l_excluded_items_rec.created_by := to_number(l_token);
1751: l_state := 10;
1752: elsif (l_column = 'CREATION_DATE') then
1753: l_excluded_items_rec.creation_date := to_date(l_token,
1754: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1755: l_state := 10;
1756: elsif (l_column = 'LAST_UPDATED_BY') then
1757: l_excluded_items_rec.last_updated_by := to_number(l_token);
1758: l_state := 10;

Line 1764: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1760: l_excluded_items_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
1761: l_state := 10;
1762: elsif (l_column = 'LAST_UPDATE_DATE') then
1763: l_excluded_items_rec.last_update_date := to_date(l_token,
1764: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1765: l_state := 10;
1766: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1767: l_excluded_items_rec.last_update_login := to_number(l_token);
1768: l_state := 10;

Line 1858: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or

1854: --
1855: if (l_value_count = 2) then
1856: l_saved_token := l_token;
1857: end if;
1858: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1859: (l_value_count is null) then
1860: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1861: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1862: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 1956: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1952: l_resp_sec_attr_rec.created_by := to_number(l_token);
1953: l_state := 30;
1954: elsif (l_column = 'CREATION_DATE') then
1955: l_resp_sec_attr_rec.creation_date := to_date(l_token,
1956: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1957: l_state := 30;
1958: elsif (l_column = 'LAST_UPDATED_BY') then
1959: l_resp_sec_attr_rec.last_updated_by := to_number(l_token);
1960: l_state := 30;

Line 1966: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1962: l_resp_sec_attr_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
1963: l_state := 30;
1964: elsif (l_column = 'LAST_UPDATE_DATE') then
1965: l_resp_sec_attr_rec.last_update_date := to_date(l_token,
1966: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1967: l_state := 30;
1968: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1969: l_resp_sec_attr_rec.last_update_login := to_number(l_token);
1970: l_state := 30;