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

Line 1667: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);

1663: l_str10 := '';
1664: l_str11 := '';
1665:
1666:
1667: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1668: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1669:
1670: current_index := 0;
1671:

Line 1668: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

1664: l_str11 := '';
1665:
1666:
1667: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1668: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1669:
1670: current_index := 0;
1671:
1672: IF xml_tab.count > 0 THEN

Line 1674: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

1670: current_index := 0;
1671:
1672: IF xml_tab.count > 0 THEN
1673:
1674: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1675:
1676:
1677: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST LOOP
1678:

Line 1686: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

1682: IF l_str9 IN ('FILE_HEADER_START', 'FILE_HEADER_END','COST_RECO_START','COST_RECO_END'
1683: ,'COST_SEG_GRP_START','COST_SEG_GRP_END','EOY_CODE_GRP_START','EOY_CODE_GRP_END','COSTING_START','COSTING_END') THEN
1684:
1685: IF l_str9 IN ('FILE_HEADER_START','COST_RECO_START','EOY_CODE_GRP_START','COST_SEG_GRP_START','COSTING_START') THEN
1686: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1687: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1688: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1689: ELSE
1690: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

Line 1687: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1683: ,'COST_SEG_GRP_START','COST_SEG_GRP_END','EOY_CODE_GRP_START','EOY_CODE_GRP_END','COSTING_START','COSTING_END') THEN
1684:
1685: IF l_str9 IN ('FILE_HEADER_START','COST_RECO_START','EOY_CODE_GRP_START','COST_SEG_GRP_START','COSTING_START') THEN
1686: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1687: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1688: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1689: ELSE
1690: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1691: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 1688: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

1684:
1685: IF l_str9 IN ('FILE_HEADER_START','COST_RECO_START','EOY_CODE_GRP_START','COST_SEG_GRP_START','COSTING_START') THEN
1686: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1687: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1688: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1689: ELSE
1690: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1691: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1692: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

Line 1690: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

1686: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1687: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1688: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1689: ELSE
1690: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1691: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1692: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1693: END IF;
1694:

Line 1691: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1687: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1688: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1689: ELSE
1690: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1691: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1692: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1693: END IF;
1694:
1695: ELSE

Line 1692: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

1688: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1689: ELSE
1690: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1691: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1692: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1693: END IF;
1694:
1695: ELSE
1696:

Line 1699: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

1695: ELSE
1696:
1697: if l_str9 is not null then
1698:
1699: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1700: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1701: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1702: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1703: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

Line 1700: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1696:
1697: if l_str9 is not null then
1698:
1699: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1700: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1701: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1702: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1703: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1704: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 1701: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

1697: if l_str9 is not null then
1698:
1699: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1700: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1701: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1702: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1703: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1704: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1705: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

Line 1702: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);

1698:
1699: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1700: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1701: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1702: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1703: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1704: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1705: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1706: else

Line 1703: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

1699: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1700: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1701: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1702: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1703: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1704: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1705: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1706: else
1707:

Line 1704: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1700: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1701: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1702: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1703: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1704: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1705: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1706: else
1707:
1708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

Line 1705: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

1701: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1702: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1703: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1704: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1705: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1706: else
1707:
1708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1709: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 1708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

1704: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1705: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1706: else
1707:
1708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1709: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1711: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1712: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 1709: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1705: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1706: else
1707:
1708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1709: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1711: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1712: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1713: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

Line 1710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

1706: else
1707:
1708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1709: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1711: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1712: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1713: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1714:

Line 1711: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

1707:
1708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1709: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1711: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1712: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1713: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1714:
1715: end if;

Line 1712: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

1708: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1709: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1711: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1712: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1713: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1714:
1715: end if;
1716:

Line 1713: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

1709: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1710: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1711: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1712: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1713: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1714:
1715: end if;
1716:
1717: END IF;

Line 1721: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );

1717: END IF;
1718:
1719: END LOOP;
1720:
1721: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1722:
1723: ELSE
1724: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1725: END IF;

Line 1724: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );

1720:
1721: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1722:
1723: ELSE
1724: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1725: END IF;
1726:
1727: p_xfdf_clob := l_xfdf_string;
1728: