1 PACKAGE EGO_UPLOAD_PUB AUTHID CURRENT_USER AS
2 /* $Header: EGOPUPLS.pls 120.2 2011/04/13 21:15:57 sreharih ship $ */
3
4 Procedure sync_catalog_group (
5 p_api_version IN NUMBER
6 ,p_commit IN VARCHAR2
7 ,p_catalog_group IN VARCHAR2
8 ,p_parent_catalog_group IN VARCHAR2
9 ,p_description IN VARCHAR2
10 ,p_template_name IN VARCHAR2
11 ,p_creation_allowed IN VARCHAR2
12 ,p_end_date IN DATE
13 ,p_owner IN VARCHAR2
14 ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15 ,x_catalog_group_id OUT NOCOPY NUMBER
16 ,x_return_status OUT NOCOPY VARCHAR2
17 ,x_msg_count OUT NOCOPY NUMBER
18 ,x_msg_data OUT NOCOPY VARCHAR2
19 );
20
21 PROCEDURE sync_cat_attr_grp_assoc (
22 p_api_version IN NUMBER
23 ,p_commit IN VARCHAR2
24 ,p_catalog_group_id IN NUMBER
25 ,p_catalog_group IN VARCHAR2
26 ,p_data_level IN VARCHAR2
27 ,p_attr_group_name IN VARCHAR2
28 ,p_attr_group_type IN VARCHAR2
29 ,p_enabled_flag IN VARCHAR2
30 ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
31 ,x_association_id OUT NOCOPY NUMBER
32 ,x_return_status OUT NOCOPY VARCHAR2
33 ,x_msg_count OUT NOCOPY NUMBER
34 ,x_msg_data OUT NOCOPY VARCHAR2
35 );
36
37 PROCEDURE sync_cat_item_pages (
38 p_api_version IN NUMBER
39 ,p_commit IN VARCHAR2
40 ,p_catalog_group_id IN NUMBER
41 ,p_catalog_group IN VARCHAR2
42 ,p_data_level IN VARCHAR2
43 ,p_page_int_name IN VARCHAR2
44 ,p_name IN VARCHAR2
45 ,p_desc IN VARCHAR2
46 ,p_sequence IN NUMBER
47 ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
48 ,x_page_id OUT NOCOPY NUMBER
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 --
55 -- Bug 9949093. Meta data import is not creating proper
56 -- page entries for default pages. Added new param for
57 -- p_catalog_group_id.
58 -- sreharih. Wed Apr 13 13:54:12 PDT 2011
59 --
60
61 PROCEDURE sync_cat_item_page_entries (
62 p_api_version IN NUMBER
63 ,p_commit IN VARCHAR2
64 ,p_catalog_group IN VARCHAR2
65 ,p_catalog_group_id IN NUMBER
66 ,p_page_id IN NUMBER
67 ,p_page_int_name IN VARCHAR2
68 ,p_attr_group_name IN VARCHAR2
69 ,p_attr_group_type IN VARCHAR2
70 ,p_sequence IN NUMBER
71 ,p_association_id IN NUMBER
72 ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
73 ,x_return_status OUT NOCOPY VARCHAR2
74 ,x_msg_count OUT NOCOPY NUMBER
75 ,x_msg_data OUT NOCOPY VARCHAR2
76 );
77
78
79 --- exposing procedure for PIM2PIM sync bug 9586226
80 ---
81 PROCEDURE createBaseAttributePages (p_catalog_group_id IN NUMBER
82 ,x_return_status OUT NOCOPY VARCHAR2
83 );
84 END EGO_UPLOAD_PUB;