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_SE_HOLIDAY_PAY_DEBT dependencies on DBMS_LOB

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

1434: || l_iana_charset
1435: || '"?> ';
1436: l_str10 := '';
1437: l_str11 := '';
1438: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1439: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1440: current_index := 0;
1441:
1442: IF ghpd_data.COUNT > 0

Line 1439: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);

1435: || '"?> ';
1436: l_str10 := '';
1437: l_str11 := '';
1438: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1439: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1440: current_index := 0;
1441:
1442: IF ghpd_data.COUNT > 0
1443: THEN

Line 1444: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

1440: current_index := 0;
1441:
1442: IF ghpd_data.COUNT > 0
1443: THEN
1444: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1445:
1446: FOR table_counter IN ghpd_data.FIRST .. ghpd_data.LAST
1447: LOOP
1448: l_str8 := ghpd_data (table_counter).tagname;

Line 1465: DBMS_LOB.writeappend (l_xfdf_string

1461: THEN
1462: IF l_str9 IN
1463: ('LEGAL_EMPLOYER', 'LE_DETAILS', 'EMPLOYEES', 'PERSON')
1464: THEN
1465: DBMS_LOB.writeappend (l_xfdf_string
1466: , LENGTH (l_str2)
1467: , l_str2
1468: );
1469: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1469: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1465: DBMS_LOB.writeappend (l_xfdf_string
1466: , LENGTH (l_str2)
1467: , l_str2
1468: );
1469: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1470: , l_str8);
1471: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1472: , l_str3);
1473: ELSE

Line 1471: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

1467: , l_str2
1468: );
1469: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1470: , l_str8);
1471: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1472: , l_str3);
1473: ELSE
1474: DBMS_LOB.writeappend (l_xfdf_string
1475: , LENGTH (l_str4)

Line 1474: DBMS_LOB.writeappend (l_xfdf_string

1470: , l_str8);
1471: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1472: , l_str3);
1473: ELSE
1474: DBMS_LOB.writeappend (l_xfdf_string
1475: , LENGTH (l_str4)
1476: , l_str4
1477: );
1478: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1478: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1474: DBMS_LOB.writeappend (l_xfdf_string
1475: , LENGTH (l_str4)
1476: , l_str4
1477: );
1478: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1479: , l_str8);
1480: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1481: , l_str5);
1482: END IF;

Line 1480: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

1476: , l_str4
1477: );
1478: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1479: , l_str8);
1480: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1481: , l_str5);
1482: END IF;
1483: ELSE
1484: IF l_str9 IS NOT NULL

Line 1486: DBMS_LOB.writeappend (l_xfdf_string

1482: END IF;
1483: ELSE
1484: IF l_str9 IS NOT NULL
1485: THEN
1486: DBMS_LOB.writeappend (l_xfdf_string
1487: , LENGTH (l_str2)
1488: , l_str2
1489: );
1490: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1490: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1486: DBMS_LOB.writeappend (l_xfdf_string
1487: , LENGTH (l_str2)
1488: , l_str2
1489: );
1490: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1491: , l_str8);
1492: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1493: , l_str3);
1494: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

Line 1492: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

1488: , l_str2
1489: );
1490: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1491: , l_str8);
1492: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1493: , l_str3);
1494: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1495: , l_str9);
1496: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

Line 1494: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

1490: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1491: , l_str8);
1492: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1493: , l_str3);
1494: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1495: , l_str9);
1496: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1497: , l_str4);
1498: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1496: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

1492: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1493: , l_str3);
1494: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1495: , l_str9);
1496: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1497: , l_str4);
1498: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1499: , l_str8);
1500: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

Line 1498: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1494: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1495: , l_str9);
1496: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1497: , l_str4);
1498: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1499: , l_str8);
1500: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1501: , l_str5);
1502: ELSE

Line 1500: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

1496: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1497: , l_str4);
1498: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1499: , l_str8);
1500: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1501: , l_str5);
1502: ELSE
1503: DBMS_LOB.writeappend (l_xfdf_string
1504: , LENGTH (l_str2)

Line 1503: DBMS_LOB.writeappend (l_xfdf_string

1499: , l_str8);
1500: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1501: , l_str5);
1502: ELSE
1503: DBMS_LOB.writeappend (l_xfdf_string
1504: , LENGTH (l_str2)
1505: , l_str2
1506: );
1507: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1507: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1503: DBMS_LOB.writeappend (l_xfdf_string
1504: , LENGTH (l_str2)
1505: , l_str2
1506: );
1507: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1508: , l_str8);
1509: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1510: , l_str3);
1511: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

Line 1509: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

1505: , l_str2
1506: );
1507: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1508: , l_str8);
1509: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1510: , l_str3);
1511: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1512: , l_str4);
1513: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1511: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

1507: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1508: , l_str8);
1509: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1510: , l_str3);
1511: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1512: , l_str4);
1513: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1514: , l_str8);
1515: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

Line 1513: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1509: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1510: , l_str3);
1511: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1512: , l_str4);
1513: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1514: , l_str8);
1515: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1516: , l_str5);
1517: END IF;

Line 1515: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

1511: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1512: , l_str4);
1513: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1514: , l_str8);
1515: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1516: , l_str5);
1517: END IF;
1518: END IF;
1519: END LOOP;

Line 1521: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);

1517: END IF;
1518: END IF;
1519: END LOOP;
1520:
1521: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1522: ELSE
1523: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1524: END IF;
1525:

Line 1523: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);

1519: END LOOP;
1520:
1521: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1522: ELSE
1523: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1524: END IF;
1525:
1526: p_xfdf_clob := l_xfdf_string;
1527: hr_utility.set_location ('Leaving WritetoCLOB ', 40);