APPS.PAY_IE_CESS_REPORT dependencies on DBMS_LOB

Line 52: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );

48: IS
49: pos PLS_INTEGER := 1;
50: buffer RAW( 32767 );
51: res BLOB;
52: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
53: BEGIN
54: Hr_Utility.set_location('Entering: pay_ie_cess_report.c2b',260);
55: DBMS_LOB.createTemporary( res, TRUE );
56: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );

Line 55: DBMS_LOB.createTemporary( res, TRUE );

51: res BLOB;
52: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
53: BEGIN
54: Hr_Utility.set_location('Entering: pay_ie_cess_report.c2b',260);
55: DBMS_LOB.createTemporary( res, TRUE );
56: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
57:
58:
59: LOOP

Line 56: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );

52: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
53: BEGIN
54: Hr_Utility.set_location('Entering: pay_ie_cess_report.c2b',260);
55: DBMS_LOB.createTemporary( res, TRUE );
56: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
57:
58:
59: LOOP
60: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );

Line 60: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );

56: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
57:
58:
59: LOOP
60: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );
61:
62: IF UTL_RAW.LENGTH( buffer ) > 0 THEN
63: DBMS_LOB.writeAppend( res, UTL_RAW.LENGTH( buffer ), buffer );
64: END IF;

Line 63: DBMS_LOB.writeAppend( res, UTL_RAW.LENGTH( buffer ), buffer );

59: LOOP
60: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );
61:
62: IF UTL_RAW.LENGTH( buffer ) > 0 THEN
63: DBMS_LOB.writeAppend( res, UTL_RAW.LENGTH( buffer ), buffer );
64: END IF;
65:
66: pos := pos + 16000;
67: EXIT WHEN pos > lob_len;