DBA Data[Home] [Help]

PACKAGE: APPS.IEU_WP_PARAM_DEFS_SEED_PKG

Source


1 PACKAGE IEU_WP_PARAM_DEFS_SEED_PKG AS
2 /* $Header: IEUWACPS.pls 120.1 2005/07/07 02:25:13 appldev ship $ */
3 
4  TYPE WP_PARAM_DEFS_rec_type IS RECORD (
5                 	PARAM_ID          NUMBER(15),
6                         PARAM_NAME        VARCHAR2(128),
7                         DATA_TYPE         VARCHAR2(64),
8 			PARAM_USER_LABEL  VARCHAR2(32),
9 			PARAM_DESCRIPTION VARCHAR2(500),
10       			created_by NUMBER(15),
11       			creation_date DATE,
12       			last_updated_by NUMBER(15),
13       			last_update_date DATE,
14       			last_update_login NUMBER(15),
15                 	owner VARCHAR2(15) );
16 
17 PROCEDURE Insert_Row (p_WP_PARAM_DEFS_rec IN WP_PARAM_DEFS_rec_type);
18 PROCEDURE Update_Row (p_WP_PARAM_DEFS_rec IN WP_PARAM_DEFS_rec_type);
19 
20 PROCEDURE translate_row (
21     			p_PARAM_ID IN NUMBER,
22 			p_param_user_label IN VARCHAR2,
23 			p_param_description IN VARCHAR2,
24                   p_last_update_date IN VARCHAR2,
25                 	p_owner IN VARCHAR2);
26 
27 PROCEDURE Load_Row (
28                     p_PARAM_ID          IN NUMBER,
29                     p_PARAM_NAME        IN VARCHAR2,
30                     p_DATA_TYPE         IN VARCHAR2,
31                     p_param_user_label  IN VARCHAR2,
32                     p_param_description IN VARCHAR2,
33                     p_last_update_date IN VARCHAR2,
34                     p_owner             IN VARCHAR2);
35 
36 procedure DELETE_ROW (
37   r_PARAM_ID in NUMBER
38 );
39 
40 procedure ADD_LANGUAGE;
41 
42 PROCEDURE Load_seed_Row (
43   p_upload_mode       IN VARCHAR2,
44   p_PARAM_ID          IN NUMBER,
45   p_PARAM_NAME        IN VARCHAR2,
46   p_DATA_TYPE         IN VARCHAR2,
47   p_param_user_label  IN VARCHAR2,
48   p_param_description IN VARCHAR2,
49   p_last_update_date IN VARCHAR2,
50   p_owner             IN VARCHAR2);
51 
52 
53 END IEU_WP_PARAM_DEFS_SEED_PKG;