[Home] [Help]
PACKAGE: APPS.PJI_SYSTEM_SETTINGS_PKG
Source
1 PACKAGE PJI_SYSTEM_SETTINGS_PKG AUTHID CURRENT_USER AS
2 /* $Header: PJISYSTS.pls 120.1.12020000.2 2012/07/18 10:57:33 admarath ship $ */
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_curr1_flag IN VARCHAR2, /* Added for Bug 8708651 */
15 p_global_curr2_flag IN VARCHAR2,
16 p_txn_curr_flag IN VARCHAR2, -- Added for bug 4167173
17 p_time_phase_flag IN VARCHAR2, /* Added for Bug 8708651 */
18 p_per_analysis_flag IN VARCHAR2, /* Added for Bug 8708651 */
19 p_up_process_flag IN VARCHAR2, /* Added for Bug 8708651 */
20 p_psi_ppr_flag IN VARCHAR2, /* Added for Bug 13889383 */
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2
24 ) ;
25
26 PROCEDURE update_row (
27 p_setting_id IN NUMBER,
28 p_pa_period_flag IN VARCHAR2,
29 p_gl_period_flag IN VARCHAR2,
30 p_planamt_alloc_method IN VARCHAR2,
31 p_prj_curr_flag IN VARCHAR2,
32 p_projfunc_curr_flag IN VARCHAR2,
33 p_curr_rep_pa_period IN VARCHAR2,
34 p_curr_rep_gl_period IN VARCHAR2,
35 p_curr_rep_ent_period IN VARCHAR2,
36 p_plan_amt_conv_date IN VARCHAR2,
37 p_global_curr1_flag IN VARCHAR2, /* Added for Bug 8708651 */
38 p_global_curr2_flag IN VARCHAR2,
39 p_txn_curr_flag IN VARCHAR2, -- Added for bug 4167173
40 p_time_phase_flag IN VARCHAR2, /* Added for Bug 8708651 */
41 p_per_analysis_flag IN VARCHAR2, /* Added for Bug 8708651 */
42 p_up_process_flag IN VARCHAR2, /* Added for Bug 8708651 */
43 p_psi_ppr_flag IN VARCHAR2, /* Added for Bug 13889383 */
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2
47 ) ;
48
49 PROCEDURE delete_row (
50 p_setting_id IN NUMBER,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2
54 ) ;
55
56 END; --end package pji_system_settings_pkg