APPS.PAY_IE_EHECS_REPORT_PKG dependencies on DBMS_LOB

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

1720: IS
1721: pos PLS_INTEGER := 1;
1722: buffer RAW( 32767 );
1723: res BLOB;
1724: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
1725: BEGIN
1726: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);
1727: DBMS_LOB.createTemporary( res, TRUE );
1728: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );

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

1723: res BLOB;
1724: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
1725: BEGIN
1726: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);
1727: DBMS_LOB.createTemporary( res, TRUE );
1728: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
1729:
1730:
1731: LOOP

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

1724: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
1725: BEGIN
1726: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);
1727: DBMS_LOB.createTemporary( res, TRUE );
1728: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
1729:
1730:
1731: LOOP
1732: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );

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

1728: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
1729:
1730:
1731: LOOP
1732: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );
1733:
1734: IF UTL_RAW.LENGTH( buffer ) > 0 THEN
1735: DBMS_LOB.writeAppend( res, UTL_RAW.LENGTH( buffer ), buffer );
1736: END IF;

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

1731: LOOP
1732: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );
1733:
1734: IF UTL_RAW.LENGTH( buffer ) > 0 THEN
1735: DBMS_LOB.writeAppend( res, UTL_RAW.LENGTH( buffer ), buffer );
1736: END IF;
1737:
1738: pos := pos + 16000;
1739: EXIT WHEN pos > lob_len;