2372:
2373: PROCEDURE gen_header_xml
2374: IS
2375: l_string varchar2(32767) := NULL;
2376: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2377: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2378:
2379: l_proc VARCHAR2(100);
2380: l_payroll_action_id number;
2373: PROCEDURE gen_header_xml
2374: IS
2375: l_string varchar2(32767) := NULL;
2376: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2377: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2378:
2379: l_proc VARCHAR2(100);
2380: l_payroll_action_id number;
2381: BEGIN
2420:
2421: PROCEDURE gen_body_xml
2422: IS
2423: l_string varchar2(32767) := NULL;
2424: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2425: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2426:
2427: l_payroll_action_id NUMBER;
2428: l_asg_action_id NUMBER;
2421: PROCEDURE gen_body_xml
2422: IS
2423: l_string varchar2(32767) := NULL;
2424: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2425: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2426:
2427: l_payroll_action_id NUMBER;
2428: l_asg_action_id NUMBER;
2429: