1 Package pqh_rei_del AUTHID CURRENT_USER as
2 /* $Header: pqreirhi.pkh 120.0 2005/05/29 02:27:10 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------------< del >----------------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure is the record interface for the delete process
11 -- for the specified entity. The role of this process is to delete the
12 -- row from the HR schema. This process is the main backbone of the del
13 -- business process. The processing of this procedure is as follows:
14 -- 1) If the p_validate parameter has been set to true then a savepoint is
15 -- issued.
16 -- 2) The controlling validation process delete_validate is then executed
17 -- which will execute all private and public validation business rule
18 -- processes.
19 -- 3) The pre_delete process is then executed which enables any
20 -- logic to be processed before the delete dml process is executed.
21 -- 4) The delete_dml process will physical perform the delete dml for the
22 -- specified row.
23 -- 5) The post_delete process is then executed which enables any
24 -- logic to be processed after the delete dml process.
25 -- 6) If the p_validate parameter has been set to true an exception is raised
26 -- which is handled and processed by performing a rollback to the
27 -- savepoint which was issued at the beginning of the del process.
28 --
29 -- Prerequisites:
30 -- The main parameters to the business process have to be in the record
31 -- format.
32 --
33 -- In Parameters:
34 -- p_validate
35 -- Determines if the process is to be validated. Setting this
36 -- boolean value to true will invoke the process to be validated. The
37 -- default is false. The validation is controlled by a savepoint and
38 -- rollback mechanism. The savepoint is issued at the beginning of the
39 -- process and is rollbacked at the end of the process
40 -- when all the processing has been completed. The rollback is controlled
41 -- by raising and handling the exception hr_api.validate_enabled. We use
42 -- the exception because, by raising the exception with the business
43 -- process, we can exit successfully without having any of the 'OUT'
44 -- parameters being set.
45 --
46 -- Post Success:
47 -- The specified row will be fully validated and deleted for the specified
48 -- entity without being committed. If the p_validate parameter has been set
49 -- to true then all the work will be rolled back.
50 --
51 -- Post Failure:
52 -- If an error has occurred, an error message will be raised.
53 --
54 -- Developer Implementation Notes:
55 -- None.
56 --
57 -- Access Status:
58 -- Internal Development Use Only.
59 --
60 -- {End Of Comments}
61 -- ----------------------------------------------------------------------------
62 Procedure del
63 (p_rec in pqh_rei_shd.g_rec_type
64 ,p_validate in boolean default false
65 );
66 --
67 -- ----------------------------------------------------------------------------
68 -- |---------------------------------< del >----------------------------------|
69 -- ----------------------------------------------------------------------------
70 -- {Start Of Comments}
71 --
72 -- Description:
73 -- This procedure is the attribute interface for the delete
74 -- process for the specified entity and is the outermost layer. The role
75 -- of this process is to validate and delete the specified row from the
76 -- HR schema. The processing of this procedure is as follows:
77 -- 1) The attributes are converted into a local record structure by
78 -- explicitly coding the attribute parameters into the g_rec_type
79 -- datatype.
80 -- 2) After the conversion has taken place, the corresponding record del
81 -- interface process is executed.
82 --
83 -- Prerequisites:
84 --
85 -- In Parameters:
86 -- p_validate
87 -- Determines if the process is to be validated. Setting this
88 -- Boolean value to true will invoke the process to be validated.
89 -- The default is false.
90 -- Post Success:
91 -- The specified row will be fully validated and deleted for the specified
92 -- entity without being committed.
93 --
94 -- Post Failure:
95 -- If an error has occurred, an error message will be raised.
96 --
97 -- Developer Implementation Notes:
98 -- The attrbute in parameters should be modified as to the business process
99 -- requirements.
100 --
101 -- Access Status:
102 -- Internal Development Use Only.
103 --
104 -- {End Of Comments}
105 -- ----------------------------------------------------------------------------
106 Procedure del
107 (p_role_extra_info_id in number
108 ,p_object_version_number in number
109 ,p_validate in boolean default false
110 );
111 --
112 end pqh_rei_del;
[Home] [Help]