APPS.AK_QUERYOBJ_PVT dependencies on AK_QUERY_OBJECTS

Line 223: from AK_QUERY_OBJECTS

219: p_nls_language IN VARCHAR2
220: ) is
221: cursor l_get_queryobj_csr is
222: select *
223: from AK_QUERY_OBJECTS
224: where query_code = p_query_code;
225:
226: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
227: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

Line 229: l_queryobj_rec AK_QUERY_OBJECTS%ROWTYPE;

225:
226: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
227: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
228: l_index NUMBER;
229: l_queryobj_rec AK_QUERY_OBJECTS%ROWTYPE;
230: l_return_status varchar2(1);
231:
232: begin
233:

Line 400: from AK_QUERY_OBJECTS

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
400: from AK_QUERY_OBJECTS
401: where APPLICATION_ID = appl_id_parm;
402: l_api_version_number CONSTANT number := 1.0;
403: l_api_name CONSTANT varchar2(30) := 'Download_Query_Object';
404: l_application_id NUMBER;

Line 582: from ak_query_objects

578: ) RETURN BOOLEAN IS
579: CURSOR l_chk_qobj_exists_csr (param_query_code in varchar2,
580: param_application_id in number) is
581: select 1
582: from ak_query_objects
583: where query_code = param_query_code
584: and application_id = param_application_id;
585: l_dummy number;
586: l_api_name constant varchar2(30) := 'QUERY_OBJECT_EXISTS';

Line 793: insert into AK_QUERY_OBJECTS (

789: p_create_or_update => 'CREATE') then
790: null;
791: end if;
792:
793: insert into AK_QUERY_OBJECTS (
794: QUERY_CODE,
795: APPLICATION_ID,
796: CREATION_DATE,
797: CREATED_BY,

Line 1095: from AK_QUERY_OBJECTS

1091: p_pass IN NUMBER := 2
1092: ) IS
1093: cursor l_get_query_csr is
1094: select *
1095: from AK_QUERY_OBJECTS
1096: where QUERY_CODE = p_query_code
1097: for update of APPLICATION_ID;
1098: l_api_version_number CONSTANT number := 1.0;
1099: l_api_name CONSTANT varchar2(30) := 'Update_Query_Object';

Line 1100: l_queryobj_rec AK_QUERY_OBJECTS%ROWTYPE;

1096: where QUERY_CODE = p_query_code
1097: for update of APPLICATION_ID;
1098: l_api_version_number CONSTANT number := 1.0;
1099: l_api_name CONSTANT varchar2(30) := 'Update_Query_Object';
1100: l_queryobj_rec AK_QUERY_OBJECTS%ROWTYPE;
1101: l_created_by number;
1102: l_creation_date date;
1103: l_last_update_date date;
1104: l_last_update_login number;

Line 1184: update AK_QUERY_OBJECTS set

1180: p_create_or_update => 'UPDATE') then
1181: null;
1182: end if;
1183:
1184: update AK_QUERY_OBJECTS set
1185: application_id = l_queryobj_rec.application_id,
1186: LAST_UPDATE_DATE = l_last_update_date,
1187: LAST_UPDATED_BY = l_last_updated_by,
1188: LAST_UPDATE_LOGIN = l_last_update_login

Line 1517: l_query_rec ak_query_objects%ROWTYPE;

1513: l_more_queryobj BOOLEAN := TRUE;
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;

Line 2012: from ak_query_objects aqo

2008: elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
2009: -- do not update customized data
2010: select aqo.last_updated_by, aqo.last_update_date
2011: into l_user_id1, l_update1
2012: from ak_query_objects aqo
2013: where aqo.query_code = l_query_tbl(l_index).query_code
2014: and aqo.application_id = l_query_tbl(l_index).application_id;
2015: /*if ( l_user_id1 = 1 or l_user_id1 = 2 ) then*/
2016: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(