APPS.AK_QUERYOBJ_PVT dependencies on AK_QUERY_OBJECT_LINES

Line 38: from AK_QUERY_OBJECT_LINES

34: p_nls_language IN VARCHAR2
35: ) is
36: cursor l_get_lines_csr (param_query_code in varchar2) is
37: select *
38: from AK_QUERY_OBJECT_LINES
39: where query_code = param_query_code
40: order by seq_num;
41:
42: l_api_name CONSTANT varchar2(30) := 'Write_lines_to_buffer';

Line 45: l_queryobj_lines_rec AK_QUERY_OBJECT_LINES%ROWTYPE;

41:
42: l_api_name CONSTANT varchar2(30) := 'Write_lines_to_buffer';
43: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
44: l_index NUMBER;
45: l_queryobj_lines_rec AK_QUERY_OBJECT_LINES%ROWTYPE;
46: l_return_status varchar2(1);
47: l_line_count NUMBER := 0;
48:
49: begin

Line 534: from ak_query_object_lines

530: ) RETURN BOOLEAN IS
531: cursor l_chk_seq_num_csr (param_query_code in varchar2,
532: param_seq_num in number) is
533: select *
534: from ak_query_object_lines
535: where query_code = param_query_code
536: and seq_num = param_seq_num;
537:
538: l_line_rec ak_query_object_lines%ROWTYPE;

Line 538: l_line_rec ak_query_object_lines%ROWTYPE;

534: from ak_query_object_lines
535: where query_code = param_query_code
536: and seq_num = param_seq_num;
537:
538: l_line_rec ak_query_object_lines%ROWTYPE;
539: l_error boolean;
540: l_api_name CONSTANT varchar2(30) := 'validate_line';
541:
542: BEGIN

Line 638: from ak_query_object_lines

634: ) RETURN BOOLEAN IS
635: CURSOR l_chk_line_exists_csr (param_query_code in varchar2,
636: param_seq_num in number) is
637: select 1
638: from ak_query_object_lines
639: where query_code = param_query_code
640: and seq_num = param_seq_num;
641: l_dummy number;
642: l_api_name constant varchar2(30) := 'LINE_EXISTS';

Line 980: insert into AK_QUERY_OBJECT_LINES (

976: p_create_or_update => 'CREATE') then
977: null;
978: end if;
979:
980: insert into AK_QUERY_OBJECT_LINES (
981: QUERY_CODE,
982: SEQ_NUM,
983: QUERY_LINE_TYPE,
984: QUERY_LINE,

Line 1275: from AK_QUERY_OBJECT_LINES

1271: ) IS
1272:
1273: cursor l_get_query_line_csr is
1274: select *
1275: from AK_QUERY_OBJECT_LINES
1276: where QUERY_CODE = p_query_code
1277: and seq_num = p_seq_num
1278: for update of QUERY_LINE;
1279: l_api_version_number CONSTANT number := 1.0;

Line 1283: l_line_rec AK_QUERY_OBJECT_LINES%ROWTYPE;

1279: l_api_version_number CONSTANT number := 1.0;
1280: l_api_name CONSTANT varchar2(30) := 'Update_Query_Object_Line';
1281: l_created_by number;
1282: l_creation_date date;
1283: l_line_rec AK_QUERY_OBJECT_LINES%ROWTYPE;
1284: l_last_update_date date;
1285: l_last_update_login number;
1286: l_last_updated_by number;
1287: l_return_status varchar2(1);

Line 1304: --** retrieve ak_query_object_lines row if it exists **

1300: end if;
1301:
1302: savepoint start_update_query_line;
1303:
1304: --** retrieve ak_query_object_lines row if it exists **
1305: open l_get_query_line_csr;
1306: fetch l_get_query_line_csr into l_line_rec;
1307: if (l_get_query_line_csr%notfound) then
1308: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 1368: update AK_QUERY_OBJECT_LINES set

1364: p_create_or_update => 'UPDATE') then
1365: null;
1366: end if;
1367:
1368: update AK_QUERY_OBJECT_LINES set
1369: query_line_type = l_line_rec.query_line_type,
1370: query_line = l_line_rec.query_line,
1371: linked_parameter = l_line_rec.linked_parameter,
1372: LAST_UPDATE_DATE = l_last_update_date,

Line 1504: l_line_rec ak_query_object_lines%ROWTYPE;

1500: ) is
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;

Line 2123: from ak_query_object_lines aqol

2119: -- update non-customized data only
2120: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
2121: select aqol.last_updated_by, aqol.last_update_date
2122: into l_user_id1, l_update1
2123: from ak_query_object_lines aqol
2124: where aqol.query_code = l_line_tbl(l_index).query_code
2125: and aqol.seq_num = l_line_tbl(l_index).seq_num;
2126: /*if ( l_user_id1 = 1 or l_user_id1 = 2 ) then*/
2127: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(