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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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
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: );