206: l_count PLS_INTEGER := 0;
207: i PLS_INTEGER;
208: l_update_stmt VARCHAR2(4000);
209: l_error_messages ams_error_messages_t := ams_error_messages_t();
210: l_object_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
211: l_object_names ams_object_names_t := ams_object_names_t();
212: l_parent_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
213: BEGIN
214: IF(p_commit = FND_API.G_TRUE) THEN
208: l_update_stmt VARCHAR2(4000);
209: l_error_messages ams_error_messages_t := ams_error_messages_t();
210: l_object_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
211: l_object_names ams_object_names_t := ams_object_names_t();
212: l_parent_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
213: BEGIN
214: IF(p_commit = FND_API.G_TRUE) THEN
215: COMMIT; --commits the current row processed
216: END IF;