[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