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