1 PACKAGE Ibe_Msite_Information_Mgr_Pvt AUTHID CURRENT_USER AS
2 /* $Header: IBEVMIMS.pls 115.3 2003/08/20 16:09:56 jshang ship $ */
3
4 -- HISTORY
5 -- 12/13/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.
6 -- *********************************************************************************
7
8 -- Cursors with data for mini-site
9 TYPE MSITE_CSR IS REF CURSOR;
10 TYPE MSITE_INFO_CSR IS REF CURSOR;
11
12 PROCEDURE Change_Msite_Info
13 (
14 p_api_version IN NUMBER,
15 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16 p_commit IN VARCHAR2 := FND_API.G_FALSE,
17 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18 p_operation_flags IN JTF_VARCHAR2_TABLE_100,
19 p_msite_information_ids IN JTF_NUMBER_TABLE,
20 p_object_version_numbers IN JTF_NUMBER_TABLE,
21 p_msite_ids IN JTF_NUMBER_TABLE,
22 p_msite_information_contexts IN JTF_VARCHAR2_TABLE_100,
23 p_msite_informations1 IN JTF_VARCHAR2_TABLE_300,
24 p_msite_informations2 IN JTF_VARCHAR2_TABLE_300,
25 p_msite_informations3 IN JTF_VARCHAR2_TABLE_300,
26 p_msite_informations4 IN JTF_VARCHAR2_TABLE_300,
27 p_msite_informations5 IN JTF_VARCHAR2_TABLE_300,
28 p_msite_informations6 IN JTF_VARCHAR2_TABLE_300,
29 p_msite_informations7 IN JTF_VARCHAR2_TABLE_300,
30 p_msite_informations8 IN JTF_VARCHAR2_TABLE_300,
31 p_msite_informations9 IN JTF_VARCHAR2_TABLE_300,
32 p_msite_informations10 IN JTF_VARCHAR2_TABLE_300,
33 p_msite_informations11 IN JTF_VARCHAR2_TABLE_300,
34 p_msite_informations12 IN JTF_VARCHAR2_TABLE_300,
35 p_msite_informations13 IN JTF_VARCHAR2_TABLE_300,
36 p_msite_informations14 IN JTF_VARCHAR2_TABLE_300,
37 p_msite_informations15 IN JTF_VARCHAR2_TABLE_300,
38 p_msite_informations16 IN JTF_VARCHAR2_TABLE_300,
39 p_msite_informations17 IN JTF_VARCHAR2_TABLE_300,
40 p_msite_informations18 IN JTF_VARCHAR2_TABLE_300,
41 p_msite_informations19 IN JTF_VARCHAR2_TABLE_300,
42 p_msite_informations20 IN JTF_VARCHAR2_TABLE_300,
43 p_attribute_categorys IN JTF_VARCHAR2_TABLE_100,
44 p_attributes1 IN JTF_VARCHAR2_TABLE_300,
45 p_attributes2 IN JTF_VARCHAR2_TABLE_300,
46 p_attributes3 IN JTF_VARCHAR2_TABLE_300,
47 p_attributes4 IN JTF_VARCHAR2_TABLE_300,
48 p_attributes5 IN JTF_VARCHAR2_TABLE_300,
49 p_attributes6 IN JTF_VARCHAR2_TABLE_300,
50 p_attributes7 IN JTF_VARCHAR2_TABLE_300,
51 p_attributes8 IN JTF_VARCHAR2_TABLE_300,
52 p_attributes9 IN JTF_VARCHAR2_TABLE_300,
53 p_attributes10 IN JTF_VARCHAR2_TABLE_300,
54 p_attributes11 IN JTF_VARCHAR2_TABLE_300,
55 p_attributes12 IN JTF_VARCHAR2_TABLE_300,
56 p_attributes13 IN JTF_VARCHAR2_TABLE_300,
57 p_attributes14 IN JTF_VARCHAR2_TABLE_300,
58 p_attributes15 IN JTF_VARCHAR2_TABLE_300,
59 x_msite_information_ids OUT NOCOPY JTF_NUMBER_TABLE,
60 x_msite_info_return_statuses OUT NOCOPY JTF_VARCHAR2_TABLE_100,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2
64 );
65
66 PROCEDURE Load_MsiteInformation
67 (
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70 p_commit IN VARCHAR2 := FND_API.G_FALSE,
71 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72 p_msite_id IN NUMBER,
73 p_msite_information_context IN VARCHAR2,
74 x_msite_csr OUT NOCOPY MSITE_CSR,
75 x_msite_information_csr OUT NOCOPY MSITE_INFO_CSR,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2
79 );
80
81 PROCEDURE duplicate_msite_info(
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84 p_commit IN VARCHAR2 := FND_API.G_FALSE,
85 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86 p_source_msite_id IN NUMBER,
87 p_target_msite_id IN NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93 END Ibe_Msite_Information_Mgr_Pvt;