DBA Data[Home] [Help]

PACKAGE: APPS.PQP_GET_DATE_MODE

Source


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;