APPS.CN_UTILS dependencies on CN_SOURCE_ALL

Line 70: DELETE FROM cn_source_all

66: x_package_spec_id cn_objects.object_id%TYPE,
67: x_package_body_id cn_objects.object_id%TYPE,
68: p_org_id IN NUMBER) IS
69: BEGIN
70: DELETE FROM cn_source_all
71: WHERE (object_id = x_package_spec_id
72: OR object_id = x_package_body_id)
73: AND org_id = p_org_id ;
74:

Line 268: FROM cn_source_all

264: code.text := NULL ;
265:
266: SELECT text
267: INTO code.text
268: FROM cn_source_all
269: WHERE object_id = code.object_id
270: AND line_no = code.line
271: AND org_id = g_org_id;
272:

Line 278: UPDATE cn_source_all

274: code.text := substr(code.text, 1, length(code.text) - (i + 1));
275: code.text := code.text || '
276: ';
277:
278: UPDATE cn_source_all
279: SET text = code.text
280: WHERE object_id = code.object_id
281: AND line_no = code.line
282: AND org_id = g_org_id;

Line 309: INSERT into cn_source_all (source_id, object_id, line_no, text, org_id)

305:
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

Line 314: 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)
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:

Line 320: INSERT into cn_source_all (source_id, object_id, line_no, text, org_id)

316: EXIT;
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: