[Home] [Help]
PACKAGE: APPS.HR_JP_AST_UTILITY_PKG
Source
1 package hr_jp_ast_utility_pkg as
2 /* $Header: hrjpastu.pkh 120.0.12010000.1 2008/10/14 08:16:10 keyazawa noship $ */
3 --
4 -- Type Definition
5 --
6 type t_number_tbl is table of number index by binary_integer;
7 type t_varchar2_tbl is table of varchar2(255) index by binary_integer;
8 type t_date_tbl is table of date index by binary_integer;
9 type t_asg_rec is record(
10 assignment_id_tbl t_number_tbl,
11 effective_date_tbl t_date_tbl,
12 assignment_number_tbl t_varchar2_tbl,
13 full_name_tbl t_varchar2_tbl);
14 -- ----------------------------------------------------------------------------
15 -- |-----------------------< chk_assignment_set_name >------------------------|
16 -- ----------------------------------------------------------------------------
17 procedure chk_assignment_set_name(
18 p_assignment_set_name in varchar2,
19 p_business_group_id in number);
20 -- ----------------------------------------------------------------------------
21 -- |----------------------------< create_asg_set >----------------------------|
22 -- ----------------------------------------------------------------------------
23 procedure create_asg_set(
24 p_assignment_set_name in varchar2,
25 p_business_group_id in number,
26 p_payroll_id in number,
27 p_assignment_set_id out nocopy number);
28 -- ----------------------------------------------------------------------------
29 -- |--------------------< create_asg_set_with_request_id >--------------------|
30 -- ----------------------------------------------------------------------------
31 procedure create_asg_set_with_request_id(
32 p_prefix in varchar2,
33 p_business_group_id in number,
34 p_payroll_id in number,
35 p_assignment_set_id out nocopy number,
36 p_assignment_set_name out nocopy varchar2);
37 -- ----------------------------------------------------------------------------
38 -- |--------------------------< create_asg_set_amd >--------------------------|
39 -- ----------------------------------------------------------------------------
40 procedure create_asg_set_amd(
41 p_assignment_set_id in number,
42 p_assignment_id in number,
43 p_include_or_exclude in varchar2);
44 -- ----------------------------------------------------------------------------
45 -- |-----------------------< get_assignment_set_info >------------------------|
46 -- ----------------------------------------------------------------------------
47 procedure get_assignment_set_info(
48 p_assignment_set_id in number,
49 p_formula_id out nocopy number,
50 p_amendment_type out nocopy varchar2);
51 -- ----------------------------------------------------------------------------
52 -- |--------------------------< amendment_validate >--------------------------|
53 -- ----------------------------------------------------------------------------
54 function amendment_validate(
55 p_assignment_set_id in number,
56 p_assignment_id in number) return varchar2;
57 -- ----------------------------------------------------------------------------
58 -- |---------------------------< formula_validate >---------------------------|
59 -- ----------------------------------------------------------------------------
60 function formula_validate(
61 p_formula_id in number,
62 p_assignment_id in number,
63 p_effective_date in date,
64 p_populate_fs in boolean default false) return boolean;
65 -- ----------------------------------------------------------------------------
66 -- |------------------------< assignment_set_validate >------------------------|
67 -- ----------------------------------------------------------------------------
68 function assignment_set_validate(
69 p_assignment_set_id in number,
70 p_assignment_id in number,
71 p_effective_date in date,
72 p_populate_fs_flag in varchar2 default 'N') return varchar2;
73 -- ----------------------------------------------------------------------------
74 -- |-------------------------------< pay_asgs >-------------------------------|
75 -- ----------------------------------------------------------------------------
76 procedure pay_asgs(
77 p_payroll_id in number,
78 p_effective_date in date,
79 p_start_date in date,
80 p_end_date in date,
81 p_assignment_set_id in number,
82 p_asg_rec out nocopy t_asg_rec);
83 --
84 end hr_jp_ast_utility_pkg;