1 PACKAGE pay_hxc_deposit_interface AS
2 /* $Header: pyhxcdpi.pkh 120.0.12010000.2 2008/08/06 07:23:44 ubhat ship $ */
3
4 TYPE r_full_name is RECORD(
5 person_id NUMBER(9),
6 full_name VARCHAR2(240),
7 effective_start_date date,
8 effective_end_date date
9 );
10 TYPE t_full_name is table of r_full_name index by binary_integer;
11 g_full_name_ct t_full_name;
12
13 TYPE r_asg is RECORD(
14 effective_start_date date,
15 effective_end_date date,
16 assignment_id number(9),
17 business_group_id number(9),
18 cost_allocation_structure varchar2(150)
19 );
20 TYPE t_asg is table of r_asg index by binary_integer;
21 g_asg_ct t_asg;
22
23 user_language varchar2(4);
24
25 TYPE r_ele_type is RECORD(
26 element_name VARCHAR2(80),
27 effective_start_date date,
28 effective_end_date date
29 );
30
31 TYPE t_ele_type is TABLE OF r_ele_type INDEX BY BINARY_INTEGER;
32 g_ele_type_ct t_ele_type;
33
34 TYPE r_iv_map is RECORD(
35 effective_start_date date,
36 effective_end_date date,
37 start_index BINARY_INTEGER,
38 stop_index BINARY_INTEGER
39 );
40 TYPE t_iv_map IS TABLE OF r_iv_map INDEX BY BINARY_INTEGER;
41 g_iv_map_ct t_iv_map;
42
43
44 TYPE r_iv_lk_map IS RECORD(
45 iv_name pay_input_values_f.name%TYPE,
46 lcode HR_LOOKUPS.lookup_code%TYPE
47 );
48 TYPE t_iv_lk_map IS TABLE OF r_iv_lk_map INDEX BY BINARY_INTEGER;
49 g_iv_lk_map_ct t_iv_lk_map;
50
51 TYPE r_ivn IS RECORD(
52 element_type_id NUMBER(9),
53 field_name VARCHAR2(80),
54 ipv_name PAY_INPUT_VALUES_F.NAME%TYPE
55 );
56 TYPE t_ivn is TABLE OF r_ivn INDEX BY BINARY_INTEGER;
57 g_ivn_ct t_ivn;
58
59 TYPE r_link is RECORD(
60 assignment_id NUMBER(9),
61 element_type_id NUMBER(9),
62 effective_date date,
63 element_link_id NUMBER(9)
64 );
65 TYPE t_link IS TABLE OF r_link INDEX BY BINARY_INTEGER;
66 g_link_ct t_link;
67
68
69 TYPE r_iv_mapping IS RECORD (
70 iv_name pay_input_values_f.name%TYPE
71 , iv_id pay_input_values_f.input_value_id%TYPE
72 , iv_seq pay_input_values_f.display_sequence%TYPE
73 , iv_uom pay_input_values_f.uom%TYPE );
74 TYPE t_iv_mapping IS TABLE OF r_iv_mapping INDEX BY BINARY_INTEGER;
75 g_iv_mapping_ct t_iv_mapping;
76
77
78 -- TYPE r_canonical_iv_id IS RECORD ( flag VARCHAR2(1) );
79 -- TYPE t_canonical_iv_id IS TABLE OF r_canonical_iv_id INDEX BY BINARY_INTEGER;
80 TYPE t_canonical_iv_id IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
81
82 g_canonical_iv_id_tab t_canonical_iv_id;
83
84
85 FUNCTION pay_retrieval_process RETURN VARCHAR2;
86
87 FUNCTION hr_retrieval_process RETURN VARCHAR2;
88
89 PROCEDURE pay_validate_process
90 (p_operation IN VARCHAR2);
91
92 PROCEDURE pay_validate_timecard
93 (p_operation IN VARCHAR2
94 ,p_time_building_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
95 ,p_time_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
96 ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE);
97
98 PROCEDURE pay_update_process
99 (p_operation IN VARCHAR2);
100
101 PROCEDURE pay_update_timecard
102 (p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
103 p_blocks in hxc_self_service_time_deposit.timecard_info
104 );
105 END pay_hxc_deposit_interface;