1 Package pqp_get_date_mode AUTHID CURRENT_USER as
2 /* $Header: pqdtmode.pkh 115.0 2003/02/05 16:50:30 sshetty noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------< Update Date Mode >---------------|
6 -- ----------------------------------------------------------------------------
7
8 Procedure find_dt_upd_modes
9 (p_effective_date IN DATE
10 ,p_base_table_name IN VARCHAR2
11 ,p_base_key_column IN VARCHAR2
12 ,p_base_key_value IN NUMBER
13 ,p_correction OUT NOCOPY NUMBER
14 ,p_update OUT NOCOPY NUMBER
15 ,p_update_override OUT NOCOPY NUMBER
16 ,p_update_change_insert OUT NOCOPY NUMBER
17 );
18 --
19 --
20 -- ----------------------------------------------------------------------------
21 -- |------------------< Delete Date Mode >------------------|
22 -- ----------------------------------------------------------------------------
23
24
25 Procedure find_dt_del_modes
26 (p_effective_date IN DATE
27 ,p_base_table_name IN VARCHAR2
28 ,p_base_key_column IN VARCHAR2
29 ,p_base_key_value IN NUMBER
30 ,p_zap OUT NOCOPY NUMBER
31 ,p_delete OUT NOCOPY NUMBER
32 ,p_future_change OUT NOCOPY NUMBER
33 ,p_delete_next_change OUT NOCOPY NUMBER
34 );
35
36
37 end pqp_get_date_mode;