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_QUERYOBJ_PVT dependencies on AK_QUERYOBJ_PUB

Line 394: p_queryobj_pk_tbl IN AK_QUERYOBJ_PUB.queryObj_PK_Tbl_Type

390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391: p_api_version_number IN NUMBER,
392: p_return_status OUT NOCOPY VARCHAR2,
393: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
394: p_queryobj_pk_tbl IN AK_QUERYOBJ_PUB.queryObj_PK_Tbl_Type
395: := AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_PK_TBL,
396: p_nls_language IN VARCHAR2
397: ) is
398: cursor l_get_queryobj_list_csr (appl_id_parm in number) is

Line 395: := AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_PK_TBL,

391: p_api_version_number IN NUMBER,
392: p_return_status OUT NOCOPY VARCHAR2,
393: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
394: p_queryobj_pk_tbl IN AK_QUERYOBJ_PUB.queryObj_PK_Tbl_Type
395: := AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_PK_TBL,
396: p_nls_language IN VARCHAR2
397: ) is
398: cursor l_get_queryobj_list_csr (appl_id_parm in number) is
399: select query_code

Line 410: l_queryobj_pk_tbl AK_QUERYOBJ_PUB.Queryobj_PK_Tbl_Type;

406: l_index NUMBER;
407: l_last_orig_index NUMBER;
408: l_msg_count NUMBER;
409: l_msg_data VARCHAR2(2000);
410: l_queryobj_pk_tbl AK_QUERYOBJ_PUB.Queryobj_PK_Tbl_Type;
411: l_return_status varchar2(1);
412: begin
413: IF NOT FND_API.Compatible_API_Call (
414: l_api_version_number, p_api_version_number, l_api_name,

Line 1505: l_line_tbl AK_queryobj_PUB.queryobj_lines_Tbl_Type;

1501: l_api_version_number CONSTANT number := 1.0;
1502: l_api_name CONSTANT varchar2(30) := 'Upload_queryobj';
1503: l_line_index NUMBER := 0;
1504: l_line_rec ak_query_object_lines%ROWTYPE;
1505: l_line_tbl AK_queryobj_PUB.queryobj_lines_Tbl_Type;
1506: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
1507: l_column varchar2(30);
1508: l_dummy NUMBER;
1509: l_eof_flag VARCHAR2(1);

Line 1518: l_query_tbl AK_QUERYOBJ_PUB.queryobj_Tbl_Type;

1514: l_msg_count NUMBER;
1515: l_msg_data VARCHAR2(2000);
1516: l_query_index NUMBER := 0;
1517: l_query_rec ak_query_objects%ROWTYPE;
1518: l_query_tbl AK_QUERYOBJ_PUB.queryobj_Tbl_Type;
1519: l_return_status varchar2(1);
1520: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
1521: l_state NUMBER;
1522: l_token AK_ON_OBJECTS_PUB.Buffer_Type;

Line 1640: l_query_rec := AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_REC;

1636: end if;
1637: elsif (l_state = 1) then
1638: if (l_token = 'QUERY_OBJECT') then
1639: --== Clear out previous column data ==--
1640: l_query_rec := AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_REC;
1641: l_state := 2;
1642: else
1643: -- Found the beginning of a non-region object,
1644: -- rebuild last line and pass it back to the caller

Line 1763: l_line_rec := AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_LINE_REC;

1759: elsif (l_state = 13) then
1760: if (l_token = 'QUERY_OBJECT_LINE') then
1761: --== Clear out previous query object line column data ==--
1762: -- and load query object key values into record --
1763: l_line_rec := AK_QUERYOBJ_PUB.G_MISS_QUERYOBJ_LINE_REC;
1764: l_line_rec.query_code := l_query_rec.query_code;
1765: l_state := 20;
1766: else
1767: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN