PACKAGE: APPS.IEU_WP_PARAM_PROPS_SEED_PKG

Source

1 PACKAGE IEU_WP_PARAM_PROPS_SEED_PKG AS
2 /* $Header: IEUWPROS.pls 120.2 2005/08/04 23:18:13 appldev ship $ */
3 
4  TYPE wp_param_props_rec_type IS RECORD (
5                     PARAM_PROPERTY_ID NUMBER(15),
6                     ACTION_PARAM_SET_ID     NUMBER,
7                     PARAM_ID          NUMBER,
8                     PROPERTY_ID       NUMBER,
9                     PROPERTY_VALUE    VARCHAR(4000),
10                     PROPERTY_VALUE_TL VARCHAR(4000),
11                     VALUE_OVERRIDE_FLAG   VARCHAR2(5),
12                     created_by NUMBER(15),
13                     creation_date DATE,
14                     last_updated_by NUMBER(15),
15                     last_update_date DATE,
16                     last_update_login NUMBER(15),
17                     not_valid_flag     VARCHAR(4000),
18                     owner VARCHAR2(15) );
19 
20 PROCEDURE Insert_Row (p_wp_param_props_rec IN wp_param_props_rec_type);
21 PROCEDURE Update_Row (p_wp_param_props_rec IN wp_param_props_rec_type);
22 
23 PROCEDURE translate_row (
24                 p_PARAM_PROPERTY_ID IN NUMBER,
25                 p_PROPERTY_VALUE_TL IN VARCHAR2,
26                 p_last_update_date IN VARCHAR2,
27                 p_owner IN VARCHAR2);
28 PROCEDURE Load_Row (
29                 p_PARAM_PROPERTY_ID IN NUMBER,
30                 p_ACTION_PARAM_SET_ID IN NUMBER,
31                 p_PARAM_ID IN NUMBER,
32                 p_PROPERTY_ID IN NUMBER,
33                 p_PROPERTY_VALUE IN VARCHAR2,
34                 p_VALUE_OVERRIDE_FLAG IN VARCHAR2,
35                 p_PROPERTY_VALUE_TL IN VARCHAR2,
36                 p_NOT_VALID_FLAG    IN VARCHAR2,
37                 p_last_update_date IN VARCHAR2,
38                 p_owner IN VARCHAR2);
39 
40 procedure DELETE_ROW (
41   X_PARAM_PROPERTY_ID in NUMBER
42 );
43 
44 procedure ADD_LANGUAGE;
45 
46 PROCEDURE Load_seed_Row (
47   p_upload_mode IN VARCHAR2,
48   p_PARAM_PROPERTY_ID IN NUMBER,
49   p_ACTION_PARAM_SET_ID IN NUMBER,
50   p_PARAM_ID IN NUMBER,
51   p_PROPERTY_ID IN NUMBER,
52   p_PROPERTY_VALUE IN VARCHAR2,
53   p_VALUE_OVERRIDE_FLAG IN VARCHAR2,
54   p_PROPERTY_VALUE_TL IN VARCHAR2,
55   p_NOT_VALID_FLAG    IN VARCHAR2,
56   p_last_update_date IN VARCHAR2,
57   p_owner IN VARCHAR2);
58 
59 END IEU_WP_PARAM_PROPS_SEED_PKG;