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.MSC_RP_PUB dependencies on DBMS_LOB

Line 17: dbms_lob.createtemporary(l_from_where_clob,TRUE,DBMS_LOB.SESSION);

13: l_update_sql_clob clob; -- temporary
14:
15: PROCEDURE init_lobs IS
16: BEGIN
17: dbms_lob.createtemporary(l_from_where_clob,TRUE,DBMS_LOB.SESSION);
18: dbms_lob.createtemporary(l_sql_clob,TRUE,DBMS_LOB.SESSION);
19: dbms_lob.createtemporary(l_key_values_xml_clob,TRUE,DBMS_LOB.SESSION);
20: dbms_lob.createtemporary(l_keys_xml_clob,TRUE,DBMS_LOB.SESSION);
21: dbms_lob.createtemporary(l_update_sql_clob,TRUE,DBMS_LOB.SESSION);

Line 18: dbms_lob.createtemporary(l_sql_clob,TRUE,DBMS_LOB.SESSION);

14:
15: PROCEDURE init_lobs IS
16: BEGIN
17: dbms_lob.createtemporary(l_from_where_clob,TRUE,DBMS_LOB.SESSION);
18: dbms_lob.createtemporary(l_sql_clob,TRUE,DBMS_LOB.SESSION);
19: dbms_lob.createtemporary(l_key_values_xml_clob,TRUE,DBMS_LOB.SESSION);
20: dbms_lob.createtemporary(l_keys_xml_clob,TRUE,DBMS_LOB.SESSION);
21: dbms_lob.createtemporary(l_update_sql_clob,TRUE,DBMS_LOB.SESSION);
22: exception when others then

Line 19: dbms_lob.createtemporary(l_key_values_xml_clob,TRUE,DBMS_LOB.SESSION);

15: PROCEDURE init_lobs IS
16: BEGIN
17: dbms_lob.createtemporary(l_from_where_clob,TRUE,DBMS_LOB.SESSION);
18: dbms_lob.createtemporary(l_sql_clob,TRUE,DBMS_LOB.SESSION);
19: dbms_lob.createtemporary(l_key_values_xml_clob,TRUE,DBMS_LOB.SESSION);
20: dbms_lob.createtemporary(l_keys_xml_clob,TRUE,DBMS_LOB.SESSION);
21: dbms_lob.createtemporary(l_update_sql_clob,TRUE,DBMS_LOB.SESSION);
22: exception when others then
23: rp_debug('exception in init_lobs');

Line 20: dbms_lob.createtemporary(l_keys_xml_clob,TRUE,DBMS_LOB.SESSION);

16: BEGIN
17: dbms_lob.createtemporary(l_from_where_clob,TRUE,DBMS_LOB.SESSION);
18: dbms_lob.createtemporary(l_sql_clob,TRUE,DBMS_LOB.SESSION);
19: dbms_lob.createtemporary(l_key_values_xml_clob,TRUE,DBMS_LOB.SESSION);
20: dbms_lob.createtemporary(l_keys_xml_clob,TRUE,DBMS_LOB.SESSION);
21: dbms_lob.createtemporary(l_update_sql_clob,TRUE,DBMS_LOB.SESSION);
22: exception when others then
23: rp_debug('exception in init_lobs');
24: rp_debug(sqlerrm);

Line 21: dbms_lob.createtemporary(l_update_sql_clob,TRUE,DBMS_LOB.SESSION);

17: dbms_lob.createtemporary(l_from_where_clob,TRUE,DBMS_LOB.SESSION);
18: dbms_lob.createtemporary(l_sql_clob,TRUE,DBMS_LOB.SESSION);
19: dbms_lob.createtemporary(l_key_values_xml_clob,TRUE,DBMS_LOB.SESSION);
20: dbms_lob.createtemporary(l_keys_xml_clob,TRUE,DBMS_LOB.SESSION);
21: dbms_lob.createtemporary(l_update_sql_clob,TRUE,DBMS_LOB.SESSION);
22: exception when others then
23: rp_debug('exception in init_lobs');
24: rp_debug(sqlerrm);
25: END init_lobs;

Line 32: v_length:=DBMS_LOB.GETLENGTH (lob1);

28: v_length INTEGER:=1;
29: v_trim_length INTEGER:=1;
30: BEGIN
31:
32: v_length:=DBMS_LOB.GETLENGTH (lob1);
33: rp_debug('clearing lob v_length='||v_length);
34: if v_length>0 then
35: DBMS_LOB.ERASE(lob1, v_length);
36: DBMS_LOB.TRIM(lob1, v_trim_length);

