eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_UTILS dependencies on CN_SOURCE

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

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 333: INSERT into cn_source (source_id, object_id, line_no, text, org_id)

329: code.text := NULL ;
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;

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 366: -- the expression can be inserted directly into cn_source

362: l_prev_pos := 1;
363: DBMS_LOB.CREATETEMPORARY(l_clob_text,FALSE,DBMS_LOB.CALL);
364:
365: -- If the length of the expression is less than 1900 characters
366: -- the expression can be inserted directly into cn_source
367: -- otherwise need to find the close braces and insert the string
368: -- upto close bracess.
369: -- l_curr_pos - is used to store the no. of characters between the previously found
370: -- paranthesis and the newly found paranthesis

Line 381: INSERT into cn_source (source_id, object_id, line_no, text, org_id)

377: l_curr_pos := abs(DBMS_LOB.INSTR(l_clob_text,')',l_prev_pos) - l_prev_pos) + 1;
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:

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 391: INSERT into cn_source (source_id, object_id, line_no, text, org_id)

387: code.line := code.line + 1 ;
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:

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 403: INSERT into cn_source (source_id, object_id, line_no, text, org_id)

399:
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);

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);

Line 704: -- Delete module source code from cn_source

700: -- Find the package objects AE 01-08-96
701: cn_utils.find_object(package_name,'PKS',package_spec_id, package_spec_desc, g_org_id);
702: cn_utils.find_object(package_name,'PKB',package_body_id, package_body_desc, g_org_id);
703:
704: -- Delete module source code from cn_source
705: -- Delete module object dependencies for this module
706: cn_utils.delete_module(module_id, package_spec_id, package_body_id, g_org_id);
707:
708: cn_utils.init_code (package_spec_id, spec_code); -- AE 05-02-95

Line 861: -- Delete module source code from cn_source

857: -- Find the package objects AE 01-08-96
858: cn_utils.find_object(package_name,'PKS',package_spec_id, package_spec_desc, g_org_id);
859: cn_utils.find_object(package_name,'PKB',package_body_id, package_body_desc, g_org_id);
860:
861: -- Delete module source code from cn_source
862: -- Delete module object dependencies for this module
863: cn_utils.delete_module(module_id, package_spec_id, package_body_id, g_org_id);
864:
865: cn_utils.init_code (package_spec_id, spec_code); -- AE 05-02-95

Line 904: -- Delete module source code from cn_source

900: -- Find the package objects AE 01-08-96
901: cn_utils.find_object(package_name,'PKS',package_spec_id, package_spec_desc, g_org_id);
902: cn_utils.find_object(package_name,'PKB',package_body_id, package_body_desc, g_org_id);
903:
904: -- Delete module source code from cn_source
905: -- Delete module object dependencies for this module
906: cn_utils.delete_module(module_id, package_spec_id, package_body_id, g_org_id);
907:
908: cn_utils.init_code (package_spec_id, spec_code); -- AE 05-02-95