APPS.IEM_TEXT_PVT dependencies on IEM_INTENT_DOCUMENTS

Line 504: -- Insert The Data into IEM_INTENT_DOCUMENTS

500: x_next_row_pos_tbl => l_next_row_pos,
501: x_total_row_cnt_tbl => l_total_row_cnt,
502: x_result_array => l_result_array);
503:
504: -- Insert The Data into IEM_INTENT_DOCUMENTS
505: delete from iem_intent_documents where intent_id=l_intent_id;
506: if l_result_array.count>0 then
507: FOR l_count IN 1..l_result_array.count LOOP
508: insert into iem_intent_documents

Line 505: delete from iem_intent_documents where intent_id=l_intent_id;

501: x_total_row_cnt_tbl => l_total_row_cnt,
502: x_result_array => l_result_array);
503:
504: -- Insert The Data into IEM_INTENT_DOCUMENTS
505: delete from iem_intent_documents where intent_id=l_intent_id;
506: if l_result_array.count>0 then
507: FOR l_count IN 1..l_result_array.count LOOP
508: insert into iem_intent_documents
509: (intent_id,

Line 508: insert into iem_intent_documents

504: -- Insert The Data into IEM_INTENT_DOCUMENTS
505: delete from iem_intent_documents where intent_id=l_intent_id;
506: if l_result_array.count>0 then
507: FOR l_count IN 1..l_result_array.count LOOP
508: insert into iem_intent_documents
509: (intent_id,
510: docname,
511: repos_id,
512: doc_id,

Line 561: insert into iem_intent_documents

557: if l_result_array.count>0 then
558: FOR l_count IN 1..l_result_array.count LOOP
559: --select set_number into l_number
560: --from CS_KB_SETS_B where set_id=l_result_array(l_count).id;
561: insert into iem_intent_documents
562: (intent_id,
563: docname,
564: repos_id,
565: doc_id,