Line 35: DBMS_LOB.ERASE(lob1, v_length);

31:
32: v_length:=DBMS_LOB.GETLENGTH (lob1);
33: rp_debug('clearing lob v_length='||v_length);
34: if v_length>0 then
35: DBMS_LOB.ERASE(lob1, v_length);
36: DBMS_LOB.TRIM(lob1, v_trim_length);
37: end if;
38: exception when others then
39: rp_debug('exception in clear_lob');

Line 36: DBMS_LOB.TRIM(lob1, v_trim_length);

32: v_length:=DBMS_LOB.GETLENGTH (lob1);
33: rp_debug('clearing lob v_length='||v_length);
34: if v_length>0 then
35: DBMS_LOB.ERASE(lob1, v_length);
36: DBMS_LOB.TRIM(lob1, v_trim_length);
37: end if;
38: exception when others then
39: rp_debug('exception in clear_lob');
40: rp_debug(sqlerrm);

Line 57: dbms_lob.FREETEMPORARY(l_from_where_clob);

53: END clear_lobs;
54:
55: PROCEDURE free_lobs IS
56: BEGIN
57: dbms_lob.FREETEMPORARY(l_from_where_clob);
58: dbms_lob.FREETEMPORARY(l_sql_clob);
59: dbms_lob.FREETEMPORARY(l_key_values_xml_clob);
60: dbms_lob.FREETEMPORARY(l_keys_xml_clob);
61: dbms_lob.FREETEMPORARY(l_update_sql_clob);

Line 58: dbms_lob.FREETEMPORARY(l_sql_clob);

54:
55: PROCEDURE free_lobs IS
56: BEGIN
57: dbms_lob.FREETEMPORARY(l_from_where_clob);
58: dbms_lob.FREETEMPORARY(l_sql_clob);
59: dbms_lob.FREETEMPORARY(l_key_values_xml_clob);
60: dbms_lob.FREETEMPORARY(l_keys_xml_clob);
61: dbms_lob.FREETEMPORARY(l_update_sql_clob);
62: exception when others then

Line 59: dbms_lob.FREETEMPORARY(l_key_values_xml_clob);

55: PROCEDURE free_lobs IS
56: BEGIN
57: dbms_lob.FREETEMPORARY(l_from_where_clob);
58: dbms_lob.FREETEMPORARY(l_sql_clob);
59: dbms_lob.FREETEMPORARY(l_key_values_xml_clob);
60: dbms_lob.FREETEMPORARY(l_keys_xml_clob);
61: dbms_lob.FREETEMPORARY(l_update_sql_clob);
62: exception when others then
63: rp_debug('exception in free_lobs');

Line 60: dbms_lob.FREETEMPORARY(l_keys_xml_clob);

56: BEGIN
57: dbms_lob.FREETEMPORARY(l_from_where_clob);
58: dbms_lob.FREETEMPORARY(l_sql_clob);
59: dbms_lob.FREETEMPORARY(l_key_values_xml_clob);
60: dbms_lob.FREETEMPORARY(l_keys_xml_clob);
61: dbms_lob.FREETEMPORARY(l_update_sql_clob);
62: exception when others then
63: rp_debug('exception in free_lobs');
64: rp_debug(sqlerrm);

Line 61: dbms_lob.FREETEMPORARY(l_update_sql_clob);

57: dbms_lob.FREETEMPORARY(l_from_where_clob);
58: dbms_lob.FREETEMPORARY(l_sql_clob);
59: dbms_lob.FREETEMPORARY(l_key_values_xml_clob);
60: dbms_lob.FREETEMPORARY(l_keys_xml_clob);
61: dbms_lob.FREETEMPORARY(l_update_sql_clob);
62: exception when others then
63: rp_debug('exception in free_lobs');
64: rp_debug(sqlerrm);
65: END free_lobs;

Line 70: dbms_lob.append (lob1, lob2);

66:
67:
68: PROCEDURE append( lob1 IN OUT NOCOPY CLOB, lob2 IN OUT NOCOPY CLOB) IS
69: BEGIN
70: dbms_lob.append (lob1, lob2);
71: exception when others then
72: rp_debug('exception in append clob');
73: rp_debug(sqlerrm);
74: END append;

Line 78: dbms_lob.writeappend (lob1, length(buffer),buffer);

74: END append;
75:
76: PROCEDURE append( lob1 IN OUT NOCOPY CLOB, buffer IN varchar2) IS
77: BEGIN
78: dbms_lob.writeappend (lob1, length(buffer),buffer);
79: exception when others then
80: rp_debug('exception in append varchar2');
81: rp_debug(sqlerrm);
82: END append;