DBA Data[Home] [Help]

APPS.CZ_FCE_COMPILE dependencies on DBMS_LOB

Line 970: DBMS_LOB.WRITEAPPEND ( ConstantPool, l_len, l_raw );

966: BEGIN
967:
968: IF ( l_len > 0 ) THEN
969:
970: DBMS_LOB.WRITEAPPEND ( ConstantPool, l_len, l_raw );
971:
972: END IF;
973: END flush_constant_pool;
974: ---------------------------------------------------------------------------------------

Line 985: DBMS_LOB.WRITEAPPEND ( CodeMemory, l_len, l_raw );

981: BEGIN
982:
983: IF ( l_len > 0 ) THEN
984:
985: DBMS_LOB.WRITEAPPEND ( CodeMemory, l_len, l_raw );
986:
987: END IF;
988: END flush_code_memory;
989: ---------------------------------------------------------------------------------------

Line 994: DBMS_LOB.CREATETEMPORARY ( ConstantPool, TRUE );

990: -- Scope: compile_logic_file
991: PROCEDURE init_logic_file IS
992: BEGIN
993:
994: DBMS_LOB.CREATETEMPORARY ( ConstantPool, TRUE );
995: DBMS_LOB.CREATETEMPORARY ( CodeMemory, TRUE );
996:
997: CodeMemory_buffer := NULL;
998: code_buffer_ptr := 0;

Line 995: DBMS_LOB.CREATETEMPORARY ( CodeMemory, TRUE );

991: PROCEDURE init_logic_file IS
992: BEGIN
993:
994: DBMS_LOB.CREATETEMPORARY ( ConstantPool, TRUE );
995: DBMS_LOB.CREATETEMPORARY ( CodeMemory, TRUE );
996:
997: CodeMemory_buffer := NULL;
998: code_buffer_ptr := 0;
999:

Line 1016: DBMS_LOB.TRIM ( ConstantPool, 0 );

1012: -- Scope: compile_logic_file
1013: PROCEDURE next_logic_segment IS
1014: BEGIN
1015:
1016: DBMS_LOB.TRIM ( ConstantPool, 0 );
1017: DBMS_LOB.TRIM ( CodeMemory, 0 );
1018:
1019: CodeMemory_buffer := NULL;
1020: code_buffer_ptr := 0;

Line 1017: DBMS_LOB.TRIM ( CodeMemory, 0 );

1013: PROCEDURE next_logic_segment IS
1014: BEGIN
1015:
1016: DBMS_LOB.TRIM ( ConstantPool, 0 );
1017: DBMS_LOB.TRIM ( CodeMemory, 0 );
1018:
1019: CodeMemory_buffer := NULL;
1020: code_buffer_ptr := 0;
1021:

Line 1051: DBMS_LOB.CREATETEMPORARY ( l_loc, TRUE );

1047: flush_code_memory ();
1048:
1049: IF ( pool_ptr + code_ptr > 0 ) THEN
1050:
1051: DBMS_LOB.CREATETEMPORARY ( l_loc, TRUE );
1052:
1053: IF ( pool_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, ConstantPool ); END IF;
1054: IF ( code_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, CodeMemory ); END IF;
1055:

Line 1053: IF ( pool_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, ConstantPool ); END IF;

1049: IF ( pool_ptr + code_ptr > 0 ) THEN
1050:
1051: DBMS_LOB.CREATETEMPORARY ( l_loc, TRUE );
1052:
1053: IF ( pool_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, ConstantPool ); END IF;
1054: IF ( code_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, CodeMemory ); END IF;
1055:
1056: DBMS_LOB.WRITEAPPEND ( l_loc, 4, cz_fce_compile_utils.integer_raw ( pool_ptr ));
1057: DBMS_LOB.WRITEAPPEND ( l_loc, 4, const_file_signature );

Line 1054: IF ( code_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, CodeMemory ); END IF;

