24:
25: PROCEDURE update_row
26: (
27: p_mini_site_section_section_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_level_number IN NUMBER,
32: p_sort_order IN NUMBER,
47: PROCEDURE load_row
48: (
49: p_owner IN VARCHAR2,
50: p_mini_site_section_section_id IN NUMBER,
51: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
52: p_mini_site_id IN NUMBER,
53: p_parent_section_id IN NUMBER,
54: p_child_section_id IN NUMBER,
55: p_start_date_active IN DATE,
61:
62: PROCEDURE Create_MSite_Section_Section
63: (
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_mini_site_id IN NUMBER,
69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
62: PROCEDURE Create_MSite_Section_Section
63: (
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_mini_site_id IN NUMBER,
69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_child_section_id IN NUMBER,
63: (
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_mini_site_id IN NUMBER,
69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_child_section_id IN NUMBER,
71: p_start_date_active IN DATE,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_mini_site_id IN NUMBER,
69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_child_section_id IN NUMBER,
71: p_start_date_active IN DATE,
72: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
68: p_mini_site_id IN NUMBER,
69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_child_section_id IN NUMBER,
71: p_start_date_active IN DATE,
72: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_mini_site_section_section_id OUT NUMBER,
69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_child_section_id IN NUMBER,
71: p_start_date_active IN DATE,
72: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_mini_site_section_section_id OUT NUMBER,
77: x_return_status OUT VARCHAR2,
70: p_child_section_id IN NUMBER,
71: p_start_date_active IN DATE,
72: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_mini_site_section_section_id OUT NUMBER,
77: x_return_status OUT VARCHAR2,
78: x_msg_count OUT NUMBER,
71: p_start_date_active IN DATE,
72: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_mini_site_section_section_id OUT NUMBER,
77: x_return_status OUT VARCHAR2,
78: x_msg_count OUT NUMBER,
79: x_msg_data OUT VARCHAR2
81:
82: PROCEDURE Update_MSite_Section_Section
83: (
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
82: PROCEDURE Update_MSite_Section_Section
83: (
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
83: (
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
97: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
97: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: x_return_status OUT VARCHAR2,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
97: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: x_return_status OUT VARCHAR2,
99: x_msg_count OUT NUMBER,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
97: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: x_return_status OUT VARCHAR2,
99: x_msg_count OUT NUMBER,
100: x_msg_data OUT VARCHAR2
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
97: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: x_return_status OUT VARCHAR2,
99: x_msg_count OUT NUMBER,
100: x_msg_data OUT VARCHAR2
101: );
102:
103: PROCEDURE Delete_MSite_Section_Section
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
103: PROCEDURE Delete_MSite_Section_Section
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: x_return_status OUT VARCHAR2,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: x_return_status OUT VARCHAR2,
114: x_msg_count OUT NUMBER,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: x_return_status OUT VARCHAR2,
114: x_msg_count OUT NUMBER,
115: x_msg_data OUT VARCHAR2
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: x_return_status OUT VARCHAR2,
114: x_msg_count OUT NUMBER,
115: x_msg_data OUT VARCHAR2
116: );
117:
118: PROCEDURE Update_MSite_Section_Sections
119: (
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
125: p_object_version_numbers IN JTF_NUMBER_TABLE,
118: PROCEDURE Update_MSite_Section_Sections
119: (
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
125: p_object_version_numbers IN JTF_NUMBER_TABLE,
126: p_start_date_actives IN JTF_DATE_TABLE,
119: (
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
125: p_object_version_numbers IN JTF_NUMBER_TABLE,
126: p_start_date_actives IN JTF_DATE_TABLE,
127: p_end_date_actives IN JTF_DATE_TABLE,
133:
134: PROCEDURE Update_Delete_Sct_Scts
135: (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
141: p_object_version_numbers IN JTF_NUMBER_TABLE,
134: PROCEDURE Update_Delete_Sct_Scts
135: (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
141: p_object_version_numbers IN JTF_NUMBER_TABLE,
142: p_start_date_actives IN JTF_DATE_TABLE,
135: (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
141: p_object_version_numbers IN JTF_NUMBER_TABLE,
142: p_start_date_actives IN JTF_DATE_TABLE,
143: p_end_date_actives IN JTF_DATE_TABLE,