[Home] [Help]
PACKAGE: APPS.PER_ABSENCE_ATTENDANCES_PKG3
Source
1 PACKAGE PER_ABSENCE_ATTENDANCES_PKG3 AUTHID CURRENT_USER as
2 /* $Header: peaba03t.pkh 115.7 2004/04/05 03:16:21 kjagadee ship $ */
3
4 /*
5 MODIFIED (DD-MON-YYYY)
6
7 btailor 110.0 28-JUN-1995 Created.
8 ctredwin 110.1 01-OCT_1999 Added insert_abs_for_bee
9 dcasemor 115.2 20-NOV-2001 Added commit statement.
10 dcasemor 115.3 21-DEC-2001 Added dbdrv line.
11 dcasemor 115.4 14-AUG-2002 GSCC compliance - added WHENEVER OSERROR...
12 kjagadee 115.6 23-FEB-2004 Added overloaded proc for
13 insert_abs_for_bee
14 kjagadee 115.7 05-APR-2004 Bug 3506133, Modified procedure
15 insert_abs_for_bee(one which is called from BEE)
16 */
17
18 TYPE t_message_table IS TABLE OF VARCHAR2(30)
19 INDEX BY BINARY_INTEGER;
20
21 PROCEDURE insert_abs_for_paymix(p_session_date in date,
22 p_absence_att_type_id in number,
23 p_assignment_id in number,
24 p_absence_days in number,
25 p_absence_hours in number,
26 p_date_start in date,
27 p_date_end in date);
28 --
29 PROCEDURE insert_abs_for_bee(p_session_date in date,
30 p_absence_att_type_id in number,
31 p_assignment_id in number,
32 p_batch_id in number,
33 p_absence_days in number,
34 p_absence_hours in number,
35 p_date_start in date,
36 p_date_end in date,
37 p_absence_attendance_id out nocopy number,
38 p_warning_table out nocopy t_message_table,
39 p_error_table out nocopy t_message_table);
40 --
41 -- Overloaded procedure
42 procedure insert_abs_for_bee(
43 p_absence_att_type_id in number,
44 p_batch_id in number,
45 p_asg_act_id in number,
46 p_entry_values_count in number,
47 p_hours_or_days in varchar2,
48 p_format in varchar2,
49 p_value in varchar2,
50 p_date_start in date,
51 p_date_end in date,
52 p_line_record in pay_batch_lines%Rowtype,
53 p_passed_inp_tbl in hr_entry.number_table,
54 p_passed_val_tbl in hr_entry.varchar2_table,
55 p_absence_attendance_id out nocopy number,
56 p_warning_table out nocopy t_message_table,
57 p_error_table out nocopy t_message_table);
58 --
59 END PER_ABSENCE_ATTENDANCES_PKG3;