[Home] [Help]
PACKAGE: APPS.BEN_PIL_ASSIGNMENT_API
Source
1 Package ben_pil_assignment_api as
2 /* $Header: bepsgapi.pkh 120.0 2005/09/29 06:20:11 ssarkar noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_pil_assignment >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 --
16 -- Out Parameters:
17 -- Name Reqd Type Description
18 -- p_pil_assignment_id Yes number PK of record
19 -- p_object_version_number No number OVN of record
20 --
21 -- Post Failure:
22 --
23 -- Access Status:
24 -- Public.
25 --
26 -- {End Of Comments}
27 --
28 procedure create_pil_assignment
29 (
30 p_validate in boolean default false
31 ,p_pil_assignment_id out nocopy number
32 ,p_per_in_ler_id in number default null
33 ,p_applicant_assignment_id in number default null
34 ,p_offer_assignment_id in number default null
35 ,p_object_version_number out nocopy number
36 );
37 -- ----------------------------------------------------------------------------
38 -- |------------------------< update_pil_assignment >------------------------|
39 -- ----------------------------------------------------------------------------
40 -- {Start Of Comments}
41 --
42 -- Description:
43 --
44 -- Prerequisites:
45 --
46 --
47 -- In Parameters:
48 --
49 -- Name Type Description
50 -- p_object_version_number No number OVN of record
51 --
52 -- Post Failure:
53 --
54 -- Access Status:
55 -- Public.
56 --
57 -- {End Of Comments}
58 --
59 procedure update_pil_assignment
60 (
61 p_validate in boolean default false
62 ,p_pil_assignment_id in number default hr_api.g_number
63 ,p_per_in_ler_id in number default hr_api.g_number
64 ,p_applicant_assignment_id in number default hr_api.g_number
65 ,p_offer_assignment_id in number default hr_api.g_number
66 ,p_object_version_number in out nocopy number
67 );
68 --
69 -- ----------------------------------------------------------------------------
70 -- |------------------------< delete_pil_assignment >------------------------|
71 -- ----------------------------------------------------------------------------
72 -- {Start Of Comments}
73 --
74 -- Description:
75 --
76 -- Prerequisites:
77 --
78 --
79 -- In Parameters:
80 -- Name Reqd Type Description
81 -- p_validate Yes boolean Commit or Rollback.
82 -- p_pil_assignment_id Yes number PK of record
83 --
84 -- Post Success:
85 --
86 -- Name Type Description
87 -- p_object_version_number No number OVN of record
88 --
89 -- Post Failure:
90 --
91 -- Access Status:
92 -- Public.
93 --
94 -- {End Of Comments}
95 --
96 procedure delete_pil_assignment
97 (
98 p_validate in boolean default false
99 ,p_pil_assignment_id in number
100 ,p_object_version_number in out nocopy number
101 );
102 --
103 -- ----------------------------------------------------------------------------
104 -- |----------------------------------< lck >---------------------------------|
105 -- ----------------------------------------------------------------------------
106 -- {Start Of Comments}
107 --
108 -- Description:
109 --
110 -- Prerequisites:
111 --
112 --
113 -- In Parameters:
114 -- Name Reqd Type Description
115 -- p_pil_assignment_id Yes number PK of record
116 -- p_object_version_number Yes number OVN of record
117 --
118 -- Post Success:
119 --
120 -- Name Type Description
121 --
122 -- Post Failure:
123 --
124 -- Access Status:
125 -- Public.
126 --
127 -- {End Of Comments}
128 --
129 procedure lck
130 (
131 p_pil_assignment_id in number
132 ,p_object_version_number in number
133 );
134 --
135 end ben_pil_assignment_api;