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.PER_NL_LTSR_ARCHIVE dependencies on PAY_FILE_DETAILS

Line 1591: l_clob pay_file_details.file_fragment%TYPE;

1587: PROCEDURE gen_header_xml
1588: IS
1589: l_string VARCHAR2(32767) := NULL;
1590: l_string_value VARCHAR2(1000) := NULL;
1591: l_clob pay_file_details.file_fragment%TYPE;
1592: l_blob pay_file_details.blob_file_fragment%TYPE;
1593: l_payroll_action_id NUMBER;
1594: l_org_struct_id NUMBER := NULL;
1595: l_person_id NUMBER := NULL;

Line 1592: l_blob pay_file_details.blob_file_fragment%TYPE;

1588: IS
1589: l_string VARCHAR2(32767) := NULL;
1590: l_string_value VARCHAR2(1000) := NULL;
1591: l_clob pay_file_details.file_fragment%TYPE;
1592: l_blob pay_file_details.blob_file_fragment%TYPE;
1593: l_payroll_action_id NUMBER;
1594: l_org_struct_id NUMBER := NULL;
1595: l_person_id NUMBER := NULL;
1596: l_org_id NUMBER := NULL;

Line 1750: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;

1746: FROM fnd_product_groups;
1747: /**************************************************************************/
1748: --Variables--
1749:
1750: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1751: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1752: l_file UTL_FILE.FILE_TYPE;
1753: l_directory_path VARCHAR2(500);
1754: l_file_name VARCHAR2(50);

Line 1751: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;

1747: /**************************************************************************/
1748: --Variables--
1749:
1750: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1751: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1752: l_file UTL_FILE.FILE_TYPE;
1753: l_directory_path VARCHAR2(500);
1754: l_file_name VARCHAR2(50);
1755: x NUMBER := 0;