APPS.PER_NL_LTSRR_ARCHIVE dependencies on PAY_FILE_DETAILS

Line 1661: l_clob pay_file_details.file_fragment%TYPE;

1657: PROCEDURE gen_header_xml
1658: IS
1659: l_string VARCHAR2(32767) := NULL;
1660: l_string_value VARCHAR2(1000) := NULL;
1661: l_clob pay_file_details.file_fragment%TYPE;
1662: l_blob pay_file_details.blob_file_fragment%TYPE;
1663: l_payroll_action_id NUMBER;
1664: l_org_struct_id NUMBER := NULL;
1665: l_person_id NUMBER := NULL;

Line 1662: l_blob pay_file_details.blob_file_fragment%TYPE;

1658: IS
1659: l_string VARCHAR2(32767) := NULL;
1660: l_string_value VARCHAR2(1000) := NULL;
1661: l_clob pay_file_details.file_fragment%TYPE;
1662: l_blob pay_file_details.blob_file_fragment%TYPE;
1663: l_payroll_action_id NUMBER;
1664: l_org_struct_id NUMBER := NULL;
1665: l_person_id NUMBER := NULL;
1666: l_org_id NUMBER := NULL;

Line 1822: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;

1818: SELECT release_name
1819: FROM fnd_product_groups;
1820: /**************************************************************************/
1821: --Variables--
1822: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1823: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1824: l_file UTL_FILE.FILE_TYPE;
1825: l_directory_path VARCHAR2(500);
1826: l_file_name VARCHAR2(50);

Line 1823: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;

1819: FROM fnd_product_groups;
1820: /**************************************************************************/
1821: --Variables--
1822: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1823: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1824: l_file UTL_FILE.FILE_TYPE;
1825: l_directory_path VARCHAR2(500);
1826: l_file_name VARCHAR2(50);
1827: x NUMBER := 0;