PACKAGE: APPS.PAY_JP_SOE_PKG

Source

1 package PAY_JP_SOE_PKG as
2 /* $Header: pyjpsoe.pkh 120.1 2006/12/11 07:28:19 ttagawa noship $ */
3 -------------------------------------------------------------------------------
4 TYPE lock_status_t is RECORD(
5 	lock_status     varchar2(30),
6 	action_status   varchar2(30));
7 -------------------------------------------------------------------------------
8 TYPE lock_action_t is RECORD(
9 	assignment_action_id    number,
10         action_status           varchar2(30),
11         object_version_number   number,
12         payroll_action_id       number,
13         action_type             varchar2(30),
14         effective_date          date);
15 -------------------------------------------------------------------------------
16 FUNCTION messages_exist_flag(
17 	p_source_id		IN NUMBER,
18 	p_source_type		IN VARCHAR2) RETURN VARCHAR2;
19 -------------------------------------------------------------------------------
20 FUNCTION retro_entries_processed_flag(p_creator_id IN NUMBER) RETURN VARCHAR2;
21 -------------------------------------------------------------------------------
22 FUNCTION entry_processed_flag(
23 	p_element_entry_id	IN NUMBER,
24 	p_effective_start_date	IN DATE,
25 	p_effective_end_date	IN DATE) RETURN VARCHAR2;
26 -------------------------------------------------------------------------------
27 Function lock_action(
28 	p_locked_action_id	IN NUMBER,
29 	p_locking_action_type	IN VARCHAR2) return lock_action_t;
30 -------------------------------------------------------------------------------
31 Function lock_status(
32 	p_locked_action_id	IN NUMBER,
33 	p_locking_action_type	IN VARCHAR2) return lock_status_t;
34 -------------------------------------------------------------------------------
35 Function get_lock_action_val(
36 	p_locked_action_id	IN NUMBER,
37 	p_locking_action_type	IN VARCHAR2,
38 	p_attribute		IN VARCHAR2) return VARCHAR2;
39 -------------------------------------------------------------------------------
40 Function get_lock_action_num(
41 	p_locked_action_id	IN NUMBER,
42 	p_locking_action_type	IN VARCHAR2,
43 	p_attribute		IN VARCHAR2) return NUMBER;
44 -------------------------------------------------------------------------------
45 Function get_lock_status_val(
46 	p_locked_action_id	IN NUMBER,
47 	p_locking_action_type	IN VARCHAR2,
48 	p_attribute		IN VARCHAR2) return VARCHAR2;
49 -------------------------------------------------------------------------------
50 PROCEDURE lock_row(
51 	p_assignment_action_id	IN NUMBER,
52 	p_object_version_number	IN NUMBER);
53 -------------------------------------------------------------------------------
54 PROCEDURE rollback(
55 	p_validate		IN BOOLEAN DEFAULT FALSE,
56 	p_rollback_mode		IN VARCHAR2,
57 	p_assignment_action_id	IN NUMBER,
58 	p_payroll_action_id	IN NUMBER,
59 	p_action_type		IN VARCHAR2);
60 -------------------------------------------------------------------------------
61 PROCEDURE reverse_assact(
62 	p_assignment_action_id	IN NUMBER);
63 -------------------------------------------------------------------------------
64 PROCEDURE run_attributes(
65 	p_assignment_action_id	IN NUMBER,
66 	p_itax_category		OUT NOCOPY VARCHAR2,
67 	p_d_itax_category	OUT NOCOPY VARCHAR2,
68 	p_yea_category		OUT NOCOPY VARCHAR2,
69 	p_d_yea_category	OUT NOCOPY VARCHAR2,
70 	p_allowance_ytd		OUT NOCOPY NUMBER,
71 	p_taxable_ytd		OUT NOCOPY NUMBER,
72 	p_si_prem_ytd		OUT NOCOPY NUMBER,
73 	p_itax_ytd		OUT NOCOPY NUMBER);
74 -------------------------------------------------------------------------------
75 FUNCTION get_effective_date(
76 	p_effective_date	IN DATE,
77 	p_assignment_id		IN NUMBER) return DATE;
78 -------------------------------------------------------------------------------
79 end pay_jp_soe_pkg;