1050:
1051: DBMS_LOB.CREATETEMPORARY ( l_loc, TRUE );
1052:
1053: IF ( pool_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, ConstantPool ); END IF;
1054: IF ( code_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, CodeMemory ); END IF;
1055:
1056: DBMS_LOB.WRITEAPPEND ( l_loc, 4, cz_fce_compile_utils.integer_raw ( pool_ptr ));
1057: DBMS_LOB.WRITEAPPEND ( l_loc, 4, const_file_signature );
1058:

Line 1056: DBMS_LOB.WRITEAPPEND ( l_loc, 4, cz_fce_compile_utils.integer_raw ( pool_ptr ));

1052:
1053: IF ( pool_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, ConstantPool ); END IF;
1054: IF ( code_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, CodeMemory ); END IF;
1055:
1056: DBMS_LOB.WRITEAPPEND ( l_loc, 4, cz_fce_compile_utils.integer_raw ( pool_ptr ));
1057: DBMS_LOB.WRITEAPPEND ( l_loc, 4, const_file_signature );
1058:
1059: IF ( this_segment_nbr = 1 ) THEN
1060:

Line 1057: DBMS_LOB.WRITEAPPEND ( l_loc, 4, const_file_signature );

1053: IF ( pool_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, ConstantPool ); END IF;
1054: IF ( code_ptr > 0 ) THEN DBMS_LOB.APPEND ( l_loc, CodeMemory ); END IF;
1055:
1056: DBMS_LOB.WRITEAPPEND ( l_loc, 4, cz_fce_compile_utils.integer_raw ( pool_ptr ));
1057: DBMS_LOB.WRITEAPPEND ( l_loc, 4, const_file_signature );
1058:
1059: IF ( this_segment_nbr = 1 ) THEN
1060:
1061: SELECT cz_fce_files_s.NEXTVAL INTO this_file_id FROM DUAL;

Line 1156: DBMS_LOB.WRITEAPPEND ( ConstantPool, l_len, p_data );

1152: IF ( l_data_len >= const_constantpool_buffersize ) THEN
1153:
1154: flush_constant_pool ();
1155:
1156: DBMS_LOB.WRITEAPPEND ( ConstantPool, l_len, p_data );
1157:
1158: ConstantPool_buffer := NULL;
1159: pool_buffer_ptr := 0;
1160:

Line 1224: DBMS_LOB.TRIM ( ConstantPool, 0 );

1220: --already been saved to the database, for example segment switching occured in
1221: --in the middle of a rule generation, and this rule has to be rolled back. The
1222: --previous segment nees to be restored in memory from the database.
1223:
1224: DBMS_LOB.TRIM ( ConstantPool, 0 );
1225: DBMS_LOB.TRIM ( CodeMemory, 0 );
1226:
1227: SELECT fce_file INTO l_fce_file FROM cz_fce_files
1228: WHERE deleted_flag = '0'

Line 1225: DBMS_LOB.TRIM ( CodeMemory, 0 );

1221: --in the middle of a rule generation, and this rule has to be rolled back. The
1222: --previous segment nees to be restored in memory from the database.
1223:
1224: DBMS_LOB.TRIM ( ConstantPool, 0 );
1225: DBMS_LOB.TRIM ( CodeMemory, 0 );
1226:
1227: SELECT fce_file INTO l_fce_file FROM cz_fce_files
1228: WHERE deleted_flag = '0'
1229: AND component_id = p_component_id

Line 1236: l_size := UTL_RAW.CAST_TO_BINARY_INTEGER ( DBMS_LOB.SUBSTR ( l_fce_file, 4, DBMS_LOB.GETLENGTH ( l_fce_file ) - 7 ));

1232:
1233: --According to the logic file format, second four bytes from the end store the
1234: --size of the Constant Pool.
1235:
1236: l_size := UTL_RAW.CAST_TO_BINARY_INTEGER ( DBMS_LOB.SUBSTR ( l_fce_file, 4, DBMS_LOB.GETLENGTH ( l_fce_file ) - 7 ));
1237: l_tail := DBMS_LOB.GETLENGTH ( l_fce_file ) - 8 - l_size;
1238:
1239: IF ( l_size > 0 ) THEN ConstantPool := DBMS_LOB.SUBSTR ( l_fce_file, l_size, 1 ); END IF;
1240: IF ( l_tail > 0 ) THEN CodeMemory := DBMS_LOB.SUBSTR ( l_fce_file, l_tail, l_size + 1 ); END IF;

