APPS.AMV_SEARCH_PVT dependencies on AMV_TEMP_IDS

Line 23: -- insert into 'amv_temp_ids' table right after each

19: -- 5. Build_Items_URL_Sql
20: --
21: -- 10/23/00 jjwu Removed 'UNION ALL' statements
22:
23: -- insert into 'amv_temp_ids' table right after each
24:
25: -- substatement construction
26:
27: --

Line 4093: --TRUNCATE also empties the session entries into amv_temp_ids

4089: --DBMS_OUTPUT.PUT_LINE('Enter : insert_temp_numbers' );
4090:
4091: -- delete channels from temp table
4092:
4093: --TRUNCATE also empties the session entries into amv_temp_ids
4094:
4095: --Since temp tables are empty at beginning of session, then
4096:
4097: -- amv_temp_ids must also be empty after TRUNCATE

Line 4097: -- amv_temp_ids must also be empty after TRUNCATE

4093: --TRUNCATE also empties the session entries into amv_temp_ids
4094:
4095: --Since temp tables are empty at beginning of session, then
4096:
4097: -- amv_temp_ids must also be empty after TRUNCATE
4098:
4099: l_return_status := FND_INSTALLATION.get_app_info('AMV',l_status,l_industry,l_schema);
4100: --EXECUTE IMMEDIATE 'TRUNCATE TABLE amv.amv_temp_numbers';
4101:

Line 4150: l_ins_stmt varchar2(100) := 'INSERT INTO amv_temp_ids (id,number_value,score) ';

4146: x_status OUT NOCOPY VARCHAR2)
4147:
4148: IS
4149:
4150: l_ins_stmt varchar2(100) := 'INSERT INTO amv_temp_ids (id,number_value,score) ';
4151:
4152: l_rows_processed PLS_INTEGER;
4153:
4154: l_cursor_id PLS_INTEGER;

Line 4196: --EXECUTE IMMEDIATE 'TRUNCATE TABLE amv.amv_temp_ids';

4192: -- temporary table for session, including amv_temp_numbers
4193:
4194: -- which causes search result to be empty.
4195:
4196: --EXECUTE IMMEDIATE 'TRUNCATE TABLE amv.amv_temp_ids';
4197:
4198:
4199:
4200: p_stmt(p_start_index - 1) := l_ins_stmt;

Line 4322: , amv_temp_ids tmp

4318: , max(tmp.score)
4319:
4320: from amv_c_channels_vl chn
4321:
4322: , amv_temp_ids tmp
4323:
4324: where chn.channel_id = tmp.id
4325:
4326: group by chn.channel_id, chn.last_update_date, chn.channel_name, chn.description, tmp.number_value

Line 4336: from amv_temp_ids

4332: CURSOR channel_count_csr IS
4333:
4334: select sum(count(distinct id))
4335:
4336: from amv_temp_ids
4337:
4338: group by number_value;
4339:
4340:

Line 4550: from jtf_amv_items_vl itm, amv_temp_ids tmp

4546: select itm.item_id, itm.last_update_date, itm.item_name,
4547:
4548: itm.description, max(tmp.score)
4549:
4550: from jtf_amv_items_vl itm, amv_temp_ids tmp
4551:
4552: where itm.item_id = tmp.id
4553:
4554: group by itm.item_id, itm.last_update_date, itm.item_name, itm.description

Line 4564: from amv_temp_ids

4560: CURSOR item_count_csr IS
4561:
4562: select sum(count(distinct id))
4563:
4564: from amv_temp_ids
4565:
4566: group by id;
4567:
4568:

Line 4576: from amv_temp_ids tmp

4572: select number_value
4573:
4574: , max(score)
4575:
4576: from amv_temp_ids tmp
4577:
4578: where id = l_item_id
4579:
4580: group by number_value;

Line 4620: select count(*) into l_count from amv_temp_ids;

4616: --DBMS_OUTPUT.PUT_LINE('Enter : populate_item_results' );
4617:
4618:
4619:
4620: select count(*) into l_count from amv_temp_ids;
4621:
4622: --DBMS_OUTPUT.PUT_LINE('count is: ' || l_count);
4623:
4624:

Line 7834: cursor id_csr is select id from amv_temp_ids;

7830:
7831:
7832: l_id number;
7833:
7834: cursor id_csr is select id from amv_temp_ids;
7835:
7836: --
7837:
7838: BEGIN