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

Line 1639: l_len := DBMS_LOB.GETLENGTH (l_file);

1635: FROM gmp_pdr_xml_temp
1636: WHERE pdr_xml_id = p_sequence_num;
1637: l_limit:= 1;
1638:
1639: l_len := DBMS_LOB.GETLENGTH (l_file);
1640: LOOP
1641: IF l_len > l_limit THEN
1642: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.
1643: --Introduced another clob variable m_file and after trimming it assigned to the varchar type variable.

Line 1642: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.

1638:
1639: l_len := DBMS_LOB.GETLENGTH (l_file);
1640: LOOP
1641: IF l_len > l_limit THEN
1642: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.
1643: --Introduced another clob variable m_file and after trimming it assigned to the varchar type variable.
1644: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1645: M_FILE := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1646: file_varchar2:=trim(M_FILE);

Line 1644: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);

1640: LOOP
1641: IF l_len > l_limit THEN
1642: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.
1643: --Introduced another clob variable m_file and after trimming it assigned to the varchar type variable.
1644: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1645: M_FILE := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1646: file_varchar2:=trim(M_FILE);
1647: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
1648: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);

Line 1645: M_FILE := DBMS_LOB.SUBSTR (l_file,10,l_limit);

1641: IF l_len > l_limit THEN
1642: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.
1643: --Introduced another clob variable m_file and after trimming it assigned to the varchar type variable.
1644: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1645: M_FILE := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1646: file_varchar2:=trim(M_FILE);
1647: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
1648: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
1649: file_varchar2 := NULL;

Line 1653: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);

1649: file_varchar2 := NULL;
1650: m_file :=NULL;
1651: l_limit:= l_limit + 10;
1652: ELSE
1653: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1654: M_FILE := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1655: file_varchar2:=trim(M_FILE);
1656: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
1657: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);

Line 1654: M_FILE := DBMS_LOB.SUBSTR (l_file,10,l_limit);

1650: m_file :=NULL;
1651: l_limit:= l_limit + 10;
1652: ELSE
1653: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1654: M_FILE := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1655: file_varchar2:=trim(M_FILE);
1656: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
1657: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
1658: file_varchar2 := NULL;