1 Package hr_psf_del AUTHID CURRENT_USER as
2 /* $Header: hrpsfrhi.pkh 120.3.12020000.2 2013/04/19 03:06:04 pathota ship $ */
3 --
4 --
5 g_debug boolean := hr_utility.debug_enabled;
6 --
7 --
8 --
9 -- ----------------------------------------------------------------------------
10 -- |------------------------------< delete_dml >------------------------------|
11 -- ----------------------------------------------------------------------------
12 -- {Start Of Comments}
13 --
14 -- Description:
15 -- This procedure calls the dt_delete_dml control logic which handles
16 -- the actual datetrack dml.
17 --
18 -- Prerequisites:
19 -- This is an internal private procedure which must be called from the del
20 -- procedure.
21 --
22 -- In Parameters:
23 -- A Pl/Sql record structre.
24 --
25 -- Post Success:
26 -- Processing contines.
27 --
28 -- Post Failure:
29 -- No specific error handling is required within this procedure.
30 --
31 -- Developer Implementation Notes:
32 -- None.
33 --
34 -- Access Status:
35 -- Internal Row Handler Use Only.
36 --
37 -- {End Of Comments}
38 -- ----------------------------------------------------------------------------
39 Procedure delete_dml
40 (p_rec in out nocopy hr_psf_shd.g_rec_type,
41 p_effective_date in date,
42 p_datetrack_mode in varchar2,
43 p_validation_start_date in date,
44 p_validation_end_date in date);
45 --
46 -- ----------------------------------------------------------------------------
47 -- |---------------------------------< del >----------------------------------|
48 -- ----------------------------------------------------------------------------
49 -- {Start Of Comments}
50 --
51 -- Description:
52 -- This procedure is the record interface for the datetrack delete
53 -- process for the specified entity. The role of this
54 -- process is to delete the dateracked row from the HR schema.
55 -- This process is the main backbone of the del business process. The
56 -- processing of this procedure is as follows:
57 -- 1) Ensure that the datetrack delete mode is valid.
58 -- 2) The controlling validation process delete_validate is then executed
59 -- which will execute all private and public validation business rule
60 -- processes.
61 -- 3) The pre_delete process is then executed which enables any
62 -- logic to be processed before the delete dml process is executed.
63 -- 4) The delete_dml process will physical perform the delete dml for the
64 -- specified row.
65 -- 5) The post_delete process is then executed which enables any
66 -- logic to be processed after the delete dml process.
67 --
68 -- Prerequisites:
69 -- The main parameters to the business process have to be in the record
70 -- format.
71 --
72 -- In Parameters:
73 -- p_effective_date
74 -- Specifies the date of the datetrack update operation.
75 -- p_datetrack_mode
76 -- Determines the datetrack update mode.
77 --
78 -- Post Success:
79 -- The specified row will be fully validated and deleted for the specified
80 -- entity without being committed.
81 --
82 -- Post Failure:
83 -- If an error has occurred, an error message will be supplied with the work
84 -- rolled back.
85 --
86 -- Developer Implementation Notes:
87 -- None.
88 --
89 -- Access Status:
90 -- Internal Development Use Only.
91 --
92 -- {End Of Comments}
93 -- ----------------------------------------------------------------------------
94 Procedure del
95 (
96 p_rec in out nocopy hr_psf_shd.g_rec_type,
97 p_effective_date in date,
98 p_datetrack_mode in varchar2,
99 p_validate in boolean default false
100 );
101 --
102 -- ----------------------------------------------------------------------------
103 -- |---------------------------------< del >----------------------------------|
104 -- ----------------------------------------------------------------------------
105 -- {Start Of Comments}
106 --
107 -- Description:
108 -- This procedure is the attribute interface for the delete
109 -- process for the specified entity and is the outermost layer. The role
110 -- of this process is to validate and delete the specified row from the
111 -- HR schema. The processing of this procedure is as follows:
112 -- 1) The attributes are converted into a local record structure by
113 -- explicitly coding the attribute parameters into the g_rec_type
114 -- datatype.
115 -- 2) After the conversion has taken place, the corresponding record del
116 -- interface business process is executed.
117 --
118 -- Prerequisites:
119 --
120 -- In Parameters:
121 -- p_effective_date
122 -- Specifies the date of the datetrack update operation.
123 -- p_datetrack_mode
124 -- Determines the datetrack update mode.
125 --
126 -- Post Success:
127 -- The specified row will be fully validated and deleted for the specified
128 -- entity without being committed.
129 --
130 -- Post Failure:
131 -- If an error has occurred, an error message will be supplied with the work
132 -- rolled back.
133 --
134 -- Developer Implementation Notes:
135 -- The attrbute in parameters should be modified as to the business process
136 -- requirements.
137 --
138 -- Access Status:
139 -- Internal Development Use Only.
140 --
141 -- {End Of Comments}
142 -- ----------------------------------------------------------------------------
143 Procedure del
144 (
145 p_position_id in number,
146 p_effective_start_date out nocopy date,
147 p_effective_end_date out nocopy date,
148 p_object_version_number in out nocopy number,
149 p_effective_date in date,
150 p_datetrack_mode in varchar2,
151 p_validate in boolean default false,
152 p_security_profile_id in number default hr_security.get_security_profile
153 );
154 --
155 end hr_psf_del;