1 package hxc_tat_del as
2 /* $Header: hxtatrhi.pkh 120.0.12010000.2 2008/08/05 12:11:28 ubhat ship $ */
3 -- --------------------------------------------------------------------------
4 -- |---------------------------------< del >--------------------------------|
5 -- --------------------------------------------------------------------------
6 -- {Start Of Comments}
7 --
8 -- Description:
9 -- This procedure is the record interface for the delete process
10 -- for the specified entity. The role of this process is to delete the
11 -- row from the HR schema. This process is the main backbone of the del
12 -- business process. The processing of this procedure is as follows:
13 -- 1) The controlling validation process delete_validate is then executed
14 -- which will execute all private and public validation business rule
15 -- processes.
16 -- 2) The pre_delete process is then executed which enables any
17 -- logic to be processed before the delete dml process is executed.
18 -- 3) The delete_dml process will physical perform the delete dml for the
19 -- specified row.
20 -- 4) The post_delete process is then executed which enables any
21 -- logic to be processed after the delete dml process.
22 --
23 -- Prerequisites:
24 -- The main parameters to the business process have to be in the record
25 -- format.
26 --
27 -- In Parameters:
28 --
29 -- Post Success:
30 -- The specified row will be fully validated and deleted for the specified
31 -- entity without being committed.
32 --
33 -- Post Failure:
34 -- If an error has occurred, an error message will be raised.
35 --
36 -- Developer Implementation Notes:
37 -- None.
38 --
39 -- Access Status:
40 -- Internal Development Use Only.
41 --
42 -- {End Of Comments}
43 -- --------------------------------------------------------------------------
44 procedure del
45 (p_rec in hxc_tat_shd.g_rec_type
46 );
47
48 -- --------------------------------------------------------------------------
49 -- |---------------------------------< del >--------------------------------|
50 -- --------------------------------------------------------------------------
51 -- {Start Of Comments}
52 --
53 -- Description:
54 -- This procedure is the attribute interface for the delete
55 -- process for the specified entity and is the outermost layer. The role
56 -- of this process is to validate and delete the specified row from the
57 -- HR schema. The processing of this procedure is as follows:
58 -- 1) The attributes are converted into a local record structure by
59 -- explicitly coding the attribute parameters into the g_rec_type
60 -- datatype.
61 -- 2) After the conversion has taken place, the corresponding record del
62 -- interface process is executed.
63 --
64 -- Prerequisites:
65 --
66 -- In Parameters:
67 --
68 -- Post Success:
69 -- The specified row will be fully validated and deleted for the specified
70 -- entity without being committed.
71 --
72 -- Post Failure:
73 -- If an error has occurred, an error message will be raised.
74 --
75 -- Developer Implementation Notes:
76 -- The attrbute in parameters should be modified as to the business process
77 -- requirements.
78 --
79 -- Access Status:
80 -- Internal Development Use Only.
81 --
82 -- {End Of Comments}
83 -- --------------------------------------------------------------------------
84 procedure del
85 (p_time_attribute_id in number
86 ,p_object_version_number in number
87 );
88
89 end hxc_tat_del;