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

Line 739: l_offset_var Integer := 1; /Offset given to the dbms_lob.read call/

735: l_filepath VARCHAR2(200) := '';/*has the dir path of log file*/
736: l_file_name VARCHAR2(200) := '';/*has the client file name*/
737: l_log_file VARCHAR2(200) := '';/*has the log file name*/
738: l_amount_var Integer := 200;/*Number of bytes to be read from blob*/
739: l_offset_var Integer := 1; /*Offset given to the dbms_lob.read call*/
740: l_string_param VARCHAR2(200) := '';
741: l_period_name VARCHAR2(25) := '';
742: l_salesgrp_id VARCHAR2(25) := '';
743: l_salesforce_id VARCHAR2(25) := '';

Line 767: SELECT DBMS_LOB.GETLENGTH(file_data), file_data, file_name

763: l_credit_type_name VARCHAR2(300);
764: l_valid BOOLEAN := TRUE;
765: l_exception VARCHAR2(500) := '';
766: BEGIN
767: SELECT DBMS_LOB.GETLENGTH(file_data), file_data, file_name
768: INTO l_lob_len, l_lob_loc, l_file_name
769: FROM FND_LOBS
770: WHERE file_id = p_file_id;
771:

Line 816: DBMS_LOB.READ(l_lob_loc, lv_amount_var, l_offset_var, l_lob_data);

812: End if;
813:
814: while(l_lob_len > 0)
815: LOOP
816: DBMS_LOB.READ(l_lob_loc, lv_amount_var, l_offset_var, l_lob_data);
817: l_string_param := utl_raw.cast_to_varchar2(l_lob_data);
818: while(length(l_string_param) > 0 )
819: Loop
820: l_line_data := '';

Line 1088: DBMS_LOB.CREATETEMPORARY(g_temp_blob, true);

1084: l_log_string VARCHAR2(1000);
1085: BEGIN
1086: /*Creating a temporary blob*/
1087: IF (p_exists) THEN
1088: DBMS_LOB.CREATETEMPORARY(g_temp_blob, true);
1089: END IF;
1090:
1091: IF (p_op_type = 'W') THEN
1092: /*Write to the temp lob*/

Line 1096: DBMS_LOB.WRITEAPPEND(g_temp_blob, l_strlen,utl_raw.cast_to_raw(l_log_string));

1092: /*Write to the temp lob*/
1093: l_log_string := p_log_string||g_next_line;
1094: l_strlen := length(l_log_string);
1095: IF(l_temp_amt_var > l_strlen) THEN
1096: DBMS_LOB.WRITEAPPEND(g_temp_blob, l_strlen,utl_raw.cast_to_raw(l_log_string));
1097:
1098: l_temp_offset := l_temp_offset + l_strlen;
1099: ELSE
1100: WHILE(l_strlen > 0)

Line 1102: DBMS_LOB.WRITEAPPEND(g_temp_blob, l_temp_amt_var, utl_raw.cast_to_raw(l_log_string));

1098: l_temp_offset := l_temp_offset + l_strlen;
1099: ELSE
1100: WHILE(l_strlen > 0)
1101: LOOP
1102: DBMS_LOB.WRITEAPPEND(g_temp_blob, l_temp_amt_var, utl_raw.cast_to_raw(l_log_string));
1103: l_temp_offset := l_temp_offset + l_temp_amt_var;
1104: l_strlen := l_strlen - l_temp_amt_var;
1105: if ((l_strlen > 0) and (l_strlen < l_temp_amt_var)) Then
1106: l_temp_amt_var := l_strlen;

Line 1113: SELECT file_data, dbms_lob.getlength(file_data)

1109: l_temp_offset := 1;
1110: l_temp_amt_var := 200;
1111: END IF;
1112: ELSIF (p_op_type = 'C') THEN
1113: SELECT file_data, dbms_lob.getlength(file_data)
1114: INTO dest_lob_loc, l_temp_amt_var1
1115: FROM FND_LOBS
1116: WHERE file_id = p_file_id
1117: FOR Update;

Line 1118: dbms_lob.erase(dest_lob_loc, l_temp_amt_var1);

1114: INTO dest_lob_loc, l_temp_amt_var1
1115: FROM FND_LOBS
1116: WHERE file_id = p_file_id
1117: FOR Update;
1118: dbms_lob.erase(dest_lob_loc, l_temp_amt_var1);
1119: l_temp_amt_var1 := dbms_lob.getlength(g_temp_blob);
1120: dbms_lob.copy(dest_lob_loc, g_temp_blob, l_temp_amt_var1);
1121: commit;
1122: dbms_lob.freetemporary(g_temp_blob);

Line 1119: l_temp_amt_var1 := dbms_lob.getlength(g_temp_blob);

1115: FROM FND_LOBS
1116: WHERE file_id = p_file_id
1117: FOR Update;
1118: dbms_lob.erase(dest_lob_loc, l_temp_amt_var1);
1119: l_temp_amt_var1 := dbms_lob.getlength(g_temp_blob);
1120: dbms_lob.copy(dest_lob_loc, g_temp_blob, l_temp_amt_var1);
1121: commit;
1122: dbms_lob.freetemporary(g_temp_blob);
1123: END IF;

Line 1120: dbms_lob.copy(dest_lob_loc, g_temp_blob, l_temp_amt_var1);

1116: WHERE file_id = p_file_id
1117: FOR Update;
1118: dbms_lob.erase(dest_lob_loc, l_temp_amt_var1);
1119: l_temp_amt_var1 := dbms_lob.getlength(g_temp_blob);
1120: dbms_lob.copy(dest_lob_loc, g_temp_blob, l_temp_amt_var1);
1121: commit;
1122: dbms_lob.freetemporary(g_temp_blob);
1123: END IF;
1124: exception

Line 1122: dbms_lob.freetemporary(g_temp_blob);

1118: dbms_lob.erase(dest_lob_loc, l_temp_amt_var1);
1119: l_temp_amt_var1 := dbms_lob.getlength(g_temp_blob);
1120: dbms_lob.copy(dest_lob_loc, g_temp_blob, l_temp_amt_var1);
1121: commit;
1122: dbms_lob.freetemporary(g_temp_blob);
1123: END IF;
1124: exception
1125: when others then
1126: dbms_lob.freetemporary(g_temp_blob);

Line 1126: dbms_lob.freetemporary(g_temp_blob);

1122: dbms_lob.freetemporary(g_temp_blob);
1123: END IF;
1124: exception
1125: when others then
1126: dbms_lob.freetemporary(g_temp_blob);
1127: End Create_Loglob;
1128:
1129: End AS_FORECAST_ACTUAL_PKG;