[Home] [Help]
PACKAGE: APPS.IEB_SVC_CAT_TEMPS_SEED_PKG
Source
1 PACKAGE ieb_svc_cat_temps_seed_pkg AUTHID CURRENT_USER AS
2 /* $Header: IEBSCTPS.pls 120.1 2005/09/16 00:00:51 appldev ship $ */
3 PROCEDURE insert_row(
4 x_wbsc_id NUMBER
5 , x_svcpln_svcpln_id NUMBER
6 , x_created_by NUMBER
7 , x_creation_date DATE
8 , x_last_update_date DATE
9 , x_last_updated_by NUMBER
10 , x_last_update_login NUMBER
11 , x_media_type VARCHAR2
12 , x_depth NUMBER
13 , x_parent_id NUMBER
14 , x_original_name VARCHAR2
15 , x_active_y_n VARCHAR2
16 , x_source_table_name VARCHAR2
17 , x_src_tbl_key_column VARCHAR2
18 , x_src_tbl_value_column VARCHAR2
19 , x_src_tbl_value_translation_fl VARCHAR2
20 , x_src_tbl_where_clause VARCHAR2
21 , x_MEDIA_TYPE_ID NUMBER
22 , x_SERVICE_CATEGORY_NAME VARCHAR2
23 , x_DESCRIPTION VARCHAR2
24 , x_MEDIA_CATEGORY_LABEL VARCHAR2
25 );
26
27
28 PROCEDURE update_row(
29 x_wbsc_id NUMBER
30 , x_svcpln_svcpln_id NUMBER
31 , x_last_update_date DATE
32 , x_last_updated_by NUMBER
33 , x_last_update_login NUMBER
34 , x_media_type VARCHAR2
35 , x_depth NUMBER
36 , x_parent_id NUMBER
37 , x_original_name VARCHAR2
38 , x_active_y_n VARCHAR2
39 , x_source_table_name VARCHAR2
40 , x_src_tbl_key_column VARCHAR2
41 , x_src_tbl_value_column VARCHAR2
42 , x_src_tbl_value_translation_fl VARCHAR2
43 , x_src_tbl_where_clause VARCHAR2
44 , x_MEDIA_TYPE_ID NUMBER
45 , x_SERVICE_CATEGORY_NAME VARCHAR2
46 , x_DESCRIPTION VARCHAR2
47 , x_MEDIA_CATEGORY_LABEL VARCHAR2
48 );
49
50 PROCEDURE load_row (
51 p_wbsc_id IN NUMBER,
52 p_svcpln_svcpln_id IN NUMBER,
53 p_media_type IN VARCHAR2,
54 p_depth IN NUMBER,
55 p_parent_id IN NUMBER,
56 p_original_name IN VARCHAR2,
57 p_active_y_n IN VARCHAR2,
58 p_source_table_name IN VARCHAR2,
59 p_src_tbl_key_column IN VARCHAR2,
60 p_src_tbl_value_column IN VARCHAR2,
61 p_src_tbl_value_translation_fl IN VARCHAR2,
62 p_src_tbl_where_clause IN VARCHAR2,
63 p_MEDIA_TYPE_ID IN NUMBER,
64 p_SERVICE_CATEGORY_NAME IN VARCHAR2,
65 p_DESCRIPTION IN VARCHAR2,
66 p_MEDIA_CATEGORY_LABEL IN VARCHAR2,
67 p_OWNER IN VARCHAR2);
68
69 PROCEDURE load_seed_row (
70 p_wbsc_id IN NUMBER,
71 p_svcpln_svcpln_id IN NUMBER,
72 p_media_type IN VARCHAR2,
73 p_depth IN NUMBER,
74 p_parent_id IN NUMBER,
75 p_original_name IN VARCHAR2,
76 p_active_y_n IN VARCHAR2,
77 p_source_table_name IN VARCHAR2,
78 p_src_tbl_key_column IN VARCHAR2,
79 p_src_tbl_value_column IN VARCHAR2,
80 p_src_tbl_value_translation_fl IN VARCHAR2,
81 p_src_tbl_where_clause IN VARCHAR2,
82 p_MEDIA_TYPE_ID IN NUMBER,
83 p_SERVICE_CATEGORY_NAME IN VARCHAR2,
84 p_DESCRIPTION IN VARCHAR2,
85 p_MEDIA_CATEGORY_LABEL IN VARCHAR2,
86 p_OWNER IN VARCHAR2,
87 p_UPLOAD_MODE IN VARCHAR2);
88
89 PROCEDURE translate_row (
90 p_wbsc_id IN NUMBER,
91 p_SERVICE_CATEGORY_NAME IN VARCHAR2,
92 p_DESCRIPTION IN VARCHAR2,
93 p_MEDIA_CATEGORY_LABEL IN VARCHAR2,
94 p_OWNER IN VARCHAR2);
95
96 PROCEDURE ADD_LANGUAGE;
97
98
99 END ieb_svc_cat_temps_seed_pkg;