APPS.PER_NL_DSR_ARCHIVE dependencies on PAY_FILE_DETAILS

Line 2252: l_clob pay_file_details.file_fragment%TYPE;

2248: PROCEDURE gen_header_xml
2249: IS
2250: l_string VARCHAR2(32767) := NULL;
2251: l_string_value VARCHAR2(1000) := NULL;
2252: l_clob pay_file_details.file_fragment%TYPE;
2253: l_blob pay_file_details.blob_file_fragment%TYPE;
2254: l_payroll_action_id NUMBER;
2255: l_org_struct_id NUMBER := NULL;
2256: l_person_id NUMBER := NULL;

Line 2253: l_blob pay_file_details.blob_file_fragment%TYPE;

2249: IS
2250: l_string VARCHAR2(32767) := NULL;
2251: l_string_value VARCHAR2(1000) := NULL;
2252: l_clob pay_file_details.file_fragment%TYPE;
2253: l_blob pay_file_details.blob_file_fragment%TYPE;
2254: l_payroll_action_id NUMBER;
2255: l_org_struct_id NUMBER := NULL;
2256: l_person_id NUMBER := NULL;
2257: l_org_id NUMBER := NULL;

Line 2537: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;

2533: SELECT release_name
2534: FROM fnd_product_groups;
2535: /**************************************************************************/
2536: --Variables--
2537: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2538: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2539: l_file UTL_FILE.FILE_TYPE;
2540: l_directory_path VARCHAR2(500);
2541: l_file_name VARCHAR2(50);

Line 2538: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;

2534: FROM fnd_product_groups;
2535: /**************************************************************************/
2536: --Variables--
2537: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2538: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2539: l_file UTL_FILE.FILE_TYPE;
2540: l_directory_path VARCHAR2(500);
2541: l_file_name VARCHAR2(50);
2542: x NUMBER := 0;