Line 1237: l_tail := DBMS_LOB.GETLENGTH ( l_fce_file ) - 8 - l_size;

1233: --According to the logic file format, second four bytes from the end store the
1234: --size of the Constant Pool.
1235:
1236: l_size := UTL_RAW.CAST_TO_BINARY_INTEGER ( DBMS_LOB.SUBSTR ( l_fce_file, 4, DBMS_LOB.GETLENGTH ( l_fce_file ) - 7 ));
1237: l_tail := DBMS_LOB.GETLENGTH ( l_fce_file ) - 8 - l_size;
1238:
1239: IF ( l_size > 0 ) THEN ConstantPool := DBMS_LOB.SUBSTR ( l_fce_file, l_size, 1 ); END IF;
1240: IF ( l_tail > 0 ) THEN CodeMemory := DBMS_LOB.SUBSTR ( l_fce_file, l_tail, l_size + 1 ); END IF;
1241:

Line 1239: IF ( l_size > 0 ) THEN ConstantPool := DBMS_LOB.SUBSTR ( l_fce_file, l_size, 1 ); END IF;

1235:
1236: l_size := UTL_RAW.CAST_TO_BINARY_INTEGER ( DBMS_LOB.SUBSTR ( l_fce_file, 4, DBMS_LOB.GETLENGTH ( l_fce_file ) - 7 ));
1237: l_tail := DBMS_LOB.GETLENGTH ( l_fce_file ) - 8 - l_size;
1238:
1239: IF ( l_size > 0 ) THEN ConstantPool := DBMS_LOB.SUBSTR ( l_fce_file, l_size, 1 ); END IF;
1240: IF ( l_tail > 0 ) THEN CodeMemory := DBMS_LOB.SUBSTR ( l_fce_file, l_tail, l_size + 1 ); END IF;
1241:
1242: this_segment_nbr := segment_nbr_svp;
1243:

Line 1240: IF ( l_tail > 0 ) THEN CodeMemory := DBMS_LOB.SUBSTR ( l_fce_file, l_tail, l_size + 1 ); END IF;

1236: l_size := UTL_RAW.CAST_TO_BINARY_INTEGER ( DBMS_LOB.SUBSTR ( l_fce_file, 4, DBMS_LOB.GETLENGTH ( l_fce_file ) - 7 ));
1237: l_tail := DBMS_LOB.GETLENGTH ( l_fce_file ) - 8 - l_size;
1238:
1239: IF ( l_size > 0 ) THEN ConstantPool := DBMS_LOB.SUBSTR ( l_fce_file, l_size, 1 ); END IF;
1240: IF ( l_tail > 0 ) THEN CodeMemory := DBMS_LOB.SUBSTR ( l_fce_file, l_tail, l_size + 1 ); END IF;
1241:
1242: this_segment_nbr := segment_nbr_svp;
1243:
1244: ELSE

Line 1254: DBMS_LOB.TRIM ( CodeMemory, code_ptr_svp );

1250:
1251: code_ptr := code_ptr_svp;
1252: pool_ptr := pool_ptr_svp;
1253:
1254: DBMS_LOB.TRIM ( CodeMemory, code_ptr_svp );
1255: DBMS_LOB.TRIM ( ConstantPool, pool_ptr_svp );
1256:
1257: CodeMemory_buffer := NULL;
1258: code_buffer_ptr := 0;

Line 1255: DBMS_LOB.TRIM ( ConstantPool, pool_ptr_svp );

1251: code_ptr := code_ptr_svp;
1252: pool_ptr := pool_ptr_svp;
1253:
1254: DBMS_LOB.TRIM ( CodeMemory, code_ptr_svp );
1255: DBMS_LOB.TRIM ( ConstantPool, pool_ptr_svp );
1256:
1257: CodeMemory_buffer := NULL;
1258: code_buffer_ptr := 0;
1259: