APPS.PAY_IE_EHECS_REPORT_PKG dependencies on DBMS_LOB

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

2003: IS
2004: pos PLS_INTEGER := 1;
2005: buffer RAW( 32767 );
2006: res BLOB;
2007: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
2008: BEGIN
2009: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);
2010: DBMS_LOB.createTemporary( res, TRUE );
2011: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );

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

2006: res BLOB;
2007: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
2008: BEGIN
2009: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);
2010: DBMS_LOB.createTemporary( res, TRUE );
2011: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
2012:
2013:
2014: LOOP

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

2007: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
2008: BEGIN
2009: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);
2010: DBMS_LOB.createTemporary( res, TRUE );
2011: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
2012:
2013:
2014: LOOP
2015: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );

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

2011: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
2012:
2013:
2014: LOOP
2015: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );
2016:
2017: IF UTL_RAW.LENGTH( buffer ) > 0 THEN
2018: DBMS_LOB.writeAppend( res, UTL_RAW.LENGTH( buffer ), buffer );
2019: END IF;

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

2014: LOOP
2015: buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( c, 16000, pos ) );
2016:
2017: IF UTL_RAW.LENGTH( buffer ) > 0 THEN
2018: DBMS_LOB.writeAppend( res, UTL_RAW.LENGTH( buffer ), buffer );
2019: END IF;
2020:
2021: pos := pos + 16000;
2022: EXIT WHEN pos > lob_len;