1 Package Body ghr_mre_custom_pkg as
2 /* $Header: ghmrecus.pkb 120.0 2010/07/21 10:48:33 utokachi noship $ */
3 --
4 -- -----------------------------------------------------------------------------
5 -- |-----------------------------< business_rules >-----------------------|
6 -- -----------------------------------------------------------------------------
7 -- {Start of Comments}
8 --
9 -- Description:
10 -- This procedure is provided for the customer to allow them to
11 -- add there own routines and business rules to determine at the MRE process.
12 -- It is called from the execute_mre procedure.
13 --
14 --
15 -- In Arguments:
16 -- p_mass_realignment_id -- MRE id associated with the current MRE process
17 -- p_action -- Action Type associated with the current action CREATE or UPDATE
18 -- p_show_vacant_pos -- No. of vacant positions
19
20 --
21 -- OUT Arguments:
22 --
23 -- Post Success:
24 -- Processing goes back to the execute_mre process.
25
26 --
27 -- Post Failure:
28 -- SQL failure:
29 -- Processing goes back to the execute_mre process:
30
31 -- Developer Implementation Notes:
32 -- Customer defined.
33 --
34 -- {End of Comments}
35 -- -----------------------------------------------------------------------------
36 -- ----------------------------------------------------------------------------
37 -- | Private Global Definitions |
38 -- ----------------------------------------------------------------------------
39 --
40 g_package varchar2(33) := 'ghr_mre_custom_pkg.'; -- Global package name
41 --
42 -- ----------------------------------------------------------------------------
43 -- |-------------------------------< business_rules >-------------------------|
44 -- ----------------------------------------------------------------------------
45 --
46 procedure business_rules( p_mass_realignment_id IN NUMBER,
47 p_action IN VARCHAR2,
48 p_show_vacant_pos IN VARCHAR2) IS
49 --
50 l_proc varchar2(72) := g_package||'business_rules';
51 --
52 Begin
53 hr_utility.set_location('Entering:'||l_proc, 5);
54 --
55 /*************** Add custom code here **************/
56
57 -- /**************** EXAMPLE *********************************
58 -- below you can add the custom code
59 -- NOTE: You need to set ALL out parameters
60 -- ***********************************************************/
61 --
62 --
63 hr_utility.set_location('Leaving:'||l_proc, 10);
64 end business_rules;
65 --
66 end ghr_mre_custom_pkg;
[Home] [Help]