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

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

1422: l_str10 := '';
1423: l_str11 := '';
1424:
1425:
1426: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1427: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1428:
1429: current_index := 0;
1430:

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

1423: l_str11 := '';
1424:
1425:
1426: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1427: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1428:
1429: current_index := 0;
1430:
1431: IF xml_tab.count > 0 THEN

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

1429: current_index := 0;
1430:
1431: IF xml_tab.count > 0 THEN
1432:
1433: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1434:
1435:
1436: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST LOOP
1437:

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

1441: IF l_str9 IN ('FILE_HEADER_FOOTER_START', 'FILE_HEADER_FOOTER_END','ABSENCE_RECO_START' ,'ABSENCE_RECO_END')
1442: THEN
1443:
1444: IF l_str9 IN ('FILE_HEADER_FOOTER_START' , 'ABSENCE_RECO_START' ) THEN
1445: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1446: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1447: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1448: ELSE
1449: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

1442: THEN
1443:
1444: IF l_str9 IN ('FILE_HEADER_FOOTER_START' , 'ABSENCE_RECO_START' ) THEN
1445: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1446: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1447: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1448: ELSE
1449: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1450: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

1443:
1444: IF l_str9 IN ('FILE_HEADER_FOOTER_START' , 'ABSENCE_RECO_START' ) THEN
1445: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1446: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1447: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1448: ELSE
1449: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1450: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1451: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

1445: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1446: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1447: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1448: ELSE
1449: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1450: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1451: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1452: END IF;
1453:

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

1446: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1447: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1448: ELSE
1449: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1450: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1451: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1452: END IF;
1453:
1454: ELSE

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

1447: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1448: ELSE
1449: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1450: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1451: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1452: END IF;
1453:
1454: ELSE
1455:

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

1454: ELSE
1455:
1456: if l_str9 is not null then
1457: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
1458: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1460: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1461: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1462: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

1455:
1456: if l_str9 is not null then
1457: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
1458: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1460: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1461: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1462: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1463: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

1456: if l_str9 is not null then
1457: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
1458: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1460: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1461: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1462: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1463: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1464: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

1457: l_str9 := hr_dk_utility.REPLACE_SPECIAL_CHARS(l_str9); /* Place the check after not null check*/
1458: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1460: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1461: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1462: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1463: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1464: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1465: else

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

1458: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1460: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1461: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1462: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1463: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1464: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1465: else
1466:

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

1459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1460: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1461: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1462: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1463: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1464: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1465: else
1466:
1467: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

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

1460: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1461: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
1462: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1463: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1464: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1465: else
1466:
1467: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1468: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

1463: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1464: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1465: else
1466:
1467: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1468: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1469: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1470: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1471: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

1464: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1465: else
1466:
1467: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1468: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1469: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1470: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1471: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1472: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

1465: else
1466:
1467: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1468: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1469: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1470: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1471: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1472: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1473:

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

1466:
1467: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1468: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1469: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1470: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1471: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1472: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1473:
1474: end if;

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

1467: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1468: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1469: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1470: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1471: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1472: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1473:
1474: end if;
1475:

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

1468: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1469: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
1470: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
1471: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1472: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
1473:
1474: end if;
1475:
1476: END IF;

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

1476: END IF;
1477:
1478: END LOOP;
1479:
1480: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1481:
1482: ELSE
1483: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1484: END IF;

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

1479:
1480: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
1481:
1482: ELSE
1483: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1484: END IF;
1485:
1486: p_xfdf_clob := l_xfdf_string;
1487: