[Home] [Help]
19: Name Vers Date Notes
20: --------- ----- ----------- --------------------------------------------------
21: cadams 40.0 12-Feb-1996 Created
22: cadams 40.1 13-Mar-1996 Changed report output from dbms_output to
23: PAY_MESSAGE_LINES and added code to commit
24: after every CHUNK_SIZE employers/employees
25: cadams 40.2 15-Mar-1996 Added explicit deletion of assignment actions
26: to rollback code
27: ramurthy 40.3 17-Apr-1996 Made some changes to the way the Archive
373: --
374: --==============================================================================
375: -- ARCH_OUTPUT
376: --
377: -- Output a report line to pay_message_lines
378: --==============================================================================
379: PROCEDURE arch_output (p_line VARCHAR2) IS
380: BEGIN
381: hr_utility.set_location ('arch_output',1);
379: PROCEDURE arch_output (p_line VARCHAR2) IS
380: BEGIN
381: hr_utility.set_location ('arch_output',1);
382: --
383: INSERT INTO pay_message_lines
384: ( line_sequence, payroll_id, message_level,
385: source_id, source_type, line_text )
386: VALUES
387: ( pay_message_lines_s.nextval,
383: INSERT INTO pay_message_lines
384: ( line_sequence, payroll_id, message_level,
385: source_id, source_type, line_text )
386: VALUES
387: ( pay_message_lines_s.nextval,
388: NULL,
389: 'I',
390: l_payroll_action_id,
391: 'P',