DBA Data[Home] [Help]

APPS.PER_NL_WAZO_ARCHIVE dependencies on PAY_FILE_DETAILS

Line 1885: l_clob pay_file_details.file_fragment%TYPE;

1881: PROCEDURE gen_header_xml
1882: IS
1883: l_string VARCHAR2(32767) := NULL;
1884: l_string_value VARCHAR2(1000) := NULL;
1885: l_clob pay_file_details.file_fragment%TYPE;
1886: l_blob pay_file_details.blob_file_fragment%TYPE;
1887: l_payroll_action_id NUMBER;
1888: l_org_struct_id NUMBER := NULL;
1889: l_person_id NUMBER := NULL;

Line 1886: l_blob pay_file_details.blob_file_fragment%TYPE;

1882: IS
1883: l_string VARCHAR2(32767) := NULL;
1884: l_string_value VARCHAR2(1000) := NULL;
1885: l_clob pay_file_details.file_fragment%TYPE;
1886: l_blob pay_file_details.blob_file_fragment%TYPE;
1887: l_payroll_action_id NUMBER;
1888: l_org_struct_id NUMBER := NULL;
1889: l_person_id NUMBER := NULL;
1890: l_org_id NUMBER := NULL;

Line 2101: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;

2097: FROM fnd_product_groups;
2098: /**************************************************************************/
2099: --Variables--
2100:
2101: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2102: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2103: l_file UTL_FILE.FILE_TYPE;
2104: l_directory_path VARCHAR2(500);
2105: l_file_name VARCHAR2(50);

Line 2102: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;

2098: /**************************************************************************/
2099: --Variables--
2100:
2101: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2102: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2103: l_file UTL_FILE.FILE_TYPE;
2104: l_directory_path VARCHAR2(500);
2105: l_file_name VARCHAR2(50);
2106: x NUMBER := 0;