1 Package hr_eap_del as
2 /* $Header: hreaprhi.pkh 120.0 2005/05/30 23:58 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< delete_sso_details >-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of Comments}
7 -- Description:
8 -- This procedure is called to delete the external application details in SSO
9 -- schema and if successful then delete from hr_ki_ext_applications
10 --
11 -- Prerequisites:
12 --
13 -- In Parameters:
14 -- p_ext_application_id IN ext_application_id stored in
15 -- hr_ki_ext_applications
16 --
17 -- Post Success:
18 -- External application is deleted from SSO schema and from
19 -- hr_ki_ext_applications.
20 --
21 -- Post Failure:
22 -- An application error is raised if in case of failure
23 --
24 -- Developer Implementation Notes:
25 -- None.
26 --
27 -- Access Status:
28 -- Internal Development Use Only.
29 --
30 -- {End of Comments}
31 -- ----------------------------------------------------------------------------
32
33 PROCEDURE delete_sso_details (
34 p_sso_id IN number
35 );
36
37 --
38 -- ----------------------------------------------------------------------------
39 -- |---------------------------------< del >----------------------------------|
40 -- ----------------------------------------------------------------------------
41 -- {Start Of Comments}
42 --
43 -- Description:
44 -- This procedure is the record interface for the delete process
45 -- for the specified entity. The role of this process is to delete the
46 -- row from the HR schema. This process is the main backbone of the del
47 -- business process. The processing of this procedure is as follows:
48 -- 1) The controlling validation process delete_validate is then executed
49 -- which will execute all private and public validation business rule
50 -- processes.
51 -- 2) The pre_delete process is then executed which enables any
52 -- logic to be processed before the delete dml process is executed.
53 -- 3) The delete_dml process will physical perform the delete dml for the
54 -- specified row.
55 -- 4) The post_delete process is then executed which enables any
56 -- logic to be processed after the delete dml process.
57 --
58 -- Prerequisites:
59 -- The main parameters to the business process have to be in the record
60 -- format.
61 --
62 -- In Parameters:
63 --
64 -- Post Success:
65 -- The specified row will be fully validated and deleted for the specified
66 -- entity without being committed.
67 --
68 -- Post Failure:
69 -- If an error has occurred, an error message will be raised.
70 --
71 -- Developer Implementation Notes:
72 -- None.
73 --
74 -- Access Status:
75 -- Internal Development Use Only.
76 --
77 -- {End Of Comments}
78 -- ----------------------------------------------------------------------------
79 Procedure del
80 (p_rec in hr_eap_shd.g_rec_type
81 );
82 --
83 -- ----------------------------------------------------------------------------
84 -- |---------------------------------< del >----------------------------------|
85 -- ----------------------------------------------------------------------------
86 -- {Start Of Comments}
87 --
88 -- Description:
89 -- This procedure is the attribute interface for the delete
90 -- process for the specified entity and is the outermost layer. The role
91 -- of this process is to validate and delete the specified row from the
92 -- HR schema. The processing of this procedure is as follows:
93 -- 1) The attributes are converted into a local record structure by
94 -- explicitly coding the attribute parameters into the g_rec_type
95 -- datatype.
96 -- 2) After the conversion has taken place, the corresponding record del
97 -- interface process is executed.
98 --
99 -- Prerequisites:
100 --
101 -- In Parameters:
102 --
103 -- Post Success:
104 -- The specified row will be fully validated and deleted for the specified
105 -- entity without being committed.
106 --
107 -- Post Failure:
108 -- If an error has occurred, an error message will be raised.
109 --
110 -- Developer Implementation Notes:
111 -- The attrbute in parameters should be modified as to the business process
112 -- requirements.
113 --
114 -- Access Status:
115 -- Internal Development Use Only.
116 --
117 -- {End Of Comments}
118 -- ----------------------------------------------------------------------------
119 Procedure del
120 (p_ext_application_id in number
121 );
122 --
123 end hr_eap_del;