APPS.CCT_QDE_PUB dependencies on CCT_QDE_DATA

Line 143: insert into cct_qde_data (item_id,

139: x_msg_data := null;
140:
141: -- API body
142: --dbms_output.put_line('RECEIVE_ITEM: pre insert data');
143: insert into cct_qde_data (item_id,
144: item_kvp,
145: created_by, creation_date,
146: last_updated_by, last_update_date, last_update_login)
147: values (p_item_id,

Line 281: update cct_qde_data

277: is_reroute = p_is_reroute,
278: is_routed = 'Y'
279: where item_id = p_item_id;
280:
281: update cct_qde_data
282: set item_kvp = p_kvp
283: where item_id = p_item_id;
284:
285: commit;

Line 337: select item_kvp into l_kvp from cct_qde_data

333: raise RESULT_NOT_FOUND ;
334:
335: end;
336:
337: select item_kvp into l_kvp from cct_qde_data
338: where item_id = p_item_id;
339:
340: -- enqueue result.
341:

Line 349: delete from cct_qde_data where item_id = p_item_id;

345: delete from cct_qde_route_result where item_id = p_item_id;
346: --dbms_output.put_line('UPDATE_ROUTE_RESULT: post delete route result');
347:
348:
349: delete from cct_qde_data where item_id = p_item_id;
350:
351: update cct_qde_agent
352: set is_get_work = 0, item_type = null, classification = null
353: where agent_id = r1_rec.agent_id;

Line 578: select item_kvp into x_kvp from cct_qde_data

574: -- end if;
575: --dbms_output.put_line('GET_NEXT_ITEM: pre delete route result');
576: delete from cct_qde_route_result where item_id = r1_rec.item_id;
577: --dbms_output.put_line('GET_NEXT_ITEM: post delete route result');
578: select item_kvp into x_kvp from cct_qde_data
579: where item_id = r1_rec.item_id;
580: delete from cct_qde_data where item_id = r1_rec.item_id;
581:
582: update cct_qde_agent

Line 580: delete from cct_qde_data where item_id = r1_rec.item_id;

576: delete from cct_qde_route_result where item_id = r1_rec.item_id;
577: --dbms_output.put_line('GET_NEXT_ITEM: post delete route result');
578: select item_kvp into x_kvp from cct_qde_data
579: where item_id = r1_rec.item_id;
580: delete from cct_qde_data where item_id = r1_rec.item_id;
581:
582: update cct_qde_agent
583: set is_get_work = 0, item_type = null, classification = null
584: where agent_id = p_agent_id;