DBA Data[Home] [Help]

PACKAGE: APPS.PJI_SYSTEM_SETTINGS_PKG

Source


1 PACKAGE PJI_SYSTEM_SETTINGS_PKG AS
2 /* $Header: PJISYSTS.pls 120.0 2005/05/29 12:57:38 appldev noship $ */
3   PROCEDURE insert_row (
4         p_setting_id           IN NUMBER,
5         p_pa_period_flag       IN VARCHAR2,
6         p_gl_period_flag       IN VARCHAR2,
7         p_planamt_alloc_method IN VARCHAR2,
8         p_prj_curr_flag        IN VARCHAR2,
9         p_projfunc_curr_flag   IN VARCHAR2,
10         p_curr_rep_pa_period   IN VARCHAR2,
11         p_curr_rep_gl_period   IN VARCHAR2,
12         p_curr_rep_ent_period  IN VARCHAR2,
13         p_plan_amt_conv_date   IN VARCHAR2,
14         p_global_curr2_flag    IN VARCHAR2,
15         p_txn_curr_flag        IN VARCHAR2, -- Added for bug 4167173
16         x_return_status  OUT NOCOPY VARCHAR2,
17 	x_msg_count      OUT NOCOPY NUMBER,
18 	x_msg_data       OUT NOCOPY VARCHAR2
19   ) ;
20 
21   PROCEDURE update_row (
22         p_setting_id           IN NUMBER,
23         p_pa_period_flag       IN VARCHAR2,
24         p_gl_period_flag       IN VARCHAR2,
25         p_planamt_alloc_method IN VARCHAR2,
26         p_prj_curr_flag        IN VARCHAR2,
27         p_projfunc_curr_flag   IN VARCHAR2,
28         p_curr_rep_pa_period   IN VARCHAR2,
29         p_curr_rep_gl_period   IN VARCHAR2,
30         p_curr_rep_ent_period  IN VARCHAR2,
31         p_plan_amt_conv_date   IN VARCHAR2,
32         p_global_curr2_flag    IN VARCHAR2,
33         p_txn_curr_flag        IN VARCHAR2, -- Added for bug 4167173
34         x_return_status  OUT NOCOPY VARCHAR2,
35         x_msg_count      OUT NOCOPY NUMBER,
36         x_msg_data       OUT NOCOPY VARCHAR2
37   ) ;
38 
39   PROCEDURE delete_row (
40         p_setting_id   IN NUMBER,
41         x_return_status  OUT NOCOPY VARCHAR2,
42         x_msg_count      OUT NOCOPY NUMBER,
43         x_msg_data       OUT NOCOPY VARCHAR2
44   ) ;
45 
46 END; --end package pji_system_settings_pkg