1 Package pay_retro_comp_usage_internal AUTHID CURRENT_USER as
2 /* $Header: pyrcubsi.pkh 115.0 2003/09/24 10:08 thabara noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------< populate_retro_comp_usages >----------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure populates retro component usages and their child element
11 -- span usages for the specified element type. Records will be created by
12 -- copying from the retro component usages defined for the corresponding
13 -- classification.
14 --
15 -- This procedure is intended to be called when a new element type is being
16 -- introduced.
17 --
18 -- Prerequisites:
19 -- The element type must exist on the specified effective date.
20 --
21 -- In Parameters:
22 -- Name Reqd Type Description
23 -- p_effective_date Yes Date Effective Date
24 -- p_element_type_id Yes Number Element Type ID
25 --
26 --
27 -- Post Success:
28 -- The procedure will set the following out parameters:
29 -- Name Type Description
30 --
31 --
32 -- Post Failure:
33 -- The procedure will not create a retro component usage and raises an error.
34 --
35 -- Access Status:
36 -- Internal Development Use Only.
37 --
38 -- {End Of Comments}
39 --
40 procedure populate_retro_comp_usages
41 (p_effective_date in date
42 ,p_element_type_id in number
43 );
44
45 -- ----------------------------------------------------------------------------
46 -- |---------------------< delete_child_retro_comp_usages >-------------------|
47 -- ----------------------------------------------------------------------------
48 -- {Start Of Comments}
49 --
50 -- Description:
51 -- This procedure deletes child retro component usages of an element type
52 -- and deletes dependent element span usages accordingly.
53 --
54 -- This procedure is intended to be called when an element type is being
55 -- deleted.
56 --
57 -- Prerequisites:
58 -- None.
59 --
60 -- In Parameters:
61 -- Name Reqd Type Description
62 -- p_effective_date Yes Date Effective Date
63 -- p_element_type_id Yes Number Element Type ID
64 --
65 --
66 -- Post Success:
67 -- The procedure will set the following out parameters:
68 -- Name Type Description
69 --
70 --
71 -- Post Failure:
72 -- The procedure will not delete records and raises an error.
73 --
74 -- Access Status:
75 -- Internal Development Use Only.
76 --
77 -- {End Of Comments}
78 --
79 procedure delete_child_retro_comp_usages
80 (p_effective_date in date
81 ,p_element_type_id in number
82 );
83
84
85 end pay_retro_comp_usage_internal;