APPS.PER_NL_DSRR_ARCHIVE dependencies on PAY_FILE_DETAILS

Line 1638: l_clob pay_file_details.file_fragment%TYPE;

1634: PROCEDURE gen_header_xml
1635: IS
1636: l_string VARCHAR2(32767) := NULL;
1637: l_string_value VARCHAR2(1000) := NULL;
1638: l_clob pay_file_details.file_fragment%TYPE;
1639: l_blob pay_file_details.blob_file_fragment%TYPE;
1640: l_payroll_action_id NUMBER;
1641: l_org_struct_id NUMBER := NULL;
1642: l_person_id NUMBER := NULL;

Line 1639: l_blob pay_file_details.blob_file_fragment%TYPE;

1635: IS
1636: l_string VARCHAR2(32767) := NULL;
1637: l_string_value VARCHAR2(1000) := NULL;
1638: l_clob pay_file_details.file_fragment%TYPE;
1639: l_blob pay_file_details.blob_file_fragment%TYPE;
1640: l_payroll_action_id NUMBER;
1641: l_org_struct_id NUMBER := NULL;
1642: l_person_id NUMBER := NULL;
1643: l_org_id NUMBER := NULL;

Line 1796: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;

1792: SELECT release_name
1793: FROM fnd_product_groups;
1794: /**************************************************************************/
1795: --Variables--
1796: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1797: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1798: l_file UTL_FILE.FILE_TYPE;
1799: l_directory_path VARCHAR2(500);
1800: l_file_name VARCHAR2(50);

Line 1797: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;

1793: FROM fnd_product_groups;
1794: /**************************************************************************/
1795: --Variables--
1796: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1797: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1798: l_file UTL_FILE.FILE_TYPE;
1799: l_directory_path VARCHAR2(500);
1800: l_file_name VARCHAR2(50);
1801: x NUMBER := 0;