PACKAGE: APPS.MSC_IMPORT_UTIL

Source

1 PACKAGE MSC_IMPORT_UTIL AUTHID CURRENT_USER AS
2 /* $Header: MSCIMPUS.pls 120.1.12010000.2 2010/03/23 13:50:57 skakani noship $ */
3 -- Modification for bug 1863615
4 	            PROCEDURE load_frm_stg_tbl (
5 				errbuf                  OUT NOCOPY VARCHAR2,
6                                 retcode                 OUT NOCOPY NUMBER,
7                                 req_id 		in 	number,
8 				stg_tbl		in	varchar2 Default 'MSC_ST_ITEM_ATTRIBUTES'
9 				);
10 		    function sim_set(p_plan_id number) return varchar2;
11 
12 		    procedure attach_simset_toplan(p_plan_id number, p_simset varchar2);
13 
14 		    procedure modify_imm_item_attr(p_plan_id number, p_attr_name varchar2,p_attr_val varchar2,p_item_id number,p_org_id number,p_inst_id number);
15 
16 		    procedure modify_plan_item_attr(p_plan_id number, p_attr_name varchar2,p_attr_val varchar2,p_item_id number,p_org_id number,p_sr_instance_id number);
17 
18 		    procedure get_sql(p_attr_name varchar2,p_sql out nocopy varchar2,p_lov_type out nocopy number);
19 
20 		    function get_real_attrname(p_attr_name varchar2) return varchar2;
21 
22 END MSC_IMPORT_UTIL;