1 PACKAGE IBE_DSP_MSITE_SCT_ITEM_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVCMIS.pls 115.1 2002/12/13 10:56:00 schak ship $ */
3
4 -- HISTORY
5 -- 12/12/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.
6 -- **************************************************************************
7
8 PROCEDURE insert_row
9 (
10 p_mini_site_section_item_id IN NUMBER,
11 p_object_version_number IN NUMBER,
12 p_mini_site_id IN NUMBER,
13 p_section_item_id IN NUMBER,
14 p_start_date_active IN DATE,
15 p_end_date_active IN DATE,
16 p_creation_date IN DATE,
17 p_created_by IN NUMBER,
18 p_last_update_date IN DATE,
19 p_last_updated_by IN NUMBER,
20 p_last_update_login IN NUMBER,
21 x_rowid OUT NOCOPY VARCHAR2,
22 x_mini_site_section_item_id OUT NOCOPY NUMBER
23 );
24
25 PROCEDURE update_row
26 (
27 p_mini_site_section_item_id IN NUMBER,
28 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
29 p_start_date_active IN DATE,
30 p_end_date_active IN DATE,
31 p_last_update_date IN DATE,
32 p_last_updated_by IN NUMBER,
33 p_last_update_login IN NUMBER
34 );
35
36 PROCEDURE delete_row
37 (
38 p_mini_site_section_item_id IN NUMBER
39 );
40
41 PROCEDURE Create_MSite_Section_Item
42 (
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45 p_commit IN VARCHAR2 := FND_API.G_FALSE,
46 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47 p_mini_site_id IN NUMBER,
48 p_section_item_id IN NUMBER,
49 p_start_date_active IN DATE,
50 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
51 x_mini_site_section_item_id OUT NOCOPY NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE Update_MSite_Section_Item
58 (
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61 p_commit IN VARCHAR2 := FND_API.G_FALSE,
62 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63 p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
64 p_object_version_number IN NUMBER,
65 p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
66 p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
67 p_start_date_active IN DATE := FND_API.G_MISS_DATE,
68 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE Delete_MSite_Section_Item
75 (
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78 p_commit IN VARCHAR2 := FND_API.G_FALSE,
79 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80 p_call_from_trigger IN BOOLEAN := FALSE,
81 p_mini_site_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
82 p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
83 p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88
89 END IBE_DSP_MSITE_SCT_ITEM_PVT;