PACKAGE: APPS.IEU_UWQ_MEDIA_TYPES_SEED_PKG

Source

1 PACKAGE IEU_UWQ_MEDIA_TYPES_SEED_PKG AS
2 /* $Header: IEUSEEDS.pls 120.1 2005/06/23 02:39:20 appldev ship $ */
3 
4 TYPE uwq_media_types_rec_type IS RECORD (
5                         media_type_id NUMBER(15),
6                         media_type_uuid VARCHAR2(38),
7                     simple_blending_order NUMBER,
8                     tel_reqd_flag VARCHAR2(1),
9                     svr_login_rule_id NUMBER,
10                     application_id NUMBER,
11                                 sh_category_type VARCHAR2(30),
12                                 image_file_name VARCHAR2(80),
13                                 classification_query_proc VARCHAR2(60),
14                     blended_flag VARCHAR2(1),
15                     blended_dir VARCHAR2(1),
16                         media_type_name VARCHAR2(1996),
17                         media_type_description VARCHAR2(1996),
18                      created_by NUMBER(15),
19                      creation_date DATE,
20                      last_updated_by NUMBER(15),
21                      last_update_date DATE,
22                      last_update_login NUMBER(15),
23                         owner VARCHAR2(15) );
24 
25 PROCEDURE Insert_Row (p_uwq_media_types_rec IN uwq_media_types_rec_type);
26 PROCEDURE Update_Row (p_uwq_media_types_rec IN uwq_media_types_rec_type);
27 
28 PROCEDURE Load_Row (
29                         p_media_type_id IN NUMBER,
30                         p_media_type_uuid IN VARCHAR2,
31                     p_simple_blending_order IN NUMBER,
32                     p_tel_reqd_flag IN VARCHAR2,
33                     p_svr_login_rule_id IN NUMBER,
34                     p_application_id IN NUMBER,
35                                 p_sh_category_type IN VARCHAR2,
36                                 p_image_file_name IN VARCHAR2,
37                                 p_classification_query_proc IN VARCHAR2,
38                     p_blended_flag IN VARCHAR2,
39                     p_blended_dir IN VARCHAR2,
40                              p_media_type_name IN VARCHAR2,
41                         p_media_type_description IN VARCHAR2,
42                         p_owner IN VARCHAR2);
43 
44 PROCEDURE translate_row (
45                         p_media_type_id IN NUMBER,
46                         p_media_type_name IN VARCHAR2,
47                         p_media_type_description IN VARCHAR2,
48                         p_owner IN VARCHAR2);
49 
50 PROCEDURE ADD_LANGUAGE;
51 
52 procedure LOCK_ROW (
53 X_MEDIA_TYPE_ID in NUMBER,
54 X_MEDIA_TYPE_UUID in VARCHAR2,
55 X_LANGUAGE in VARCHAR2,
56 X_CREATED_BY in NUMBER,
57 X_CREATION_DATE in DATE,
58 X_LAST_UPDATED_BY in NUMBER,
59 X_LAST_UPDATE_DATE in DATE,
60 X_MEDIA_TYPE_NAME in VARCHAR2,
61 X_SOURCE_LANG in VARCHAR2,
62 X_MEDIA_TYPE_DESCRIPTION in VARCHAR2,
63 X_OBJECT_VERSION_NUMBER in NUMBER
64 );
65 
66 procedure DELETE_ROW (
67 X_MEDIA_TYPE_ID in NUMBER
68 );
69 
70 PROCEDURE Load_Seed_Row (
71   p_upload_mode IN VARCHAR2,
72   p_media_type_id IN NUMBER,
73   p_media_type_uuid IN VARCHAR2,
74   p_simple_blending_order IN NUMBER,
75   p_tel_reqd_flag IN VARCHAR2,
76   p_svr_login_rule_id IN NUMBER,
77   p_application_id IN NUMBER,
78   p_sh_category_type IN VARCHAR2,
79   p_image_file_name IN VARCHAR2,
80   p_classification_query_proc IN VARCHAR2,
81   p_blended_flag IN VARCHAR2,
82   p_blended_dir IN VARCHAR2,
83   p_media_type_name IN VARCHAR2,
84   p_media_type_description IN VARCHAR2,
85   p_owner IN VARCHAR2
86 );
87 
88 
89 END IEU_UWQ_MEDIA_TYPES_SEED_PKG;