1 Package irc_asg_status_swi As
2 /* $Header: iriasswi.pkh 120.0 2005/07/26 15:04:29 mbocutt noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-------------------------< create_irc_asg_status >-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: irc_asg_status_api.create_irc_asg_status
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_irc_asg_status
27 (p_validate in number default hr_api.g_false_num
28 ,p_assignment_id in number
29 ,p_assignment_status_type_id in number
30 ,p_status_change_date in date
31 ,p_status_change_reason in varchar2 default null
32 ,p_assignment_status_id in number
33 ,p_object_version_number out nocopy number
34 ,p_return_status out nocopy varchar2
35 );
36 -- ----------------------------------------------------------------------------
37 -- |-------------------------< delete_irc_asg_status >-------------------------|
38 -- ----------------------------------------------------------------------------
39 -- {Start of comments}
40 --
41 -- Description:
42 -- This procedure is the self-service wrapper procedure to the following
43 -- API: irc_asg_status_api.delete_irc_asg_status
44 --
45 -- Pre-requisites
46 -- All 'IN' parameters to this procedure have been appropriately derived.
47 --
48 -- Post Success:
49 -- p_return_status will return value indicating success.
50 --
51 -- Post Failure:
52 -- p_return_status will return value indication failure.
53 --
54 -- Access Status:
55 -- Internal Development use only.
56 --
57 -- {End of comments}
58 -- ----------------------------------------------------------------------------
59 PROCEDURE delete_irc_asg_status
60 (p_validate in number default hr_api.g_false_num
61 ,p_assignment_status_id in number
62 ,p_object_version_number in number
63 ,p_return_status out nocopy varchar2
64 );
65 -- ----------------------------------------------------------------------------
66 -- |-------------------------< update_irc_asg_status >-------------------------|
67 -- ----------------------------------------------------------------------------
68 -- {Start of comments}
69 --
70 -- Description:
71 -- This procedure is the self-service wrapper procedure to the following
72 -- API: irc_asg_status_api.update_irc_asg_status
73 --
74 -- Pre-requisites
75 -- All 'IN' parameters to this procedure have been appropriately derived.
76 --
77 -- Post Success:
78 -- p_return_status will return value indicating success.
79 --
80 -- Post Failure:
81 -- p_return_status will return value indication failure.
82 --
83 -- Access Status:
84 -- Internal Development use only.
85 --
86 -- {End of comments}
87 -- ----------------------------------------------------------------------------
88 PROCEDURE update_irc_asg_status
89 (p_validate in number default hr_api.g_false_num
90 ,p_status_change_reason in varchar2 default hr_api.g_varchar2
91 ,p_status_change_date in date
92 ,p_assignment_status_id in number
93 ,p_object_version_number in out nocopy number
94 ,p_return_status out nocopy varchar2
95 );
96 end irc_asg_status_swi;