APPS.CN_UTILS dependencies on CN_SOURCE_S

Line 310: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,l_text1, g_org_id);

306: LOOP
307: l_pos := instr(l_text,')');
308: l_text1 :=substr(l_text,1,l_pos);
309: INSERT into cn_source_all (source_id, object_id, line_no, text, org_id)
310: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,l_text1, g_org_id);
311: l_text := substr(l_text, l_pos +1 );
312:
313: IF nvl(l_pos,0) = 0 then
314: INSERT into cn_source_all (source_id, object_id, line_no, text, org_id)

Line 315: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,substr(l_text,l_pos), g_org_id);

311: l_text := substr(l_text, l_pos +1 );
312:
313: IF nvl(l_pos,0) = 0 then
314: INSERT into cn_source_all (source_id, object_id, line_no, text, org_id)
315: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,substr(l_text,l_pos), g_org_id);
316: EXIT;
317: END IF;
318:
319: IF l_pos= 0 then

Line 321: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,substr(l_text,l_pos), g_org_id);

317: END IF;
318:
319: IF l_pos= 0 then
320: INSERT into cn_source_all (source_id, object_id, line_no, text, org_id)
321: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,substr(l_text,l_pos), g_org_id);
322: EXIT;
323: END IF;
324:
325: code.line := code.line + 1 ;

Line 334: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line, code.text, g_org_id );

330:
331: ELSE
332:
333: INSERT into cn_source (source_id, object_id, line_no, text, org_id)
334: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line, code.text, g_org_id );
335: code.text := NULL ;
336:
337: END IF;
338:

Line 382: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,l_text1, g_org_id);

378:
379: l_text1 :=DBMS_LOB.SUBSTR(l_clob_text,l_curr_pos,l_prev_pos);
380:
381: INSERT into cn_source (source_id, object_id, line_no, text, org_id)
382: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,l_text1, g_org_id);
383:
384: DBMS_LOB.ERASE(l_clob_text,l_curr_pos,l_prev_pos);
385:
386:

Line 392: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,DBMS_LOB.SUBSTR(l_clob_text,DBMS_LOB.GETLENGTH(code.text)-l_prev_pos,l_prev_pos), g_org_id);

388: l_prev_pos := l_prev_pos + l_curr_pos ;
389:
390: IF nvl(abs(DBMS_LOB.INSTR(l_clob_text,')',l_prev_pos)),0) = 0 THEN
391: INSERT into cn_source (source_id, object_id, line_no, text, org_id)
392: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,DBMS_LOB.SUBSTR(l_clob_text,DBMS_LOB.GETLENGTH(code.text)-l_prev_pos,l_prev_pos), g_org_id);
393: EXIT;
394: END IF;
395:
396: END LOOP;

Line 404: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line, l_text1, g_org_id);

400: ELSE
401: codelen := DBMS_LOB.GETLENGTH(code.text);
402: DBMS_LOB.READ(code.text,codelen,1,l_text1);
403: INSERT into cn_source (source_id, object_id, line_no, text, org_id)
404: VALUES (cn_source_s.NEXTVAL, code.object_id, code.line, l_text1, g_org_id);
405: END IF;
406:
407: DBMS_LOB.ERASE(code.text,codelen,1);
408: DBMS_LOB.FREETEMPORARY(l_clob_text);