PACKAGE: APPS.OE_PARAMETERS_DEF_UTIL

Source

1 PACKAGE  Oe_Parameters_Def_Util AS
2 /* $Header: OEXUPADS.pls 120.2 2005/10/20 00:21:55 ppnair noship $ */
3 
4 -- Record for parameter definition
5 TYPE sys_param_def_rec_type IS RECORD
6   (Parameter_Code          VARCHAR2(80) --<R12.MOAC>
7   ,Name                    VARCHAR2(240)
8   ,Description             VARCHAR2(2000)
9   ,Creation_Date           DATE
10   ,Created_By              NUMBER(15)
11   ,Last_Update_Date        DATE
12   ,Last_Updated_By         NUMBER(15)
13   ,Last_Update_Login       NUMBER(15)
14   ,Category_Code           VARCHAR2(30)
15   ,Value_Set_Id            NUMBER
16   ,Open_Orders_Check_Flag  VARCHAR2(1)
17   ,Enabled_Flag            VARCHAR2(1)
18   ,Seeded_Flag             VARCHAR2(1));
19 
20 
21 PROCEDURE Insert_Row(p_sys_param_def_rec IN OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type);
22 
23 PROCEDURE Delete_Row(p_parameter_code IN VARCHAR2);
24 
25 PROCEDURE Update_Row(p_sys_param_def_rec IN OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type);
26 
27 PROCEDURE Lock_Row(p_parameter_code IN VARCHAR2);
28 
29 PROCEDURE Translate_Row(p_parameter_code IN VARCHAR2,
30                         p_name IN VARCHAR2,
31                         p_description IN VARCHAR2,
32                         p_updated_by  IN NUMBER,
33                         p_update_login  IN NUMBER,
34 			p_custom_mode in varchar2 default null);
35 
36 PROCEDURE Load_Row(p_parameter_code  IN VARCHAR2,
37                    p_name            IN VARCHAR2,
38                    p_description     IN VARCHAR2,
39                    p_updated_by      IN NUMBER,
40                    p_update_login    IN NUMBER,
41                    p_category_code   IN VARCHAR2,
42                    p_value_set       IN VARCHAR2,
43                    p_open_orders_check_flag  IN VARCHAR2,
44                    p_enabled_flag    IN VARCHAR2,
45                    p_seeded_flag     IN VARCHAR2,
46 		   p_custom_mode in varchar2 default null);
47 
48 PROCEDURE Add_Language;
49 
50 END Oe_Parameters_Def_Util;